Intended Application
Used in conjunction with the identically named composite export, in order to batch update reward canceled and/or redeemed information. The export file is downloaded, modified, and re-imported to complete the total process.
Notes
- No header. First record is processed.
- Only redeemed and canceled information will be updated.
- Rewards cannot be un-canceled or un-redeemed.
File Structure
DATA COLUMN |
DATA TYPE | DATA REQUIRED? | FORMATTING | NOTES |
---|---|---|---|---|
Reward Id |
Numeric |
Yes |
||
Account Id | Alphanumeric | Yes | ||
Reward External Reference | Alphanumeric | Yes | ||
Reward Name | Alphanumeric | Yes | ||
Reward Point Value | Decimal | Yes | ||
Issued Timestamp | Date/Time | Yes | MMDDYYYYHHMMSS | UTC timezone. |
Canceled Status | Alphanumeric | Yes | Allowed values (Y, N) | |
Canceled Timestamp | Date/Time | No | MMDDYYYYHHMMSS | Required, if canceled. UTC timezone. |
Redeemed Status | Alphanumeric | Yes | Allowed values (Y, N) | |
Redeemed Timestamp | Alphanumeric | No | Required, if redeemed. UTC timezone. | |
Redeemed Location External Reference | Alphanumeric | No | Required, if redeemed. |
Sample File
1: 2: 3: 4: |
MemberRewardId|MemberAccountId|RewardTypeExternalRef|RewardTypeName|RewardPointValue|IssueTimestamp|CancelStatus|CancelTimestamp|RedeemStatus|RedeemTimestamp|RedeemLocation 1|65006||Racing T-Shirt|1700.0000|10172008203306|N||N|| 2|65006||Racing T-Shirt|1700.0000|10172008204307|N||N|| 3|65006||Racing T-Shirt|1700.0000|10202008144321|N||N|| |