| FIRSTNAME |
nvarchar(255) |
|
Default = '' |
First Name of the Contact Record |
| LASTNAME |
nvarchar(255) |
|
Default = '' |
Last Name of the Contact Record |
| MIDDLENAME |
nvarchar(100) |
|
Default = '' |
Middle Name of the Contact Record |
| SALUTATION |
nvarchar(255) |
|
Default = '' |
Salutation for the Contact Record |
| EMAILADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
Email Address of the Contact Record |
| HOMEPHONE |
nvarchar(25) |
|
Default = '' |
Primary Phone number of the Contact Record |
| CELLPHONE |
nvarchar(25) |
|
Default = '' |
Cell Phone number of the Contact Record |
| ADDRESSBLOCK |
nvarchar(300) |
|
Default = '' |
Street Name and Number for the Contact Address |
| CITY |
nvarchar(100) |
|
Default = '' |
City name for the Contact Address |
| POSTCODE |
nvarchar(24) |
|
Default = '' |
Postal/ZIP Code for the Contact Address |
| PREFERREDCOMMUNICATIONCODE |
tinyint |
|
Default = 1 |
Preferred communication method for contact |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| PREFERREDCOMMUNICATION |
nvarchar(12) (Computed) |
yes |
CASE [PREFERREDCOMMUNICATIONCODE] WHEN 1 THEN N'Email' WHEN 2 THEN N'Home Phone' WHEN 3 THEN N'Cell Phone' WHEN 4 THEN N'Regular Mail' WHEN 5 THEN N'Other' END |
Provides a translation for the 'PREFERREDCOMMUNICATIONCODE' field. |
| TEXTMESSAGESEND |
bit |
|
Default = 1 |
Indicates whether the contact receives text messages |
| BUSINESSPHONE |
nvarchar(25) |
|
Default = '' |
Business number of the Contact Record |
| BUSINESSADDRESS |
nvarchar(300) |
|
Default = '' |
Street Name and Number for the Business Address |
| SECONDARYEMAILADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
Secondary Email Address of the Record |
| SECONDARYCITY |
nvarchar(100) |
|
Default = '' |
Secondary City name for the Contact Address |
| SECONDARYPOSTCODE |
nvarchar(24) |
|
Default = '' |
Secondary Postal/ZIP Code for the Contact Address |
| COMPANYNAME |
nvarchar(255) |
|
Default = '' |
Company name |
| NOTES |
nvarchar(1000) |
|
Default = '' |
Notes |