Diagrams


Table

Item Availability by Date

Fields

# Name Type
1 Item No. Code20
2 Date Date
3 Available Qty Decimal
4 Updated Available Qty Decimal
5 Variant Code Code10
6 Location Code Code10

Keys

# Fields
0 Item No.,Variant Code,Location Code,Date Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field