Diagrams


Table

Currency Exchange Rate

Fields

# Name Type
1 Currency Code (Currency Code) Code10 NotBlank: Yes
Editable: No
2 Starting Date (Starting Date) Date NotBlank: Yes
3 Exchange Rate Amount (Exchange Rate Amount) Decimal (1:6)
4 Adjustment Exch. Rate Amount (Adjustment Exch. Rate Amount) Decimal (1:6)
5 Relational Currency Code (Relational Currency Code) Code10
6 Relational Exch. Rate Amount (Relational Exch. Rate Amount) Decimal (1:6)
7 Fix Exchange Rate Amount (Fix Exchange Rate Amount) Option
8 Relational Adjmt Exch Rate Amt (Relational Adjmt Exch Rate Amt) Decimal (1:6)

Keys

# Fields
0 Currency Code,Starting Date (Currency Code,Starting Date) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Relational Currency Code (Relational Currency Code) Currency Code (Code) 1..n

Table Relations From Other Tables

From Table From Field