Each of the formats available for the subscription export (comma-delimited and dBASE) contains the same fields in the same order.
Note: audit fields
The following audit fields appear in export files from both the audit and nonaudit systems. These fields may be ignored in nonaudit systems:
CONTROLn, REQTYPEn, SUBCLASSn.
All other audit fields only appear in export files created by the audit system.
The first record in comma-delimited files includes the field names listed below.
|
|
|
|
|
AF - Audit fields |
|
Name |
Type |
Length |
Decimals |
CF - Customer fields |
|
Numeric |
7 |
0 |
| |
|
ORDERNUM |
Character |
9 |
|
|
|
CUSTNUM |
Character |
9 |
|
|
|
Character |
1 |
|
| |
|
Character |
1 |
|
| |
|
PREFIX |
Character |
12 |
|
CF |
|
FNAME |
Character |
20 |
|
CF |
|
LNAME |
Character |
30 |
|
CF |
|
SUFFIX |
Character |
5 |
|
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 |
|
FAX |
Character |
20 |
|
CF |
|
|
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 |
|
CASSDATE |
Date |
8 |
|
CF |
|
CREATEDATE |
Date |
8 |
|
CF |
|
POSTALDATE |
Date |
8 |
|
CF |
|
EMAILDATE |
Date |
8 |
|
CF |
|
PHONEDATE |
Date |
8 |
|
CF |
|
FAXDATE |
Date |
8 |
|
CF |
|
Character |
1 |
|
| |
|
Numeric |
4 |
|
| |
|
PUB |
Character |
6 |
|
|
|
Date |
8 |
|
| |
|
RENEWALS |
Numeric |
3 |
|
|
|
TRACK |
Character |
6 |
|
|
|
Character |
6 |
|
| |
|
Character |
1 |
|
| |
|
Character |
1 |
|
| |
|
Character |
2 |
|
| |
|
Character |
37 |
|
| |
|
Character |
37 |
|
| |
|
Character |
37 |
|
| |
|
Character |
20 |
|
| |
|
Numeric |
9 |
2 |
| |
|
Numeric |
9 |
2 |
| |
|
Character |
1 |
|
| |
|
Numeric |
3 |
|
| |
|
Date |
8 |
|
| |
|
Character |
1 |
|
| |
|
Character |
19 |
|
| |
|
Character |
5 |
|
| |
|
Character |
6 |
|
| |
|
Character |
1 |
|
| |
|
ORDDATE1 |
Date |
8 |
|
|
|
ORDBATCH1 |
Numeric |
4 |
|
|
|
Character |
2 |
|
| |
|
SHIPCLASS1 |
Character |
1 |
|
|
|
COPIES1 |
Numeric |
4 |
|
|
|
Numeric |
4 |
|
| |
|
FREEISS1 |
Numeric |
4 |
|
|
|
Character |
1 |
|
| |
|
PREMIUM1 |
Character |
6 |
|
|
|
SERVICE1 |
Character |
2 |
|
|
|
PRICE1 |
Numeric |
9 |
2 |
|
|
TAX1 |
Numeric |
9 |
2 |
|
|
SHIPPING1 |
Numeric |
9 |
2 |
|
|
PAID1 |
Numeric |
9 |
2 |
|
|
PAYDATE1 |
Date |
8 |
|
|
|
PAYTYPE1 |
Character |
1 |
|
|
|
REFUND1 |
Numeric |
9 |
2 |
|
|
PONUM1 |
Character |
20 |
|
|
|
CONTROL1 |
Character |
1 |
|
AF |
|
REQTYPE1 |
Character |
3 |
|
AF |
|
SUBCLASS1 |
Character |
3 |
|
AF |
|
BILLSER1 |
Character |
6 |
|
|
|
Date |
8 |
|
| |
|
Numeric |
1 |
|
| |
|
Numeric |
1 |
|
| |
|
RENSER1 |
Character |
6 |
|
|
|
Character |
6 |
|
| |
|
Character |
6 |
|
| |
|
Character |
6 |
|
| |
|
Numeric |
4 |
1 |
| |
|
Date |
8 |
|
| |
|
Numeric |
2 |
|
| |
|
Numeric |
2 |
|
| |
|
Numeric |
4 |
|
| |
|
Numeric |
4 |
|
| |
|
Numeric |
4 |
|
| |
|
Date |
8 |
|
| |
|
Date |
8 |
|
| |
|
ORDDATE2 |
Date |
8 |
|
|
|
ORDBATCH2 |
Numeric |
4 |
|
|
|
Character |
2 |
|
| |
|
SHIPCLASS2 |
Character |
1 |
|
|
|
COPIES2 |
Numeric |
4 |
|
|
|
Numeric |
4 |
|
| |
|
FREEISS2 |
Numeric |
4 |
|
|
|
Character |
1 |
|
| |
|
PREMIUM2 |
Character |
6 |
|
|
|
SERVICE2 |
Character |
2 |
|
|
|
PRICE2 |
Numeric |
9 |
2 |
|
|
TAX2 |
Numeric |
9 |
2 |
|
|
SHIPPING2 |
Numeric |
9 |
2 |
|
|
PAID2 |
Numeric |
9 |
2 |
|
|
PAYDATE2 |
Date |
8 |
|
|
|
PAYTYPE2 |
Character |
1 |
|
|
|
REFUND2 |
Numeric |
9 |
2 |
|
|
PONUM2 |
Character |
20 |
|
|
|
CONTROL2 |
Character |
1 |
|
AF |
|
REQTYPE2 |
Character |
3 |
|
AF |
|
SUBCLASS2 |
Character |
3 |
|
AF |
|
BILLSER2 |
Character |
6 |
|
|
|
Date |
8 |
|
| |
|
Numeric |
1 |
|
| |
|
Numeric |
1 |
|
| |
|
RENSER2 |
Character |
6 |
|
|
|
Character |
6 |
|
| |
|
Character |
6 |
|
| |
|
Character |
6 |
|
| |
|
Numeric |
4 |
1 |
| |
|
Date |
8 |
|
| |
|
Numeric |
2 |
|
| |
|
Numeric |
2 |
|
| |
|
Numeric |
4 |
|
| |
|
Numeric |
4 |
|
| |
|
Numeric |
4 |
|
| |
|
Date |
8 |
|
| |
|
Date |
8 |
|
| |
|
ORDDATE3 |
Date |
8 |
|
|
|
ORDBATCH3 |
Numeric |
4 |
|
|
|
Character |
2 |
|
| |
|
SHIPCLASS3 |
Character |
1 |
|
|
|
COPIES3 |
Numeric |
4 |
|
|
|
Numeric |
4 |
|
| |
|
FREEISS3 |
Numeric |
4 |
|
|
|
Character |
1 |
|
| |
|
PREMIUM3 |
Character |
6 |
|
|
|
SERVICE3 |
Character |
2 |
|
|
|
PRICE3 |
Numeric |
9 |
2 |
|
|
TAX3 |
Numeric |
9 |
2 |
|
|
SHIPPING3 |
Numeric |
9 |
2 |
|
|
PAID3 |
Numeric |
9 |
2 |
|
|
PAYDATE3 |
Date |
8 |
|
|
|
PAYTYPE3 |
Character |
1 |
|
|
|
REFUND3 |
Numeric |
9 |
2 |
|
|
PONUM3 |
Character |
20 |
|
|
|
CONTROL3 |
Character |
1 |
|
AF |
|
REQTYPE3 |
Character |
3 |
|
AF |
|
SUBCLASS3 |
Character |
3 |
|
AF |
|
BILLSER3 |
Character |
6 |
|
|
|
Date |
8 |
|
| |
|
Numeric |
1 |
|
| |
|
Numeric |
1 |
|
| |
|
RENSER3 |
Character |
6 |
|
|
|
Character |
6 |
|
| |
|
Character |
6 |
|
| |
|
Character |
6 |
|
| |
|
Numeric |
4 |
1 |
| |
|
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 |