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”.
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
