Oracle Fusion · Data dictionary
EXM_EXPENSES
SharedUsed in 1 subject areas36 reporting columns
Source object in the Oracle Fusion data model.
Primary key: EXPENSE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AUDIT_ADJUSTMENT_REASON | ● | Audit adjustment reason. | |
| AVG_MILEAGE_RATE | ● | Avg mileage rate. | |
| DAILY_DISTANCE | ● | Daily distance. | |
| DESCRIPTION | ● | Description. | |
| DESTINATION_FROM | ● | Destination from. | |
| DESTINATION_TO | ● | Destination to. | |
| DISTANCE_UNIT_CODE | ● | Code identifying the distance unit. | |
| EXPENSE_CATEGORY_CODE | ● | Code identifying the expense category. | |
| EXPENSE_ID | PK | ○ | Identifier for the expense. |
| EXPENSE_SOURCE | ● | Expense source. | |
| EXPENSE_TYPE_CATEGORY_CODE | ● | Code identifying the expense type category. | |
| FLIGHT_NUMBER | ● | Flight number. | |
| FUEL_TYPE | ● | Type of fuel. | |
| FUNC_CURRENCY_AMOUNT | ● | Func currency amount. | |
| JUSTIFICATION | ● | Justification. | |
| JUSTIFICATION_REQUIRED_FLAG | ● | Indicator (Y/N) for the justification required. | |
| LOCATION | ● | Location. | |
| MERCHANT_NAME | ● | Name of the merchant. | |
| NUMBER_OF_ATTENDEES | ● | Number of attendees. | |
| ORIG_REIMBURSABLE_AMOUNT | ● | Orig reimbursable amount. | |
| PASSENGER_AMOUNT | ● | Passenger amount. | |
| PERSONAL_RECEIPT_AMOUNT | ● | Personal receipt amount. | |
| POLICY_SHORTPAY_FLAG | ● | Indicator (Y/N) for the policy shortpay. | |
| POLICY_VIOLATED_FLAG | ● | Indicator (Y/N) for the policy violated. | |
| RECEIPT_AMOUNT | ● | Receipt amount. | |
| RECEIPT_CURRENCY_CODE | ● | Currency code for the receipt. | |
| RECEIPT_MISSING_FLAG | ● | Indicator (Y/N) for the receipt missing. | |
| RECEIPT_REQUIRED_FLAG | ● | Indicator (Y/N) for the receipt required. | |
| RECEIPT_VERIFIED_FLAG | ● | Indicator (Y/N) for the receipt verified. | |
| REIMBURSABLE_AMOUNT | ● | Reimbursable amount. | |
| TAX_CLASSIFICATION_CODE | ● | Code identifying the tax classification. | |
| TICKET_CLASS_CODE | ● | Code identifying the ticket class. | |
| TICKET_NUMBER | ● | Ticket number. | |
| TRAVEL_TYPE | ● | Type of travel. | |
| TRIP_DISTANCE | ● | Trip distance. | |
| VEHICLE_CATEGORY_CODE | ● | Code identifying the vehicle category. | |
| VEHICLE_TYPE | ● | Type of vehicle. |
3 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to EXM_EXPENSES.
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 EXM_EXPENSES?
We ship parameterized SQL, BICC config, and dbt models you own.