# Carrier Mail Export

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

| Data Element                                     | Description                                                                                                                                                                        |
| ------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 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                                                                                                                                                          |
| <p>Create Date<br>Create Time<br>Create User</p> | 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).             |
| <p>Product ID<br>Publication Name</p>            | 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                                                                                                                                                               |