Bewerken: PmjPurchaseRequestLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PmjprlPmwId` | nvarchar(5) | Nee | — | — |
| `PmjprlPmjId` | nvarchar(3) | Nee | — | — |
| `PmjprlLineId` | nvarchar(8) | Nee | — | — |
| `PmjprlDescr` | nvarchar(200) | Ja | — | — |
| `PmjprlContext` | bigint | Nee | ((0)) | — |
| `PmjprlRecStatus` | int | Nee | ((0)) | — |
| `PmjprlAccId` | nvarchar(11) | Ja | — | — |
| `PmjPrlArtId` | nvarchar(9) | Ja | — | — |
| `PmjprlArtVdrPurchCode` | nvarchar(60) | Ja | — | — |
| `PmjprlCalcDlvDateMethod` | smallint | Nee | ((0)) | — |
| `PmjprlCcrId` | nvarchar(9) | Ja | — | — |
| `PmjprlCharge` | smallint | Nee | ((0)) | — |
| `PmjprlCompId` | nvarchar(6) | Nee | — | — |
| `PmjprlCsttId` | nvarchar(9) | Ja | — | — |
| `PmjprlCurConvFactor` | smallint | Nee | ((0)) | — |
| `PmjprlCurId` | nvarchar(5) | Nee | — | — |
| `PmjprlCurRate` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlDepId` | nvarchar(11) | Ja | — | — |
| `PmjprlDiscount` | decimal(21,2) | Nee | ((0)) | — |
| `PmjprlDlvDaysBefStartJob` | smallint | Nee | ((0)) | — |
| `PmjprlEqmId` | nvarchar(24) | Ja | — | — |
| `PmjprlExported` | smallint | Nee | ((0)) | — |
| `PmjprlGrossPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlGrossTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlLeadTime` | int | Nee | ((0)) | — |
| `PmjprlPrfId` | nvarchar(50) | Ja | — | — |
| `PmjprlPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlPurchQty` | decimal(21,2) | Nee | ((0)) | — |
| `PmjprlQtyPurchUnt` | decimal(21,2) | Nee | ((0)) | — |
| `PmjprlRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PmjprlStdTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlStdTotPriceInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlStdVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlText` | nvarchar(max) | Ja | — | — |
| `PmjprlTotPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlTotPriceInclVat` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlUntDescr` | nvarchar(9) | Ja | — | — |
| `PmjprlVatId` | nvarchar(3) | Ja | — | — |
| `PmjprlVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `PmjprlVatPrice` | decimal(21,5) | Nee | ((0)) | — |
| `PmjprlVdrId` | nvarchar(6) | Ja | — | — |
| `PmjprlDataProvider` | nvarchar(50) | Ja | — | — |
| `PmjprlProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PmjprlTransferNextTime` | smallint | Nee | ((0)) | — |
| `PmjprlExternalId` | nvarchar(50) | Ja | — | — |
| `PmjprlExternalStatus` | nvarchar(50) | Ja | — | — |