About This Guide > ExchangeRate
  
ExchangeRate
Exchange Rate
 
 
Field Name
Label
Col-Label
Format
Dec
 
ExchangeRate
Exchange Rate
Rate
->,>>>,>>9.9999999999
10
 
ExchangeRate_ID
Record ID
 
9999999999
 
 
ExchangeRateScale
Scale Factor
 
->,>>>,>>9.9999999999
10
 
ExchangeRateType_ID
Exchange Rate Type
Rate Type
9999999999
 
 
ExchangeRateValidDateFrom
Valid from
 
99/99/9999
 
 
ExchangeRateValidDateTill
Valid to
 
99/99/9999
 
 
FromCurrency_ID
From Currency Code
From Curr
9999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SharedSet_ID
Link to SharedSet
 
9999999999
 
 
ToCurrency_ID
To Currency Code
To Curr
9999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CombiTillIdx
no
SharedSet_ID
yes
no
 
 
 
FromCurrency_ID
yes
no
 
 
 
ToCurrency_ID
yes
no
 
 
 
ExchangeRateValidDateTill
yes
no
 
CombiTypeTillIdx
no
SharedSet_ID
yes
no
 
 
 
FromCurrency_ID
yes
no
 
 
 
ToCurrency_ID
yes
no
 
 
 
ExchangeRateType_ID
yes
no
 
 
 
ExchangeRateValidDateTill
yes
no
 
DateFrom
no
ExchangeRateValidDateFrom
yes
no
 
DateTill
no
ExchangeRateValidDateTill
yes
no
 
FromCurrency
no
FromCurrency_ID
yes
no
 ∗
Prim
yes
ExchangeRate_ID
yes
no
 
RateType
no
ExchangeRateType_ID
yes
no
 
SharedSet
no
SharedSet_ID
yes
no
 
ToCurrency
no
ToCurrency_ID
yes
no
 
UniqueIndex
yes
SharedSet_ID
yes
no
 
 
 
ExchangeRateType_ID
yes
no
 
 
 
FromCurrency_ID
yes
no
 
 
 
ToCurrency_ID
yes
no
 
 
 
ExchangeRateValidDateFrom
yes
no