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 “AccountStatement” usage.
Data Element | Description |
---|---|
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 “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).
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.
File mapping can be used for the following options.
Data Element | Description |
---|---|
Data Element | Description |
---|---|
Data Element |
---|
Data Element |
---|
Data Element |
---|
File Map Usage |
---|
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).
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.
* Field is required.
The following data elements can be used with the “ALTDrawAdjImprt” usage.
* 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:
The “AuthImport” file mapping usage is used with this option. The possible data elements are described in the following table.
* Field is required.
Data Element | Description |
---|
Adjust Or Replace |
Barcode |
Draw Change Amount [Sun-Sat] |
Draw Type Class |
Effective Date |
Filler |
Identification Number* |
Record Identifier |
Reversal Date |
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 |
|
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 |
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. |
The following data elements can be used with the “BalanceFwdBill” usage.
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
The following data elements can be used with the “BASREconcilSumm” usage.
* Field is required.
The following data elements can be used with the “BundleTops” usage.
The following data elements can be used with the “BASReconcilDtl” usage.
* Field is required.
Data Element | Description |
---|---|
Data Element | Description |
---|---|
Data Element | Description |
---|
Amount
Amount
BAS Category*
BAS category
Quantity
Quantity
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.
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 |
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.”
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* |
|
The following data elements can be used with the “ComplaintSummary” usage.
* Field is required.
The following data elements can be used with the “CarrierMailExp” usage.
The following data elements can be used with the “CleanseFlagExp” usage.
Data Element |
---|
Data Element | Description |
---|---|
Account ID*
Account Name
Complaint Code*
District Manager
Number of Complaints*
Route ID*
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
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 |
|
|
The following data elements can be used with the “CommHistImport” usage.
The following data elements can be used with the “CleanseFlagImp” usage.
* Field is required.
The following data elements can be used with the “DNCImport” usage.
* Field is required
Data Element | Description |
---|---|
Data Element | Description |
---|
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.
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
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. |
The following data elements can be used with the “ComplaintDetail” usage.
* Field is required.
The following data elements can be used with the “CCExpire” usage.
The following data elements can be used with the “DrawChgImport” usage.
* 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 “DrawAdjImport” usage.
* Field is required
The following data elements can be used with the “DoNotCall” usage.
* Field is required
The following data elements can be used with the “DispatchExport” usage.
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.
Account ID* | Days Adjust | Modify Time |
---|---|---|
Data Element | Description |
---|---|
Data Element | Description |
---|---|
Data Element | Description |
---|---|
SEQ | “Dispatch” | “DispatchPlus” |
---|---|---|
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
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
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.
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.
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.
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
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
File maps used for the Audit GL Interface Journal export have a usage of “GLAudit,” and the following data elements can be used:
* Field is required.
The following data elements can be used with the “DropCreditAudit” usage.
The following data elements can be used with the “DrwForecastExprt” usage.
The following data elements can be used with the “DropTimeImport” usage.
* Field is required.
The following data elements can be used with the “MerchandiseRpt” usage.
Amount
GLCompanyID*
Comments
GLTranDate
CreateDate
GLTranNumber*
CreateTime
JournalCode
CreateUser
Memo
CreditAmount
Posted
DebitAmount
PostedBatchID
FiscalPeriod
PostedDate
FiscalYear
ReferenceEntityID
GLAccountID*
ReferenceEntityType
GLBatchID
Suspended
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
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
Delivery Date |
Delivery Time |
Departure ID |
Drop Order |
Product ID |
Run Date |
Truck ID* |
Truck Sequence ID |
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 |
File maps used for the GL Export have a usage of “GLExport,” and the following data elements can be used:
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 “MiscChgCredImp” usage.
Data Element | Description |
---|---|
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
The following data elements can be used with the “NoteImport” usage.
* Field is required.
Data Element | Description |
---|---|
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
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 “PastDueLetter” usage.
Data Element | Description |
---|---|
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 “PymtAuthor” usage.
* Field is required
** Field is required if a record identifier is entered on the record type setup screen.
Data Element | Description |
---|---|
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.).
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.”
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.”
Carriage Return
Filler
Line Feed
Literal Value
Price Code
Publish Date
Quantity
Service Code
USPS Number
Volume Number
Weight
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 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
The following data elements can be used with the “ProofOfSale” usage.
* Field is required
Data Element | Description |
---|---|
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.
The following table lists the data elements available for the “SubBilling” File Map usage.
Data Element | Data Element |
---|---|
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 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.
* Field is required.
Data Element | Route | Single Copy | TM |
---|---|---|---|
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
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.
* 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 data elements can be used with the “RouteAddrLabel” usage, which can be used with the Route Labels and Previous Delivery Labels menu options.
* 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 “Stacker” usage.
The following data elements can be used with the “RouterImport” usage.
* Indicates a required element
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
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
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 |
AAM Zone ID |
Address ID* |
New Route ID* |
Old Route ID* |
Product ID* |
Record Identifier |
The following data elements can be used with the “RouteSmart” usage.
* Indicates a required element
Data Elements |
---|
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 |
The following data elements can be used with the “SoldImport” usage.
* Field is required
Data Element | Description |
---|---|
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.
The following data elements can be used with the “StatusCollctCard” usage.
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
The following data elements can be used with the “SubTranExprt” usage.
* 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.
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.
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.
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 “SubscrExprt” usage.
* Field is required.
The following data elements can be used with the “SubRefJrnl” usage.
The following data elements can be used with the “SubLockbox” usage.
* 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.”
The following data elements can be used with the “SubPymtJrnl” usage.
Data Element | Detail Element |
---|---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element |
---|
Data Element | Data Element |
---|
Data Element |
---|
Data Element |
---|
Data Element |
---|
Data Element |
---|
Data Element |
---|
Data Element | Description |
---|
Data Element | Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
Data Element | Data Element |
---|
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 |
|
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 |
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 |
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. |
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 “SubscrTaxExpt” usage.
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:
The following data elements can be used with the “TokenUpdater” usage.
* Field is required.
The following data elements can be used with the “SubTranImprt” usage.
* 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 “TM” usage.
Data Element | Description |
---|
Data Element | Description |
---|
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 |
AdjustOrReplace |
EffectiveDate |
Filler |
Quantity |
RecordIdentifier |
ReversalDate |
RouteID |
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 * |
|
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 | Flag that determines whether a renewal notice is sent to auto renew subscribers. |
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. |
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 “TruckSeqExp” usage.
* Field is required.
The following data elements can be used with the “TruckSeqImp” usage.
* Field is required.
The following data elements can be used with the “AccountLockbox” usage.
* 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 “AddressExport” and “AddressImprt” usages.
* Field is required
** Field can only be exported if addresses are stored unparsed in the database and QAS is used for address correction
Data Element | Description |
---|---|
Data Element | Description |
---|---|
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
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*
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.
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.
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
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