Rewards Export Format
File type:
Fixed width, with each record followed by a carriage return. A single header record will be exported, and a detail record will be exported for each reward transaction selected.
Location:
/dti/exchange/cm
. The file name will be [provider code][sequence], where “provider code” is the 4-character provider code entered for the export, and “sequence” is a 4-digit export sequence that is incremented each time rewards are exported. For example, if the provider code entered is “AIRM” and this is the 11th export, the file name will be “AIRM0011
”.
Field | Format | Description |
---|---|---|
Header Record |
|
|
Record Type | X(2) | Value “TH” |
Reserved Space | X(6) | Blank fill |
Provider Code | X(4) | Provider Code defined for the publication |
Transmission Sequence # | 999999 | Incremental Batch Sequence number (zero padded) |
Process Date | YYYYMMDD | Rundate |
Process Time | HHMMSS | Process Time |
Total Detail Records | 99999999 | Total number of detail records (zero padded) |
Miles Issued | 1E+13 | Total Miles for all Detail Records. The last digit must be converted to a Hexadecimal value to indicate whether or not the field has a positive or negative value. (zero padded) |
Reserved Space | X(26) | Blank fill |
Reserved for Audit Data | X(42) | Blank fill |
Reserved Space | X(79) | Blank fill |
Provider Reserved Space | X(50) | Blank fill |
|
|
|
Detail Record |
|
|
Record Type | X(2) | Value “TD” |
Reserved Space | X(15) | Blank fill |
Account Number | 99999999999 | Air Miles® account number |
Sponsor Reference # | 1E+20 | Newscycle Subscription ID (zero padded) |
Sponsor Code | X(4) | Sponsor Code defined for the publication |
Offer Code | X(8) | Offer code defined within setup or the user-defined offer code assigned with the manual mileage adjustment |
Location Code | X(4) | Location Code defined for the publication (may be blank filled if no location code is available) |
Sponsor Batch # | X(9) | Blank fill |
Miles Issues | 999999999 | Miles issued to this account. The last digit must be converted to a Hexadecimal value to indicate whether or not the field has a positive or negative value. (zero padded) |
Reserved Space | X(18) | Blank fill |
Purchase Date | YYYYMMDD | Date of the transaction |
Offer Occurrence | 999 | Value “001” |
Record Sequence # | 9999999 | Zero fill |
Payment Type | X(8) | Valid values (CASH, CRED, DEBT) or Blank fill |
Payment Method | X(1) | Value “M” |
Value | 99999 | Zero fill |
Reserved Space | X(11) | Blank fill |
Sponsor Reserved Space | X(21) | Subscription ID followed by “|” followed by Transaction Number. Blank fill remaining spaces. |
Reserved for Audit | X(86) | Blank fill |
Last updated