Currency Profile Schema
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 |