ExpenseMileagePoliciesexpenseMileagePolicyLines
Contains line-level specifics for mileage policy, supporting different mileage rates or exceptions based on region or vehicle.
Columns
| Name | Type | Description |
| ExpenseMileagePoliciesMileagePolicyId [KEY] | Long | The unique identifier for the mileage policy in the ExpenseMileagePolicies table, used to link to specific policy lines within the expense management system. |
| AdditionalRateCode | String | The code representing any additional rate applied to the mileage policy, allowing for extra charges or discounts to be associated with the expense lines. |
| AdditionalRate | String | The value of the additional rate, specifying the monetary amount that is added or adjusted to the base rate in the mileage policy. |
| CalculationMethodCode | String | The code defining the method used to calculate mileage reimbursement, such as distance-based, time-based, or flat-rate. |
| CalculationMethod | String | A detailed description of the method used for calculating mileage expenses, such as 'per mile,' 'per kilometer,' or 'flat rate per day.' |
| CreatedBy | String | The username or identifier of the person who created the mileage policy line, useful for tracking data origins and auditing. |
| CreationDate | Datetime | The timestamp representing when the mileage policy line was created in the system, providing a historical record for when policies are added. |
| CurrencyCode | String | The code for the currency in which the mileage reimbursement is calculated, such as USD or EUR. |
| Currency | String | The full name of the currency used for the reimbursement amount, such as USD or EUR, providing clarity in multi-currency environments. |
| DistanceThreshold | Decimal | The threshold distance in miles or kilometers, above which specific rules or additional rates are applied to the mileage policy. |
| EndDate | Date | The date when the mileage policy line ends, marking the expiration or cutoff date for the policy to be valid or in effect. |
| FuelTypeCode | String | The code used to categorize the type of fuel associated with the vehicle in the mileage policy, such as 'Gas,' 'Diesel,' or 'Electric.' |
| FuelType | String | A description of the type of fuel used by the vehicle under the mileage policy, which can influence reimbursement rates or policies. |
| GeographyId | Long | A unique identifier for the geography or region related to the mileage policy, used to define where the policy applies (for example, specific cities, regions, or countries). |
| GeolocName | String | The name of the geographic location where the mileage policy applies, such as a specific city or region that has special rules or rates. |
| InvalidCode | String | A code representing the invalid status or error associated with the mileage policy line, useful for identifying issues that prevent processing. |
| InvalidDescription | String | A description of why the mileage policy line is considered invalid, providing context for troubleshooting or data correction. |
| LastUpdateDate | Datetime | The timestamp of the most recent update to the mileage policy line, allowing users to track changes and updates over time. |
| LastUpdateLogin | String | The login or username of the person who last updated the mileage policy line, facilitating accountability and traceability of changes. |
| LastUpdatedBy | String | The name or identifier of the person who made the most recent update to the mileage policy line, assisting with user tracking for audit purposes. |
| MileagePolicyId | Long | The unique identifier of the mileage policy, linking it to the specific rules and conditions applied to the expense reports and mileage calculations. |
| PassengerThreshold | Int | The threshold number of passengers in the vehicle that influences the mileage policy, potentially adjusting reimbursement rates based on vehicle occupancy. |
| PolicyLineId [KEY] | Long | The unique identifier of the specific policy line within the mileage policy, enabling precise reference to individual rules or conditions in the policy. |
| Rate | Decimal | The base rate for mileage reimbursement, typically calculated per mile or kilometer, used in conjunction with other factors to determine the total reimbursement. |
| RawCity | String | The raw city name as entered in the system, which may need further validation or standardization for processing in the mileage policy. |
| RawCountry | String | The raw country name entered in the system for the location where the mileage policy is applicable, useful for geographic filtering or data standardization. |
| RawCounty | String | The raw county name entered in the system, which may be used for location-based policy rules or geographical classification within the mileage policy. |
| RawState | String | The raw state or province name entered in the system, which could be relevant for policies that apply only to specific regions within a country. |
| RoleId | Long | The unique identifier for the role associated with the user or system function related to the mileage policy line, used for security and access management. |
| RoleName | String | The name of the role associated with the user or function managing the mileage policy, such as 'Manager' or 'Administrator,' indicating levels of access or responsibility. |
| StartDate | Date | The date when the mileage policy line becomes effective, marking the beginning of its applicability to mileage reimbursement. |
| StatusCode | String | A code representing the current status of the mileage policy line, such as 'Active,' 'Inactive,' or 'Pending,' indicating its processing state. |
| Status | String | A detailed description of the current status of the mileage policy line, providing further context on whether the policy is active, suspended, or in review. |
| VehicleCategoryCode | String | The code representing the category of vehicle (for example, 'Sedan,' 'SUV,' 'Truck') under the mileage policy, influencing rate calculations or eligibility. |
| VehicleCategory | String | A description of the vehicle category associated with the mileage policy, such as 'Sedan' or 'Electric Vehicle,' which may impact reimbursement rates. |
| VehicleTypeCode | String | The code representing the specific type of vehicle used in the mileage policy, such as 'Compact,' 'Luxury,' or 'Heavy Duty.' |
| VehicleType | String | The description of the vehicle type under the policy, such as 'Economy Car,' 'Luxury Sedan,' or 'Electric Vehicle,' affecting reimbursement rates and eligibility. |
| ZoneCode | String | The code for the geographic zone associated with the mileage policy, used to determine which zones are eligible for specific reimbursement rates. |
| Zone | String | The name of the geographic zone to which the mileage policy applies, which can vary by region, district, or other geographical classification. |
| Finder | String | A field used to search for and identify specific expense mileage policy lines, providing a user-friendly mechanism for filtering and locating policies. |