Bewerken: Job

Sectie: Properties

Reden:

## Properties

| 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 |  |