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 |