Oracle Fusion · Data dictionary
DOO_ORDER_CHARGES
SharedUsed in 1 subject areas15 reporting columns
Order Management (DOO).
Primary key: not yet catalogued for DOO_ORDER_CHARGES — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AVG_UNIT_SELLING_PRICE | ● | Avg unit selling price. | |
| BLOCK_ALLOWANCE | ● | Block allowance. | |
| BLOCK_SIZE | ● | Block size. | |
| CHARGE_APPLIES_TO | ● | Charge applies to. | |
| CHARGE_SUBTYPE_CODE | ● | Code identifying the charge subtype. | |
| CHARGE_TYPE_CODE | ● | Code identifying the charge type. | |
| PRICED_QUANTITY | ● | Priced quantity. | |
| PRICE_PERIODICITY_CODE | ● | Code identifying the price periodicity. | |
| PRICE_TYPE_CODE | ● | Code identifying the price type. | |
| PRIMARY_FLAG | ● | Indicator (Y/N) for the primary. | |
| ROLLUP_FLAG | ● | Indicator (Y/N) for the rollup. | |
| SEQUENCE_NUMBER | ● | Sequence number. | |
| TIERED_FLAG | ● | Indicator (Y/N) for the tiered. | |
| TIER_APPLIES_TO | ● | Tier applies to. | |
| USAGE_PRICE_LOCK_FLAG | ● | Indicator (Y/N) for the usage price lock. |
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 DOO_ORDER_CHARGES?
We ship parameterized SQL, BICC config, and dbt models you own.