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