Diagrams


Table

Record Buffer

Fields

# Name Type
1 Entry No. (Entry No.) Integer
3 Table No. (Table No.) Integer
4 Table Name (Table Name) Text250 Editable: No
5 Record Identifier (Record Identifier) RecordID Editable: No
6 Search Record ID (Search Record ID) Code100 Editable: No
7 Primary Key (Primary Key) Text250 Editable: No
8 Primary Key Field 1 No. (Primary Key Field 1 No.) Integer
9 Primary Key Field 1 Name (Primary Key Field 1 Name) Text80 FlowField
10 Primary Key Field 1 Value (Primary Key Field 1 Value) Text50
11 Primary Key Field 2 No. (Primary Key Field 2 No.) Integer
12 Primary Key Field 2 Name (Primary Key Field 2 Name) Text80 FlowField
13 Primary Key Field 2 Value (Primary Key Field 2 Value) Text50
14 Primary Key Field 3 No. (Primary Key Field 3 No.) Integer
15 Primary Key Field 3 Name (Primary Key Field 3 Name) Text80 FlowField
16 Primary Key Field 3 Value (Primary Key Field 3 Value) Text50
17 Level (Level) Integer
20 Serial No. (Serial No.) Code20
21 Lot No. (Lot No.) Code20
22 Item No. (Item No.) Code20
23 Variant Code (Variant Code) Code10

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Table No.,Search Record ID (Table No.,Search Record ID)
2 Search Record ID (Search Record ID)

Table Relations To Other Tables

Field Related Table Related Field
Primary Key Field 3 No. (Primary Key Field 3 No.) Field No. (No.) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n

Table Relations From Other Tables

From Table From Field