ExpenseTemplatesexpenseTypespreferredMerchantLists
ExpenseTemplatesexpenseTypespreferredMerchantLists
Columns
| Name | Type | Description |
| ExpenseTemplatesExpenseTemplateId [KEY] | Long | ExpenseTemplatesExpenseTemplateId of ExpenseTemplatesexpenseTypespreferredMerchantLists |
| ExpensetypesExpenseTypeId [KEY] | Long | Unique identifier of an expense type in an expense template. |
| CreatedBy | String | User who created the preferred merchant list. |
| CreationDate | Datetime | Date when the preferred merchant list was created. |
| DispWarningToUserFlag | Bool | Indicates whether policy warning is displayed to user. |
| EndDate | Date | Date when this preferred merchant list is no longer applicable. |
| ExpenseTypeId [KEY] | Long | Value that uniquely identifies the parent expense type. |
| LastUpdateDate | Datetime | Date when the preferred merchant list was last updated. |
| LastUpdateLogin | String | Session login that's associated with the user who last updated the preferred merchant list. |
| LastUpdatedBy | String | User who last updated the preferred merchant list. |
| MerchantListName | String | Lookup type name that provides name of the preferred merchant list. |
| MerchantListType [KEY] | String | Lookup type code of the preferred merchant list. |
| PolicyEnforcement | String | Type of policy enforcement applied to this preferred merchant list. Values are from lookup EXM_PREFERRED_ENFORCEMENT. |
| PolicyEnforcementCode | String | Code of policy enforcement applied to this preferred merchant list. Values are from lookup EXM_PREFERRED_ENFORCEMENT. |
| StartDate [KEY] | Date | Date when this preferred merchant list is applicable. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ExpenseTemplateId | Long | ExpenseTemplateId |
| BindDate | Date | bindDate |
| BindOrgId | Long | bindOrgId |
| Finder | String | finder |