Each of the formats available for the prospect export (comma-delimited and dBASE) contains the same fields in the same order.
The first record in comma-delimited files includes the field names listed below. Also, the total number of fields in prospect export files created from the non-audit system is 42. The total number of fields in files created from the audit system will vary depending on the number of questions in your qualification form(s).
|
|
|
|
AF - Audit fields |
|
|
|
|
PF – Prospect fields |
|
Name |
Type |
Length |
CF - Customer fields |
|
RECNUM |
Numeric |
7 |
|
|
CUSTNUM |
Character |
9 |
CF |
|
PREFIX |
Character |
12 |
CF |
|
FNAME |
Character |
20 |
CF |
|
LNAME |
Character |
30 |
CF |
|
SUFFIX |
Character |
12 |
CF |
|
Character |
15 |
CF |
|
|
SEX |
Character |
1 |
CF |
|
TITLE |
Character |
40 |
CF |
|
COMPANY |
Character |
40 |
CF |
|
DEPT |
Character |
40 |
CF |
|
STREET1 |
Character |
40 |
CF |
|
STREET2 |
Character |
40 |
CF |
|
CITY |
Character |
26 |
CF |
|
STATE |
Character |
2 |
CF |
|
ZIP |
Character |
10 |
CF |
|
ZIP2 |
Character |
2 |
CF |
|
CARRT |
Character |
4 |
CF |
|
CNTRYCODE |
Character |
4 |
CF |
|
COUNTRY |
Character |
24 |
CF |
|
TAXJR |
Character |
3 |
CF |
|
PHONE |
Character |
20 |
CF |
|
CELLPHONE |
Character |
20 |
CF |
|
FAX |
Character |
20 |
CF |
|
|
Character |
60 |
CF |
|
EMAIL2 |
Character |
60 |
CF |
|
USERID |
Character |
15 |
CF |
|
PASSWORD |
Character |
15 |
CF |
|
TAXABLE |
Character |
1 |
CF |
|
RENTPOSTAL |
Character |
1 |
CF |
|
RENTEMAIL |
Character |
1 |
CF |
|
RENTPHONE |
Character |
1 |
CF |
|
RENTFAX |
Character |
1 |
CF |
|
BADSEED |
Character |
1 |
CF |
|
DEMCODEA |
Numeric |
4 |
CF |
|
DEMCODEB |
Numeric |
4 |
CF |
|
DEMCODEC |
Numeric |
4 |
CF |
|
DEMCODED |
Numeric |
4 |
CF |
|
DEMDATA1 |
Character |
19 |
CF |
|
DEMDATA2 |
Character |
19 |
CF |
|
EXTCUSTID |
Character |
12 |
CF |
|
SELFLAGS |
Character |
8 |
CF |
|
CASSDATE |
Date |
8 |
CF |
|
CREATEDATE |
Date |
8 |
CF |
|
POSTALDATE |
Date |
8 |
CF |
|
EMAILDATE |
Date |
8 |
CF |
|
PHONEDATE |
Date |
8 |
CF |
|
FAXDATE |
Date |
8 |
CF |
|
LIST |
Character |
12 |
PF |
|
PROSPDATE |
Date |
8 |
PF |
|
PROSPRQTYPE |
Character |
3 |
(see note below) |
|
PUB |
Character |
12 |
PF |
|
QDATE |
Date |
8 |
AF |
|
QBATCHDATE |
Date |
8 |
AF |
|
QBATCHNUM |
Numeric |
4 |
AF |
|
PERSID |
Character |
20 |
AF |
|
Character |
|
AF |
|
|
Qual. Data |
Character |
|
AF |
|
Qual. Data |
Character |
|
AF |
|
Qual. Data |
Character |
|
AF |
Note: The PROSPRQTYPE field appears in export files from both the audit and nonaudit systems. This field may be ignored in nonaudit systems.