 | Address Line 1 | VARCHAR(40) | Null | For individuals the first line of the address may be used for the company name particularly for consultants. |
 | Address Line 2 | VARCHAR(40) | Null | - |
 | City | VARCHAR(15) | Null | The name of the city or town. |
 | Comments | VARCHAR(2000) | Null | Our comments concerning the person or company |
 | Country | VARCHAR(20) | Null | The address country. Default: Canada |
 | Creation Date | datetime | Null | The date the record was created. |
 | Creation User Name | VARCHAR(15) | Null | The name of the relevant user as used for logging into the system, e.g jtench. |
 | Edit Date | datetime | Null | The date the record was last edited. |
 | Edit User Name | VARCHAR(15) | Null | The name of the relevant user as used for logging into the system, e.g jtench. |
 | Email Address | VARCHAR(50) | Null | An email address in the format local-part@domain-name |