Oracle Fusion · Data dictionary
CMF_FISCAL_DOC_SCHEDULES
CostingUsed in 5 subject areas10 reporting columns
Source object in the Oracle Fusion data model.
Primary key: not yet catalogued for CMF_FISCAL_DOC_SCHEDULES, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATION_DATE | ● | Date and time the row was created. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| RECEIPT_NUM | ● | Receipt number. | |
| RECEIVED_QTY | ● | Received quantity. | |
| SCHEDULE_NUMBER | ● | Schedule number. | |
| SD_PRICE | ● | Sd price. | |
| SD_PRICE_CURRENCY | ● | Sd price currency. | |
| SD_UOM_CODE | ● | Code identifying the sd unit of measure. | |
| SOURCE_DOC_TYPE | ● | Type of source doc. | |
| USER_EXCHANGE_RATE | ● | User exchange rate. |
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.
- Costing - Cost Accounting Real Time
- Costing - Receipt Accounting Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
Need the extract + dbt staging for CMF_FISCAL_DOC_SCHEDULES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table