| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| archived |
Archive this company to not have it anymore on the search |
boolean | |
| name |
Name of the company. |
string |
Max length: 64 |
| notes |
Notes/Remark field |
string | |
| create_date |
Creation date+time |
date | |
| sales_territory_id |
Foreign key of the sales territory this company belongs to. |
globally unique identifier | |
| marketing_segment_id |
Marketing Segment of the company (Sales (Visit frequency logic) +Services (Planning Jobs To Be Planned) ) |
globally unique identifier | |
| sales_organization_id |
Foreign key of the sales organization this company belongs to. |
globally unique identifier | |
| sys_opening_hours |
Readonly: computed/normalized representation of the company's opening hours, derived from . |
string | |
| opening_hours |
Serialized configuration of the company's opening hours. |
string | |
| vat_reg_code |
VAT number |
string |
Max length: 50 |
| credit_limit |
Maximum outstanding balance allowed for this company before further orders/jobs may be blocked. |
decimal number | |
| article_price_label_id |
Foreign key of the default price label used to price articles for this company. |
globally unique identifier | |
| article_order_channel_rule_id |
Foreign key of the article order channel rule that governs what this company is allowed to order. |
globally unique identifier | |
| is_working_address |
Services : If False, you cannot create project/installation on this company.Default=true |
boolean | |
| parent_id |
Reference to a parent company (in case of Child/Parent) when adding/updating company |
globally unique identifier | |
| phone |
Phone number of the company |
string |
Max length: 50 |
| mobile |
Mobile phone number of the company. |
string | |
| fax |
Fax number of the company |
string |
Max length: 50 |
| url |
URL of the company website |
string |
Max length: 255 |
|
|
string |
Max length: 250 |
|
| street |
Address:Street |
string |
Max length: 100 |
| street2 |
Bus |
string |
Max length: 100 |
| street_number |
Address:Street Number. If your ERP doesn't have this field, then only use field "street" and disable the street number on Odyssee/Admin/Impl Settings/Global Settings:Hide Street Number |
string |
Max length: 50 |
| city |
Address:City |
string |
Max length: 50 |
| zip |
Address:Zip |
string |
Max length: 50 |
| db_state_id |
Foreign key of the state/province of the company's address. |
globally unique identifier | |
| db_country_id |
Address:Country |
globally unique identifier | |
| latitude_decimal |
Latitude of the company's address, used for map display and route optimization. |
decimal number | |
| longitude_decimal |
Longitude of the company's address, used for map display and route optimization. |
decimal number | |
| company_sales_status_id |
Foreign key of the company's current sales status. |
globally unique identifier | |
| company_discount_family_id |
Foreign key of the discount family this company belongs to. |
globally unique identifier | |
| discount |
Default discount percentage applied to this company's orders/jobs. |
decimal number | |
| company_type_id |
Company Type |
globally unique identifier | |
| db_language_id |
Language of the company.If empty, will use the default on the system |
globally unique identifier | |
| code |
Field used for Embedded entity (store there your ERP PK) |
string |
Max length: 50 |
| feelist_id |
Foreign key of the default fee list used to price hour-based work for this company. |
globally unique identifier | |
| db_payment_method_id |
Foreign key of the company's default payment method. |
globally unique identifier | |
| company_picture |
Logo/picture of the company, as raw image bytes. |
Collection of byte | |
| is_client |
Indicates this company is an active client (as opposed to e.g. a prospect or supplier). |
boolean | |
| account_manager_user_id |
Foreign key of the user acting as account manager for this company. |
globally unique identifier | |
| create_by_user_id |
Foreign key of the user who created this company. |
globally unique identifier | |
| company_vat_id |
Foreign key of the default VAT regime applied to this company. |
globally unique identifier | |
| finance_manager_user_id |
Foreign key of the user acting as finance manager for this company. |
globally unique identifier | |
| service_manager_user_id |
Foreign key of the user acting as service manager for this company. |
globally unique identifier | |
| sys_sales_territory_id_changed |
Readonly: indicates the sales_territory_id has changed and dependent data needs to be recomputed. |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| 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 |