Output standard columns used in tMelissaDataAddress
The table below lists all the output standard columns in tMelissaDataAddress. These read-only columns are automatically added to
the output schema.
|
Output column |
Description |
|---|---|
|
COMPANY_STANDARDIZED |
This column returns a standardized company name. |
|
ADDRESSLINE1_STANDARDIZED |
This column returns the first line of the address. |
|
ADDRESSLINE2_STANDARDIZED |
This column returns the second line of the address. |
|
CITY_STANDARDIZED |
This column returns a standardized city name. |
|
STATE_STANDARDIZED |
This column returns a two-letter abbreviation for the state |
|
COUNTRY_STANDARDIZED |
This column returns a two-letter abbreviation for the country |
|
RESULTS_CODE |
This column returns verification codes to indicate data quality, For example, the AC02 code means that the For a complete list of the result codes visit http://www.melissadata.com/. |