ExpenseConversionRateOptions
Establishes expense-specific conversion rate policies for multiple currencies, ensuring correct reimbursement calculations.
Columns
Name | Type | Description |
ConversionRateId [KEY] | Long | The unique identifier for the conversion rate in the ExpenseConversionRateOptions table, used to distinguish different conversion rate records. |
CreatedBy | String | The user or system responsible for creating the record in the ExpenseConversionRateOptions table, providing auditability of data creation. |
CreationDate | Datetime | The date and time when the record in the ExpenseConversionRateOptions table was created, used for tracking the creation timeline. |
DefaultConversionRateFlag | Bool | A flag indicating whether the conversion rate is the default one for the given business unit or expense type, influencing automatic rate selection. |
DisplayWarningToUser | String | A message or instruction displayed to the user, alerting them of important details or actions related to the expense conversion rate. |
ErrorTolerance | Decimal | The acceptable margin of error when applying the conversion rate to expenses, ensuring calculations are within a defined range of accuracy. |
ConversionRateType | String | The type of conversion rate (for example, fixed, dynamic) used in the ExpenseConversionRateOptions, specifying the method for calculating expense conversions. |
LastUpdateDate | Datetime | The date and time when the record in the ExpenseConversionRateOptions table was last updated, useful for tracking changes to the conversion rate configuration. |
LastUpdateLogin | String | The login ID of the user who last updated the record in the ExpenseConversionRateOptions table, providing accountability for changes. |
LastUpdatedBy | String | The name or ID of the user who last modified the record in the ExpenseConversionRateOptions table, allowing for audit and tracking of updates. |
WarningTolerance | Decimal | The threshold at which a warning is triggered when the expense conversion exceeds an acceptable tolerance level, helping to catch potential errors. |
BusinessUnit | String | The business unit associated with the conversion rate, enabling the system to apply specific rates based on organizational structure or financial requirements. |
Finder | String | A search identifier or criteria used within the ExpenseConversionRateOptions table, helping users or the system locate relevant conversion rate records quickly. |