Currency Profile Schema

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

An instance of this profile schema stores currency information. The profile is mapped to the physical Currency table. No Currency fields are exported by default into the Data Warehouse. For information about the table entries, see Conventions.

Property Name

Data

Type

Req

Exp

Group

Display Name/

Description

currency_code (primary and join key)

Unicode String

T

F

GeneralInfo

ISO 4217 currency code

currency_culture

Unicode String

T

F

GeneralInfo

Culture used to format the currency

conversion_factor

Float

T

F

GeneralInfo

Currency difference coefficient

user_id_changed_by

Unicode String

F

F

ProfileSystem

ID of the user that last changed this currency

date_last_changed

Date Time

F

F

ProfileSystem

Date that this currency was last changed

date_created

Date Time

F

F

ProfileSystem

Date that this currency was created

csadapter_date_last_changed

Date Time

F

F

ProfileSystem

Reserved for BizTalk adapter functionality

See Also

Other Resources

Address Profile Schema

BlanketPOs Profile Schema

CreditCard Profile Schema

Organization Profile Schema

UserObject Profile Schema

Profiles Schema