This file is quote delimited with a space between each field and a carriage return/line feed at the end of each record. The file begins with a line containing a code, "110." The format of the records is:
|
Name |
Contents |
|
ACTION |
This field always contains "1" |
|
CREDIT CARD NUMBER |
Credit card number |
|
EXPIRATION DATE |
Expiration date for the credit card |
|
AMOUNT |
Total charge amount |
|
TICKET |
QuickFill order number |
|
ZIP CODE |
Customer's zip code (except the hyphen in zip+4) |
|
STREET ADDRESS |
First line of the customer's street address |
|
CARD MEMBER NAME |
Customer's name (20 character maximum) |
|
CUSTOMER CODE |
Customer's purchase order number |
|
TAX AMOUNT |
Tax amount being charged |
If the customer's full name (prefix + firstname + lastname + suffix) exceeds 20 characters, the prefix will be left out followed by the suffix, followed by the first name except for the first name initial, followed by the first name initial. Finally, if the customer's last name is more than 20 characters long, it will be truncated.