Skip to main content

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



This column returns a standardized company name.


This column returns the first line of the address.


This column returns the second line of the address.


This column returns a standardized city name.


This column returns a two-letter abbreviation for the state name.


This column returns a two-letter abbreviation for the country name.


This column returns verification codes to indicate data quality, statuses and errors. These codes are written in comma-delimited lists. Each code consists of two letters followed by two numbers.

For example, the AC02 code means that the state name is corrected based on the combination of city name and ZIP code.

For a complete list of the result codes visit

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!