Oracle Fusion · Data dictionary
CMF_FISCAL_DOC_LINES_VL
CostingUsed in 5 subject areas18 reporting columns
view layer, joins the base table with translations for the current language.
Primary key: not declared here, see Oracle's Tables and Views page for CMF_FISCAL_DOC_LINES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATION_DATE | ● | Date and time the row was created. | |
| EFD_ITEM_CODE | ● | Code identifying the efd item. | |
| EFD_ITEM_DESCRIPTION | ● | Description of the efd item. | |
| EFD_PROD_ADD_INFO | ● | Efd prod add info. | |
| FCI_CONTROL_NUMBER | ● | Fci control number. | |
| FD_AMOUNT | ● | Fd amount. | |
| FD_PRICE | ● | Fd price. | |
| FD_QUANTITY | ● | Fd quantity. | |
| FD_UOM | ● | Fd unit of measure. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_NUMBER | ● | Line number. | |
| LINE_STATUS | ● | Status of the line. | |
| LINE_TYPE | ● | Type of line. | |
| PHYSICAL_RECEIPT_DATE | ● | Physical receipt date. | |
| PHYSICAL_RECEIPT_QUANTITY | ● | Physical receipt quantity. | |
| PHYSICAL_RECEIPT_UOM | ● | Physical receipt unit of measure. | |
| SOURCE_DOCUMENT_TYPE | ● | Type of source document. |
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.
- Costing - Cost Accounting Real Time
- Costing - Fiscal Document Capture Transactions Real Time
- Costing - Fiscal Document Holds Real Time
- Costing - Fiscal Document Item Deliveries Real Time
- Costing - Receipt Accounting Real Time
Need the extract + dbt staging for CMF_FISCAL_DOC_LINES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table