Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ExpenseTypespreferredAgencyLists

Links preferred agency details (for example, travel agencies) to particular expense types, helping users select valid partners.

Columns

Name Type Description
ExpenseTypesExpenseTypeId [KEY] Long Unique identifier for the expense type in the ExpenseTypespreferredAgencyLists table, linking the preferred agency list to its corresponding expense type.
AgencyListName String Name of the agency list associated with the expense type, used to identify and manage different agency lists.
AgencyListType [KEY] String Type of the agency list, specifying whether it is a preferred, recommended, or other category of agency list within the expense type.
CreatedBy String Username of the individual who created the preferred agency list record, ensuring accountability for data entry.
CreationDate Datetime Timestamp indicating 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, alerting them to potential issues or restrictions.
EndDate Date End date when the preferred agency list becomes inactive, marking the expiration of its validity for the associated expense type.
ExpenseTypeId [KEY] Long Unique identifier for the expense type linked to the preferred agency list, categorizing the list under specific types of expenses.
LastUpdatedBy String Username of the individual who last modified the preferred agency list, ensuring accountability for updates.
LastUpdateDate Datetime Timestamp of the most recent update to the preferred agency list, helping track changes and maintain accuracy.
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, ensuring that only approved agencies are selected based on company rules.
PolicyEnforcementCode String Code that defines the specific policy enforcement rule applied to the preferred agency list, ensuring consistency in the application of policies.
StartDate [KEY] Date Start date when the preferred agency list becomes valid, marking the beginning of its applicability 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.
BindTemplateId Long Unique identifier for the template to which the preferred agency list is bound, linking the list to a specific expense template.
Finder String Search term or identifier used to locate and filter preferred agency list records within the system, making it easier to retrieve specific lists.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434