CST_RECEIPTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE TRANSACTION_ID TRANSFER_CST_INV_TXN_ID INTRANSIT_FLAG

Query

SQL_Statement
select CT.COST_ORG_ID ,CT.COST_BOOK_ID ,CT.INVENTORY_ITEM_ID ,CT.VAL_UNIT_ID ,CT.COST_DATE ,CT.TRANSACTION_ID ,CT.TRANSFER_CST_INV_TXN_ID ,CT.INTRANSIT_FLAG from cst_transactions ct where ct.cost_transaction_type = 'RECEIPT'