Diagrams

Table

Substitution Condition

DynamicsDocs.comSubstitution Condition«Table 5716»Substitution ConditionNo. [PK]Variant Code [PK]Substitute No. [PK]Substitute Variant Code [PK]Line No. [PK]ConditionType; [Item,Nonstock Item] [PK]Substitute Type; [Item,Nonstock Item]...«Table 5715»Item SubstitutionNo. [PK,NN]Variant Code [PK]Substitute No. [PK,NN]Substitute Variant Code [PK]DescriptionInventoryInterchangeableConditionLocation FilterType; [Item,Nonstock Item] [PK]Substitute Type; [Item,Nonstock Item]...Sub. Item No.Relations LevelQuantity Avail. on Shpt. DateShipment Date<No.><Variant Code><Substitute No.><Substitute Variant Code>

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

Fields

# Name Type
1 No. (No.) Code20
2 Variant Code (Variant Code) Code10
3 Substitute No. (Substitute No.) Code20
4 Substitute Variant Code (Substitute Variant Code) Code10
5 Line No. (Line No.) Integer
6 Condition (Condition) Text80
100 Type (Type) Option
101 Substitute Type (Substitute Type) Option

Keys

# Fields
0 Type,No.,Variant Code,Substitute Type,Substitute No.,Substitute Variant Code,Line No. (Type,No.,Variant Code,Substitute Type,Substitute No.,Substitute Variant Code,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Substitute Variant Code (Substitute Variant Code) Item Substitution Substitute Variant Code (Substitute Variant Code) 1..n

Table Relations From Other Tables

From Table From Field