title: "ArticleSite (table)" category: reference tags: [table, articlesite, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ArticleSite
Schema: dba
Aantal kolommen: 34
Zie ook de entity-pagina: ../entities/ArticleSite
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ArtsArtId |
nvarchar(9) | Nee | — | — |
ArtsSitId |
nvarchar(8) | Nee | — | — |
ArtsContext |
bigint | Nee | ((0)) | — |
ArtsRecStatus |
int | Nee | ((0)) | — |
ArtsCompId |
nvarchar(6) | Nee | — | — |
ArtsDataProvider |
nvarchar(50) | Ja | — | — |
ArtsExported |
smallint | Nee | ((0)) | — |
ArtsExternalId |
nvarchar(50) | Ja | — | — |
ArtsExternalStatus |
nvarchar(50) | Ja | — | — |
ArtsMaximum |
decimal(21,2) | Nee | ((0)) | — |
ArtsPchlPrepQuantity |
decimal(21,2) | Nee | ((0)) | — |
ArtsPchrlPrepQuantity |
decimal(21,2) | Nee | ((0)) | — |
ArtsProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ArtsPurch |
smallint | Nee | ((0)) | — |
ArtsPurchLevel |
decimal(21,2) | Nee | ((0)) | — |
ArtsPurchQty |
decimal(21,2) | Nee | ((0)) | — |
ArtsRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ArtsRepQty |
decimal(21,2) | Nee | ((0)) | — |
ArtsResQty |
decimal(21,2) | Nee | ((0)) | — |
ArtsStock |
decimal(21,2) | Nee | ((0)) | — |
ArtsTransferNextTime |
smallint | Nee | ((0)) | — |
ArtsPurchasePrepQty |
decimal(21,2) | Nee | — | — |
ArtsStckStatCode |
nvarchar(2) | Nee | — | — |
ArtsVdrId |
nvarchar(6) | Ja | — | — |
ArtsHasPreferredVendor |
smallint | Nee | ((0)) | — |
ArtsPurchPrice |
decimal(21,5) | Nee | ((0)) | — |
ArtsPurchPrDate |
date | Ja | — | — |
ArtsVatId |
nvarchar(3) | Ja | — | — |
ArtsRseId |
nvarchar(5) | Ja | — | — |
ArtsIntRseId |
nvarchar(5) | Ja | — | — |
ArtsExtRseId |
nvarchar(5) | Ja | — | — |
ArtsAbcId |
nvarchar(9) | Ja | — | — |
ArtsOverwriteAbcCode |
smallint | Nee | ((0)) | — |
ArtsAbcCodeIdGenerated |
nvarchar(9) | Ja | — | — |
Computed columnsbewerken
ArtsPurchasePrepQty—(CONVERT([decimal](21,2),[ArtsPchlPrepQuantity]+[ArtsPchrlPrepQuantity]))ArtsStckStatCode—(CONVERT([nvarchar](2),case when [ArtsStock]<[ArtsPurchLevel] then case when ((([ArtsStock]-[ArtsResQty])+[ArtsPurchQty])+[ArtsRepQty])<[ArtsPurchLevel] then N'B' else N'F' end else case when ((([ArtsStock]-[ArtsResQty])+[ArtsPurchQty])+[ArtsRepQty])<[ArtsPurchLevel] then N'E' else N'V' end end))
Trigger-gevulde kolommenbewerken
ArtsArtId← TRGI_ArticleWarehouse, TRGU_ArticleWarehouseArtsSitId← TRGI_ArticleWarehouse, TRGU_ArticleWarehouseArtsRecStatus← TRGU_ArticleArtsCompId← TRGI_ArticleWarehouse, TRGU_ArticleWarehouseArtsPchlPrepQuantity← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtsPchrlPrepQuantity← TRSD_PURCHASEREQUESTLINE, TRSM_PURCHASEREQUESTLINEArtsPurchQty← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtsRepQty← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtsStock← TRSD_ARTICLEWAREHOUSE, TRSM_ARTICLEWAREHOUSE
Brondatabewerken
- DB-schema —
lookup_table_schema("ArticleSite")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ArticleSite")· ../entities/ArticleSite Properties, contexts, statussen. Bron:Entities.xml.