Circulation User Manual
NavigaSupportSetup Manual
  • Circulation User Manual
  • ❶ Introduction
    • Circulation Overview
      • The Basic Concept
      • Summary
    • Application Launcher
    • Navigating the Graphical Interfaces
    • Viewing and Printing Reports
      • The Report Viewer
      • Filtering and Other Options
    • Personalization
    • Mapping
  • ❷ Customer Service
    • Find
    • Documents
    • Alerts
    • Contacts
    • Mapping
    • Viewing Customer Information
      • Subscription
      • Address
      • Occupant
      • Contact
      • Demographics
      • Financial
      • Rate Changes
      • Rates
      • Miscellaneous
      • Transactions
      • Rewards
      • Merchandise
      • Subscriber Info
    • Address and Occupant
    • Transactions
      • Day Pass
      • New Start
      • Stop
      • Restart
      • Complaint
      • Billing Change
      • Delivery Schedule
      • Route/Mail Reassignment
      • Move
      • Temporary Address
      • End Temporary Address
      • Payment
      • Cancel Payment
      • Transfer
      • Refund
      • Refund Write-off
      • Grace WriteOff
      • Notes
      • Delivery Placement
      • Contact
      • Combo Change
      • End Combo
      • Modifying Transactions
      • A Note About Rerating Subscribers
    • Messages
    • Tasks
  • ❸ Route Service
    • Finding Routes
    • Mapping
    • Viewing Route Information
    • Transactions
    • Draw Management
    • Account Information
    • Messages
    • Route Service Reports
    • Setup
      • Route Sequence
      • Route Setup Utility
      • Router Utility
      • Rerouting
      • Substitute Draw
      • Truck Time
    • Account Services
    • Distribution Maintenance
    • Utilities
      • Suspend Route
      • Insert Base and Draw Exports
      • Burt Export
      • GMA/SAM Export
      • Draw Forecast Export
      • Drop Time Import
      • Truck Dock Import
      • Single Copy Draw Import
      • Router Import
      • Max Return
      • Drop Time Entry
      • Truck Validation
      • Truck Check
      • Deadline Override
      • Reseq Drop Order
      • Reseq Depart Order
      • Draw Change Lockout
  • ❹ Publishing
    • Introduction to Publishing
    • Edition Override
    • Multi-Pack Override
    • Edition List Setup
    • Import Bundle Sizes
    • Carrier Mail Export
    • Set Sub-Product Draw
    • Start Publishing Run
    • Press Room Report
    • Transaction Processing
    • Undo Final Tran Proc
    • Distribution Menu
      • Daily Draw Worksheet
      • Edition Drawsheet
      • Enter Bundle Info
      • Stacker Interface
      • Bundle Tops
      • Truck Manifest
      • Route Labels
      • Status/Collect Cards
      • Prev Delivery Labels
      • Adv Reconciliation
      • Single Copy Receipts
    • Mail Menu
      • Print Labels
      • Daily PO Report
      • Finnish Post Export
    • DM Report
    • End Publ Run
    • Press Room Entry
    • Press Room Import
    • Press Room Audit
    • Resupply Documents
    • Publishing Run Status
    • Advance Processing
  • ❺ Dispatching
    • What Is Dispatching?
    • Review Dispatch Items
    • Dispatching Items
    • Compliance
  • ❻ Reporting
    • The Reporting Module
    • AAM Menu
      • Daily
      • Daily Price Level
      • Paragraph 3 by Town
      • Paragraph 3 by Zip
      • Paragraph 3 by Zip/Town
      • Paid and Qualified History
      • History
      • History Price Level
      • Reduced Rates
      • Nth Factor
      • Other Paid Draw
      • Paid Draw by Rate
      • 4% Allowance
      • Subscriber Export
      • Billing Export
      • AAM Draw Export
      • Period Comparison
      • Restate AAM History
      • Digital Access Draw
      • Digital Analysis Report
      • Digital Subscription Audit Report
    • Account Menu
      • Account List
      • Status/Collect Cards
      • Charge/Credit
      • Bond Activity
      • Billed/Unbilled Draw
      • Past Due Letter
      • 1099 Forms
      • 1099 Audit
      • Vacation Pack Labels
      • Drop Credit Audit
    • Audit Menu
      • Transaction Audit Reports
      • Address Audit Reports
      • Occupant Audit Reports
      • Other Audit Reports
      • Setup Audit Reports
    • Churn Reports
    • Management Menu
      • Unearned Revenue
      • GL Interface Journal
      • Audit GL Journal
      • Summary Age Analysis
      • Detail Age Analysis
      • Daily Draw Impact
      • Start/Stop Analysis
      • Retention Analysis
      • Stop Analysis
      • Subscriber Payment Analysis
      • Formal Complaint
      • Complaint Rate
      • Rate by 100
      • District Summary
      • Dispatch Report
      • Address Duplicates
      • Taxable Revenue
      • Draw and Revenue
      • Revenue Comparison Report
      • CC Success Report
    • Market Penetration Reports
    • Postal Menu
      • Financial PO
      • Walk Sequence Cards
    • Route Menu
      • Route Delivery List
      • Route Walk Sequence
      • Complaint
      • Home Deliv Compare
      • Draw Variance
      • Delivery Credit/Draw
      • Draw Analysis
      • Net Draw
      • Pending Messages Report
      • Future Starts Report
      • Router List
    • Single Copy Menu
      • Return Draw Analysis
      • Pilferage
      • Weekly Manifest
      • Single Copy by Day
    • Subscriber Menu
      • Active Mail
      • Active Online
      • Available Refunds
      • Refunds Written Off
      • Refund Cards
      • Grace Due
      • Grace Balance
      • Receivables Aging
      • Writeoff Analysis
      • Grace Written Off
      • End Grace
      • Fee Analysis
      • Fee WriteOff
      • Office Pay Expires
      • Stopped Subscribers
      • Throwoff Subscribers
      • Paid/Unpaid Starts
      • Discount Prediction
      • Subscriber Info Export
      • Balance Forward Bill
      • Undo Balance Forward
      • Subscriber Activity Export
      • Subscriber Activity Import
    • Taxing Menu
      • Tax Exclusion
      • Tax Liability
      • Trans Cost Remit Tax
      • BAS Reconciliation
      • Tax Export
  • ❼ Targeted Marketing
    • Introduction to Targeted Marketing
    • Setup
      • 1. Create a New TM Product
      • 2. Define Selection Criteria for the TM Product
      • 3. Specify the Output Formats for the TM Product
      • Creating New Formats
      • Other Setup Options
    • Processing
    • Undo Processing
    • Selection Summary
    • Copy
    • Campaigns
      • Campaign Setup
      • Canvass Board
      • iServices Campaign Module
      • Business Rules for the iServices Campaign Module
      • Using a Campaign in iServices Subscriber
  • ❽ Tasks
    • Introduction
    • Setup Menu
      • Task Group
      • User Notification
      • Activity Code
      • Task Type
      • Task
      • Alert
    • Tasks Menu
      • My Tasks
      • All Tasks
    • Generating Tasks
    • Tasks in Targeted Marketing and Reports
    • Reports Menu
      • User Statistics Report
      • User Audit Report
    • Utilities Menu
      • Overdue Tasks
  • ❾ Dashboard
    • Introduction
    • Activity by Time
    • Department Activity by Transaction Type
    • User Activity
    • Activity by Source
    • Activity by Reason
    • Activity by Delivery Schedule
    • Complaint Types
    • Task Types
    • Donations
  • ❿ Accounting
    • Introduction
      • Accounting and the General Ledger
      • About Subscriber Rating
      • About Account Rates
      • Subscriber and Account Rating Examples
      • About Payment Authorization
      • About Credit Card Surcharges
      • When to Use Accounting Options
    • Account Billing Menu
      • Selection
      • Processing
      • Billing Journal
      • Invoices
      • Deposit Slips
      • Trans Exclusion
      • Invoice Export
      • Close
      • Invoices on Bundle
      • Missed Invoices
      • Statement Export
      • Undo Processing
      • Billing Run Status
      • Undo Close
      • Interest Calculation
      • Create Bond Charges
      • Create Drop Credits
      • Undo Drop Credits
      • Trial Billing
    • Accruals
    • Account Payments Menu
      • Payment Entry
      • Lockbox Processing
      • Bank Draft Payments
      • Payments to GL
      • Cancel Payment
      • Cancel Credit Payment
      • Payment Journal
      • Cash Batch Audit Journal
      • Apply Unapplied
      • Apply All Unapplied
      • Applied Journal
      • BACS Pre-Notify
      • Proof of Sale Adj
    • Misc. Charge/Credit Menu
      • Miscellaneous Charge
      • Balance Writeoff
      • Cancel Miscellaneous Charge
      • Charges Journal
      • Charge for Complaints
      • Misc. Charges Export
      • Misc. Chg/Cr Import
    • AP/Direct Deposit Menu
      • Interface to AP
      • Midmonth Pmt Export
      • Direct Deposits
      • Credit Journal
      • Vendor Import
      • Vendor Export
      • Vendor Change Report
    • Subscriber Payments Menu
      • Auto Payments
      • Lockbox Processing
      • Batch Payments
        • Business Rules for Subscriber Payments
        • Entering Subscriber Payments
        • How Circulation Determines Term and Length
        • Payments and Discounted Rates
        • Paying for Premium Days
        • Entering Group Payments
        • Generating Rewards
      • Payment Journal
      • Payment Processing
      • Batch Audit Journal
      • Resolve Payments
      • Resolve Journal
      • Pymt Authorization
      • Vindicia Report
      • ACH Status Update
    • Vindicia Payments
    • Subscriber Menu
      • Renewal Notices
      • Undo Renewal Notices
      • Auto Notice Export
      • Send eBills
      • Batch Refunds
      • Refund Journal
      • Refund Writeoff
      • Avail Refund Export
      • Grace Owed Export
      • Grace Writeoff
      • CC Invoice Export
      • Credit Card Expires
      • Trans Cost Export
    • Fiscal Close Menu
      • Close Period (Account)
      • Close Period (Subscriber)
      • Fiscal Close - GL Submenu
        • Export GL
        • Audit GL Transactions
  • ⓫ Utilities
    • Introduction
    • Account Menu
      • Rate Check
      • Draw Export
      • Compare/Update AAM %
      • Update # Households
      • Update Census Tract %
      • Balances
      • Change Recur Charge
      • Holiday Draw
      • Holiday Edition
      • Change Bill Source
      • Change Account ID
      • Rate Change
    • Audience Menu
      • Audience Sync
      • Reset Audience Sync
    • Subscription/Address Menu
      • Batch Addr Hygiene
      • Router Addr Hygiene
      • Change Credit Status
      • Extend Grace Days
      • Dupl Address Edit
      • Dupl Address Report
      • Subscription Purge
      • Address Demographics
      • Product Change Setup
      • Product Change
      • ACS Update
      • Bonus Day Setup
      • Copy Bonus Day Setup
      • Bonus Day Delivery
      • Bonus Day Adjustment
      • Delivery Schedule Change
      • Extend Expire Dates
      • Stop Utility
      • Batch Transactions
      • Sub Length Pricing
      • Auto Accept Batches
    • System Menu
      • Batch Setup
      • Check Disk Space
      • Check Date & Time
      • View/Print
      • Who’s Logged In
      • Process Log Report
      • Purge Process Log
      • Find Fields
      • Purge Session Data
      • Performance Analysis Tools
    • History Purge
    • Setup Menu
      • Bulk Route Changes
      • Bulk Router Updates
      • Truck Validation
      • Route Delivery Sequence
      • Route Delivery Sequence Update
      • Trip Delivery Sequence
      • Trip Delivery Sequence Import
      • Postal Walk Sequence
      • Route Type Change
      • Route ID Change
      • Copy Publ Info
      • GMA/SAM Account Type
      • One Day Rate Change
    • Tools Menu
      • Check Single Copy and Check Home Delivery
      • Move Truck Drop
      • Change Area Code
      • Rerate Subscribers
      • Unlock/Clear Batches
      • Undo Draw Adj Batch
      • Re-Export Interface to AP
      • Re-Export Direct Deposits
      • Re-Export Subscriber Payment Batch
      • Re-Export Direct Debit
      • Find CC Transactions
      • Comboizer
    • Export Menu
      • Subscriber Activity
      • Collectech
      • Subscriber Balances
      • mass2one
      • Rewards
      • Update Cleanse Flag
      • Subscriber Info
      • Draw Impact Export
      • Addresses
      • Subscribe Extract Export
    • Import Menu
      • Billing Change
      • Do Not Call List
      • Subscriber Activity
      • Reward Response
      • Address Information
      • Update Cleanse Flag
      • Communication Hist
      • Auth Import
      • Note Transaction Import
      • Single Copy Demographic Answers
      • Token Account Updater
    • Close Day for AAM
    • Reset End Publ Run
    • Remove End Publ Lock
    • Custom Menu
    • Handheld Export
    • Newsvendor Invoice
    • Weekly Sales Order (WSO) Report
    • Vaulting Service
  • ⓬ Options
    • Introduction
    • Bellatrix Interface
  • ⓭ Appendix A—Glossary
    • A-B
    • C
    • D
    • E-L
    • M-O
    • P-R
    • S
    • T-Z
  • ⓮ Appendix B—File Formats
    • File Formats: An Introduction
    • “Secure” Directory for Private Information
    • 1099 File Format
    • AAM 4% Report Export
    • AAM Billing Export
    • AAM Draw Export
    • AAM Paragraph 3 by ZIP Export
    • AAM Subscriber Export
    • Account Credit Card Payment Formats
    • Account Invoice Scan Line Format
    • ACS Update Format
    • Admail Export File
    • Advance Reconciliation Export Format
    • Audience Sync
    • Auto Notice Export Format
    • Auto Renew Statement Export
    • Available Refund Export
    • Bank Draft Formats
    • Bellatrix Import and Export
    • Bill Format Export Elements (Used for Invoice Export)
    • Bonus Day Adjustment Export Format
    • Bundle Sizes Import Format
    • Burt Address Manager
    • Burt Export Formats
    • Burt Export Formats for TM
    • Cancel Credit Card Payment Format
    • Carrier Collect Invoice Format
    • Chart of Accounts Import
    • Collectech Export Format
    • Desktop Mailer Export
    • District Manager Export
    • Draw Export Format
    • Draw Impact Export
    • Draw Import Format
    • eBill Export Format
    • E-mail Templates
      • General Variables
      • eBill Templates
      • New Password template
      • Digital Vacation Pack template
      • Digital Complaint Template
      • Day Pass Template
      • Start Template
      • Temp Stop - Restart Template
      • Payment Template
      • Tip Donation Template
    • Export/Import Account Rates
    • Export/Import Subscription Rates
    • File Mapping Data Elements
      • 1099 Export
      • 1099 Forms Printing Export
      • Account Lockbox
      • Account Statement Export
      • Address Export and Address Import
      • Alternate Format for Draw Adjustments
      • Alternate Single Copy Draw Change Import
      • Audit GL Transactions
      • Authentication Import
      • Balance Forward Billing Export
      • BAS Reconciliation (Detail)
      • BAS Reconciliation (Summary)
      • Bundle Top Export
      • Campaign Import
      • Carrier Mail Export
      • Cleanse Flag Export
      • Cleanse Flag Import
      • Communication History Import
      • Complaint Export (Detail)
      • Complaint Export (Summary)
      • Credit Card Expires
      • Dispatch Export
      • Do Not Call Import
      • Do Not Call List
      • Draw Adjustments and Returns Import
      • Draw Change Import
      • Draw Forecast Export
      • Drop Credit Audit
      • Drop Time Import
      • GL Audit (Audit GL Journal)
      • GL Export
      • GL Interface Journal
      • Merchandise Report
      • Misc Chg/Credit Import
      • Note Import
      • Office Pay Audit Report
      • Past Due Letter
      • Payment Authorization
      • Postal Billing Export
      • Postal Subscriber Audit
      • Postal Subscriber Full Audit
      • Proof of Sale
      • Renewal Notice
      • Returns Journal
      • Route Data (Route Delivery List Export)
      • Route Labels
      • Router Import
      • Route Smart
      • Single Copy By Day Report
      • Sold Import
      • Stacker Interface
      • Status/Collection Cards
      • Subscriber Activity Export
      • Subscriber Activity Import
      • Subscriber Billing
      • Subscriber Export
      • Subscriber Lockbox
      • Subscriber Payment Journal
      • Subscriber Refund Journal
      • Subscriber Tax Export
      • Subscriber Tran Import
      • Targeted Marketing
      • TM Draw Change Import
      • Token Account Updater
      • Truck Sequence Export
      • Truck Sequence Import
    • General Ledger Interface Format
    • Grace Owed Export
    • Import Vendor Format
    • Insert Base and Draw Export Formats
    • Interface to AP Formats
    • Mail Mart Labels in Targeted Marketing
    • mass2one Export Format
    • Refund Export Formats
    • Refund Writeoff Export
    • Renewal Notice Export Formats
    • Rewards Export Format
    • Rewards Import Format
    • Route Delivery List Export
    • Route Delivery Sequence Update
    • Route ID Change Format
    • Route Type Change Export File
    • Sam Export Formats
    • Single Copy Demographic Import
    • Stacker Interface
    • Subscriber Activity Import Format
    • Subscriber Activity Output Format
    • Subscriber Balances Export Format
    • Subscriber Credit Card Expires Format
    • Subscriber Lockbox File Format (Standard)
    • Subscriber Payment Cancel Export Format
    • Subscriber Payment Formats (Credit Card)
    • Teledirect Formats
    • TM Output File
    • Transportation Cost Export
    • Trip Sequence Import File
    • Truck Manifest Export
    • Vac Pack Label Export
    • Vendor Change Export
    • Vendor Export
Powered by GitBook
LogoLogo

COPYRIGHT © 2024 NAVIGA

On this page
Export as PDF
  1. ⓮ Appendix B—File Formats
  2. File Mapping Data Elements

Targeted Marketing

The following data elements can be used with the “TM” usage.

Data Element
Description

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.

PreviousSubscriber Tran ImportNextTM Draw Change Import

Last updated 2 years ago