Bewerken: JobTls

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobtJobId` | nvarchar(12) | Nee | — | — |
| `JobtLineId` | nvarchar(9) | Nee | — | — |
| `JobtContext` | bigint | Nee | ((0)) | — |
| `JobtRecStatus` | int | Nee | ((0)) | — |
| `JobtBookDate` | date | Ja | — | — |
| `JobtCcrId` | nvarchar(9) | Ja | — | — |
| `JobtCompId` | nvarchar(6) | Nee | — | — |
| `JobtCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobtCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobtCsttId` | nvarchar(9) | Ja | — | — |
| `JobtCusId` | nvarchar(6) | Ja | — | — |
| `JobtDataProvider` | nvarchar(50) | Ja | — | — |
| `JobtDepId` | nvarchar(11) | Ja | — | — |
| `JobtEqmId` | nvarchar(24) | Ja | — | — |
| `JobtExported` | smallint | Nee | ((0)) | — |
| `JobtExternalId` | nvarchar(50) | Ja | — | — |
| `JobtExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobtExtra1` | smallint | Nee | ((0)) | — |
| `JobtExtra2` | decimal(21,0) | Nee | ((0)) | — |
| `JobtExtra3` | nvarchar(5) | Ja | — | — |
| `JobtHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobtHoursCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobtInvCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobtInvHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobtInvoId` | nvarchar(9) | Ja | — | — |
| `JobtInvolLineId` | nvarchar(8) | Ja | — | — |
| `JobtInvQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobtJobjplId` | nvarchar(6) | Ja | — | — |
| `JobtJpId` | nvarchar(11) | Ja | — | — |
| `JobtOrgRecStatus` | int | Nee | ((0)) | — |
| `JobtPrfId` | nvarchar(50) | Ja | — | — |
| `JobtPrjId` | nvarchar(6) | Ja | — | — |
| `JobtProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobtQty` | decimal(21,2) | Nee | ((0)) | — |
| `JobtQtyCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobtRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobtSkcId` | nvarchar(9) | Ja | — | — |
| `JobtTariff` | decimal(21,5) | Nee | ((0)) | — |
| `JobtTariffCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobtTlsId` | nvarchar(9) | Ja | — | — |
| `JobtTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobtVatId` | nvarchar(3) | Ja | — | — |
| `JobtVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `JobtWeek` | int | Nee | ((0)) | — |