| FIELD NAME |
TYPE |
LENGTH |
QRY |
MOD |
INS |
REQ INS |
VALIDATE |
REL |
| ListID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| TimeCreated |
Timestamp |
27 |
True |
False |
False |
N/A |
CCCC-MM-DDThh:mm:ssZ |
|
| TimeModified |
Timestamp |
27 |
True |
False |
False |
N/A |
CCCC-MM-DDThh:mm:ssZ |
|
| EditSequence |
Varchar |
16 |
True |
False |
False |
N/A |
String |
|
| Name |
Varchar |
41 |
True |
True |
True |
Yes |
String |
|
| IsActive |
Bit |
5 |
True |
True |
True |
No |
1 0 true false |
|
| CompanyName |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| Salutation |
Varchar |
15 |
True |
True |
True |
No |
String |
|
| FirstName |
Varchar |
25 |
True |
True |
True |
No |
String |
|
| MiddleName |
Varchar |
5 |
True |
True |
True |
No |
String |
|
| LastName |
Varchar |
25 |
True |
True |
True |
No |
String |
|
| OtherNameAddressAddr1 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| OtherNameAddressAddr2 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| OtherNameAddressAddr3 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| OtherNameAddressAddr4 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| OtherNameAddressAddr5 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| OtherNameAddressCity |
Varchar |
31 |
True |
True |
True |
No |
String |
|
| OtherNameAddressState |
Varchar |
21 |
True |
True |
True |
No |
String |
|
| OtherNameAddressPostalCode |
Varchar |
13 |
True |
True |
True |
No |
String |
|
| OtherNameAddressCountry |
Varchar |
31 |
True |
True |
True |
No |
String |
|
| OtherNameAddressNote |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| OtherNameAddressBlockAddr1 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
| OtherNameAddressBlockAddr2 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
| OtherNameAddressBlockAddr3 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
| OtherNameAddressBlockAddr4 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
| OtherNameAddressBlockAddr5 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
| Phone |
Varchar |
21 |
True |
True |
True |
No |
String |
|
| AltPhone |
Varchar |
21 |
True |
True |
True |
No |
String |
|
| Fax |
Varchar |
21 |
True |
True |
True |
No |
String |
|
| Email |
Varchar |
1023 |
True |
True |
True |
No |
String |
|
| Contact |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| AltContact |
Varchar |
41 |
True |
True |
True |
No |
String |
|
| AccountNumber |
Varchar |
99 |
True |
True |
True |
No |
String |
|
| Notes |
Varchar |
4095 |
True |
True |
True |
No |
String |
|