ExpenseTemplatesexpenseTypespreferredMerchantLists
Specifies pre-approved merchants for given expense types in a template, streamlining compliance and spend oversight.
Columns
| Name | Type | 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 | Date when the preferred merchant list is bound to a specific record or context, making the list applicable from that point onward. |
| BindOrgId | Long | Unique identifier for the organization associated with the preferred merchant list, ensuring it is linked to the correct organization. |
| ExpenseTemplateId | Long | 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. |