1. Tables and Views for SCM
  2. CST_COT_TXNS_TO_PROC_GT

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 Status
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 OBSOLETE: Indicates the operation level total new scrap return quantity in current execution. Obsolete
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 OBSOLETE: Indicates the net operation completion quantity available in costing at the work order operation level. Obsolete
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.
SCRAP_TYPE VARCHAR2 50 Indicates type of scrap. Possible values are SCRAP and SCRAPESTIMATE.
NET_OP_SCRAP_EST_QTY NUMBER Indicates the net estimated scrap quantity available in costing at the work order operation level.
TOTAL_NEW_SCRAP_RETURN_QTY NUMBER Indicates the operation level total new scrap return quantity in current execution.
NET_OP_COMPLETE_QTY NUMBER Indicates the net operation completion quantity available in costing at the work order operation level.