Bewerken: InspectionLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `IslId` | nvarchar(9) | Nee | — | — |
| `IslDescr` | nvarchar(200) | Ja | — | — |
| `IslContext` | bigint | Nee | ((0)) | — |
| `IslRecStatus` | int | Nee | ((0)) | — |
| `IslArtId` | nvarchar(9) | Ja | — | — |
| `IslCompId` | nvarchar(6) | Nee | — | — |
| `IslDataProvider` | nvarchar(50) | Ja | — | — |
| `IslDynamic` | smallint | Nee | ((0)) | — |
| `IslEqmId` | nvarchar(24) | Ja | — | — |
| `IslEqmmspEqmId` | nvarchar(24) | Ja | — | — |
| `IslEqmmspMspId` | nvarchar(70) | Ja | — | — |
| `IslExecuteOnWorkDaysOnly` | smallint | Nee | ((1)) | — |
| `IslExported` | smallint | Nee | ((0)) | — |
| `IslExternalId` | nvarchar(50) | Ja | — | — |
| `IslExternalStatus` | nvarchar(50) | Ja | — | — |
| `IslFrqId` | nvarchar(3) | Ja | — | — |
| `IslFrqQty` | smallint | Nee | ((0)) | — |
| `IslImageFile` | nvarchar(max) | Ja | — | — |
| `IslLastDate` | date | Ja | — | — |
| `IslNextDate` | date | Ja | — | — |
| `IslOrder` | smallint | Nee | ((0)) | — |
| `IslOrderPmw` | smallint | Nee | ((0)) | — |
| `IslPlannedArtQty` | decimal(21,2) | Nee | ((0)) | — |
| `IslPmwId` | nvarchar(5) | Ja | — | — |
| `IslPrfId` | nvarchar(50) | Ja | — | — |
| `IslPrfmspMspId` | nvarchar(70) | Ja | — | — |
| `IslPrfmspPrfId` | nvarchar(50) | Ja | — | — |
| `IslProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `IslRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `IslSpcId` | nvarchar(40) | Ja | — | — |
| `IslTransferNextTime` | smallint | Nee | ((0)) | — |
| `IslTrashedAutomatically` | smallint | Nee | ((0)) | — |
| `IslInstruction` | nvarchar(max) | Ja | — | — |
| `IslInstructionImageFile2` | nvarchar(max) | Ja | — | — |
| `IslInstructionImageFile3` | nvarchar(max) | Ja | — | — |
| `IslInstructionImageFile4` | nvarchar(max) | Ja | — | — |