| Name | Description | Type | Additional information |
|---|---|---|---|
| ID |
Caliq internal unique identifier |
integer |
None. |
| Active |
Inactive addresses should not be used |
boolean |
None. |
| Alias |
Friendly name for the address |
string |
Max length: 30 |
| Main |
Is this the customers 'main' address? |
boolean |
None. |
| AllowBilling |
Can invoices be sent to this address? |
boolean |
None. |
| AllowDelivery |
Can goods be delivered to this address? |
boolean |
None. |
| Line1 | string |
Max length: 50 |
|
| Line2 | string |
Max length: 50 |
|
| Line3 | string |
Max length: 50 |
|
| Town | string |
Max length: 50 |
|
| County | string |
Max length: 25 |
|
| Country |
Country code, derived from country table ISO3 |
string |
Max length: 3 |
| Postcode | string |
Max length: 15 |
|
| VATReg |
Customers VAT reg number |
string |
Max length: 30 |
| VATClassification |
STD or EXEMPT |
string |
Max length: 6 |
| CountryForVAT |
Country code, derived from country table ISO2. Used in VAT calculations |
string |
Max length: 3 |
| Latitude |
Latitude of the address |
string |
Max length: 20 |
| Longitude |
Longitude of the address |
string |
Max length: 20 |
| CanTakePallets |
Can pallets be sent to this address? |
boolean |
None. |
| MustBookIn |
Deliveries to this address must be booked in? |
boolean |
None. |
| SalesRep |
Name of the sales representative for this address |
string |
Max length: 100 |
| SalesRepID |
ID of the sales representative for this address |
string |
Max length: 10 |
| AccountMgr |
Name of the account manager for this address |
string |
Max length: 100 |
| AccountMgrID |
ID of the account manager for this address |
string |
Max length: 10 |
| OfficeRep |
Name of the office representative for this address |
string |
Max length: 100 |
| OfficeRepID |
ID of the office representative for this address |
string |
Max length: 10 |
| Region |
Region for the address analysis. This is NOT to be used as part of the address - use county |
string |
Max length: 30 |
| UDF1 |
User defined field 1 |
string |
Max length: 40 |
| UDF2 |
User defined field 2 |
string |
Max length: 40 |
| UDF3 |
User defined field 3 |
string |
Max length: 40 |
| UDF4 |
User defined field 4 |
string |
Max length: 40 |
| UDF5 |
User defined field 5 |
string |
Max length: 40 |
| UDF6 |
User defined field 6 |
string |
Max length: 40 |
| UDF7 |
User defined field 7 |
string |
Max length: 40 |
| UDF8 |
User defined field 8 |
string |
Max length: 40 |
| UDF9 |
User defined field 9 |
string |
Max length: 40 |