ExpenseMiscPoliciesexpenseMiscPolicyLines
Describes specific line items under miscellaneous policies, such as office supplies or other uncommon expense types.
Columns
| Name | Type | Description |
| ExpenseMiscPoliciesMiscPolicyId [KEY] | Long | The unique identifier for the miscellaneous policy within the Expense Miscellaneous Policies table, linking it to its related policy lines. |
| CreatedBy | String | The username or system identifier of the person or system who created the record in the Expense Miscellaneous Policies table. |
| CreationDate | Datetime | The timestamp when the record in the Expense Miscellaneous Policies table was created, indicating the date and time of entry. |
| CurrencyCode | String | The ISO currency code associated with the expense policy, determining the currency used for calculations and transactions. |
| DailyLimit | Decimal | The maximum allowable expense amount per day for the given policy, expressed as a decimal value. |
| EndDate | Date | The date on which the expense policy ends, marking the expiration of its validity. |
| GenderCode | String | The gender specification for the policy, if applicable, representing the gender-related restrictions or applicability. |
| GeographyId | Long | A unique identifier for the geographical region linked to the expense policy, representing location-based rules or limits. |
| GeolocName | String | The name of the geographical location associated with the policy, such as a city or region name. |
| InvalidCode | String | A code that flags invalid entries or discrepancies in the data of the expense policy line, used for validation purposes. |
| LastUpdateDate | Datetime | The date and time when the record was last modified, indicating the most recent update to the expense policy line. |
| LastUpdatedBy | String | The user or system identifier of the person or system who made the most recent update to the record. |
| LastUpdateLogin | String | The login identifier used during the last update of the record, tracking which session modified the data. |
| MiscPolicyId | Long | A unique identifier for the miscellaneous policy, representing the overarching policy to which the policy line belongs. |
| PolicyLineId [KEY] | Long | The unique identifier for an individual line within the miscellaneous policy, indicating a specific policy detail. |
| RawCity | String | The unprocessed city name as provided in the expense policy line, often used for geolocation or validation purposes. |
| RawCountry | String | The unprocessed country name provided in the policy, reflecting the geographical location of the expense entry. |
| RawCounty | String | The unprocessed county name associated with the expense, typically used for location-based limits or restrictions. |
| RawState | String | The unprocessed state name provided within the expense policy line, used to determine state-specific rules. |
| ReimbursementPercentage | Decimal | The percentage of the total expense that is eligible for reimbursement under the policy, expressed as a decimal. |
| RoleId | Long | The unique identifier for the role associated with the policy line, which determines the role-specific rules or limits. |
| RoleName | String | The name of the role that the expense policy applies to, identifying the user role or category (for example, manager, employee). |
| SingleInstanceLimit | Decimal | The maximum allowable amount for a single instance of an expense under the policy, expressed as a decimal. |
| StartDate | Date | The date on which the expense policy becomes effective, marking the beginning of its validity. |
| StatusCode | String | A code indicating the current status of the expense policy line, such as active, pending, or expired. |
| TypeOfRateCode | String | The code specifying the type of rate used for the policy (for example, per diem, hourly rate), which influences the reimbursement structure. |
| YearlyLimit | Decimal | The total maximum allowable expense for the entire year under the policy, represented as a decimal value. |
| ZoneCode | String | The code representing the zone or region for the policy, used to apply region-specific limits or rules. |
| Status | String | The current status of the policy line, indicating whether it is active, pending, or inactive. |
| Currency | String | The currency in which the expenses are reimbursed, typically reflecting the currency code used for calculations. |
| Finder | String | The identifier or name of the system or user that is responsible for searching and retrieving the policy line information. |