Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

ExpensePerDiemPoliciesexpensePerDiemPolLines

The expense per diem policy lines resource is used to view per diem expense policy line records.

Columns

Name Type Description
ExpensePerDiemPoliciesPerDiemPolicyId [KEY] Long ExpensePerDiemPoliciesPerDiemPolicyId of ExpensePerDiemPoliciesexpensePerDiemPolLines
AccomNightRate Decimal AccomNightRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
AccommodationDeduction Decimal AccommodationDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
AccommodationTypeCode String AccommodationTypeCode of ExpensePerDiemPoliciesexpensePerDiemPolLines
AccommodationType String AccommodationType of ExpensePerDiemPoliciesexpensePerDiemPolLines
BaseRate Decimal BaseRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
CreatedBy String CreatedBy of ExpensePerDiemPoliciesexpensePerDiemPolLines
CreationDate Datetime CreationDate of ExpensePerDiemPoliciesexpensePerDiemPolLines
CurrencyCode String CurrencyCode of ExpensePerDiemPoliciesexpensePerDiemPolLines
Currency String Currency of ExpensePerDiemPoliciesexpensePerDiemPolLines
EndDate Date EndDate of ExpensePerDiemPoliciesexpensePerDiemPolLines
FirstDayRate Decimal FirstDayRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
GeographyId Long GeographyId of ExpensePerDiemPoliciesexpensePerDiemPolLines
GeoLocName String GeoLocName of ExpensePerDiemPoliciesexpensePerDiemPolLines
HolidayRate Decimal HolidayRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
InvalidCode String InvalidCode of ExpensePerDiemPoliciesexpensePerDiemPolLines
Invalid String Invalid of ExpensePerDiemPoliciesexpensePerDiemPolLines
LastDayRate Decimal LastDayRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
LastUpdateDate Datetime LastUpdateDate of ExpensePerDiemPoliciesexpensePerDiemPolLines
LastUpdateLogin String LastUpdateLogin of ExpensePerDiemPoliciesexpensePerDiemPolLines
LastUpdatedBy String LastUpdatedBy of ExpensePerDiemPoliciesexpensePerDiemPolLines
LineHours Int LineHours of ExpensePerDiemPoliciesexpensePerDiemPolLines
LineMinutes Int LineMinutes of ExpensePerDiemPoliciesexpensePerDiemPolLines
LowerLineHours Int LowerLineHours of ExpensePerDiemPoliciesexpensePerDiemPolLines
LowerLineMinutes Int LowerLineMinutes of ExpensePerDiemPoliciesexpensePerDiemPolLines
LowerRoleThreshold Int LowerRoleThreshold of ExpensePerDiemPoliciesexpensePerDiemPolLines
LowerTripExceedDays Decimal LowerTripExceedDays of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsBreakfastDeduction Decimal MealsBreakfastDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsBreakfastRate Decimal MealsBreakfastRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsDailyDeduction Decimal MealsDailyDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsDinnerDeduction Decimal MealsDinnerDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsDinnerRate Decimal MealsDinnerRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsLunchDeduction Decimal MealsLunchDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsLunchRate Decimal MealsLunchRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsOneMealDeduction Decimal MealsOneMealDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsOneMealRate Decimal MealsOneMealRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsThreeMealsDeduction Decimal MealsThreeMealsDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsThreeMealsRate Decimal MealsThreeMealsRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsTwoMealsDeduction Decimal MealsTwoMealsDeduction of ExpensePerDiemPoliciesexpensePerDiemPolLines
MealsTwoMealsRate Decimal MealsTwoMealsRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
ObjectVersionNumber Int ObjectVersionNumber of ExpensePerDiemPoliciesexpensePerDiemPolLines
OthersFirstDayRate Decimal OthersFirstDayRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
OthersLastDayRate Decimal OthersLastDayRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
OthersStandardRate Decimal OthersStandardRate of ExpensePerDiemPoliciesexpensePerDiemPolLines
PerDiemPolicyId Long PerDiemPolicyId of ExpensePerDiemPoliciesexpensePerDiemPolLines
PolicyLineId [KEY] Long PolicyLineId of ExpensePerDiemPoliciesexpensePerDiemPolLines
RawCity String RawCity of ExpensePerDiemPoliciesexpensePerDiemPolLines
RawCountry String RawCountry of ExpensePerDiemPoliciesexpensePerDiemPolLines
RawCounty String RawCounty of ExpensePerDiemPoliciesexpensePerDiemPolLines
RawState String RawState of ExpensePerDiemPoliciesexpensePerDiemPolLines
RoleThreshold Int RoleThreshold of ExpensePerDiemPoliciesexpensePerDiemPolLines
RoleThresholdCode String RoleThresholdCode of ExpensePerDiemPoliciesexpensePerDiemPolLines
SeasonEndDay Int SeasonEndDay of ExpensePerDiemPoliciesexpensePerDiemPolLines
SeasonEndMonth Int SeasonEndMonth of ExpensePerDiemPoliciesexpensePerDiemPolLines
SeasonStartDay Int SeasonStartDay of ExpensePerDiemPoliciesexpensePerDiemPolLines
SeasonStartMonth Int SeasonStartMonth of ExpensePerDiemPoliciesexpensePerDiemPolLines
StartDate Date StartDate of ExpensePerDiemPoliciesexpensePerDiemPolLines
Status String Status of ExpensePerDiemPoliciesexpensePerDiemPolLines
StatusMeaning String StatusMeaning of ExpensePerDiemPoliciesexpensePerDiemPolLines
TripExceedDays Decimal TripExceedDays of ExpensePerDiemPoliciesexpensePerDiemPolLines
TypeOfLineCode String TypeOfLineCode of ExpensePerDiemPoliciesexpensePerDiemPolLines
WeekendDay1Rate Decimal WeekendDay1Rate of ExpensePerDiemPoliciesexpensePerDiemPolLines
WeekendDay2Rate Decimal WeekendDay2Rate of ExpensePerDiemPoliciesexpensePerDiemPolLines
ZoneCode String ZoneCode of ExpensePerDiemPoliciesexpensePerDiemPolLines
Finder String Finder of ExpensePerDiemPoliciesexpensePerDiemPolLines

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