ExpensePerDiemCalculations
The expense per diem calculations resource is used to calculate the reimbursement of a trip upon which a per diem policy applies.
Columns
Name | Type | Description |
Username [KEY] | String | User Name of the person associated with the trip. |
BusinessUnit [KEY] | String | Business unit associated with the expense template. |
ExpenseTemplate [KEY] | String | Expense template associated with the trip. |
ExpenseType [KEY] | String | Expense type associated with the per diem policy. |
Location [KEY] | String | Geographical location or zone code of the trip. Values are from exm_locations_mv. |
StartDatetime [KEY] | String | Date and time when the trip started. The format is YYYY-MM-DD hours:minutes:seconds in two digits. |
EndDatetime [KEY] | String | Date and time when the trip ended. The format is YYYY-MM-DD hours:minutes:seconds in two digits. |
ReimbursementCurrencyCode [KEY] | String | Optional value that indicates the reimbursement currency if it's different from the functional currency. |
Deductions [KEY] | String | Optional value that indicates daily deductions. The format is a series of day entries separated by a comma. Each day is indicated with 5 letters composed of Y and N. The letters indicate whether the day is a holiday, whether breakfast, lunch, and dinner are included, and whether accommodations are included. For example, a two day trip with no holidays where the first day breakfast and last day dinner aren't included is entered as: NNYYY,NYYNY. |
PersonId [KEY] | Long | Unique identifier of the person associated with the user name. |
BusinessUnitId | Long | BusinessUnitId of ExpensePerDiemCalculations |
ExpenseTypeId [KEY] | Long | Unique identifier of the expense type. |
LocationId [KEY] | Long | Unique identifier of the geographical location obtained from the location. |
ExchangeRate | Decimal | Exchange rate between the functional currency and the reimbursement currency, if specified. |
ReimbursableAmount | Decimal | The reimbursable amount in the reimbursement currency, if specified. |
ReceiptAmount | Decimal | Per diem amount in the functional currency. |
ReceiptCurrencyCode | String | Indicates the functional currency of this per diem. |
DailyDetails | String | Daily breakdown of per diem calculations like eligibility, deductions, and so on. |
Messages | String | Validation messages and error messages. |
Finder | String | Finder of ExpensePerDiemCalculations |