Difference between revisions of "Listware for Excel:SmartMover:Output Columns"

From Melissa Data Wiki
Jump to navigation Jump to search
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''SmartMover NCOA Navigation'''
| style="padding-right:220px;"|
|style="border-bottom:1px solid #aaaaaa;"|[[Listware for Excel:Check and Verify|← Check and Verify]]
|[[Listware for Excel:SmartMover|Overview]]
|[[Listware for Excel:SmartMover Tutorial|Tutorial]]
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|[[Listware for Excel:SmartMover:Processing Range|Processing Range]]
|[[Listware for Excel:SmartMover:NCOA Options|NCOA Options]]
|[[Listware for Excel:SmartMover:Input Columns|Input Columns]]
|[[Listware for Excel:SmartMover:Output Columns|Output Columns]]
|[[Listware for Excel:SmartMover:Reporting|Reporting]]
|[[Listware for Excel:SmartMover:Review Settings|Review Settings]]
|[[Listware for Excel:SmartMover:Processing|Processing]]
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|[[Result Codes]]


Latest revision as of 23:54, 31 May 2018

← Listware for Excel Reference

SmartMover NCOA Navigation
← US & Canada
Processing Range
NCOA Options
Input Columns
Output Columns
Review Settings
Result Codes

LWE SmartMover OutputColumns.png

Specify what data you want to output by checking the box next to the desired columns.

You can right-click each section to 'Check All' or 'Check None'.

The following output columns are available:

Name 1

This section contains name components.

Full Name
Full name. E.g. "Dr. Bill S. Preston, Esquire."
Parsed name prefix. E.g. "Dr."
First Name
Parsed first name. E.g. "Bill."
Middle Name
Parsed middle name. E.g. "S."
Last Name
Parsed last name. E.g. "Preston."
Parsed name suffix. E.g. "Esquire."


Company or organization.
Full address.
Address 2
Second address. If you specify a second address line, secondary information (apartment, suite, etc.) will be put here. If you choose to not output to Address 2, secondary information will be appended to the first Address.
US State or Canadian Province.
ZIP Code
US ZIP Code or Canadian Postal Code.
Country name.
AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa Data products.

Move Information

Move Date
Move effective date.
Move Status
Move status description.
Move Type
Move type description.

Address Information

Extra Address Information
Extra information that does not fit in any of the output address columns.
If requested, the suite will be populated in this column instead of the output address columns.
Private Mailbox
Private Mailbox. These mailboxes are used in commercial receiving agencies, such as the UPS store.
If requested, the Private Mailbox will be populated in this column instead of the output address columns.
Urbanization (PR Only)
Urbanization name. These are used only in Puerto Rican addresses.
City Abbreviation
City abbreviation is any is available.
State Name
Full state name.
ISO Country Code
ISO country code.
Carrier Route
Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.
Delivery Point
Delivery Point (DP) and its check digit. This is a 2-digit code defining the address's delivery location. The single-digit check digit follows the delivery point and serves as an error check for the ZIP Code, Plus4 and Delivery Point.

Parsed Address

House Number
Parsed House Number for the output address.
Street Pre-Directional
Parsed Street Pre-Directional for the output address.
Street Name
Parsed Street Name for the output address.
Street Suffix/Type
Parsed Street Suffix (a.k.a. Street Type) for the output address.
Street Post-Directional
Parsed Post-Direction for the output address.
Suite Name
Parsed Suite Name for the output address.
Suite Number
Parsed Suite Number for the output address.
Private Mailbox Name
Parsed Private Mailbox Name for the output address.
Private Mailbox Number
Parsed Private Mailbox Number for the output address.
Route Service Number (CAN Only)
Parsed Route Service Number for the output address.
Canada Only.
Delivery Installation (CAN Only)
Parsed Delivery Installation for the output address.
Canada Only.
Lock Box Number (CAN Only)
Parsed Lock Box Number for the output address.
Canada Only.