CMF_I_FISCAL_DOC_REF

Details

Schema: FUSION
Object owner: CMF
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CMF_I_FISCAL_DOC_REF_ATTR_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	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

Foreign Keys

Table	Foreign Table	Foreign Key Column
CMF_I_FISCAL_DOC_REF_ATTR	cmf_i_fiscal_doc_headers	EFD_INTERFACE_HEADER_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CMF_I_FISCAL_DOC_REF_ATTR_F1	Non Unique	FUSION_TS_TX_DATA	EFD_INTERFACE_HEADER_ID	Active
CMF_I_FISCAL_DOC_REF_ATTR_U1	Unique	FUSION_TS_TX_DATA	EFD_INTERFACE_REF_ID