Diagrams


Table

Warehouse Shipment Line

DynamicsDocs.comWarehouse Shipment Line«Table 7321»Warehouse Shipment 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 Document; [,Sales Order,,,Sales...Location CodeShelf No.Bin CodeZone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to ShipQty. to Ship [Base]Qty. PickedQty. Picked [Base]Qty. ShippedQty. Shipped [Base]Pick Qty.Pick Qty. [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Status; [,Partially Picked,Partially S...Sorting Sequence No....«Table 5767»Warehouse 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]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Shipping Agent 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 7326»Whse. Worksheet LineWorksheet Template Name [PK,NN]Name [PK,NN]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 Code [PK]Shelf No.From Zone CodeFrom Bin CodeTo Bin CodeTo Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]From Unit of Measure Code [NN]Qty. per From Unit of MeasureUnit of Measure Code [NN]Qty. per Unit of MeasureVariant CodeDescriptionDescription 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...«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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...<Location Code><Destination No.><Bin Code><Zone Code><Item No.><Unit of Measure Code><Variant Code><Destination No.><Destination No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Destination No.><Destination No.><Bin Code><Zone Code><Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Destination No.><Destination No.><Bin Code><Zone Code><Location Code><Destination No.><From Zone Code><To Zone Code><To Bin Code><Item No.><From Unit of Measure Code><Unit of Measure Code><Variant Code><Destination No.><Destination No.><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 Code><Location Code><Location Filter><Location Code><Zone Code><Item Filter><Bin Filter><Vendor No.><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Bill-to Customer No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 No. Code20 Editable: No
2 Line No. Integer Editable: No
3 Source Type Integer Editable: No
4 Source Subtype Option Editable: No
6 Source No. Code20 Editable: No
7 Source Line No. Integer Editable: No
9 Source Document Option Editable: No
10 Location Code Code10 Editable: No
11 Shelf No. Code10
12 Bin Code Code20
13 Zone Code Code10
14 Item No. Code20 Editable: No
15 Quantity Decimal (0:5) Editable: No
16 Qty. (Base) Decimal (0:5) Editable: No
19 Qty. Outstanding Decimal (0:5) Editable: No
20 Qty. Outstanding (Base) Decimal (0:5) Editable: No
21 Qty. to Ship Decimal (0:5)
22 Qty. to Ship (Base) Decimal (0:5)
23 Qty. Picked Decimal (0:5) Editable: No
Normal
24 Qty. Picked (Base) Decimal (0:5) Editable: No
25 Qty. Shipped Decimal (0:5) Editable: No
26 Qty. Shipped (Base) Decimal (0:5) Editable: No
27 Pick Qty. Decimal (0:5) Editable: No
FlowField
28 Pick Qty. (Base) Decimal (0:5) Editable: No
FlowField
29 Unit of Measure Code Code10 Editable: No
30 Qty. per Unit of Measure Decimal (0:5) Editable: No
31 Variant Code Code10 Editable: No
32 Description Text50 Editable: No
33 Description 2 Text50 Editable: No
34 Status Option Editable: No
35 Sorting Sequence No. Integer Editable: No
36 Due Date Date
39 Destination Type Option Editable: No
40 Destination No. Code20 Editable: No
41 Cubage Decimal (0:5)
42 Weight Decimal (0:5)
44 Shipping Advice Option Editable: No
45 Shipment Date Date
46 Completely Picked Boolean Editable: No
48 Not upd. by Src. Doc. Post. Boolean Editable: No
49 Posting from Whse. Ref. Integer Editable: No
900 Assemble to Order Boolean Editable: No

Keys

# Fields
0 No.,Line No. Clustered: Yes
1 No.,Sorting Sequence No. MaintainSQLIndex: No
2 No.,Item No. MaintainSQLIndex: No
3 No.,Source Document,Source No. MaintainSQLIndex: No
4 No.,Shelf No. MaintainSQLIndex: No
5 No.,Bin Code MaintainSQLIndex: No
6 No.,Due Date MaintainSQLIndex: No
7 No.,Destination Type,Destination No. MaintainSQLIndex: No
8 Source Type,Source Subtype,Source No.,Source Line No.,Assemble to Order MaintainSIFTIndex: No
9 No.,Source Type,Source Subtype,Source No.,Source Line No. MaintainSQLIndex: No
10 Item No.,Location Code,Variant Code,Due Date MaintainSIFTIndex: No
11 Bin Code,Location Code MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Bin Code Bin Code 1..n
Destination No. Customer No. 1..n
Item No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Destination No. Location Code 1..n
Destination No. Vendor No. 1..n
Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field
Registered Whse. Activity Line Whse. Document Line No. 1..n
Warehouse Activity Line Whse. Document Line No. 1..n
Whse. Worksheet Line Whse. Document Line No. 1..n