Bewerken: JobSchedulePart

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobspId` | nvarchar(9) | Nee | — | — |
| `JobspDescr` | nvarchar(200) | Ja | — | — |
| `JobspContext` | bigint | Nee | ((0)) | — |
| `JobspRecStatus` | int | Nee | ((0)) | — |
| `JobspCompId` | nvarchar(6) | Nee | — | — |
| `JobspDataProvider` | nvarchar(50) | Ja | — | — |
| `JobspEmpId` | nvarchar(9) | Ja | — | — |
| `JobspEndDate` | datetimeoffset(7) | Ja | — | — |
| `JobspExported` | smallint | Nee | ((0)) | — |
| `JobspExternalId` | nvarchar(50) | Ja | — | — |
| `JobspExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobspHoursCalc` | decimal(21,2) | Nee | ((0)) | — |
| `JobspJobId` | nvarchar(12) | Ja | — | — |
| `JobspJobrJobId` | nvarchar(12) | Ja | — | — |
| `JobspJobrLineId` | nvarchar(9) | Ja | — | — |
| `JobspPartOfJobspId` | nvarchar(9) | Ja | — | — |
| `JobspProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobspRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobspStartDate` | datetimeoffset(7) | Ja | — | — |
| `JobspTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobspVdrId` | nvarchar(6) | Ja | — | — |
| `JobspPlanSequence` | smallint | Nee | ((0)) | — |
| `JobspPlanDate` | date | Ja | — | — |
| `JobspRemark` | nvarchar(max) | Ja | — | — |