eBill Export Format
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).
E-Bill Export Format
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
Last updated
