CST_REMAINING_DEPL_QTY_GT
Remaining Quantity to Deplete - quantity that needs depletions
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
CST_REMAINING_DEPL_QTY_GT_PK |
DEP_TRXN_ID |
Columns
| Name |
|---|
|
REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.Active DEP_TRXN_IDNUMBER18YesDeplete Transaction IdentifyerActive COST_ORG_IDNUMBER18YesSingle column FK: Identifies the Cost Organization associated with the inventory organization.Active COST_BOOK_IDNUMBER18YesSingle column FK: Identifies the Cost Book assigned to the Cost Organization.Active INVENTORY_ITEM_IDNUMBER18YesInventory Item IdentifierActive VAL_UNIT_IDNUMBER18YesValuation unit identifierActive COST_DATETIMESTAMPTransaciton Cost DateActive ORIG_QUANTITYNUMBEROriginal Depletion QuantityActive QUANTITY_DEPLETEDNUMBERPrevious Depleted QuanityActive QUANTITY_REMAINNUMBERQuantity Remining To DepleteActive |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_REMAINING_DEP_QTY_GT_U1 | Unique | DEP_TRXN_ID |