Bewerken: InspPlanLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `IsplIspId` | nvarchar(11) | Nee | — | — |
| `IsplLineId` | nvarchar(9) | Nee | — | — |
| `IsplDescr` | nvarchar(200) | Ja | — | — |
| `IsplContext` | bigint | Nee | ((1)) | — |
| `IsplRecStatus` | int | Nee | ((0)) | — |
| `IsplArtId` | nvarchar(9) | Ja | — | — |
| `IsplDataProvider` | nvarchar(50) | Ja | — | — |
| `IsplDynamic` | smallint | Nee | ((0)) | — |
| `IsplExecuteOnWorkDaysOnly` | smallint | Nee | ((1)) | — |
| `IsplExplanationMandatory` | smallint | Nee | ((0)) | — |
| `IsplExplanationPossible` | smallint | Nee | ((0)) | — |
| `IsplExported` | smallint | Nee | ((0)) | — |
| `IsplExternalId` | nvarchar(50) | Ja | — | — |
| `IsplExternalStatus` | nvarchar(50) | Ja | — | — |
| `IsplExtra1` | smallint | Nee | ((0)) | — |
| `IsplExtra10` | nvarchar(5) | Ja | — | — |
| `IsplExtra2` | smallint | Nee | ((0)) | — |
| `IsplExtra3` | int | Nee | ((0)) | — |
| `IsplExtra4` | int | Nee | ((0)) | — |
| `IsplExtra5` | nvarchar(41) | Ja | — | — |
| `IsplExtra6` | nvarchar(5) | Ja | — | — |
| `IsplExtra7` | nvarchar(5) | Ja | — | — |
| `IsplExtra8` | nvarchar(5) | Ja | — | — |
| `IsplExtra9` | nvarchar(5) | Ja | — | — |
| `IsplFreeTextPossible` | smallint | Nee | ((0)) | — |
| `IsplFrqId` | nvarchar(3) | Ja | — | — |
| `IsplFrqQty` | smallint | Nee | ((0)) | — |
| `IsplMsrId` | nvarchar(6) | Ja | — | — |
| `IsplNominalValue` | nvarchar(16) | Ja | — | — |
| `IsplOrder` | smallint | Nee | ((0)) | — |
| `IsplPlannedArtQty` | decimal(21,2) | Nee | ((0)) | — |
| `IsplPoint` | smallint | Nee | ((0)) | — |
| `IsplProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `IsplRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `IsplRequiredCfmrId` | nvarchar(5) | Ja | — | — |
| `IsplSetsPermitHighRisk` | smallint | Nee | ((0)) | — |
| `IsplSetsPermitLotoApplic` | smallint | Nee | ((0)) | — |
| `IsplShowApplicable` | smallint | Nee | ((0)) | — |
| `IsplShowDone` | smallint | Nee | ((0)) | — |
| `IsplText` | nvarchar(max) | Ja | — | — |
| `IsplTransferNextTime` | smallint | Nee | ((0)) | — |
| `IsplQuestionToAnswerWithYes` | nvarchar(200) | Ja | — | — |
| `IsplQuestionToAnswerWithNo` | nvarchar(200) | Ja | — | — |