ExpenseTypespreferredMerchantLists
ExpenseTypespreferredMerchantLists
Columns
Name | Type | Description |
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
BindDate | Date | bindDate |
BindTemplateId | Long | bindTemplateId |
Finder | String | finder |