title: "WorkOrder (table)" category: reference tags: [table, workorder, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.WorkOrder
Schema: dba
Aantal kolommen: 113
Zie ook de entity-pagina: ../entities/WorkOrder
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
WoId |
nvarchar(9) | Nee | — | — |
WoDescr |
nvarchar(200) | Ja | — | — |
WoContext |
bigint | Nee | ((1)) | — |
WoRecStatus |
int | Nee | ((0)) | — |
WoActiveDate |
datetimeoffset(7) | Ja | — | — |
WoActiveEmpId |
nvarchar(9) | Ja | — | — |
WoActiveTime |
int | Nee | ((0)) | — |
WoApprvDate |
datetimeoffset(7) | Ja | — | — |
WoApprvEmpId |
nvarchar(9) | Ja | — | — |
WoArtId |
nvarchar(9) | Ja | — | — |
WoAutoClose |
smallint | Nee | ((0)) | — |
WoBldId |
nvarchar(11) | Ja | — | — |
WoBudgetMutation |
decimal(21,5) | Nee | ((0)) | — |
WoBudgetOrg |
decimal(21,5) | Nee | ((0)) | — |
WoCcrId |
nvarchar(9) | Ja | — | — |
WoCloseDate |
datetimeoffset(7) | Ja | — | — |
WoCloseEmpId |
nvarchar(9) | Ja | — | — |
WoCompId |
nvarchar(6) | Nee | — | — |
WoComplDate |
datetimeoffset(7) | Ja | — | — |
WoComplEmpId |
nvarchar(9) | Ja | — | — |
WoComplTime |
int | Nee | ((0)) | — |
WoCurId |
nvarchar(5) | Nee | — | — |
WoDataProvider |
nvarchar(50) | Ja | — | — |
WoDepId |
nvarchar(11) | Ja | — | — |
WoDuration |
decimal(21,2) | Nee | ((0)) | — |
WoDurationCalc |
decimal(21,2) | Nee | ((0)) | — |
WoEmpId |
nvarchar(9) | Ja | — | — |
WoEndDate |
datetimeoffset(7) | Ja | — | — |
WoEndEmpId |
nvarchar(9) | Ja | — | — |
WoEqmId |
nvarchar(24) | Ja | — | — |
WoEqmInv |
decimal(21,5) | Nee | ((0)) | — |
WoExported |
smallint | Nee | ((0)) | — |
WoExtCalc |
decimal(21,5) | Nee | ((0)) | — |
WoExtCost |
decimal(21,5) | Nee | ((0)) | — |
WoExternalId |
nvarchar(50) | Ja | — | — |
WoExternalStatus |
nvarchar(50) | Ja | — | — |
WoExtInv |
decimal(21,5) | Nee | ((0)) | — |
WoExtra1 |
smallint | Nee | ((0)) | — |
WoExtra10 |
nvarchar(5) | Ja | — | — |
WoExtra11 |
nvarchar(5) | Ja | — | — |
WoExtra12 |
decimal(21,0) | Nee | ((0)) | — |
WoExtra2 |
int | Nee | ((0)) | — |
WoExtra3 |
nvarchar(5) | Ja | — | — |
WoExtra4 |
nvarchar(5) | Ja | — | — |
WoExtra5 |
int | Nee | ((0)) | — |
WoExtra6 |
int | Nee | ((0)) | — |
WoExtra7 |
int | Nee | ((0)) | — |
WoExtra8 |
nvarchar(5) | Ja | — | — |
WoExtra9 |
nvarchar(5) | Ja | — | — |
WoFalId |
nvarchar(9) | Ja | — | — |
WoHours |
decimal(21,2) | Nee | ((0)) | — |
WoHoursCalc |
decimal(21,2) | Nee | ((0)) | — |
WoHoursInv |
decimal(21,2) | Nee | ((0)) | — |
WoHoursToPlan |
decimal(21,2) | Nee | ((0)) | — |
WoImpId |
nvarchar(11) | Ja | — | — |
WoIOFixedPriceCost |
decimal(21,5) | Nee | ((0)) | — |
WoIoTermCost |
decimal(21,5) | Nee | ((0)) | — |
WoIoTermInv |
decimal(21,5) | Nee | ((0)) | — |
WoLabCost |
decimal(21,5) | Nee | ((0)) | — |
WoLabInv |
decimal(21,5) | Nee | ((0)) | — |
WoMatCalc |
decimal(21,5) | Nee | ((0)) | — |
WoMatCost |
decimal(21,5) | Nee | ((0)) | — |
WoMatInv |
decimal(21,5) | Nee | ((0)) | — |
WoMemorandumCost |
decimal(21,5) | Nee | ((0)) | — |
WoPercComplete |
decimal(21,2) | Nee | ((0)) | — |
WoPmId |
nvarchar(5) | Ja | — | — |
WoPmWeek |
int | Nee | ((0)) | — |
WoPostpDate |
datetimeoffset(7) | Ja | — | — |
WoPostpEmpId |
nvarchar(9) | Ja | — | — |
WoPostpTime |
int | Nee | ((0)) | — |
WoPrfId |
nvarchar(50) | Ja | — | — |
WoPriId |
nvarchar(4) | Ja | — | — |
WoPrjId |
nvarchar(6) | Ja | — | — |
WoPrjMngrEmpId |
nvarchar(9) | Ja | — | — |
WoProviderMutDate |
datetimeoffset(7) | Ja | — | — |
WoPurchaseRequestCalc |
decimal(21,5) | Nee | ((0)) | — |
WoPurchCalc |
decimal(21,5) | Nee | ((0)) | — |
WoPurchCommit |
decimal(21,5) | Nee | ((0)) | — |
WoPurchCost |
decimal(21,5) | Nee | ((0)) | — |
WoPurchInv |
decimal(21,5) | Nee | ((0)) | — |
WoRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
WoReportDate |
datetimeoffset(7) | Ja | — | — |
WoReportDepId |
nvarchar(11) | Ja | — | — |
WoReportEmpId |
nvarchar(41) | Ja | — | — |
WoReportFkEmpId |
nvarchar(9) | Ja | — | — |
WoReportState |
decimal(21,0) | Nee | ((0)) | — |
WoResCalc |
decimal(21,5) | Nee | ((0)) | — |
WoSchStartDate |
datetimeoffset(7) | Ja | — | — |
WoSitId |
nvarchar(8) | Ja | — | — |
WoSkcId |
nvarchar(9) | Ja | — | — |
WoSortOrder |
int | Nee | ((0)) | — |
WoTargetDate |
datetimeoffset(7) | Ja | — | — |
WoText |
nvarchar(max) | Ja | — | — |
WoTlsCalc |
decimal(21,5) | Nee | ((0)) | — |
WoTlsCost |
decimal(21,5) | Nee | ((0)) | — |
WoTlsInv |
decimal(21,5) | Nee | ((0)) | — |
WoToSpendFcDate |
date | Ja | — | — |
WoToSpendForeCast |
decimal(21,5) | Nee | ((0)) | — |
WoTotalHoursPlanned |
decimal(21,2) | Nee | ((0)) | — |
WoTransferNextTime |
smallint | Nee | ((0)) | — |
WoUrgId |
nvarchar(11) | Ja | — | — |
WoVdrId |
nvarchar(6) | Ja | — | — |
WoWotId |
nvarchar(6) | Ja | — | — |
WoYrpslmmLineId |
nvarchar(8) | Ja | — | — |
WoYrpslmmYrpId |
nvarchar(9) | Ja | — | — |
WoYrpslmmYrpsLineId |
nvarchar(2) | Ja | — | — |
WoYrpslmmYrpslLineId |
nvarchar(9) | Ja | — | — |
WoBudgetTotal |
decimal(21,5) | Nee | — | — |
WoCalcTotal |
decimal(21,5) | Nee | — | — |
WoCostTotal |
decimal(21,5) | Nee | — | — |
WoInvTotal |
decimal(21,5) | Nee | — | — |
WoFileExtension |
nvarchar(5) | Nee | — | — |
WoText_FT |
varbinary(max) | Ja | — | — |
Computed columnsbewerken
WoBudgetTotal—(CONVERT([decimal](21,5),[WoBudgetOrg]+[WoBudgetMutation]))WoCalcTotal—(CONVERT([decimal](21,5),(((([WoMatCalc]+[WoExtCalc])+[WoTlsCalc])+[WoResCalc])+[WoPurchaseRequestCalc])+[WoPurchCalc]))WoCostTotal—(CONVERT([decimal](21,5),(((([WoMatCost]+[WoExtCost])+[WoTlsCost])+[WoLabCost])+[WoPurchCost])+[WoMemorandumCost]))WoInvTotal—(CONVERT([decimal](21,5),((((([WoEqmInv]+[WoMatInv])+[WoExtInv])+[WoTlsInv])+[WoLabInv])+[WoPurchInv])+[WoIoTermInv]))WoFileExtension—(N'.html')WoText_FT—(case when [WoText] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([WoText],(5))=N'<html' then [WoText] else N'<html lang="nl">'+[WoText] end) end)
Trigger-gevulde kolommenbewerken
WoBudgetMutation← TRSD_WORKORDERBUDGETSUPPL, TRSM_WORKORDERBUDGETSUPPLWoEqmInv← TRSD_JOB, TRSM_JOBWoExtCalc← TRSD_JOB, TRSM_JOBWoExtCost← TRSD_JOB, TRSM_JOBWoExtInv← TRSD_JOB, TRSM_JOBWoHours← TRGU_Job, TRSD_JOB, TRSM_JOBWoHoursCalc← TRSD_JOB, TRSM_JOBWoHoursInv← TRSD_JOB, TRSM_JOBWoHoursToPlan← TRSD_JOB, TRSM_JOBWoIOFixedPriceCost← TRSD_JOB, TRSM_JOBWoIoTermCost← TRSD_JOB, TRSM_JOBWoIoTermInv← TRSD_JOB, TRSM_JOBWoLabCost← TRSD_JOB, TRSM_JOBWoLabInv← TRSD_JOB, TRSM_JOBWoMatCalc← TRSD_JOB, TRSM_JOBWoMatCost← TRSD_JOB, TRSM_JOBWoMatInv← TRSD_JOB, TRSM_JOBWoMemorandumCost← TRSD_JOB, TRSM_JOBWoPercComplete← TRGU_WorkOrderWoPurchaseRequestCalc← TRSD_JOB, TRSM_JOBWoPurchCalc← TRSD_JOB, TRSM_JOBWoPurchCommit← TRSD_JOB, TRSM_JOBWoPurchCost← TRSD_JOB, TRSM_JOBWoPurchInv← TRSD_JOB, TRSM_JOBWoResCalc← TRSD_JOB, TRSM_JOBWoTlsCalc← TRSD_JOB, TRSM_JOBWoTlsCost← TRSD_JOB, TRSM_JOBWoTlsInv← TRSD_JOB, TRSM_JOBWoTotalHoursPlanned← TRSD_JOB, TRSM_JOB
Brondatabewerken
- DB-schema —
lookup_table_schema("WorkOrder")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("WorkOrder")· ../entities/WorkOrder Properties, contexts, statussen. Bron:Entities.xml.