This table holds information used to convert currencies in customer orders.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| varchar | 40 | No | Primary key component. Foreign key to |
| smallint | No | Currency to be converted from. Primary key component. Foreign key to | |
| smallint | No | Currency to be converted to. Primary key component. Foreign key to | |
| double | No | Conversion rate from the source to the destination currency. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. | |
| double | No | Conversion rate from the destination to the source currency. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. |