CST_RECEIPTS_GT

Receipts Available to Deplete - quantity onhand

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

Primary Key

Name Columns

CST_RECEIPTS_GT_PK

REC_TRXN_ID

Columns

Name

REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.Active

REC_TRXN_IDNUMBER18YesReceipt 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

VAL_UNIT_IDNUMBER18Valuation unit identifierActive

INVENTORY_ITEM_IDNUMBER18YesInventory Item IdentifierActive

COST_DATETIMESTAMPTransaciton Cost DateActive

QUANTITY_ONHANDNUMBERQuantity Onhand To DepleteActive

Indexes

Index Uniqueness Columns
CST_RECEIPTS_GT_U1 Unique REC_TRXN_ID