Currencies
Stores currency definitions and exchange rates. This table supports multi-currency transaction handling and standardized monetary value conversion.
Columns
| Name | Type | ReadOnly | Description |
| Conversion_Rate | Decimal | False |
The numerical rate that is used to convert this currency to the system's base currency. This value is applied during financial calculations, reporting normalization, and multi-currency conversions. |
| Created_By | String | True |
The unique identifier (Id) of the user who created the currency record. This field supports audit tracking and record ownership. |
| Date_Entered | Datetime | True |
The date and time when the currency record was created. |
| Date_Modified | Datetime | True |
The date and time when the currency record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the currency record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete behavior and administrative cleanup workflows. |
| Id [KEY] | String | True |
The unique Id of the currency record. |
| Iso4217 | String | False |
The three-letter international currency code that is defined by the ISO 4217 standard (for example, 'USD' or 'EUR'). This field ensures consistency across financial systems and integrations. |
| Name | String | False |
The descriptive name of the currency (for example, 'US Dollar' or 'Euro'). This value is displayed in currency selection menus. |
| Status | String | False |
The current operational state of the currency (for example, 'Active' or 'Inactive'). This field determines whether the currency can be selected in financial transactions. |
| Symbol | String | False |
The symbolic character that represents the currency (for example, '$', '€', or '£'). This value is used in UI display and formatted financial output. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile the currency record across external systems or data integrations. |