| Name | Description | Type | Additional 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 |
Foreign key of the db_address (service location) where the job takes place. |
globally unique identifier | |
| db_address_name |
Name/label of the service address (denormalized copy of the address record). |
string |
Max length: 100 |
| db_address_street |
Street of the service address (denormalized copy of the address record). |
string |
Max length: 50 |
| db_address_street2 |
Bus |
string |
Max length: 100 |
| db_address_street_number |
Street/house number of the service address (denormalized copy of the address record). |
string |
Max length: 50 |
| db_address_db_country_id |
Foreign key of the country of the service address. |
globally unique identifier | |
| db_address_city |
City of the service address (denormalized copy of the address record). |
string |
Max length: 50 |
| db_address_zip |
Zip/postal code of the service address (denormalized copy of the address record). |
string |
Max length: 50 |
| db_address_phone |
Phone number at the service address (denormalized copy of the address record). |
string |
Max length: 50 |
| db_address_email |
Email address at the service address (denormalized copy of the address record). |
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 |
Actual time spent by the technician with hands on the machine/equipment, in minutes. |
integer | |
| estimated_time |
Estimated total duration of the job, in minutes. |
integer | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| total_time_planned |
Total planned duration across all slots for this job, in minutes. |
integer | |
| customer_reference |
Customer's own reference/identifier for this job, truncated to 50 characters on assignment. |
string |
Max length: 50 |
| requested_by_company_id |
Foreign key of the company that requested this job. |
globally unique identifier | |
| requested_by_company_name |
Name of the requesting company (denormalized copy of the company record). |
string | |
| requested_by_company_street |
Street of the requesting company's address (denormalized copy of the company record). |
string | |
| requested_by_company_street2 |
Bus/second address line of the requesting company's address (denormalized copy of the company record). |
string | |
| requested_by_company_street_number |
Street/house number of the requesting company's address (denormalized copy of the company record). |
string | |
| requested_by_company_zip |
Zip/postal code of the requesting company's address (denormalized copy of the company record). |
string | |
| requested_by_company_city |
City of the requesting company's address (denormalized copy of the company record). |
string | |
| requested_by_company_phone |
Phone number of the requesting company (denormalized copy of the company record). |
string | |
| requested_by_company_email |
Email address of the requesting company (denormalized copy of the company record). |
string | |
| requested_by_company_country_id |
Foreign key of the country of the requesting company's address. |
globally unique identifier | |
| requested_by_contact_id |
Foreign key of the contact that requested this job. |
globally unique identifier | |
| requested_by_contact_firstname |
First name of the requesting contact (denormalized copy of the contact record). |
string | |
| requested_by_contact_lastname |
Last name of the requesting contact (denormalized copy of the contact record). |
string | |
| requested_by_contact_phone |
Phone number of the requesting contact (denormalized copy of the contact record). |
string | |
| requested_by_contact_mobile |
Mobile phone number of the requesting contact (denormalized copy of the contact record). |
string | |
| requested_by_contact_email |
Email address of the requesting contact (denormalized copy of the contact record). |
string | |
| approval_responsible_user_id |
Foreign key of the user responsible for approving this job. |
globally unique identifier | |
| contact_id |
Foreign key of the primary contact for this job (e.g. on-site contact). |
globally unique identifier | |
| company_id |
Foreign key of the company the job is performed for (customer). |
globally unique identifier | |
| company_code |
Back-office code of the company (denormalized copy of the company record). |
string |
Max length: 50 |
| company_name |
Name of the company (denormalized copy of the company record). |
string |
Max length: 255 |
| date_closed |
Local date and time the job was closed. |
date | |
| dateutc_closed |
Readonly system field: UTC date and time the job was closed. |
date | |
| source_db_table_id |
Identifier of the source database table this job was generated from, when created via integration/automation. |
globally unique identifier | |
| source_id_in_table |
Primary key of the source record (in the table identified by ) this job was generated from. |
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 |
Free-text remark explaining/qualifying the estimated quantities recorded on this job's lines. |
string |
Max length: 4000 |
| date_update |
Local date and time of the last update to this job. |
date | |
| _parent_id |
Foreign key in case of grouped WorkOrder |
globally unique identifier | |
| root_parent_id |
Foreign key of the top-most ancestor job in a grouped Work Order hierarchy (see ). |
globally unique identifier | |
| has_child |
Indicates whether this job has one or more child jobs grouped under it. |
boolean | |
| service_model_id |
Service model id |
globally unique identifier | |
| wo_service_type |
For short/detailed service on group wo |
string | |
| suggested_user_id |
Foreign key of the user suggested (e.g. by planning/dispatch logic) to perform this job. |
globally unique identifier | |
| created_by_user_id |
Foreign key of the user who created this job. |
globally unique identifier | |
| next_job_planning_id |
Foreign key of the next planned slot for this job. |
globally unique identifier | |
| dateutc_max_sla_contact |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| date_reported_by_company |
Local date and time the job was reported by the requesting company. |
date | |
| dateutc_in_progress |
Readonly system field: UTC date and time the job was put in progress. |
date | |
| updated_by_user_id |
Foreign key of the user who last updated this job. |
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 |
Foreign key of the company that should be billed for this job, when different from (see ). |
globally unique identifier | |
| udf1 |
Custom user-defined text field #1. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf2 |
Custom user-defined text field #2. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf3 |
Custom user-defined text field #3. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf4 |
Custom user-defined text field #4. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf5 |
Custom user-defined text field #5. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf6 |
Custom user-defined text field #6. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf7 |
Custom user-defined text field #7. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf8 |
Custom user-defined text field #8. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf9 |
Custom user-defined text field #9. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf10 |
Custom user-defined text field #10. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf11 |
Custom user-defined text field #11. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf12 |
Custom user-defined text field #12. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf13 |
Custom user-defined text field #13. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf14 |
Custom user-defined text field #14. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf15 |
Custom user-defined text field #15. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf16 |
Custom user-defined text field #16. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf17 |
Custom user-defined text field #17. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf18 |
Custom user-defined text field #18. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf19 |
Custom user-defined text field #19. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf20 |
Custom user-defined text field #20. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf21 |
Custom user-defined text field #21. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf22 |
Custom user-defined text field #22. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf23 |
Custom user-defined text field #23. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf24 |
Custom user-defined text field #24. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf25 |
Custom user-defined text field #25. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf26 |
Custom user-defined text field #26. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf27 |
Custom user-defined text field #27. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf28 |
Custom user-defined text field #28. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf29 |
Custom user-defined text field #29. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf30 |
Custom user-defined text field #30. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf31 |
Custom user-defined text field #31. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf32 |
Custom user-defined text field #32. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf33 |
Custom user-defined text field #33. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf34 |
Custom user-defined text field #34. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf35 |
Custom user-defined text field #35. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf36 |
Custom user-defined text field #36. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf37 |
Custom user-defined text field #37. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf38 |
Custom user-defined text field #38. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf39 |
Custom user-defined text field #39. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf40 |
Custom user-defined text field #40. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf41 |
Custom user-defined text field #41. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf42 |
Custom user-defined text field #42. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf43 |
Custom user-defined text field #43. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf44 |
Custom user-defined text field #44. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf45 |
Custom user-defined text field #45. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf46 |
Custom user-defined text field #46. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf47 |
Custom user-defined text field #47. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf48 |
Custom user-defined text field #48. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf49 |
Custom user-defined text field #49. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf50 |
Custom user-defined text field #50. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf51 |
Custom user-defined text field #51. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf52 |
Custom user-defined text field #52. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf53 |
Custom user-defined text field #53. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf54 |
Custom user-defined text field #54. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf55 |
Custom user-defined text field #55. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf56 |
Custom user-defined text field #56. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf57 |
Custom user-defined text field #57. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf58 |
Custom user-defined text field #58. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf59 |
Custom user-defined text field #59. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf60 |
Custom user-defined text field #60. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf61 |
Custom user-defined text field #61. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf62 |
Custom user-defined text field #62. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf63 |
Custom user-defined text field #63. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf64 |
Custom user-defined text field #64. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf65 |
Custom user-defined text field #65. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf66 |
Custom user-defined text field #66. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf67 |
Custom user-defined text field #67. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf68 |
Custom user-defined text field #68. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf69 |
Custom user-defined text field #69. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf70 |
Custom user-defined text field #70. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf71 |
Custom user-defined text field #71. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf72 |
Custom user-defined text field #72. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf73 |
Custom user-defined text field #73. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf74 |
Custom user-defined text field #74. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf75 |
Custom user-defined text field #75. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf76 |
Custom user-defined text field #76. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf77 |
Custom user-defined text field #77. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf78 |
Custom user-defined text field #78. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf79 |
Custom user-defined text field #79. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf80 |
Custom user-defined text field #80. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf81 |
Custom user-defined text field #81. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf82 |
Custom user-defined text field #82. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf83 |
Custom user-defined text field #83. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf84 |
Custom user-defined text field #84. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf85 |
Custom user-defined text field #85. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf86 |
Custom user-defined text field #86. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf87 |
Custom user-defined text field #87. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf88 |
Custom user-defined text field #88. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf89 |
Custom user-defined text field #89. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf90 |
Custom user-defined text field #90. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf91 |
Custom user-defined text field #91. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf92 |
Custom user-defined text field #92. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf93 |
Custom user-defined text field #93. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf94 |
Custom user-defined text field #94. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf95 |
Custom user-defined text field #95. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf96 |
Custom user-defined text field #96. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf97 |
Custom user-defined text field #97. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf98 |
Custom user-defined text field #98. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf99 |
Custom user-defined text field #99. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf100 |
Custom user-defined text field #100. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |