NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier

Required
archived

Archive this company to not have it anymore on the search

 boolean
name

string

Max length: 64
notes

Notes/Remark field

 string
create_date

Creation date+time

 date
sales_territory_id

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

globally unique identifier
sys_opening_hours

string
opening_hours

string
vat_reg_code

VAT number

 string

Max length: 50
credit_limit

decimal number
article_price_label_id

globally unique identifier
article_order_channel_rule_id

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

string
fax

Fax number of the company

 string

Max length: 50
url

URL of the company website

 string

Max length: 255
email

email

 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

globally unique identifier
db_country_id

Address:Country

 globally unique identifier
latitude_decimal

decimal number
longitude_decimal

decimal number
company_sales_status_id

globally unique identifier
company_discount_family_id

globally unique identifier
discount

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

globally unique identifier
db_payment_method_id

globally unique identifier
company_picture

Collection of byte
is_client

boolean
account_manager_user_id

globally unique identifier
create_by_user_id

globally unique identifier
company_vat_id

globally unique identifier
finance_manager_user_id

globally unique identifier
service_manager_user_id

globally unique identifier
sys_sales_territory_id_changed

boolean
modified_dateutc

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

 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