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. |