ExpenseTemplatesexpenseTypespreferredMerchantLists
Specifies pre-approved merchants for given expense types in a template, streamlining compliance and spend oversight.
Columns
| Name | Type | SupportedFinders | Description |
| ExpenseTemplatesExpenseTemplateId [KEY] | Long | Unique identifier for the expense template in the ExpenseTemplatesexpenseTypespreferredMerchantLists table, used to link the merchant list to a specific expense template. | |
| ExpensetypesExpenseTypeId [KEY] | Long | Unique identifier for the expense type associated with the preferred merchant list, categorizing the type of expenses that the merchant list applies to. | |
| CreatedBy | String | Username of the individual who created the preferred merchant list, ensuring accountability for record creation. | |
| CreationDate | Datetime | Timestamp indicating when the preferred merchant list was created, providing a reference for tracking its establishment. | |
| DispWarningToUserFlag | Bool | Flag indicating whether a warning should be displayed to the user when selecting a merchant from the list, alerting them to potential issues or restrictions. | |
| EndDate | Date | End date when the preferred merchant list becomes inactive, marking the conclusion of its applicability for the associated expense type. | |
| ExpenseTypeId [KEY] | Long | Unique identifier for the expense type linked to the preferred merchant list, used to associate the list with specific types of expenses. | |
| LastUpdateDate | Datetime | Timestamp of the most recent update to the preferred merchant list, tracking any changes or revisions to the list. | |
| LastUpdateLogin | String | Session login associated with the user who last updated the record, ensuring traceability of updates. | |
| LastUpdatedBy | String | Username of the individual who last modified the preferred merchant list, providing accountability for changes made. | |
| MerchantListName | String | Name of the preferred merchant list, used to identify and differentiate between various merchant lists within the system. | |
| MerchantListType [KEY] | String | Type of the merchant list, indicating whether it is a preferred merchant list, recommended list, or another category of merchants. | |
| PolicyEnforcement | String | Describes the policy enforcement rules applied to the preferred merchant list, defining how merchants are selected or restricted. | |
| PolicyEnforcementCode | String | Code that specifies the policy enforcement rule, used for consistent application of policies across the system. | |
| StartDate [KEY] | Date | Start date of the preferred merchant list's validity, marking the beginning of its applicability within the expense template. | |
| BindDate | Date | FindByOrgIdAndDate | Date when the preferred merchant list is bound to a specific record or context, making the list applicable from that point onward. |
| BindOrgId | Long | FindByOrgIdAndDate | Unique identifier for the organization associated with the preferred merchant list, ensuring it is linked to the correct organization. |
| ExpenseTemplateId | Long | PrimaryKey | Unique identifier for the expense template associated with the preferred merchant list, helping to link the list to specific expense templates. |
| Finder | String | Search term or identifier used to locate and filter preferred merchant list records within the system, making data retrieval easier. |