ExpenseTemplatesexpenseTypespreferredAgencyLists
Associates preferred travel or service agencies with specific expense types in an expense template, ensuring employees use approved vendors.
Columns
| Name | Type | Description |
| ExpenseTemplatesExpenseTemplateId [KEY] | Long | Unique identifier for the expense template in the ExpenseTemplatesexpenseTypespreferredAgencyLists table, used to reference the specific template associated with preferred agency lists. |
| ExpensetypesExpenseTypeId [KEY] | Long | Unique identifier for the expense type in the ExpenseTemplatesexpenseTypespreferredAgencyLists table, categorizing the preferred agency list by its specific expense type. |
| AgencyListName | String | Name of the agency list, used to identify and differentiate various agency lists within the expense template. |
| AgencyListType [KEY] | String | Type of the agency list, specifying whether it is a list for preferred agencies, recommended agencies, or another category. |
| CreatedBy | String | Username of the individual who created the preferred agency list, ensuring accountability for data entry. |
| CreationDate | Datetime | Timestamp of when the preferred agency list was created, providing a reference for when the record was established. |
| DispWarningToUserFlag | Bool | Flag indicating whether a warning should be displayed to the user when selecting an agency from the list, used for compliance and guidance. |
| EndDate | Date | End date of the validity period for the preferred agency list, marking when the list is no longer applicable. |
| ExpenseTypeId [KEY] | Long | Unique identifier for the expense type associated with the preferred agency list, linking the list to a specific category of expenses. |
| LastUpdatedBy | String | Username of the individual who last updated the preferred agency list, providing accountability for changes made to the record. |
| LastUpdateDate | Datetime | Timestamp of the most recent update made to the preferred agency list, helping to track modifications and maintain accurate records. |
| LastUpdateLogin | String | Session login associated with the user who last updated the record, ensuring traceability for updates. |
| PolicyEnforcement | String | Describes how policy enforcement is applied to the preferred agency list, such as whether only certain agencies are allowed based on company policy. |
| PolicyEnforcementCode | String | Code that defines the specific policy enforcement rule applied to the preferred agency list, used for consistent application of rules. |
| StartDate [KEY] | Date | Start date for the preferred agency list, marking the beginning of its validity period within the expense template. |
| BindDate | Date | Date when the preferred agency list is bound to a specific record or context, making it applicable from that point onward. |
| BindOrgId | Long | Unique identifier for the organization to which the preferred agency list is bound, ensuring that the list is linked to the correct organization. |
| ExpenseTemplateId | Long | Unique identifier for the expense template that the preferred agency list is associated with, linking the agency list to a specific template. |
| Finder | String | Search term or identifier used to locate and display specific preferred agency list records, making data retrieval more efficient. |