機械翻訳について

CST_GROSS_MARGIN_DETAILS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CST

• オブジェクト・タイプ: VIEW

列

名前

DOC_LINE_ID GL_DATE PROFIT_CENTER_BU_ID BU_NAME COST_ORG_ID COST_ORG_NAME COST_BOOK_ID COST_BOOK_CODE CURRENCY_CODE EXTENDED_PRECISION PRECISION CURRENCY_NAME INVENTORY_ORG_ID INV_ORG_NAME ITEM_ORGANIZATION_ID INVENTORY_ITEM_ID ITEM_NUMBER CONFIG_INVENTORY_ITEM_ID CONFIG_ITEM_NUMBER ROOT_INVENTORY_ITEM_ID ROOT_ITEM_NUMBER CATEGORY_ID CATEGORY_NAME SHIPMENT_NUMBER SHIPMENT_TYPE DOO_ORDER_NUMBER DOO_ORDER_TYPE ORDER_TYPE_CODE INVOICE_SOURCE INVOICE_NUMBER INVOICE_ID INVOICE_LINE_ID REVENUE_RECOGNITION_SRC CUSTOMER_ID CUSTOMER_NAME CUSTOMER_TYPE SHIP_TO_CUSTOMER_ID SUCCESSOR_BU_NAME SUCCESSOR_BU_ID RECOGNIZED_REV RECOGNIZED_COGS_AMOUNT RECOGNIZED_GROSS_MARGIN RECOGNIZED_COGS_PROFIT_AMT RECOGNIZED_COGS_OVERHEAD_AMT RECOGNIZED_COGS_RESOURCE_AMT UNRECOGNIZED_REV UNRECOGNIZED_COGS_AMOUNT UNRECOGNIZED_GROSS_MARGIN UNRECOGNIZED_COGS_PROFIT_AMT UNRECOGNIZED_COGS_OVERHEAD_AMT UNRECOGNIZED_COGS_RESOURCE_AMT COGS_ACCOUNT_ID

問合せ

SQL_Statement

SELECT doc_line_id, gl_date, profit_center_bu_id, bu_name, cost_org_id, cost_org_name, cost_book_id, cost_book_code, currency_code, extended_precision, precision, currency_name, inventory_org_id, inv_org_name, item_organization_id, inventory_item_id, item_number, config_inventory_item_id, config_item_number, root_inventory_item_id, root_item_number, category_id, category_name, shipment_number, shipment_type, doo_order_number, doo_order_type, order_type_code, invoice_source, invoice_number, invoice_id, invoice_line_id, revenue_recognition_src, customer_id, customer_name, customer_type, ship_to_customer_id, successor_bu_name, successor_bu_id, recognized_rev, recognized_cogs_amount, recognized_gross_margin, recognized_cogs_profit_amt, recognized_cogs_overhead_amt, recognized_cogs_resource_amt, unrecognized_rev, unrecognized_cogs_amount, unrecognized_gross_margin, unrecognized_cogs_profit_amt, unrecognized_cogs_overhead_amt, unrecognized_cogs_resource_amt, cogs_account_id FROM cst_gross_margin_details_mv