Intended Application
For transaction importing in which a single file may contain transactions from multiple locations and/or multiple transaction types. Supports either retail amount->point conversion via Kognitiv Loyalty transaction point formula, and also direct point entry in 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.
- Header record is not expected. All data rows are processed as records.
- Negative values in either the retail value or point amount columns will result in an error.
- Standard point adjustment transaction type is not supported.
File Structure
|
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
|---|---|---|---|---|
| Activity Timestamp* | Date/Time | Yes | MM/DD/YYYY HH:MM:SS | Based on a 24 hour clock |
| Account Id* | Alphanumeric(20) | Yes | ||
| Retail Value | Decimal | Yes | 0.0 | |
| Point Amount | Decimal | Yes | 0.0 | |
| Transaction Translation Id | Alphanumeric | Yes | ||
| Location External Reference | Alphanumeric | Yes |
* - 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|14.93|0.00|FOOD|DELI2 10/10/2010 13:15:49|1003|11.49|0.00|MERCH|BOOKST 10/10/2010 13:49:50|1004|0.00|2.00|VISIT|STADIUM |
