Intended Application
Acts as the primary method for importing reservation-related point transactions.
Notes
- Pipe delimiter must be used for this file.
- No header record is expected. The first record will be processed.
- Transactions are linked to locations using their location external references.
File Structure
|
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
|---|---|---|---|---|
| Alphanumeric | Yes | |||
| Record Action | Alphanumeric | Yes | ADD will add a transaction, while UND will undo/cancel a previous transaction. | |
| Post Date* | Date | Yes | YYYY-MM-DD | |
| Activity Timestamp | Date | YYYY-MM-DD | ||
| Location External Reference* | Alphanumeric | Yes | ||
| Source Application | Alphanumeric | Yes | Maximum of 10 characters. | |
| Transaction Translation Id | Alphanumeric | Yes | ||
| Transaction Identifier* | Decimal | Yes | 123456.123 | External unique transaction identifier. Maximum of 12 characters. 3 decimal digits |
| Daily Rate* | Decimal | Yes | 34.00 | For checkout transactions. |
| Quantity | Numeric | Yes | Quantity of daily rates or points. | |
| Points | Decimal | Yes | 0.00 | |
| Notes | Alphanumeric | Yes | Maximum of 50 characters. |
* - Denotes that the field(s) comprise the unique transaction key.
Sample File
