Bewerken: JobRes

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobrJobId` | nvarchar(12) | Nee | — | — |
| `JobrLineId` | nvarchar(9) | Nee | — | — |
| `JobrContext` | bigint | Nee | ((0)) | — |
| `JobrRecStatus` | int | Nee | ((0)) | — |
| `JobrBookDate` | date | Ja | — | — |
| `JobrCcrId` | nvarchar(9) | Ja | — | — |
| `JobrCompId` | nvarchar(6) | Nee | — | — |
| `JobrCostCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobrCrmId` | nvarchar(6) | Ja | — | — |
| `JobrCsttId` | nvarchar(9) | Ja | — | — |
| `JobrCusId` | nvarchar(6) | Ja | — | — |
| `JobrDataProvider` | nvarchar(50) | Ja | — | — |
| `JobrDepId` | nvarchar(11) | Ja | — | — |
| `JobrDiscount` | decimal(21,0) | Nee | — | — |
| `JobrDiscountTariff` | decimal(21,5) | Nee | — | — |
| `JobrEqmId` | nvarchar(24) | Ja | — | — |
| `JobrExported` | smallint | Nee | ((0)) | — |
| `JobrExternalId` | nvarchar(50) | Ja | — | — |
| `JobrExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobrExtra1` | smallint | Nee | ((0)) | — |
| `JobrExtra2` | int | Nee | ((0)) | — |
| `JobrExtra3` | nvarchar(5) | Ja | — | — |
| `JobrHoursCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobrInvCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobrInvHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobrInvoId` | nvarchar(9) | Ja | — | — |
| `JobrInvolLineId` | nvarchar(8) | Ja | — | — |
| `JobrJobjplId` | nvarchar(6) | Ja | — | — |
| `JobrJpId` | nvarchar(11) | Ja | — | — |
| `JobrNextWeek` | smallint | Nee | ((0)) | — |
| `JobrOrgRecStatus` | int | Nee | ((0)) | — |
| `JobrPrfId` | nvarchar(50) | Ja | — | — |
| `JobrPrjId` | nvarchar(6) | Ja | — | — |
| `JobrProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobrQtyCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobrRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobrSkcId` | nvarchar(9) | Ja | — | — |
| `JobrTariffCalc` | decimal(21,5) | Nee | ((0)) | — |
| `JobrTotalHoursPlanned` | decimal(21,2) | Nee | ((0)) | — |
| `JobrTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobrVatId` | nvarchar(3) | Ja | — | — |
| `JobrVatPercentage` | decimal(21,2) | Nee | ((0)) | — |
| `JobrWeek` | int | Nee | ((0)) | — |
| `JobrExceedsOriginalTimeEstimate` | smallint | Nee | — | — |
| `JobrHoursToPlan` | decimal(21,2) | Nee | — | — |