title: "PurchaseLine (table)" category: reference tags: [table, purchaseline, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.PurchaseLine
Schema: dba
Aantal kolommen: 89
Zie ook de entity-pagina: ../entities/PurchaseLine
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PchlPchId |
nvarchar(10) | Nee | — | — |
PchlLineId |
nvarchar(4) | Nee | — | — |
PchlDescr |
nvarchar(200) | Ja | — | — |
PchlContext |
bigint | Nee | ((0)) | — |
PchlRecStatus |
int | Nee | ((0)) | — |
PchlAccId |
nvarchar(11) | Ja | — | — |
PchlArtId |
nvarchar(9) | Ja | — | — |
PchlArtVdrPurchCode |
nvarchar(60) | Ja | — | — |
PchlBookCostOnSvc |
smallint | Nee | ((0)) | — |
PchlCalculateDlvDate |
smallint | Nee | ((0)) | — |
PchlCall |
nvarchar(2) | Ja | — | — |
PchlCcrId |
nvarchar(9) | Ja | — | — |
PchlCharge |
smallint | Nee | ((0)) | — |
PchlChargeRseId |
nvarchar(5) | Ja | — | — |
PchlCompId |
nvarchar(6) | Nee | — | — |
PchlConcept |
smallint | Nee | ((0)) | — |
PchlCsttId |
nvarchar(9) | Ja | — | — |
PchlCurId |
nvarchar(5) | Nee | — | — |
PchlCusId |
nvarchar(6) | Ja | — | — |
PchlDataProvider |
nvarchar(50) | Ja | — | — |
PchlDepId |
nvarchar(11) | Ja | — | — |
PchlDiscount |
decimal(21,2) | Nee | ((0)) | — |
PchlDlvDate |
date | Ja | — | — |
PchlEqmId |
nvarchar(24) | Ja | — | — |
PchlExported |
smallint | Nee | ((0)) | — |
PchlExternalId |
nvarchar(50) | Ja | — | — |
PchlExternalStatus |
nvarchar(50) | Ja | — | — |
PchlExtra1 |
smallint | Nee | ((0)) | — |
PchlExtra2 |
smallint | Nee | ((0)) | — |
PchlExtra3 |
int | Nee | ((0)) | — |
PchlExtra4 |
int | Nee | ((0)) | — |
PchlExtra5 |
nvarchar(100) | Ja | — | — |
PchlExtra6 |
nvarchar(15) | Ja | — | — |
PchlExtra7 |
nvarchar(15) | Ja | — | — |
PchlGrossPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlGrossTotPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlInpToRcvQty |
decimal(21,2) | Nee | ((0)) | — |
PchlInvId |
nvarchar(9) | Ja | — | — |
PchlInvlLineId |
nvarchar(4) | Ja | — | — |
PchlInvPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlInvQty |
decimal(21,2) | Nee | ((0)) | — |
PchlJobId |
nvarchar(12) | Ja | — | — |
PchlLeadTime |
int | Nee | ((0)) | — |
PchlPrfId |
nvarchar(50) | Ja | — | — |
PchlPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlPrjId |
nvarchar(6) | Ja | — | — |
PchlProviderMutDate |
datetimeoffset(7) | Ja | — | — |
PchlPurchQty |
decimal(21,2) | Nee | ((0)) | — |
PchlQtyPurchUnt |
decimal(21,2) | Nee | ((1)) | — |
PchlRcpId |
nvarchar(9) | Ja | — | — |
PchlRcplLineId |
nvarchar(4) | Ja | — | — |
PchlRcvQty |
decimal(21,2) | Nee | ((0)) | — |
PchlRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PchlRepair |
smallint | Nee | ((0)) | — |
PchlRetour |
decimal(21,2) | Nee | ((0)) | — |
PchlRetToRcvQty |
decimal(21,2) | Nee | ((0)) | — |
PchlSitId |
nvarchar(8) | Ja | — | — |
PchlSkcId |
nvarchar(9) | Ja | — | — |
PchlStdTotCrdInvPrInclVat |
decimal(21,5) | Nee | ((0)) | — |
PchlStdTotCredInvPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlStdTotCredInvQty |
decimal(21,2) | Nee | ((0)) | — |
PchlStdTotInvPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlStdTotInvPriceInclVat |
decimal(21,5) | Nee | ((0)) | — |
PchlStdTotPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlStdTotPriceInclVat |
decimal(21,5) | Nee | ((0)) | — |
PchlStdVatPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlStockArt |
smallint | Nee | ((0)) | — |
PchlSvcId |
nvarchar(9) | Ja | — | — |
PchlSvclLineId |
nvarchar(8) | Ja | — | — |
PchlText |
nvarchar(max) | Ja | — | — |
PchlTls |
nvarchar(2) | Ja | — | — |
PchlToRcvQty |
decimal(21,2) | Nee | ((0)) | — |
PchlTotPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlTotPriceInclVat |
decimal(21,5) | Nee | ((0)) | — |
PchlTransferNextTime |
smallint | Nee | ((0)) | — |
PchlUntDescr |
nvarchar(9) | Ja | — | — |
PchlVatId |
nvarchar(3) | Ja | — | — |
PchlVatPercentage |
decimal(21,2) | Nee | ((0)) | — |
PchlVatPrice |
decimal(21,5) | Nee | ((0)) | — |
PchlVdrId |
nvarchar(6) | Ja | — | — |
PchlWhsId |
nvarchar(10) | Ja | — | — |
PchlCalcArtPrepQuantity |
decimal(21,2) | Nee | — | — |
PchlCalcArtPurchQuantity |
decimal(21,2) | Nee | — | — |
PchlCalcArtRepQuantity |
decimal(21,2) | Nee | — | — |
PchlRemainingCommitExclVat |
decimal(21,5) | Nee | — | — |
PchlRemainingCommitInclVat |
decimal(21,5) | Nee | — | — |
PchlArtWhslArtId |
nvarchar(9) | Ja | — | — |
PchlArtWhslWhslWhsId |
nvarchar(10) | Ja | — | — |
PchlArtWhslWhslCode |
nvarchar(20) | Ja | — | — |
Computed columnsbewerken
PchlCalcArtPrepQuantity—(CONVERT([decimal](21,2),case when [PchlStockArt]=(1) AND ([PchlRecStatus]=(128) OR [PchlRecStatus]=(2)) then [pchlqtypurchunt]*[pchlpurchqty] else (0) end))PchlCalcArtPurchQuantity—(CONVERT([decimal](21,2),case when [PchlStockArt]=(1) AND [PchlRepair]=(0) AND ([PchlRecStatus]=(64) OR [PchlRecStatus]=(4)) then [pchlqtypurchunt]*[pchltorcvqty] else (0) end))PchlCalcArtRepQuantity—(CONVERT([decimal](21,2),case when [PchlStockArt]=(1) AND [PchlRepair]=(1) AND ([PchlRecStatus]=(64) OR [PchlRecStatus]=(4)) then [pchlqtypurchunt]*[pchltorcvqty] else (0) end))PchlRemainingCommitExclVat—(CONVERT([decimal](21,5),case when [PchlRecStatus]=(256) OR [PchlRecStatus]=(64) OR [PchlRecStatus]=(4) then (([PchlPurchQty]-[PchlInvQty])*[PchlStdTotPrice])/case when [PchlPurchQty]=(0) then (1) else [PchlPurchQty] end else (0) end))PchlRemainingCommitInclVat—(CONVERT([decimal](21,5),case when [PchlRecStatus]=(256) OR [PchlRecStatus]=(64) OR [PchlRecStatus]=(4) then (([PchlPurchQty]-[PchlInvQty])*([PchlStdTotPrice]+([PchlStdTotPrice]/(100.0))*[PchlVatPercentage]))/case when [PchlPurchQty]=(0) then (1) else [PchlPurchQty] end else (0) end))
Trigger-gevulde kolommenbewerken
PchlRecStatus← TRGI_ArticleSite, TRGI_ArticleWarehouse, TRGU_UmmSettingsPchlInvPrice← TRSD_INVOICELINE, TRSM_INVOICELINEPchlSitId← TRGI_PurchaseLine, TRGU_Purchase, TRGU_PurchaseLine
Brondatabewerken
- DB-schema —
lookup_table_schema("PurchaseLine")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("PurchaseLine")· ../entities/PurchaseLine Properties, contexts, statussen. Bron:Entities.xml.