ExpenseTypespreferredMerchantLists
Catalogs approved merchants for specific expense types, ensuring policy compliance and negotiated rates.
Columns
Name | Type | Description |
ExpenseTypesExpenseTypeId [KEY] | Long | Unique identifier for the expense type in the ExpenseTypespreferredMerchantLists table, linking the preferred merchant list to its corresponding expense type. |
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 restrictions or compliance issues. |
EndDate | Date | End date when the preferred merchant list becomes inactive, marking the expiration of its validity for the associated expense type. |
ExpenseTypeId [KEY] | Long | Unique identifier for the expense type linked to the preferred merchant list, categorizing the list under specific types of expenses. |
LastUpdateDate | Datetime | Timestamp of the most recent update made to the preferred merchant list, helping track changes and maintain data accuracy. |
LastUpdateLogin | String | Session login associated with the user who last updated the record, ensuring traceability for updates. |
LastUpdatedBy | String | Username of the individual who last modified the preferred merchant list, providing accountability for updates. |
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, recommended, or other category of merchant list. |
PolicyEnforcement | String | Describes how policy enforcement is applied to the preferred merchant list, ensuring that merchants comply with company policies and restrictions. |
PolicyEnforcementCode | String | Code that defines the specific policy enforcement rule applied to the preferred merchant list, ensuring consistent policy application. |
StartDate [KEY] | Date | Start date when the preferred merchant list becomes valid, 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, ensuring its applicability from that point onward. |
BindTemplateId | Long | Unique identifier for the template to which the preferred merchant list is bound, ensuring the list is associated with the correct template. |
Finder | String | Search term or identifier used to locate and filter preferred merchant list records within the system, aiding in efficient data retrieval. |