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.
Problems that run through this table