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
  • iDAB
  • Header record
  • Detail record
  • KANSA
  • QUIP
  • HALL
  • WinLincs
  • Header Record
  • Truck Data
  • Route Data
  • Muller Martini
  • Header Record
  • Detail Record
  • Ferag
  • Title Record
  • Truck List Record
  • Truck Detail Record
  • Route Start Record
  • Bundle Characteristics Record
  • Route Detail Record
  • End of Truck Record
  • End of Title Record
Export as PDF
  1. ⓮ Appendix B—File Formats

Stacker Interface

Note: All of the stacker interfaces require a separate license fee to use. Contact the Naviga Support Center for more information.

File type: Fixed Length. The format used depends upon the brand of stacker machine, and is controlled by Business Rules. Note that not all versions of each stacker brand is supported—please verify the file format with the format required by your stacker version. Location: /dti/exchange/cm

iDAB

Header record

Field
Description

L

The route If there are inserts, the final mix name is appended to the L record with a period (.) separator.

E

The edition; will be blank if the publication is not started by edition. If started by edition, one file will be created for each edition selected. The edition ID will be appended to the filename.

Detail record

Field
Description

I

The date (8 characters)

F

Paper type; always “1” for broadsheet

P

Number of pages from Enter Bundle Info

M

Minimum size from Enter Bundle Info

A

Maximum bundle size from Enter Bundle Info

S

Standard bundle size from Enter Bundle Info

Note: If multiple bundle sizes are entered, the M, A, and S records will be taken from the first bundle size record found.

B

Batches in a bundle (CUTS from Enter Bundle Info)

K

Key sequence. Always “4”.

For each truck:

T

Truck ID (8 characters)

X

Key bundle size (3 digits)

N

Number of standard bundles (4 digits)

KANSA

One record is read for each bundle on each route.

Data
L
Type
Description

Truck ID

8

character

The truck for this route

Route ID

8

character

The route

Bundle Size

3

integer

The size for this bundle

Bundle Size

3

integer

The bundle size divided by 2 and rounded up

QUIP

One record is read for each bundle on each route.

Data
L
Type
Description

Truck ID

8

character

The truck for this route

Bundle Size

3

integer

The size for this bundle

Record Counter

4

integer

This starts at 1 and increases by 1 for every record created

Edition

4

character

The edition for this route

Route ID

8

character

The route

HALL

One record is created for each truck, one for each route’s standard bundles, and one for each routes’s key bundle (two if split key).

Data
L
Type
Description

TI

2

“TI” marks the beginning of the truck record

Truck ID

7

character

The truck

?

1

“?” marks the end of the truck record

RN

2

“RN” marks the beginning of the route record

Route ID

8

character

The route

?BQ

3

“?BQ” marks the start of bundle information

# of Bundles

3

integer

The number of bundles contained in this record

?SS

3

“?SS” marks the beginning of bundle size information

Bundle Size

3

integer

The size of the bundles in this record

?SC01

5

“?SC01” marks the end of the route record.

WinLincs

Note: To use the WinLincs format, your trucks must be set up in one of the ways shown below.

If you need WinLincs data by ad zone, you must have your trucks set up as follows:

  • Parent Truck A (a physical truck that contains only relay trucks but no routes). The relay trucks represent ad zones of this physical truck.

    • Truck A1 (contains relay trucks and routes for ad zone “123”, for example)

    • Truck A2 (contains relay trucks and routes for ad zone “246”, for example)

    • etc.

  • Parent Truck B (same as above)

    • Truck B1 (contains relay trucks and routes for ad zone “369”, for example)

    • Truck B2 (contains relay trucks and routes for ad zone “456”, for example)

    • etc.

If you do not need WinLincs data by ad zone, you must have one parent truck, and all trucks must be defined as relay trucks on the parent truck. For example:

  • Parent Truck A

    • Truck A1

    • Truck A2

    • Truck A3

    • etc.

The WinLincs interface creates the following records:

  • A header record

  • Truck data, which contains a record for each relay truck

  • Route data

