Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
RATE
|
decimal(20, 8)
|
false
|
|
The rate to use when performing the conversion.
|
|
ASOFDATE
|
datetime
|
false
|
|
The date for which the exchange rate is valid.
|
|
ASOFTIME
|
time
|
false
|
|
The time for which the exchange rate is valid.
|
|
TYPECODE
|
tinyint
|
false
|
|
The type of the exchange rate.
|
|
SEQUENCE
|
int
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
TYPE
|
nvarchar(9) (Computed)
|
true
|
|
Provides a translation for the 'TYPECODE' field.
|
