Diagrams

Table

Bin

DynamicsDocs.comBin«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«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...«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 336»Tracking SpecificationEntry No. [PK]Item No.Location CodeQuantity [Base]DescriptionCreation DateSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Item Ledger Entry No.Transfer Item Entry No.Serial No.PositiveQty. per Unit of MeasureAppl.-to Item EntryWarranty DateExpiration DateQty. to Handle [Base]Qty. to Invoice [Base]Quantity Handled [Base]Quantity Invoiced [Base]Qty. to HandleQty. to InvoiceBuffer Status; [,MODIFY,INSERT]Buffer Status2; [,ExpDate blocked]Buffer Value1Buffer Value2Buffer Value3...«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 5407»Prod. Order ComponentStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Prod. Order Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityRemaining QuantityAct. Consumption [Qty]Flushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeItem Low-Level CodeLengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 5520»Unplanned DemandDemand Type; [,Production,Sales,Servic...Demand SubType; [0,1,2,3,4,5,6,7,8,9]...Demand Order No. [PK]Demand Line No. [PK]Demand Ref. No. [PK]Sell-to Customer No.DescriptionDemand DateStatus; [0,1,2,3,4,5,6,7,8,9,10]Item No.Variant CodeLocation CodeQuantity [Base]LevelBin CodeQty. per Unit of MeasureUnit of Measure CodeReserveNeeded Qty. [Base]Special OrderPurchasing Code«Table 5700»Stockkeeping UnitItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionDescription 2Assembly BOMShelf No.Unit CostStandard CostLast Direct CostVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder QuantityCommentLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterInventoryQty. on Purch. OrderQty. on Sales OrderDrop Shipment FilterAssembly Policy; [Assemble-to-Stock,As...Qty. on Assembly OrderQty. on Asm. ComponentQty. on Job OrderTransfer-Level CodeLot Size...«Table 6504»Serial No. InformationItem No. [PK,NN]Variant Code [PK]Serial No. [PK,NN]DescriptionBlockedCommentInventoryDate FilterLocation FilterBin FilterExpired Inventory«Table 6505»Lot No. InformationItem No. [PK,NN]Variant Code [PK]Lot No. [PK,NN]DescriptionTest Quality; [,Good,Average,Bad]Certificate NumberBlockedCommentInventoryDate FilterLocation FilterBin FilterExpired Inventory«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 7324»Whse. Put-away RequestDocument Type; [Receipt,Internal Put-a...Document No. [PK]Location CodeZone CodeBin CodeCompletely Put AwayStatus; [Open,Released]«Table 7325»Whse. Pick RequestDocument Type; [Shipment,Internal Pick...Document Subtype; [0,1,2,3,4,5,6,7,8,9...Document No. [PK,NN]Location Code [PK]Zone CodeBin CodeStatus; [Open,Released]Completely PickedShipment Method CodeShipping Agent CodeShipping Agent Service Code«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 99000829»Planning ComponentWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityFlushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeRef. Order Status; [Simulated,Planned,...Ref. Order No.Ref. Order Line No.LengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 99000853»Inventory ProfileLine No. [PK]Attribute PriorityOrder PriorityItem No.Variant CodeLocation CodeBin CodeIsSupplyOrder Relation; [Normal,Safety Stock,R...Source TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LinePrimary Order StatusPrimary Order No.Primary Order LinePrimary Order TypeOriginal QuantityRemaining Quantity [Base]Untracked QuantityOriginal Due DateDue DatePlanning Flexibility; [Unlimited,None,...Fixed DateAction Message; [,New,Change Qty.,Resc...Binding; [,Order-to-Order]Quantity [Base]Min. QuantityStarting Date...«Table 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«Table 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick«Table 7304»Warehouse ClassCode [PK,NN]Description«Table 7305»Special EquipmentCode [PK,NN]Description<Location Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Zone Code><Bin Type Code><Warehouse Class Code><Special Equipment Code><Item Filter><Bin Filter><Variant Filter><Bin Filter><Bin Code><Bin Code><Bin Code><Bin Code><Bin Filter><Bin Filter><Bin Code><Bin Code><Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Bin Code><Bin Code><Location Filter><Location Code><Location Code><Location Code><Location Code><Components at Location><Transfer-from Code><Location Filter><Location Filter><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Alternative Item No.><Warehouse Class Code><Special Equipment Code><Item No.><Source No.><Item No.><Original Item No.><Item No.><Item No.><Item No.><Item No.><Item Filter><Item No.><Item No.><Work Center Filter><Capacity No. Filter><Capacity No. Filter><Prod. Order No.><Document No.><Special Equipment Code><Zone Code><Bin Type Code><Warehouse Class Code><Zone Code><Zone Code><Alternate Work Center><Work Center No.><Bin Type Code><Warehouse Class Code><Special Equipment Code>

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

Fields

# Name Type
1 Location Code (Location Code) Code10 NotBlank: Yes
Editable: No
2 Code (Code) Code20 NotBlank: Yes
3 Description (Description) Text50
4 Zone Code (Zone Code) Code10 Editable: No
5 Adjustment Bin (Adjustment Bin) Boolean Editable: No
FlowField
10 Bin Type Code (Bin Type Code) Code10
11 Warehouse Class Code (Warehouse Class Code) Code10
12 Block Movement (Block Movement) Option
20 Special Equipment Code (Special Equipment Code) Code10
21 Bin Ranking (Bin Ranking) Integer
22 Maximum Cubage (Maximum Cubage) Decimal (0:5) BlankZero: Yes
23 Maximum Weight (Maximum Weight) Decimal (0:5) BlankZero: Yes
30 Empty (Empty) Boolean Editable: No
32 Item Filter (Item Filter) Code20 FlowFilter
33 Variant Filter (Variant Filter) Code10 FlowFilter
34 Default (Default) Boolean Editable: No
FlowField
40 Cross-Dock Bin (Cross-Dock Bin) Boolean
41 Dedicated (Dedicated) Boolean

Keys

# Fields
0 Location Code,Code (Location Code,Code) Clustered: Yes
1 Bin Type Code (Bin Type Code)
2 Location Code,Warehouse Class Code,Bin Ranking (Location Code,Warehouse Class Code,Bin Ranking)
3 Location Code,Zone Code,Code (Location Code,Zone Code,Code)
4 Code (Code)

Table Relations To Other Tables

Field Related Table Related Field
Bin Type Code (Bin Type Code) Bin Type Code (Code) 1..n
Item Filter (Item Filter) Item No. (No.) 1..n
Location Code (Location Code) Location Code (Code) 1..n
Special Equipment Code (Special Equipment Code) Special Equipment Code (Code) 1..n
Variant Filter (Variant Filter) Stockkeeping Unit Variant Code (Variant Code) 1..n
Warehouse Class Code (Warehouse Class Code) Warehouse Class Code (Code) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Action Message Entry Bin Code (Bin Code) 1..n
Assembly Header Bin Code (Bin Code) 1..n
Assembly Line Bin Code (Bin Code) 1..n
Bin Content Bin Code (Bin Code) 1..n
Bin Content Buffer Bin Code (Bin Code) 1..n
Internal Movement Header To Bin Code (To Bin Code) 1..n
Internal Movement Line To Bin Code (To Bin Code) 1..n
Inventory Buffer Bin Code (Bin Code) 1..n
Inventory Profile Bin Code (Bin Code) 1..n
Item Bin Filter (Bin Filter) 1..n
Item Journal Line New Bin Code (New Bin Code) 1..n
Job Ledger Entry Bin Code (Bin Code) 1..n
Job Planning Line Bin Code (Bin Code) 1..n
Location Asm.-to-Order Shpt. Bin Code (Asm.-to-Order Shpt. Bin Code) 1..n
Lot No. Information Bin Filter (Bin Filter) 1..n
Machine Center From-Production Bin Code (From-Production Bin Code) 1..n
Planning Component Bin Code (Bin Code) 1..n
Posted Invt. Pick Line Bin Code (Bin Code) 1..n
Posted Invt. Put-away Line Bin Code (Bin Code) 1..n
Posted Whse. Receipt Header Bin Code (Bin Code) 1..n
Posted Whse. Receipt Line Cross-Dock Bin Code (Cross-Dock Bin Code) 1..n
Posted Whse. Shipment Header Bin Code (Bin Code) 1..n
Posted Whse. Shipment Line Bin Code (Bin Code) 1..n
Prod. Order Component Bin Code (Bin Code) 1..n
Prod. Order Line Bin Code (Bin Code) 1..n
Production Order Bin Code (Bin Code) 1..n
Purch. Cr. Memo Line Bin Code (Bin Code) 1..n
Purch. Inv. Line Bin Code (Bin Code) 1..n
Purch. Rcpt. Line Bin Code (Bin Code) 1..n
Purchase Line Bin Code (Bin Code) 1..n
Purchase Line Archive Bin Code (Bin Code) 1..n
Registered Invt. Movement Line Bin Code (Bin Code) 1..n
Registered Whse. Activity Line Bin Code (Bin Code) 1..n
Requisition Line Bin Code (Bin Code) 1..n
Return Receipt Line Bin Code (Bin Code) 1..n
Return Shipment Line Bin Code (Bin Code) 1..n
Sales Cr.Memo Line Bin Code (Bin Code) 1..n
Sales Invoice Line Bin Code (Bin Code) 1..n
Sales Line Bin Code (Bin Code) 1..n
Sales Line Archive Bin Code (Bin Code) 1..n
Sales Shipment Line Bin Code (Bin Code) 1..n
Serial No. Information Bin Filter (Bin Filter) 1..n
Service Cr.Memo Line Bin Code (Bin Code) 1..n
Service Invoice Line Bin Code (Bin Code) 1..n
Service Ledger Entry Bin Code (Bin Code) 1..n
Service Line Bin Code (Bin Code) 1..n
Service Shipment Line Bin Code (Bin Code) 1..n
Standard Item Journal Line Bin Code (Bin Code) 1..n
Stockkeeping Unit Bin Filter (Bin Filter) 1..n
Tracking Specification Bin Code (Bin Code) 1..n
Transfer Line Transfer-To Bin Code (Transfer-To Bin Code) 1..n
Transfer Receipt Line Transfer-To Bin Code (Transfer-To Bin Code) 1..n
Transfer Shipment Line Transfer-from Bin Code (Transfer-from Bin Code) 1..n
Unplanned Demand Bin Code (Bin Code) 1..n
Warehouse Activity Line Bin Code (Bin Code) 1..n
Warehouse Entry Bin Code (Bin Code) 1..n
Warehouse Journal Line To Bin Code (To Bin Code) 1..n
Warehouse Receipt Header Cross-Dock Bin Code (Cross-Dock Bin Code) 1..n
Warehouse Receipt Line Cross-Dock Bin Code (Cross-Dock Bin Code) 1..n
Warehouse Shipment Header Bin Code (Bin Code) 1..n
Warehouse Shipment Line Bin Code (Bin Code) 1..n
Whse. Internal Pick Header To Bin Code (To Bin Code) 1..n
Whse. Internal Pick Line To Bin Code (To Bin Code) 1..n
Whse. Internal Put-away Header From Bin Code (From Bin Code) 1..n
Whse. Pick Request Bin Code (Bin Code) 1..n
Whse. Put-away Request Bin Code (Bin Code) 1..n
Whse. Worksheet Line To Bin Code (To Bin Code) 1..n
Work Center From-Production Bin Code (From-Production Bin Code) 1..n