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 |