CST_REVENUE_DETAILS_GT

This temporary table is used for the gross margin calculations.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
DOC_LINE_ID	NUMBER		18	Fullfillment or orchestration line identifier from the revenue details.
GL_DATE	DATE			General Ledger date of the revenue details.
PROFIT_CENTER_BU_ID	NUMBER		18	Identifies the Profit Center Business Unit associated to the Cost Organization.
COST_ORG_ID	NUMBER		18	Identifies the Cost Organization associated with the Inventory Organization.
COST_BOOK_ID	NUMBER		18	Identifies the Cost Book assigned to the Cost Organization.
CURRENCY_CODE	VARCHAR2	30		Base Currency Code of the Cost Organization.
INVENTORY_ORG_ID	NUMBER		18	Identifies the Inventory Organization associated to the details.
ITEM_ORGANIZATION_ID	NUMBER		18	Identifies the Inventory Organization associated to the Item.
INVENTORY_ITEM_ID	NUMBER		18	Identifies the Item associated to the details.
CONFIG_INVENTORY_ITEM_ID	NUMBER		18	Identifies the Configured Item that is associated to the details.
ROOT_INVENTORY_ITEM_ID	NUMBER		18	In case of assembled or picked to order, identifies the root Item.
TXN_INVENTORY_ITEM_ID	NUMBER		18	Identifies the Item on the transaction. Note that this can be different from the Item used in the gross margin calculations for complex flows.
CATEGORY_ID	NUMBER		18	Costing Category associated to the Item.
SHIPMENT_NUMBER	VARCHAR2	240		Shipment number associated to the details.
SHIPMENT_TYPE	VARCHAR2	50		Type of the Shipment associated to the details.
DOO_ORDER_NUMBER	VARCHAR2	240		Order number associated to the details.
DOO_ORDER_TYPE	VARCHAR2	50		Type of the Order. Possible values are SO/OO: Sales Order, RMA: RMA Order , TO: Transfer Order, IOT: Interorganization Transfer Order, etc.
INVOICE_SOURCE	VARCHAR2	30		Source of the Invoice. Possible values are DOO: Distributed Order Orchestration, FOS/SFO: Supply Chain Financial Orchestration, CST: Costing.
INVOICE_NUMBER	VARCHAR2	20		Invoice number associated to the details.
INVOICE_ID	NUMBER		18	Identifies the Invoice associated to the details.
INVOICE_LINE_ID	NUMBER		18	Identifies the Invoice line associated to the details.
REVENUE_RECOGNITION_SRC	VARCHAR2	60		Indicates if the revenue source is Receivables or Revenue Management.
CUSTOMER_ID	NUMBER		18	Identifies the bill to Customer associated to the details.
SHIP_TO_CUSTOMER_ID	NUMBER		18	Identifies the ship to Customer associated to the details.
ORDER_TYPE_CODE	VARCHAR2	30		Sales order type.
CUSTOMER_TYPE	VARCHAR2	1		Indicates if the Customer is internal or external.
SUCCESSOR_BU_ID	NUMBER		18	Identifies the successor Business Unit for financial orchestration flow.
RECOGNIZED_REV	NUMBER			Recognized revenue amount.
RECOGNIZED_COGS_AMOUNT	NUMBER			Recognized cost of goods sold amount.
RECOGNIZED_GROSS_MARGIN	NUMBER			Recognized gross margin amount.
UNRECOGNIZED_REV	NUMBER			Unrecognized revenue amount.
UNRECOGNIZED_COGS_AMOUNT	NUMBER			Unrecognized cost of goods sold amount.
UNRECOGNIZED_GROSS_MARGIN	NUMBER			Unrecognized gross margin amount.
RECOGNIZED_COGS_PROFIT_AMT	NUMBER			Recognized cost of goods sold profit part of the total amount.
UNRECOGNIZED_COGS_PROFIT_AMT	NUMBER			Unrecognized cost of goods sold profit part of the total amount.
RECOGNIZED_COGS_OVERHEAD_AMT	NUMBER			Recognized cost of goods sold overhead part of the total amount.
UNRECOGNIZED_COGS_OVERHEAD_AMT	NUMBER			Unrecognized cost of goods sold overhead part of the total amount.
RECOGNIZED_COGS_RESOURCE_AMT	NUMBER			Recognized cost of goods sold resource part of the total amount.
UNRECOGNIZED_COGS_RESOURCE_AMT	NUMBER			Unrecognized cost of goods sold resource part of the total amount.
COGS_ACCOUNT_ID	NUMBER		18	General Ledger account that contains the COGS amount.
REVENUE_LINE_ID	NUMBER		18	Identifies the revenue line.