Bewerken: JobInsp

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `JobiJobId` | nvarchar(12) | Nee | — | — |
| `JobiLineId` | nvarchar(9) | Nee | — | — |
| `JobiContext` | bigint | Nee | ((1)) | — |
| `JobiRecStatus` | int | Nee | ((0)) | — |
| `JobiCompId` | nvarchar(6) | Nee | — | — |
| `JobiDataProvider` | nvarchar(50) | Ja | — | — |
| `JobiDone` | smallint | Nee | ((0)) | — |
| `JobiEqmId` | nvarchar(24) | Ja | — | — |
| `JobiEqmState` | decimal(21,2) | Nee | ((0)) | — |
| `JobiExported` | smallint | Nee | ((0)) | — |
| `JobiExternalId` | nvarchar(50) | Ja | — | — |
| `JobiExternalStatus` | nvarchar(50) | Ja | — | — |
| `JobiExtra1` | smallint | Nee | ((0)) | — |
| `JobiExtra10` | nvarchar(5) | Ja | — | — |
| `JobiExtra2` | smallint | Nee | ((0)) | — |
| `JobiExtra3` | int | Nee | ((0)) | — |
| `JobiExtra4` | int | Nee | ((0)) | — |
| `JobiExtra5` | nvarchar(41) | Ja | — | — |
| `JobiExtra6` | nvarchar(5) | Ja | — | — |
| `JobiExtra7` | nvarchar(5) | Ja | — | — |
| `JobiExtra8` | nvarchar(5) | Ja | — | — |
| `JobiExtra9` | nvarchar(5) | Ja | — | — |
| `JobiGenJobId` | nvarchar(12) | Ja | — | — |
| `JobiIslId` | nvarchar(9) | Ja | — | — |
| `JobiIsplText` | nvarchar(max) | Ja | — | — |
| `JobiJobjplId` | nvarchar(6) | Ja | — | — |
| `JobiJpId` | nvarchar(11) | Ja | — | — |
| `JobiMsrId` | nvarchar(6) | Ja | — | — |
| `JobiNmbrOfCndtnFlawPrsnts` | smallint | Nee | ((0)) | — |
| `JobiNominalValue` | nvarchar(16) | Ja | — | — |
| `JobiNoState` | smallint | Nee | ((0)) | — |
| `JobiPoint` | smallint | Nee | ((0)) | — |
| `JobiPrfState` | decimal(21,2) | Nee | ((0)) | — |
| `JobiProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `JobiQualOk` | smallint | Nee | ((0)) | — |
| `JobiRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `JobiSafiId` | nvarchar(6) | Ja | — | — |
| `JobiText1` | nvarchar(max) | Ja | — | — |
| `JobiText2` | nvarchar(max) | Ja | — | — |
| `JobiTransferNextTime` | smallint | Nee | ((0)) | — |
| `JobiUnfindable` | smallint | Nee | ((0)) | — |
| `JobiValue` | nvarchar(11) | Ja | — | — |
| `JobiValue2` | decimal(21,2) | Nee | ((0)) | — |
| `JobiZeroState` | smallint | Nee | ((0)) | — |
| `JobiIsltId` | nvarchar(5) | Ja | — | — |
| `JobiQualityNotOk` | smallint | Nee | ((0)) | — |
| `JobiSkippedDate` | datetimeoffset(7) | Ja | — | — |
| `JobiSkippedEmpId` | nvarchar(9) | Ja | — | — |
| `JobiFinishedDate` | datetimeoffset(7) | Ja | — | — |
| `JobiFinishedEmpId` | nvarchar(9) | Ja | — | — |
| `JobiSrId` | nvarchar(4) | Ja | — | — |
| `JobiInspectionImageFile1` | nvarchar(max) | Ja | — | — |
| `JobiInspectionImageFile2` | nvarchar(max) | Ja | — | — |
| `JobiInspectionImageFile3` | nvarchar(max) | Ja | — | — |
| `JobiInspectionImageFile4` | nvarchar(max) | Ja | — | — |
| `JobiInstructionImageFile1` | nvarchar(max) | Ja | — | — |
| `JobiInstructionImageFile2` | nvarchar(max) | Ja | — | — |
| `JobiInstructionImageFile3` | nvarchar(max) | Ja | — | — |
| `JobiInstructionImageFile4` | nvarchar(max) | Ja | — | — |
| `JobiFollowUpJob` | nvarchar(12) | Ja | — | — |
| `JobiPmjPmwId` | nvarchar(5) | Ja | — | — |
| `JobiPmjId` | nvarchar(3) | Ja | — | — |
| `JobiPreviousJobId` | nvarchar(12) | Ja | — | — |
| `JobiPreviousLineId` | nvarchar(9) | Ja | — | — |
| `JobiSourceIdentifier` | nvarchar(36) | Ja | — | — |
| `JobiDescr` | nvarchar(85) | Ja | — | — |
| `JobiPointOriginalValue` | smallint | Nee | ((0)) | — |