Currency Table
The Currency table in the profiles database contains information about the currencies that the Commerce Server Core Systems application recognizes.
The following table describes the columns in the Currency table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_currency_code |
nvarchar(50) |
no |
The currency code. This is the primary key. |
u_currency_culture |
nvarchar(50) |
no |
The currency culture. |
d_conversion_factor |
decimal(38,6) |
no |
The number by which to multiply an item's price in order to convert to the price in this currency. |
u_user_id_changed_by |
nvarchar(50) |
yes |
The Microsoft Windows user ID of the person who last modified the currency record. |
dt_date_last_changed |
datetime |
yes |
The date that changes were last made to the currency record. |
dt_csadapter_date_last_changed |
datetime |
yes |
The date the currency record was last updated by BizTalk Server. |
dt_date_created |
datetime |
yes |
The date the currency record was created. |