Diagrams


Table

Sales Prepayment %

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

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

Keys

# Fields
0 Item No.,Sales Type,Sales Code,Starting Date Clustered: Yes
1 Sales Type,Sales Code

Table Relations To Other Tables

Field Related Table Related Field
Sales Code Customer No. 1..n
Sales Code Customer Price Group Code 1..n
Item No. Item No. 1..n

Table Relations From Other Tables

From Table From Field