CST_DEPLETIONS_GT
Deplete Remaining Quantity: Qty that still needs depleting
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_DEPLETIONS_GT_PK |
DEP_TRXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | ||
| DEP_TRXN_ID | NUMBER | 18 | Yes | Deplete Transaction Identifyer | Active | |
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | Active | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | Active | |
| INVENTORY_ORG_ID | NUMBER | Not used in depletions anymore. | ||||
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier | Active | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier | Active | |
| COST_DATE | TIMESTAMP | Transaciton Cost Date | Active | |||
| QUANTITY_REMAIN | NUMBER | Quantity Remining To Deplete | Active | |||
| REVERSAL_EXISTS_FLAG | VARCHAR2 | 4 | Possible values are Y, N and null. Y indicates that a negative inventory reversal layer exists. N indicates that a negative inventory reversal layer does not exist. Null indicates record is not for negative layer. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_DEPLETIONS_GT_U1 | Unique | DEP_TRXN_ID |