Gross Margin Details
The Gross Margin Details view object contains the cost of goods sold, revenue, and gross margin information for the internal sales transactions.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstGrossMarginDetailsExtractPVO
Primary Keys : CstGrossMarginDetailsPEOGrossMarginDetailId
Initial Extract Date : CstGrossMarginDetailsPEOCreationDate
Incremental Extract Date : CstGrossMarginDetailsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CstGrossMarginDetailsPEOCogsAccountId | The code combination identifier of the account entered by the user while creating the transactions. |
| CstGrossMarginDetailsPEOConfigInventoryItemId | The unique identifier of the configured item associated with the details. |
| CstGrossMarginDetailsPEOCostBookId | The unique identifier of the cost book associated with the cost organization. |
| CstGrossMarginDetailsPEOCostOrgId | The unique identifier of the cost organization associated with the inventory organization. |
| CstGrossMarginDetailsPEOCreatedBy | The user who created the gross margin detail row. |
| CstGrossMarginDetailsPEOCreationDate | The date when the gross margin detail row was created. |
| CstGrossMarginDetailsPEOCurrencyCode | The currency code associated with the details. |
| CstGrossMarginDetailsPEOCustomerId | The unique identifier of the bill to customer. |
| CstGrossMarginDetailsPEOCustomerType | The customer type indicating whether the customer is internal or external. A list of accepted values is defined in the lookup type CUSTOMER_TYPE. |
| CstGrossMarginDetailsPEODocLineId | The unique identifier of the fulfillment line associated with the details. This is used in gross margin calculation. |
| CstGrossMarginDetailsPEODooOrderNumber | The order number associated with the details. |
| CstGrossMarginDetailsPEODooOrderType | The type of the order associated with the details. A list of accepted values is defined in the lookup type ORA_CST_DOC_FLOW_TYPES. |
| CstGrossMarginDetailsPEOGlDate | The accounting date of the gross margin record in the general ledger. |
| CstGrossMarginDetailsPEOGrossMarginDetailId | The unique identifier of the gross margin detail. This is the primary key of the Gross Margin Details view object. |
| CstGrossMarginDetailsPEOInventoryItemId | The unique identifier of the item associated with the details. This is used in gross margin calculation. |
| CstGrossMarginDetailsPEOInventoryOrgId | The unique identifier of the inventory organization associated with the details. |
| CstGrossMarginDetailsPEOInvoiceId | The unique identifier of the invoice or the customer contract header. |
| CstGrossMarginDetailsPEOInvoiceLineId | The unique identifier of the invoice or the performance obligation line. |
| CstGrossMarginDetailsPEOInvoiceNumber | The invoice or the contract number associated with the details. |
| CstGrossMarginDetailsPEOInvoiceSource | The source of the invoice or contract associated with the details. Applicable values are: DOO - Distributed Order Orchestration, FOS or SFO - Supply Chain Financial Orchestration, and CST - Costing. |
| CstGrossMarginDetailsPEOItemOrganizationId | The unique identifier of the inventory organization associated with the item. |
| CstGrossMarginDetailsPEOLastUpdateDate | The date when the gross margin detail row was last updated. |
| CstGrossMarginDetailsPEOLastUpdateLogin | The session login associated with the user who last updated the gross margin detail row. |
| CstGrossMarginDetailsPEOLastUpdatedBy | The user who last updated the gross margin detail row. |
| CstGrossMarginDetailsPEOOrderTypeCode | The order type code associated with the details. The value is from the order management table DOO_HEADERS_ALL. |
| CstGrossMarginDetailsPEOProfitCenterBuId | The unique identifier of the profit center business unit associated with the cost organization. |
| CstGrossMarginDetailsPEORecognizedCogsAmount | The recognized COGS amount. |
| CstGrossMarginDetailsPEORecognizedCogsOverheadAmt | The recognized COGS overhead amount. |
| CstGrossMarginDetailsPEORecognizedCogsProfitAmt | The recognized COGS profit amount. |
| CstGrossMarginDetailsPEORecognizedCogsResourceAmt | The recognized COGS resource amount. |
| CstGrossMarginDetailsPEORecognizedGrossMargin | The recognized gross margin amount. |
| CstGrossMarginDetailsPEORecognizedRev | The recognized revenue amount. |
| CstGrossMarginDetailsPEORevenueRecognitionSrc | The revenue source, which can be Receivables or Revenue Management. A list of accepted values is defined in the lookup type ORA_CST_REV_RECOGNITION_SRC. |
| CstGrossMarginDetailsPEORootInventoryItemId | The unique identifier of the root or model item in the case of complex flows involving KIT, PTO, or ATO. |
| CstGrossMarginDetailsPEOShipToCustomerId | The unique identifier of the ship to customer. |
| CstGrossMarginDetailsPEOShipmentNumber | The number of the source document associated with the details. |
| CstGrossMarginDetailsPEOShipmentType | The type of the source document associated with the details. A list of accepted values is defined in the lookup type ORA_CST_DOC_FLOW_TYPES. |
| CstGrossMarginDetailsPEOSuccessorBuId | The unique identifier of the successor business unit for the financial orchestration flow. |
| CstGrossMarginDetailsPEOUnrecognizedCogsAmount | The unrecognized COGS amount. |
| CstGrossMarginDetailsPEOUnrecognizedCogsOverheadAmt | The unrecognized COGS overhead amount. |
| CstGrossMarginDetailsPEOUnrecognizedCogsProfitAmt | The unrecognized COGS profit amount. |
| CstGrossMarginDetailsPEOUnrecognizedCogsResourceAmt | The unrecognized COGS resource amount. |
| CstGrossMarginDetailsPEOUnrecognizedGrossMargin | The unrecognized gross margin amount. |
| CstGrossMarginDetailsPEOUnrecognizedRev | The unrecognized revenue amount. |