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.
COMPLEMENTARY_FLAG	VARCHAR2	1			It defines whether the current FD is a Complementary FD (Tax, Price, or Quantity) or not.
IFACE_RCV_FLAG	VARCHAR2	1			If "Y", allows the Receiving Interface for the current FD.
CHARGES_DISTRIBUTION_FLAG	VARCHAR2	1			Determines the behaviour of the charges allocation UI.
FD_USAGE	VARCHAR2	30			Fiscal document usage will be like material or freight.
IFACE_AP_FLAG	VARCHAR2	1			If "Y", allows the Payables Interface for the current FD.

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