Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The following data elements can be used with the “1099Export” usage. This usage or the 1099 Forms Export usage can be used to export 1099 reporting information in the 1099 Forms option (see 1099 Forms).
Amount
Payment amount
Business Unit
Newspaper business unit
Direct Sales Indicator
Direct sales indicator (“1” if over 5,000 in sales, otherwise blank)
Filler
Linefeed
Literal Value
Tax ID Number
Transmitter’s TIN or SSN (Federal ID number prompted for on 1099 screen)
Vendor ID
Payer’s account number (account’s vendor ID)
Vendor Prefix
The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section)
Withholding Class
1099 withholding class. If the carrier has amounts in both box 3 and box 7, separate records will be exported.
Withholding Type
1099 withholding type (“IRS” for interest 1099s or “FED” for miscellaneous).
The following data elements can be used with the “AccountLockbox” usage.
Account Holder Name
The name on bank or credit card account.
Account ID
The ID of the account.
Authorization Number
Authorization number for authorized credit card transactions.
Balance Due
The balance due.
Batch Payment Total
Total of all payments in the batch.
Batch Record Count
Number of records in the batch.
Bill Source ID
The bill source (group of accounts being billed together, such as Carrier, Dealer, NIE).
Cash Batch Date
Date of the batch.
Check Number
Number on the check.
Comments
Comments for the batch.
Company Number
Company number.
Credit Card Expires
Expire date of credit card.
Credit Card Number
Credit card number, if account paid with credit card.
Credit Card Type
The credit card type (Visa, MasterCard, etc.)
Credit Card Vault ID
Vault ID used only for off-site credit card storage
File Payment Total
Payment total in the file.
File Record Count
The total number of records in the file.
Filler
Filler denotes blank fields or information that will not be used in Circulation; these fields will be ignored.
Invoice Date
Date of the invoice.
Invoice Number
Number of the invoice.
Lockbox ID
ID of the lockbox.
Masked Credit Card Number
Credit card number with all but the last four digits masked (replaced with “*”). Used only for off-site credit card storage.
Payment Amount*
Amount of the payment.
Payment Date
Date of the payment.
Payment Type
The type of payment (credit card, check, etc.)
Record Identifier**
Field that identifies the record type, for example “D” to indicate a detail record. This must be the first field in the record.
Route ID
The ID of the route.
Scan Line Check Digit
Check digit of the lockbox scan line.
Signature File Name
File name of the signature image from Syncronex.
Use Credit Card On File
Y/N flag to use the credit card number in the account record.
* Field is required.
** Field is required if a record identifier is entered on the record type setup screen.
File mapping can be used for the following options.
The following data elements can be used with the “ALTDrawAdjImprt” usage.
* Field is required.
Barcode
House Returns
Branch Name
Identification Number *
Claim Reference
Line Sequence
Customer Identifier
Record Identifier
Customer Name
Supplier Identifier
Draw Adjustment
Supplier Name
Draw Class ID
Trade Returns
Draw Date
Version Number
File Date
Week Number
Filler
Year
Generation Number
The following data elements can be used with the “AddressExport” and “AddressImprt” usages.
Accuracy Factor
8-character accuracy factor of latitude and longitude.
Additional (Geographic) Data**
Address ID*
10-digit sequentially assigned number used to uniquely identify the record.
Address Lines 1-6
The address in “unparsed” format, lines 1 through 6.
Address Sort
Defines the sort order of an address within the postal code and extension.
Building
Building name.
Census Block ID
Census block identifier.
Census Tract ID
Census tract identifier.
City ID
City.
Cleanse
Address’s cleans setting (Y/N).
Cleanse Data Date
Cleanse data.
Cleanse Date
Cleanse Score
Cleanse Time
Cleanse User
Complex
Complex name.
Congressional District
Congressional district of the address.
Country ID
Country.
County ID
County.
Create Date
Record create information.
Create Time
Create User
Dbl Dependent Locality**
Delivery Office Number**
Delivery Point ID
Department 1**
Department 2**
Dependent Locality**
Dependent Thoroughfare**
Directions To Address
Directions to the address.
Dual Address
Whether this is a dual address.
Dwelling Status Date
Date on which the dwelling status was verified.
Dwelling Status ID
The dwelling status.
Dwelling Type ID
The dwelling type.
Filler
Available only for the Address Export.
Function*
A (add), C (change), or D (delete). Available only for the Address Import.
House Number
The house number.
House Number Modifier
The modifier of the house number.
INSEE Code**
Language
The language ID.
Latitude
Latitude location of the address.
Level Designator ID
The level (e.g., floor)
Level Number
The level number
Line Feed
Available only for the Address Export.
Literal Value
Available only for the Address Export.
Longitude
Longitude location of the address.
Lot
Lot number.
Lot Sequence
Lot sequence.
Mail Accessible
Whether this address is mail accessible.
Military Foreign 1
First address line for military or foreign addresses.
Military Foreign 2
Second address line for military or foreign addresses.
Modify Date
Record modify information.
Modify Time
Modify User
Non (Postally) Required Locality**
Odd Even
Odd or even side of the street
Organization
PO Route Number, PO Route Type, PO Route Walk Sequence
Address post office route number, type and walk sequence.
PO Route Type,
PO Route Walk Sequence
Post Directional
Street name post-modifier, such as the “N” in “Main St N”.
Pre Directional
Street name pre-modifier, such as the “N” in “N Main St”.
Prev Zip Code
Previous Zip code. Available only for the Address Import.
Prev Zip Extension
Previous Zip code extension. Available only for the Address Import.
Route Accessible
Indicates if this address is accessible by circulation carriers for the delivery of publications and products.
State ID
The state.
Street Name
The street name (e.g., “Main”)
Street Suffix ID
The street suffix (e.g., “North”)
Sub-Building Name**
Town of 25 ID
The town of 25.
Unit Designator ID
The unit designator (e.g., “Apt.”)
Unit Number
The unit number (e.g., the “135” in “Apt. 135”)
ZIP Bar Code, ZIP Code, ZIP Extension
Zip code, Zip code + 4, and Zip bar code.
* Field is required
** Field can only be exported if addresses are stored unparsed in the database and QAS is used for address correction
The following data elements can be used with the “BASReconcilDtl” usage.
Account ID
Account ID
Amount
Amount
BAS Category*
BAS category
Charge Code Description
Description of charge code
Charge Code ID
ID of charge code
Charge Date
Date of the charge
Charge Type
Type of charge
City Tax Amount
Tax amount for city
City Tax Authority
Tax authority for city
City Tax Change
Change in city tax
City Tax Exempt Chg
Tax exempt change for city
City Tax Exempt Reason
Reason for tax exempt change
Country Tax Amount
Tax amount for country
Country Tax Authority
Tax authority for country
Country Tax Change
Change in country tax
Country Tax Exempt Chg
Tax exempt change for country
Country Tax Exempt Reason
Reason for tax exempt change
County Tax Amount
Tax amount for county
County Tax Authority
Tax authority for county
County Tax Change
Change in county tax
County Tax Exempt Chg
Tax exempt change for county
County Tax Exempt Reason
Reason for tax exempt change
Product ID
ID of the product
Quantity
Quantity
Route ID
ID of the route
State Tax Amount
Tax amount for state
State Tax Authority
Tax authority for state
State Tax Change
Change in state tax
State Tax Exempt Chg
Tax exempt change for state
State Tax Exempt Reason
Reason for tax exempt change
Transaction Reference
Reference number
Unit Rate
Rate per unit
* Field is required.
The following data elements can be used with the “AccountStatement” usage.
Account Group Address Line (1-6)
Address associated with the account group.
Account Group ID
The account group to which the account belongs.
Account ID
The ID of the account.
Age Balance
The balance due for an aging period.
Age Current
The current balance due.
Age Periods 1-4
Up to four aging periods can be included.
Age Unapplied
The unapplied amount for an aging period.
Area Code
Area code portion of the account’s phone number.
Area ID
The ID of the bill area.
Balance Type
Indicates if the account has a credit, debit, or zero balance.
Bill Source ID
The bill source (group of accounts being billed together, such as Carrier, Dealer, NIE).
Building
The building identifier, such as “Building 212”.
Charges Detail (Parent Element)
Details about a charge (parent element). Also from the following child elements: Account ID, Amount, Bill Batch ID, Carrier ID, Charge Batch ID, Charge Code ID, Charge Date, Charge Type ID, Delivery Route ID, Delivery Schedule ID, Description, Entity ID, Entity Type, GL Account ID, Line Feed, Literal Value, Product ID, Quantity, Rate Code ID, Remarks, Retail Amount, Reversal, Route ID, Route Name, Transportation GL Account ID, and Unit Rate.
City ID
The city.
CollectorID
ID of the collector assigned to the account.
Company ID
The ID of the company.
Complex
The name of the complex, such as “Oak Park Apartments”.
Country ID
The country.
County ID
The county.
Credit Card On File
Indicates whether the account has a credit card number on file.
Distrib Zone ID
ID of the distribution zone.
District ID
ID of the district.
Drop Order
Drop order.
Extension
The local extension of the phone number.
First Name
The first name on the account.
Historical Aging Detail
Aging detail (parent element). Also choose from the following child elements: Account ID, Age Balance, Age Current, Age Period 1-12, Age Unapplied, Bill Date, Bill Source ID, Company ID, Last Bill Amount, Last Bill Date, Line Feed, and Literal Value.
Honorific ID
Occupant’s honorific (name suffix)
House Number
The house number for this address, such as “103” for the address “103 Main Street”.
House Number Modifier
Modifier of the house number, like “½” in the address “103 ½ Main St”.
Invoice Detail
Invoice detail (parent element). Also choose from the following child elements: Account ID, Balance Due, Bill Batch ID, Bill Source ID, Company ID, Discount Amount, Discount Date, Due Date, Invoice Date, Invoice Number, Line Feed, Literal Value, and Original Amount.
Last Name
The account’s last name.
Line Feed
A line feed to start a new line.
Literal Value
A literal value.
Location
Description of the location.
Middle Initial
Occupant’s middle initial.
Name Address Lines 1-6
Up to six lines of name and address information in an unparsed format.
Occupant Salutation ID
Occupant’s title, such as “Mr.”
Other Name
Account’s other name
Other Name Usage
Account’s other name usage
Payment Detail
Details about a payment (parent element). Also select from the following child elements: Account ID, Adjustment Amount, Adjustment ID, Bank ID, Bill Batch ID, Bill Source ID, Cash Amount, Cash Batch ID, Check Number, Company ID, Discount Amount, Invoice Number, Line Feed, Literal Value, Lockbox ID, Payment Amount, Payment Date, Payment Method, Tran Type, and Unapplied Amount.
Phone
The account’s phone number.
Post Directional
Street name post-modifier, such as the “N” in “Main St N”.
Pre Directional
Street name pre-modifier, such as the “N” in “N Main St”.
Product ID
ID of the product.
Region ID
ID of the region.
Remit To Address Lines 1-7
The remit-to address.
Route ID
ID of the route.
Route Name
Name of the route.
Run Date
Date of the export.
State ID
The state.
Street Name
Street name for this address, such as “Main” for the “103 Main Street” address. This will be the PO box if the address has one.
Street Suffix ID
The suffix street direction, such as “N” in “1234 Main St N”.
Truck ID
ID of the truck.
Truck Name
Name of the truck.
Truck Sequence ID
ID of the truck sequence.
Unit Designator ID
Enter the type of unit, such as Apt, Lot, Room, Suite.
Unit Number
The number of the unit, such as the “20” in “Apt 20”.
ZIP Bar Code, ZIP Code, ZIP Extension
Zip code, Zip code + 4, and Zip bar code.
The following data elements can be used with the “BASREconcilSumm” usage.
Amount
Amount
BAS Category*
BAS category
Quantity
Quantity
* Field is required.
The following data elements can be used with the “1099FormsExport” usage. This usage or the 1099 Export usage can be used to export 1099 reporting information in the 1099 Forms option.
The 1099 Forms can be exported in three formats: 1099-INT, 1099-Misc, and 1099-NEC. The interest income received report is exported using Form 1099-INT. Miscellaneous income is exported using Form 1099-Misc. The nonemployee compensation report is exported using Form 1099-NEC.
BondInterest-Box3
Bond interest amount (prints in Box 3)
Business Address Line 1 Business Address Line 2 etc.
The business address (lines 1-6) is exported by these elements
Business Phone
Business phone number
Filler
InterestIncome-Box1
Interest income amount (prints in Box 1)
Linefeed
Literal Value
NonEmployeeComp-Box7
Non-employee compensation amount (prints in Box 7)
OtherIncome-Box3
Other income amount (prints in Box 3)
PayerFederalIDNumber
Federal ID number specified when running the export
RecipientAccountNumber
Account’s vendor ID
RecipientCity
This and the following fields contain information about the account (carrier)
RecipientCityStateZip
RecipientName
RecipientState
RecipientStreetAddress
RecipientTaxIDNumber
Tax ID number specified for account
RecipientZip
Resale-Box9
Resale amount (prints in Box 9)
StateNumber
State number specified when running the export
BusinessAddressLine1
BusinessAddressLine2
BusinessAddressLine3
BusinessAddressLine4
BusinessPhone
PayerFederalIDNumber
RecipientTaxIDNumber
RecipientName
RecipientStreetAddress
RecipientCityStateZip
RecipientAccountNumber
InterestIncome-Box1
BondInterest-Box3
StateNumber
BusinessAddressLine1
BusinessAddressLine2
BusinessAddressLine3
BusinessAddressLine4
BusinessPhone
PayerFederalIDNumber
RecipientTaxIDNumber
RecipientName
RecipientStreetAddress
RecipientCityStateZip
RecipientAccountNumber
OtherIncome-Box3
NonEmployeeComp-Box7
Resale-Box9
BusinessAddressLine1
BusinessAddressLine2
BusinessAddressLine3
BusinessAddressLine4
BusinessPhone
PayerFederalIDNumber
RecipientTaxIDNumber
RecipientName
RecipientStreetAddress
RecipientCityStateZip
RecipientAccountNumber
NonEmployeeComp-Box1
StateNumber
The following data elements can be used with the “AltDrawChgImprt” usage.
Adjust Or Replace
Barcode
Draw Change Amount [Sun-Sat]
Draw Type Class
Effective Date
Filler
Identification Number*
Record Identifier
Reversal Date
* Field is required.
The “AuthImport” file mapping usage is used with this option. The possible data elements are described in the following table.
OccupantID
Recommended. The ID of the occupant accessing the subscription.
AuthDate*
Required. The date of the authentication.
AuthTime
Recommended. The time of the authentication.
AuthOnly
“Yes” or “No.” Must be set to “Yes” if authentication information is used for AAM purposes. If this data element is not included in the file map, its value will be set to “Yes” automatically when imported into Circulation.
AuthType*
Required. The authentication integration used, such as the online content vendor: “Tecnavia,” “Pressmart,” “Standard,” “Saxotech,” etc.
AuthControl
Must be a valid authentication control ID (set up in CMO Setup). If this data element is not included in the file map, the user will be prompted to enter it when running the Authentication Import option.
AuthenticationReason
Optional. Reason authentication was performed, such as “Paymeter”.
AuthProductList
A comma-separated list of Circulation product IDs that limits authentication to subscribers receiving at least one of the specified products.
SubscriptionID
The ID of the subscription being accessed. If only an occupant ID is supplied, Circulation will use the Authentication Detail records defined for the authentication control to determine which subscription was accessed.
* Field is required.
File maps used for the Audit GL Transactions export have a usage of “AuditGLTrans,” and the following data elements can be used:
Amount
GL Account ID
Payment Or Refund Type
Source Code
Authorization Number
GL Batch ID
Posted
Source Code Description
Comments
GL Company ID
Posted Batch ID
Source Field [1-10]
Create Date
GL Tran Date
Posted Date
Source Key [1-10]
Create Time
GL Tran Number
Reason Code
Source Table
Create User
Journal Code
Reason Code Description
Source Tran Number
Credit Card Type
Line Feed
Reference Entity ID
Source Transaction
Filler
Literal Value
Reference Entity Type
Subscription ID
Fiscal Period
Memo
Set Number
Suspended
Fiscal Year
The following data elements can be used with the “BundleTops” usage.
The following data elements can be used with the “CleanseFlagExp” usage.
The following data elements can be used with the “CommHistImport” usage.
The following data elements can be used with the “BalanceFwdBill” usage.
File maps used for the Import Campaign option have a usage “CampaignImp,” and the following data elements can be used. Required fields are indicated with an asterisk (*).
* Field is required.
The following fields are conditionally required and will produce errors if they are not present when expected:
TM Product ID, Reject Response, and Followup Response are required when the Allowable Usage is “Canvass.”
Parent Forecasted Responses and Parent Number Solicited are required when generating a new parent campaign (i.e., if it does not yet exist).
Start Type is required when the Tran Type ID is “Start.”
Delivery Schedule ID is required if the Tran Type is “Start,” “DelivSched,” or “DelivSched w/BillingChg.”
Term and Length are required if the allowable usage is “Renewals.”
The following data elements can be used with the “CleanseFlagImp” usage.
* Field is required.
Account ID
Account ID
Account Name
Account’s name
Account Phone Number
Account’s phone number
Additional Product Detail
AccountID, AccountName, AccountPhoneNumber, AdditionalProductID, AdZoneID, DepartureID, Description, DistribTypeMessage, DropLocationLine [1-6], DropOrder, EditionID, GeneralMessage, InsertMix, LineFeed, LiteralValue, ProductID, PublicationName, PublishDate, RouteID, RouteName, StandardSize, SupplyingTruckID, TotalDraw
Advance Draw Detail
ComboCode, ComponentRouteID, DrawTotal, KeyBundleSize, NumberOfStandardBundles, PaperSectionID, StandardBundleSize
Advance Sections
Number of advance sections
AdZoneID
Ad zone ID
Barcode
The 15-digit barcode
Bulk [Route]
The route’s bulk value from Distribution Maintenance.
Bundle Method
The bundle method
Carrier Collect Draw
Carrier collect draw
Combined Draw Detail
ComponentRouteID, DrawClassID, DrawClassTotal, DrawTotal, KeyBundleSize, NumberOfStandardBundles
CombinedPublGroupDrawDetail
AccountID, AccountName, AccountPhoneNumber, AdZoneID, BundleMethod, ComponentProductID, ComponentPublicationName, DepartureID, DistribTypeMessage, DrawTotal, DropLocationLine [1-6], EditionID, GeneralMessage, InsertMix, KeyBundleSize, LabeledBundles, LineFeed, LiteralValue, MaximumBundleSize, MinimumBundleSize, MultiPackID, NumberOfBundles, NumberOfStandardBundles, ProductID, PublicationName, PublishDate, RouteID, SecondKeyBundleSize, StandardBundleSize, StandardWeight, TruckID, TruckSequenceID, Weight
Component Route Name
The route name, when multiple routes are combined
Departure ID
The truck departure
Distrib Type Message
Route, motor, or single copy message entered in Bundle Info
Draw Comparison
MonthlyAverageLastYear, MonthlyAveragePercentChange, MonthlyAverageQuantityChange, MonthlyAverageThisYear, Weekday, YTDAverageLastYear, YTDAveragePercentChange, YTDAverageQuantityChange, YTDAverageThisYear
Draw Total
Total draw
Drop Location (Lines 1-7)
Drop address (lines 1-6) and drop instructions (line 7)
Drop Order
Drop order
Edition ID
Edition ID
Final Mix
The insert mix name and combo code
General Message
“All” message entered in Bundle Info.
Insert Detail
CustomerName
Insert Mix
Name of the insert mix.
Key Bundle Size
Size of key bundle.
Labeled Bundles
Number of labeled bundles.
Line Feed
A line feed to start a new line.
Literal Value
Literal fields are hard-coded to display whatever is entered in “format”. For example, if a field should always display “Z”, set it up as a literal value and enter “Z” in FORMAT.
Maximum Bundle Size
The maximum size of bundles.
Message Detail
BillingMethod, ComponentProductID, ComponentRouteID, Copies, DeliveryInstructions, DeliveryScheduleID, ExpireDate, MessageDate, MessageText, MessageType, NameAddressLine(1-6), Reason, RestartDate, SubscriberPhoneNumber, SubscriptionID
Message Recap
BillingMethod, ComponentProductID, Copies, DeliveryScheduleID, MessageType
Minimum Bundle Size
The minimum size of bundles.
Number of Bundles
The total number of bundles.
Number of Standard Bundles
The number of standard bundles.
Office Pay Draw
Total office pay draw.
Paid Comp Draw
Total paid comp draw.
Print Key Bundles Only
Print Key Bundles Only field in Enter Bundle Info.
Print Key Bundles Only [Route]
The route’s Print Key Bundle Only value from Distribution Maintenance.
Product ID
ID of the product.
Publication Name
Name of the publication.
Publish Date
The publishing date.
Remarks
Remarks about the subscription.
Route ID
The ID of the route.
Route List
AdditionalProducts, Copies, DeliveryDirections, DeliveryInstructions, NameAddressLine (1-6)
Route Name
The name of the route.
Sample Draw
Total sample draw.
Second Key Bundle Size
If bundle tops are run with a split key, this is the size of the additional key bundle that will be produced.
Service Draw
Total service draw.
Stacker Detail Lines 1-7
Stacker detail lines from Distribution Maintenance.
Standard Bundle Size
The standard bundle size.
Supplying Truck ID
ID of the supplying truck.
Third Party Draw
Total third party draw.
Truck ID
The ID of the truck.
Truck Sequence ID
Truck sequence.
Unpaid Comp Draw
Total unpaid comp draw.
Week Number
The week’s number.
Weight
Total weight.
Wrapper Detail
BundleNumber, BundleSize, CarrierCollectDraw, DrawTotal, KeyBundleSize, NumberOfBundles, NumberOfStandardBundles, OfficePayDraw, PaidCompDraw, SampleDraw, SecondKeyBundleSize, ServiceDraw, StandardBundleSize, ThirdPartyDraw, UnpaidCompDraw, WrapNumber
Year
The year.
Accuracy Factor
Directions To Address
Modify Date
Address ID
Dual Address
Modify Time
Address Sort
Dwelling Status Date
Modify User
Building
Dwelling Status ID
Odd Even
Can Drop Credit
Dwelling Type ID
PO Route Number
Census Block ID
Formatted Address Line [1-6]
PO Route Type
Census Tract ID
House Number
PO Route Walk Sequence
City ID
House Number Modifier
Post Directional
Cleanse
Language
Pre Directional
Cleanse Data Date
Latitude
Route Accessible
Cleanse Date
Level Designator ID
State ID
Cleanse Time
Level Number
Street Name
Cleanse User
Line Feed
Street Suffix ID
Complex
Literal Value
Town of 25 ID
Congressional District
Longitude
Unit Designator ID
Country ID
LOT
Unit Number
County ID
LOT Sequence
Zip Bar Code
Create Date
Mail Accessible
Zip Code
Create Time
Military Foreign
Zip Extension
Create User
Communication Item ID
ID of communication item whose history is being imported.
Communication Method Details*
Occupant’s e-mail address, phone number or address for the communication item above.
Communication Method ID*
Occupant’s communication method (email, phone or mail).
Delivery Date
Date communication was sent to occupant.
Delivery Time
Time communication was sent to occupant.
Occupant ID*
ID of occupant receiving the communication.
Balance Forward Amount
Country Tax Message
Payment Detail
Balance Forward Date
County Tax Amount
Publication Name
Billed Through Date
County Tax Message
Purchase Order Number
Bill To Address 1
Deliver To Address 1
Rate Amount
Bill To Address 2
Deliver To Address 2
Rate Amount Before Tax
Bill To Address 3
Deliver To Address 3
Rate Code ID
Bill To Delivery Point Code
Deliver To Delivery Point Code
Rate Code Message
Bill To Indicator
Deliver To Name
Rate Description
Bill To Name
Deliver To Zip
Renewal Number
Bill To Postal Route
Deliver To Zip Extension
Renewal Period Message 1
Bill To Zip
Delivery Route
Renewal Period Message 2
Bill To Zip Extension
Delivery Schedule ID
Run Date
Carrier Name
Due When
Scan Line
Carrier Primary Phone
Expire Change Detail
Start Reason
City Tax Amount
Expire Date
State Tax Amount
City Tax Message
General Message
State Tax Message
Copy Message 1
Line Feed
Subscription ID
Copy Message 2
Literal Value
Subscription Primary Phone
Country Tax Amount
Payment Adjustment Detail
Total Amount Due
Action*
Event Number
Reason Code*
Allowable Usage*
Followup Response
Reject Response
All Zip Codes*
Forecasted Responses
Renewal Delivery Method
Auto Assign
Image URL
Source Code*
Billing Method*
Is Searchable
Start Date*
Campaign Code*
Length
Start Email Parameters
Campaign Script
Lock Method
Start Type
Combo ID
Number Solicited
Sub Source ID
Confirmation Page Script
Parent Campaign Code*
Term
Cost Per Order
Parent Forecasted Responses
TM Product ID
Delivery Method*
Parent Number Solicited
Tran Type ID*
Delivery Schedule ID
Priority Order
Zip Code
Description
Product ID*
Zip Code List
End Date
Rate Code ID*
Accuracy Factor
Directions To Address
Modify Date
Address ID*
Dual Address
Modify Time
Address Sort
Dwelling Status Date
Modify User
Building
Dwelling Status ID
Odd Even
Can Drop Credit
Dwelling Type ID
PO Route Number
Census Block ID
Filler
PO Route Type
Census Tract ID
Formatted Address Line [1-6]
PO Route Walk Sequence
City ID
House Number
Post Directional
Cleanse*
House Number Modifier
Pre Directional
Cleanse Data Date
Language
Record Identifier
Cleanse Date
Latitude
Route Accessible
Cleanse Time
Level Designator ID
State ID
Cleanse User
Level Number
Street Name
Complex
Line Feed
Street Suffix ID
Congressional District
Literal Value
Town of 25 ID
Country ID
Longitude
Unit Designator ID
County ID
LOT
Unit Number
Create Date
LOT Sequence
Zip Bar Code
Create Time
Mail Accessible
Zip Code
Create User
Military Foreign
Zip Extension
The following data elements can be used with the “DoNotCall” usage.
Action
Add or Delete flag (“A” or “D”), used in DNC changes file.
Area Code*
Subscriber’s area code.
Change Date
Change date, used in DNC changes file.
Filler
Filler fields will be blank.
Phone*
Subscriber’s phone number.
* Field is required
The following data elements can be used with the “DNCImport” usage.
Action
Add or Delete flag (“A” or “D”), used in DNC changes file.
Area Code*
Subscriber’s area code.
Change Date
Change date, used in DNC changes file.
Filler
Filler fields will be blank.
Phone*
Subscriber’s phone number.
* Field is required
The following data elements can be used with the “CCExpire” usage.
AddressLine[1-4]
CreditCardExpires
OccFirstName
BillAddressLine[1-4]
CreditCardExpiresMasked
OccLastName
BillFirstName
CreditCardNumber
OccPhone
BillLastName
CreditCardNumberMasked
PublicationName
BillToCityID
CreditCardTypeID
StateID
BillToStateID
Filler
SubscriptionID
BillToZipCode
LineFeed
ZipBarCode
BillToZipExtension
LiteralValue
ZipCode
CityID
OccAreaCode
ZipExtension
The following data elements can be used with the “CarrierMailExp” usage.
Account ID
The ID of the account.
Account Name
Account’s name
Account Phone Number
Account’s phone number
Ad Zone ID
Ad zone ID
All Message
“All” message entered in Bundle Info.
Billing Method
Account’s billing method
Building
Address’ building
Carrier Notification ID
ID of the account notification method
City ID
City
Complex
Address’ complex
Component Product ID
ID of the component product, if part of a combined publication. Same as the Product ID if there is no combined publication.
Component Route ID
Route ID associated with the component product, if part of a combined publication. Same as the Route ID if there is no combined publication.
Copies
Number of copies
Copies [day of week]
Copies by day of the week
Create Date Create Time Create User
Date, time and user information for the message
Delivery Instructions
Instructions for delivering the paper to the subscriber
Delivery Schedule ID
ID of the delivery schedule
Directions to Address
Directions to the subscriber’s address
Distrib Type Message
Route, motor, or single copy message entered in Bundle Info
Drop Location Line [1-6]
Drop location (lines 1-6)
Drop Order
The drop order of the route on the truck
Edition ID
The route’s edition
Expire Date
Subscription expire date (for office pay subscribers)
External Subscription ID
Subscriber’s ID for external publication
First Name
Occupant’s first name
Honorific ID
Occupant’s honorific
House Number
Address house number
House Number Modifier
Address’ house number modifier
Insert Mix
Name of the insert mix
Last Name
Occupant’s last name
Level Designator ID
Address’ level type
Level Number
Address’ level number
Line Feed
A line feed to start a new line
Literal Value
Literal fields are hard-coded to display whatever is entered in “format”. For example, if a field should always display “Z”, set it up as a literal value and enter “Z” in FORMAT.
Message Date
Date of the message
Message ID
ID of the message
Message Label
Label of the message
Message Text
Text of the message
Message Type
Type of message
Method Type
The type of notification method (e.g., phone type if notification method is phone)
Middle Initial
Occupant’s middle initial
Name Address Line [1-6]
These six lines can be used for the subscriber’s name and address, rather than using individual name and address elements.
Notification Method
Type of account notification (email, phone, etc.)
Notification Method Details
Specific phone number, email address, URL, etc.
Occupant Salutation ID
The occupant’s title
Other Name
Occupant’s other name
Permanent
Indicates whether the reason code is permanent
Postdirectional
Address postdirectional
Predirectional
Address predirectional
Primary Contract Holder
Setting of the Business Rule, What account demographic should be used for the Primary Contract Holder in the Vendor and Carrier Mail Exports? (Account Setup section).
Product ID Publication Name
Subscriber’s publication ID and name
Publish Date
Publishing date on which transaction was processed
Rate Code ID
Subscriber’s rate code
Rate Description
Description of subscriber’s rate code
Reason
Reason code entered for transaction
Restart Date
Subscriber’s restart date
Route ID
ID of the route
Route Name
Name of the route
Source Code
Source code entered for the transaction
State ID
State
Street Name
Address street name
Street Suffix ID
Street type
Subscriber Phone Area Code
Area code of subscriber’s phone number (e.g., the 304 in 3045551234)
Subscriber Phone Number
Subscriber’s phone number, including area code (e.g., 3045551234)
Subscriber Phone Prefix and Line
Subscriber’s phone number, not including area code (e.g., 5551234)
Subscription ID
Subscriber’s subscription ID
Subsource ID
Subsource for source code entered with transaction.
TM Product ID
ID of the TM product
Tran Date
Transaction date for subscriber transaction.
Tran Number
Transaction ID
Tran Type ID
Transaction type
Truck ID
ID of the truck
Unit Designator ID
Address’ unit designator
Unit Number
Address’ unit number
Zip Code
Zip/postal code
Zip Extension
Zip/postal extension
The following data elements can be used with the “ComplaintSummary” usage.
Account ID*
Account Name
Complaint Code*
District Manager
Number of Complaints*
Route ID*
* Field is required.
The following data elements can be used with the “DispatchExport” usage.
AddressLine[1-6]
Dispatch Type
Page Modem Phone
Shortage Quantity
Carriage Return
District ID
Page To Area Code
State ID
Carrier ID
Filler
Page To Phone
Street Name
CityID
First Name
Post Directional
Street Suffix ID
Copies
House Number
Pre Directional
Subscriber Area Code
Create Date
House number Modifier
Product ID
Subscriber Phone
Create Time
Last Name
Reason Code
Subscription ID
Create User
Line Feed
Reason Desc
Tran Date
Delivery Directions
Literal Value
Redelivery
Unit Number
Delivery Request
Message Text
Redelivery Instructions
Unit Type
Delivery Schedule ID
Other Name
Route ID
Urgent
Dispatch
Overage Quantity
Service Area
Zip Code
DispatchID
Page Modem Area Code
The standard export file maps for the Dispatch Interface are given below. “Dispatch” is the standard format, and “DispatchPlus” is the standard format plus the Redelivery and Dispatch flags at the end.
10
Dispatch Type
Dispatch Type
20
Page Modem Area Code
Page Modem Area Code
30
Page Modem Phone
Page Modem Phone
40
Page To Area Code
Page To Area Code
50
Page To Phone
Page To Phone
60
Service Area
Service Area
70
District ID
District ID
80
Product ID
Product ID
90
Route ID
Route ID
100
Carrier ID
Carrier ID
110
Create Date
Create Date
120
Create Time
Create Time
130
Create User
Create User
140
Subscription ID
Subscription ID
150
Delivery Schedule ID
Delivery Schedule ID
160
Reason Code
Reason Code
170
Reason Desc
Reason Desc
180
Address Line 1
Address Line 1
190
Address Line 2
Address Line 2
200
Address Line 3
Address Line 3
210
Address Line 4
Address Line 4
220
Address Line 5
Address Line 5
230
Address Line 6
Address Line 6
240
Redelivery Instructions
Redelivery Instructions
250
Delivery Directions
Delivery Directions
260
Delivery Request
Delivery Request
270
Urgent
Urgent
280
Subscriber Area Code
Subscriber Area Code
290
Subscriber Phone
Subscriber Phone
300
Message Text
Message Text
310
Shortage Quantity
Shortage Quantity
320
Overage Quantity
Overage Quantity
330
Dispatch ID
Dispatch ID
340
Filler
350
Redelivery
360
Filler
370
Dispatch
The following data elements can be used with the “ComplaintDetail” usage.
Account Name
Delivery Schedule ID
Modify User
Address ID
Discount
Name Address Line [1-6]
Bonus
Dispatch Date
Number of Complaints
Bundle Print Date
Dispatch Time
Number of Formal Complaints
Card Print Date
Dispatch User
Occupant ID
Cause Code
District ID
Print For Carrier
Charge Batch ID
District Manager
Redeliver
Complaint Code ID
DM Call
Redeliver Instructions
Complaint Date
External Subscription ID
Route ID*
Complaint Text
Formal
Sequence Number
Complaint Time
Formal Address ID
Source Code
Compliance Date
Formal Complaint Date
Subscriber Phone
Compliance Time
Formal Complaint Time
Subscription ID*
Create Date
Formal Occupant ID
Tran Number
Create Time
Modify Date
Urgent
Create User
* Field is required.
File maps used for the Audit GL Interface Journal export have a usage of “GLAudit,” and the following data elements can be used:
Amount
GLCompanyID*
Comments
GLTranDate
CreateDate
GLTranNumber*
CreateTime
JournalCode
CreateUser
Memo
CreditAmount
Posted
DebitAmount
PostedBatchID
FiscalPeriod
PostedDate
FiscalYear
ReferenceEntityID
GLAccountID*
ReferenceEntityType
GLBatchID
Suspended
* Field is required.
The following data elements can be used with the “DrawChgImport” usage.
Adjust or Replace
Indicates whether the draw should be adjusted (increased or decreased) or replaced.
Draw Change Amount (Mon-Sun)
The amount that the draw should be adjusted or replaced. Negative adjustments will have a minus (-) sign.
Draw Type Class
The draw class.
Effective Date
The first date that this draw change will be in effect.
Filler
Filler fields will be blank.
Product ID
The product to which this draw change applies.
Record Identifier**
Field that identifies the record type, for example “D” to indicate a detail record. This must be the first field in the record.
Reversal Date
The date on which the draw change should be reversed (may be blank).
Route ID*
The ID of the route.
* Field is required
** Field is required if a record identifier is entered on the record type setup screen.
The following data elements can be used with the “DropCreditAudit” usage.
Account Area Code
Account First Name
Account Formatted Phone
Account Honorific ID
Account ID
Account Last Name
Account Middle Initial
Account Name Address [1-6]
Account Other Name
Account Other Name Usage
Account Phone
Account Salutation ID
Address detail
Bill Account fields (same as account fields, above)
Bill Source Description
Bill Source ID
Company ID
Company Name
Line Feed
Literal Value
Process End Date
Process Start Date
The following data elements can be used with the “DropTimeImport” usage.
Delivery Date
Delivery Time
Departure ID
Drop Order
Product ID
Run Date
Truck ID*
Truck Sequence ID
* Field is required.
The following data elements can be used with the “DrawAdjImport” usage.
AAM Draw Date
The draw adjustment date for AAM reporting purposes. This will be the same as the Draw Date unless AAM has already been closed for the draw date.
Amount Collected
The amount collected from the route.
Control Total
Populates the Control Papers field in Returns for a Day and Returns for a Week.
Draw Adjustment
The draw adjustment quantity.
Draw Date
The publishing date for the returns.
Import Edition ID
The edition of the product that is being returned. Note: If ImportEditionID is included in the import file for draw adjustment transactions, it will be ignored upon import.
Product ID
The product that is being returned.
Record Identifier
Field that identifies the record type, for example “D” to indicate a detail record. This must be the first field in the record.
Route ID*
The ID of the route. This field is required.
* Field is required
The following data elements can be used with the “DrwForecastExprt” usage.
The following data elements can be used with the “NoteImport” usage.
* Field is required.
The following data elements can be used with the “MiscChgCredImp” usage.
File maps used for the GL Export have a usage of “GLExport,” and the following data elements can be used:
Account ID
Drop Country ID
Export End Date
Address Line [1 - 6]
Drop County ID
Export Start Date
Area ID
Drop House Number
Filler
Demographic Answer
Drop House Number Modifier
Line Feed
Distribution Type
Drop Post Directional
Literal Value
Distrib Zone ID
Drop Pre Directional
Other Name
District ID
Drop State ID
Product ID
Draw Adjust Total
Drop Street Name
Region ID
Draw Class ID
Drop Street Suffix ID
Return Total
Draw Date
Drop Unit Designator ID
Route Class ID
Draw Total
Drop Unit Number
Route ID
Drop Address Line [1-6]
Drop Zip
Route Name
Drop City ID
Drop Zip Extension
Route Type ID
Edition ID
Truck ID
Filler
Filler fields will be blank.
Reason
Reason code entered for the transaction
Remarks*
Remarks, if any, on the note transaction. Field has a maximum of 2000 characters.
Source
Source code entered for the transaction
SubscriptionID*
Subscriber’s subscription ID
TranDate
Transaction date for note transaction
Account ID*
Carrier’s account ID
Amount*
Charge/credit amount (format 9999.99)
Charge Code ID
ID of miscellaneous charge/credit code used with charge
Charge Date
Date of charge
Description
Description of charge
Draw Total
Draw of route associated with charge/credit
Remarks
Remarks, if any, on the charge/credit
Route ID
Route associated with charge/credit
Amount
Fiscal Period YY
GL Transaction Posted Batch ID
Reference Entity Type
Authorization Number
Fiscal Year
GL Transaction Posted Date
RollUpGLAccountID
Chart of Accounts Description
GL Account ID
Journal Code
Set Number
Comments
GL Account ID Char1-5
Journal Code YYPP
Source Code
Control Total Credits
GL Account ID Char7-11
Line Feed
Source Code Description
Control Total Debits
GL Account ID Char13-17
Literal Value
Source Field [1-10]
Create Date
GL Account ID Char19-22
Memo
Source Key [1-10]
Create Time
GL Batch ID
Payment Or Refund Type
Source Table
Create User
GL Company ID
Process Start Date
Source Tran Number
Credit Card Type
GL Journal Description
Process End Date
Source Transaction
Filler
GL Tran Date
Reason Code
Subscription ID
Fiscal Period
GL Tran Number
Reason Code Description
Suspended
GL Transaction Posted
Reference Entity ID
Total Journal Entries Exported
The following data elements can be used with the “PymtAuthor” usage.
Abort Status
Indicates whether the payment was processed.
Account Number
Account number for bank draft payments/declines.
Address Verification
Indicates whether the subscriber’s address has been verified.
Authorization Number
Payment authorization number, typically supplied for credit card payments.
BACS Originator ID
Bank originator ID for draft payments/declines.
Bank Number
Bank number for draft payments/declines.
Batch Count
The total number of records in the batch.
Batch Date
The date the batch was created.
Batch Total
The total amount for the payment batch.
Beginning Sequence
This data element is not currently used.
Credit Card Number
The subscriber’s credit card number.
Edgil ID
ID assigned to the payment by the Edgil system.
Ending Sequence
This data element is not currently used.
File Sequence
This data element is not currently used.
Filler
Filler denotes blank fields or information that will not be used in Circulation; these fields will be ignored.
Merchant ID
Credit card merchant ID
Record Identifier**
Field that identifies the record type, for example “D” to indicate a detail record. This must be the first field in the record.
Reference Number
Unique customer reference (could include account number).
Remarks
Remarks.
Response Message
Payment authorization response text.
Subscription ID
Subscriber’s account ID in Circulation.
Tran Amount*
Payment amount.
Tran Code
Transaction code that describes the type of payment.
Tran Date
Date of payment.
Tran Number
Payment transaction number.
Trans Sequence
This data element is not currently used.
Tran Status
Status of payment (authorized, rejected, etc.).
* Field is required
** Field is required if a record identifier is entered on the record type setup screen.
The following table lists the data elements available for the “PostSubFull” usage, which is used for the Finnish Post Export with an export type of “Full Audit.”
Activity Indicator
Carriage Return
Copies
Delivery Frequency
Filler
Line Feed
Literal Value
Other Name
Post Code
Product ID
Publish Date
Route ID
Subscriber Address
Subscriber Name
Subscriber Name + Other Name
Subscription ID
File maps used for the GL Interface Journal export have a usage of “GLInterJrnl,” and the following data elements can be used:
Amount
GLTranDate
OccupantTypeID
Comments
GLTranNumber
OtherName
DebitOrCredit
HonorificID
Posted
DtCrAmount
JournalCode
PostedBatchID
FirstName
LastName
PostedDate
FiscalPeriod
Memo
ReferenceEntityID
FiscalYear
MiddleInitial
ReferenceEntityType
GLAccountID
OccupantID
SetNumber
GLBatchID
OccupantSalutationID
Suspended
GLCompanyID
OccupantTitle
The following table lists the data elements available for the “SubBilling” File Map usage.
SubscriptionID
RateTerm2ExpireDate
LastName
RateTerm3Amount
FirstName
RateTerm3ExpireDate
HouseNumber
RateTerm3Length
StreetName
RateTerm4Amount
StreetSuffixID
RateTerm4ExpireDate
UnitDesignatorID
RateTerm4Length
UnitNumber
RateTerm1PremiumAmount
CityID
RateTerm2PremiumAmount
StateID
RateTerm3PremiumAmount
ZipCode
RateTerm4PremiumAmount
RateTerm1Amount
RateTerm1AmountWithTaxes
RateTerm1ExpireDate
ActivationFeeAmount
RateTerm1Length
PrintedBillFeeAmount
RateTerm2Amount
ProductID
ActivationFeeTax
ActivationCityFeeTax
ActivationCountyFeeTax
ActivationStateFeeTax
ActivationCountryFeeTax
PrintedBillFeeTax
PrintedBillCityFeeTax
PrintedBillCountyFeeTax
PrintedBillStateFeeTax
PrintedBillCountryFeeTax
The following data elements can be used with the “OfficePayAudit” usage.
Address ID
Delivery Placement ID
Longitude
Receive Bonus Days
Allow Web Access
Delivery Schedule ID
Mail Accessible
Renewal Delivery Override
Area Code
Directions To Address
Middle Initial
Renewal Override Code
Area Code + Phone
Dwelling Status Date
Military Foreign
Report Period End Date
Attention Line
Dwelling Status ID
Name Address Line [1-6]
Report Period Start Date
Auto Pay
Dwelling Type ID
Number of Renewals Sent
Route Accessible
Bill Address ID
Email Address
Occupant ID
Route ID
Billing Method
Expire Date
Occupant Salutation ID
Route Name
Bill Occupant ID
Extension
Occupant Title
Send Invoice
Bill Source ID
Firm Name
Occupant Type ID
Send Renewal
Building
First Name
Original Start Date
Short Name
Carrier ID
Gets Paper
Other Name
State ID
Carrier Name
Home Page
Other Name Usage
Street Name
Census Block ID
Honorific ID
Phone
Street Suffix ID
Census Tract ID
House Number Modifier
Phone Unlisted
Subscriber
City ID
Last Name
PO Route Number
Subscription ID
Company ID
Last Payment Amount
PO Route Type
Subscription Status
Complaint Days Adjust
Last Payment Date
PO Route Walk Sequence
Town of 25 ID
Complex
Last Payment Length
Post Directional
Transaction Detail
Country ID
Last Payment Method
Pre Directional
Unit Designator ID
County ID
Last Payment Term
Product ID
Unit Number
Credit Detail
Latitude
Publication Name
Zip Bar Code
Date Last Renewal Sent
Line Feed
Purchase Number
Zip Code
Delivery Instructions
Literal Value
Rate Code ID
Zip Extension
The following data elements can be used with the “MerchandiseRpt” usage.
Account First Name
Bill To Street Name
Longitude
Account Honorific ID
Bill To Street Suffix ID
LOT
Account ID
Bill To Town Of 25 ID
LOT Sequence
Account Last Name
Bill To Unit Designator ID
Mail Accessible
Account Middle Initial
Bill To Unit Number
Merchandise Code
Account Occupant ID
Bill To Zip Bar Code
Middle Initial
Account Occupant Salutation ID
Bill To Zip Code
Military Foreign
Address ID
Bill To Zip Extension
Name Address Lines [1-6]
Billing Method
Campaign Code
Occupant ID
Bill To Address ID
Canvass Board Number
Occupant Type ID
Bill To Building
Carrier ID
Other Name
Bill To Census Block ID
Census Block ID
Other Name Usage
Bill To Census Tract ID
Census Tract ID
Payment Amount
Bill To City ID
City ID
Payment Term Length
Bill To Complex
Complex
PO Route Number
Bill To Congressional District
Congressional District
PO Route Type
Bill To Country ID
Country ID
PO Route Walk Sequence
Bill To County ID
County ID
Post Directional
Bill To Dwelling Status Date
Delivery Schedule ID
Pre Directional
Bill To Dwelling Status ID
Description
Process Date
Bill To Dwelling Type ID
Dwelling Status Date
Product ID
Bill To House Number
Dwelling Status ID
Reason Code
Bill To House Number Modifier
Dwelling Type ID
Route Accessible
Bill To Language
Email Address
Route ID
Bill To Latitude
First Name
Source Code
Bill To Level Designator ID
Formatted Phone
State ID
Bill To Level Number
Fulfillment Date
Street Name
Bill To Longitude
Honorific ID
Street Suffix ID
Bill To LOT
House Number
Subscription ID
Bill To LOT Sequence
House Number Modifier
Town of 25 ID
Bill To Mail Accessible
Language
Tran Date
Bill To Military Foreign
Last Name
Tran Type
Bill To Name Address Line [1-6]
Latitude
Unit Designator ID
Bill To PO Route Number
Level Designator ID
Unit Number
Bill To PO Route Type
Level Number
Zip Bar Code
Bill To PO Route Walk Sequence
Line Feed
Zip Code
Bill To State ID
Literal Value
Zip Extension
The following table lists the data elements available for the “PostBillExp” usage, which is used for the Finnish Post Export with an export type of “Billing.”
Carriage Return
Filler
Line Feed
Literal Value
Price Code
Publish Date
Quantity
Service Code
USPS Number
Volume Number
Weight
The following data elements can be used with the “PastDueLetter” usage.
Account ID
The account ID of the carrier/dealer.
Age Balance
The balance due for an aging period.
Age Current
The current balance due.
Age Periods 1-4
Up to four aging periods can be included.
Age Unapplied
The unapplied amount for an aging period.
Allow Web Access
Allow web access setting (yes/no)
Area Code
Area code portion of the account’s phone number.
Attention Line
Occupant’s attention line.
Collector ID
ID of the collector assigned to this account.
Company Name
Name of the company.
Delivery Date
The date the letter was delivered.
Due Date
Date on which the balance is due.
Due Day Name
Day of the week the balance is due.
EMail Address
Occupant’s email address.
Extension
Occupant’s phone number extension.
Firm Name
Firm name, if other name usage is “Firm”.
First Name
Occupant’s first name.
Formatted Phone
Occupant’s formatted phone number.
Honorific ID
Occupant’s honorific (name suffix)
Last Bill Amount
Amount of the last bill.
Last Bill Date
Date of the last bill.
Last Invoice Date
Date of the last invoice.
Last Name
Occupant’s last name.
Last Payment Amount
Amount of last payment.
Last Payment Date
Date of last payment.
Literal Value
Literal fields are hard-coded to display whatever is entered in “format”. For example, if a field should always display “Z”, set it up as a literal value and enter “Z” in FORMAT.
Middle Initial
Occupant’s middle initial.
Name Address Line 1
Address lines 1 through 6 (using unparsed addresses)
Occupant Title
Occupant’s title.
Occupant TypeID
Account’s occupant type.
Other Name
Occupant’s other name.
Other Name Usage
Usage of occupant’s other name.
Past Due Amount
Past due amount.
Phone
Occupant’s phone number.
Phone Unlisted
Phone number unlisted setting (yes/no)
Short Name
Abbreviated company name used by banks.
Terms ID
Subscription term.
Truck ID
Truck ID from the truck sequence files.
The following data elements can be used with the “ProofOfSale” usage.
AccountID*
The account to which the proof of sale applies.
AdjustmentAmount*
The copies sold amount.
BillSourceID
The account’s bill source.
CompanyID
The account’s company.
InvoiceNumber
The invoice number for the copies sold.
TranDate
The transaction date for copies sold.
* Field is required
The following table lists the data elements available for the “PostSubAudit” usage, which is used for the Finnish Post Export with an export type of “Subscriber Audit.”
Activity Indicator
Carriage Return
Copies
Delivery Frequency
Filler
Line Feed
Literal Value
Other Name
Post Code
Product ID
Publish Date
Route ID
Subscriber Address
Subscriber Name
Subscriber Name + Other Name
Subscription ID
The following data elements can be used with the “RouterImport” usage.
AAM Zone ID
Address ID*
New Route ID*
Old Route ID*
Product ID*
Record Identifier
* Indicates a required element
The following data elements can be used with the “RouteAddrLabel” usage, which can be used with the Route Labels and Previous Delivery Labels menu options.
Address Line [1-5]
House Number
Product ID
Attention Line
House Number Modifier
Route ID
Building
Label Detail*
Route Name
City ID
Last Name
State ID
Complex
Line Feed
Street Name
District Description
Literal Value
Street Suffix ID
District ID
Mail Stop
Subscription ID
Drop Order
Middle Initial
Truck ID
Edition ID
Occupant Title
Unit Designator ID
Expire Date
Other Name
Unit Number
Filler
Other Name Usage
Zip Code
Firm Name
Post Directional
Zip Code + Zip Extension
First Name
Pre Directional
Zip Extension
Honorific ID
* Can contain the following detail elements:
Attention Line, Building, City ID, Complex, Country ID, District Description, District ID, Drop Order, Edition Id, Expire Date, Filler, Firm Name, First Name, Honorific ID, House Number, House Number Modifier, Label Line [1-6], Last Name, Line Feed, Literal Value, Mail Stop, Middle Initial, Occupant Title, Other Name, Other Name Usage, Post Directional, Pre Directional, Product ID, Route ID, State ID, Street Name, Street Suffix ID, Subscription ID, Truck ID, Unit Designator ID, Unit Number, Zip Code, Zip Extension
The following data elements can be used with the “SCByDay” usage.
Adjust Copies
Area
Company ID
Copies Delivered
Copies Returned
District
Draw Date
Filler
Line Feed
Literal Value
Location
Net Returns And Adjust
Net Sales
Product ID
Publication Name
Region
Return Percentage
Route ID
Sell Out
Single Copy Type
Zone
The following table lists the data elements that can be used with the “RouteData” file map usage, which is used for exporting the Route Delivery List.
Address ID
Drop Location
Region ID
Address Line [1-5]
Dwelling Status Date
Route Accessible
Area ID
Dwelling Status ID
Route ID
Building
Dwelling Type ID
State ID
Census Block ID
Filler
Street Name
Census Tract ID
House Number
Street Suffix ID
City ID
House Number Modifier
Supply Truck ID
Complex
Line Feed
Town of 25 ID
Country ID
Literal Value
Truck ID
County ID
Mail Accessible
Truck Name
Delivery Detail (has detail)*
Military Foreign
Unit Designator ID
Delivery Placement ID
PO Route Number
Unit Number
Demographic Answer
PO Route Type
Zip Bar Code
Depot ID
PO Route Walk Sequence
Zip Code
Directions To Address
Post Directional
Zip Code + Zip Extension
Distrib Zone ID
Pre Directional
Zip Extension
District ID
* Delivery Detail can include the following detail elements:
AddressID, AddressLine[1-5], AllowWebAccess, AreaCode, AreaCode+Phone, AreaID, AttentionLine, Building, CensusBlockID, CensusTractID, CityID, Complex, Copies[Sun-Sat], CountryID, CountyID, DeliveryInstructions, DeliveryPlacementID, DeliveryScheduleID, DepotID, DirectionsToAddress, DistribZoneID, DistrictID, DropLocation, DwellingStatusDate, DwellingStatusID, DwellingTypeID, Extension, ExternalSubscriptionID, Filler, FirmName, FirstName, HouseNumber, HouseNumberModifier , LastName, LineFeed, LiteralValue, MailAccessible, MilitaryForeign, Name, NameAddress [Lines1-6], OccupantID, OccupantTitle, OccupantTypeID, OriginalStartDate, OtherName, OtherNameUsage, Phone, PhoneUnlisted, PORouteNumber, PORouteType, PORouteWalkSequence, PostDirectional, PreDirectional, ProductID, RateCodeID, RegionID, RenewalDeliveryOverride, RenewalOverrideCode, RouteAccessible, RouteID, ShortName, StateID, StreetName, StreetSuffixID, SubscriptionID, TownOf25ID, UnitDesignatorID, UnitNumber, ZipBarCode, ZipCode, ZipCode+ZipExtension, ZipExtension
The following table lists the data elements available for the “ReturnsJournal” File Map usage. Some of the data elements are valid only for certain types of draw adjustments (route, single copy, or TM), and the table shows which elements are valid for each. When a data element is exported for a table that does not use that field, a blank will be exported instead of a value.
ProductID*
X
X
X
RouteID*
X
X
X
DrawDate
X
X
X
DrawClassID
X
SequenceNumber
X
X
X
DrawAdjustID
X
X
X
AAMDrawDate
X
X
X
DrawAdjustDate
X
X
X
DrawAdjustment
X
X
X
DrawAdjustBatchID
X
X
X
BillBatchID
X
X
X
FullyBilled
X
X
X
AmountCollected
X
ShortageTranNumber
X
IsBadEdition
X
IsOverSupply
X
X
IsEarlyLateReturn
X
X
X
Remarks
X
ChargeBatchID
X
X
X
ChargeSequenceNumber
X
X
X
CreditSequenceNumber
X
X
X
ImportEditionID
X
TMProductID
X
DeliveryDate
X
DeliveryScheduleID
X
CarrierCollectDrawAdjust
X
OfficePayDrawAdjust
X
PaidCompDrawAdjust
X
UnpaidCompDrawAdjust
X
SampleDrawAdjust
X
ServiceDrawAdjust
X
ThirdPartyDrawAdjust
X
SubscriptionID
X
TranNumber
X
AAMColumnID
X
CreateDate
X
X
X
CreateTime
X
X
X
CreateUser
X
X
X
* Field is required.
The following data elements can be used with the “RouteSmart” usage.
AddressID
AddressLine1
AddressLine2
AddressLine3
AddressLine4
AddressLine5
AreaID
Building
CensusBlockID
CensusTractID
CityID
Complex
CountryID
CountyID
DeliveryDetail*
DeliveryPointID
DemographicAnswer
DepotID
DirectionsToAddress
DistribZoneID
DistrictID
DropLocation
DwellingStatusDate
DwellingStatusID
DwellingTypeID
Filler
HouseNumber
HouseNumberModifier
LevelDesignatorID
LevelNumber
LiteralValue
MailAccessible
MilitaryForeign
PORouteNumber
PORouteType
PORouteWalkSequence
PostDirectional
PreDirectional
RegionID
RouteAccessible
RouteID
StateID
StreetName
StreetSuffixID
SupplyTruckID
TownOf25ID
TruckID
TruckName
UnitDesignatorID
UnitNumber
ZipBarCode
ZipCode
ZipCode+ZipExtension
ZipExtension
* Indicates a required element
The following data elements can be used with the “SoldImport” usage.
* Field is required
The following data elements can be used with the “StatusCollctCard” usage.
The following data elements can be used with the “SubBilling” usage.
The following data elements can be used with the “SubActivityImprt” usage. Data elements marked with an asterisk (*) contain detail elements that are listed in a separate table. Note that either a SubscriptionID must be supplied, or enough occupant and address data to match or create a subscription. Also note that elements listed in one of the Detail Element tables must be defined in the format as sub-elements under that detail element. For example, the reason code for a payment must be imported with the ReasonCode element within the PaymentDetail element.
The following data elements can be used with the “Stacker” usage.
ProductID
The product to which the sold/shrink copies apply.
RouteID*
The ID of the route.
DrawDate
Date of the sold/shrink draw adjustment.
DrawAdjustment*
Draw adjustment for sold/shrink copies for the route.
Account Area Code
Delivery Schedule ID
Rate Per Week
Account ID
Edition ID
Route ID
Account Name
Expiration Date
State Tax Per Week
Account Phone
First Name
Subscription ID
Activity Type
Last Name
Supply Truck
Area Code
Name Address Line [1-6]
Total Amount Per Week
Card Type
Number of Copies [Sun-Sat]
Transaction Date
City Tax Per Week
Phone
Truck Drop Sequence
Country Tax Per Week
Product ID
Truck ID
County Tax Per Week
Publish Date
Truck Sequence ID
Current Press Run Date
Rate Code End Date
Walk Sequence
Delivery Instructions
Rate Code ID
AddressID
AddressLine[1-5]
AllowWebAccess
AreaCode
AreaManager
AttentionLine
BillToAddressID
BillToAddressLine[1-5]
BillToAllowWebAccess
BillToAreaCode
BillToAttentionLine
BillToBuilding
BillToCensusBlockID
BillToCensusTractID
BillToCityID
BillToComplex
BillToCountryID
BillToCountryName
BillToCountyID
BillToDeliveryInstructions
BillToDirectionsToAddress
BillToDwellingStatusDate
BillToDwellingStatusID
BillToDwellingTypeID
BillToEmailAddress
BillToExtension
BillToFirmName
BillToFirstName
BillToHouseNumber
BillToHouseNumberModifier
BillToIMBarcode
BillToIMBarcodeMC
BillToIMBarcodeUC
BillToIndicator
BillToIsOnline
BillToLastName
BillToMailAccessible
BillToMilitaryForeign
BillToName
BillToNameAddressLine[1-6]
BillToOccupantID
BillToOccupantTitle
BillToOccupantTypeID
BillToOtherName
BillToOtherNameUsage
BillToPORouteNumber
BillToPORouteType
BillToPORouteWalkSequence
BillToPhone
BillToPhoneUnlisted
BillToPostDirectional
BillToPreDirectional
BillToRouteAccessible
BillToRouteID
BillToShortName
BillToStateID
BillToStateName
BillToStreetName
BillToStreetSuffixID
BillToTownOf25ID
BillToUnitDesignatorID
BillToUnitNumber
BillToZipBarCode
BillToZipCode
BillToZipCode+ZipExtension
BillToZipExtension
Building
CarrierAreaCode
CarrierName
CarrierPhone
CensusBlockID
CensusTractID
CityID
CityTaxMessage
CityTaxPercentage
Complex
Copies [day of week]
CopyMessage1
CopyMessage2
CountryID
CountryName
CountryTaxMessage
CountryTaxPercentage
CountyID
CountyTaxMessage
CountyTaxPercentage
DeliveryInstructions
DeliveryScheduleID
DemographicDetail
DepotID
DirectionsToAddress
DistrictManager
DropOrder
DueDate
DwellingStatusDate
DwellingStatusID
DwellingTypeID
EmailAddress
EndGraceDate
ExpireChangeMessage[1-10]
ExpireChangeDetail
ExpireDate
Extension
Filler
FirmName
FirstName
GeneralMessage
GraceAccrualDetail
HouseNumber
HouseNumberModifier
IsOnline
LastName
LastPaymentAmount
LastPaymentEffectiveDate
LastPaymentLength
LastPaymentRateCodeID
LastPaymentTerm
LastStartReasonCode
LineFeed
LiteralValue
MailAccessible
MilitaryForeign
NameAddressLine[1-6]
NumberOfPayments
OccupantID
OccupantTitle
OccupantTypeID
OriginalStartDate
OtherName
OtherNameUsage
PORouteNumber
PORouteType
PORouteWalkSequence
PaymentDetail
Phone
PhoneUnlisted
PostDirectional
PreDirectional
ProductID
PublicationName
PurchaseNumber
RateCodeID
RateCodeMessage[1-4]
RateTerm[1-4]StartDate
RateTerm[1-4]EndDate
RateTerm[1-4]ExpireDate
RateTerm[1-4]Amount
RateTerm[1-4]AmountWithTaxes
RateTerm[1-4]TotalTax
RateTerm[1-4]Description
RateTerm[1-4]CityTaxAmount
RateTerm[1-4]CountryTaxAmount
RateTerm[1-4]CountyTaxAmount
RateTerm[1-4]StateTaxAmount
RateTermsDetail
RegionManager
RenewalDeliveryMethod
RenewalDeliveryOverride
RenewalPeriodMessage1
RenewalPeriodMessage2
RenewalNumber
RenewalOverrideCode
RenewalType
RouteAccessible
RouteID
RouteType
RouteWalkSequence
RunDate
ScanLine
SequenceValue
ShortName
StateID
StateName
StateTaxMessage
StateTaxPercentage
StreetName
StreetSuffixID
SubscriberName
SubscriptionID
TermEndDate
TermStartDate
TownOf25ID
TripID
TripWalkSequence
TruckID
UnallocatedAmount
UnitDesignatorID
UnitNumber
ZipBarCode
ZipCode
ZipCode+ZipExtension
ZipExtension
ZoneManager
*
SubscriptionID
ExpireDate
LiteralValue
LineFeed
Filler
CampaignDetail
CampaignCode
CampaignScript
DeliveryScheduleID
Description
RateCodeID
ReasonCode
RequiredLength
RequiredTerm
SourceCode
TranTypeID
DemographicDetail
Answer
DemographicID
DemographicTypeID
ExpireChangeDetail
AmountAdjusted
Comments
CouponAmount
DaysAdjust
DonationAmount
PaymentAmount
ReasonCode
RenewalDescription
TipAmount
TranDate
TranTypeID
TransferAmount
TransferDays
GraceAccrualDetail
DiscountAmount
GraceOwedAmount
GraceDays
TranDate
NotificationDetail
NotificationTitle
Details
PaymentDetail
EffectiveDate
PaymentAmount
PaymentLength
PaymentTerm
RateCodeID
RateTermsDetail
Amount
AmountWithTax
AmountByDate
CityTaxAmount
CountryTaxAmount
CountyTaxAmount
Description
DiscountAmount
PaymentLength
PaymentTerm
StateTaxAmount
TermEndDate
TermExpireDate
TermStartDate
TransportationCost
AddressID
DateField[3]
IntegerField[2]
Phone
AddressLine
DateField[4]
IntegerField[3]
PostDirectional
AreaCode
DateField[5]
IntegerField[4]
PreDirectional
BillingChangeDetail*
DecimalField[1]
IntegerField[5]
ProductID (required)
Building
DecimalField[2]
LastName
RecordIdentifier
CharacterField[1]
DecimalField[3]
LevelDesignatorID
RestartDetail*
CharacterField[2]
DecimalField[4]
LevelNumber
SolicitationCodeID[1]
CharacterField[3]
DecimalField[5]
LogicalField[1]
SolicitationCodeID[2]
CharacterField[4]
DeliveryAddressDetail*
LogicalField[2]
StartDetail*
CharacterField[5]
DeliveryMethod
LogicalField[3]
StateID
CityID
DeliveryScheduleChangeDetail*
LogicalField[4]
StopDetail*
CityStateLine
DemographicAnswerDetail*
LogicalField[5]
StreetName
ComplaintDetail*
ExternalSubscriptionID
MiddleInitial
StreetSuffixID
Complex
Filler
MoveDetail*
SubscriptionID
ComboChangeDetail*
FirstName
NameLine
UnitDesignatorID
CountryID
HonorificID
OccupantID
UnitNumber
CountyID
HouseNumber
OccupantSalutationID
ZipCode
DateField[1]
HouseNumberModifier
OrderCode
ZipExtension
DateField[2]
IntegerField[1]
PaymentDetail*
DigitalAddress
EmailAddress
GNAF-PID
HIN
ReasonCode
SourceCode
StreetNameAndSuffixLine
TranDate
TranTypeID
Trial
Trial Length
Trial Term
AAMColumnID
BillToCityID
BillToStreetSuffixID
RenewalDeliveryMethod
AccountHolderName
BillToComplex
BillToUnitDesignatorID
RenewalOverrideCode
AccountNumber
BillToCountryID
BillToUnitNumber
SendInvoice
AccountType
BillToCountyID
BillToZipCode
SendRenewal
AdjustmentAmount[1]
BillToCreditStatusID
BillToZipExtension
SendStatement
AdjustmentAmount[2]
BillToEMailAddress
CreditCardExpires
SourceCode (required)
AdjustmentAmount[3]
BillToFirstName
CreditCardNumber
SubAdjustCodeID[1]
AdjustmentAmount[4]
BillToHonorificID
CreditCardTypeID
SubAdjustCodeID[2]
AdjustmentAmount[5]
BillToHouseNumber
CreditStatusID
SubAdjustCodeID[3]
AuthorizationNumber
BillToHouseNumberModifier
DateLastRenewalSent
SubAdjustCodeID[4]
AutoRenew
BillToLastName
EbillEmailAddress
SubAdjustCodeID[5]
AutoRenewLength
BillToLevelDesignatorID
EMailAddress
SubSourceID
AutoRenewTerm
BillToLevelNumber
Filler
TaxExemptReason[City]
AutoRenewType
BillToMiddleInitial
MaskedCreditCardNumber
TaxExemptReason[Country]
BankClientType
BillToOccupantTypeID
NumberOfRenewalsSent
TaxExemptReason[County]
BankNumber
BillToPhone
OccupantTypeID
TaxExemptReason[State]
BillingGroupID
BillToPhoneUnlisted
PurchaseNumber
TipAmount
BillingMethod
BillToPostDirectional
RateCodeID
TranDate (required)
BillToAddressID
BillToPreDirectional
ReasonCode (required)
VaultCustomerID
BillToAreaCode
BillToStateID
ReceiveBonusDays
VaultID
BillToBuilding
BillToStreetName
Remarks
AutoRenewPayPalEmailAddress
EffectiveDate
ChargeCarrier
ReasonCode (required)
ComplaintDate (required)
Redeliver
ComplaintText
RedeliverInstructions
DaysAdjust
SourceCode (required)
Dispatch
Urgent
Filler
ComboID (required)
Remarks
TranDate (required)
SourceCode (required)
RateCodeID (required)
SubsourceID
ReasonCode (required)
EbillEmailAddress
RenewalDeliveryMethod
RenewalOverrideCode
AddressID (required)
LevelDesignatorID
ValidDeliveryDay[1] (at least 1 ValidDeliveryDay required)
Building
LevelNumber
ValidDeliveryDay[2]
CityID
PostDirectional
ValidDeliveryDay[3]
Complex
PreDirectional
ValidDeliveryDay[4]
CountryID
StateID
ValidDeliveryDay[5]
CountyID
StreetName
ValidDeliveryDay[6]
Filler
StreetSuffixID
ValidDeliveryDay[7]
HouseNumber
UnitDesignatorID
ZipCode
HouseNumberModifier
UnitNumber
ZipExtension
GNAF-PID
HIN
Copies[1] (at least Copies field required)
Copies[7]
ReasonCode (required)
Copies[2]
DeliveryScheduleID (required)
Remarks
Copies[3]
Filler
SourceCode (required)
Copies[4]
MerchandiseCode
SubSourceID
Copies[5]
PreviousDeliveryRequested
TranDate (required)
Copies[6]
RateCodeID
NewDeliveryMethod
NewLabelGroupID
NewRouteID[1]
NewRouteID[2]
NewRouteID[3]
NewRouteID[4]
NewRouteID[5]
NewRouteID[6]
NewRouteID[7]
Answer (required)
DemographicID (required)
Filler
Replace
AAMZoneID
Copies[5]
MoveInDate (required)
StateID
AddressID (required)
Copies[6]
MoveOutDate (required)
StreetName
AreaCode
Copies[7]
MovePrimaryOnly
StreetSuffixID
BillingMethod
CountryID
Phone
TaxExemptReason[City]
Building
CountyID
PhoneUnlisted
TaxExemptReason[Country]
CityID
DeliveryMethod
PostDirectional
TaxExemptReason[County]
Complex
DeliveryPlacementID
PreDirectional
TaxExemptReason[State]
Copies[1]
DeliveryScheduleID
RateCodeID
UnitDesignatorID
Copies[2]
Filler
ReasonCode (required)
UnitNumber
Copies[3]
HouseNumber
Remarks
ZipCode
Copies[4]
HouseNumberModifier
SourceCode (required)
ZipExtension
AccountHolderName
BankClientType
MaskedCreditCardNumber
SubAdjustCodeID[3]
AccountNumber
BankNumber
PaymentAmount (required)
SubAdjustCodeID[4]
AccountType
CheckNumber
PaymentType (required)
SubAdjustCodeID[5]
AdjustmentAmount[1]
CouponAmount
ReasonCode (required)
TipAmount
AdjustmentAmount[2]
CreditCardExpires
Remarks
TranDate (required)
AdjustmentAmount[3]
CreditCardNumber
SourceCode (required)
TransactionID
AdjustmentAmount[4]
CreditCardTypeID
SubAdjustCodeID[1]
VaultCustomerID
AdjustmentAmount[5]
Filler
SubAdjustCodeID[2]
VaultID
AuthorizationNumber
AccountID
PreviousDeliveryRequested
BillSourceID
ReasonCode (required)
CompanyID
Remarks
DonateAllDays
SourceCode
DonationCode
SubSourceID (required)
DonationDays
TranDate (required)
Filler
VacationPack
AAMColumnID
BillToCreditStatusID
Copies[3]
ReasonCode (required)
AAMZoneID
BillToEMailAddress
Copies[4]
ReassignReasonCode
AccountHolderName
BillToFirstName
Copies[5]
ReceiveBonusDays
AccountNumber
BillToHonorificID
Copies[6]
Remarks
AccountType
BillToHouseNumber
Copies[7]
RenewalDeliveryMethod
AdjustmentAmount[1]
BillToHouseNumberModifier
CreditCardExpires
RenewalOverrideCode
AdjustmentAmount[2]
BillToLastName
CreditCardNumber
RouteID
AdjustmentAmount[3]
BillToLevelDesignatorID
CreditCardTypeID
SendInvoice
AdjustmentAmount[4]
BillToLevelNumber
CreditStatusID
SendRenewal
AdjustmentAmount[5]
BillToMiddleInitial
DeliveryFeeCode
SendStatement
AuthorizationNumber
BillToOccupantTypeID
DeliveryInstructions
SourceCode (required)
AutoRenew
BillToPhone
DeliveryPlacementID
SubAdjustCodeID[1]
AutoRenewLength
BillToPhoneUnlisted
DeliveryScheduleID (required)
SubAdjustCodeID[2]
AutoRenewTerm
BillToPostDirectional
DirectionsToAddress
SubAdjustCodeID[3]
AutoRenewType
BillToPreDirectional
EbillEmailAddress
SubAdjustCodeID[4]
BankClientType
BillToStateID
EMailAddress
SubAdjustCodeID[5]
BankNumber
BillToStreetName
ExpireDate
SubSourceID
BillingGroupID
BillToStreetSuffixID
Filler
TaxExemptReason[City]
BillingMethod (required)
BillToUnitDesignatorID
MaskedCreditCardNumber
TaxExemptReason[Country]
BillToAddressID
BillToUnitNumber
MerchandiseCode
TaxExemptReason[County]
BillToAreaCode
BillToZipCode
OccupantTypeID
TaxExemptReason[State]
BillToBuilding
BillToZipExtension
PhoneUnlisted
TipAmount
BillToCityID
CampaignCode
PreviousDeliveryRequested
TranDate (required)
BillToComplex
Copies[1] (at least 1 Copies field required)
PurchaseNumber
VaultCustomerID
BillToCountryID
Copies[2]
RateCodeID
VaultID
BillToCountyID
AutoRenewPayPalEmailAddress
BillToGNAF-PID
BillToHIN
AccountID
Filler
RestartReasonCode
BillSourceID
PreviousDeliveryRequested
SourceCode (required)
CompanyID
ReasonCode (required)
StopDate (required)
DonateAllDays
RefundRequested
SubSourceID
DonationCode
Remarks
VacationPack
DonationDays
RestartDate
ActionDetail*
GroupHeaderDetail
PrintObject (the publication’s ISSN number)
ActionRecordID
GroupTrailerDetail*
ProductID
ActionType
iDabEdition
ProductionDate
BoxOutQuantity
iDabNumberOfCuts
ProductionGroup
BundleCompensationSize
iDabPageCount
PublicationName
BundleSize
iDabRouteID
RouteDetail*
BundleType
iDabTruckID
RouteID
CarrierID
IllegalIndicator
RouteLabel
CarrierName
InkjetDetail
Route Name
ChuteID
InkjetNeeded
RouteRecordID
CreateAD1BundleDetail*
KeyBundleSize
RunDate
CreateRestBundleDetail*
LineFeed
RunDateDay
CreateStdBundleDetail*
LiteralValue
SequenceNumber
DayNameAbbr
MaxBatch
SpecialInstructions
DefaultMaximumSize
MaxBatchLabel
StackerID
DefaultMinimumSize
MaximumSize
StackerDetail*
DefaultStandardSize
MaxStackBundleSize
StackerRecordID
DrawTotal
MessageDetail
StackerDetailLine
DrawTotalForDawClass
MinBatchLabel
StandardSize
DropLocation
MinimumSize
StdSizeLabel
DropLocation1
MullerDrawForDrawClass
SubNameAddrRecordID
DropLocation2
MullerCarrierID
SubscriberNameAddress
DropLocation3
MullerTruckID
SubscriberName
DropLocation4
MullerTruckSequence
SubscriberAddress
DropLocation5
NbrOfTurnsLabel
SubscriberID
DropOrder
NumberOfRouteBundles
TopSheetMarker
EditionDescription
NumberofStacksPerBundle
TransactionRecordID
EditionID
NumberOfStandardBundles
TransactionDetails
ExecuteStdBundleDetail*
NumberofTurns
TruckDrawTotal
ExecuteRestBundleDetail*
OrderStackerGroupID
TruckID
ExecuteAD1BundleDetail*
OtherMsgDetail*
TruckSequence
FeragControlChars
OtherName
TruckSequenceNumber
FeragDBFlag
PageCount
WeekNumber
Filler
PostCode
WinLincRouteLine
GlobalMessage
ZipCode
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.
The following data elements can be used with the “SubRefJrnl” usage.
RefundBatchID
BatchReasonCode
BatchAddress
BatchLabel
BatchRemarks
BatchTax
BatchDeliveryFee
BatchCreditCardIssuer
BatchSourceCode
BatchSourceType
BatchSrcReasonTotalAmount
BatchSrcReasonCode
BatchSrcReasonGrandTotalCount
BatchSrcReasonCount
BatchSrcReasonGrandTotalAmount
BatchSrcReasonAmount
BatchInterfaceTotalCount
BatchSrcReasonTotalCount
BatchInterfaceTotalAmount
DeliveryFee
DeliveryFeeCount
DeliveryFeeAmount
DeliveryFeeGrandTotalCount
DeliveryFeeGrandTotalAmount
Account
Source
AccountName
Reason
RefundDate
Vendor
RefundAmount
Tax
RefundPaid
BillToAddress
RefundReq
ProductID
PublicationName
ProductCount
ProductAmount
TotalProductCount
TotalProductAmount
PaymentType
PaymentSubType
PaymentTypeCount
PaymentTypeAmount
PaymentTypeTotalCount
PaymentTypeTotalAmount
PaymentTypeGrandTotalCount
PaymentTypeGrandTotalAmount
SourceType
ReasonCode
ReasonCount
ReasonAmount
SourceCode
SourceReasonTotalCount
SourceReasonTotalAmount
SourceReasonGrandTotalCount
SourceReasonGrandTotalAmount
TaxAuthority
TaxAuthorityCount
TaxAuthorityAmount
TaxAuthorityGrandTotalCount
TaxAuthorityGrandTotalAmount
UserName
UserCount
UserAmount
UserGrandCount
UserGrandAmount
The following data elements can be used with the “SubscrExprt” usage.
AddressLine[1-6]
AptHouseStreet
AreaCode
Area Code + Phone
CityID
ComboID
ComboSubscriptionID
ConvertLiteral
CountryID
DateRenewed (most recent start)
DeliveryPointID
DueDate (last Expire or End Grace)
EMailAddress
ExtractDate
Filler
FirstName
IndicatorFlag
IsOnline
LastName
LiteralValue
OccupantID
Phone
PublicationName
RecordCount
StartDate (original start date)
StateID
Status (“A” active or “I” inactive)
SubscriptionID*
ZipCode
ZipCode + ZipExtension
ZipExtension
* Field is required.
The following data elements can be used with the “SubTranImprt” usage.
AAM Column ID
Subscriber’s AAM category.
Account Holder Name
Name on the credit card or bank account.
Account Number
Bank draft subscriber’s bank account number.
Account Type
Bank draft subscriber’s account type (checking or savings).
Adjustment Amount
Subscriber cash payment adjustment; for example, 5.00 for a t-shirt.
Authorization Number
Payment authorization number, typically supplied for credit card payments.
Auto Pay Length
Payment length for auto renew subscriber.
Auto Pay Send Renewal
Yes/No flag to set the 'AutoRenewSubscription.SendStatement' flag
Auto Pay Term
Payment term for auto renew subscriber (for example “week”)
Auto Pay Type
Payment type for auto renew subscribers (credit card, bank draft, PayPal, or none)
Bank Client Type
Bank draft auto renew subscriber’s bank client type (business or personal)
Bank Number
Bank number for bank drafts.
Bill Address ID
Address ID of bill-to address.
Billing Method
Subscriber’s billing method.
Billing Period
Subscriber’s auto renew billing group.
Bill Occupant ID
Occupant ID of bill-to occupant.
City Exempt Reason Code
Tax exempt reason code for city tax.
City ID
Address city.
Country Exempt Reason Code
Tax exempt reason code for country tax.
Country ID
Address country.
County Exempt Reason Code
Tax exempt reason code for county tax.
County ID
Address county.
Credit Card Expires
Credit card expire date.
Credit Card Type
The credit card type (Visa, Mastercard, etc.)
Credit Card Vault ID
The vault ID, used only for off-site credit card storage.
Date Last Renewal Sent
Date last renewal notice or invoice was sent to subscriber.
Email Address
Occupant’s email address.
File Date
The date the file was created.
File Record Count
The total number of records in the file.
Filler
Filler fields will be blank.
First Name
Occupant’s first name.
Honorific ID
Occupant’s honorific (name suffix)
Last Name
Occupant’s last name.
Mailing Address ID
ID of the mailing address.
Mailing Occupant ID
ID of the mailing occupant.
Masked Credit Card Number
The credit card number with all but the last four digits masked (replaced with “*”). Used only for off-site credit card storage.
Middle Initial
Occupant’s middle initial.
Number of Renewals Sent
Number of renewal notices or invoices sent to the subscriber so far in the current subscription period.
Occupant Salutation ID
Occupant’s title, such as “Mr.”
Purchase Number
Purchase number entered with transaction.
Rate Code ID
Subscriber’s rate.
Receive Bonus Days
Bonus day flag for subscriber (yes/no).
Record Identifier**
Field that identifies the record type, for example “D” to indicate a detail record.
Remarks
Remarks entered with transaction.
Renewal Delivery Method
Method of delivering subscriber’s renewal (carrier, mail, ebill)
Send Invoice, Send Renewal
Send invoice and renewal flags, entered during starts or billing changes (yes/no).
State Exempt Reason Code
Tax exempt reason code for state tax.
State ID
Address state.
Subscription ID*
Subscriber’s subscription ID.
Tip Amount
Auto renew tip amount.
Tran Date
Transaction date for subscriber transaction.
ZIP Code, ZIP Extension
Address Zip code and Zip code + 4.
* Field is required
** Field is required if a record identifier is entered on the record type setup screen.
The following data elements can be used with the “SubscrTaxExpt” usage.
Address Lines [1-6]
County Tax Amount
Previous Rate Code
Amount
County Tax Authority
Previous Length
Amount+Tax
Date
Previous Pay Date
Auto Pay
Delivery Schedule ID
Product ID
Auto Pay Type
Effective Date
State Tax Amount
Bill To Address [1-6]
Name
State Tax Authority
Campaign Code
Number of Payments
Subscription ID
City Tax Amount
Paid To Date
SurchargeAmount
City Tax Authority
Payment Reason
Tax Amount
Country Tax Amount
Payment Term Length
Tran Type
Country Tax Authority
Phone
Transaction Reference
The following data elements can be used with the “TruckSeqExp” usage.
Bundle Size Method
Map Reference
Depot ID
Maximum Truck Weight
Draw For Draw Type
Product ID*
Draw For Drop
Relay Truck ID
Draw For Truck
Relay Truck Indicator
Draw Type
Route Address Line[1-6]
Drop Instructions
Route Delivery Time [Sun - Sat]
Drop Location
Route ID
Drop Order*
Route Name
Drop Where
Standard Duration For Truck
Filler
Truck Departure Time
Line Feed
Truck ID*
Literal Value
Truck Name
Map Number
Weight For Drop
* Field is required.
The following data elements can be used with the “SubLockbox” usage.
Account Holder Name
Name on the credit card or bank account.
Account Number
Subscriber’s bank account number.
Account Type
Bank draft subscriber’s account type (checking or savings).
Adjustment Amount
Subscriber cash payment adjustment; for example, 5.00 for a t-shirt. A popup window will open for entry of a payment adjust code.
Authorization Number
Credit card authorization number.
Bank Client Type
Type of bank account—this can be “personal” or “business”
Bank Number
The bank number of the subscriber’s bank.
Batch Total Elements
A number of elements exist for batch totals of adjustment, coupon, payment and tip totals. BatchAdjustmentTotal BatchCouponTotal BatchPayment+CashAdj+TipsTotal BatchPayment+CashAdjTotal BatchPayment+TipsTotal BatchPaymentTotal BatchTipTotal
Batch Date
The date the batch was created.
Batch Record Count
The total number of records in the batch.
Batch Remarks
Any user remarks about the batch.
Check Digit***
Check digits are used to verify that information in other fields is correct.
Check Number
Check number, if subscriber paid with check.
Coupon Amount
Amount of coupon sent in with subscriber payment.
Coupon Total
Total dollar value of all coupons in the record type.
Credit Card Expires
Expire date of credit card.
Credit Card Type
Type of credit card (Visa, Mastercard, etc.)
Credit Card Vault ID
Vault ID used only with off-site credit card storage.
File Totals elements
A number of elements exist for file totals (in cases where the file contains more than one batch). FileAdjustmentTotal FileCouponTotal FilePayment+CashAdj+TipsTotal FilePayment+CashAdjTotal FilePayment+TipsTotal FilePaymentTotal FileTipTotal
File Date
The date the file was created.
File Record Count
The total number of records in the file.
File Remarks
Any user remarks about the file.
Filler
Filler denotes blank fields or information that will not be used in Circulation; these fields will be ignored.
Last Name
Subscriber’s last name.
Lockbox ID
Destination of lockbox file.
Masked Credit Card Number
The credit card number with all but the last four digits masked (replaced with “*”). Used only for off-site credit card storage.
Payment Amount elements
There are several elements for payment amounts, for payments that include payment adjustments, tips, neither or both. PaymentAmount PaymentAmount+CashAdjusts PaymentAmount+CashAdjusts+Tips PaymentAmount+Tips
Payment Date
Date of the payment.
PaymentType
Indicates the payment type, whether the payment is a check, cash, credit card or bank draft payment.
Record Identifier**
Field that identifies the record type, for example “D” to indicate a detail record. This must be the first field in the record.
Remarks
Remarks about the payment or other item.
Scan Line***
Contents of the lockbox scan line from the renewal notice. The scan line contains four payment terms, the subscription ID and a check digit.
Subscription ID*
Subscriber’s account ID in Circulation.
Tip Amount
The amount of the tip, if any, sent with the payment.
TransactionID
Credit card or bank draft transaction ID.
* Field is required
** Field is required if a record identifier is entered on the record type setup screen.
*** Required if the Business Rule Should subscriber lock box files verify the scan line against the check digit? is set to “Yes.”
This file map usage (“DrawChgImprtTM”) is used when importing standing TM draw on the Draw | Draw Changes tab of the Product Detail window in the Targeted Marketing module. The data elements that can be used include:
AdjustOrReplace
EffectiveDate
Filler
Quantity
RecordIdentifier
ReversalDate
RouteID
The following data elements can be used with the “TokenUpdater” usage.
AccountOwnerType
Company
FirstName
ModifiedDateTime
UpdateType
AccountType
CreateDateTime
LastFour *
Phone
Zip
AdditionalInfo1
CreatedBy
LastName
RoutingNumber
AdditionalInfo2
Division
LineFeed
State
AdditionalInfo3
LiteralValue
StreetAddress
BankName
ExpireDate
MaskedCard
SubscriptionID
Card Type
Filler
MiddleName
Token *
City
FirstFour
ModifiedBy
UpdateCode *
* Field is required.
The following data elements can be used with the “SubPymtJrnl” usage.
LiteralValue
AccDeliveryFee
CountyTaxAuthID
AccountID
TipAmount1
StateTaxAmount
AccountName
TipCarrierID1
StateTaxAuthID
Type
TipOccupantName1
CountryTaxAmount
PaymentDate
TipAmount2
CountryTaxAuthID
PaymentAmount
TipCarrierID2
CityAdjTaxAmount
CheckNumber
TipOccupantName2
CityAdjTaxAuthID
PymtTranID
TipAmount3
CountyAdjTaxAmount
VaultID
TipCarrierID3
CountyAdjTaxAuthID
VaultCustomerID
TipOccupantName3
StateAdjTaxAmount
AuthorizationNum
TipAmount4
StateAdjTaxAuthID
AccountType
TipCarrierID4
CountryAdjTaxAmount
AccountNumber
TipOccupantName4
CountryAdjTaxAuthID
BankNumber
TipAmount5
CityGraceTaxAmount
PaypalEmail
TipCarrierID5
CityGraceTaxAuthID
CreditCardTypeID
TipOccupantName5
CountyGraceTaxAmount
CreditCardNumber
TipAmount6
CountyGraceTaxAuthID
CreditCardExpires
TipCarrierID6
StateGraceTaxAmount
PaymentSource
TipOccupantName6
StateGraceTaxAuthID
AdjustmentAmount
TipAmount7
CountryGraceTaxAmount
AdjustmentCodeID
TipCarrierID7
CountryGraceTaxAuthID
GracePaid
TipOccupantName7
Remarks
BadDebtPaid
ActivationFee
ActivationFeeTax
CouponAmount
PrintedBillFee
PrintedBillFeeTax
EffectiveDate
OtherFee
OtherFeeTax
ExpireDate
FeeCodeID
PaymentLength
ISOverride
PaymentTerm
CityTaxAmount
RateCode
CityTaxAuthID
Reason
CountyTaxAmount
LiteralValue
AdjustmentNonLiabGracePD
AdjustmentCode
AdjustmentTotalCount
AdjustmentCount
AdjustmentTotalNonCashAmt
AdjustmentNonCashAmt
AdjustmentTotalCashAmt
AdjustmentCashAmt
AdjustmentTotalNoUpdExp
AdjustmentNoUpdExp
AdjustmentTotalUpdExp
AdjustmentUpdExp
AdjustmentTotalLiabImpact
AdjustmentLiabImpact
AdjustmentTotalNonLiabGracePD
LiteralValue
BankNonCashAdj
BankName
BankTotalCount
BankCount
BankTotalAmount
BankAmount
BankTotalCouponAmt
BankCouponAmt
BankTotalTipAmt
BankTipAmt
BankTotalPymtTotal
BankPymtTotal
BankTotalGracePaid
BankGracePaid
BankTotalBadDebtPD
BankBadDebtPD
BankTotalCashAdj
BankCashAdj
BankTotalNonCashAdj
LiteralValue
CancelTranTypeNonCashAdj
CancelTranType
CancelTranTotalTypeCount
CancelTranTypeCount
CancelTranTotalTypeAmt
CancelTranTypeAmt
CancelTranTotalTypeCouponAmt
CancelTranTypeCouponAmt
CancelTranTotalTypeTipAmt
CancelTranTypeTipAmt
CancelTranTotalTypePymtTotal
CancelTranTypePymtTotal
CancelTranTotalTypeGracePaid
CancelTranTypeGracePaid
CancelTranTotalTypeBadDebtPD
CancelTranTypeBadDebtPD
CancelTranTotalTypeCashAdj
CancelTranTypeCashAdj
CancelTranTotalTypeNonCashAdj
LiteralValue
DeliveryFee
DeliveryFeeCount
DeliveryFeeAmount
DeliveryTotalFeeCount
DeliveryTotalFeeAmount
LiteralValue
FeeGrandTotalCount
FeeType
FeeGrandTotalAmt
FeeCode
FeeTaxCount
FeeDescription
FeeTaxAmt
FeeCount
FeeTaxTotalCount
FeeAmt
FeeTaxTotalAmt
FeeTotalCount
FeeTaxGrandTotalCount
FeeTotalAmt
FeeTaxGrandTotalAmt
LiteralValue
GroupEffectiveDate
GroupName
GroupTotalPymtAmt
GroupPayDate
GroupTotalCouponAmt
GroupSubscriberID
GroupTotalTipAmt
GroupSubscriberName
GroupGrandTotalPymtAmt
GroupPymtAmt
GroupGrandTotalCouponAmt
GroupCouponAmt
GroupGrandTotalTipAmt
GroupTipAmt
LiteralValue
OperatorNonCashAdj
OperatorName
OperatorTotalCount
OperatorCount
OperatorTotalAmt
OperatorAmt
OperatorTotalCouponAmt
OperatorCouponAmt
OperatorTotalTipAmt
OperatorTipAmt
OperatorTotalPymtAmt
OperatorPymtAmt
OperatorTotalGracePaid
OperatorGracePaid
OperatorTotalBadDebtPD
OperatorBadDebtPD
OperatorTotalCashAdj
OperatorCashAdj
OperatorTotalNonCashAdj
LiteralValue
ProStatTotalSourceNonCashAdj
ProcessStatusType
ProStatGrandTotalSourceCount
ProStatTotalSourceCount
ProStatGrandTotalSourceAmt
ProStatTotalSourceAmt
ProStatGrandTotalSourceCouponA
ProStatTotalSourceCouponAmt
ProStatGrandTotalSourceTipAmt
ProStatTotalSourceTipAmt
ProStatGrandTotalSourcePymtTot
ProStatTotalSourcePymtTotal
ProStatGrandTotalSourceGracePa
ProStatTotalSourceGracePaid
ProStatGrandTotalSourceBadDebt
ProStatTotalSourceBadDebtPD
ProStatGrandTotalSourceCashAdj
ProStatTotalSourceCashAdj
ProStatGrandTotalSourceNoCashA
LiteralValue
PublPymtTypeNonCashAdj
PublID
PublPymtTypeTotalCount
PublPymtType
PublPymtTypeTotalAmt
PublPymtTypeCount
PublPymtTypeTotalCouponAmt
PublPymtTypeAmt
PublPymtTypeTotalTipAmt
PublPymtTypeCouponAmt
PublPymtTypeTotalPymtTotal
PublPymtTypeTipAmt
PublPymtTypeTotalGracePaid
PublPymtTypePymtTotal
PublPymtTypeTotalBadDebtPD
PublPymtTypeGracePaid
PublPymtTypeTotalCashAdj
PublPymtTypeBadDebtPD
PublPymtTypeTotalNonCashAdj
PublPymtTypeCashAdj
LiteralValue
PaymentTypeNonCashAdj
PaymentType
PaymentTypeTotalCount
PaymentTypeCount
PaymentTypeTotalAmt
PaymentTypeAmt
PaymentTypeTotalCouponAmt
PaymentTypeCouponAmt
PaymentTypeTotalTipAmt
PaymentTypeTipAmt
PaymentTypeTotalPymtTotal
PaymentTypePymtTotal
PaymentTypeTotalGracePaid
PaymentTypeGracePaid
PaymentTypeTotalBadDebtPD
PaymentTypeBadDebtPD
PaymentTypeTotalCashAdj
PaymentTypeCashAdj
PaymentTypeTotalNonCashAdj
LiteralValue
SourceTotalTipAmt
Source
SourceTotalPymtTotal
SourceReason
SourceTotalGracePaid
SourceCount
SourceTotalBadDebtPD
SourceAmt
SourceTotalCashAdj
SourceCouponAmt
SourceTotalNonCashAdj
SourceTipAmt
SourceGrandTotalCount
SourcePymtTotal
SourceGrandTotalAmt
SourceGracePaid
SourceGrandTotalCouponAmt
SourceBadDebtPD
SourceGrandTotalTipAmt
SourceCashAdj
SourceGrandTotalPymtTotal
SourceNonCashAdj
SourceGrandTotalGracePaid
SourceTotalCount
SourceGrandTotalBadDebtPD
SourceTotalAmt
SourceGrandTotalCashAdj
SourceTotalCouponAmt
SourceGrandTotalNonCashAdj
LiteralValue
SubTotalTypeTotalPymtTotal
SubTotalType
SubTotalTypeTotalGracePaid
SubTotalTypeTotalCount
SubTotalTypeTotalBadDebtPD
SubTotalTypeTotalAmt
SubTotalTypeTotalCashAdj
SubTotalTypeTotalCouponAmt
SubTotalTypeTotalNonCashAdj
SubTotalTypeTotalTipAmt
LiteralValue
TaxTotalCount
TaxAuthority
TaxTotalAmount
TaxCount
TaxTotalGraceTax
TaxAmount
TaxFeeTax
TaxGraceTax
TaxTotalFeeTax
LiteralValue
TranDateTypeNonCashAdj
TranDate
TranDateTotalTypeCount
TranType
TranDateTotalTypeAmt
TranDateTypeCount
TranDateTotalTypeCouponAmt
TranDateTypeAmt
TranDateTotalTypeTipAmt
TranDateTypeCouponAmt
TranDateTotalTypePymtTotal
TranDateTypeTipAmt
TranDateTotalTypeGracePaid
TranDateTypePymtTotal
TranDateTotalTypeBadDebtPD
TranDateTypeGracePaid
TranDateTotalTypeCashAdj
TranDateTypeBadDebtPD
TranDateTotalTypeNonCashAdj
TranDateTypeCashAdj
The following data elements can be used with the “TM” 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.
Area Code + Phone
Full phone number including area code.
Area ID
Area in which subscriber’s delivery route is located.
Billing Method
Subscriber’s billing method.
Bill to fields
All standard address and occupant fields are available for the bill-to address and occupant.
BillToIsOnline
Digital Sales indicator (yes/no) for BillTo Address
Building
Address building.
Campaign Code
ID of the targeted marketing campaign.
Canvass Board Number
Number of the canvass board.
Carrier fields
All standard address and occupant fields are available for the carrier.
Carrier ID
Subscriber’s delivery carrier.
Census Block ID Census Tract ID
Address census tract and block.
City ID
Address city.
Communication Item ID
The ID of the communication item selected for the TM product.
Communication Method ID
The communication method selected for the TM product (“address”, “email”, or “phone”).
Communication Method Details
The occupant’s e-mail address, phone number or address.
Communication Preference
This detail element contains allows you to define the following sub-elements related to an occupant’s communication preferences: Address ID, Communication Item ID, Communication Method Details, Communication Method ID, Communication Method Type, Line Feed, Literal, Occupant ID, Opt In Date, Opt In Reason, Opt In Source, Opt In Time, Opt Out Date, Opt Out Reason, Opt Out Source, Opt Out Time, Subscription ID.
Complex
Address complex.
Country ID
Address country.
County ID
Address county.
Credit Status ID
Subscriber’s assigned credit status.
Date Last Renewal Sent
Date last renewal notice or invoice was sent to subscriber.
Delivery Date
The date the TM product was delivered.
Delivery Instructions
Occupant delivery instructions.
Delivery Placement ID
Delivery placement for subscriber.
Delivery Product ID
ID of the delivery product.
Delivery Schedule ID
ID of the delivery schedule.
Demographic Answer
Demographic answer
Directions To Address
Directions to the address
Distrib Zone ID
ID of the distribution point
District ID
ID of the district
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.
Extension
Phone number extension.
ExternalSubscriptionID
Occupant’s external subscription ID (if interfaced from an external system).
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.
IsOnline
Digital Sales indicator (yes/no)
Label Group ID
Label group ID.
Last Delivery Date
From the previous Product Address record (same product).
Last Name
Occupant’s last name.
Latitude
Latitude location of the address.
Literal Value
Literal fields are hard-coded to display whatever is entered in “format”. For example, if a field should always display “Z”, set it up as a literal value and enter “Z” in FORMAT.
Longitude
Longitude location of the address.
LOT
Line of travel (US Post Office)
LOTSequence
Line of travel sequence
Mail Accessible
Address mail accessible flag (yes/no).
MailTo [address elements]
All address elements are available for the mail-to address (MailToBuilding, MailToCountyID, etc.)
Middle Initial
Occupant’s middle initial.
Military Foreign
Address military/foreign information.
Name Address Line (1-6)
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
Occupant ID in Circulation.
Occupant Type ID
Occupant type.
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.
Process Date
Process date for transaction.
Product ID
ID of the product.
Purchase Number
Purchase number entered with transaction.
Rate Code ID
Subscriber’s rate.
Receive Bonus Days
Bonus day flag for subscriber (yes/no).
Record Count
Record number in file.
Region ID
Region in which subscriber’s delivery route is located.
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).
Route ID
Subscriber’s route, if subscription is route-delivered.
Route Type ID
Route type of subscriber’s route.
Send Invoice Send Renewal
Send invoice and renewal flags, entered during starts or billing changes (yes/no).
Solicitation Detail
Address ID, Occupant ID, Literal Value, Line Feed, Subscription ID, Solitation Code ID and Description, End Date, Start Date, and Last Review Date.
State ID
Address state ID .
Street Name
Address street name.
Street Suffix ID
Address street suffix.
Subscriber
Flag that determines whether the occupant is a current subscriber (yes/no).
Subscriber Copies
Number of copies received by the subscriber on the selection date.
Subscription Balance
Balance on the subscription
Subscription Balance With Tax
Balance on the subscription plus tax
Subscription ID
Subscriber’s subscription ID
Subscription Status
Status of the subscription
Subscription Type
Type of subscription: “Day Pass” or “Term”
TM Product ID
Product ID of the TM product.
Town Of 25 ID
Address Town of 25.
Unit Designator ID Unit Number
Unit type and number.
Walk Sequence
Walk sequence.
ZIP Bar Code, ZIP Code, ZIP Extension
Zip code, Zip code + 4, and Zip bar code.
ZIP Code + ZIP Extension
Full ZIP Code, including extension.
The following data elements can be used with the “TruckSeqImp” usage.
Bundle Size Method
Drop Instructions
Drop Location
Drop Order*
Drop Where
Filler
Line Feed
Literal Value
Map Number
Map Reference
Maximum Weight
Product ID*
Record Identifier
Relay Truck ID
Relay Truck Indicator
Route Delivery Time [Sun - Sat]
Route ID
Standard Duration For Truck
Truck Departure Time
Truck ID*
* Field is required.