JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062