Diagrams

Table

Product Group

DynamicsDocs.comProduct Group«Table 5723»Product GroupItem Category Code [PK,NN]Code [PK,NN]DescriptionWarehouse Class Code«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas Children«Table 7304»Warehouse ClassCode [PK,NN]Description<Item Category Code><Warehouse Class Code><Parent Category>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Item Category Code (Item Category Code) Code20 NotBlank: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Description (Description) Text50
7300 Warehouse Class Code (Warehouse Class Code) Code10

Keys

# Fields
0 Item Category Code,Code (Item Category Code,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item Category Code (Item Category Code) Item Category Code (Code) 1..n
Warehouse Class Code (Warehouse Class Code) Warehouse Class Code (Code) 1..n

Table Relations From Other Tables

From Table From Field