CST_WO_RUNTOTAL_INPUT_GT

This table is used to the store the work orders to be passed as input to the work order running cost calculator program.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
COST_ORG_ID NUMBER 18 Yes Cost Organization Identifier.
COST_BOOK_ID NUMBER 18 Yes Cost Book Identifier.
CST_WORK_ORDER_ID NUMBER 18 Yes Surrogate identifying a work order in cost accounting.
MAX_OP_SEQ_NUM NUMBER Yes Operation sequence until which the costs need to be calculated.
CUTOFF_DATE TIMESTAMP Date until which the transaction need to be considered.
WO_CLOSED_FLAG VARCHAR2 1 Indicates if the work order totals are to be calculated from a closed WO perspective. Valid values are Y, N and NULL.
CYCLIC_WORK_ORDER_FLAG VARCHAR2 1 A flag that indicates whether the work order have same item as component and product for a non rework work order. Possible values are: NULL : Non cyclic work order, Y : Cyclic work order.