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 |
|