Listware for Excel:Global:Output Columns - Revision history

Admin at 23:47, 31 May 2018

2018-05-31T23:47:31Z

@@ Line 1: / Line 1: @@
-[[Listware for Excel:Reference|&larr; Listware for Excel Reference]]
+{{LWEGlobalNav
+|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 18:39, 25 July 2017

2017-07-25T18:39:01Z

← Older revision		Revision as of 18:39, 25 July 2017
Line 160:		Line 160:

	;Sub-Premises		;Sub-Premises
	:The ~~alpha-numeric~~ code that identifies an individual location.		:The alphanumeric code that identifies an individual location.

	;Building		;Building

Admin at 21:15, 13 December 2016

2016-12-13T21:15:27Z

← Older revision		Revision as of 21:15, 13 December 2016
Line 184:		Line 184:
	;Latitude and Longitude		;Latitude and Longitude
	:Output the latitude and longitude.		:Output the latitude and longitude.

			;Link to Map Location
			:Global Verify will use the returned Address and Latitude Longitude pair to create a hyperlink to the specified Map Server. Unverified records with no returned Lat Long pair, may therefore display a map to the user’s local area determined by the selected Map Server.


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 21:43, 15 September 2014

2014-09-15T21:43:55Z

← Older revision		Revision as of 21:43, 15 September 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| 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;"\|'''Global Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Global Check and Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
			\|-
			\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:Global\|Overview]]		\|[[Listware for Excel:Global\|Overview]]

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

2014-07-07T18:01:30Z

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;"|'''Global Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Listware for Excel:Global|Overview]]
|-
|[[Listware for Excel:Global Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:Global:Processing Range|Processing Range]]
|-
|[[Listware for Excel:Global:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:Global:Input Columns|Input Columns]]
|-
|[[Listware for Excel:Global:Output Columns|Output Columns]]
|-
|[[Listware for Excel:Global:Reporting|Reporting]]
|-
|[[Listware for Excel:Global:Review Settings|Review Settings]]
|-
|[[Listware for Excel:Global:Processing|Processing]]
|-
|[[Listware for Excel:Global: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_Global_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:

==Output Address Format Options==
Select the addressing style that best describes the type of data that you would like to output

;Multi-Line Address
:Use this option if you want the entire mailing address to appear in output Address Lines 1-8.

;Delivery Address
:Use this option if you want the street address to appear in output Address Lines 1-8 and Regional information to appear in separate fields.

;Delivery Address and Parsed Components
:Use this option if you want the street address to appear in output Address Lines 1-8 and Regional information to appear in separate fields. In addition, you can capture the parsed street address components.

==Organization==
;Organization
:Output the company or organization.

==Address Lines==
;Address Line 1 - Address Line 8
:Output the selected line of the complete output address.

==Regional Levels==
;Double-Dependent Locality
:Double-Dependent Locality. An area or village (e.g. UK) within a Dependent Locality required to identify an address.

;Dependent Locality
:Dependent Locality. A district, area, or neighborhood (e.g. Turkey) within a Locality required to identify an address.

;City/Locality
:A city (e.g. US), town, or municipality (e.g. Canada) that is the most common population center element within an Administrative Area.

;Sub-Administrative Area
:A county (e.g. US) or region larger than the Locality but smaller than the Administrative Area.

;State/Province/Admin Area
:A state (e.g. US), province (e.g. Canada) or canton (e.g. Switzerland) contained within a Country.

;ZIP/Postal Code
:The postal code or ZIP code (e.g. US) for the input address.

;Sub-National Area
:Sub-National Area. Not commonly used. An arbitrary region smaller than a Country but larger than an Administrative Area.

==Country==
;ISO 3166-1 Country Code
:Output the ISO 3166-1 Country Code.

;Format
:Select the format of the output country code. The possible formats are:

;:*Alpha-2

:::The two letter abbreviation for countries. E.G., for United States; Canada; and the Philippines: US; CA; PH.

;:*Alpha-3

:::The three letter abbreviation for countries. E.G., for United States; Canada; and the Philippines: USA; CAN; PHL.

;:*Numeric

:::The number code for countries. E.G., for United States; Canada; and the Philippines: 840; 124; 608.

==Parsed Components==
;Address Type
:A one-character code for the type of address coded. Only for US and Canadian addresses.

;AddressKey
:A unique key for the address. Only for US and Canadian addresses.

;Thoroughfare
:The thoroughfare (eg, the name of the street or block).

;Thoroughfare Pre-Direction
:The prefix directional contained within the Thoroughfare.

;Thoroughfare Leading Type
:The leading thoroughfare type indicator within the Thoroughfare.

;Thoroughfare Name
:The name indicator within the Thoroughfare.

;Thoroughfare Trailing Type
:The trailing thoroughfare type indicator within the Thoroughfare.

;Thoroughfare Post-Direction
:The postfix directional contained within the Thoroughfare.

;Dependent Thoroughfare
:The dependent thoroughfare (eg, the name of the dependent street or block).

;Dependent Thoroughfare Pre-Direction
:The prefix directional contained within the Dependent Thoroughfare.

;Dependent Thoroughfare Leading Type
:The leading thoroughfare type indicator within the Dependent Thoroughfare.

;Dependent Thoroughfare Post-Direction
:The postfix directional contained within the Dependent Thoroughfare.

;Sub-Premises
:The alpha-numeric code that identifies an individual location.

;Building
:The descriptive name identifying an individual location.

;Premises Type
:The leading premises type indicator within Premises.

;Premises Number
:The alphanumeric indicator within Premises.

;Sub-Premises Type
:The sub-premises type indicator within Sub-Premises.

;Sub-Premises Number
:The alphanumeric indicator within Sub-Premises.

;Post Box
:The post box information for a particular delivery point.

==GeoLocation==
;Latitude and Longitude
:Output the latitude and longitude.

[[Category:Listware for Excel]]