Diagrams

Table

Bin Content

DynamicsDocs.comBin Content«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 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«Table 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...«Table 5741»Transfer LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureQty. to ShipQty. to ReceiveQuantity ShippedQuantity ReceivedStatus; [Open,Released]Shortcut Dimension 1 CodeShortcut Dimension 2 CodeDescriptionGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Outstanding Qty. [Base]Qty. to Ship [Base]Qty. Shipped [Base]Qty. to Receive [Base]Qty. Received [Base]Qty. per Unit of MeasureUnit of Measure CodeOutstanding QuantityGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2In-Transit Code...«Table 5773»Registered Whse. Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeStarting DateSerial No.Lot No....«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«Table 7311»Warehouse Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Registering DateLocation Code [PK]From Zone CodeFrom Bin CodeDescriptionItem No.QuantityQty. [Base]Qty. [Absolute]Qty. [Absolute, Base]Zone CodeBin CodeSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeTo Zone CodeTo Bin CodeReason CodeRegistering No. SeriesFrom Bin Type CodeCubageWeightWhse. Document No.Whse. Document Type; [Whse. Journal,Re......«Table 7341»Posted Invt. Put-away LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7343»Posted Invt. Pick LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7345»Registered Invt. Movement LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 753»Standard Item Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Item No.Entry Type; [Purchase,Sale,Positive Ad...DescriptionLocation CodeInventory Posting GroupQuantityUnit AmountUnit CostAmountSalespers./Purch. CodeSource CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Standard Journal Code [PK]Reason CodeTransaction TypeTransport MethodCountry/Region CodeQty. [Calculated]Qty. [Phys. Inventory]Phys. InventoryGen. Bus. Posting GroupGen. Prod. Posting GroupEntry/Exit PointAreaTransaction SpecificationPosting No. SeriesDimension Set ID...«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«Table 900»Assembly HeaderDocument Type; [Quote,Order,,,Blanket...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedItem No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Assembled QuantityAssembled Quantity [Base]Quantity to AssembleQuantity to Assemble [Base]Reserved QuantityReserved Qty. [Base]Planning Flexibility; [Unlimited,None]...«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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«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 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 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick«Table 7304»Warehouse ClassCode [PK,NN]Description«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight<Location Code><Zone Code><Bin Code><Item No.><Bin Type Code><Warehouse Class Code><Variant Code><Unit of Measure Code><Unit of Measure Filter><Bin Code><Bin Code><Bin Code><Transfer-from Bin Code><Bin Code><Bin Code><From Bin Code><Bin Code><Bin Code><Bin Code><Bin Code><Bin Code><Bin Code><Location Code><Purch. Order Line No.><Special Order Purch. Line No.><Sales Order Line No.><Special Order Sales Line No.><Attached to Line No.><Blanket Order Line No.><Variant Code><Originally Ordered Var. Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Originally Ordered No.><BOM Item No.><Location Code><Attached to Line No.><Blanket Order Line No.><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Prod. Order Line No.><Item No.><Variant Code><Location Code><Bin Code><Unit of Measure Code><Whse. Document Line No.><Order Line No.><Item No.><Unit of Measure Code><Variant Code><In-Transit Code><Transfer-from Code><Transfer-to Code><Derived From Line No.><Transfer-To Bin Code><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Zone Code><Whse. Document No.><No.><Replaced Item No.><Location Code><Attached to Line No.><Variant Code><Bin Code><Unit of Measure Code><Location Code><From Zone Code><Zone Code><To Zone Code><From Bin Code><Bin Code><To Bin Code><Item No.><From Bin Type Code><Variant Code><Unit of Measure Code><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Zone Code><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Zone Code><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Bin Code><Zone Code><Item No.><Originally Ordered No.><Location Code><Variant Code><Originally Ordered Var. Code><Bin Code><Unit of Measure Code><Item No.><Source No.><Originally Ordered No.><Location Code><New Location Code><Variant Code><Originally Ordered Var. Code><Bin Code><New Bin Code><Unit of Measure Code><Item No.><Variant Code><Location Code><Bin Code><Unit of Measure 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><Location Code><Location Filter><Location Code><Bin Type Code><Warehouse Class Code><Zone Code><Bin Type Code><Warehouse Class Code><Item Filter><Bin Filter><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Warehouse Class 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
2 Zone Code (Zone Code) Code10 NotBlank: Yes
Editable: No
3 Bin Code (Bin Code) Code20 NotBlank: Yes
4 Item No. (Item No.) Code20 NotBlank: Yes
10 Bin Type Code (Bin Type Code) Code10 Editable: No
11 Warehouse Class Code (Warehouse Class Code) Code10 Editable: No
12 Block Movement (Block Movement) Option
15 Min. Qty. (Min. Qty.) Decimal (0:5)
16 Max. Qty. (Max. Qty.) Decimal (0:5)
21 Bin Ranking (Bin Ranking) Integer Editable: No
26 Quantity (Quantity) Decimal (0:5) Editable: No
FlowField
29 Pick Qty. (Pick Qty.) Decimal (0:5) Editable: No
FlowField
30 Neg. Adjmt. Qty. (Neg. Adjmt. Qty.) Decimal (0:5) Editable: No
FlowField
31 Put-away Qty. (Put-away Qty.) Decimal (0:5) Editable: No
FlowField
32 Pos. Adjmt. Qty. (Pos. Adjmt. Qty.) Decimal (0:5) Editable: No
FlowField
37 Fixed (Fixed) Boolean
40 Cross-Dock Bin (Cross-Dock Bin) Boolean
41 Default (Default) Boolean
50 Quantity (Base) (Quantity (Base)) Decimal (0:5) Editable: No
FlowField
51 Pick Quantity (Base) (Pick Quantity (Base)) Decimal (0:5) Editable: No
FlowField
52 Negative Adjmt. Qty. (Base) (Negative Adjmt. Qty. (Base)) Decimal (0:5) Editable: No
FlowField
53 Put-away Quantity (Base) (Put-away Quantity (Base)) Decimal (0:5) Editable: No
FlowField
54 Positive Adjmt. Qty. (Base) (Positive Adjmt. Qty. (Base)) Decimal (0:5) Editable: No
FlowField
55 ATO Components Pick Qty. (ATO Components Pick Qty.) Decimal (0:5) Editable: No
FlowField
56 ATO Components Pick Qty (Base) (ATO Components Pick Qty (Base)) Decimal (0:5) Editable: No
FlowField
5402 Variant Code (Variant Code) Code10
5404 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
5407 Unit of Measure Code (Unit of Measure Code) Code10 NotBlank: Yes
6500 Lot No. Filter (Lot No. Filter) Code20 FlowFilter
6501 Serial No. Filter (Serial No. Filter) Code20 FlowFilter
6502 Dedicated (Dedicated) Boolean Editable: No
6503 Unit of Measure Filter (Unit of Measure Filter) Code10 FlowFilter

Keys

# Fields
0 Location Code,Bin Code,Item No.,Variant Code,Unit of Measure Code (Location Code,Bin Code,Item No.,Variant Code,Unit of Measure Code) Clustered: Yes
1 Bin Type Code (Bin Type Code)
2 Location Code,Item No.,Variant Code,Cross-Dock Bin,Qty. per Unit of Measure,Bin Ranking (Location Code,Item No.,Variant Code,Cross-Dock Bin,Qty. per Unit of Measure,Bin Ranking)
3 Location Code,Warehouse Class Code,Fixed,Bin Ranking (Location Code,Warehouse Class Code,Fixed,Bin Ranking)
4 Location Code,Item No.,Variant Code,Warehouse Class Code,Fixed,Bin Ranking (Location Code,Item No.,Variant Code,Warehouse Class Code,Fixed,Bin Ranking)
5 Item No. (Item No.)
6 Default,Location Code,Item No.,Variant Code,Bin Code (Default,Location Code,Item No.,Variant Code,Bin Code)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Bin Type Code (Bin Type Code) Bin Type Code (Code) 1..n
Item No. (Item No.) Item () 1..n
Unit of Measure Filter (Unit of Measure Filter) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (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
Assembly Header Bin Code (Bin Code) 1..n
Item Journal Line 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
Prod. Order Line Bin Code (Bin Code) 1..n
Purchase Line 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
Sales Line Bin Code (Bin Code) 1..n
Service Line Bin Code (Bin Code) 1..n
Standard Item Journal Line Bin Code (Bin Code) 1..n
Transfer Line Transfer-from Bin Code (Transfer-from Bin Code) 1..n
Warehouse Journal Line From Bin Code (From Bin Code) 1..n