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