Bewerken: JobMat

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobmJobId` | nvarchar(12) | Nee | — | — |
| `JobmLineId` | nvarchar(9) | Nee | — | — |
| `JobmContext` | bigint | Nee | ((0)) | — |
| `JobmRecStatus` | int | Nee | ((0)) | — |
| `JobmArtId` | nvarchar(9) | Ja | — | — |
| `JobmArtReserved` | smallint | Nee | ((0)) | — |
| `JobmBookDate` | date | Ja | — | — |
| `JobmCatArtId` | nvarchar(9) | Ja | — | — |
| `JobmCcrId` | nvarchar(9) | Ja | — | — |
| `JobmChargeRaisePerc` | decimal(21,2) | Nee | ((0)) | — |
| `JobmCompId` | nvarchar(6) | Nee | — | — |
| `JobmCostCalcDecimals` | smallint | Nee | ((0)) | — |
| `JobmCostDecimals` | smallint | Nee | ((0)) | — |
| `JobmCsttId` | nvarchar(9) | Ja | — | — |
| `JobmCusId` | nvarchar(6) | Ja | — | — |
| `JobmDataProvider` | nvarchar(50) | Ja | — | — |
| `JobmDepId` | nvarchar(11) | Ja | — | — |
| `JobmDiscount` | decimal(21,0) | Nee | — | — |
| `JobmDiscountTariff` | decimal(21,5) | Nee | — | — |
| `JobmDlvTime` | time(7) | Ja | — | — |
| `JobmEqmId` | nvarchar(24) | Ja | — | — |
| `JobmExported` | smallint | Nee | ((0)) | — |
| `JobmExternalId` | nvarchar(50) | Ja | — | — |
| `JobmExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobmExtra1` | smallint | Nee | ((0)) | — |
| `JobmExtra2` | int | Nee | ((0)) | — |
| `JobmExtra3` | nvarchar(5) | Ja | — | — |
| `JobmInvCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobmInvoId` | nvarchar(9) | Ja | — | — |
| `JobmInvolLineId` | nvarchar(8) | Ja | — | — |
| `JobmInvQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobmJobjplId` | nvarchar(6) | Ja | — | — |
| `JobmJpId` | nvarchar(11) | Ja | — | — |
| `JobmOrgRecStatus` | int | Nee | ((0)) | — |
| `JobmOrgResQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobmPlanQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobmPrfId` | nvarchar(50) | Ja | — | — |
| `JobmPrice` | decimal(21,5) | Nee | ((0)) | — |
| `JobmPriceCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobmPrjId` | nvarchar(6) | Ja | — | — |
| `JobmProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobmQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobmQtyIn` | decimal(21,2) | Nee | ((0)) | — |
| `JobmRaisePerc` | decimal(21,2) | Nee | ((0)) | — |
| `JobmRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobmResQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobmSkcId` | nvarchar(9) | Ja | — | — |
| `JobmTotalPriceDecimals` | smallint | Nee | ((0)) | — |
| `JobmTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobmVatId` | nvarchar(3) | Ja | — | — |
| `JobmVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `JobmWhsId` | nvarchar(10) | Ja | — | — |
| `JobmWhslCode` | nvarchar(20) | Ja | — | — |
| `JobmWhslWhsId` | nvarchar(10) | Ja | — | — |
| `JobmWhsoId` | nvarchar(9) | Ja | — | — |
| `JobmWhsolLineId` | nvarchar(9) | Ja | — | — |
| `JobmCost` | decimal(21,5) | Nee | — | — |
| `JobmCostCalc` | decimal(21,5) | Nee | — | — |
| `JobmTotalPrice` | decimal(21,5) | Nee | — | — |
| `JobmSitId` | nvarchar(8) | Ja | — | — |
| `JobmPickedQuantity` | decimal(21,2) | Nee | ((0)) | — |