Bewerken: JobExt

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobeJobId` | nvarchar(12) | Nee | — | — |
| `JobeLineId` | nvarchar(9) | Nee | — | — |
| `JobeDescr` | nvarchar(200) | Ja | — | — |
| `JobeContext` | bigint | Nee | ((0)) | — |
| `JobeRecStatus` | int | Nee | ((0)) | — |
| `JobeBookDate` | date | Ja | — | — |
| `JobeCcrId` | nvarchar(9) | Ja | — | — |
| `JobeCompId` | nvarchar(6) | Nee | — | — |
| `JobeCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobeCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobeCsttId` | nvarchar(9) | Ja | — | — |
| `JobeCusId` | nvarchar(6) | Ja | — | — |
| `JobeDataProvider` | nvarchar(50) | Ja | — | — |
| `JobeDepId` | nvarchar(11) | Ja | — | — |
| `JobeEqmId` | nvarchar(24) | Ja | — | — |
| `JobeExported` | smallint | Nee | ((0)) | — |
| `JobeExt` | nvarchar(5) | Ja | — | — |
| `JobeExternalId` | nvarchar(50) | Ja | — | — |
| `JobeExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobeExtra1` | smallint | Nee | ((0)) | — |
| `JobeExtra2` | decimal(21,0) | Nee | ((0)) | — |
| `JobeExtra3` | nvarchar(5) | Ja | — | — |
| `JobeInvCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobeInvoId` | nvarchar(9) | Ja | — | — |
| `JobeInvolLineId` | nvarchar(8) | Ja | — | — |
| `JobeInvQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobeJobjplId` | nvarchar(6) | Ja | — | — |
| `JobeJpId` | nvarchar(11) | Ja | — | — |
| `JobeOrgRecStatus` | int | Nee | ((0)) | — |
| `JobePchStatus` | int | Nee | ((0)) | — |
| `JobePrfId` | nvarchar(50) | Ja | — | — |
| `JobePrjId` | nvarchar(6) | Ja | — | — |
| `JobeProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobeQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobeQtyCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobeRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobeSkcId` | nvarchar(9) | Ja | — | — |
| `JobeTariff` | decimal(21,5) | Nee | ((0)) | — |
| `JobeTariffCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobeTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobeUnit` | nvarchar(5) | Ja | — | — |
| `JobeVatId` | nvarchar(3) | Ja | — | — |
| `JobeVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `JobeVdrId` | nvarchar(6) | Ja | — | — |
| `JobeWeek` | int | Nee | ((0)) | — |