| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| db_title_id |
Foreign key of the user's title/salutation (e.g. Mr, Mrs, Dr). |
globally unique identifier | |
| db_language_id |
Foreign key of db_language |
globally unique identifier | |
| article_order_channel_rule_id |
Foreign key of the article order channel rule that governs what this user is allowed to order. |
globally unique identifier | |
| firstname |
Firstname of the user |
string |
Max length: 255 |
| lastname |
Lastname of the user |
string |
Required Max length: 255 |
| archived |
Archive the user if he is not valid anymore (user cannot be deleted) |
boolean | |
| functions |
HR : Functions of the user (Manager, Tech leader) |
string |
Max length: 255 |
|
Email of the user |
string |
Required Max length: 255 |
|
| phone |
Phone number of the user |
string |
Max length: 50 |
| fax |
Fax number of the user |
string |
Max length: 50 |
| mobile |
Mobile number of the user |
string |
Max length: 50 |
| sales_organization_id |
Foreign key of the sales organization this user belongs to. |
globally unique identifier | |
| car_id |
Foreign key of the car assigned to this user. |
globally unique identifier | |
| user_picture |
Photo/picture of the user, as raw image bytes. |
Collection of byte | |
| birthdate |
Date of birth of the user. |
date | |
| private_street |
Street of the user's private address. |
string | |
| private_street_number |
Street number of the user's private address. |
string | |
| private_zip |
Zip/postal code of the user's private address. |
string | |
| private_city |
City of the user's private address. |
string | |
| private_db_country_id |
Foreign key of the country of the user's private address. |
globally unique identifier | |
| office_db_address_id |
Foreign key of the user's office/branch address. |
globally unique identifier | |
| office_street |
Street of the user's office address. |
string | |
| office_street_number |
Street number of the user's office address. |
string | |
| office_zip |
Zip/postal code of the user's office address. |
string | |
| office_city |
City of the user's office address. |
string | |
| office_db_country_id |
Foreign key of the country of the user's office address. |
globally unique identifier | |
| user_group_id |
Foreign key of the user group this user belongs to, controlling default permissions. |
globally unique identifier | |
| default_starting_point |
This is to known what is the default departure of the user |
string | |
| skype |
Skype account |
string | |
| is_team_leader |
Is team leader? |
boolean | |
| user_team_id |
Team Id |
globally unique identifier | |
| user_type_id |
User type id |
globally unique identifier | |
| allowed_in_api |
Indicates whether this user is allowed to authenticate against the API. |
boolean | |
| sys_working_hours |
Internal field used to store the working hours of a user. Will be used to know if user is actually working or not (for gps) |
string | |
| licence_user_type_code |
This will be needed to be able to detect if the logged user is a "normal fsa user means power user", or a timesheet user (mainly access to hr timer) or subcontractor (mainly my wo list) |
string | |
| culture_settings |
Specify how to display value depending not anymore on the culture of the device but on the user itself. |
string | |
| allow_service_app |
allowed using app? |
boolean | |
| is_superadmin |
Indicates whether this user has super-administrator privileges. |
boolean | |
| global_json |
User settings stored as JSON, sourced from user_settings.global_json (join on user id) |
string | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| terms_accepted_dateutc |
UTC date and time the user accepted the terms and conditions. |
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 |