Intended Application
For transaction importing in which the account Id will be an Email Address or an alphanumeric string and 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 are allowed.
- Does not support ID Type Auto Ranges.
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(256) |
Yes |
|
Internal Member Id is used in unique key. | |
| 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|[email protected]|0.00|50.00 10/10/2010 13:15:49|[email protected]|19.44|50.00 10/10/2010 13:49:50|[email protected]|32.00|75.00 |
