usm_exchange_rate

Persists the mappings between different exchange rates based on currency. The rate is always stored relative to the SP currency. So to convert from one currency to another currency where neither is the SP currency, you first convert to the first currency then convert to the second currency.

Column Name Column Datatype Column Null Option Column Comment
currency varchar(50) not null the value as used in iCanView that is stored in the tenant. Currently this is an integer value stored in a string field
exchange_date date not null The dat the exchange rate took affect
symbol_1 varchar(8) with null The text abbreviation of the currency (ie: USD, GBP, etc)
symbol_2 varchar(16) with null the actual symbo used (ie: $ )
rate varchar(64) with null A multiplying factor

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.