CST_WO_RESOURCE_TXN_STATUS_GT

This transaction GT table will be used to explode the resource transactions received from manufacturing for each book.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Precision Comments
CST_WO_RESOURCE_TXN_ID NUMBER 18 Surrogate ID identifying the resource transaction 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.