Table Currency

Unique identifier code for the currency (e.g., USD, EUR, GBP). This field is required and must be non-blank.

Date when the currency record was last modified. This field is automatically maintained by the system.

Date when the currency exchange rates were last adjusted. This field is automatically maintained by the system.

Three-letter ISO 4217 currency code (e.g., USD, EUR, GBP). Must be exactly 3 characters and contain only ASCII letters.

Three-digit ISO 4217 numeric currency code (e.g., 840 for USD, 978 for EUR). Must be exactly 3 characters and contain only numeric digits.

General Ledger account for posting unrealized currency gains. Used when currency exchange rates fluctuate positively between transaction and revaluation dates.

General Ledger account for posting realized currency gains. Used when currency gains are actually realized through settlement of transactions.

General Ledger account for posting unrealized currency losses. Used when currency exchange rates fluctuate negatively between transaction and revaluation dates.

General Ledger account for posting realized currency losses. Used when currency losses are actually realized through settlement of transactions.

Precision used for rounding invoice amounts in this currency. Determines the smallest unit to which invoice totals are rounded (e.g., 0.01 for cents). Must be compatible with the Amount Rounding Precision setting.

Method used for rounding invoice amounts when applying Invoice Rounding Precision. Options: Nearest (standard rounding), Up (always round up), Down (always round down).

Precision used for rounding general amounts in this currency. Determines the smallest unit to which amounts are rounded during calculations.

Precision used for rounding unit amounts (prices, rates) in this currency. Typically has higher precision than amount rounding for detailed calculations.

Descriptive name for the currency (e.g., "US Dollar", "Euro", "British Pound").

Format specification for displaying amounts in this currency. Defines minimum and maximum decimal places (e.g., "2:2" for exactly 2 decimal places).

Format specification for displaying unit amounts (prices, rates) in this currency. Typically allows more decimal places than regular amounts for precise calculations.

Flow filter to restrict calculations to a specific customer. Used with calculated fields to show customer-specific currency balances.

Flow filter to restrict calculations to a specific vendor. Used with calculated fields to show vendor-specific currency balances.

Flow filter to restrict calculations to a specific global dimension 1 value. Used with calculated fields for dimensional analysis of currency balances.

Flow filter to restrict calculations to a specific global dimension 2 value. Used with calculated fields for dimensional analysis of currency balances.

Flow filter to restrict calculations to a specific date or date range. Used with calculated fields to show currency balances as of specific dates.

Calculated field indicating whether customer ledger entries exist matching the current filters. Used to determine if customer balance calculations will return meaningful results.

Calculated customer balance in this currency based on detailed customer ledger entries. Amount is filtered by Customer Filter, dimension filters, and date filter settings.

Calculated total of outstanding customer orders in this currency. Shows the sum of undelivered sales order amounts for the filtered customer.

Calculated total of shipped but not yet invoiced customer orders in this currency. Shows the sum of goods delivered but not yet billed to the customer.

Calculated customer balance due in this currency based on due dates. Shows amounts that are due for payment as of the specified date filter.

Calculated field indicating whether vendor ledger entries exist matching the current filters. Used to determine if vendor balance calculations will return meaningful results.

Calculated vendor balance in this currency based on detailed vendor ledger entries. Amount is filtered by Vendor Filter, dimension filters, and date filter settings. Note: Amount is negated to show payable amounts as positive values.

Calculated total of outstanding vendor orders in this currency. Shows the sum of unreceived purchase order amounts for the filtered vendor.

Calculated total of received but not yet invoiced vendor orders in this currency. Shows the sum of goods received but not yet billed by the vendor.

Calculated vendor balance due in this currency based on due dates. Shows amounts that are due for payment as of the specified date filter. Note: Amount is negated to show payable amounts as positive values.

Calculated customer balance in Local Currency (LCY) equivalent. Shows the same balance as Customer Balance but converted to local currency amounts.

Calculated vendor balance in Local Currency (LCY) equivalent. Shows the same balance as Vendor Balance but converted to local currency amounts. Note: Amount is negated to show payable amounts as positive values.

General Ledger account for posting realized currency gains on GL transactions. Used specifically for GL account postings as opposed to customer/vendor transactions.

General Ledger account for posting realized currency losses on GL transactions. Used specifically for GL account postings as opposed to customer/vendor transactions.

Precision used for rounding amounts during payment application processes. Determines the tolerance allowed when applying payments to invoices in this currency.

Indicates whether this currency is part of the European Monetary Union (EMU). Used for special handling of Euro-related currencies and conversion logic.

System-calculated factor used in currency conversion calculations. This field is automatically maintained and should not be manually edited.

General Ledger account for posting residual currency gains. Used for small rounding differences that occur during currency conversions.

General Ledger account for posting residual currency losses. Used for small rounding differences that occur during currency conversions.

General Ledger account for posting debit rounding differences during LCY conversion. Used when converting foreign currency amounts to local currency creates rounding differences.

General Ledger account for posting credit rounding differences during LCY conversion. Used when converting foreign currency amounts to local currency creates rounding differences.

Maximum VAT difference amount allowed for transactions in this currency. Defines the tolerance for VAT calculation discrepancies during currency conversions. The amount is automatically rounded to the currency's Amount Rounding Precision.

Method used for rounding VAT amounts in this currency. Options: Nearest (standard rounding), Up (always round up), Down (always round down).

Payment tolerance percentage allowed for this currency. This field is automatically maintained by the system and cannot be edited directly.

Maximum payment tolerance amount allowed for this currency. This field is automatically maintained by the system and cannot be edited directly.

Display symbol for the currency (e.g., $, €, £). If not specified, the system will attempt to resolve an appropriate symbol automatically.

Timestamp of when the currency record was last modified. This field is automatically maintained by the system.

Specifies the position of the currency symbol in relation to the amount.

Calculated field indicating whether this currency record is coupled to Microsoft Dataverse. Used for integration scenarios where currency data is synchronized between systems.