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.

Field	Format	Description
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.