tm.contactaddress
1 min
Each contact can have one or more addresses.
Fields
FIELD | TYPE | DESCRIPTION |
|---|---|---|
id | int | ID |
createdts | timestamp | Created timestamp |
lastupdatets | timestamp | Last update timestamp |
contactid | int | Contact this address is linked to References: tm.contact |
typeid | int | Type of address References: tm.contactaddresstype |
street1 | string | Street |
street2 | string | Number |
street3 | string | Box |
street4 | string | Extra address line |
zip | string | Zipcode |
city | string | City |
state | string | State |
countrycode | string | Country code. Should be an ISO 3166-1 alpha-2 two-letter code. References: tm.country |
sortorder | int | Sort order for the addresses. The address with sort order 0 is de main address |