CST_WO_ONHAND_GT
This GT table would be used for in-process layer creation related to work order transactions. This table will be loaded with running quantities for all wip receipt layers.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WIP_REC_TRXN_ID | NUMBER | 18 | Yes | Surrogate ID identifying the layer that gets depleted. | |
| 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 | Indicates if the layer is for component or end items. Possible values: COMPONENT/PRODUCT | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Indicates the transaction date as recorded in CST_TRANSACTIONS. | ||
| QUANTITY_ONHAND | NUMBER | Quantity remaining on this layer available for depletion. | |||
| UOM_CODE | VARCHAR2 | 3 | Costing Unit of measure of the transaction. | ||
| CURR_RUNNING_RCPT_QTY | NUMBER | Running total receipt quantity till the current row available for depletion. | |||
| PREV_RUNNING_RCPT_QTY | NUMBER | Running total receipt quantity till the previous row available for depletion. |