NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier
project_id

Foreign key of project for this job

 globally unique identifier

Optionally required : project_id, project_reference_back_office or project must be provided
job_priority_id

Foreign key of job_priority for this job

 globally unique identifier
job_type_id

Foreign key of job type for this job

 globally unique identifier

Optionally required : job_type_id, job_type_code or job_type must be provided
job_status_id

Foreign key of job status for this job

 globally unique identifier

Optionally required : job_status_id or job_status_code must be provided
reference_back_office

The Id/Ref of the back office for this job. Used by Embedded entity

 string

Max length: 50
name

Name of the Job

 string

Required

Max length: 255
description

Description of the job

 string

Max length: 4000
internal_memo

Internal field for communication between BackOffice/Planners/Technicians

 string

Max length: 4000
prejob_information

Information usefull for the technician before start (Call the customer,...)

 string

Max length: 4000
id2

Internal ID (numeric). Will be used if reference_back_office is empty

 integer
db_address_id

globally unique identifier
db_address_name

string

Max length: 100
db_address_street

string

Max length: 50
db_address_street2

Bus

 string

Max length: 100
db_address_street_number

string

Max length: 50
db_address_db_country_id

globally unique identifier
db_address_city

string

Max length: 50
db_address_zip

string

Max length: 50
db_address_phone

string

Max length: 50
db_address_email

string

Max length: 250
dateutc_max_sla_hands_on_machine

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
dateutc_max_sla_resolution

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
dateutc_create

Needed to know what is my actual percentage of time used

 date
hands_on_machine_time

integer
estimated_time

integer
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
total_time_planned

integer
customer_reference

string

Max length: 50
requested_by_company_id

globally unique identifier
requested_by_company_name

string
requested_by_company_street

string
requested_by_company_street2

string
requested_by_company_street_number

string
requested_by_company_zip

string
requested_by_company_city

string
requested_by_company_phone

string
requested_by_company_email

string
requested_by_company_country_id

globally unique identifier
requested_by_contact_id

globally unique identifier
requested_by_contact_firstname

string
requested_by_contact_lastname

string
requested_by_contact_phone

string
requested_by_contact_mobile

string
requested_by_contact_email

string
approval_responsible_user_id

globally unique identifier
contact_id

globally unique identifier
company_id

globally unique identifier
company_code

string

Max length: 50
company_name

string

Max length: 255
date_closed

date
dateutc_closed

date
source_db_table_id

globally unique identifier
source_id_in_table

globally unique identifier
suggested_date_start

The suggested date+time when creating a wo

 date
agreed_time

Time, in minute, agreed with the customer

 integer
bill_to_party

Used to know which party is the bill to. cf task.bill_to_party

 string

Max length: 255
db_address_latitude_decimal

needed to have an optimized MyWoList , tab Route

 decimal number
db_address_longitude_decimal

needed to have an optimized MyWoList , tab Route

 decimal number
estimated_quantity_remark

string

Max length: 4000
date_update

date
_parent_id

Foreign key in case of grouped WorkOrder

 globally unique identifier
root_parent_id

globally unique identifier
has_child

boolean
service_model_id

Service model id

 globally unique identifier
wo_service_type

For short/detailed service on group wo

 string
suggested_user_id

globally unique identifier
created_by_user_id

globally unique identifier
next_job_planning_id

globally unique identifier
dateutc_max_sla_contact

date
date_reported_by_company

date
dateutc_in_progress

date
updated_by_user_id

globally unique identifier
earliest_date_plannable

Earliest date for planning

 date
due_date

Due date for planning

 date
sys_wi_generation_in_progress

flag for checking WIs are generating or not

 boolean
dateutc_reopened

The last reopened job date

 date
bill_to_company_id

globally unique identifier
udf1

string

Max length: 4000
udf2

string

Max length: 4000
udf3

string

Max length: 4000
udf4

string

Max length: 4000
udf5

string

Max length: 4000
udf6

string

Max length: 4000
udf7

string

Max length: 4000
udf8

string

Max length: 4000
udf9

string

Max length: 4000
udf10

string

Max length: 4000
udf11

string

Max length: 4000
udf12

string

Max length: 4000
udf13

string

Max length: 4000
udf14

string

Max length: 4000
udf15

string

Max length: 4000
udf16

string

Max length: 4000
udf17

string

Max length: 4000
udf18

string

Max length: 4000
udf19

string

Max length: 4000
udf20

string

Max length: 4000
udf21

string

Max length: 4000
udf22

string

Max length: 4000
udf23

string

Max length: 4000
udf24

string

Max length: 4000
udf25

string

Max length: 4000
udf26

string

Max length: 4000
udf27

string

Max length: 4000
udf28

string

Max length: 4000
udf29

string

Max length: 4000
udf30

string

Max length: 4000
udf31

string

Max length: 4000
udf32

string

Max length: 4000
udf33

string

Max length: 4000
udf34

string

Max length: 4000
udf35

string

Max length: 4000
udf36

string

Max length: 4000
udf37

string

Max length: 4000
udf38

string

Max length: 4000
udf39

string

Max length: 4000
udf40

string

Max length: 4000
udf41

string

Max length: 4000
udf42

string

Max length: 4000
udf43

string

Max length: 4000
udf44

string

Max length: 4000
udf45

string

Max length: 4000
udf46

string

Max length: 4000
udf47

string

Max length: 4000
udf48

string

Max length: 4000
udf49

string

Max length: 4000
udf50

string

Max length: 4000
udf51

string

Max length: 4000
udf52

string

Max length: 4000
udf53

string

Max length: 4000
udf54

string

Max length: 4000
udf55

string

Max length: 4000
udf56

string

Max length: 4000
udf57

string

Max length: 4000
udf58

string

Max length: 4000
udf59

string

Max length: 4000
udf60

string

Max length: 4000
udf61

string

Max length: 4000
udf62

string

Max length: 4000
udf63

string

Max length: 4000
udf64

string

Max length: 4000
udf65

string

Max length: 4000
udf66

string

Max length: 4000
udf67

string

Max length: 4000
udf68

string

Max length: 4000
udf69

string

Max length: 4000
udf70

string

Max length: 4000
udf71

string

Max length: 4000
udf72

string

Max length: 4000
udf73

string

Max length: 4000
udf74

string

Max length: 4000
udf75

string

Max length: 4000
udf76

string

Max length: 4000
udf77

string

Max length: 4000
udf78

string

Max length: 4000
udf79

string

Max length: 4000
udf80

string

Max length: 4000
udf81

string

Max length: 4000
udf82

string

Max length: 4000
udf83

string

Max length: 4000
udf84

string

Max length: 4000
udf85

string

Max length: 4000
udf86

string

Max length: 4000
udf87

string

Max length: 4000
udf88

string

Max length: 4000
udf89

string

Max length: 4000
udf90

string

Max length: 4000
udf91

string

Max length: 4000
udf92

string

Max length: 4000
udf93

string

Max length: 4000
udf94

string

Max length: 4000
udf95

string

Max length: 4000
udf96

string

Max length: 4000
udf97

string

Max length: 4000
udf98

string

Max length: 4000
udf99

string

Max length: 4000
udf100

string

Max length: 4000