title: "JobRes (table)" category: reference tags: [table, jobres, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.JobRes
Schema: dba
Aantal kolommen: 45
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
JobrJobId |
nvarchar(12) | Nee | — | — |
JobrLineId |
nvarchar(9) | Nee | — | — |
JobrContext |
bigint | Nee | ((0)) | — |
JobrRecStatus |
int | Nee | ((0)) | — |
JobrBookDate |
date | Ja | — | — |
JobrCcrId |
nvarchar(9) | Ja | — | — |
JobrCompId |
nvarchar(6) | Nee | — | — |
JobrCostCalc |
decimal(21,5) | Nee | ((0)) | — |
JobrCrmId |
nvarchar(6) | Ja | — | — |
JobrCsttId |
nvarchar(9) | Ja | — | — |
JobrCusId |
nvarchar(6) | Ja | — | — |
JobrDataProvider |
nvarchar(50) | Ja | — | — |
JobrDepId |
nvarchar(11) | Ja | — | — |
JobrDiscount |
decimal(21,0) | Nee | — | — |
JobrDiscountTariff |
decimal(21,5) | Nee | — | — |
JobrEqmId |
nvarchar(24) | Ja | — | — |
JobrExported |
smallint | Nee | ((0)) | — |
JobrExternalId |
nvarchar(50) | Ja | — | — |
JobrExternalStatus |
nvarchar(50) | Ja | — | — |
JobrExtra1 |
smallint | Nee | ((0)) | — |
JobrExtra2 |
int | Nee | ((0)) | — |
JobrExtra3 |
nvarchar(5) | Ja | — | — |
JobrHoursCalc |
decimal(21,2) | Nee | ((0)) | — |
JobrInvCost |
decimal(21,5) | Nee | ((0)) | — |
JobrInvHours |
decimal(21,2) | Nee | ((0)) | — |
JobrInvoId |
nvarchar(9) | Ja | — | — |
JobrInvolLineId |
nvarchar(8) | Ja | — | — |
JobrJobjplId |
nvarchar(6) | Ja | — | — |
JobrJpId |
nvarchar(11) | Ja | — | — |
JobrNextWeek |
smallint | Nee | ((0)) | — |
JobrOrgRecStatus |
int | Nee | ((0)) | — |
JobrPrfId |
nvarchar(50) | Ja | — | — |
JobrPrjId |
nvarchar(6) | Ja | — | — |
JobrProviderMutDate |
datetimeoffset(7) | Ja | — | — |
JobrQtyCalc |
decimal(21,2) | Nee | ((0)) | — |
JobrRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
JobrSkcId |
nvarchar(9) | Ja | — | — |
JobrTariffCalc |
decimal(21,5) | Nee | ((0)) | — |
JobrTotalHoursPlanned |
decimal(21,2) | Nee | ((0)) | — |
JobrTransferNextTime |
smallint | Nee | ((0)) | — |
JobrVatId |
nvarchar(3) | Ja | — | — |
JobrVatPercentage |
decimal(21,2) | Nee | ((0)) | — |
JobrWeek |
int | Nee | ((0)) | — |
JobrExceedsOriginalTimeEstimate |
smallint | Nee | — | — |
JobrHoursToPlan |
decimal(21,2) | Nee | — | — |
Computed columnsbewerken
JobrExceedsOriginalTimeEstimate—(CONVERT([smallint],case when [JobrHoursCalc]<[JobrTotalHoursPlanned] then (1) else (0) end))JobrHoursToPlan—(CONVERT([decimal](21,2),case when ([JobrHoursCalc]-[JobrTotalHoursPlanned])<(0) then (0) else [JobrHoursCalc]-[JobrTotalHoursPlanned] end))
Trigger-gevulde kolommenbewerken
JobrRecStatus← TRGU_JobJobPlanJobrTotalHoursPlanned← TRSD_JOBSCHEDULEPART, TRSM_JOBSCHEDULEPART
Brondatabewerken
- DB-schema —
lookup_table_schema("JobRes")Alle kolommen met types, triggers, computed. Bron:database-schema.json.