Oracle Fusion · Data dictionary
CMF_FD_LINES_INT
CostingUsed in 1 subject areas21 reporting columns
Source object in the Oracle Fusion data model.
Likely primary key: FD_LINES_INT_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CHARGES_AMOUNT | ● | Charges amount. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DISCOUNT_LINE_AMOUNT | ● | Discount line amount. | |
| FD_LINES_INT_ID | PK? | ● | Identifier for the fd lines int. |
| FREIGHT_LINE_AMOUNT | ● | Freight line amount. | |
| FREIGHT_MODAL | ● | Freight modal. | |
| INSURANCE_LINE_AMOUNT | ● | Insurance line amount. | |
| ITEM_CODE | ● | Code identifying the item. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_AMOUNT | ● | Line amount. | |
| LINE_NUMBER | ● | Line number. | |
| LINE_TYPE | ● | Type of line. | |
| OTHER_EXPENSES_LINE_AMOUNT | ● | Other expenses line amount. | |
| QUANTITY | ● | Quantity. | |
| SOURCE_CURRENCY_CODE | ● | Currency code for the source. | |
| SOURCE_DOCUMENT_LINE | ● | Source document line. | |
| SOURCE_DOCUMENT_NUMBER | ● | Source document number. | |
| SOURCE_DOCUMENT_TYPE | ● | Type of source document. | |
| UNIT_PRICE | ● | Unit price. | |
| VALIDATION_STATUS | ● | Status of the validation. |
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.
Need the extract + dbt staging for CMF_FD_LINES_INT?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table