title: "Article (table)" category: reference tags: [table, article, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Article
Schema: dba
Aantal kolommen: 95
Zie ook de entity-pagina: ../entities/Article
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ArtId |
nvarchar(9) | Nee | — | — |
ArtDescr |
nvarchar(200) | Ja | — | — |
ArtContext |
bigint | Nee | ((1)) | — |
ArtRecStatus |
int | Nee | ((0)) | — |
ArtAbc |
nvarchar(2) | Ja | — | — |
ArtAgId |
nvarchar(9) | Ja | — | — |
ArtCategory |
nvarchar(2) | Ja | — | — |
ArtCompId |
nvarchar(6) | Nee | — | — |
ArtDataProvider |
nvarchar(50) | Ja | — | — |
ArtDateAppr |
datetimeoffset(7) | Ja | — | — |
ArtDeviateFromInvMethod |
smallint | Nee | ((0)) | — |
ArtEmpId |
nvarchar(9) | Ja | — | — |
ArtEqmQty |
int | Nee | ((0)) | — |
ArtExported |
smallint | Nee | ((0)) | — |
ArtExternalId |
nvarchar(50) | Ja | — | — |
ArtExternalStatus |
nvarchar(50) | Ja | — | — |
ArtExtra0 |
smallint | Nee | ((0)) | — |
ArtExtra1 |
smallint | Nee | ((0)) | — |
ArtExtra2 |
smallint | Nee | ((0)) | — |
ArtExtra3 |
int | Nee | ((0)) | — |
ArtExtra4 |
int | Nee | ((0)) | — |
ArtExtra5 |
nvarchar(5) | Ja | — | — |
ArtExtra6 |
nvarchar(5) | Ja | — | — |
ArtExtra7 |
nvarchar(5) | Ja | — | — |
ArtExtRseId |
nvarchar(5) | Ja | — | — |
ArtFulId |
nvarchar(5) | Ja | — | — |
ArtImageFile |
nvarchar(max) | Ja | — | — |
ArtIntRseId |
nvarchar(5) | Ja | — | — |
ArtInvmId |
nvarchar(5) | Ja | — | — |
ArtJobOut |
decimal(21,2) | Nee | ((0)) | — |
ArtLeadTime |
smallint | Nee | ((0)) | — |
ArtManufArtId |
nvarchar(16) | Ja | — | — |
ArtManufVdrId |
nvarchar(6) | Ja | — | — |
ArtMaximum |
decimal(21,2) | Nee | ((0)) | — |
ArtMinDysBtwnDlvrAndExpDate |
int | Nee | ((0)) | — |
ArtMinimum |
decimal(21,2) | Nee | ((0)) | — |
ArtMinPurchQty |
decimal(21,2) | Nee | ((0)) | — |
ArtMinPurchUnt |
decimal(21,2) | Nee | ((0)) | — |
ArtMspCode |
nvarchar(70) | Ja | — | — |
ArtMutDate |
datetimeoffset(7) | Ja | — | — |
ArtOutDate |
date | Ja | — | — |
ArtPchlPrepQuantity |
decimal(21,2) | Nee | ((0)) | — |
ArtPchrlPrepQuantity |
decimal(21,2) | Nee | ((0)) | — |
ArtPrddId |
nvarchar(6) | Ja | — | — |
ArtPrdDossierAddedDate |
datetimeoffset(7) | Ja | — | — |
ArtPrdDossierAddedEmpId |
nvarchar(9) | Ja | — | — |
ArtPrdDossierOutboundDate |
datetimeoffset(7) | Ja | — | — |
ArtPrdDossierOutboundEmpId |
nvarchar(9) | Ja | — | — |
ArtPrddOutboundId |
nvarchar(6) | Ja | — | — |
ArtProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ArtPurch |
smallint | Nee | ((1)) | — |
ArtPurchLevel |
decimal(21,2) | Nee | ((0)) | — |
ArtPurchPrDate |
date | Ja | — | — |
ArtPurchPrice |
decimal(21,5) | Nee | ((0)) | — |
ArtPurchQty |
decimal(21,2) | Nee | ((0)) | — |
ArtPurchText |
nvarchar(max) | Ja | — | — |
ArtRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ArtRegisterStock |
smallint | Nee | ((1)) | — |
ArtRepQty |
decimal(21,2) | Nee | ((0)) | — |
ArtResoId |
nvarchar(11) | Ja | — | — |
ArtResQty |
decimal(21,2) | Nee | ((0)) | — |
ArtRseId |
nvarchar(5) | Ja | — | — |
ArtServOutBY |
decimal(21,2) | Nee | ((0)) | — |
ArtServOutUnt |
nvarchar(9) | Ja | — | — |
ArtShowInWebShop |
smallint | Nee | ((0)) | — |
ArtSitId |
nvarchar(8) | Ja | — | — |
ArtStock |
decimal(21,2) | Nee | ((0)) | — |
ArtStockMut |
nvarchar(2) | Ja | — | — |
ArtText |
nvarchar(max) | Ja | — | — |
ArtTransferNextTime |
smallint | Nee | ((0)) | — |
ArtTypeNr |
nvarchar(40) | Ja | — | — |
ArtUnitDescr |
nvarchar(200) | Ja | — | — |
ArtUseOwnInventoryMethod |
smallint | Nee | ((0)) | — |
ArtVatId |
nvarchar(3) | Ja | — | — |
ArtVdrId |
nvarchar(6) | Ja | — | — |
ArtVdrPerSite |
smallint | Nee | ((0)) | — |
ArtWarrentPeriod |
int | Nee | ((0)) | — |
ArtWarrentStartDate |
datetimeoffset(7) | Ja | — | — |
ArtWhsId |
nvarchar(10) | Ja | — | — |
ArtWhsOut |
decimal(21,2) | Nee | ((0)) | — |
ArtPurchasePrepQty |
decimal(21,2) | Nee | — | — |
ArtStckStatCode |
nvarchar(2) | Nee | — | — |
ArtFileExtension |
nvarchar(5) | Nee | — | — |
ARTPURCHTEXT_FT |
varbinary(max) | Ja | — | — |
ARTTEXT_FT |
varbinary(max) | Ja | — | — |
ArtAddToBillOfMaterials |
smallint | Nee | ((0)) | — |
ArtReplacedByArtId |
nvarchar(9) | Ja | — | — |
ArtReplacedByDate |
datetimeoffset(7) | Ja | — | — |
ArtReplacedByRemarkText |
nvarchar(200) | Ja | — | — |
ArtReplacedByEmpId |
nvarchar(9) | Ja | — | — |
ArtAbcId |
nvarchar(9) | Ja | — | — |
ArtArtvArtId |
nvarchar(9) | Ja | — | — |
ArtArtvVdrId |
nvarchar(6) | Ja | — | — |
ArtOverwriteAbcCode |
smallint | Nee | ((0)) | — |
ArtAbcCodeIdGenerated |
nvarchar(9) | Ja | — | — |
Computed columnsbewerken
ArtPurchasePrepQty—(CONVERT([decimal](21,2),[ArtPchlPrepQuantity]+[ArtPchrlPrepQuantity]))ArtStckStatCode—(CONVERT([nvarchar](2),case when [ArtStock]<[ArtPurchLevel] then case when ((([ArtStock]-[ArtResQty])+[ArtPurchQty])+[ArtRepQty])<[ArtPurchLevel] then N'B' else N'F' end else case when ((([ArtStock]-[ArtResQty])+[ArtPurchQty])+[ArtRepQty])<[ArtPurchLevel] then N'E' else N'V' end end))ArtFileExtension—(N'.html')ARTPURCHTEXT_FT—(case when [ARTPURCHTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([ARTPURCHTEXT],(5))=N'<html' then [ARTPURCHTEXT] else N'<html lang="nl">'+[ARTPURCHTEXT] end) end)ARTTEXT_FT—(case when [ARTTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([ARTTEXT],(5))=N'<html' then [ARTTEXT] else N'<html lang="nl">'+[ARTTEXT] end) end)
Trigger-gevulde kolommenbewerken
ArtEqmQty← TRGI_EquipmentArtPchlPrepQuantity← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtPchrlPrepQuantity← TRSD_PURCHASEREQUESTLINE, TRSM_PURCHASEREQUESTLINEArtPurchQty← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtRepQty← TRSD_PURCHASELINE, TRSM_PURCHASELINEArtResoId← TRGU_ReservableObjectArtResQty← TRSD_ARTICLESITE, TRSM_ARTICLESITEArtSitId← TRGI_ReservableObject, TRGU_ReservableObjectArtStock← TRSD_ARTICLESITE, TRSM_ARTICLESITE
Brondatabewerken
- DB-schema —
lookup_table_schema("Article")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Article")· ../entities/Article Properties, contexts, statussen. Bron:Entities.xml.