Clients
| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 255 | yes | yes | Client ID | |
| is_active | boolean | no | yes | true/false | Is client active The most common examples for our system for inactive clients: Deceased clients should be tagged as 'false' as they are classed as inactive in our system. Clients that the business no longer wants to service should also be classed as 'false'. Clients that have been soft deleted in the source system should be classed as 'false'. | |
| title | varchar | 40 | no | no | Title | |
| first_name | varchar | 50 | no | no | First name | |
| last_name | varchar | 255 | no | yes | Last name | |
| street | varchar | 255 | no | no | Street | |
| postcode | varchar | 20 | no | no | Postcode | |
| city | varchar | 255 | no | no | City | |
| state | varchar | 255 | no | no | State | |
| 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 |
Example CSV-File: clients.csv