Intended Application
For transaction importing in which a single file will contain transactions from only one transaction type and a retail value or point amount is included in the file.
Notes
- Any delimiter except for [tab] can be used to separate columns. The delimiter used is then specified at the time of file import or file upload template creation.
- Header record is not expected. All data rows are processed as records.
- Negative values will result in processing errors.
- Records containing potentially dangerous sequence of characters and commands used in cross-site scripting attacks may be rejected.
File Structure
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
---|---|---|---|---|
Date/Time |
Yes |
MM/DD/YYYY HH:MM:SS |
Based on a 24 hour clock | |
Alphanumeric(20) |
Yes |
|
||
Retail Value | Decimal | Yes | 0.00 | |
Point Amount | Decimal | Yes | 0.00 |
* - Denotes that the data column helps comprise the transaction unique key for this import file specification.
Sample File
1: 2: 3: |
10/10/2010 13:14:19|1001|0.00|50.00 10/10/2010 13:15:49|1003|19.44|50.00 10/10/2010 13:49:50|1004|32.00|75.00 |