ExpenseTemplatesexpenseTypespreferredAgencyLists

Columns


Name	Type	Description
ExpenseTemplatesExpenseTemplateId [KEY]	Long	ExpenseTemplatesExpenseTemplateId of ExpenseTemplatesexpenseTypespreferredAgencyLists
ExpensetypesExpenseTypeId [KEY]	Long	Unique identifier of an expense type in an expense template.
AgencyListName	String	Lookup type name that provides name of the preferred agency list.
AgencyListType [KEY]	String	Lookup type code of the preferred agency list.
CreatedBy	String	User who created the preferred agency list.
CreationDate	Datetime	Date when the preferred agency list was created.
DispWarningToUserFlag	Bool	Indicates whether policy warning is displayed to user.
EndDate	Date	Date when this preferred agency list is no longer applicable.
ExpenseTypeId [KEY]	Long	Value that uniquely identifies the parent expense type.
LastUpdatedBy	String	User who last updated the preferred agency list.
LastUpdateDate	Datetime	Date when the preferred agency list was last updated.
LastUpdateLogin	String	Session login that's associated with the user who last updated the preferred agency list.
PolicyEnforcement	String	Type of policy enforcement applied to this preferred agency list. Values are from lookup EXM_PREFERRED_ENFORCEMENT.
PolicyEnforcementCode	String	Code of policy enforcement applied to this preferred agency list. Values are from lookup EXM_PREFERRED_ENFORCEMENT.
StartDate [KEY]	Date	Date when this preferred agency list is applicable.

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