title: "PurchaseRequestLine (table)" category: reference tags: [table, purchaserequestline, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.PurchaseRequestLine
Schema: dba
Aantal kolommen: 107
Zie ook de entity-pagina: ../entities/PurchaseRequestLine
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PchrlId |
nvarchar(8) | Nee | — | — |
PchrlDescr |
nvarchar(200) | Ja | — | — |
PchrlContext |
bigint | Nee | ((1)) | — |
PchrlRecStatus |
int | Nee | ((0)) | — |
PchrlAccId |
nvarchar(11) | Ja | — | — |
PchrlApprvDate |
datetimeoffset(7) | Ja | — | — |
PchrlApprvEmpId |
nvarchar(9) | Ja | — | — |
PchrlArtId |
nvarchar(9) | Ja | — | — |
PchrlArtVdrPurchCode |
nvarchar(60) | Ja | — | — |
PchrlBookCostOnSvc |
smallint | Nee | ((0)) | — |
PchrlBookDate |
date | Ja | — | — |
PchrlCalcDlvDateMethod |
smallint | Nee | ((0)) | — |
PchrlCalculateReqDlvDate |
smallint | Nee | ((0)) | — |
PchrlCcrId |
nvarchar(9) | Ja | — | — |
PchrlCharge |
smallint | Nee | ((0)) | — |
PchrlChargeRaisePerc |
decimal(21,2) | Nee | ((0)) | — |
PchrlChargeRseId |
nvarchar(5) | Ja | — | — |
PchrlClosedDate |
datetimeoffset(7) | Ja | — | — |
PchrlClosedEmpId |
nvarchar(9) | Ja | — | — |
PchrlCompId |
nvarchar(6) | Nee | — | — |
PchrlConcept |
smallint | Nee | ((0)) | — |
PchrlConceptDate |
datetimeoffset(7) | Ja | — | — |
PchrlConceptEmpId |
nvarchar(9) | Ja | — | — |
PchrlCreatDate |
datetimeoffset(7) | Ja | — | — |
PchrlCreatedForStop |
smallint | Nee | ((0)) | — |
PchrlCreatedFromAdvice |
smallint | Nee | ((0)) | — |
PchrlCreatEmpId |
nvarchar(9) | Ja | — | — |
PchrlCsttId |
nvarchar(9) | Ja | — | — |
PchrlCurConvFactor |
smallint | Nee | ((0)) | — |
PchrlCurId |
nvarchar(5) | Nee | — | — |
PchrlCurRate |
decimal(21,5) | Nee | ((0)) | — |
PchrlCusId |
nvarchar(6) | Ja | — | — |
PchrlDataProvider |
nvarchar(50) | Ja | — | — |
PchrlDeliveredDate |
datetimeoffset(7) | Ja | — | — |
PchrlDeliveredEmpId |
nvarchar(9) | Ja | — | — |
PchrlDeliveredQuantity |
decimal(21,2) | Nee | ((0)) | — |
PchrlDepId |
nvarchar(11) | Ja | — | — |
PchrlDiscount |
decimal(21,2) | Nee | ((0)) | — |
PchrlDlvDaysBefStartJob |
smallint | Nee | ((0)) | — |
PchrlEqmId |
nvarchar(24) | Ja | — | — |
PchrlExported |
smallint | Nee | ((0)) | — |
PchrlExternalId |
nvarchar(50) | Ja | — | — |
PchrlExternalStatus |
nvarchar(50) | Ja | — | — |
PchrlGrossPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlGrossTotPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlInvCost |
decimal(21,5) | Nee | ((0)) | — |
PchrlInvoId |
nvarchar(9) | Ja | — | — |
PchrlInvolLineId |
nvarchar(8) | Ja | — | — |
PchrlInvQty |
decimal(21,2) | Nee | ((0)) | — |
PchrlJobId |
nvarchar(12) | Ja | — | — |
PchrlJobjplId |
nvarchar(6) | Ja | — | — |
PchrlJobSelected |
smallint | Nee | ((0)) | — |
PchrlJpId |
nvarchar(11) | Ja | — | — |
PchrlLeadTime |
int | Nee | ((0)) | — |
PchrlOrgRecStatus |
int | Nee | ((0)) | — |
PchrlPadId |
nvarchar(9) | Ja | — | — |
PchrlPartDeliveredDate |
datetimeoffset(7) | Ja | — | — |
PchrlPartDeliveredEmpId |
nvarchar(9) | Ja | — | — |
PchrlPchId |
nvarchar(10) | Ja | — | — |
PchrlPchlId |
nvarchar(4) | Ja | — | — |
PchrlPchrId |
nvarchar(11) | Ja | — | — |
PchrlPickedQuantity |
decimal(21,2) | Nee | ((0)) | — |
PchrlPrePurchCreatedStatus |
int | Nee | ((0)) | — |
PchrlPrfId |
nvarchar(50) | Ja | — | — |
PchrlPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlPrjId |
nvarchar(6) | Ja | — | — |
PchrlProviderMutDate |
datetimeoffset(7) | Ja | — | — |
PchrlPurchase |
smallint | Nee | ((0)) | — |
PchrlPurchQty |
decimal(21,2) | Nee | ((0)) | — |
PchrlQtyPurchUnt |
decimal(21,2) | Nee | ((0)) | — |
PchrlRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PchrlRejectDate |
datetimeoffset(7) | Ja | — | — |
PchrlRejectEmpId |
nvarchar(9) | Ja | — | — |
PchrlRepair |
smallint | Nee | ((0)) | — |
PchrlRequestedDate |
datetimeoffset(7) | Ja | — | — |
PchrlRequestedDlvDate |
date | Ja | — | — |
PchrlRequestedEmpId |
nvarchar(9) | Ja | — | — |
PchrlRequestEmpId |
nvarchar(9) | Ja | — | — |
PchrlReservedDate |
datetimeoffset(7) | Ja | — | — |
PchrlReservedEmpId |
nvarchar(9) | Ja | — | — |
PchrlReservedQuantity |
decimal(21,2) | Nee | ((0)) | — |
PchrlRfqId |
nvarchar(5) | Ja | — | — |
PchrlSelected |
smallint | Nee | ((0)) | — |
PchrlSitId |
nvarchar(8) | Ja | — | — |
PchrlSkcId |
nvarchar(9) | Ja | — | — |
PchrlStdTotPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlStdTotPriceInclVat |
decimal(21,5) | Nee | ((0)) | — |
PchrlStdVatPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlStockArt |
smallint | Nee | ((0)) | — |
PchrlSvcId |
nvarchar(9) | Ja | — | — |
PchrlSvclLineId |
nvarchar(8) | Ja | — | — |
PchrlTender |
smallint | Nee | ((0)) | — |
PchrlTenderDate |
datetimeoffset(7) | Ja | — | — |
PchrlTenderEmpId |
nvarchar(9) | Ja | — | — |
PchrlTenderPchrId |
nvarchar(11) | Ja | — | — |
PchrlText |
nvarchar(max) | Ja | — | — |
PchrlToDeliverQuantity |
decimal(21,2) | Nee | ((0)) | — |
PchrlTotPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlTotPriceInclVat |
decimal(21,5) | Nee | ((0)) | — |
PchrlTransferNextTime |
smallint | Nee | ((0)) | — |
PchrlUntDescr |
nvarchar(9) | Ja | — | — |
PchrlVatId |
nvarchar(3) | Ja | — | — |
PchrlVatPercentage |
decimal(21,2) | Nee | ((0)) | — |
PchrlVatPrice |
decimal(21,5) | Nee | ((0)) | — |
PchrlVdrId |
nvarchar(6) | Ja | — | — |
PchrlWhsId |
nvarchar(10) | Ja | — | — |
PchrlCalcArtPrepQuantity |
decimal(21,2) | Nee | — | — |
Computed columnsbewerken
PchrlCalcArtPrepQuantity—(CONVERT([decimal](21,2),case when [PCHRLPCHRID] IS NULL AND [PchrlStockArt]=(1) AND [PchrlRecStatus]=(8) then [Pchrlqtypurchunt]*[Pchrlpurchqty] else (0) end))
Trigger-gevulde kolommenbewerken
PchrlRecStatus← TRGI_ArticleSite, TRGI_ArticleWarehouse, TRGU_UmmSettingsPchrlRequestedDlvDate← TRGU_Job
Brondatabewerken
- DB-schema —
lookup_table_schema("PurchaseRequestLine")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("PurchaseRequestLine")· ../entities/PurchaseRequestLine Properties, contexts, statussen. Bron:Entities.xml.