ExpensePerDiemCalculations
Calculates trip-specific per diem amounts for employee expenses, factoring in policy rules and travel duration.
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, meals, etc., 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. |