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 |
Last updated
