NameDescriptionTypeAdditional information
id

Primary key

 globally unique identifier
name

Name of the address

 string

Max length: 50
street

Street

 string

Max length: 100
street2

Bus

 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

Max length: 50
mobile

Cell phone number

 string

Max length: 50
fax

Fax number

 string

Max length: 50
email

Email address

 string

Max length: 250
db_country_id

Foreign key to table Country

 globally unique identifier
latitude_decimal

decimal number
longitude_decimal

decimal number
archived

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

 boolean
modified_dateutc

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

 date