ExpensePerDiemCalculations
ExpensePerDiemCalculations
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 | Unique identifier of the business unit. |
| ExpenseTypeId [KEY] | Long | Unique identifier of the expense type. |
| LocationId [KEY] | Long | Unique identifier of the geographical location obtained from the location. |
| ExchangeRate | Double | Exchange rate between the functional currency and the reimbursement currency, if specified. |
| ReimbursableAmount | Double | The reimbursable amount in the reimbursement currency, if specified. |
| ReceiptAmount | Double | 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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |