Bewerken: PurchaseLine

Sectie: Kolommen

Reden:

## Kolommen

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