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
email	varchar	80	no	no		Email Address

Example CSV-File: clients.csv

ProfitDiagnostix Public knowledge base