CST_WO_DEPLETION_QTYS_GT
This GT table would be used for in-process layer creation related to work order transactions. This table will be populated with the depletion transactions (component return and product return) for which layers need to be created with a running count of depletion quantity ordered by transaction date.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WIP_DEP_TRXN_ID | NUMBER | 18 | Yes | Surrogate ID identifying the depletion transaction. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the Plant. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book associated to the cost organization. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation in costing. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the item recorded against the transaction. | |
| WIP_ITEM_TYPE | VARCHAR2 | 30 | Yes | Identifies the item use for this particular transaction. Possible values: COMPONENT/PRODUCT | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Indicates the transaction date as recorded in CST_TRANSACTIONS. | ||
| QUANTITY_REMAIN | NUMBER | Remaining quantity to be depleted. | |||
| CURR_RUNNING_DEPL_QTY | NUMBER | Total depletion quantity till this transaction. | |||
| PREV_RUNNING_DEPL_QTY | NUMBER | Total depletion quantity till the previous layer. |