NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier
_parent_id

Reference to a parent job (in case of Multi Job)

 globally unique identifier
_parent_job

Embedded entity "job" for parent (multi job level) when adding/updating job

 jobs
_parent_jobs_reference_back_office

Embedded entity "job" for parent (multi job level) using ERP PK when adding/updating job

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

Embedded entity "project" using ERP PK when adding/updating job

 string

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

Embedded entity "project" when adding/updating job

 project

Optionally required : project_id, project_reference_back_office or project must be provided
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_type_code

Embedded entity "job_type" using ERP PK when adding/updating job

 string

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

Embedded entity "job_type" when adding/updating job

 job_type

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

Foreign key of job priority for this job

 globally unique identifier
job_priority_code

Foreign key of job status for this job. If you don't know the GUID, use job_type_code

 string
job_priority

Embedded entity "job_priority" when adding/updating job

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

Foreign key of job status using code. Use "Canceled,ToBePlanned, Waiting, Pooling, Suggested, Activated or Open" If Status=Suggested AND suggested_user filled AND suggested_date_start filled THEN a job_planning will be added

 string

Optionally required : job_status_id or job_status_code must be provided
db_address_id

Foreign key of db_address if job is not on a mobile equipment.Must be the address_id of the location or the equipment

 globally unique identifier
contact_id

Foreign key of contact if the main contact of the job is different than the one of the project

 globally unique identifier
requested_by_company_id

Foreign key of company if a specific company makes the request for this job

 globally unique identifier
requested_by_contact_id

Foreign key of contact to specify why contact of the requested_company_id makes the request

 globally unique identifier
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
working_sequence

In case of mutli job, they will be ordered by this sequence

 integer
internal_memo

Internal field for communication between BackOffice/Planners/Technicians

 string
prejob_information

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

 string
estimated_time

Estimation of the time needed (in minute). Will be used for planning and statistic

 integer
earliest_date_plannable

Use this field if there is a minimum date for the planning (Not Before)

 date
due_date

Deadline of Max date for the planning (Not After)

 date
date_create

Creation date+time

 date
date_update

Update date+time

 date
date_closed

Date+time job goes to completed

 date
suggested_user_id

Foreign key of user if there is a suggested user (used for planning) If Status=Suggested AND suggested_user filled AND suggested_date_start filled THEN a job_planning will be added

 globally unique identifier
suggested_user_code

Embedded entity "suggested user" using ERP PK when adding/updating job

 string
suggested_user

Embedded entity "sugessted user" when adding/updating job

 user
suggested_date_start

Suggested date+time start (used for planning) If Status=Suggested AND suggested_user filled AND suggested_date_start filled THEN a job_planning will be added

 date
skill_id

Foreign key of skill if the job requires a specific skill (used for planning)

 globally unique identifier
skill_code

Embedded entity "skill" using ERP PK when adding/updating job

 string
skill

Embedded entity "skill" when adding/updating job

 skill
customer_reference

Reference of this job for the customer

 string

Max length: 50
approval_responsible_user_id

In case of multi user job, foreign key of user that is the "WO Leader"

 globally unique identifier
date_reported_by_company

Date+time when company reported the problem

 date
id2

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

 integer
company_id

This field will be filled automatically based on the project_id

 globally unique identifier
company_code

This field will be filled automatically based on the project_id

 string
db_address_name

When mobile equipment, the address to use

 string

Max length: 100
db_address_street

When mobile equipment, the address to use and this field is mandatory

 string

Max length: 50
db_address_street2

It is sub street

 string

Max length: 50
db_address_street_number

When mobile equipment, the address to use

 string

Max length: 50
db_address_city

When mobile equipment, the address to use and this field is mandatory

 string

Max length: 50
db_address_zip

When mobile equipment, the address to use and this field is mandatory

 string

Max length: 50
db_address_db_country_id

When mobile equipment, the address to use

 globally unique identifier
db_address_db_country_code

When mobile equipment, the address to use

 string
db_address_phone

When mobile equipment, the address to use

 string

Max length: 50
db_address_email

When mobile equipment, the address to use

 string

