ExpenseMealsPoliciesexpenseMealsPolicyLines
Breaks down meal policy rules into line items, detailing per-diem amounts, eligibility, and exceptions.
Columns
| Name | Type | Description |
| ExpenseMealsPoliciesMealsPolicyId [KEY] | Long | The unique identifier for each meal policy within the Expense Meals Policies table, used to associate specific policies with their related expense meal lines. |
| PolicyLineId [KEY] | Long | The unique identifier for each line item in the Expense Meals Policies table, linking the specific line entry to a broader policy. |
| MealsPolicyId | Long | The identifier for the meal policy in the Expense Meals Policies table, used to track and manage specific meal-related expense policies. |
| TypeOfRateCode | String | A code representing the type of rate applied to a meal policy, helping to categorize the rate structure (for example, flat or per person). |
| SingleInstanceLimit | Decimal | The maximum allowable amount for a single expense instance within the meal policy, used to enforce spending limits per meal. |
| DailyLimit | Decimal | The daily spending limit for meals, restricting total allowable meal expenses within a 24-hour period. |
| CurrencyCode | String | The ISO currency code for the meal policy expenses, indicating the currency in which limits and allowances are defined. |
| Currency | String | The name of the currency used in the meal policy, corresponding to the CurrencyCode for expense processing. |
| StartDate | Date | The effective date when the meal policy becomes active, marking the beginning of the validity period for the policy. |
| EndDate | Date | The expiration date when the meal policy is no longer valid, defining the end of the policy's applicability. |
| RoleId | Long | The identifier of the role associated with the meal policy, linking the policy to specific organizational roles (for example, manager, employee). |
| RoleName | String | The name of the role tied to the meal policy, indicating which user roles or departments are governed by this policy. |
| GeographyId | Long | The unique identifier for the geographical area associated with the meal policy, helping to associate policies with specific regions. |
| ZoneCode | String | A code representing the specific zone within a geography, often used to determine localized meal limits and rates. |
| Zone | String | The name of the zone associated with the meal policy, providing a more human-readable description of the geographic area covered. |
| GeolocName | String | The name of the geographical location tied to the meal policy, helping to identify the specific area within a zone or region. |
| RawCountry | String | The raw country name, as entered in the system, used to identify the country in which the meal policy is applicable. |
| RawState | String | The raw state or province name, reflecting the state-level region for which the meal policy applies. |
| RawCounty | String | The raw county name, used for more granular geographic identification within the broader region of the meal policy. |
| RawCity | String | The raw city name, specifying the exact city in which the meal policy is valid or applied. |
| StatusCode | String | A code indicating the current status of the meal policy line, such as active, inactive, or suspended. |
| Status | String | A descriptive status of the meal policy line, providing additional context about whether the policy line is currently in use or has been discontinued. |
| CreationDate | Datetime | The timestamp indicating when the meal policy line was first created in the system, helping to track its initiation. |
| CreatedBy | String | The identifier of the user who created the meal policy line, providing traceability for system changes. |
| LastUpdateDate | Datetime | The timestamp indicating the last time the meal policy line was updated, helping to track recent changes. |
| LastUpdatedBy | String | The identifier of the user who last updated the meal policy line, providing accountability for changes. |
| LastUpdateLogin | String | The login identifier of the user who last modified the meal policy line, offering additional context for auditing purposes. |
| Finder | String | A user-defined search term or keyword used for querying the Expense Meals Policies data, allowing for quick retrieval based on specific criteria. |