CMF_I_FISCAL_DOC_EXCEPTIONS

Stores the Exceptions found in FISCAL Document data validation.

Details

• Schema: FUSION

• Object owner: CMF

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CMF_I_FISCAL_DOC_EXCEPTIO_PK	EFD_EXCEPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
EFD_EXCEPTION_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
EFD_INTERFACE_ENTITY_ID	NUMBER		18		Stores the foreign key which identifies the Child Entity row.	Active
EFD_INTERFACE_ENTITY_TYPE	VARCHAR2	30			Stores the child entity name identification.	Active
EFD_ERROR_CODE	VARCHAR2	80		Yes	Stores the error code found in the validations and derivations.
EFD_ERROR_DESCR	VARCHAR2	900			Stores the error description found in the validations and derivations.	Active
TOKEN1_NAME	VARCHAR2	30			Token name as required by error code message.
TOKEN1_VALUE	VARCHAR2	240			Token value as required by error code message.
TOKEN2_NAME	VARCHAR2	30			Token name as required by error code message.
TOKEN2_VALUE	VARCHAR2	240			Token value as required by error code message.
TOKEN3_NAME	VARCHAR2	30			Token name as required by error code message.
TOKEN3_VALUE	VARCHAR2	240			Token value as required by error code message.
TOKEN4_NAME	VARCHAR2	30			Token name as required by error code message.
TOKEN4_VALUE	VARCHAR2	240			Token value as required by error code message.
TOKEN5_NAME	VARCHAR2	30			Token name as required by error code message.
TOKEN5_VALUE	VARCHAR2	240			Token value as required by error code message.
TOKEN6_NAME	VARCHAR2	30			Token name as required by error code message.
TOKEN6_VALUE	VARCHAR2	240			Token value as required by error code message.
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

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CMF_I_FISCAL_DOC_EXCEPTIONS_U1	Unique	Default	EFD_EXCEPTION_ID	Active