File Type: Pipe delimited. The format will be the same as for the Detailed Export 2 except that two additional segments are added after the P1 segment. The A1 segment contains auto-renew information, and A2 segments contain auto renew adjustments. The fields contained in this segment are given below.
File location: /dti/exchange/cm. The file name will be autorenewsMMDDYY-xxx, where “MMDDYY” represents the month, date and year of the export, respectively, and “xxx” represents an incrementing sequence number that distinguishes files exported on the same day.
A1 (Auto renew data begins)
Tip Amount
Credit Card Number (if credit card auto renew)
Credit Card Authorization Number (if credit card auto renew)
Credit Card Expiration Date (if credit card auto renew)
Bank Number (if bank draft auto renew)
Client Type (if bank draft auto renew)
Account Type (if bank draft auto renew)
Account Number (if bank draft auto renew)
(For each A1 record, one or more A2 records can be created for each auto renew adjustment.)
A2 (Auto renew data begins)
Auto renew adjustment code ID
Adjustment code description
Auto renew adjustment amount
In addition, many fields in the Detailed Export 2 format will be blank, and a few will have different data in them:
In the Subscription Data segment, the Lockbox Scan Line field will always be blank.
In the Subscription Data segment, the Last Renewal Date will be the date of the last auto renew transaction.
Only one rate will be populated in the Rate Data segment, and likewise only one set of taxes will be populated in the Tax Data segment.
In the Messages Continued segment (M2), the Renewal Period Messages and General Message will be blank.