Diagrams


Table

Inventory Period Entry

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field