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. You can't join across them in OTBI, the owned conformed model joins them on shared 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