Field | Type | Length | Unique | Description |
---|---|---|---|---|
company_identifier | varchar | 255 | yes | Client ID |
is_active | boolean | true/false | no | Is client active |
person_honorific_prefix | varchar | 40 | no | Title |
person_given_name | varchar | 50 | no | First name |
person_family_name | varchar | 255 | no | Last name |
main_address_street | varchar | 255 | no | Street |
main_address_postcode | varchar | 20 | no | Postcode |
main_address_city | varchar | 255 | no | City |
main_address_state | varchar | 255 | no | State |
main_address_country | varchar | 255 | no | Country |
telephone | varchar | 40 | no | Phone number |
mobile_phone | varchar | 40 | no | Mobile phone |
varchar | 80 | no | Email Address |
Example CSV-File: