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

HZ_ADDR_LOCALES_INT

This table HZ_ADDR_LOCALES_INT is used to import address locales for optimized import

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
BATCH_ID NUMBER 18 Yes BATCH_ID
INTERFACE_ROW_ID NUMBER 18 Yes INTERFACE_ROW_ID
IMPORT_STATUS_CODE VARCHAR2 30 IMPORT_STATUS_CODE
ACTION_CODE VARCHAR2 30 ACTION_CODE
INTERNAL_ACTION_CODE VARCHAR2 30 INTERNAL_ACTION_CODE
FILE_RECORD_NUM NUMBER 10 FILE_RECORD_NUM
FILE_NAME_SYSTASK_ID NUMBER 18 FILE_NAME_SYSTASK_ID
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SITE_SOURCE_SYSTEM VARCHAR2 30 Original System for the Location Locale
SITE_SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Original System Reference for the Location Locale
PARTY_SITE_NUMBER VARCHAR2 30 Unique Identification number for the party site
PARTY_SITE_ID NUMBER 18 PARTY_SITE_ID
LOCATION_ID NUMBER 18 Unique Identifier for a Location. Foreign Key to HZ_LOCATIONS table.
LOCATION_LOCALE_ID NUMBER 18 Unique Identifier for this table.
LL_ADDR_ELEMENT_ATTRIBUTE1 VARCHAR2 150 Additional address element to support flexible address format
LL_ADDR_ELEMENT_ATTRIBUTE2 VARCHAR2 150 Additional address element to support flexible address format
LL_ADDR_ELEMENT_ATTRIBUTE3 VARCHAR2 150 Additional address element to support flexible address format
LL_ADDR_ELEMENT_ATTRIBUTE4 VARCHAR2 150 Additional address element to support flexible address format
LL_ADDR_ELEMENT_ATTRIBUTE5 VARCHAR2 150 Additional address element to support flexible address format
LL_ADDRESS1 VARCHAR2 240 First Address Line
LL_ADDRESS2 VARCHAR2 240 Second Address Line
LL_ADDRESS3 VARCHAR2 240 Third Address Line
LL_ADDRESS4 VARCHAR2 240 Fourth Address Line
LL_BUILDING VARCHAR2 240 Specific building name or number ata given address
LL_CITY VARCHAR2 60 the administrative or geographic subdivisions of certain state
LL_COUNTY VARCHAR2 60 the administrative or geographic subdivisions of certain state
LL_FLOOR_NUMBER VARCHAR2 240 Specific floor number at a given address or a particular building when building number is provided.
LL_POSTAL_CODE VARCHAR2 60 A postal code (known in various countries as a post code, postcode, or ZIP code) is a series of letters and/or digits appended to a postal address for the purpose of sorting mail.
LL_POSTAL_PLUS4_CODE VARCHAR2 20 POSTAL_PLUS4_CODE
LL_PROVINCE VARCHAR2 60 PROVINCE
LL_STATE VARCHAR2 60 One of the more or less internally autonomous territorial and political units composing a federation under a sovereign government:
COUNTRY VARCHAR2 2 LL_COUNTRY
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."

Indexes

Index Uniqueness Tablespace Columns
HZ_ADDR_LOCALES_INT_N1 Non Unique Default BATCH_ID, IMPORT_STATUS_CODE, INTERNAL_ACTION_CODE
HZ_ADDR_LOCALES_INT_N2 Non Unique Default BATCH_ID, IMPORT_STATUS_CODE, PARTY_SITE_ID
HZ_ADDR_LOCALES_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID