ExpensePerDiemCalculations
Calculates trip-specific per diem amounts for employee expenses, factoring in policy rules and travel duration.
Table-Specific Information
Select
The provider uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The provider processes other filters within the provider.
For example, the following query is processed server-side:
SELECT * FROM Financials.ExpensePerDiemCalculations WHERE Finder = 'PrimaryKey' AND Username = 'user.name' AND PersonId = 300000050525401 AND Deductions = 'NNYYY';
Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.
The ExpensePerDiemCalculations view supports the 'PrimaryKey' finder. The fields which can be used along with it are
- BusinessUnit
- Deductions
- StartDatetime
- EndDatetime
- ExpenseTemplate
- ExpenseType
- ExpenseTypeId
- Location
- LocationId
- PersonId
- ReimbursementCurrencyCode
- Username
Columns
| Name | Type | Description |
| Username [KEY] | String | The name of the user associated with the trip, typically representing the employee or individual submitting the expense. |
| BusinessUnit [KEY] | String | The business unit or department that is linked to the expense template, providing context for the financial tracking and approval process. |
| ExpenseTemplate [KEY] | String | The expense template assigned to the trip, which defines the structure and rules for expense reporting under the applicable policy. |
| ExpenseType [KEY] | String | The type of expense incurred during the trip, such as per diem, travel, or meals, aligning with the organization's cost categorization. |
| Location [KEY] | String | The geographic location or zone code of the trip, referring to a specific area from the exm_locations_mv table used to track expenses by region. |
| StartDatetime [KEY] | String | The date and time when the trip commenced, formatted as YYYY-MM-DD HH:MM:SS, marking the beginning of the expense period. |
| EndDatetime [KEY] | String | The date and time when the trip ended, formatted as YYYY-MM-DD HH:MM:SS, marking the conclusion of the expense period. |
| ReimbursementCurrencyCode [KEY] | String | An optional value indicating the currency for reimbursement, in cases where it differs from the organization's functional currency. |
| Deductions [KEY] | String | Optional deductions for daily expenses, formatted as a series of day entries where each entry uses five letters (Y or N) to indicate holiday status, meals, and accommodations. |
| PersonId [KEY] | Long | The unique identifier for the individual associated with the trip, linking to the person record in the system. |
| BusinessUnitId | Long | The unique identifier for the business unit associated with the expense template, helping to track expenses against specific organizational units. |
| ExpenseTypeId [KEY] | Long | A unique identifier for the type of expense, enabling the system to categorize and track different categories of expenses accurately. |
| LocationId [KEY] | Long | A unique identifier for the geographical location linked to the trip, which helps in organizing and analyzing location-based expenses. |
| ExchangeRate | Decimal | The exchange rate between the organization's functional currency and the reimbursement currency, if applicable, allowing for accurate conversion of amounts. |
| ReimbursableAmount | Decimal | The amount that is eligible for reimbursement in the specified reimbursement currency, based on the trip's eligible expenses. |
| ReceiptAmount | Decimal | The total per diem amount in the functional currency, reflecting the daily allowance for the trip. |
| ReceiptCurrencyCode | String | The functional currency code used for per diem calculations, indicating the currency in which the per diem is calculated. |
| DailyDetails | String | A detailed breakdown of per diem calculations, including eligibility, deductions, and adjustments for each day of the trip. |
| Messages | String | A list of validation and error messages related to the trip's expense submission, useful for troubleshooting and correcting data entry. |
| Finder | String | A reference to the finder used to search and retrieve expense per diem calculations, enabling easy lookup and filtering of records. |