Intended Application
For RV-related transaction importing where a unique contract number is provided.
Notes
- Any delimiter can be used to separate columns. The delimiter used is then specified at the time of file import.
- Header record is required. The first row is not treated as a data record and will be skipped in processing.
- The associated transaction type will be selected at the time of import.
- Custom fields will not be processed if the event admission transaction type is selected.
- In the event that a transaction type using direct point entry point calculation method is selected, the point amount will be used. Otherwise, points will be calculated based on the retail value.
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 |
Yes |
|
||
Retail Value | Decimal | Yes | 0.00 | |
Point Amount | Decimal | Yes | 0.00 | |
Contract Number* | Alphanumeric | Yes | Maximum length of 5 characters. Generated by external system. | |
Transaction Custom Field(s) | Varies | No |
A column must be present in the header for each transaction custom field cited, in the same column position as the associated data. The column name must match the transaction custom field external reference. |
* - 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|75.00|75.00|A3411 10/10/2010 13:15:49|1003|100.00|100.00|A34BC 10/10/2010 13:49:50|1004|125.00|125.00|A3455 |