ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

ExpenseTypespreferredMerchantLists

Catalogs approved merchants for specific expense types, ensuring policy compliance and negotiated rates.

Columns

Name Type Description
ExpenseTypesExpenseTypeId [KEY] Long Unique identifier for the expense type in the ExpenseTypespreferredMerchantLists table, linking the preferred merchant list to its corresponding expense type.
CreatedBy String Username of the individual who created the preferred merchant list, ensuring accountability for record creation.
CreationDate Datetime Timestamp indicating when the preferred merchant list was created, providing a reference for tracking its establishment.
DispWarningToUserFlag Bool Flag indicating whether a warning should be displayed to the user when selecting a merchant from the list, alerting them to potential restrictions or compliance issues.
EndDate Date End date when the preferred merchant 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 merchant list, categorizing the list under specific types of expenses.
LastUpdateDate Datetime Timestamp of the most recent update made to the preferred merchant list, helping track changes and maintain data accuracy.
LastUpdateLogin String Session login associated with the user who last updated the record, ensuring traceability for updates.
LastUpdatedBy String Username of the individual who last modified the preferred merchant list, providing accountability for updates.
MerchantListName String Name of the preferred merchant list, used to identify and differentiate between various merchant lists within the system.
MerchantListType [KEY] String Type of the merchant list, indicating whether it is a preferred, recommended, or other category of merchant list.
PolicyEnforcement String Describes how policy enforcement is applied to the preferred merchant list, ensuring that merchants comply with company policies and restrictions.
PolicyEnforcementCode String Code that defines the specific policy enforcement rule applied to the preferred merchant list, ensuring consistent policy application.
StartDate [KEY] Date Start date when the preferred merchant list becomes valid, marking the beginning of its applicability within the expense template.
BindDate Date Date when the preferred merchant list is bound to a specific record or context, ensuring its applicability from that point onward.
BindTemplateId Long Unique identifier for the template to which the preferred merchant list is bound, ensuring the list is associated with the correct template.
Finder String Search term or identifier used to locate and filter preferred merchant list records within the system, aiding in efficient data retrieval.

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