CST_CURR_COST_ELEMENTS_GT

This table is a temporary table used by the perpetual cost engine to create the list of the currenct cost elements for a given transaction. This information is used to identify any potential missing cost elements in the cost_transaction_costs and as a result in the cst_perpavg_costs table.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Comments	Status
COST_ORG_ID	NUMBER		18	Indentifies the Cost Organization.	Active
COST_BOOK_ID	NUMBER		18	Indentifies the Cost Book.	Active
INVENTORY_ITEM_ID	NUMBER		18	Indentifies the Inventory Item.	Active
VAL_UNIT_ID	NUMBER		18	Indentifies the valuation unit.	Active
COST_ELEMENT_ID	NUMBER		18	Indentifies the cost element.	Active
EFF_DATE	TIMESTAMP			Effective date of the cost.	Active
TRANSACTION_ID	NUMBER			Indentifies the Transaction.	Active
CURRENCY_CODE	VARCHAR2	30		Indentifies the currency of the cost.	Active
COST_DATE	TIMESTAMP			Cost date of the transaction or adjustment	Active
BASE_TXN_TYPE_ID	NUMBER		18	Identifies the transaction tyoe of the cost.	Active
BASE_TXN_SOURCE_TYPE_ID	NUMBER		18	Identifies the transaction source type of the cost.	Active
BASE_TXN_ACTION_ID	NUMBER		18	Identifies the transaction action of the cost.	Active
EXPENSE_POOL_ID	NUMBER		18	Identifies the expense pool.
CST_INV_TRANSACTION_ID	NUMBER		18	Costing inventory transaction identifier.
ADJUSTMENT_TRANSACTION_ID	NUMBER		18	Adjustment transaction identifier.
USER_ADJUSTMENT_ID	NUMBER		18	User adjusment identifier.
PREV_EFF_DATE	TIMESTAMP			Effective date of the last cost record.

Indexes

Index	Uniqueness	Columns	Status
CST_CURR_ELM_GT_N1	Non Unique	COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, EFF_DATE, TRANSACTION_ID	Active
CST_CURR_ELM_GT_N2	Non Unique	TRANSACTION_ID	Active