title: "PmSchedule (table)" category: reference tags: [table, pmschedule, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.PmSchedule
Schema: dba
Aantal kolommen: 49
Zie ook de entity-pagina: ../entities/PmSchedule
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PmsId |
nvarchar(5) | Nee | — | — |
PmsDescr |
nvarchar(200) | Ja | — | — |
PmsContext |
bigint | Nee | ((1)) | — |
PmsRecStatus |
int | Nee | ((0)) | — |
PmsCompId |
nvarchar(6) | Nee | — | — |
PmsEndDate |
date | Ja | — | — |
PmsExported |
smallint | Nee | ((0)) | — |
PmsExtra1 |
smallint | Nee | ((0)) | — |
PmsExtra2 |
int | Nee | ((0)) | — |
PmsExtra3 |
int | Nee | ((0)) | — |
PmsExtra4 |
nvarchar(5) | Ja | — | — |
PmsExtra5 |
nvarchar(5) | Ja | — | — |
PmsFrqId |
nvarchar(3) | Ja | — | — |
PmsIncludeAutoPmWorkOrders |
smallint | Nee | ((0)) | — |
PmsPmsGrByPaId |
nvarchar(5) | Ja | — | — |
PmsPmwInSchemaSearchType |
smallint | Nee | ((0)) | — |
PmsRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PmsSearchOnlyDateNextMaint |
smallint | Nee | ((0)) | — |
PmsShowAssetsInStructure |
smallint | Nee | ((1)) | — |
PmsShowExpectedPM |
smallint | Nee | ((1)) | — |
PmsShowExtCalc |
smallint | Nee | ((1)) | — |
PmsShowFleetEquipment |
smallint | Nee | ((1)) | — |
PmsShowFleetObjects |
smallint | Nee | ((1)) | — |
PmsShowHoursCosts |
smallint | Nee | ((1)) | — |
PmsShowInfraBuildingPart |
smallint | Nee | ((1)) | — |
PmsShowInfraComplex |
smallint | Nee | ((1)) | — |
PmsShowInfraElement |
smallint | Nee | ((1)) | — |
PmsShowInfraObject |
smallint | Nee | ((1)) | — |
PmsShowInfraRoute |
smallint | Nee | ((1)) | — |
PmsShowInstallations |
smallint | Nee | ((1)) | — |
PmsShowInventories |
smallint | Nee | ((1)) | — |
PmsShowJobs |
smallint | Nee | ((1)) | — |
PmsShowJobsWithStatusOpen |
smallint | Nee | ((1)) | — |
PmsShowMatCalc |
smallint | Nee | ((1)) | — |
PmsShowOnlyAssetsWithJob |
smallint | Nee | ((0)) | — |
PmsShowOnlyJobsWithDowntimeRequired |
smallint | Nee | ((0)) | — |
PmsShowProcessFunctions |
smallint | Nee | ((1)) | — |
PmsShowPurchaseRequestCalc |
smallint | Nee | ((1)) | — |
PmsShowPurchCalc |
smallint | Nee | ((1)) | — |
PmsShowResCalc |
smallint | Nee | ((1)) | — |
PmsShowTlsCalc |
smallint | Nee | ((1)) | — |
PmsSitId |
nvarchar(8) | Ja | — | — |
PmsSkcId |
nvarchar(9) | Ja | — | — |
PmsStartDate |
date | Ja | — | — |
PmsTakeCourseRoute |
smallint | Nee | ((0)) | — |
PmsWeek |
int | Nee | ((0)) | — |
PmsWoAct |
int | Nee | ((0)) | — |
PmsWoFnd |
int | Nee | ((0)) | — |
PmsShowExchangeParts |
smallint | Nee | ((1)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("PmSchedule")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("PmSchedule")· ../entities/PmSchedule Properties, contexts, statussen. Bron:Entities.xml.