ZCQ_IMP_LOCATION_VIEW

Details

• Schema: FUSION

• Object owner: ZCQ

• Object type: VIEW

Columns

Name

LOCATIONINTERFACEID BATCHID LOCATIONIDENTIFIER HOUSETYPE ADDRESS ADDRESSLINE1 ADDRESSLINE2 ADDRESSLINE3 ADDRESSLINE4 PHONETICADDRESSLINES CITY COUNTY COUNTRYSUBENTITY PROVINCE COUNTRY POSTALCODE POSTALCODEEXT POSITION ADDRESSEXPIRATIONDATE ADDRESSEFFECTIVEDATE LOCATIONLANGUAGE DEPENDENTLOCALITY DOUBLEDEPENDENTLOCALITY CUSTOMATTRIBUTE1 CUSTOMATTRIBUTE2 CUSTOMATTRIBUTE3 CUSTOMATTRIBUTE4 CUSTOMATTRIBUTE5 CUSTOMATTRIBUTE6 CUSTOMATTRIBUTE7 CUSTOMATTRIBUTE8 CUSTOMATTRIBUTE9 CUSTOMATTRIBUTE10

Query

SQL_Statement

select LOCATION_T_ID LocationInterfaceID, BATCH_ID BatchID, LOCATION_ID LocationIdentifier,HOUSE_TYPE HouseType, (Address1||' '||Address2||' '||Address3||' '||Address4) Address, ADDRESS1 AddressLine1,ADDRESS2 AddressLine2, ADDRESS3 AddressLine3,ADDRESS4 AddressLine4,ADDRESS_LINES_PHONETIC PhoneticAddressLines, CITY City,COUNTY County,STATE CountrySubEntity,PROVINCE Province,COUNTRY Country,POSTAL_CODE PostalCode, POSTAL_PLUS4_CODE PostalCodeExt,POSITION Position, ADDRESS_EXPIRATION_DATE AddressExpirationDate,ADDRESS_EFFECTIVE_DATE AddressEffectiveDate, LOCATION_LANGUAGE LocationLanguage, ADDR_ELEMENT_ATTRIBUTE2 DependentLocality, ADDR_ELEMENT_ATTRIBUTE3 DoubleDependentLocality, ATTRIBUTE1 CustomAttribute1,ATTRIBUTE2 CustomAttribute2,ATTRIBUTE3 CustomAttribute3, ATTRIBUTE4 CustomAttribute4, ATTRIBUTE5 CustomAttribute5, ATTRIBUTE6 CustomAttribute6, ATTRIBUTE7 CustomAttribute7, ATTRIBUTE8 CustomAttribute8, ATTRIBUTE9 CustomAttribute9, ATTRIBUTE10 CustomAttribute10 from hz_imp_locations_t