CST_COT_TXNS_TO_PROC_GT

This transaction temporary table will be used to hold the operation transactions that are identified to be processed in the current cost processor execution.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
OPERATION_TRANSACTION_ID	NUMBER		18		Surrogate ID identifying the operation transaction in costing.
COST_ORG_ID	NUMBER		18		Surrogate ID identifying the cost organization associated to the plant where the work order is executed.
COST_BOOK_ID	NUMBER		18		Surrogate ID identifying the cost book associated to the cost organization.
CST_WORK_ORDER_ID	NUMBER		18		Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18		Surrogate ID identifying the work order operation in costing.
COST_DATE	TIMESTAMP				Indicates the date and time slotted for sequencing this transaction.
PERIOD_NAME	VARCHAR2	15			Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
OPERATION_SEQ_NUMBER	NUMBER				Indicates a number that identifies the operation sequence within this work order.
QUANTITY	NUMBER				Operation transaction quantity.
UOM_CODE	VARCHAR2	3			Primary unit of measure for the quantity.
OPERATION_SCRAP_COST_TYPE	VARCHAR2	30			Cost profile option indicating whether the scrap cost is to be Included in inventory or Expensed.
OPERATION_ADJ_TXN_ID	NUMBER		18		Surrogate ID indicating the adjustment transaction.
WO_CLOSED_FLAG	VARCHAR2	1		Yes	This flag indicates if the corresponding work order is closed. This is then used to derive the costs appropriately.
PROCESSING_SEQ_NUMBER	NUMBER				Processing rank established within the process.
TOTAL_NEW_SCRAP_QTY	NUMBER				Indicates the operation level total new scrap quantity in current execution.
TOTAL_NEW_SCRAP_RET_QTY	VARCHAR2	20			Indicates the operation level total new scrap return quantity in current execution.
NET_OP_SCRAP_QTY	NUMBER				Indicates the net scrap quantity available in costing at the work order operation level.
NET_OP_COMPL_QTY	VARCHAR2	20			Indicates the net operation completion quantity available in costing at the work order operation level.
ERROR_MESSAGE_NAME	VARCHAR2	30			Identifies the error message in case the transaction is in error.
COST_ELEMENT_ID	NUMBER		18		Cost element identifier, populated for work orders with no input components or resources.
COST_PROFILE_ID	NUMBER		18		Cost profile identifier of the end item of work order.