Currency Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The Currency table in the profiles database contains information about the currencies that the Commerce Server 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.

See Also

Other Resources

Profiles System Database Tables