Diagrams


Table

Item Availability by Date

Fields

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

Keys

# Fields
0 Item No.,Variant Code,Location Code,Date (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