| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| _parent_id |
Empty or filled with the parent |
globally unique identifier | |
| root_parent_id |
Empty of filled with the top root parent |
globally unique identifier | |
| name |
Name |
string |
Max length: 255 |
| equipment_family_id |
Foreign key to equipment_family |
globally unique identifier |
Optionally required : equipment_family_id, equipment_family_code or equipment_family must be provided |
| equipment_family_name |
equipment_family.equipment_family_name |
string | |
| company_id |
The company owner of this project/installation |
globally unique identifier |
Optionally required : company_id, company_code or company must be provided |
| description |
Long description |
string | |
| reference_back_office |
The Id/Ref of the back office for this project/installation. Used by Embedded entity |
string |
Max length: 255 |
| serial_number |
Serial number |
string |
Max length: 255 |
| barcode |
Barcode |
string |
Max length: 50 |
| date_start_production |
Date project/installation becomes active |
date | |
| warranty_date_until |
End date of the warranty (if applicable) |
date | |
| date_built |
Build date of the installation (if applicable) |
date | |
| shutdown_consequence |
Consequence of the installation is shut down (CEO has no air cooling anymore,..) |
string |
Max length: 4000 |
| id2 |
Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| contact_id |
Foreign key of the contact linked to this project/installation. |
globally unique identifier | |
| is_mobile_installation |
Indicates this installation is mobile (e.g. mounted on a vehicle) rather than fixed at a single address. |
boolean | |
| location |
Free-text description of where on-site the installation is located (e.g. "Basement, room 3"). |
string |
Max length: 255 |
| contract_id |
Foreign key of the contract covering this project/installation. |
globally unique identifier | |
| db_address_id |
Foreign key of the address where this project/installation is located. |
globally unique identifier | |
| project_status_id |
Foreign key of the current status of this project/installation. |
globally unique identifier | |
| owner_user_id |
Foreign key of the user who owns/manages this project/installation. |
globally unique identifier | |
| equipment_model_id |
Foreign key of the equipment model installed for this project. |
globally unique identifier | |
| replacement_date |
Planned or actual date this installation is to be replaced. |
date | |
| customer_reference |
Customer's own reference/identifier for this project/installation. |
string |
Max length: 50 |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| has_child |
Indicates whether this project has one or more sub-projects nested under it (see ). |
boolean | |
| 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 |