1. Tables and Views for Sales and Fusion Service
  2. HZ_IMP_LOCATIONS_T

HZ_IMP_LOCATIONS_T

The import interface table HZ_IMP_LOCATIONS_T has the details of the location to be loaded and each interface record would insert a record into HZ_LOCATIONS and HZ_LOCATION_PROFILES

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Status
LOCATION_T_ID NUMBER 18 Unique identifier of the HZ_IMP_LOCATIONS_T interface record. Internal use only.
LONGITUDE NUMBER Used to store Longitude Information for the Location for Spatial Proximity and containment purposes
LATITUDE NUMBER Used to store Latitude Information for the Location for Spatial Proximity and containment purposes
INTERFACE_ROW_ID NUMBER 18 Unique identifier of the HZ_IMP_LOCATIONS_T interface record. Internal use only.
BATCH_ID NUMBER 18 Yes Unique Identifier for a Batch
LOCATION_ORIG_SYSTEM VARCHAR2 30 Original System ID for the Location
LOCATION_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original System Reference for the Location
LOCATION_ID NUMBER 18 Unique identifier for the location
INSERT_UPDATE_FLAG VARCHAR2 1 Indicates if a record should be explicitly inserted or updated Active
ACTION_FLAG VARCHAR2 1 Indicates the insert or update action decided by the matching process
COUNTRY VARCHAR2 2 Country code from the TERRITORY_CODE column in the FND_TERRITORY table Active
ADDRESS1 VARCHAR2 240 Fist Line of Address Active
ADDRESS2 VARCHAR2 240 Second Line of Address Active
ADDRESS3 VARCHAR2 240 Third Line of Address Active
ADDRESS4 VARCHAR2 240 Fourth Line of Address Active
FLOOR_NUMBER VARCHAR2 40 Floor number
BUILDING VARCHAR2 240 Building
CITY VARCHAR2 60 CITY Active
STATE VARCHAR2 60 STATE Active
PROVINCE VARCHAR2 60 PROVINCE Active
COUNTY VARCHAR2 60 COUNTY Active
ADDRESS_LINES_PHONETIC VARCHAR2 560 Phonetic or Kana representation of the Kanji address lines (used in Japan) Active
POSTAL_CODE VARCHAR2 60 Postal Code Active
POSTAL_PLUS4_CODE VARCHAR2 10 Four digit extension to the United States Postal ZIP code. Active
POSITION VARCHAR2 50 The primary direction such as North or East that is used to access the location
LOCATION_DIRECTIONS VARCHAR2 640 Directions to the location Active
CLLI_CODE VARCHAR2 60 Common Language Location Identifier (CLLI) code Active
LOCATION_LANGUAGE VARCHAR2 4 Operating language of the location. Foreign key to the FND_LANGUAGES table Active
DESCRIPTION VARCHAR2 2000 An extensive description of the location Active
SHORT_DESCRIPTION VARCHAR2 240 Short description of the location Active
SALES_TAX_GEOCODE VARCHAR2 30 US State and Local Tax Jurisdiction code. Use this field to provide either a Vertex GeoCode or Taxware Geocode value for the Point of Order Origin Active
SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2 1 Indicates if the location is inside the boundary of a city. Used to calculate state and local taxes in the United States. Value '1' is for locations inside the city limits and '0' is for locations outside the city limits. Defaults 1 if null.
HOUSE_TYPE VARCHAR2 30 Some countries require the use of a House Type field (ex. Netherlands)
COMMENTS VARCHAR2 2000 User comments
TIMEZONE_CODE VARCHAR2 50 Time zone identifier. Foreign key to HZ_TIMEZONES Active
ADDRESS1_STD VARCHAR2 240 Standardized First Line of Address Active
ADDRESS2_STD VARCHAR2 240 Standardized Second Line of Address Active
ADDRESS3_STD VARCHAR2 240 Standardized Third Line of Address Active
ADDRESS4_STD VARCHAR2 240 Standardized Fourth Line of Address Active
CITY_STD VARCHAR2 60 Standard City Active
PROVINCE_STD VARCHAR2 60 Standard Province
STATE_STD VARCHAR2 60 Standard State
COUNTY_STD VARCHAR2 60 Standardized County Active
COUNTRY_STD VARCHAR2 2 Standardized Country Active
POSTAL_CODE_STD VARCHAR2 60 Standard Postal Code Active
ADAPTER_CONTENT_SOURCE VARCHAR2 30 The Source used to validate the address
ADDR_VALID_STATUS_CODE VARCHAR2 30 The Address Validation Code returned by the Source Active
DATE_VALIDATED DATE Date Address was validated Active
ADDRESS_EFFECTIVE_DATE DATE Date when the location is valid.
ADDRESS_EXPIRATION_DATE DATE Date when the location is no longer valid
VALIDATED_FLAG VARCHAR2 1 Indicates if the location was validated. Y for validated, N for invalidated.
DO_NOT_VALIDATE_FLAG VARCHAR2 1 A new attribute that indicates that a particular location is not eligible for address validation regardless of the current Validation Status Code. The default is "No" meaning that by default, all address are eligible for validation. This attribute is not unset on update.
INTERNAL_FLAG VARCHAR2 1 This is set to Y for identifying internal/legal location. Possible values are Y and N. Default is N.
INTERFACE_STATUS VARCHAR2 30 Status for the data in the interface table Active
ERROR_ID NUMBER 18 Foreign Key to the Error Table Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ADDR_ELEMENT_ATTRIBUTE1 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE2 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE3 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE4 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE5 VARCHAR2 150 Additional address element to support flexible address format
FILE_RECORD_NUM NUMBER 10 This column is required by import wizard to related record in the interface table to the file row.
TRANSLITERATION_LANG VARCHAR2 4 This column captures language used for the location components in this table. It is validated against FND_LANGUAGES.LANGUAGE_CODE. No Default value.
LL_POSTAL_CODE VARCHAR2 60 Postal Code for Local language
LL_POSTAL_PLUS4CODE VARCHAR2 10 Four digit extension to the United States Postal ZIP code for local language.
LL_STATE VARCHAR2 60 STATE for local language
LL_PROVINCE VARCHAR2 60 PROVINCE for local language
LL_COUNTY VARCHAR2 60 COUNTY for local language
LL_CITY VARCHAR2 60 CITY for local language
LL_ADDRESS1 VARCHAR2 240 First Line of Address for local language
LL_ADDRESS2 VARCHAR2 240 Second Line of Address for local language
LL_ADDRESS3 VARCHAR2 240 Third Line of Address for local language
LL_ADDRESS4 VARCHAR2 240 Fourth Line of Address for local language
LL_BUILDING VARCHAR2 240 Building for local language
LL_FLOOR_NUMBER VARCHAR2 240 Floor number for local language
LL_ADDR_ELEMENT_ATTRIBUTE1 VARCHAR2 150 Additional address element to support flexible address format for local language
LL_ADDR_ELEMENT_ATTRIBUTE2 VARCHAR2 150 Additional address element to support flexible address format for local language
LL_ADDR_ELEMENT_ATTRIBUTE3 VARCHAR2 150 Additional address element to support flexible address format for local language
LL_ADDR_ELEMENT_ATTRIBUTE4 VARCHAR2 150 Additional address element to support flexible address format for local language
LL_ADDR_ELEMENT_ATTRIBUTE5 VARCHAR2 150 Additional address element to support flexible address format for local language
ADDR_ELEMENT_ATTRIBUTE2_STD VARCHAR2 150 Dependent Locality
ADDR_ELEMENT_ATTRIBUTE3_STD VARCHAR2 150 DoubleDependentLocality
POSTAL_PLUS4_CODE_STD VARCHAR2 10 PostalPlusCode
GNR_STATUS VARCHAR2 4 GNR status
ACTION_CODE VARCHAR2 30 Indicates delete action entered by user
IMPORT_STATUS_CODE VARCHAR2 30 Status for the data in the interface table
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
FILE_NAME_SYSTASK_ID NUMBER 18 Stores systask id for each import csv file.
PARTYSITE_INT_ROWID NUMBER 18 Unique identifier of the HZ_IMP_PARTYSITES_T interface record. Internal use only.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_IMP_LOCATIONS_T hz_imp_batch_summary BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_IMP_LOCATIONS_T_N1 Non Unique Default BATCH_ID, LOCATION_ID, INTERFACE_STATUS
HZ_IMP_LOCATIONS_T_N2 Non Unique Default ACTION_FLAG
HZ_IMP_LOCATIONS_T_N3 Non Unique Default BATCH_ID, LOCATION_ORIG_SYSTEM, LOCATION_ORIG_SYSTEM_REFERENCE, INTERFACE_STATUS
HZ_IMP_LOCATIONS_T_N4 Non Unique Default BATCH_ID, FILE_RECORD_NUM, INTERFACE_STATUS
HZ_IMP_LOCATIONS_T_N5 Non Unique Default BATCH_ID, PARTYSITE_INT_ROWID
HZ_IMP_LOCATIONS_T_U1 Unique Default LOCATION_T_ID