CST_COGS_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	Not-null	Comments
DOC_LINE_ID	NUMBER		18		Fullfillment or orchestration line identifier from the cost of goods sold details.
GL_DATE	DATE				General Ledger date of the cost of goods sold details.
PROFIT_CENTER_BU_ID	NUMBER		18		Identifies the Profit Center Business Unit associated to the Cost Organization.
COST_ORG_ID	NUMBER		18	Yes	Identifies the Cost Organization associated with the Inventory Organization.
COST_BOOK_ID	NUMBER		18	Yes	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.