HZ_LOCATION_LOCALES

Details

Schema: FUSION
Object owner: HZ
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
HZ_LOCATION_LOCALES_PK	LOCATION_LOCALE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOCATION_LOCALE_ID	NUMBER		18	Yes	Unique Identifier for this table.
LOCATION_ID	NUMBER		18	Yes	Unique Identifier for a LOcation. Foreign Key to HZ_LOCATIONS table.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	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.
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.
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
TRANSLITERATION_LANG	VARCHAR2	4		Yes	This column captures language used for the location components in this table. It is validated against FND_LANGUAGES.LANGUAGE_CODE. No Default value.
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.
POSTAL_PLUS4_CODE	VARCHAR2	20			POSTAL_PLUS4_CODE
STATE	VARCHAR2	60			One of the more or less internally autonomous territorial and political units composing a federation under a sovereign government:
PROVINCE	VARCHAR2	60			PROVINCE
COUNTY	VARCHAR2	60			the administrative or geographic subdivisions of certain state
CITY	VARCHAR2	60			The administrative or geographic subdivisions of certain state
ADDRESS1	VARCHAR2	240			First Address Line
ADDRESS2	VARCHAR2	240			Second Address Line
ADDRESS3	VARCHAR2	240			Third Address Line
ADDRESS4	VARCHAR2	240			Fourth Address Line
BUILDING	VARCHAR2	240			Specific building name or number ata given address
FLOOR_NUMBER	VARCHAR2	240			Specific floor number at a given address or a particular building when building number is provided.
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
USER_LAST_UPDATE_DATE	TIMESTAMP				Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
CPDRF_VER_SOR	NUMBER		9		Additional address element to support flexible address format
CPDRF_VER_PILLAR	NUMBER		9		Additional address element to support flexible address format
CPDRF_LAST_UPD	VARCHAR2	15			Additional address element to support flexible address format

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_LOCATION_LOCALES	hz_locations	LOCATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
HZ_LOCATION_LOCALES_PK	Unique	Default	LOCATION_LOCALE_ID
HZ_LOCATION_LOCALES_U1	Unique	Default	LOCATION_ID, TRANSLITERATION_LANG