CST_COSTED_INTR_TXN_COSTS_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 COST_ELEMENT_ID SNAPSHOT_DATE EFF_TO_DATE ONHAND_VALUE ACCTD_ONHAND_VALUE CURRENCY_CODE UOM_CODE COST_METHOD_CODE EXPENSE_TRANSACTION_FLAG CONSIGNED_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, cost_element_id, snapshot_date, eff_to_date, onhand_value, acctd_onhand_value, currency_code, uom_code, cost_method_code, expense_transaction_flag, consigned_flag FROM cst_costed_intr_txn_costs_mv |