This table holds information used to convert currencies in customer orders.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
DAY_ID | varchar | 40 | No | Primary key component. Foreign key to ARF_TIME_DAY.ID column. |
SRC_CURRENCY_ID | smallint | No | Currency to be converted from. Primary key component. Foreign key to ARF_CURRENCY.ID column. | |
DST_CURRENCY_ID | smallint | No | Currency to be converted to. Primary key component. Foreign key to ARF_CURRENCY.ID column. | |
SRC_DST_CONVERSION_RATE | 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. | |
DST_SRC_CONVERSION_RATE | 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. |