CST_WO_UPDATE_EVENT_STATUS_GT

This transaction GT table will be used to explode the work order close transactions received from manufacturing for each book. This is in line with the current model where the explosion of transactions and creation of actual transactions is separated.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Precision Comments
CST_WO_UPDATE_EVENT_ID NUMBER 18 Surrogate ID identifying the work order status update in costing.
COST_ORG_ID NUMBER 18 Surrogate ID identifying the cost organization associated to the plant where the resource was consumed.
COST_BOOK_ID NUMBER 18 Surrogate ID identifying the cost book.
TRANSACTION_DATE TIMESTAMP Date and time when the resource was consumed.