ExpenseMileagePolicies
Sets reimbursement rules for mileage claims, including distance rates and allowable vehicle types.
Columns
| Name | Type | Description |
| AdditionalRatesListCode | String | The unique code representing the additional rates list associated with the ExpenseMileagePolicies record, used to define specific rate details. |
| ApplyThresholdByCode | String | A code specifying the method by which thresholds are applied in the ExpenseMileagePolicies record, such as by distance or cost. |
| ApplyThresholdBy | String | The criteria used to determine how thresholds are applied in the ExpenseMileagePolicies record, such as based on distance, time, or amount. |
| CalculationPassRateByDistFlag | Bool | A flag indicating whether the pass rate calculation is based on distance, used in the ExpenseMileagePolicies record for distance-based calculations. |
| CapturePassNamesFlag | Bool | A flag indicating whether to capture pass names, useful for logging or reporting pass-specific information in the ExpenseMileagePolicies record. |
| CommuteDistanceRequiredFlag | Bool | A flag specifying whether a commute distance is required for the ExpenseMileagePolicies record, ensuring that only valid commute data is processed. |
| CountryCode | String | A two-character country code that defines the region for the ExpenseMileagePolicies record, used to apply region-specific rules and rates. |
| Country | String | The full name of the country for the ExpenseMileagePolicies record, helping to identify the geographical context for the policy. |
| CreatedBy | String | The username or ID of the individual who created the ExpenseMileagePolicies record, useful for tracking policy creation. |
| CreationDate | Datetime | The date and time when the ExpenseMileagePolicies record was created, providing a timestamp for auditing and history tracking. |
| CurrencyCode | String | The code representing the currency used in the ExpenseMileagePolicies record, such as USD, EUR, or GBP, indicating the financial context. |
| Currency | String | The full name of the currency used in the ExpenseMileagePolicies record, offering a clearer context for financial operations within the policy. |
| CurrencyOptionCode | String | A code indicating the specific currency option available for the ExpenseMileagePolicies record, allowing for different currency configurations. |
| CurrencyOption | String | A description of the currency option available in the ExpenseMileagePolicies record, such as 'foreign' or 'local' to differentiate various choices. |
| Description | String | A textual description providing details about the specific ExpenseMileagePolicies record, useful for understanding the intent and scope of the policy. |
| DisplayAllUnitsFlag | Bool | A flag indicating whether all units of measurement should be displayed for the ExpenseMileagePolicies record, enabling full visibility of available options. |
| DistanceThresholdFlag | Bool | A flag that determines whether a distance threshold is applied within the ExpenseMileagePolicies record, ensuring compliance with predefined limits. |
| EligibilityDistance | Decimal | The minimum distance required for eligibility under the ExpenseMileagePolicies record, ensuring only valid mileage claims are considered. |
| EnabledAdditnlRatesFlag | Bool | A flag specifying whether additional rates are enabled for the ExpenseMileagePolicies record, allowing for the inclusion of extra rate details. |
| EnabledDeductCommuteFlag | Bool | A flag indicating whether commute-related deductions are enabled in the ExpenseMileagePolicies record, ensuring accurate expense calculations. |
| EnabledEligibilityFlag | Bool | A flag that enables or disables the eligibility conditions for the ExpenseMileagePolicies record, ensuring that only valid claims are processed. |
| EnabledFuelTypeFlag | Bool | A flag indicating whether fuel type selection is enabled for the ExpenseMileagePolicies record, allowing for specific fuel-related deductions or policies. |
| EnabledGenderFlag | Bool | A flag that determines whether gender-specific criteria are enabled in the ExpenseMileagePolicies record, potentially affecting rates or rules. |
| EnabledLocationFlag | Bool | A flag indicating whether location-based policies are enabled in the ExpenseMileagePolicies record, allowing for geographically dependent rules. |
| EnabledMaximumPassFlag | Bool | A flag specifying whether a maximum pass limit is enabled in the ExpenseMileagePolicies record, controlling the number of passes allowed. |
| EnabledPassengerFlag | Bool | A flag indicating whether passenger-related criteria are enabled in the ExpenseMileagePolicies record, affecting rates or rules based on passengers. |
| EnabledRoleFlag | Bool | A flag that determines whether role-based criteria are enabled in the ExpenseMileagePolicies record, enabling differentiated policies for various user roles. |
| EnabledStandardDeductionFlag | Bool | A flag indicating whether standard deductions are enabled in the ExpenseMileagePolicies record, simplifying mileage calculations by applying predefined deductions. |
| EnabledVehCategoryFlag | Bool | A flag that determines whether vehicle category-based policies are enabled in the ExpenseMileagePolicies record, allowing for different rates based on vehicle types. |
| EnabledVehTypeFlag | Bool | A flag indicating whether vehicle type-specific criteria are enabled in the ExpenseMileagePolicies record, enabling differentiation based on vehicle characteristics. |
| FuelTypeListCode | String | A code representing the list of fuel types associated with the ExpenseMileagePolicies record, used to define which types of fuel are eligible for reimbursement. |
| LastUpdateDate | Datetime | The date and time the ExpenseMileagePolicies record was last updated, providing an audit trail of modifications. |
| LastUpdateLogin | String | The username or ID of the individual who last updated the ExpenseMileagePolicies record, helping to track changes to the policy. |
| LastUpdatedBy | String | The username or ID of the person who made the most recent update to the ExpenseMileagePolicies record, ensuring accountability in changes. |
| LocationTypeCode | String | A code that defines the type of location for the ExpenseMileagePolicies record, helping to categorize the location context within the policy. |
| LocationType | String | A description of the type of location associated with the ExpenseMileagePolicies record, such as 'urban' or 'rural', providing more specific context for the policy. |
| MaximumPassengers | Int | The maximum number of passengers allowed under the expense mileage policies, which dictates the upper limit for passengers that can be considered when calculating mileage reimbursements. |
| MileageDeduction | Decimal | The specific monetary amount deducted for mileage under the expense mileage policies, typically used to calculate the expense reimbursement based on the distance traveled. |
| MileagePolicyId [KEY] | Long | A unique identifier assigned to each mileage policy in the ExpenseMileagePolicies table, used to reference specific policies when applying rules or calculations. |
| PassengerRuleCode | String | A code that specifies the set of rules for determining passenger-related factors in the expense mileage policies, often used to categorize types of passenger groups. |
| PassengerRule | String | The detailed description of the rules applied to passengers under the expense mileage policies, outlining conditions like eligibility and calculation methodologies. |
| PolicyName | String | The name of the mileage policy, which identifies the policy's purpose, such as 'Standard Mileage Reimbursement' or 'Custom Vehicle Category Mileage'. |
| PolicyRoleCode | String | A code that represents the role of an individual or entity in the context of the mileage policy, used to distinguish between different roles such as employee, manager, or external vendor. |
| PolicyRole | String | A textual description of the role in the context of the mileage policy, clarifying the responsibilities or actions allowed under the policy, such as 'Employee' or 'Approver'. |
| StatusCode | String | A code representing the current status of the mileage policy, indicating whether the policy is active, suspended, or archived. |
| Status | String | The status description of the mileage policy, such as 'Active', 'Inactive', or 'Pending', providing an overview of the policy's current state in the system. |
| StandardDeductionCode | String | A code identifying the standard deduction type applied within the mileage policy, typically used to standardize deduction rates for various vehicle or trip types. |
| UnitOfMeasureCode | String | A code representing the unit of measure used in the policy, such as 'Miles' or 'Kilometers', specifying the unit used for distance calculations. |
| UnitOfMeasure | String | The textual description of the unit of measure, indicating how mileage is quantified under the policy, such as 'Miles' or 'Kilometers'. |
| VehicleCategoryListCode | String | A code representing the list of vehicle categories that are eligible for mileage reimbursement, helping to categorize vehicle types such as 'Sedan' or 'SUV'. |
| VehicleTypeListCode | String | A code representing a list of vehicle types covered by the mileage policy, used to specify allowable vehicle types for reimbursement purposes, like 'Compact' or 'Luxury'. |
| ZoneTypeCode | String | A code representing the type of geographical zone considered in the mileage policy, used to distinguish between different types of reimbursement zones like 'Urban' or 'Rural'. |
| ZoneType | String | The name or description of the geographical zone type, helping to define the area for which the mileage policy applies, such as 'Urban Area' or 'Long-Distance Zone'. |
| Finder | String | The identifier or search keyword used to locate and retrieve specific mileage policies in the system, often used for filtering policies in the database. |