Bewerken: PurchaseRequestLine

Sectie: Kolommen

Reden:

## Kolommen

| 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 | — | — |