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