title: "Job" category: reference tags: [entity, job, datamodel] source: Entities.xml date: 2026-04-17 status: published

Job

Type: Entity Properties: 328 Contexts: 25 Statussen: 10

Zie ook het handgeschreven artikel: job

DB-schema: lookup_table_schema("Job") · ../tables/Job

Contextsbewerken

Statussenbewerken

Propertiesbewerken

Property Type Kolom Width Nullable Default
Id UltimoString JOBID 12 false
_Gmp Boolean _JOBGMP false 0
AcceptanceRemarkText UltimoString JOBACCEPTANCEREMARKTEXT true
AcceptanceStatement UltimoString JOBACCEPTANCESTATEMENT true
Accepted Accept JOBACCEPTED false 0
AcceptedBy Employee JOBACCEPTEMPID true
AcceptedDate DateTime? JOBACCEPTDATE true
Activity Activity JOBACTID true
ActualMoveDate Date? JOBACTUALMOVEDATE true
AllowChangeKnowledgeTopic Boolean JOBALLOWCHANGEKNTID false 0
AllowChangeServiceDeskReportType Boolean JOBALLOWCHANGESDRTID false 0
AllowMultijobPlanningFieldsToExpand Boolean JOBALLOWMULTIJOBPLANNINGFIELDSTOEXPAND false 1
Article Article JOBARTID true
BackOffice BackOffice JOBBOFID true
BuildingFloorId UltimoString JOBBLDFID 23 true
BuildingId UltimoString JOBBLDID 11 true
BuildingPartId UltimoString JOBBLDPID 11 true
BulkJobLines List[JobInspectionLine] JOBIGENJOBID true
Canceled Boolean JOBCANCELLED false
CateringCount Int16 JOBCATERINGCOUNT false
Change Change JOBCHGID true
ChangeJob Job JOBCHANGEJOBID true
ChangeLinkDate Date? JOBCHANGELINKDATE true
ChangeWorkOrder WorkOrder JOBCHANGEWOID true
Charge JobChargeType JOBCHARGE false
ChildJobs List[Job] JOBPARENTJOBID true
Classification Impact JOBCLASSIFICATIONIMPID true
CommunicationMedium CommunicationMedium JOBREPORTCOMMID true
Component Component JOBCMPTID true
ComponentProblem ComponentProblem JOBCMPTPID true
ConditionFlawPresents List[ConditionFlawPresent] CONFLPJOBID true
ConditionMeasurements List[ConditionMeasurement] CONMJOBID true
Context Context JOBCONTEXT false 1
ConvertedDurationToHours Boolean JOBCONVERTEDDURATIONTOHOURS false 1
CostCenter CostCenter JOBCCRID true
CostComponent CostComponent JOBCCID true
CostType CostType JOBCSTTID true
Craftsman Craftsman JOBCRMID true
CreatedByServiceDesk Boolean JOBCREATEDBYSERVICEDESK false 0
CurrentWeek WeekOfYear JOBCURRWEEK false
Customer Customer JOBCUSID true
CustomerContactPerson Employee JOBCUSCONTACTEMPID true
CustomerReference UltimoString JOBCUSTOMERREFERENCE 100 true
CustomerSatisfaction CustomerSatisfaction JOBCUSSID true
DataProvider UltimoString JOBDATAPROVIDER 50 true
Decomposition Decomposition JOBDECID true
Department Department JOBDEPID true
Description UltimoString JOBDESCR 200 true
Document Document JOBDOCID true
DowntimeRequired Boolean JOBDOWNTIMEREQUIRED false 0
Duration Decimal JOBDURATION false
DurationCalculated Decimal JOBDURATIONCALC false
Employee Employee JOBEMPID true
EmployeeLabourLines List[EmployeeLabourLine] EMPLLJOBID true
Equipment Equipment JOBEQMID true
EquipmentChargedInternal CompanyMoney JOBEQMINV false 0
Equipments List[EquipmentJob] EQMJJOBID false
EquipmentsAvailable Int16 JOBEQMAVAILABLECOUNT false
EquipmentsNotAvailable Int16 JOBEQMNOTAVAILABLECOUNT false
EquipmentType EquipmentType JOBEQMTID true
ExceedsOriginalTimeEstimate Boolean JOBEXCEEDSORIGINALTIMEESTIMATE false
ExecutionDays Int32 JOBEXECUTIONDAYS false 0
ExecutionWindowQuantity Decimal JOBEXECWINDOWQTY false 0
ExecutionWindowStartDate DateTime? JOBEXECWINDOWSTARTDATE true
ExecutionWindowStopDate DateTime? JOBEXECWINDOWSTOPDATE true
ExecutionWindowTimeUnit TimeUnit JOBEXECWINDOWTIMUID true
Exported Boolean JOBEXPORTED false
ExportedDate DateTime? JOBEXPORTEDDATE true
ExtensionDays Int32 JOBEXTENSIONDAYS false 0
ExternalHourlyRate CompanyMoney JOBEXTTARIFF false 0
ExternalId UltimoString JOBEXTERNALID 50 true
Externals List[JobExternal] JOBEJOBID false
ExternalsCalculated CompanyMoney JOBEXTCALC false 0
ExternalsChargedInternal CompanyMoney JOBEXTINV false 0
ExternalsRealCost CompanyMoney JOBEXTCOST false 0
ExternalStatus UltimoString JOBEXTERNALSTATUS 50 true
Extra1 Int16 JOBEXTRA1 false
Extra10 UltimoString JOBEXTRA10 5 true
Extra11 UltimoString JOBEXTRA11 5 true
Extra12 Int32 JOBEXTRA12 false
Extra2 Int32 JOBEXTRA2 false
Extra3 UltimoString JOBEXTRA3 6 true
Extra4 UltimoString JOBEXTRA4 5 true
Extra5 Int32 JOBEXTRA5 false
Extra6 Int32 JOBEXTRA6 false
Extra7 UltimoString JOBEXTRA7 5 true
Extra8 UltimoString JOBEXTRA8 5 true
Extra9 UltimoString JOBEXTRA9 5 true
FailType FailType JOBFALID true
FailureDownDate DateTime? JOBDOWNDATE true
FailureUpDate DateTime? JOBUPDATE true
FeedbackText UltimoString JOBFEEDBACKTEXT true
FieldSafetyNotice FieldSafetyNotice JOBFSNID true
FileId UltimoString JOBFILEID 100 true
FinalFinishDate Date? JOBFINALFINISHDATE true
Foreman Foreman JOBFMANID true
GeocodeX Decimal JOBGEOCODEX false 0
GeocodeY Decimal JOBGEOCODEY false 0
HasInspectionLines JobHasInspectionLines JOBINSPECTIONLINES false 0
HideInSelectionList Boolean JOBHIDEINSELECTIONLIST false 0
Hours Decimal JOBHOURS false
HoursCalculated Decimal JOBHOURSCALC false
HoursChargedInternal Decimal JOBHOURSINV false 0
HoursPlanned Decimal JOBPLANHOURS false
HoursToPlan Decimal JOBHOURSTOPLAN false
HoursToPlanFromResources Decimal JOBHOURSTOPLANFROMRESOURCES false 0
HourTariffCategory HourTariffCategory JOBHTCID true
ImageFile UltimoString JOBIMAGEFILE true
ImageFile2 UltimoString JOBIMAGEFILE2 true
ImageFile3 UltimoString JOBIMAGEFILE3 true
ImageFile4 UltimoString JOBIMAGEFILE4 true
Impact Impact JOBIMPID true
ImportDate DateTime? JOBIMPORTEDDATE true
Incident Incident JOBINCID true
IndicatorValue Decimal JOBSTATE false
InspectionLine ObjectInspectionLine JOBOBJIOBJISPID, JOBOBJILINE true ,
InspectionLines List[JobInspectionLine] JOBIJOBID false
InspectionPlan InspectionPlan JOBISPID true
InstallmentsChargedInternal CompanyMoney JOBIOTERMINV false 0
InstallmentsDescription UltimoString JOBINVOUTTERMTERMSTDDESCR 100 true
InstallmentsFixedCostPerTerm CompanyMoney JOBIOTERMCOST false 0
InstallmentsFixedPrice Boolean JOBINVOUTTERMFIXEDPRICE false
InstallmentsFixedPriceCost CompanyMoney JOBINVOUTTERMFXDPRICECST false 0
InstallmentsFrequencyQuantity Int16 JOBINVOUTTERMFRQQTY false
InstallmentsPayInTerms Boolean JOBINVOUTTERMPAYINTERMS false
InstallmentsTermFrequency Frequency JOBINVOUTTERMTERMFRQID true
InstallmentsTermFromDate Date? JOBINVOUTTERMTERMFROMDATE true
InstallmentsTermQuantity Int16 JOBINVOUTTERMTERMQTY false
InternalChargeInstallments List[JobInternalChargeInstallment] JOBIOTJOBID false
InternalChargeMethod InternalChargeMethod JOBINVOMID true
InvoiceLines List[InvoiceLine] INVLJOBID true
InvoiceTotal CompanyMoney JOBTOTALINV false 0
IsMaster Boolean JOBISMASTER false 0
IsMultijob Boolean JOBISMULTIJOB false 0
ItilChangeJob Job JOBITILCHANGEJOBID true
ITRelease ITRelease JOBITRID true
JobMoveLines List[JobMoveLine] JOBMLJOBID false
JobPlan JobPlan JOBJPID true
KnowledgeDomain KnowledgeDomain JOBKNDID true
KnowledgeTopic KnowledgeTopic JOBKNTID true
KnowledgeTopicCount Int32 JOBKNOWLEDGETOPICCOUNT false 0
Kwis Kwis JOBKWSID true
LabourChargedInternal CompanyMoney JOBLABINV false 0
LabourRealCost CompanyMoney JOBLABCOST false 0
LastUsedMaterialInStockIndicator MaterialInStockIndicator JOBLASTUSEDMATERIALINSTOCKINDICATOR false 0
LockoutTagoutApplicable Boolean JOBLOTOAPPLICABLE false 0
MasterJob Job JOBMASTERJOBID true
Materials List[JobMaterial] JOBMJOBID false
MaterialsCalculated CompanyMoney JOBMATCALC false 0
MaterialsChargedInternal CompanyMoney JOBMATINV false 0
MaterialsRealCost CompanyMoney JOBMATCOST false 0
MeetingTopic MeetingTopic JOBMEETTID true
MemorandumCost CompanyMoney JOBMEMORANDUMCOST false 0
MoveFromSpace Space JOBMOVEFROMSPCID true
MoveToSpace Space JOBMOVETOSPCID true
Multijob Job JOBMJID true
MultijobTemplate MultijobTemplate JOBMJTID true
MultijobTemplateLine MultijobTemplateLine JOBMJTLMJTID, JOBMJTLLINEID true ,
NonServiceDeskServiceRequest Boolean JOBNONSERVDESKSERVREQUEST false
NoPermit Boolean JOBNOPERMIT false 0
NumberOfMaterials Int32 JOBNUMBEROFMATERIALS false 0
OperationLosses List[JobOperationLoss] JOBOLJOBID false
OperationLossHours Decimal JOBOPERATIONLOSSHOURS false
OriginalFinalFinishDate Date? JOBORIGINALFINALFINISHDATE true
OriginalScheduledStartDate Date? JOBORIGINALSCHSTARTDATE true
OriginalServiceContractTargetFinishedDate DateTime? JOBORIGINALSVCTARGETDATE true
ParentJob Job JOBPARENTJOBID true
PercentageComplete Decimal JOBPERCCOMPLETE false 0
Permits List[Permit] PERMJOBID true
PmJob PmJob JOBPMJPMWID, JOBPMJID true ,
PmWorkOrder PmWorkOrder JOBPMID true
Priority Priority JOBPRIID true
ProblemJob Job JOBPROBLEMJOBID true
ProcessFunction ProcessFunction JOBPRFID true
ProcessFunctionJobs List[ProcessFunctionJob] PRFJJOBID false
ProductDossier ProductDossier JOBPRDDID true
ProgressStatus ProgressStatus JOBPRSID true
ProgressStatusHistories List[JobProgressStatusHistory] JOBPRSHJOBID false
Project Project JOBPRJID true
Protocol UltimoString JOBPROC 41 true
ProviderMutationDate DateTime? JOBPROVIDERMUTDATE true
PurchaseCalculated CompanyMoney JOBPURCHCALC false 0
PurchaseChargedInternal CompanyMoney JOBPURCHINV false 0
PurchaseCommit CompanyMoney JOBPURCHCOMMIT false 0
PurchaseLines List[PurchaseLine] PCHLJOBID true
PurchaseRealCost CompanyMoney JOBPURCHCOST false 0
PurchaseRequestCalculated CompanyMoney JOBPURCHASEREQUESTCALC false 0
PurchaseRequestLines List[PurchaseRequestLine] PCHRLJOBID true
PurchaseRequestTotalWhenBookCostExcludingVat CompanyMoney JOBPCHRLTOTBOOKCOSTEXLVAT false 0
PurchaseRequestTotalWhenBookCostIncludingVat CompanyMoney JOBPCHRLTOTBOOKCOSTINCLVAT false 0
PurchaseTotalWhenBookCostExcludingVat CompanyMoney JOBPCHTOTALBOOKCOSTEXLVAT false 0
PurchaseTotalWhenBookCostIncludingVat CompanyMoney JOBPCHTOTALBOOKCOSTINCLVAT false 0
ReceivedEmails List[ReceivedEmail] RECEJOBID true
RecordChangeDate DateTime? JOBRECCHANGEDATE true
RecordCreateDate DateTime? JOBRECCREATEDATE true SYSDATETIME
RejectAcceptanceDate DateTime? JOBREJECTACCEPTANCEDATE true
RejectAcceptanceEmployee Employee JOBREJECTACCEPTANCEEMPID true
ReleaseCondition ReleaseCondition JOBRELCID true
ReleaseDate Date? JOBRELEASEDATE true
ReleaseTillDate Date? JOBRELEASETILLDATE true
RemarkChar1 UltimoString JOBREMARKCHAR1 20 true
RemarkChar2 UltimoString JOBREMARKCHAR2 20 true
RemarkChar3 UltimoString JOBREMARKCHAR3 20 true
RemarkChar4 UltimoString JOBREMARKCHAR4 20 true
RemarkChar5 UltimoString JOBREMARKCHAR5 20 true
RemarkChar6 UltimoString JOBREMARKCHAR6 10 true
RemarkChar7 UltimoString JOBREMARKCHAR7 10 true
RemarkDate1 Date? JOBREMARKDATE1 true
RemarkDate2 Date? JOBREMARKDATE2 true
RemarkDateTime1 DateTime? JOBREMARKDATETIME1 true
RemarkDateTime2 DateTime? JOBREMARKDATETIME2 true
RemarkDouble1 Decimal JOBREMARKDOUBLE1 false 0
RemarkDouble2 Decimal JOBREMARKDOUBLE2 false 0
RemarkInt1 Int32 JOBREMARKINT1 false 0
RemarkInt2 Int32 JOBREMARKINT2 false 0
RemarkInt3 Int32 JOBREMARKINT3 false 0
RemarkInt4 Int32 JOBREMARKINT4 false 0
RemarkInt5 Int16 JOBREMARKINT5 false
RemarkSmallInt1 Int16 JOBREMARKSMALLINT1 false
RemarkSmallInt2 Int16 JOBREMARKSMALLINT2 false
RemarkSmallInt3 Int16 JOBREMARKSMALLINT3 false
RemarkSmallInt4 Int16 JOBREMARKSMALLINT4 false
RemarkSmallInt5 Int16 JOBREMARKSMALLINT5 false
RemarkSpace Space JOBREMARKSPCID true
RemarkText1 UltimoString JOBREMARKTEXT1 true
RemarkText2 UltimoString JOBREMARKTEXT2 true
Remedy Remedy JOBRMYID true
Reporter UltimoString JOBREPORTEMPID 41 true
ReportForeignKeyEmployee Employee JOBREPORTFKEMPID true USERID
ReportText UltimoString JOBREPORTTEXT true
ReportVendor Vendor JOBREPORTVDRID true
RequestedCustomerSatisfaction Boolean JOBREQUESTEDCUSTOMERSATISFACTION false 0
RequestedResponse Boolean JOBREQUESTEDRESPONSE false 0
ReservableEndDate DateTime? JOBRESENDDATE true
ReservationCleaningEndDate DateTime? JOBRESENDCLEANINGDATE true
ReservationDuration Decimal JOBRESDURATION false 0
ReservationLayout UltimoString JOBRESLAYID 9 true
ReservationReservedBy UltimoString JOBRESRESERVEDBY 40 true
ReservationSpace Space JOBRESSPCID true
ReservationStartDate DateTime? JOBRESSTARTDATE true
ReservationStartPreparationDate DateTime? JOBRESSTARTPREPAREDATE true
ReserveCapacity Int32 JOBRESCAPACITY false
ReservedByEmployee Employee JOBRESEMPID true
Resources List[JobResource] JOBRJOBID false
ResourcesCalculated CompanyMoney JOBRESCALC false 0
RootCauseAnalysis RootCauseAnalysis JOBRCAID true
SafetyDossier SafetyDossier JOBSAFDID true
SafetyIncident SafetyIncident JOBSAFIID true
ScheduledMoveDate Date? JOBSCHEDULEDMOVEDATE true
ScheduledStartDate DateTime? JOBSCHSTARTDATE true
ScheduleParts List[JobSchedulePart] JOBSPJOBID true
SchedulerRemarkText UltimoString JOBSCHEDULERREMARKTEXT 50 true
SelfServiceRequest Boolean JOBSELFSERVICEREQUEST false 0
SentToBackOfficeBy Employee JOBSERVICEDESKTOBOEMPID true
SentToBackOfficeDate DateTime? JOBSERVICEDESKTOBODATE true
ServiceContract ServiceContract JOBSVCID true
ServiceContractFinishedDate DateTime? JOBSVCFINISHDATE true
ServiceContractFinishExceededReason UltimoString JOBSVCREASONTARGETEXCEEDED true
ServiceContractFinishPercentage Decimal JOBSVCFINISHPERCTARGET false
ServiceContractResponseDate DateTime? JOBSVCRESPONSEDATE true
ServiceContractResponseExceededReason UltimoString JOBSVCREASONRESPONSEEXCEEDED true
ServiceContractResponsePercentage Decimal JOBSVCRESPONSEPERCTARGET false
ServiceContractTargetFinishedDate DateTime? JOBSVCTARGETDATE true
ServiceContractTargetResponseDate DateTime? JOBSVCTARGETRESPONSEDATE true
ServiceDeskReportType ServiceDeskReportType JOBSDRTID true
ServiceLevel ServiceLevel JOBSRVID, JOBSRVLID true ,
ServiceLevelAgreementServiceContract ServiceContract JOBSLASVCID true
ShiftLogLine ShiftLogLine JOBSHLLID true
SignatureFile UltimoString JOBSIGNATUREFILE true
Site Site JOBSITID true
SkillCategory SkillCategory JOBSKCID true
SolvedByReporter Boolean JOBSOLVEDBYREPORTER false 0
Space Space JOBSPCID true
StandardStopJob Boolean JOBSTANDARDSTOPJOB false 0
Status Status JOBRECSTATUS false
StatusActiveDate DateTime? JOBACTIVEDATE true
StatusActiveEmployee Employee JOBACTIVEEMPID true
StatusApprovedDate DateTime? JOBAPPRVDATE true
StatusApprovedEmployee Employee JOBAPPRVEMPID true
StatusClosedDate DateTime? JOBCLOSEDATE true
StatusClosedEmployee Employee JOBCLOSEEMPID true
StatusCompletedDate DateTime? JOBCOMPLDATE true
StatusCompletedEmployee Employee JOBCOMPLEMPID true
StatusCreatedDate DateTime? JOBOPENDATE true SYSDATETIME
StatusCreatedEmployee Employee JOBOPENEMPID true USERID
StatusCreatedReportDate DateTime? JOBREPORTDATE true SYSDATETIME
StatusFinishedDate DateTime? JOBFINISHDATE true
StatusFinishedEmployee Employee JOBFINISHEMPID true
StatusPostponedDate DateTime? JOBPOSTPDATE true
StatusPostponedEmployee Employee JOBPOSTPEMPID true
StatusPostponedEndDate DateTime? JOBPOSTPENDDATE true
StatusPostponedRemark UltimoString JOBPOSTPREMARK 61 true
StatusRequestedDate DateTime? JOBREQUESTDATE true SYSDATETIME
StatusRequestedEmployee Employee JOBREQUESTEMPID true USERID
StopRelated Boolean JOBSTOPRELATED false 0
SubJobs List[Job] JOBMJID true
SupportLine JobSupportLineType JOBSUPPORTLINE false 1
SurveyAssessmentLine SurveyAssessmentLine JOBSUALSUAID, JOBSUALLINEID true ,
SystemCompany Company JOBCOMPID false
TargetDate DateTime? JOBTARGETDATE true
Tariff CompanyMoney JOBTARIFF false 0
Tasks List[JobTask] JOBTSKJOBID false
Text UltimoString JOBTEXT true
Tools List[JobTool] JOBTJOBID false
ToolsCalculated CompanyMoney JOBTLSCALC false 0
ToolsChargedInternal CompanyMoney JOBTLSINV false 0
ToolsRealCost CompanyMoney JOBTLSCOST false 0
TotalCalculated CompanyMoney JOBTOTALCALC false 0
TotalCost CompanyMoney JOBTOTALCOST false 0
TransferNextTime Boolean JOBTRANSFERNEXTTIME false
UnapprovedHoursCalculated Decimal JOBUNAPPROVEDHOURSCALCULATED false 0
UnapprovedHoursPlanned Decimal JOBUNAPPROVEDHOURSPLANNED false 0
Urgency Urgency JOBURGID true
UseEquipmentReservation Boolean JOBUSEEQUIPMENTRESERVATION false 1
UseStandardCatering Boolean JOBUSESTDCATERING false
UseWorkScheduleForPlanning Boolean JOBUSEWORKSCHEDULEFORPLANNING false 1
Vendor Vendor JOBVDRID true
VerifiedByEmployee Employee JOBVERIFYEMPID true
VerifyDate DateTime? JOBVERIFYDATE true
VerifyNeeded Boolean JOBVERIFYNEEDED false
WarehouseServeOuts List[WarehouseServeOut] WHSOJOBID true
WeekLabs List[JobWeekLabour] JOBWLJOBID false
Weeks List[JobWeek] JOBWJOBID false
WorkOrder WorkOrder JOBWOID true
WorkOrderType WorkOrderType JOBWOTID true
YearPlan YearPlan JOBYRPID true
YearPlanScenarioLineCalculation CompanyMoney JOBYRPSLCALC false 0
YearPlanScenarioLines List[YearPlanScenarioLine] YRPSLJOBID true

Brondatabewerken