Admin at 23:54, 31 May 2018

2018-05-31T23:54:17Z

@@ Line 1: / Line 1: @@
-[[Listware for Excel:Reference|&larr; Listware for Excel Reference]]
+{{LWESmartMoverNav
+|StepsCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}
 {{CustomTOC}}

Admin at 21:39, 23 September 2014

2014-09-23T21:39:33Z

← Older revision		Revision as of 21:39, 23 September 2014
Line 11:		Line 11:
	\|-		\|-
	\|[[Listware for Excel:SmartMover Tutorial\|Tutorial]]		\|[[Listware for Excel:SmartMover Tutorial\|Tutorial]]
			\|-
			\|[[Listware for Excel:SmartMover:PAF\|PAF]]
	\|-		\|-
	\|		\|

Admin at 19:38, 17 September 2014

2014-09-17T19:38:10Z

← Older revision		Revision as of 19:38, 17 September 2014
Line 30:		Line 30:
	\|-		\|-
	\|[[Listware for Excel:SmartMover:Processing\|Processing]]		\|[[Listware for Excel:SmartMover:Processing\|Processing]]
	\|-
	~~\|[[Listware for Excel:SmartMover:Review Results\|Review Results]]~~
	\|}		\|}
	\|-		\|-

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

2014-09-17T18:42:04Z

Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

New page

[[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]]
|-
|[[Listware for Excel:SmartMover:Review Results|Review Results]]
|}
|-
|
{| 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]]
|}
|}

{{CustomTOC}}

[[File:LWE_SmartMover_OutputColumns.png|link=]]

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."

;Prefix
: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."

;Suffix
:Parsed name suffix. E.g. "Esquire."

==Address==
;Company
:Company or organization.

;Address
: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.

;City
:City.

;State
:US State or Canadian Province.

;ZIP Code
:US ZIP Code or Canadian Postal Code.

;Country
:Country name.

;AddressKey
: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.

;Suite
:Suite.

: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.

[[Category:Listware for Excel]]

Listware for Excel:SmartMover:Output Columns - Revision history

Admin at 23:54, 31 May 2018

Admin at 21:39, 23 September 2014

Admin at 19:38, 17 September 2014

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."