This file is quote-comma delimited (a quotation mark is at the beginning and end of each field) with a carriage return/line feed at the end of each record. The format of the records is as follows:
|
Field |
Contents |
|
PUB |
QuickFill publication code |
|
NAME |
Customer name |
|
TITLE |
Customer title |
|
COMPANY |
Customer company |
|
DEPT |
Customer department |
|
STREET1 |
Customer street 1 |
|
STREET2 |
Customer street 2 |
|
CITY |
Customer city |
|
STATE |
Customer state |
|
ZIP |
Customer zip |
|
COUNTRY |
Customer country |
|
CCNUM |
Credit card number |
|
CCTYPE |
Credit card type (M/V/A/D) |
|
CCEXP |
Credit card expiration |
|
CVV2 |
Credit card verification value |
|
CCAUTH |
Credit card authorization |
|
AMOUNT |
Credit card amount |
|
ORDERNO |
QuickFill order number |
|
CUSTNO |
QuickFill customer number |
|
SDATE |
Date update processed |
|
STIME |
Time update processed |
|
MERCHANT |
Merchant number |