NameDescriptionTypeAdditional information
id

Primary key

 globally unique identifier
company_id

The company owner of this address

 globally unique identifier

Optionally required : company_id, company_code or company must be provided
company_code

Embedded entity "company" using ERP PK when adding/updating address

 string

Optionally required : company_id, company_code or company must be provided
company

Embedded entity "company" when adding/updating address

 company

Optionally required : company_id, company_code or company must be provided
db_address_type_id

Foreign key to the db_address_type. Please use controller DbAddressType to find the correct it to use

 globally unique identifier
code

Field used for Embedded entity (store there your ERP PK)

 string
archived

You cannot delete an address. The only way is to archive it.

 boolean
name

Name of the address

 string
street

Street

 string

Max length: 100
street_number

Street number. Can be not used

 string

Max length: 50
zip

Zip code

 string

Max length: 50
city

City

 string

Max length: 50
phone

Phone number

 string
mobile

Cell phone number

 string
fax

Fax number

 string
email

Email address

 string

Max length: 250
url

Url

 string
db_country_id

Foreign key to table Country

 globally unique identifier
db_country_code

CountryCode entity using international code when adding/updating company

 string
street2

Additional information on the address not part of the postal address

 string

Max length: 50
modified_dateutc

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

 date