Subscriber Activity Export
The following data elements can be used with the “SubTranExprt” usage.
AAM Zone ID
Subscriber’s AAM zone.
Address ID
ID of subscriber’s address in Circulation.
Allow Web Access
Allow web access setting (yes/no).
Area Code
Occupant’s area code.
AreaID, AreaID[H]
Area in which subscriber’s delivery route is located.
Attention Line
Occupant’s attention line.
Auto Renew Length
Length of the auto-renew subscription.
Auto Renew Term
Term of the auto-renew subscription.
Bill Address ID
Address ID of bill-to address.
Billing Method
Subscriber’s billing method.
BillingMethod[H]
Subscriber’s billing method at the time of the transaction.
Bill Occupant ID
Occupant ID of bill-to occupant.
Bill to fields
All standard address and occupant fields are available for the bill-to address and occupant.
BillToAllowWebAccess
BillToAreaCode
BillToAttentionLine
BillToBuildng
BillToCensusBlockID
BillToCensusTrackID
BillToCityID
BillToComplex
BillToCountryID
BillToCountyID
BillToDeliveryInstructions
BillToDirectionsToAddress
BillToDwellingStatusDate
BillToDwellingStatusID
BillToDwellingTypeID
BillToEmailAddress
BillToExtension
BillToFirmName
BillToFirstName
BillToHomePage
BillToHouseNumber
BillToHouseNumberModifier
BillToIsOnline
Digital Sales indicator (yes/no) for BillTo Address
BillToLastName
BillToMailAccessible
BillToMilitaryForeign
BillToNameAddressLine[1] to [7]
BillToOccupantTitle
BillToOccupantTypeID
BillToOtherName
BillToOtherNameUsage
BillToPhone
BillToPhoneUnlisted
BillToPORouteNumber
BillToPORouteType
BillToPORouteWalkSequence
BillToPostDirectional
BillToPreDirectional
BillToRoueAccessible
BillToShortName
BillToStateID
BillToStateName
BillToStreetName
BillToStreetSuffixID
BillToTownOf25ID
BillToUnitDesignatorID
BillToUnitNumber
BillToZipBarCode
BillToZipCode
BillToZipExtension
Building
Address building.
Carrier City ID Carrier City ID [H]
City of the delivery carrier’s address.
Carrier ID Carrier ID[H]
ID of the subscriber’s delivery carrier.
Carrier Name Carrier Name [H]
Name of the subscriber’s delivery carrier.
Carrier Zip Code Carrier Zip Code [H]
Zip code of the delivery carrier’s address.
Carrier Zip Extension Carrier Zip Extension [H]
Zip extension of the delivery carrier’s address.
Census Block ID, Census Tract ID
Address census tract and block.
City ID
Address city.
Complex
Address complex.
Copies Copies[H]
Number of copies of the paper delivered to the subscriber. Copies based on the current date or (for Copies[H]) the transaction date.
Country ID
Address country.
Country Name
Name of country in address.
County ID
Address county.
Create Date, Create Time, Create User
Date, time and user information for transaction.
CreditStatusID
Subscriber’s assigned credit status.
Date Last Renewal Sent
Date last renewal notice or invoice was sent to subscriber.
Delivery Instructions
Occupant delivery instructions.
Delivery Placement ID
Newspaper delivery placement for subscriber.
Delivery Point ID
Delivery Schedule ID
Subscriber’s delivery schedule.
DeliveryScheduleID[H]
Subscriber’s delivery schedule at the time of the transaction.
DemographicAnswer
Subscriber’s answer to a demographic question.
Directions To Address
Address delivery directions.
DistribZoneID DistribZoneID[H]
Distribution zone in which subscriber’s delivery route is located.
DistrictID DistrictID[H]
District in which subscriber’s delivery route is located.
Dwelling Status Date, Dwelling Status ID
Address dwelling status and date last updated.
Dwelling Type ID
Address dwelling type.
Email Address
Occupant’s email address.
End Grace Date End Grace Date [H]
The date on which the grace period will end for the subscriber.
Expire Date Expire Date [H]
The stop date for the subscription
Extension
Phone number extension.
File Create Date, File Create Time
Create date and time for export file.
Filler
Filler fields will be blank.
Firm Name
Firm name, if other name usage is “Firm”.
First Name
Occupant’s first name.
Gets Paper
This flag is set to yes or no depending on whether the occupant is an active subscriber (i.e. is an active subscriber who is not temp stopped).
Home Page
Occupant’s home page.
Honorific ID
Occupant’s honorific (name suffix)
House Number
Address house number.
House Number Modifier
Address house number modifier.
Insert Group ID Insert Group ID[H]
Insert group assigned to the subscriber’s route.
IsOnline
Digital Sales indicator (yes/no)
LabelGroupID LabelGroup[H]
Subscriber’s label group, if the subscription is mail delivered.
LastFullPaymentLength
Length purchased by the last subscriber payment, including grace paid.
LastFullPaymentTerm
Largest term purchased by subscriber’s last payment, taking grace days into consideration.
Last Name
Occupant’s last name.
LastPaymentAmount
Amount of the last payment.
LastPaymentLength
Length of subscriber’s last payment, not including grace paid.
LastPaymentMethod
Payment method of last payment: “Auto Renew Bank Draft”, “Auto Renew Credit Card”, “Bank Draft”, “Credit Card”, “Cash” or “Check”.
LastPaymentTaxAmount
Tax amount of last payment.
LastPaymentTerm
Largest term purchased by subscriber’s last payment.
Literal
Literal fields will be hard coded to display whatever is entered in “format”. For example if a given field should always display “D”, set it up as a literal and enter “D” in FORMAT.
Mail Accessible
Address mail accessible flag (yes/no).
Middle Initial
Occupant’s middle initial.
Military Foreign
Address military/foreign information.
Name Address Lines
These six lines can be used for the subscriber’s name and address, rather than using individual name and address elements.
Number of Renewals Sent
Number of renewal notices or invoices sent to the subscriber so far in the current subscription period.
Occupant ID
Subscriber’s occupant ID in Circulation.
Occupant Salutation ID
Occupant’s title, such as “Mr.”
Occupant Title
Occupant’s Title
Occupant Type ID
Subscriber’s occupant type.
Old Rate Code ID
Old Rate Code associated with payment rate terms for this subscription
Original Start Date
Subscriber’s original start date.
Other Name
Occupant’s other name.
Other Name Usage
Occupant’s other name usage.
Phone
Occupant’s phone number.
Phone Unlisted
Phone number unlisted setting (yes/no).
PO Route Number, PO Route Type, PO Route Walk Sequence
Address post office route number, type and walk sequence.
Post Directional
Street address post directional.
Pre Directional
Street address predirectional.
Previous Delivery Requested
Whether the subscriber requested previous delivery.
Process Date, Process Time
Process date and time for transaction.
Product ID, Publication Name
Subscriber’s publication ID and name.
Publish Date
Publishing date on which transaction was processed.
Purchase Number
Purchase number entered with transaction.
Rate Amount
Amount of the subscriber’s rate.
Rate Code ID Rate Code ID [H]
Subscriber’s rate.
Rate Length
Subscriber’s subscription length.
Rate Tax Amount
Tax amount of the subscriber’s rate.
Rate Term
Subscriber’s rate term.
Reason Code
Reason code entered for transaction.
Receive Bonus Days
Bonus day flag for subscriber (yes/no).
Record Count
Record number in file.
Record Identifier**
Field that identifies the record type, for example “D” to indicate a detail record.
RegionID RegionID[H]
Region in which subscriber’s delivery route is located.
Remarks
Remarks entered with transaction.
Renewal Delivery Override
Renewal delivery method override (yes/no).
Renewal Override Code
Override code for renewal delivery method.
Route Accessible
Address route accessible flag (yes/no).
RouteID RouteID[H]
Subscriber’s route, if subscription is route-delivered.
RouteTypeID RouteTypeID[H]
Route type of subscriber’s route.
Send Invoice, Send Renewal
Send invoice and renewal flags, entered during starts or billing changes (yes/no).
Short Name
Abbreviated company name used by banks.
Source Code
Source code entered for transaction.
State ID, State Name
Address state ID and name.
Street Name
Address street name.
Street Suffix ID
Address street suffix.
Subscriber
Flag that determines whether the occupant is a current subscriber (yes/no).
Subscription ID
Subscriber’s subscription ID.
Subsource ID
Subsource for source code entered with transaction.
Town of 25 ID
Address Town of 25.
Tran Date
Transaction date for subscriber transaction.
Tran Type ID
Transaction type (start, billing change, etc.).
Unit Designator ID, Unit Number
Unit type and number.
ZIP Bar Code, ZIP Code, ZIP Extension
Zip code, Zip code + 4, and Zip bar code.
* Field is required.
** Field is required if a record identifier is entered on the record type setup screen.
[H] indicates the historical value at the time of the transaction.
Last updated
