ExpenseTemplatesexpenseTypespreferredAgencyLists
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. |
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 |