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. There are 22 fields, of which only 10 are used. The remaining 12 fields are blank.
|
Field |
Contents |
|
ACCOUNT NUMBER |
Credit card number |
|
EXPIRATION DATE |
Card expiration date in MM/YY format |
|
AMOUNT |
Amount charged |
|
TRANSACTION TYPE |
Always SALE |
|
STREET ADDRESS |
First 20 characters of Street1 + Street2 |
|
ZIP CODE |
Zip code without hyphen |
|
CUSTOMER CODE |
Always blank |
|
SALES TAX |
Amount of the charge that is tax |
|
INVOICE NUMBER |
Order number |
|
CVV2 INDICATOR |
1=CVV2 number supplied, 9=CVV2 not supplied |
|
CVV2 |
CVV2 number (Card verification value) |
|
|
The remaining 11 fields are blank |