Oracle Fusion · Data dictionary
CST_REVENUE_LINES
CostingUsed in 1 subject areas14 reporting columns
Cost Management (CST) — line table — one row per line item under the header.
Likely primary key: REVENUE_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_AMOUNT | ● | Acctd amount. | |
| DOCUMENT_TYPE | ● | Type of document. | |
| DOO_FULFILL_LINE_ID | ● | Identifier for the doo fulfill line. | |
| DOO_ORDER_NUMBER | ● | Doo order number. | |
| DOO_ORDER_TYPE | ● | Type of doo order. | |
| EXTENDED_AMOUNT | ● | Extended amount. | |
| INVOICE_DATE | ● | Invoice date. | |
| INVOICE_LINE_AMOUNT | ● | Invoice line amount. | |
| INVOICE_NUMBER | ● | Invoice number. | |
| INVOICE_SOURCE | ● | Invoice source. | |
| LINE_NUMBER | PK? | ○ | Line number. |
| QUANTITY_INVOICED | ● | Quantity invoiced. | |
| REVENUE_AMOUNT | ● | Revenue amount. | |
| REVENUE_HEADER_ID | PK? | ○ | Identifier for the revenue header. |
| REVENUE_PERCENTAGE | ● | Revenue percentage. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
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_REVENUE_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.