CMF_I_FD_REF_ATTR_GT

Stores the FISCAL Document referenced documents.

Details

• Schema: FUSION

• Object owner: CMF

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CMF_I_FD_REF_ATTR_GT_PK	EFD_INTERFACE_REF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
EFD_INTERFACE_REF_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_REF_ATTR_ID	NUMBER		18		Identifier of referenced attributes of the document.	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
REF_ACCESS_KEY_NUMBER	VARCHAR2	64			Access Key Number of referenced document.	Active
REF_DOCUMENT_NUMBER	NUMBER		9		Stores the Number of Referenced Document.	Active
REF_SERIES	NUMBER		9		Stores the Series of Referenced Document.	Active
REF_ISSUE_DATE	TIMESTAMP				Issue Date of referenced document.	Active
REF_MODEL	VARCHAR2	64			Stores the Model of Referenced Document.	Active
REF_ISSUER_TAXPAYER_ID	NUMBER		18		Taxpayer Id of referenced issuer.	Active
REF_ISSUER_STATE	VARCHAR2	2			State of referenced document Issuer.	Active
VALIDATION_STATUS	VARCHAR2	30			Stores the Status of the validation results of the current entity.	Active

Indexes

Index	Uniqueness	Columns	Status
CMF_I_FD_REF_ATTR_GT_N1	Non Unique	EFD_INTERFACE_HEADER_ID	Active
CMF_I_FD_REF_ATTR_GT_U1	Unique	EFD_INTERFACE_REF_ID	Active