File Type: Fixed length
File location: /dti/exchange/cm/ebillmmdd
where mm and dd are the current month and day.
Subscribers with a renewal delivery method of “ebill” will be exported to this file when renewal notices are run (rather than one of the renewal export files).
Account Key
10
Subscription ID
Name
24
Subscriber’s first name + last name
Address 1
30
Subscriber’s primary address, line 1
Address 2
30
Subscriber’s primary address, line 2
Address 3
30
Subscriber’s primary address, line 3
Bill-to Name
24
Bill-to Occupant’s first name + last name
Bill-to Address 1
30
Bill-to address, line 1
Bill-to Address 2
30
Bill-to address, line 2
Bill-to Address 3
30
Bill-to address, line 3
Message Line 1
68
Rate code renewal message
Message Line 2
68
Spaces
Expire Date
8
Subscription’s expire date, format YYYYMMDD
Due Date
8
For renewals, the expire date. For invoices, the expire date + 7. Format YYYYMMDD
Term 1
8
Term and length of first rate term (in order of lowest to highest)
Term 2
8
Term and length of second rate term
Term 3
8
Term and length of third rate term
Term 4
8
Term and length of fourth rate term
Week Description
22
“Number of Weeks”
Copies
3
Number of copies the subscriber receives per delivery day
Term 1 Weeks
8
Number of weeks for first term offered. (If term is months, this will be term * 4.3.)
Term 2 Weeks
8
Number of weeks for second term offered.
Term 3 Weeks
8
Number of weeks for third term offered.
Term 4 Weeks
8
Number of weeks for fourth term offered.
Filler
22
Spaces
Filler
3
Zeros
Filler
32
Spaces
Rate Description
22
“Weekly Rate”
Filler
3
Zeros
Cost of Term 1
8
Weekly rate for term 1
Cost of Term 2
8
Weekly rate for term 2
Cost of Term 3
8
Weekly rate for term 3
Cost of Term 4
8
Weekly rate for term 4
Filler
22
Spaces
Filler
3
Zeros
Filler
54
Spaces
Filler
3
Zeros
Filler
54
Spaces
Draw 6
3
Zeros
Filler
32
Spaces
Trans. Cost 1
8
Transportation cost (carrier credit for delivery subscription) for term 1
Trans. Cost 2
8
Transportation cost for term 2
Trans. Cost 3
8
Transportation cost for term 3
Trans. Cost 4
8
Transportation cost for term 4
Net Cost 1
8
Net cost for first term (term + tax)
Net Cost 2
8
Net cost for second term (term + tax)
Net Cost 3
8
Net cost for third term (term + tax)
Net Cost 4
8
Net cost for fourth term (term + tax)
AAM Zone
8
AAM Zone of the address
District
8
District manager for route delivering subscription
Route
8
Route delivering subscription
Carrier
8
Carrier delivering route on date renewals are processed
Rate Code
20
Subscriber’s rate code
Last Payment Date
8
Date of last subscriber payment, format YYYYMMDD
Payment Total
8
Total amount of last payment, including tip, taxes, and cash adjustments.
Payment Amount
8
The subscription amount of the last payment.
Tax Amount
8
The tax collected from the last payment.
Tip Amount
8
The tip amount from the last payment.
Adjust Amount
8
The cash adjustment amount from the last payment.
Vacation Days
3
The number of days newspaper was temp stopped (only temp stops with a reason code that can be printed on renewals will be included)
Vac. Days Since
8
Date of temp stop, format YYYYMMDD
Bill Type
1
“M” for mail. If route delivered, “R” for renewal or “I” for invoice
Bill Terms
1
Number of terms offered subscriber. 1 term = “0” 2 terms = “2” 3 terms = “T” 4 terms = “F”
Default Term
8
Term matching last payment amount. If none match (or no previous payment), next lowest term.
Statement Date
8
Date the file was exported, format YYYYMMDD
Email address
67
Occupant’s email address