CMF_FD_TO_PROCESS_GT

Stores Temporary data to be processed by the Tolerance and Tax Validations.

Details

• Schema: FUSION

• Object owner: CMF

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CMF_FD_TO_PROCESS_GT_PK	FD_TO_PROCESS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
FD_TO_PROCESS_ID	NUMBER		18	Yes	Stores the Unique key which identifies the row.	Active
DOCUMENT_HEADER_ID	NUMBER		18	Yes	Stores the foreign key which identifies the fiscal document header row.	Active
HEADER_HOLD_ID	NUMBER		18		Stores the Hold Id identified by the Tolerance Validations process.	Active
FISCAL_PROC_OPTIONS_ID	NUMBER		18		Stores the identifier for Fiscal process options.
PROCESS_OPTION_CODE	VARCHAR2	50			Stores the code using which the fiscal flow of a document can be identified. e.g. ST for Standard flow, FT_ACQ for Freight Acquisition.
SOURCE_DOCUMENT_TYPE_CODE	VARCHAR2	30			Stores the type of source document a fiscal flow can refer to. e.g. PURCHASE_ORDER, NO_SOURCE.

Indexes

Index	Uniqueness	Columns	Status
CMF_FD_TO_PROCESS_GT_N1	Non Unique	DOCUMENT_HEADER_ID	Active
CMF_FD_TO_PROCESS_GT_U1	Unique	FD_TO_PROCESS_ID