| Name | Description | Type | Additional 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 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 |