CST_RUNNING_DEPLETIONS_GT
Remaining Quantity to Deplete - quantity that needs depletions
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REC_TRXN_ID | NUMBER | 18 | Yes | Receipt Transaction Identifier. | |
| DEP_TRXN_ID | NUMBER | 18 | Yes | Deplete Transaction Identifier. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| INVENTORY_ORG_ID | NUMBER | Inventory Organization of deplete/receipt transaction. | |||
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier. | |
| COST_DATE | TIMESTAMP | Transaction Cost Date. | |||
| RCPT_DATE | TIMESTAMP | Transaction Receipt Date. | |||
| RUNNING_DEPL_QTY | NUMBER | Running depletion quantity of this transaction. | |||
| ISSUE_QTY | NUMBER | Issued Quantity of this transaction. | |||
| REC_ONHAND_AVAIL_FLAG | VARCHAR2 | 1 | Indicates if the receipt has onhand available so that it can be used for depletion. | ||
| REC_ONHAND | NUMBER | Receipt available Onhand quantity prior to the depletions in this table. |