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 |