title: "PmJob (table)" category: reference tags: [table, pmjob, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.PmJob
Schema: dba
Aantal kolommen: 87
Zie ook de entity-pagina: ../entities/PmJob
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PmjPmwId |
nvarchar(5) | Nee | — | — |
PmjId |
nvarchar(3) | Nee | — | — |
PmjDescr |
nvarchar(200) | Ja | — | — |
PmjContext |
bigint | Nee | ((1)) | — |
PmjRecStatus |
int | Nee | ((0)) | — |
PmjActId |
nvarchar(5) | Ja | — | — |
PmjAllowDetailsBesideJobPlan |
smallint | Nee | ((0)) | — |
PmjApprvDate |
datetimeoffset(7) | Ja | — | — |
PmjApprvEmpId |
nvarchar(9) | Ja | — | — |
PmjCcrId |
nvarchar(9) | Ja | — | — |
PmjCompId |
nvarchar(6) | Nee | — | — |
PmjCopyText |
smallint | Nee | ((1)) | — |
PmjCrmId |
nvarchar(6) | Ja | — | — |
PmjCsttId |
nvarchar(9) | Ja | — | — |
PmjDataProvider |
nvarchar(50) | Ja | — | — |
PmjDelay |
decimal(21,2) | Nee | ((0)) | — |
PmjDepId |
nvarchar(11) | Ja | — | — |
PmjDocId |
nvarchar(11) | Ja | — | — |
PmjDowntimeRequired |
smallint | Nee | ((0)) | — |
PmjDurationCalc |
decimal(21,2) | Nee | ((0)) | — |
PmjEmpId |
nvarchar(9) | Ja | — | — |
PmjEqmId |
nvarchar(24) | Ja | — | — |
PmjExported |
smallint | Nee | ((0)) | — |
PmjExtCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjExternalId |
nvarchar(50) | Ja | — | — |
PmjExternalStatus |
nvarchar(50) | Ja | — | — |
PmjExtra1 |
smallint | Nee | ((0)) | — |
PmjExtra10 |
nvarchar(5) | Ja | — | — |
PmjExtra11 |
nvarchar(5) | Ja | — | — |
PmjExtra12 |
int | Nee | ((0)) | — |
PmjExtra2 |
int | Nee | ((0)) | — |
PmjExtra3 |
nvarchar(6) | Ja | — | — |
PmjExtra4 |
nvarchar(5) | Ja | — | — |
PmjExtra5 |
int | Nee | ((0)) | — |
PmjExtra6 |
int | Nee | ((0)) | — |
PmjExtra7 |
nvarchar(5) | Ja | — | — |
PmjExtra8 |
nvarchar(5) | Ja | — | — |
PmjExtra9 |
nvarchar(5) | Ja | — | — |
PmjFileId |
nvarchar(255) | Ja | — | — |
PmjFmanId |
nvarchar(5) | Ja | — | — |
PmjHours |
decimal(21,2) | Nee | ((0)) | — |
PmjImpId |
nvarchar(11) | Ja | — | — |
PmjIspId |
nvarchar(11) | Ja | — | — |
PmjJpId |
nvarchar(11) | Ja | — | — |
PmjLotoApplicable |
smallint | Nee | ((0)) | — |
PmjMatCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjMultiExtCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjMultiHours |
decimal(21,5) | Nee | ((0)) | — |
PmjMultiMatCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjMultiPurchaseRequestCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjMultiResCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjMultiTlsCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjNoPermit |
smallint | Nee | ((0)) | — |
PmJobConvertedDurationToHours |
smallint | Nee | ((1)) | — |
PmjPlanHours |
decimal(21,2) | Nee | ((0)) | — |
PmjPrfId |
nvarchar(50) | Ja | — | — |
PmjPriId |
nvarchar(4) | Ja | — | — |
PmjProc |
nvarchar(41) | Ja | — | — |
PmjProviderMutDate |
datetimeoffset(7) | Ja | — | — |
PmjPurchaseRequestCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PmjRemarkSmallInt1 |
smallint | Nee | ((0)) | — |
PmjRemarkSmallInt2 |
smallint | Nee | ((0)) | — |
PmjRemarkSmallInt3 |
smallint | Nee | ((0)) | — |
PmjResCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjSkcId |
nvarchar(9) | Ja | — | — |
PmjSpcId |
nvarchar(40) | Ja | — | — |
PmjStopRelated |
smallint | Nee | ((0)) | — |
PmjSubExtCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjSubHours |
decimal(21,5) | Nee | ((0)) | — |
PmjSubMatCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjSubPurchaseRequestCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjSubResCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjSubTlsCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjSvcId |
nvarchar(9) | Ja | — | — |
PmjTemplatePermId |
nvarchar(6) | Ja | — | — |
PmjText |
nvarchar(max) | Ja | — | — |
PmjTlsCalc |
decimal(21,5) | Nee | ((0)) | — |
PmjTransferNextTime |
smallint | Nee | ((0)) | — |
PmjUrgId |
nvarchar(11) | Ja | — | — |
PmjUseStdJp |
smallint | Nee | ((0)) | — |
PmjUseWorkScheduleForPlanning |
smallint | Nee | ((1)) | — |
PmjVdrId |
nvarchar(6) | Ja | — | — |
PmjWotId |
nvarchar(6) | Ja | — | — |
PmjTotalCalc |
decimal(21,5) | Nee | — | — |
PmjReopenedAutomatically |
smallint | Nee | ((0)) | — |
PmjLtpId |
nvarchar(6) | Ja | — | — |
Computed columnsbewerken
PmjTotalCalc—(CONVERT([decimal](21,5),((([PmjMatCalc]+[PmjExtCalc])+[PmjTlsCalc])+[PmjResCalc])+[PmjPurchaseRequestCalc]))
Trigger-gevulde kolommenbewerken
PmjRecStatus← TRGD_PmJobJobPlan, TRGI_PmJobJobPlan, TRGU_PmJobJobPlan, TRS_JpExt, TRS_JpMat, TRS_JpPurchaseRequestLine, TRS_JpRes, TRS_JpTlsPmjCcrId← TRGU_EquipmentPmjDepId← TRGU_EquipmentPmjExtCalc← TRGI_PmJob, TRGU_PmJobPmjHours← TRGI_PmJob, TRGU_PmJobPmjMatCalc← TRGI_PmJob, TRGU_PmJobPmjPrfId← TRGD_ProcessFunction, TRGU_EquipmentPmjPurchaseRequestCalc← TRGI_PmJob, TRGU_PmJobPmjResCalc← TRGI_PmJob, TRGU_PmJobPmjSpcId← TRGU_EquipmentPmjSubExtCalc← TRSD_PMJEXT, TRSM_PMJEXTPmjSubHours← TRSD_PMJRES, TRSM_PMJRESPmjSubMatCalc← TRSD_PMJMAT, TRSM_PMJMATPmjSubPurchaseRequestCalc← TRSD_PMJPURCHASEREQUESTLINE, TRSM_PMJPURCHASEREQUESTLINEPmjSubResCalc← TRSD_PMJRES, TRSM_PMJRESPmjSubTlsCalc← TRSD_PMJTLS, TRSM_PMJTLSPmjTlsCalc← TRGI_PmJob, TRGU_PmJob
Brondatabewerken
- DB-schema —
lookup_table_schema("PmJob")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("PmJob")· ../entities/PmJob Properties, contexts, statussen. Bron:Entities.xml.