Clients Address Table Formats (CLAddress)
Follow Ajera CRM specifications for preparing a file containing client addresses.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| ClientID | varchar | 32 | Internal reference number for the Client record; required field; primary key; must exist in CL (ClientID/Client) |
| Address | varchar | 20 | Unique identifier for the address record; required field; primary key |
| Address1 | varchar | 50 | First line of the client address |
| Address2 | varchar | 50 | Second line of the client address |
| Address3 | varchar | 50 | Third line of the client address |
| Address4 | varchar | 50 | Fourth line of the client address |
| Addressee | varchar | 50 | Invoice addressee; not used |
| City | varchar | 30 | Client city |
| State | varchar | 10 | Client state.
The state must exist in CFGStates. If you import both state and country, that combination must already be a valid combination in Ajera CRM. If you import a state but not a country, the state must be a valid state for the United States. |
| ZIP | varchar | 10 | Client zip code |
| Country | varchar | 40 | Client country |
| Phone | varchar | 24 | Client telephone number |
| FAX | varchar | 24 | Client fax number |
| varchar | 50 | Client email address |