Diagrams


Table

Warehouse Class

DynamicsDocs.comWarehouse Class«Table 7304»Warehouse ClassCode [PK,NN]Description«Table 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class Code«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 5723»Product GroupItem Category Code [PK,NN]Code [PK,NN]DescriptionWarehouse Class Code«Table 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7335»Bin TemplateCode [PK,NN]DescriptionLocation Code [NN]Bin DescriptionZone CodeBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightDedicated«Table 7338»Bin Creation Worksheet LineWorksheet Template Name [PK]Name [PK]Line No. [PK]Type; [Bin,Bin Content]Location Code [PK,NN]Zone CodeBin Code [NN]Item No. [NN]DescriptionBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Special Equipment CodeBin RankingMaximum CubageMaximum WeightFixedDefaultCross-Dock BinUser IDVariant CodeQty. per Unit of MeasureUnit of Measure Code [NN]Dedicated«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated<Warehouse Class Code><Warehouse Class Code><Warehouse Class Code><Warehouse Class Code><Warehouse Class Code><Warehouse Class Code><Warehouse Class Code><Warehouse Class Code><Alternative Item No.><Bin Filter><Item Filter><Item No.><Item No.><Zone Code><Zone Code><Zone Code><Zone Code><Bin Code>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Bin Warehouse Class Code 1..n
Bin Content Warehouse Class Code 1..n
Bin Creation Worksheet Line Warehouse Class Code 1..n
Bin Template Warehouse Class Code 1..n
Item Warehouse Class Code 1..n
Item Template Warehouse Class Code 1..n
Product Group Warehouse Class Code 1..n
Zone Warehouse Class Code 1..n