NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier

Required
db_title_id

globally unique identifier
db_language_id

Foreign key of db_language

 globally unique identifier
article_order_channel_rule_id

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

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

globally unique identifier
car_id

globally unique identifier
user_picture

Collection of byte
birthdate

date
private_street

string
private_street_number

string
private_zip

string
private_city

string
private_db_country_id

globally unique identifier
office_db_address_id

globally unique identifier
office_street

string
office_street_number

string
office_zip

string
office_city

string
office_db_country_id

globally unique identifier
user_group_id

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

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

boolean
modified_dateutc

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

 date
terms_accepted_dateutc

terms_accepted_dateutc

 date
udf1

string

Max length: 4000
udf2

string

Max length: 4000
udf3

string

Max length: 4000
udf4

string

Max length: 4000
udf5

string

Max length: 4000
udf6

string

Max length: 4000
udf7

string

Max length: 4000
udf8

string

Max length: 4000
udf9

string

Max length: 4000
udf10

string

Max length: 4000
udf11

string

Max length: 4000
udf12

string

Max length: 4000
udf13

string

Max length: 4000
udf14

string

Max length: 4000
udf15

string

Max length: 4000
udf16

string

Max length: 4000
udf17

string

Max length: 4000
udf18

string

Max length: 4000
udf19

string

Max length: 4000
udf20

string

Max length: 4000
udf21

string

Max length: 4000
udf22

string

Max length: 4000
udf23

string

Max length: 4000
udf24

string

Max length: 4000
udf25

string

Max length: 4000
udf26

string

Max length: 4000
udf27

string

Max length: 4000
udf28

string

Max length: 4000
udf29

string

Max length: 4000
udf30

string

Max length: 4000
udf31

string

Max length: 4000
udf32

string

Max length: 4000
udf33

string

Max length: 4000
udf34

string

Max length: 4000
udf35

string

Max length: 4000
udf36

string

Max length: 4000
udf37

string

Max length: 4000
udf38

string

Max length: 4000
udf39

string

Max length: 4000
udf40

string

Max length: 4000
udf41

string

Max length: 4000
udf42

string

Max length: 4000
udf43

string

Max length: 4000
udf44

string

Max length: 4000
udf45

string

Max length: 4000
udf46

string

Max length: 4000
udf47

string

Max length: 4000
udf48

string

Max length: 4000
udf49

string

Max length: 4000
udf50

string

Max length: 4000
udf51

string

Max length: 4000
udf52

string

Max length: 4000
udf53

string

Max length: 4000
udf54

string

Max length: 4000
udf55

string

Max length: 4000
udf56

string

Max length: 4000
udf57

string

Max length: 4000
udf58

string

Max length: 4000
udf59

string

Max length: 4000
udf60

string

Max length: 4000
udf61

string

Max length: 4000
udf62

string

Max length: 4000
udf63

string

Max length: 4000
udf64

string

Max length: 4000
udf65

string

Max length: 4000
udf66

string

Max length: 4000
udf67

string

Max length: 4000
udf68

string

Max length: 4000
udf69

string

Max length: 4000
udf70

string

Max length: 4000
udf71

string

Max length: 4000
udf72

string

Max length: 4000
udf73

string

Max length: 4000
udf74

string

Max length: 4000
udf75

string

Max length: 4000
udf76

string

Max length: 4000
udf77

string

Max length: 4000
udf78

string

Max length: 4000
udf79

string

Max length: 4000
udf80

string

Max length: 4000
udf81

string

Max length: 4000
udf82

string

Max length: 4000
udf83

string

Max length: 4000
udf84

string

Max length: 4000
udf85

string

Max length: 4000
udf86

string

Max length: 4000
udf87

string

Max length: 4000
udf88

string

Max length: 4000
udf89

string

Max length: 4000
udf90

string

Max length: 4000
udf91

string

Max length: 4000
udf92

string

Max length: 4000
udf93

string

Max length: 4000
udf94

string

Max length: 4000
udf95

string

Max length: 4000
udf96

string

Max length: 4000
udf97

string

Max length: 4000
udf98

string

Max length: 4000
udf99

string

Max length: 4000
udf100

string

Max length: 4000