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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。