ADO.NET Provider for Oracle Fusion Cloud Financials

Build 25.0.9434

ExpenseMealsPolicies

Defines meal expense guidelines, limits, and other policy details for business trips or events.

Columns

Name Type Description
MealsPolicyId [KEY] Long The unique identifier for each meal policy within the ExpenseMealsPolicies table, used to distinguish different meal policies.
PolicyName String The name of the expense meals policy, typically describing the scope or conditions under which the policy applies.
Description String A detailed description of the expense meals policy, outlining its purpose and guidelines for usage.
StatusCode String A code representing the current status of the expense meals policy, indicating whether it is active, inactive, or in another state.
Status String The status of the expense meals policy, providing a human-readable version of the status code, such as 'Active' or 'Inactive'.
SingleInstanceLimitFlag Bool Indicates whether the meal policy allows only a single instance of a meal to be reimbursed per claim. A true value means only one meal per claim.
DailyLimitFlag Bool Indicates whether the policy enforces a daily limit for meal expenses. A true value means there is a daily maximum limit for meal reimbursements.
CurrencyOptionCode String A code representing the currency option for the meal policy, used to determine which currency is applicable for meal reimbursements.
CurrencyOption String The specific currency option associated with the expense meals policy, such as USD or EUR.
CurrencyCode String The ISO code for the currency used in the meal policy, such as USD or EUR.
Currency String The name of the currency applied to the meal policy, like USD or EUR.
EnabledRoleFlag Bool Indicates whether the meal policy is enabled for specific roles. A true value means that the policy applies to certain roles within the organization.
PolicyRoleCode String A unique code identifying the role that is associated with the meal policy, such as 'Manager' or 'Employee'.
PolicyRole String The name or description of the role to which the meal policy applies, such as 'Manager', 'Employee', or other job roles.
EnabledLocationFlag Bool Indicates whether the meal policy is enabled for specific locations. A true value means the policy applies to designated locations.
LocationTypeCode String A code representing the type of location where the meal policy is applicable, such as 'Office' or 'Field'.
LocationType String The name or description of the type of location associated with the policy, such as 'Office' or 'Field'.
ZoneTypeCode String A code identifying the zone type where the meal policy is applicable, used for categorizing areas or regions within the company.
ZoneType String The name or description of the zone type that the policy covers, such as 'Domestic' or 'International'.
PolicyEnforcementCode String A code specifying the enforcement mechanism for the meal policy, such as automatic checks or manual approvals.
PolicyEnforcement String A description of how the meal policy is enforced, including any automated checks or manual oversight mechanisms.
PolicyViolationFlag Bool Indicates whether a policy violation occurred. A true value indicates that a rule or limit was violated during the claim process.
WarningTolerance Decimal The tolerance level for warning users about potential violations of the meal policy, typically expressed as a percentage above the policy limit.
DispWarningToUserFlag Bool Indicates whether a warning should be displayed to users when they are close to violating the policy. A true value means a warning is shown.
PreventSubmissionFlag Bool Indicates whether submission of a claim is prevented if it violates the policy. A true value means the claim will not be submitted.
ErrorTolerance Decimal The tolerance level for allowing errors beyond the defined policy limit, often a percentage of the total meal expenses.
CreationDate Datetime The date and time when the meal policy was created, used for tracking the policy’s origin and version history.
CreatedBy String The name or identifier of the user who created the meal policy, useful for auditing and tracking policy changes.
LastUpdateDate Datetime The date and time when the meal policy was last updated, reflecting any changes or modifications made to the policy.
LastUpdatedBy String The name or identifier of the user who last updated the meal policy, useful for tracking edits or adjustments.
LastUpdateLogin String The login identifier used during the last update of the meal policy, assisting with auditing and user activity tracking.
RatesSourceCode String A code representing the source of the rate used for meal reimbursements, typically indicating where the rate data is derived from.
RateIncludeMealsFlag Bool Indicates whether the rate includes meals as part of the reimbursement calculation. A true value means meals are included in the rate.
RateIncludeOtherFlag Bool Indicates whether other types of expenses are included in the rate. A true value means other reimbursements are factored into the total rate.
MealsRateSourceCode String A code identifying the specific source of the meals rate, such as 'Standard' or 'Custom'.
MealsRateSource String The name or description of the source used for the meals rate, providing context for how the rate was determined.
Finder String The search or filter term used to find specific expense meal policies, allowing users to quickly locate relevant policies.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434