CST_PAC_WO_INPUT_COSTS_GT

This transaction global temporary table will be used by PAC Processor to store the cost information of work orders input transactions that are processed in the current period.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MAX_TRANSACTION_ID	NUMBER		18	Yes	Maximum transaction identifier for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type.
COST_ORG_ID	NUMBER		18		Identifies the cost organization associated with the inventory organization.
COST_BOOK_ID	NUMBER		18		Identifies the cost book assigned to the cost organization.
INVENTORY_ITEM_ID	NUMBER		18		Identifier for the inventory item.
VAL_UNIT_ID	NUMBER		18		Identifier for the valuation unit.
PERIOD_NAME	VARCHAR2	15			Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
CST_WORK_ORDER_ID	NUMBER		18		Surrogate identifying a work order uniquely in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18		Surrogate identifying a work order operation associated with the transaction in costing.
QUANTITY	NUMBER				Sum of quantity for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type.
COST_ELEMENT_ID	NUMBER		18		Unique identifier for the cost element.
EXPENSE_POOL_ID	NUMBER		18		Unique identifier for the expense pool.
UNIT_COST	NUMBER				Indicates the unit cost of the cost element.