Diagrams


Table

Currency Exchange Rate

Fields

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

Keys

# Fields
0 Currency Code,Starting Date Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field