PreferredCurrenciesLOV
Enumerates currency preferences used by users or business units, enabling automated conversions and standardized reporting.
Columns
| Name | Type | Description |
| CurrencyCode [KEY] | String | The unique identifier for the currency in the PreferredCurrenciesLOV table. This is typically a 3-character currency code such as USD or EUR. |
| CurrencyName | String | The full name of the currency, such as USD or EUR, providing more clarity than just the currency code. |
| CurrencyFlag | Bool | Indicates whether the currency is currently flagged for use in transactions or reporting within the system. True signifies that the currency is active and usable. |
| EnabledFlag | Bool | Indicates whether the currency is enabled for use in the system. A value of True means the currency can be used in financial transactions, while False means it is disabled. |
| DisplaySequence | Long | The sequence number that determines the order in which currencies are displayed in user interfaces or reports, allowing for a customized presentation of currency options. |
| StartDateActive | Date | The date when the currency became active and available for use within the system. This is the date from which the currency can be selected for financial transactions. |
| EndDateActive | Date | The date when the currency was deactivated or is no longer available for use. After this date, the currency cannot be selected for transactions. |
| Precision | Int | The number of decimal places to which the currency values can be rounded. For example, USD might have a precision of 2 (representing two decimal places). |
| MinimumAccountableUnit | Decimal | The smallest possible unit of the currency that can be accounted for in transactions. For example, in some currencies, this could represent the smallest coin unit like 'cent' in USD. |
| Symbol | String | The symbol associated with the currency, such as '$' for USD or '€' for EUR. This is used in financial reports or interfaces to denote the currency. |
| LedgerSetId | Long | The unique identifier linking the currency to a specific ledger set. This is used to group different currencies for specific ledgers within the financial system. |
| ExtendedPrecision | Int | The number of additional decimal places (beyond the typical precision) used for certain currencies when higher precision is needed for specific calculations. |
| IssuingTerritoryCode | String | The code of the geographical territory or country that issues the currency. For example, US. |
| Name | String | A descriptive name for the currency record in the system, which can be used for easy reference within reports or financial records. |
| CurrencyFormat | String | The format in which the currency is displayed in reports or transactions, typically specifying the placement of the symbol, such as 'USD 100.00'. |
| CurrencyFormatWithSymbol | String | The format for displaying the currency along with its symbol, for example, '$100.00' or '€100.00', ensuring the correct visual representation of the currency. |
| CurrencyFormatWithCode | String | The format used to display the currency along with its code, such as 'USD 100.00', which includes both the currency symbol and the ISO code. |
| BindCurrencyEnabledFlag | String | Indicates whether the binding of the currency to a ledger or report is enabled. This flag helps manage the association between the currency and its usage. |
| BindEndDate | Date | The end date for the binding of the currency to a particular ledger set or financial report. After this date, the currency is no longer associated with the binding. |
| BindLedgerSetId | Long | The identifier for the ledger set with which the currency is bound. This links the currency to specific financial ledgers. |
| BindStartDate | Date | The start date for the binding of the currency to a specific ledger or financial report. This is the date when the currency begins being used in the designated context. |
| Finder | String | A unique identifier or search term used to find and reference this currency record within the system. Useful for locating specific currency data during searches. |
| SearchTerm | String | A text field that is used to search for specific currencies or records related to the currency in the system, improving the efficiency of searching for currency data. |