title: "ArticleWarehouse (table)" category: reference tags: [table, articlewarehouse, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ArticleWarehouse
Schema: dba
Aantal kolommen: 37
Zie ook de entity-pagina: ../entities/ArticleWarehouse
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ArtwArtId |
nvarchar(9) | Nee | — | — |
ArtwWhsId |
nvarchar(10) | Nee | — | — |
ArtwDescr |
nvarchar(200) | Ja | — | — |
ArtwContext |
bigint | Nee | ((0)) | — |
ArtwRecStatus |
int | Nee | ((0)) | — |
ArtwArtsArtId |
nvarchar(9) | Ja | — | — |
ArtwArtsSitId |
nvarchar(8) | Ja | — | — |
ArtwCompId |
nvarchar(6) | Nee | — | — |
ArtwDataProvider |
nvarchar(50) | Ja | — | — |
ArtwExported |
smallint | Nee | ((0)) | — |
ArtwExternalId |
nvarchar(50) | Ja | — | — |
ArtwExternalStatus |
nvarchar(50) | Ja | — | — |
ArtwExtra1 |
smallint | Nee | ((0)) | — |
ArtwExtra2 |
smallint | Nee | ((0)) | — |
ArtwExtra3 |
int | Nee | ((0)) | — |
ArtwExtra4 |
int | Nee | ((0)) | — |
ArtwExtra5 |
nvarchar(15) | Ja | — | — |
ArtwExtra6 |
nvarchar(15) | Ja | — | — |
ArtwExtra7 |
nvarchar(15) | Ja | — | — |
ArtwInPurch |
decimal(21,5) | Nee | ((0)) | — |
ArtwJobMat |
smallint | Nee | ((0)) | — |
ArtwMaximum |
decimal(21,2) | Nee | ((0)) | — |
ArtwPchlPrepQuantity |
decimal(21,2) | Nee | ((0)) | — |
ArtwPchrlPrepQuantity |
decimal(21,2) | Nee | ((0)) | — |
ArtwProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ArtwPurch |
smallint | Nee | ((1)) | — |
ArtwPurchLevel |
decimal(21,2) | Nee | ((0)) | — |
ArtwPurchQty |
decimal(21,2) | Nee | ((0)) | — |
ArtwRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ArtwRepQty |
decimal(21,2) | Nee | ((0)) | — |
ArtwResQty |
decimal(21,2) | Nee | ((0)) | — |
ArtwSitId |
nvarchar(8) | Ja | — | — |
ArtwStock |
decimal(21,2) | Nee | ((0)) | — |
ArtwTransferNextTime |
smallint | Nee | ((0)) | — |
ArtwWebShop |
smallint | Nee | ((0)) | — |
ArtwPurchasePrepQty |
decimal(21,2) | Nee | — | — |
ArtwStckStatCode |
nvarchar(2) | Nee | — | — |
Computed columnsbewerken
ArtwPurchasePrepQty—(CONVERT([decimal](21,2),[ArtwPchlPrepQuantity]+[ArtwPchrlPrepQuantity]))ArtwStckStatCode—(CONVERT([nvarchar](2),case when [ArtwStock]<[ArtwPurchLevel] then case when ((([ArtwStock]-[ArtwResQty])+[ArtwPurchQty])+[ArtwRepQty])<[ArtwPurchLevel] then 'B' else 'F' end else case when ((([ArtwStock]-[ArtwResQty])+[ArtwPurchQty])+[ArtwRepQty])<[ArtwPurchLevel] then 'E' else 'V' end end))
Trigger-gevulde kolommenbewerken
ArtwRecStatus← TRGU_UmmSettingsArtwArtsArtId← TRGI_ArticleWarehouse, TRGU_ArticleWarehouseArtwArtsSitId← TRGI_ArticleWarehouse, TRGU_ArticleWarehouseArtwPchlPrepQuantity← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtwPchrlPrepQuantity← TRSD_PURCHASEREQUESTLINE, TRSM_PURCHASEREQUESTLINEArtwPurchQty← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtwRepQty← TRSD_PURCHASELINE, TRSM_PURCHASELINE
Brondatabewerken
- DB-schema —
lookup_table_schema("ArticleWarehouse")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ArticleWarehouse")· ../entities/ArticleWarehouse Properties, contexts, statussen. Bron:Entities.xml.