Diagrams


Table

Inventory Period Entry

Fields

# Name Type
1 Entry No. Integer NotBlank: Yes
2 Ending Date Date NotBlank: Yes
3 User ID Code50
4 Creation Date Date
5 Creation Time Time
6 Closing Item Register No. Integer
7 Entry Type Option Editable: No
8 Description Text50

Keys

# Fields
0 Ending Date,Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Ending Date Inventory Period Ending Date 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field