CST_WO_OP_RUNNING_TOTALS_GT

This global temporary table is used to store the calculated cumulative costs for the work order operations.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
COST_ORG_ID	NUMBER		18	Surrogate ID identifying the cost organization.
COST_BOOK_ID	NUMBER		18	Surrogate ID identifying the cost book.
CST_WORK_ORDER_ID	NUMBER		18	Surrogate identifying a work order in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18	Surrogate Identifying a work order operation in costing.
OPERATION_SEQ_NUMBER	NUMBER			Sequence of operation on a work order.
PROCESSING_SEQ	NUMBER		18	Indicates the dense ranked sequence of processing.
COST_ELEMENT_ID	NUMBER		18	Surrogate identifying the cost element associated with the cost.
EXPENSE_POOL_ID	NUMBER		18	Surrogate identifying the expense pool associated with the cost.
INPUT_COST	NUMBER			Total input cost at the work order operation.
PRO_CUMULATIVE_COST	NUMBER			Cumulative cost at the work order operation prorated based on completion quantities.
TOT_CUMULATIVE_COST	NUMBER			Cumulative cost at the work order operation.
PRO_CARRY_FORWARD_COST	NUMBER			Carry forward cost to be taken to the next operation, prorated using the completion quantities.
TOT_CARRY_FORWARD_COST	NUMBER			Total carry forward cost to be taken to the next operation.
TOTAL_OP_PERCENTAGE	NUMBER			Total percentage of cumulative cost to be taken out for the outputs on the operation.
COMPLETED_QUANTITY	NUMBER			Total completed batch quantity on the operation.
SCRAP_QUANTITY	NUMBER			Total scrapped batch quantity on the operation.
PRO_COST_PER_BATCH	NUMBER			Per unit batch cost prorated using completion quantity.
TOT_COST_PER_BATCH	NUMBER			Total per unit batch cost till the current operation.
FIXED_OUTPUT_COST	NUMBER			Cost of fixed output on the operation.
CURRENCY_CODE	VARCHAR2	15		Indicate the currency in which costs are stored.
CONTAINS_OUTPUT_FLAG	VARCHAR2	1		Indicates if this operation has output items. Valid values are Y - Yes, Null - No and L - Last operation.
PRO_YIELD_COST	NUMBER			Yield cost at work order operation, prorated based on completion quantities.
TOT_YIELD_COST	NUMBER			Total yield cost at the work order operation.
PRO_CARRY_FORWARD_YIELD_COST	NUMBER			Carry forward operation yield cost to be taken to the next operation, prorated using the completion quantities.
TOT_CARRY_FORWARD_YIELD_COST	NUMBER			Total carry forward operation yield cost to be taken to the next operation.