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. You can't join across them in OTBI, the owned conformed model joins them on shared 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