Diagrams

Table

Item Substitution

DynamicsDocs.comItem Substitution«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«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 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Template CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...<No.><Substitute No.><No.><Substitute No.><Variant Code><Substitute Variant Code><Location Filter><No.><Variant Code><Substitute No.><Substitute Variant Code><Alternative Item No.><Location Filter><Variant Filter><Item No.><Item No.>

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 NotBlank: Yes
2 Variant Code (Variant Code) Code10
3 Substitute No. (Substitute No.) Code20 NotBlank: Yes
4 Substitute Variant Code (Substitute Variant Code) Code10
5 Description (Description) Text50 Editable: No
6 Inventory (Inventory) Decimal (0:5)
7 Interchangeable (Interchangeable) Boolean
8 Condition (Condition) Boolean Editable: No
FlowField
9 Location Filter (Location Filter) Code10 FlowFilter
100 Type (Type) Option
101 Substitute Type (Substitute Type) Option
102 Sub. Item No. (Sub. Item No.) Code20 Editable: No
FlowField
103 Relations Level (Relations Level) Integer Editable: No
104 Quantity Avail. on Shpt. Date (Quantity Avail. on Shpt. Date) Decimal (0:5)
105 Shipment Date (Shipment Date) Date

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Substitute No. (Substitute No.) Item No. (No.) 1..n
Substitute Variant Code (Substitute Variant Code) Item Variant Code (Code) 1..n
Location Filter (Location Filter) Location Code (Code) 1..n
Substitute No. (Substitute No.) Nonstock Item Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field
Substitution Condition Substitute Variant Code (Substitute Variant Code) 1..n