Currencies
Table name: currencies
Contains currency configuration data for partner systems. Provides essential currency information including names, codes, and decimal precision settings.
SQL: currencies
Schema
| Column Name | Data Type | Description |
|---|---|---|
| Primary ID | ||
| id | INTEGER | Primary key |
| Timestamps | ||
| created_at | TIMESTAMP_NTZ | Timestamp when the currency record was first created |
| updated_at | TIMESTAMP_NTZ | Timestamp when the currency record was last modified |
| Attributes | ||
| identifier | VARCHAR | Standard currency code identifier (e.g. USD, EUR, GBP) used for external reference |
| name | VARCHAR | Full display name of the currency (e.g. US Dollar, Euro, British Pound) |
| currency | VARCHAR | Three-letter ISO currency code used for transactions and reporting |
| decimals | INTEGER | Number of decimal places used for currency precision in calculations and display |
Data Inclusion Creiteria
- is not deleted
Updated 20 days ago
Did this page help you?