Oracle Fusion · Data dictionary
CST_GROSS_MARGIN_DETAILS
CostingUsed in 1 subject areas20 reporting columns
Cost Management (CST), detail-level data.
Primary key: not yet catalogued for CST_GROSS_MARGIN_DETAILS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CUSTOMER_TYPE | ● | Type of customer. | |
| DOC_LINE_ID | ● | Identifier for the doc line. | |
| DOO_ORDER_NUMBER | ● | Doo order number. | |
| GL_DATE | ● | General ledger date. | |
| INVOICE_NUMBER | ● | Invoice number. | |
| ORDER_TYPE_CODE | ● | Code identifying the order type. | |
| RECOGNIZED_COGS_AMOUNT | ● | Recognized cogs amount. | |
| RECOGNIZED_COGS_OVERHEAD_AMT | ● | Recognized cogs overhead amount. | |
| RECOGNIZED_COGS_PROFIT_AMT | ● | Recognized cogs profit amount. | |
| RECOGNIZED_COGS_RESOURCE_AMT | ● | Recognized cogs resource amount. | |
| RECOGNIZED_REV | ● | Recognized rev. | |
| REVENUE_RECOGNITION_SRC | ● | Revenue recognition src. | |
| SHIPMENT_NUMBER | ● | Shipment number. | |
| SHIPMENT_TYPE | ● | Type of shipment. | |
| UNRECOGNIZED_COGS_AMOUNT | ● | Unrecognized cogs amount. | |
| UNRECOGNIZED_COGS_OVERHEAD_AMT | ● | Unrecognized cogs overhead amount. | |
| UNRECOGNIZED_COGS_PROFIT_AMT | ● | Unrecognized cogs profit amount. | |
| UNRECOGNIZED_COGS_RESOURCE_AMT | ● | Unrecognized cogs resource amount. | |
| UNRECOGNIZED_REV | ● | Unrecognized rev. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for CST_GROSS_MARGIN_DETAILS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table