ExpenseMiscPolicies
Covers miscellaneous expense categories that don’t fall under standard policies, detailing eligibility and maximum thresholds.
Columns
| Name | Type | Description |
| CreatedBy | String | The username or ID of the individual who initially created the record for the ExpenseMiscPolicies table. |
| CreationDate | Datetime | The date and time when the record for the ExpenseMiscPolicies table was first created. |
| CurrencyCode | String | The three-letter ISO code representing the currency used in the policy for the ExpenseMiscPolicies table. |
| CurrencyOptionCode | String | The code identifying the selected currency option for the policy in the ExpenseMiscPolicies table. |
| DailyLimitFlag | Bool | A flag indicating whether a daily spending limit is applied to the policy in the ExpenseMiscPolicies table. |
| DaysBasedItemParentFlag | Bool | A flag that specifies whether the policy is based on a parent item with a days-based calculation in the ExpenseMiscPolicies table. |
| Description | String | A textual description of the ExpenseMiscPolicies record, providing more details on the specific policy. |
| DispWarningToUserFlag | Bool | A flag that determines if a warning message is displayed to the user regarding this policy in the ExpenseMiscPolicies table. |
| EligibilityDays | Int | The number of days the policy is applicable or the eligibility duration in the ExpenseMiscPolicies table. |
| EnabledEligibilityFlag | Bool | A flag indicating whether eligibility for the policy is enabled in the ExpenseMiscPolicies table. |
| EnabledGenderFlag | Bool | A flag that specifies whether gender-based eligibility is enabled for the policy in the ExpenseMiscPolicies table. |
| EnabledLocationFlag | Bool | A flag that indicates whether location-based eligibility is enabled for the policy in the ExpenseMiscPolicies table. |
| EnabledRoleFlag | Bool | A flag that signifies if role-based eligibility is enabled for the policy in the ExpenseMiscPolicies table. |
| ErrorTolerance | Decimal | The tolerance limit for errors in policy calculations, expressed as a decimal value, in the ExpenseMiscPolicies table. |
| LastUpdateDate | Datetime | The date and time when the record for the ExpenseMiscPolicies table was last updated. |
| LastUpdatedBy | String | The username or ID of the individual who last modified the record in the ExpenseMiscPolicies table. |
| LastUpdateLogin | String | The login ID associated with the last update to the ExpenseMiscPolicies record. |
| LocationTypeCode | String | The code that defines the type of location applicable for the policy in the ExpenseMiscPolicies table. |
| MiscPolicyId [KEY] | Long | A unique identifier for each miscellaneous policy in the ExpenseMiscPolicies table. |
| PeriodDay | Int | The specific day within a period (for example, day of the month) that this policy applies to in the ExpenseMiscPolicies table. |
| PeriodMonth | String | The month during which the policy is valid or enforced, represented as a string (for example, 'January') in the ExpenseMiscPolicies table. |
| PolicyEnforcementCode | String | A code that indicates how the policy is enforced (for example, strict, lenient) in the ExpenseMiscPolicies table. |
| PolicyName | String | The name or title of the policy in the ExpenseMiscPolicies table, providing a clear reference to the policy's purpose. |
| PolicyRoleCode | String | The code that specifies the role associated with this policy, indicating who the policy applies to in the ExpenseMiscPolicies table. |
| PolicyViolationFlag | Bool | A flag indicating whether a policy violation has occurred under this policy in the ExpenseMiscPolicies table. |
| PreventSubmissionFlag | Bool | A flag that determines if submission of transactions is prevented under this policy in the ExpenseMiscPolicies table. |
| RateTypeCode | String | A code that specifies the type of rate (for example, hourly, fixed) used in the policy for the ExpenseMiscPolicies table. |
| SingleInstanceLimitFlag | Bool | A flag indicating whether the policy applies a limit to a single instance (for example, per transaction) in the ExpenseMiscPolicies table. |
| StatusCode | String | The code representing the current status of the policy (for example, active, inactive) in the ExpenseMiscPolicies table. |
| WarningTolerance | Decimal | The tolerance level for issuing a warning before policy enforcement, expressed as a decimal value in the ExpenseMiscPolicies table. |
| YearlyLimitFlag | Bool | A flag indicating whether a yearly spending limit is applied to the policy in the ExpenseMiscPolicies table. |
| ZoneTypeCode | String | The code that defines the type of zone (for example, geographical zone, time zone) applicable to the policy in the ExpenseMiscPolicies table. |
| Status | String | The current status of the ExpenseMiscPolicies record, such as 'active' or 'inactive'. |
| RateType | String | The type of rate applied to the policy, such as 'fixed', 'variable', or 'hourly'. |
| CurrencyOption | String | The specific currency option selected for the policy, such as 'local currency' or 'foreign currency'. |
| PolicyRole | String | The role associated with the policy, specifying the category or group of users the policy applies to. |
| LocationType | String | The type of location associated with the policy, which could refer to geographical areas or specific locations like 'office' or 'remote'. |
| ZoneType | String | The type of zone associated with the policy, such as a geographical zone or a specific time zone that the policy governs. |
| Currency | String | The currency used in the policy, represented by its ISO currency code (for example, USD). |
| PolicyEnforcement | String | The method of enforcement applied to the policy, such as automated or manual review for compliance. |
| Finder | String | A reference identifier or code used to search for and retrieve the policy record in the ExpenseMiscPolicies table. |