title: "InspectionPlan (table)" category: reference tags: [table, inspectionplan, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.InspectionPlan
Schema: dba
Aantal kolommen: 34
Zie ook de entity-pagina: ../entities/InspectionPlan
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
IspId |
nvarchar(11) | Nee | — | — |
IspDescr |
nvarchar(254) | Ja | — | — |
IspContext |
bigint | Nee | ((1)) | — |
IspRecStatus |
int | Nee | ((0)) | — |
IspApprovedDate |
datetimeoffset(7) | Ja | — | — |
IspApprovedEmpId |
nvarchar(9) | Ja | — | — |
IspCfmrId |
nvarchar(5) | Ja | — | — |
IspCreateDate |
datetimeoffset(7) | Ja | — | — |
IspCreateEmpId |
nvarchar(9) | Ja | — | — |
IspDataProvider |
nvarchar(50) | Ja | — | — |
IspEqmtId |
nvarchar(9) | Ja | — | — |
IspExported |
smallint | Nee | ((0)) | — |
IspExternalId |
nvarchar(50) | Ja | — | — |
IspExternalStatus |
nvarchar(50) | Ja | — | — |
IspExtra1 |
smallint | Nee | ((0)) | — |
IspExtra2 |
int | Nee | ((0)) | — |
IspExtra3 |
nvarchar(5) | Ja | — | — |
IspExtra4 |
nvarchar(5) | Ja | — | — |
IspJpId |
nvarchar(11) | Ja | — | — |
IspOpenDate |
datetimeoffset(7) | Ja | — | — |
IspOpenEmpId |
nvarchar(9) | Ja | — | — |
IspOrder |
smallint | Nee | ((0)) | — |
IspPrintInTwoColumns |
smallint | Nee | ((0)) | — |
IspPrintOnlyApplicable |
smallint | Nee | ((0)) | — |
IspProviderMutDate |
datetimeoffset(7) | Ja | — | — |
IspRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
IspTransferNextTime |
smallint | Nee | ((0)) | — |
IspUseAcceptanceChecklist |
smallint | Nee | ((0)) | — |
IspAcceptanceStatement |
nvarchar(max) | Ja | — | — |
IspConvertToJobPlan |
smallint | Nee | ((1)) | — |
IspNumberOfLinkedJobPlans |
int | Nee | ((0)) | — |
IspPermtId |
nvarchar(4) | Ja | — | — |
IspPrintSelectionListWhenNotApplicable |
smallint | Nee | ((1)) | — |
IspIsDefault |
smallint | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
IspNumberOfLinkedJobPlans← TRSD_JOBPLAN, TRSM_JOBPLAN
Brondatabewerken
- DB-schema —
lookup_table_schema("InspectionPlan")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("InspectionPlan")· ../entities/InspectionPlan Properties, contexts, statussen. Bron:Entities.xml.