title: "Job (table)" category: reference tags: [table, job, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Job
Schema: dba
Aantal kolommen: 308
Zie ook de entity-pagina: ../entities/Job
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
JobId |
nvarchar(12) | Nee | — | — |
JobDescr |
nvarchar(200) | Ja | — | — |
JobContext |
bigint | Nee | ((1)) | — |
JobRecStatus |
int | Nee | ((0)) | — |
JobAcceptDate |
datetimeoffset(7) | Ja | — | — |
JobAccepted |
smallint | Nee | ((0)) | — |
JobAcceptEmpId |
nvarchar(9) | Ja | — | — |
JobActId |
nvarchar(5) | Ja | — | — |
JobActiveDate |
datetimeoffset(7) | Ja | — | — |
JobActiveEmpId |
nvarchar(9) | Ja | — | — |
JobActualMoveDate |
date | Ja | — | — |
JobAllowChangeKntId |
smallint | Nee | ((0)) | — |
JobAllowChangeSdrtId |
smallint | Nee | ((0)) | — |
JobAllowMultijobPlanningFieldsToExpand |
smallint | Nee | ((1)) | — |
JobApprvDate |
datetimeoffset(7) | Ja | — | — |
JobApprvEmpId |
nvarchar(9) | Ja | — | — |
JobArtId |
nvarchar(9) | Ja | — | — |
JobBldfId |
nvarchar(23) | Ja | — | — |
JobBldId |
nvarchar(11) | Ja | — | — |
JobBldpId |
nvarchar(11) | Ja | — | — |
JobBofId |
nvarchar(4) | Ja | — | — |
JobCancelled |
smallint | Nee | ((0)) | — |
JobCateringCount |
smallint | Nee | ((0)) | — |
JobCcId |
nvarchar(2) | Ja | — | — |
JobCcrId |
nvarchar(9) | Ja | — | — |
JobChangeJobId |
nvarchar(12) | Ja | — | — |
JobChangeLinkDate |
date | Ja | — | — |
JobChangeWoId |
nvarchar(9) | Ja | — | — |
JobCharge |
smallint | Nee | ((0)) | — |
JobChgId |
nvarchar(6) | Ja | — | — |
JobClassificationImpId |
nvarchar(11) | Ja | — | — |
JobCloseDate |
datetimeoffset(7) | Ja | — | — |
JobCloseEmpId |
nvarchar(9) | Ja | — | — |
JobCompId |
nvarchar(6) | Nee | — | — |
JobComplDate |
datetimeoffset(7) | Ja | — | — |
JobComplEmpId |
nvarchar(9) | Ja | — | — |
JobConvertedDurationToHours |
smallint | Nee | ((1)) | — |
JobCreatedByServiceDesk |
smallint | Nee | ((0)) | — |
JobCrmId |
nvarchar(6) | Ja | — | — |
JobCsttId |
nvarchar(9) | Ja | — | — |
JobCurrWeek |
int | Nee | ((0)) | — |
JobCusContactEmpId |
nvarchar(9) | Ja | — | — |
JobCusId |
nvarchar(6) | Ja | — | — |
JobCusSId |
nvarchar(10) | Ja | — | — |
JobCustomerReference |
nvarchar(100) | Ja | — | — |
JobDataProvider |
nvarchar(50) | Ja | — | — |
JobDecId |
nvarchar(15) | Ja | — | — |
JobDepId |
nvarchar(11) | Ja | — | — |
JobDocId |
nvarchar(11) | Ja | — | — |
JobDownDate |
datetimeoffset(7) | Ja | — | — |
JobDowntimeRequired |
smallint | Nee | ((0)) | — |
JobDuration |
decimal(21,2) | Nee | ((0)) | — |
JobDurationCalc |
decimal(21,2) | Nee | ((0)) | — |
JobEmpId |
nvarchar(9) | Ja | — | — |
JobEqmAvailableCount |
smallint | Nee | ((0)) | — |
JobEqmId |
nvarchar(24) | Ja | — | — |
JobEqmInv |
decimal(21,5) | Nee | ((0)) | — |
JobEqmNotAvailableCount |
smallint | Nee | ((0)) | — |
JobEqmtId |
nvarchar(9) | Ja | — | — |
JobExecWindowQty |
decimal(21,2) | Nee | ((0)) | — |
JobExecWindowStartDate |
datetimeoffset(7) | Ja | — | — |
JobExecWindowStopDate |
datetimeoffset(7) | Ja | — | — |
JobExecWindowTimuId |
nvarchar(11) | Ja | — | — |
JobExported |
smallint | Nee | ((0)) | — |
JobExportedDate |
datetimeoffset(7) | Ja | — | — |
JobExtCalc |
decimal(21,5) | Nee | ((0)) | — |
JobExtCost |
decimal(21,5) | Nee | ((0)) | — |
JobExternalId |
nvarchar(50) | Ja | — | — |
JobExternalStatus |
nvarchar(50) | Ja | — | — |
JobExtInv |
decimal(21,5) | Nee | ((0)) | — |
JobExtra1 |
smallint | Nee | ((0)) | — |
JobExtra10 |
nvarchar(5) | Ja | — | — |
JobExtra11 |
nvarchar(5) | Ja | — | — |
JobExtra12 |
int | Nee | ((0)) | — |
JobExtra2 |
int | Nee | ((0)) | — |
JobExtra3 |
nvarchar(6) | Ja | — | — |
JobExtra4 |
nvarchar(5) | Ja | — | — |
JobExtra5 |
int | Nee | ((0)) | — |
JobExtra6 |
int | Nee | ((0)) | — |
JobExtra7 |
nvarchar(5) | Ja | — | — |
JobExtra8 |
nvarchar(5) | Ja | — | — |
JobExtra9 |
nvarchar(5) | Ja | — | — |
JobExtTariff |
decimal(21,5) | Nee | ((0)) | — |
JobFalId |
nvarchar(9) | Ja | — | — |
JobFeedbackText |
nvarchar(max) | Ja | — | — |
JobFileId |
nvarchar(100) | Ja | — | — |
JobFinishDate |
datetimeoffset(7) | Ja | — | — |
JobFinishEmpId |
nvarchar(9) | Ja | — | — |
JobFmanId |
nvarchar(5) | Ja | — | — |
JobGeocodeX |
decimal(21,6) | Nee | ((0)) | — |
JobGeocodeY |
decimal(21,6) | Nee | ((0)) | — |
JobHours |
decimal(21,2) | Nee | ((0)) | — |
JobHoursCalc |
decimal(21,2) | Nee | ((0)) | — |
JobHoursInv |
decimal(21,2) | Nee | ((0)) | — |
JobHoursToPlanFromResources |
decimal(21,2) | Nee | ((0)) | — |
JobHtcId |
nvarchar(5) | Ja | — | — |
JobImageFile |
nvarchar(max) | Ja | — | — |
JobImagefile2 |
nvarchar(max) | Ja | — | — |
JobImagefile3 |
nvarchar(max) | Ja | — | — |
JobImagefile4 |
nvarchar(max) | Ja | — | — |
JobImpId |
nvarchar(11) | Ja | — | — |
JobImportedDate |
datetimeoffset(7) | Ja | — | — |
JobIncId |
nvarchar(10) | Ja | — | — |
JobInspectionLines |
int | Nee | ((0)) | — |
JobInvomId |
nvarchar(6) | Ja | — | — |
JobInvOutTermFixedPrice |
smallint | Nee | ((0)) | — |
JobInvOutTermFrqQty |
smallint | Nee | ((0)) | — |
JobInvOutTermFxdPriceCst |
decimal(21,5) | Nee | ((0)) | — |
JobInvOutTermPayInTerms |
smallint | Nee | ((0)) | — |
JobInvOutTermTermFromDate |
date | Ja | — | — |
JobInvOutTermTermFrqId |
nvarchar(3) | Ja | — | — |
JobInvOutTermTermQty |
smallint | Nee | ((0)) | — |
JobInvOutTermTermStdDescr |
nvarchar(100) | Ja | — | — |
JobIoTermCost |
decimal(21,5) | Nee | ((0)) | — |
JobIoTermInv |
decimal(21,5) | Nee | ((0)) | — |
JobIsMaster |
smallint | Nee | ((0)) | — |
JobIsMultijob |
smallint | Nee | ((0)) | — |
JobIspId |
nvarchar(11) | Ja | — | — |
JobItilChangeJobId |
nvarchar(12) | Ja | — | — |
JobItrId |
nvarchar(5) | Ja | — | — |
JobJpId |
nvarchar(11) | Ja | — | — |
JobKndId |
nvarchar(11) | Ja | — | — |
JobKnowledgeTopicCount |
int | Nee | ((0)) | — |
JobKntId |
nvarchar(11) | Ja | — | — |
JobKwsId |
nvarchar(3) | Ja | — | — |
JobLabCost |
decimal(21,5) | Nee | ((0)) | — |
JobLabInv |
decimal(21,5) | Nee | ((0)) | — |
JobLotoApplicable |
smallint | Nee | ((0)) | — |
JobMasterJobId |
nvarchar(12) | Ja | — | — |
JobMatCalc |
decimal(21,5) | Nee | ((0)) | — |
JobMatCost |
decimal(21,5) | Nee | ((0)) | — |
JobMatInv |
decimal(21,5) | Nee | ((0)) | — |
JobMeettId |
nvarchar(13) | Ja | — | — |
JobMemorandumCost |
decimal(21,5) | Nee | ((0)) | — |
JobMjId |
nvarchar(12) | Ja | — | — |
JobMjtId |
nvarchar(4) | Ja | — | — |
JobMjtlLineId |
nvarchar(2) | Ja | — | — |
JobMjtlMjtId |
nvarchar(4) | Ja | — | — |
JobMoveFromSpcId |
nvarchar(40) | Ja | — | — |
JobMoveToSpcId |
nvarchar(40) | Ja | — | — |
JobNoPermit |
smallint | Nee | ((0)) | — |
JobObjiLine |
nvarchar(6) | Ja | — | — |
JobObjiObjIspId |
nvarchar(6) | Ja | — | — |
JobOpenDate |
datetimeoffset(7) | Ja | — | — |
JobOpenEmpId |
nvarchar(9) | Ja | — | — |
JobOperationLossHours |
decimal(21,3) | Nee | ((0)) | — |
JobOriginalSchStartDate |
date | Ja | — | — |
JobOriginalSvcTargetDate |
datetimeoffset(7) | Ja | — | — |
JobParentJobId |
nvarchar(12) | Ja | — | — |
JobPchrlTotBookCostExlVat |
decimal(21,5) | Nee | ((0)) | — |
JobPchrlTotBookCostInclVat |
decimal(21,5) | Nee | ((0)) | — |
JobPchTotalBookCostExlVat |
decimal(21,5) | Nee | ((0)) | — |
JobPchTotalBookCostInclVat |
decimal(21,5) | Nee | ((0)) | — |
JobPercComplete |
decimal(21,2) | Nee | ((0)) | — |
JobPlanHours |
decimal(21,2) | Nee | ((0)) | — |
JobPmId |
nvarchar(5) | Ja | — | — |
JobPmjId |
nvarchar(3) | Ja | — | — |
JobPmjPmwId |
nvarchar(5) | Ja | — | — |
JobPostpDate |
datetimeoffset(7) | Ja | — | — |
JobPostpEmpId |
nvarchar(9) | Ja | — | — |
JobPostpEndDate |
datetimeoffset(7) | Ja | — | — |
JobPostpRemark |
nvarchar(61) | Ja | — | — |
JobPrddId |
nvarchar(6) | Ja | — | — |
JobPrfId |
nvarchar(50) | Ja | — | — |
JobPriId |
nvarchar(4) | Ja | — | — |
JobPrjId |
nvarchar(6) | Ja | — | — |
JobProblemJobId |
nvarchar(12) | Ja | — | — |
JobProc |
nvarchar(41) | Ja | — | — |
JobProviderMutDate |
datetimeoffset(7) | Ja | — | — |
JobPrsId |
nvarchar(11) | Ja | — | — |
JobPurchCommit |
decimal(21,5) | Nee | ((0)) | — |
JobPurchCost |
decimal(21,5) | Nee | ((0)) | — |
JobPurchInv |
decimal(21,5) | Nee | ((0)) | — |
JobRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
JobRelcId |
nvarchar(5) | Ja | — | — |
JobReleaseDate |
date | Ja | — | — |
JobReleaseTillDate |
date | Ja | — | — |
JobRemarkChar1 |
nvarchar(20) | Ja | — | — |
JobRemarkChar2 |
nvarchar(20) | Ja | — | — |
JobRemarkChar3 |
nvarchar(20) | Ja | — | — |
JobRemarkChar4 |
nvarchar(20) | Ja | — | — |
JobRemarkChar5 |
nvarchar(20) | Ja | — | — |
JobRemarkChar6 |
nvarchar(10) | Ja | — | — |
JobRemarkChar7 |
nvarchar(10) | Ja | — | — |
JobRemarkDate1 |
date | Ja | — | — |
JobRemarkDate2 |
date | Ja | — | — |
JobRemarkDateTime1 |
datetimeoffset(7) | Ja | — | — |
JobRemarkDateTime2 |
datetimeoffset(7) | Ja | — | — |
JobRemarkDouble1 |
decimal(21,2) | Nee | ((0)) | — |
JobRemarkDouble2 |
decimal(21,2) | Nee | ((0)) | — |
JobRemarkInt1 |
int | Nee | ((0)) | — |
JobRemarkInt2 |
int | Nee | ((0)) | — |
JobRemarkInt3 |
int | Nee | ((0)) | — |
JobRemarkInt4 |
int | Nee | ((0)) | — |
JobRemarkInt5 |
smallint | Nee | ((0)) | — |
JobRemarkSmallInt1 |
smallint | Nee | ((0)) | — |
JobRemarkSmallInt2 |
smallint | Nee | ((0)) | — |
JobRemarkSmallInt3 |
smallint | Nee | ((0)) | — |
JobRemarkSmallInt4 |
smallint | Nee | ((0)) | — |
JobRemarkSmallInt5 |
smallint | Nee | ((0)) | — |
JobRemarkSpcId |
nvarchar(40) | Ja | — | — |
JobRemarkText1 |
nvarchar(max) | Ja | — | — |
JobRemarkText2 |
nvarchar(max) | Ja | — | — |
JobReportCommId |
nvarchar(5) | Ja | — | — |
JobReportDate |
datetimeoffset(7) | Ja | — | — |
JobReportEmpId |
nvarchar(41) | Ja | — | — |
JobReportFKEmpId |
nvarchar(9) | Ja | — | — |
JobReportText |
nvarchar(max) | Ja | — | — |
JobReportVdrId |
nvarchar(6) | Ja | — | — |
JobRequestDate |
datetimeoffset(7) | Ja | — | — |
JobRequestEmpId |
nvarchar(9) | Ja | — | — |
JobResCalc |
decimal(21,5) | Nee | ((0)) | — |
JobResCapacity |
int | Nee | ((0)) | — |
JobResDuration |
decimal(21,2) | Nee | ((0)) | — |
JobResEmpId |
nvarchar(9) | Ja | — | — |
JobResEndCleaningDate |
datetimeoffset(7) | Ja | — | — |
JobResEndDate |
datetimeoffset(7) | Ja | — | — |
JobReslayId |
nvarchar(9) | Ja | — | — |
JobResReservedBy |
nvarchar(40) | Ja | — | — |
JobResSpcId |
nvarchar(40) | Ja | — | — |
JobResStartDate |
datetimeoffset(7) | Ja | — | — |
JobResStartPrepareDate |
datetimeoffset(7) | Ja | — | — |
JobSafdId |
nvarchar(6) | Ja | — | — |
JobSafiId |
nvarchar(6) | Ja | — | — |
JobScheduledMoveDate |
date | Ja | — | — |
JobSchedulerRemarkText |
nvarchar(50) | Ja | — | — |
JobSchStartDate |
datetimeoffset(7) | Ja | — | — |
JobSdrtId |
nvarchar(4) | Ja | — | — |
JobSelfServiceRequest |
smallint | Nee | ((0)) | — |
JobServiceDeskToBoDate |
datetimeoffset(7) | Ja | — | — |
JobServiceDeskToBoEmpId |
nvarchar(9) | Ja | — | — |
JobShllId |
nvarchar(13) | Ja | — | — |
JobSignatureFile |
nvarchar(max) | Ja | — | — |
JobSitId |
nvarchar(8) | Ja | — | — |
JobSkcId |
nvarchar(9) | Ja | — | — |
JobSlaSvcId |
nvarchar(9) | Ja | — | — |
JobSolvedByReporter |
smallint | Nee | ((0)) | — |
JobSpcId |
nvarchar(40) | Ja | — | — |
JobSrvId |
nvarchar(6) | Ja | — | — |
JobSrvlId |
nvarchar(6) | Ja | — | — |
JobStandardStopJob |
smallint | Nee | ((0)) | — |
JobState |
decimal(21,2) | Nee | ((0)) | — |
JobStopRelated |
smallint | Nee | ((0)) | — |
JobSualLineId |
nvarchar(10) | Ja | — | — |
JobSualSuaId |
nvarchar(10) | Ja | — | — |
JobSupportLine |
smallint | Nee | ((0)) | — |
JobSvcFinishdate |
datetimeoffset(7) | Ja | — | — |
JobSvcFinishPercTarget |
decimal(21,0) | Nee | ((0)) | — |
JobSvcId |
nvarchar(9) | Ja | — | — |
JobSvcReasonResponseExceeded |
nvarchar(max) | Ja | — | — |
JobSvcReasonTargetExceeded |
nvarchar(max) | Ja | — | — |
JobSvcResponsedate |
datetimeoffset(7) | Ja | — | — |
JobSvcResponsePercTarget |
decimal(21,0) | Nee | ((0)) | — |
JobSvcTargetdate |
datetimeoffset(7) | Ja | — | — |
JobSvcTargetResponsedate |
datetimeoffset(7) | Ja | — | — |
JobTargetDate |
datetimeoffset(7) | Ja | — | — |
JobTariff |
decimal(21,5) | Nee | ((0)) | — |
JobText |
nvarchar(max) | Ja | — | — |
JobTlsCalc |
decimal(21,5) | Nee | ((0)) | — |
JobTlsCost |
decimal(21,5) | Nee | ((0)) | — |
JobTlsInv |
decimal(21,5) | Nee | ((0)) | — |
JobTransferNextTime |
smallint | Nee | ((0)) | — |
JobUnapprovedHoursCalculated |
decimal(21,2) | Nee | ((0)) | — |
JobUnapprovedHoursPlanned |
decimal(21,2) | Nee | ((0)) | — |
JobUpDate |
datetimeoffset(7) | Ja | — | — |
JobUrgId |
nvarchar(11) | Ja | — | — |
JobUseEquipmentReservation |
smallint | Nee | ((1)) | — |
JobUseStdCatering |
smallint | Nee | ((0)) | — |
JobUseWorkScheduleForPlanning |
smallint | Nee | ((1)) | — |
JobVdrId |
nvarchar(6) | Ja | — | — |
JobVerifyDate |
datetimeoffset(7) | Ja | — | — |
JobVerifyEmpId |
nvarchar(9) | Ja | — | — |
JobVerifyNeeded |
smallint | Nee | ((0)) | — |
JobWoId |
nvarchar(9) | Ja | — | — |
JobWotId |
nvarchar(6) | Ja | — | — |
JobYrpId |
nvarchar(9) | Ja | — | — |
JobYrpslCalc |
decimal(21,5) | Nee | ((0)) | — |
JobExceedsOriginalTimeEstimate |
smallint | Nee | — | — |
JobHoursToPlan |
decimal(21,2) | Nee | — | — |
JobNonServDeskServRequest |
smallint | Nee | — | — |
JobPercCompleteRaw |
decimal(21,2) | Nee | — | — |
JobPurchaseRequestCalc |
decimal(21,5) | Nee | — | — |
JobPurchCalc |
decimal(21,5) | Nee | — | — |
JobTotalCalc |
decimal(21,5) | Nee | — | — |
JobTotalCost |
decimal(21,5) | Nee | — | — |
JobTotalInv |
decimal(21,5) | Nee | — | — |
JobFileExtension |
nvarchar(5) | Nee | — | — |
JOBFEEDBACKTEXT_FT |
varbinary(max) | Ja | — | — |
JOBREPORTTEXT_FT |
varbinary(max) | Ja | — | — |
JOBTEXT_FT |
varbinary(max) | Ja | — | — |
JobAcceptanceRemarkText |
nvarchar(max) | Ja | — | — |
JobRejectAcceptanceDate |
datetimeoffset(7) | Ja | — | — |
JobRejectAcceptanceEmpId |
nvarchar(9) | Ja | — | — |
JobAcceptanceStatement |
nvarchar(max) | Ja | — | — |
JobRequestedResponse |
smallint | Nee | ((0)) | — |
JobRequestedCustomerSatisfaction |
smallint | Nee | ((0)) | — |
JobExecutionDays |
int | Nee | ((0)) | — |
JobExtensionDays |
int | Nee | ((0)) | — |
JobFinalFinishDate |
date | Ja | — | — |
JobOriginalFinalFinishDate |
date | Ja | — | — |
JobNumberOfMaterials |
int | Nee | ((0)) | — |
JobHideInSelectionList |
smallint | Nee | ((0)) | — |
JobFsnId |
nvarchar(9) | Ja | — | — |
JobLastUsedMaterialInStockIndicator |
smallint | Nee | ((0)) | — |
JobCmptId |
nvarchar(5) | Ja | — | — |
JobRmyId |
nvarchar(5) | Ja | — | — |
JobCmptpId |
nvarchar(5) | Ja | — | — |
JobRcaId |
nvarchar(6) | Ja | — | — |
Computed columnsbewerken
JobExceedsOriginalTimeEstimate—(CONVERT([smallint],case when ([JobHoursCalc]-[JobUnapprovedHoursCalculated])<([JobPlanHours]-[JobUnapprovedHoursPlanned]) then (1) else (0) end))JobHoursToPlan—(CONVERT([decimal](21,2),case when ([JobHoursCalc]-[JobPlanHours])>[JobHoursToPlanFromResources] then (([JobHoursCalc]-[JobPlanHours])-[JobUnapprovedHoursCalculated])+[JobUnapprovedHoursPlanned] else ([JobHoursToPlanFromResources]-[JobUnapprovedHoursCalculated])+[JobUnapprovedHoursPlanned] end))JobNonServDeskServRequest—(CONVERT([smallint],case when [JobCreatedByServiceDesk]=(1) OR [JobSelfServiceRequest]=(1) then (0) else (1) end))JobPercCompleteRaw—(CONVERT([decimal](21,2),case when [JobHoursCalc]=(0) then (0) else ([JobHours]/case when [JobHoursCalc]<=(0) then (1) else [JobHoursCalc] end)*(100.0) end))JobPurchaseRequestCalc—(CONVERT([decimal](21,5),case when [JobPchrlTotBookCostExlVat]<(0) then (0) else [JobPchrlTotBookCostExlVat] end+case when [JobPchrlTotBookCostInclVat]<(0) then (0) else [JobPchrlTotBookCostInclVat] end))JobPurchCalc—(CONVERT([decimal](21,5),case when [JobPchTotalBookCostExlVat]<(0) then (0) else [JobPchTotalBookCostExlVat] end+case when [JobPchTotalBookCostInclVat]<(0) then (0) else [JobPchTotalBookCostInclVat] end))JobTotalCalc—(CONVERT([decimal](21,5),(((((([JobMatCalc]+[JobExtCalc])+[JobTlsCalc])+[JobResCalc])+case when [JobPchrlTotBookCostExlVat]<(0) then (0) else [JobPchrlTotBookCostExlVat] end)+case when [JobPchrlTotBookCostInclVat]<(0) then (0) else [JobPchrlTotBookCostInclVat] end)+case when [JobPchTotalBookCostExlVat]<(0) then (0) else [JobPchTotalBookCostExlVat] end)+case when [JobPchTotalBookCostInclVat]<(0) then (0) else [JobPchTotalBookCostInclVat] end))JobTotalCost—(CONVERT([decimal](21,5),(((([JobMatCost]+[JobExtCost])+[JobTlsCost])+[JobLabCost])+[JobPurchCost])+[JobMemorandumCost]))JobTotalInv—(CONVERT([decimal](21,5),((((([JobEqmInv]+[JobMatInv])+[JobExtInv])+[JobTlsInv])+[JobLabInv])+[JobPurchInv])+[JobIoTermInv]))JobFileExtension—(N'.html')JOBFEEDBACKTEXT_FT—(case when [JOBFEEDBACKTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([JOBFEEDBACKTEXT],(5))=N'<html' then [JOBFEEDBACKTEXT] else N'<html lang="nl">'+[JOBFEEDBACKTEXT] end) end)JOBREPORTTEXT_FT—(case when [JOBREPORTTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([JOBREPORTTEXT],(5))=N'<html' then [JOBREPORTTEXT] else N'<html lang="nl">'+[JOBREPORTTEXT] end) end)JOBTEXT_FT—(case when [JOBTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([JOBTEXT],(5))=N'<html' then [JOBTEXT] else N'<html lang="nl">'+[JOBTEXT] end) end)JobFinalFinishDate—(case when [JobExecutionDays]>(0) then dateadd(day,([JobExecutionDays]+[JobExtensionDays])-(1),[JobOriginalSchStartDate]) end)JobOriginalFinalFinishDate—(case when [JobExecutionDays]>(0) then dateadd(day,[JobExecutionDays]-(1),[JobOriginalSchStartDate]) end)
Trigger-gevulde kolommenbewerken
JobRecStatus← TRGU_IncidentJobActiveDate← TRGI_JobJobActiveEmpId← TRGI_JobJobApprvDate← TRGI_JobJobApprvEmpId← TRGI_JobJobBofId← TRGD_BackOffice, TRGI_BackOffice, TRGI_Job, TRGU_JobJobEqmInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobExtCalc← TRSD_JOBEXT, TRSM_JOBEXTJobExtCost← TRSD_JOBEXT, TRSM_JOBEXTJobExtInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobHours← TRGU_Project, TRSD_JOBWEEK, TRSM_JOBWEEKJobHoursCalc← TRSD_JOBRES, TRSM_JOBRESJobHoursInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobHoursToPlanFromResources← TRSD_JOBRES, TRSM_JOBRESJobInspectionLines← TRGD_JobInsp, TRGI_JobInspJobInvOutTermFxdPriceCst← TRSD_JOBINVOUTTERM, TRSM_JOBINVOUTTERMJobIoTermInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobLabCost← TRSD_JOBWEEK, TRSM_JOBWEEKJobLabInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobMatCalc← TRSD_JOBMAT, TRSM_JOBMATJobMatCost← TRSD_JOBMAT, TRSM_JOBMATJobMatInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobMemorandumCost← TRSD_COST, TRSM_COSTJobPchrlTotBookCostExlVat← TRGU_UmmSettings, TRSD_PURCHASEREQUESTLINE, TRSM_PURCHASEREQUESTLINEJobPchrlTotBookCostInclVat← TRGU_UmmSettings, TRSD_PURCHASEREQUESTLINE, TRSM_PURCHASEREQUESTLINEJobPchTotalBookCostExlVat← TRGU_UmmSettings, TRSD_PURCHASELINE, TRSM_PURCHASELINEJobPchTotalBookCostInclVat← TRGU_UmmSettings, TRSD_PURCHASELINE, TRSM_PURCHASELINEJobPercComplete← TRGU_JobJobPlanHours← TRSD_JOBSCHEDULEPART, TRSM_JOBSCHEDULEPARTJobPrsId← TRGI_JobJobPurchCommit← TRSD_PURCHASELINE, TRSM_PURCHASELINEJobPurchCost← TRSD_COST, TRSM_COSTJobPurchInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobResCalc← TRSD_JOBRES, TRSM_JOBRESJobTlsCalc← TRSD_JOBTLS, TRSM_JOBTLSJobTlsCost← TRSD_JOBTLS, TRSM_JOBTLSJobTlsInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEJobUnapprovedHoursCalculated← TRSD_JOBRES, TRSM_JOBRESJobUnapprovedHoursPlanned← TRSD_JOBSCHEDULEPART, TRSM_JOBSCHEDULEPARTJobRequestedResponse← TRGD_SDefPrsContext, TRGI_Job, TRGI_SDefPrsContext, TRGU_Job, TRGU_SDefPrsContextJobRequestedCustomerSatisfaction← TRGD_SDefPrsContext, TRGI_Job, TRGI_SDefPrsContext, TRGU_Job, TRGU_SDefPrsContextJobExtensionDays← TRSD_JOBMAINTRANGEHISTORY, TRSM_JOBMAINTRANGEHISTORYJobNumberOfMaterials← TRSD_JOBMAT, TRSM_JOBMAT
Brondatabewerken
- DB-schema —
lookup_table_schema("Job")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Job")· ../entities/Job Properties, contexts, statussen. Bron:Entities.xml.