tm.contactaddress
Fields
| Field | 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 |