title: "PmSchedWoDet (table)" category: reference tags: [table, pmschedwodet, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.PmSchedWoDet
Schema: dba
Aantal kolommen: 18
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PmswdPmsId |
nvarchar(5) | Nee | — | — |
PmswdLineId |
nvarchar(9) | Nee | — | — |
PmswdContext |
bigint | Nee | ((0)) | — |
PmswdRecStatus |
int | Nee | ((0)) | — |
PmswdCompId |
nvarchar(6) | Nee | — | — |
PmswdCREndDate |
datetimeoffset(7) | Ja | — | — |
PmswdCRStartDate |
datetimeoffset(7) | Ja | — | — |
PmswdDate |
date | Ja | — | — |
PmswdEqmId |
nvarchar(24) | Ja | — | — |
PmswdExported |
smallint | Nee | ((0)) | — |
PmswdExtra1 |
smallint | Nee | ((0)) | — |
PmswdHours |
decimal(21,2) | Nee | ((0)) | — |
PmswdOriginalDate |
date | Ja | — | — |
PmswdPmwWoId |
nvarchar(5) | Ja | — | — |
PmswdPrfId |
nvarchar(50) | Ja | — | — |
PmswdRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PmswdSelByStateNextExec |
smallint | Nee | ((0)) | — |
PmswdWeek |
int | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("PmSchedWoDet")Alle kolommen met types, triggers, computed. Bron:database-schema.json.