# 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

Record	L	Field
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