NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier

Required
db_language_id

Foreign key of db_language

 globally unique identifier
username

Username of the user, normally his email address

 string

Required

Max length: 255
firstname

Firstname of the user

 string

Max length: 255
lastname

Lastname of the user

 string

Required

Max length: 255
code

The Id/Ref of the back office. Used by Embedded entity

 string

Max length: 50
archived

Archive the user if he is not valid anymore (user cannot be deleted)

 boolean
disabled

Disable temporaly the user (cannot log on)

 boolean
emergency_contact

HR : Person to contact in case of emergency (wife,husband)

 string

Max length: 64
bankaccount

HR : Bank Account

 string

Max length: 50
social_security

HR : Social Security Number

 string

Max length: 50
place_of_birth

HR : place of birth

 string

Max length: 255
nationality

HR : nationality of the user

 string

Max length: 255
functions

HR : Functions of the user (Manager, Tech leader)

 string

Max length: 255
birthdate

HR : Birthdate of the user

 date
skype

Skype name

 string

Max length: 50
notes

Internal notes/remarks

 string
sales_organization_id

Main organization of the user

 globally unique identifier

Optionally required : sales_organization_id, sales_organization_code or sales_organization must be provided
sales_organization

Embedded entity "sales_organization" when adding/updating user

 sales_organization

Optionally required : sales_organization_id, sales_organization_code or sales_organization must be provided
sales_organization_code

Embedded entity "sales_organization" using ERP PK when adding/updating user

 string

Optionally required : sales_organization_id, sales_organization_code or sales_organization must be provided
is_team_leader

Specify if this user can be used as a team leader

 boolean
team_leader_user_id

Specify his team leader if this user is a team member

 globally unique identifier
email

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
private_email

Private Email of the user

 string

Max length: 250
private_phone

Private Phone number of the user

 string

Max length: 50
private_fax

Private Fax number of the user

 string

Max length: 50
private_mobile

Private Mobile number of the user

 string

Max length: 50
private_street

Private Address:Street

 string

Max length: 50
private_street_number

Private Address:Street Number

 string

Max length: 50
private_city

Private Address:City

 string

Max length: 50
private_zip

Private Address:Zip

 string

Max length: 50
private_db_country_id

Private Address:Country

 globally unique identifier
private_db_country_code

Private Address:CountryCode entity using international code when adding/updating user

 string
modified_dateutc

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

 date
allow_hero_app

Specify if this user has priviliages to hero app

 boolean
allow_sales_app

Specify if this user has priviliages to salse app

 boolean
allow_service_app

Specify if this user has priviliages to service app

 boolean
user_group_id

Specify the user group that user belongs to

 globally unique identifier