Diagrams


Table

Purchase Prepayment %

Fields

# Name Type
1 Item No. Code20 NotBlank: Yes
2 Vendor No. Code20
3 Starting Date Date
4 Ending Date Date
5 Prepayment % Decimal (0:5)

Keys

# Fields
0 Item No.,Vendor No.,Starting Date Clustered: Yes
1 Vendor No.

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field