CST_COSTED_INTR_TXN_ONHAND_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
TXN_SOURCE_REF_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_DOC_TYPE TRANSFER_TXN_ID TRANSACTION_FLOW_TYPE COST_ORG_ID COST_BOOK_ID INVENTORY_ORG_ID INVENTORY_ITEM_ID SNAPSHOT_DATE EFF_TO_DATE QUANTITY CMR_RCV_QUANTITY UOM_CODE EXPENSE_TRANSACTION_FLAG CONSIGNED_FLAG ACCOUNTED_FLAG |
問合せ
| SQL_Statement |
|---|
|
SELECT txn_source_ref_doc_number, txn_source_ref_doc_type, txn_source_doc_number, txn_source_doc_type, transfer_txn_id, transaction_flow_type, cost_org_id, cost_book_id, inventory_org_id, inventory_item_id, snapshot_date, eff_to_date, quantity, cmr_rcv_quantity, uom_code, expense_transaction_flag, consigned_flag, accounted_flag FROM cst_costed_intr_txn_onhand_mv |