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.
Likely primary key: FISCAL_DOC_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): FISCAL_DOC_HEADER_ID → CMF_FISCAL_DOC_HEADERS
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. | |
| FISCAL_DOC_HEADER_ID | PK? | ○ | Identifier for the fiscal doc header. |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_NUMBER | PK? | ● | 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. 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_LINES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table