CMF_I_LEGAL_DOC_ASSOC

Stores data related to the FISCAL Document Associated Legal Documents.

Details

• Schema: FUSION

• Object owner: CMF

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CMF_I_LEGAL_DOC_ASSOC_PK	EFD_INTERFACE_LEGAL_PROC_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
EFD_INTERFACE_LEGAL_PROC_ID	NUMBER		18	Yes	Stores the Unique key which identifies the row.	Active
EFD_INTERFACE_HEADER_ID	NUMBER		18		Stores the foreign key which identifies the Interface FD Header row.	Active
DOCUMENT_LEGAL_DOC_ASSOC	NUMBER		18		Stores the Associated Legal Document Identification.	Active
DOCUMENT_HEADER_ID	NUMBER		18		Stores the foreign key which identifies the FD Header row.	Active
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.	Active
LEGAL_PROCESS_ACT_IDENTIFIER	VARCHAR2	60			Identifier of legal process act	Active
LEGAL_PROC_PROCEEDING_ORIG	VARCHAR2	1			Proceeding origin of legal process	Active
VALIDATION_STATUS	VARCHAR2	10			Stores the Status of the validation results of the current entity.	Active
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	240			Is used for backend processing based on the interface records.	Active
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30			Is used for backend processing based on the interface records.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
DOCUMENT_LEGAL_DOC_ASSOC_ID	NUMBER		18		Identifier of associated legal document.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMF_I_LEGAL_DOC_ASSOC	cmf_i_fiscal_doc_headers	EFD_INTERFACE_HEADER_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CMF_I_LEGAL_DOC_ASSOC_F1	Non Unique	FUSION_TS_TX_DATA	EFD_INTERFACE_HEADER_ID	Active
CMF_I_LEGAL_DOC_ASSOC_U1	Unique	FUSION_TS_TX_DATA	EFD_INTERFACE_LEGAL_PROC_ID	Active