...
| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| company_identifierid | varchar | 255 | yes | yes | Client ID | |
| is_active | boolean | no | yes | true/false | Is client active | |
| person_honorific_prefixtitle | varchar | 40 | no | no | Title | |
| personfirst_given_name | varchar | 50 | no | no | First name | |
| person_familylast_name | varchar | 255 | no | yes | Last name | |
| main_address_street | varchar | 255 | no | no | Street | |
| main_address_postcode | varchar | 20 | no | no | Postcode | |
| main_address_city | varchar | 255 | no | no | City | |
| main_address_state | varchar | 255 | no | no | State | |
| main_address_country | varchar | 255 | no | no | Country | |
| telephone | varchar | 40 | no | no | Phone number | |
| mobile_phone | varchar | 40 | no | no | Mobile phone | |
| varchar | 80 | no | no | Email Address |
...