Header Record

This record is fixed length, and each value is separated by a space. A carriage feed and line feed terminates each line.

Data
L
Type
Description

VER

3

character

“VER”

DATE

6

date

Publishing date

NUMBER

6

character

“NUMBER”

ZONE_DESC

10

character

“ZONE_DESC”

PACKET

6

character

“PACKET”

COUNT

5

character

“COUNT”

DONE

4

character

“DONE”

PRE-HALT

8

character

“PRE-HALT”

POST-HALT

9

character

“POST-HALT”

STATUS

6

character

“STATUS”

STACK_SIZE

10

character

“STACK_SIZE”

COMP

4

character

“SIZE”

BATCH

5

character

“BATCH”

PRINT_DATA

10

character

“PRINT_DATA”

DELIVERY

8

character

“DELIVERY”

Truck Data

This record is fixed length, and each value is separated by a space. A carriage feed and line feed terminates each line.

Data
L
Type
Description

Zone Sequence Number

9

integer

Sequence number, starting with 000000001

Zone Description

19

character

Truck ID

Packet ID

10

character

Truck ID

Required Count

9

integer

Draw count for the truck (including relay draw)

Done Count

9

integer

Value=”0”

Pre-Halt Flag

1

Y/N

Value=”N”

Post-Halt Flag

1

Y/N

Value=”N”

Status

1

character

Value=”N”

Stack Size

4

integer

Bundle size for the truck

Bundle Compensation Size

4

integer

Bundle size for the truck, divided by 2 (rounded up, if necessary)

Batch Quantity

4

integer

Not used

Print Data

30

character

Not used

Delivery Point

1

character

Value=”A”

Route Data

This record is variable length, and each value is separated by a pipe symbol, “|”. A carriage feed and line feed terminates each line. A route record is created for every route on the truck, even if the truck is defined as “bulk” loaded. Illegal bundles are exported at the beginning of the truck. They can be exported individually or combined into one line, based on Business Rules.

Data
L
Type
Description

Route

9

character

Value=”**ROUTE**”

Route ID

8

character

Route ID

Draw Count

6

integer

Draw count for the route

Truck Information

14

character

Value= “Truck=”TruckID. For example, “Truck=Dock”.

Zip Information

9

character

Value= “Zip=”Zip Code. For example, “Zip=73533”.

Drop Information

13

character

Value= “Drop=”Drop Order. For example, “Drop=1400”.

Muller Martini

Note: When no Stacker File Name is specified in Enter Bundle Info, the file name will be: “MULLER” + <2-digit day of the month> + <3-character day of the week> + <product ID> + <Edition>. If the Edition is less than four characters, zeroes will be added to the front.

Header Record

Field
Format
Value

Date

DDMMYY

Publishing date

Page Count

99

Page count

Format change indicator

X(1)

Value=”F”; must be upper case

Format Number

99

Value=”00”

Filler

x(77)

Space filled

Detail Record

Field
Format
Value

Truck Number

X(3)

Last two positions of the truck ID, prefaced with a 0 (zero)

Sequence Number

999

Always starts at 000 and increases without regard to changes in trucks

Account Number

X(6)

Account ID assigned to the route

Name

X(30)

First and last name assigned to the account

Drop Information

X(30)

Drop location assigned to the drop

Bundle Type

N

Value=”0” for key label only; 1-9 if all bundles require a label

Draw Quantity

NNNNN

Draw total (includes all draw types)

Standards

NNN

Value=”000”

Odd Count

NNN

Value=”000”

Number of Bill Posters

N

Value=”0”

Box-out Draw Quantity

X(3)

