CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ExpenseConversionRateOptionsconversionRateTolerances

Defines allowable variances in currency conversion rates for certain currencies or business units, supporting exceptions in expense reimbursements.

Columns

Name Type Description
ExpenseConversionRateOptionsConversionRateId [KEY] Long The unique identifier for the conversion rate option associated with a specific tolerance in the ExpenseConversionRateOptions conversion rate tolerance table.
ConversionRateToleranceId [KEY] Long The unique identifier for the tolerance rule applied to the conversion rate in the ExpenseConversionRateOptions conversion-rate tolerance table.
CreatedBy String The user or system responsible for creating the record in the ExpenseConversionRateOptions conversion-rate tolerance table.
CreationDate Datetime The date and time when the record was created in the ExpenseConversionRateOptions conversion-rate tolerance table.
CurrencyCode String The code representing the currency for which the conversion rate tolerance is defined in the ExpenseConversionRateOptions table.
DefaultConversionRateFlag Bool A flag indicating whether this conversion rate is the default for the specified tolerance in the ExpenseConversionRateOptions table (true if default).
DisplayWarningToUser String A message or instruction to display to the user when the conversion rate tolerance is exceeded in the ExpenseConversionRateOptions table.
ErrorTolerance Decimal The threshold value for error tolerance, defining the acceptable deviation from the expected conversion rate in the ExpenseConversionRateOptions table.
ConversionRateId Long The unique identifier for the conversion rate that is being applied in the ExpenseConversionRateOptions conversion-rate tolerance table.
LastUpdateDate Datetime The date and time when the record was last updated in the ExpenseConversionRateOptions conversion-rate tolerance table.
LastUpdateLogin String The login identifier of the user or system that last updated the record in the ExpenseConversionRateOptions conversion-rate tolerance table.
LastUpdatedBy String The name or identifier of the user or system that last updated the record in the ExpenseConversionRateOptions conversion-rate tolerance table.
WarningTolerance Decimal The threshold value for warning tolerance, defining the acceptable range before triggering a warning to the user in the ExpenseConversionRateOptions table.
Currency String The currency being considered in the ExpenseConversionRateOptions conversion-rate tolerance table, used to determine applicable conversion rates.
Finder String An identifier or reference used to locate specific records or sets of records within the ExpenseConversionRateOptions conversion-rate tolerance table.

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