XLE_CONTACT_LEGAL_ROLES

XLE_CONTACT_LEGAL_ROLES contains the legal roles that a contact can have.

Details

• Schema: FUSION

• Object owner: XLE

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
XLE_CONTACT_LEGAL_ROLES_PK	CONTACT_ROLE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONTACT_ROLE_ID	NUMBER		18	Yes	Contact role identifier. Primary key generated from sequence.
CONTACT_PARTY_ID	NUMBER		18	Yes	Contact party identifier. Foreign key from HZ_PARTIES for the contact person.
LE_ETB_PARTY_ID	NUMBER		18	Yes	Legal entity or establishment party identifier. Foreign key from HZ_PARTIES for the legal entity or establishment.
SOURCE_TABLE	VARCHAR2	30			Source table name for the information, either XLE_ENTITY_PROFILES or XLE_ETB_PROFILES.
SOURCE_ID	NUMBER		18		Source identifier, identifier for the registered legal entity or establishment.
LOOKUP_TYPE	VARCHAR2	30			Lookup type for the data being stored in this table. The lookup type is XLE_CONTACT_ROLE.
LOOKUP_CODE	VARCHAR2	30			Legal role name. Lookup code from lookup type XLE_CONTACT_ROLE.
EFFECTIVE_FROM	DATE				Date on which a task, event or business process begins. Use for date enabled entities for which histories are not stored.
EFFECTIVE_TO	DATE				Date that a task, event, or business process ends. Use for date enabled entities that histories are not stored for.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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.
ENTERPRISE_ID	NUMBER		18		Enterprise or business group identifier.

Foreign Keys

Table	Foreign Table	Foreign Key Column
XLE_CONTACT_LEGAL_ROLES	hz_parties	CONTACT_PARTY_ID
XLE_CONTACT_LEGAL_ROLES	hz_parties	LE_ETB_PARTY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
XLE_CONTACT_LEGAL_ROLES_N1	Non Unique	Default	LE_ETB_PARTY_ID
XLE_CONTACT_LEGAL_ROLES_N2	Non Unique	Default	SOURCE_TABLE, SOURCE_ID
XLE_CONTACT_LEGAL_ROLES_U1	Unique	Default	CONTACT_ROLE_ID