Max length: 250
db_address_latitude_decimal

Latitude

 decimal number
db_address_longitude_decimal

Latitude

 decimal number
estimated_quantity_remark

Description of the parts your technician should use or pick up

 string

Max length: 4000
bill_to_company_id

Company id for bill

 globally unique identifier
modified_dateutc

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

 date
udf1

Custom field udf1

 string
udf2

Custom field udf2

 string
udf3

Custom field udf3

 string
udf4

Custom field udf4

 string
udf5

Custom field udf5

 string
udf6

Custom field udf6

 string
udf7

Custom field udf7

 string
udf8

Custom field udf8

 string
udf9

Custom field udf9

 string
udf10

Custom field udf10

 string
udf11

Custom field udf11

 string
udf12

Custom field udf12

 string
udf13

Custom field udf13

 string
udf14

Custom field udf14

 string
udf15

Custom field udf15

 string
udf16

Custom field udf16

 string
udf17

Custom field udf17

 string
udf18

Custom field udf18

 string
udf19

Custom field udf19

 string
udf20

Custom field udf20

 string
udf21

Custom field udf21

 string
udf22

Custom field udf22

 string
udf23

Custom field udf23

 string
udf24

Custom field udf24

 string
udf25

Custom field udf25

 string
udf26

Custom field udf26

 string
udf27

Custom field udf27

 string
udf28

Custom field udf28

 string
udf29

Custom field udf29

 string
udf30

Custom field udf30

 string
udf31

Custom field udf31

 string
udf32

Custom field udf32

 string
udf33

Custom field udf33

 string
udf34

Custom field udf34

 string
udf35

Custom field udf35

 string
udf36

Custom field udf36

 string
udf37

Custom field udf37

 string
udf38

Custom field udf38

 string
udf39

Custom field udf39

 string
udf40

Custom field udf40

 string
udf41

Custom field udf41

 string
udf42

Custom field udf42

 string
udf43

Custom field udf43

 string
udf44

Custom field udf44

 string
udf45

Custom field udf45

 string
udf46

Custom field udf46

 string
udf47

Custom field udf47

 string
udf48

Custom field udf48

 string
udf49

Custom field udf49

 string
udf50

Custom field udf50

 string
udf51

Custom field udf51

 string
udf52

Custom field udf52

 string
udf53

Custom field udf53

 string
udf54

Custom field udf54

 string
udf55

Custom field udf55

 string
udf56

Custom field udf56

 string
udf57

Custom field udf57

 string
udf58

Custom field udf58

 string
udf59

Custom field udf59

 string
udf60

Custom field udf60

 string
udf61

Custom field udf61

 string
udf62

Custom field udf62

 string
udf63

Custom field udf63

 string
udf64

Custom field udf64

 string
udf65

Custom field udf65

 string
udf66

Custom field udf66

 string
udf67

Custom field udf67

 string
udf68

Custom field udf68

 string
udf69

Custom field udf69

 string
udf70

Custom field udf70

 string
udf71

Custom field udf71

 string
udf72

Custom field udf72

 string
udf73

Custom field udf73

 string
udf74

Custom field udf74

 string
udf75

Custom field udf75

 string
udf76

Custom field udf76

 string
udf77

Custom field udf77

 string
udf78

Custom field udf78

 string
udf79

Custom field udf79

 string
udf80

Custom field udf80

 string
udf81

Custom field udf81

 string
udf82

Custom field udf82

 string
udf83

Custom field udf83

 string
udf84

Custom field udf84

 string
udf85

Custom field udf85

 string
udf86

Custom field udf86

 string
udf87

Custom field udf87

 string
udf88

Custom field udf88

 string
udf89

Custom field udf89

 string
udf90

Custom field udf90

 string
udf91

Custom field udf91

 string
udf92

Custom field udf92

 string
udf93

Custom field udf93

 string
udf94

Custom field udf94

 string
udf95

Custom field udf95

 string
udf96

Custom field udf96

 string
udf97

Custom field udf97

 string
udf98

Custom field udf98

 string
udf99

Custom field udf99

 string
udf100

Custom field udf100

 string