Draw quantity for the Business Rules-defined single copy type. Last value uses an over-punch. For example, zero would be presented as “00{“, and two would be presented as “00B”.

Ferag

This file is fixed length. The file format is shown below.

Note: When no Stacker File Name is specified in Enter Bundle Info, the file name will be: “FERAG” + <2-digit day of the month> + <product ID> + <3-character day of the week> + <Edition>.

Title Record

Field
Format
Value
New Line

Start Title Record

X(5)

Value=”%2440”

No

Title Name Indicator

X(3)

Value=”+40”

No

Title Name

X(8)

Value=<weekday name><first two characters of ProductID> or Value=<weekday name><first two characters of ProductID><first three characters of EditionID> Note: EditionID is included when the product is processed by Edition in the Publishing Run.

No

Publication Date Indicator

X(3)

Value=”+95”

No

Publication Date

DDMMYY

Publishing Date, formatted DDMMYY

No

Production Date Indicator

X(3)

Value=”+98”

No

Production Date

DDMMYY

Production Date, formatted DDMMYY

No

Additional Title Indicator

X(3)

Value=”+08”

No

Additional Title Info

X(50)

<Publication Name> + “ “ + <Edition Name>

No

End Title Record

X(1)

Value=”!”

No

Truck List Record

Field
Format
Value
New Line

Start Truck List Record

X(5)

Value=”%2401”

No

Truck ID Indicator

X(3)

Value=”+11”

No

Truck Name

X(13)

Value=”RT” + Truck ID + <A> or <B>. Value “A” for processing bundles equal or under minimum. Value “B” for processing bundles above the minimum.

No

End of Truck List Record

X(1)

Value=”!”

No

Truck Detail Record

Field
Format
Value
New Line

Start Truck Detail Record

X(5)

Value=”%2402”

No

Truck ID Indicator

X(3)

Value=”+11”

No

Truck Name

X(13)

Value=”RT” + Truck ID + <A> or <B>. Value “A” for processing bundles equal or under the minimum. Value “B” for processing bundles above the minimum.

No

Limit Bundle Indicator

X(3)

Value=”+30”

No

Limit Bundle Size

9999

Minimum bundle size defined within distribution info (left fill with zeros)

No

Max Stack Bundle Indicator

X(3)

Value=”+31”

No

Max Stack Bundle Size

9999

Maximum stack bundle size defined within distribution info (left fill with zeros)

No

Standard Bundle Indicator

X(3)

Value=”+32”

No

Standard Bundle Size

9999

Standard bundle size defined within distribution info (left fill with zeros)

No

N Bundle Indicator

X(3)

Value=”+33”

No

N Bundle Parameter

9999

The number of stacks per bundle defined within distribution info (left fill with zeros)

No

Max Bundle Indicator

X(3)

Value=”+34”

No

Max Bundle Size

9999

Maximum bundle size defined within distribution info (left fill with zeros)

No

SZ Bundle Indicator

X(3)

Value=”+35”

No

SZ Bundle Size

9999

Value=”0000”

No

DB Flag Indicator

X(3)

Value=”+59”

No

DB Flag

9

Value=”3”

No

EA Flag Indicator

X(3)

Value=”+69”

No

EA Flag

9

Value=”0”

No

Edition Name Indicator

X(3)

Value=”+20”

No

Edition Name

X(30)

Edition Name

No

End of Truck Detail Record

X(1)

Value=”!”

No

Route Start Record

Field
Format
Value
New Line

Route Start Record

X(5)

Value=”%2403”

No

Route Start Indicator

X(3)

Value=”+12”

No

Account ID

X(10)

Delivery carrier’s account ID

No

Copies Indicator

X(3)

Value=”+13”

No

Number of Copies

99999

Total Draw for this route

No

End of Route Start Record

X(1)

Value=”!”

No

Bundle Characteristics Record

This record is created only for the first route on the truck.

Field
Format
Value
New Line

Start Bundle Characteristics Record

X(5)

Value=”%2404”

No

Bundle Characteristics Record Indicator

X(3)

Value=”+52”

No

Create Indicator

X(23)

Value=”0313^CREATE;<ProductID>;576”

Yes

????

X(5)

Value=”ALPHA”

Yes

Bundle Characteristics (1)

X(38)

Value=”35;3;3;3;” KEY=08 STD=14 TOTAL=06””

Yes

Bundle Characteristics (2)

X(14)

Value=”6;68;2;2;”=24””

Yes

Bundle Characteristics (3)

X(17)

Value=”6;3;3;3;”A/C No-””

Yes

Bundle Characteristics (4)

X(15)

Value=”44;96;3;3;”=07””

Yes

Bundle Characteristics (5)

X(14)

Value=”8;68;2;2;”=25””

Yes

AF1 Characteristics

X(14)

Value=”AF1;8;6;30;3;3”

Yes

AF2 Characteristics

X(15)

Value=”AF2;13;2;68;3;3”

Yes

AF3 Characteristics

X(15)

Value=”AF3;30;23;3;3;3”

Yes

AF4 Characteristics

X(15)

Value=”AF4;30;20;3;3;3”

Yes

AF5 Characteristics

X(15)

Value=”AF5;30;15;3;3;3”

Yes

AF6 Characteristics

X(14)

Value=”AF6;8;6;95;3;3”

Yes

AF7 Characteristics

X(15)

Value=”AF7;30;26;3;3;3”

Yes

AF8 Characteristics

X(15.3)

Value=”AF8;30;31;45;3;3”

Yes

AF9 Characteristics

X(13)

Value=”AF9;8;2;3;3;3”

Yes

AF10 Characteristics

X(16)

Value=”AF10;30;2;20;3;3”

Yes

AF11 Characteristics

X(15)

Value=”AF11;8;2;10;3;3”

Yes

Stop Indicator

X(4)

Value=”STOP”

Yes

End Indicator

X(3)

Value=”END”

Yes

End of Bundle Characteristics Record

X(1)

Value=”!”

No

Route Detail Record

Field
Format
Value
New Line

Route Detail Record

X(5)

Value=”%2404”

No

Route Detail Indicator

X(3)

Value=”+58”

No

???

9999

Value=”0314”

No

Execute Command

X(15)

Value=”^EXECUTE;<ProductID>”

Yes

AF1 Data

X(15)

Value=”^AF1;”<Account ID>”” Note: Account ID is the delivery carrier.

Yes

AF2 Data

X(20)

Value=”^AF2;”<Truck ID><\><Sequence Number>”” (Sequence Number always starts at 0000 and increases without regard to changes in trucks)

Yes

AF3 Data

X(37)

Value=”^AF3;”<Drop Location Line 1>””

Yes

AF4 Data

X(37)

Value=”^AF4;”<Drop Location Line 2>””

Yes

AF5 Data

X(37)

Value=”^AF5;”<Drop Location Line 3>””

Yes

AF6 Data

X(15)

Value=”^AF6;BO “<draw quantity for draw class defined in Business Rules> Note: Draw quantity is optional.

Yes

AF7 Data

X(21)

Value=”^AF7;” ““

Yes

AF8 Data

X(21)

Value=”^AF8;” ““

Yes

AF9 Data

X(15)

Value=”^AF9;”<Product ID>

Yes

AF10 Data

X(38)

Value=”^AF10;”<Edition Description>

Yes

AF11 Data

X(16)

Value=”^AF11;”<Edition ID>

Yes

<Blank>

<Blank>

<Blank>

Yes

Normal Indicator

X(7)

Value=”^NORMAL”

Yes

End of Route Detail Record

X(1)

Value=”!”

No

End of Truck Record

Field
Format
Value
New Line

Start Truck Detail Record

X(5)

Value=”%2406”

No

Truck ID Indicator

X(3)

Value=”+11”

No

Truck Name

X(13)

Value=”RT” + Truck ID + <A> or <B>. Value “A” for processing bundles equal or under the minimum. Value “B” for processing bundles above the minimum.

No

End of Truck Record

X(1)

Value=”!”

No

End of Title Record

Field
Format
Value
New Line

End Title Record

X(5)

Value=”%2411”

No

Title Name Indicator

X(3)

Value=”+40”

No

Title Name

X(8)

Value=<weekday><weeknumber>

No

End of End Title Record

X(1)

Value=”!”

No

PreviousSingle Copy Demographic ImportNextSubscriber Activity Import Format

Last updated 2 years ago