498 499 AD_ADDRESS.USPS_STATE_CD mailing address state abbreviation – 500 504 AD_ADDRESS.ZIP_CD Owner’s mailing address five digit zip code – 505 508 AD_ADDRESS.ZIP_PLUS4_CD Owner’s mailing address post four digit zip code – mailing address country name. This value is determined by using the value found in AD_ADDRESS.CNTRY_CD = 509 511 AD_ADDRESS.CNTRY_CD LJ_COUNTRY.CNTRY_NAME – 512 533 OWN/OPER PHONE Drop the beginning for long distance dialing – “1” 534 555 OWN/OPER FAX Drop the beginning for long distance dialing – “1” NAICS 556 - 561 Broker Name. This value is determined by the following: and AC_DAY_ACTV_CONT.LAST_NAME or and LM_ADDN_ID.ADDN_ID = (if and last name fields AC_DAC_SET.DENORMALIZED_ID and 562 611 are null) –
498 – 499 AD_ADDRESS.USPS_STATE_CD mailing address state abbreviation 500 – 504 AD_ADDRESS.ZIP_CD Owner’s mailing address five digit zip code 505 – 508 AD_ADDRESS.ZIP_PLUS4_CD Owner’s mailing address post four digit zip code 509 – 511 AD_ADDRESS.CNTRY_CD mailing address country name. This value is determined by using the value found in AD_ADDRESS.CNTRY_CD = LJ_COUNTRY.CNTRY_NAME 512 – 533 OWN/OPER PHONE Drop the beginning “1” for long distance dialing 534 – 555 OWN/OPER FAX Drop the beginning “1” for long distance dialing 556 - 561 NAICS 562 – 611 and AC_DAY_ACTV_CONT.LAST_NAME or (if and last name fields are null) Broker Name. This value is determined by the following: and LM_ADDN_ID.ADDN_ID = AC_DAC_SET.DENORMALIZED_ID and