Carrier Mail Export
The following data elements can be used with the “CarrierMailExp” usage.
Account ID
The ID of the account.
Account Name
Account’s name
Account Phone Number
Account’s phone number
Ad Zone ID
Ad zone ID
All Message
“All” message entered in Bundle Info.
Billing Method
Account’s billing method
Building
Address’ building
Carrier Notification ID
ID of the account notification method
City ID
City
Complex
Address’ complex
Component Product ID
ID of the component product, if part of a combined publication. Same as the Product ID if there is no combined publication.
Component Route ID
Route ID associated with the component product, if part of a combined publication. Same as the Route ID if there is no combined publication.
Copies
Number of copies
Copies [day of week]
Copies by day of the week
Create Date Create Time Create User
Date, time and user information for the message
Delivery Instructions
Instructions for delivering the paper to the subscriber
Delivery Schedule ID
ID of the delivery schedule
Directions to Address
Directions to the subscriber’s address
Distrib Type Message
Route, motor, or single copy message entered in Bundle Info
Drop Location Line [1-6]
Drop location (lines 1-6)
Drop Order
The drop order of the route on the truck
Edition ID
The route’s edition
Expire Date
Subscription expire date (for office pay subscribers)
External Subscription ID
Subscriber’s ID for external publication
First Name
Occupant’s first name
Honorific ID
Occupant’s honorific
House Number
Address house number
House Number Modifier
Address’ house number modifier
Insert Mix
Name of the insert mix
Last Name
Occupant’s last name
Level Designator ID
Address’ level type
Level Number
Address’ level number
Line Feed
A line feed to start a new line
Literal Value
Literal fields are hard-coded to display whatever is entered in “format”. For example, if a field should always display “Z”, set it up as a literal value and enter “Z” in FORMAT.
Message Date
Date of the message
Message ID
ID of the message
Message Label
Label of the message
Message Text
Text of the message
Message Type
Type of message
Method Type
The type of notification method (e.g., phone type if notification method is phone)
Middle Initial
Occupant’s middle initial
Name Address Line [1-6]
These six lines can be used for the subscriber’s name and address, rather than using individual name and address elements.
Notification Method
Type of account notification (email, phone, etc.)
Notification Method Details
Specific phone number, email address, URL, etc.
Occupant Salutation ID
The occupant’s title
Other Name
Occupant’s other name
Permanent
Indicates whether the reason code is permanent
Postdirectional
Address postdirectional
Predirectional
Address predirectional
Primary Contract Holder
Setting of the Business Rule, What account demographic should be used for the Primary Contract Holder in the Vendor and Carrier Mail Exports? (Account Setup section).
Product ID Publication Name
Subscriber’s publication ID and name
Publish Date
Publishing date on which transaction was processed
Rate Code ID
Subscriber’s rate code
Rate Description
Description of subscriber’s rate code
Reason
Reason code entered for transaction
Restart Date
Subscriber’s restart date
Route ID
ID of the route
Route Name
Name of the route
Source Code
Source code entered for the transaction
State ID
State
Street Name
Address street name
Street Suffix ID
Street type
Subscriber Phone Area Code
Area code of subscriber’s phone number (e.g., the 304 in 3045551234)
Subscriber Phone Number
Subscriber’s phone number, including area code (e.g., 3045551234)
Subscriber Phone Prefix and Line
Subscriber’s phone number, not including area code (e.g., 5551234)
Subscription ID
Subscriber’s subscription ID
Subsource ID
Subsource for source code entered with transaction.
TM Product ID
ID of the TM product
Tran Date
Transaction date for subscriber transaction.
Tran Number
Transaction ID
Tran Type ID
Transaction type
Truck ID
ID of the truck
Unit Designator ID
Address’ unit designator
Unit Number
Address’ unit number
Zip Code
Zip/postal code
Zip Extension
Zip/postal extension
Last updated
