Bewerken: ShiftLog

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ShlId` | nvarchar(6) | Nee | — | — |
| `ShlDescr` | nvarchar(200) | Ja | — | — |
| `ShlContext` | bigint | Nee | ((0)) | — |
| `ShlRecStatus` | int | Nee | ((0)) | — |
| `ShlCompId` | nvarchar(6) | Nee | — | — |
| `ShlCompletedWorkText` | nvarchar(max) | Ja | — | — |
| `ShlCrwId` | nvarchar(3) | Ja | — | — |
| `ShlEmpId` | nvarchar(9) | Ja | — | — |
| `ShlExported` | smallint | Nee | ((0)) | — |
| `ShlRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ShlShlbId` | nvarchar(6) | Ja | — | — |
| `ShlSitId` | nvarchar(8) | Ja | — | — |
| `ShlStartDate` | date | Ja | — | — |
| `ShlWpId` | nvarchar(9) | Ja | — | — |
| `ShlDataProvider` | nvarchar(50) | Ja | — | — |
| `ShlProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ShlTransferNextTime` | smallint | Nee | ((0)) | — |
| `ShlExternalId` | nvarchar(50) | Ja | — | — |
| `ShlExternalStatus` | nvarchar(50) | Ja | — | — |