Listware for Excel:Business Coder:Input Columns: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
|StepsCollapse= | |StepsCollapse= | ||
}} | }} | ||
{{CustomTOC}} | {{CustomTOC}} | ||
[[File:LWE_BusinessCoder_InputColumns.png|link=]] | [[File:LWE_BusinessCoder_InputColumns.png|link=]] | ||
Latest revision as of 17:08, 3 June 2016
← Listware for Excel Reference
| Business Coder Navigation | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| ← Listware for Excel Overview | |||||||||
| Overview | |||||||||
| Tutorial | |||||||||
| |||||||||
| Result Codes |
Specify the input columns you want to process by selecting them in the drop-down menus.
The following input columns are available:
Address
- Company
- Specify the column that contains company and/or organization names.
- Address
- Specify the column that contains street or PO Box addresses.
- Address 2
- Specify the column that contains a second address line. If available, this is generally extra addressing information such as an apartment or suite numbers.
- If the information is in the "Address" column, it will be found and parsed to this column when you specify that column here.
- City
- Specify the column that contains cities.
- State
- Specify the column that contains the US state and/or Canadian province.
- ZIP Code
- Specify the column that contains the US ZIP code and/or Canadian Postal Code.
- Country
- Specify the column that contains the country name (US or Canada).
- Although Business Coder can often identify an address's country of origin by looking at the address, sometimes address verification can improve if the country is provided.
Phone
- Phone
- Specify the column that contains phone numbers.
Web Site
- URL
- The web site URL of the business.
Identifiers
- Stock Ticker
- The assigned stock exchange abbreviation/symbol for the business.
- MAK
- Melissa Address Key. A unique key assigned to the address record.