Bewerken: JobWeekLab

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobwlJobId` | nvarchar(12) | Nee | — | — |
| `JobwlWeek` | int | Nee | — | — |
| `JobwlLineId` | nvarchar(9) | Nee | — | — |
| `JobwlContext` | bigint | Nee | ((0)) | — |
| `JobwlRecStatus` | int | Nee | ((0)) | — |
| `JobwlApprovedDate` | datetimeoffset(7) | Ja | — | — |
| `JobwlBookDate` | date | Ja | — | — |
| `JobwlCcrId` | nvarchar(9) | Ja | — | — |
| `JobwlChargeTariff` | decimal(21,5) | Nee | ((0)) | — |
| `JobwlCompId` | nvarchar(6) | Nee | — | — |
| `JobwlCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobwlCrmId` | nvarchar(6) | Ja | — | — |
| `JobwlCsttId` | nvarchar(9) | Ja | — | — |
| `JobwlCusId` | nvarchar(6) | Ja | — | — |
| `JobwlDataProvider` | nvarchar(50) | Ja | — | — |
| `JobwlDayId` | nvarchar(3) | Ja | — | — |
| `JobwlDepId` | nvarchar(11) | Ja | — | — |
| `JobwlDiscount` | decimal(21,0) | Nee | — | — |
| `JobwlDiscountTariff` | decimal(21,5) | Nee | — | — |
| `JobwlEmpId` | nvarchar(9) | Ja | — | — |
| `JobwlEmpllEmpId` | nvarchar(9) | Ja | — | — |
| `JobwlEmpllLineId` | nvarchar(9) | Ja | — | — |
| `JobwlEmpllWeek` | int | Ja | — | — |
| `JobwlEmplpId` | nvarchar(10) | Ja | — | — |
| `JobwlEqmId` | nvarchar(24) | Ja | — | — |
| `JobwlExported` | smallint | Nee | ((0)) | — |
| `JobwlExternalId` | nvarchar(50) | Ja | — | — |
| `JobwlExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobwlExtra1` | smallint | Nee | ((0)) | — |
| `JobwlExtra2` | int | Nee | ((0)) | — |
| `JobwlExtra3` | nvarchar(5) | Ja | — | — |
| `JobwlHourId` | nvarchar(5) | Ja | — | — |
| `JobwlHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobwlHtcId` | nvarchar(5) | Ja | — | — |
| `JobwlInvCost` | decimal(21,5) | Nee | ((0)) | — |
| `JobwlInvHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobwlInvoId` | nvarchar(9) | Ja | — | — |
| `JobwlInvolLineId` | nvarchar(8) | Ja | — | — |
| `JobwlOrgRecStatus` | int | Nee | ((0)) | — |
| `JobwlPrfId` | nvarchar(50) | Ja | — | — |
| `JobwlPrjId` | nvarchar(6) | Ja | — | — |
| `JobwlProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobwlRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobwlRemarkText` | nvarchar(max) | Ja | — | — |
| `JobwlRemHours` | decimal(21,2) | Nee | ((0)) | — |
| `JobwlSkcId` | nvarchar(9) | Ja | — | — |
| `JobwlTariff` | decimal(21,5) | Nee | ((0)) | — |
| `JobwlTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobwlVatId` | nvarchar(3) | Ja | — | — |
| `JobwlVatPercentage` | decimal(21,2) | Nee | ((0)) | — |