Rewards Import Format
File type: Fixed width
Location: /dti/exchange/cm directory. The file format will be the same as the export format described above, except that response information will be included in the “Reserved for Audit” fields. The format of the response information is given below.
Header Record
Reject Detail
99999999
Number of records in file that were rejected
Rejected Amount
1E+13
Number of reward miles, points, etc. rejected
Accepted Detail
99999999
Number of records in this file accepted by editor
Accepted Amount
1E+13
Number of reward miles, points, etc. accepted
Detail Record
Receive Date
YYYYMMDD
Date the file was received in rewards application
Load Date
YYYYMMDD
Date the file was processed in rewards application
Return Date
YYYYMMDD
Date the audit file was generated
Merge To Account
99999999999
Account number rewards should be merged with, if applicable (survivor collector account number)
Audit Status Code
X(1)
Response for reward record. E = Fatal (not added), M = Merged, W = Added with warning, R = Merged with warning
Reserved
X(19)
Blank
Error 1 - Bad Account
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 2 - not used
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 3 - Bad SQL
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 4 - Reward Not Numeric
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 5 - Closed Account
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 6 - Offer Expired
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 7 - not used
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error-8 Invalid Reward Summary
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 9 - No Negative Rewards Allowed
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 10 - Reward Discrepancy
X(1)
Fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Reserved
X(8)
Blank
Error 16 - Invalid Payment Method
X(1)
Non-fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 17 - Invalid Payment Type
X(1)
Non-fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Error 18 - Invalid Amount
X(1)
Non-fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Reserved
X(10)
Non-fatal errors. The error field will be set to “Y” if the specific error occurred for the rewards record. Otherwise the field will be blank.
Last updated
