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 |