Diagrams


Table

Warehouse Activity Line

DynamicsDocs.comWarehouse Activity Line«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 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 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«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...«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 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting No.«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«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 7318»Posted Whse. Receipt HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesZone CodeBin CodeCommentPosting DateVendor Shipment No.Whse. Receipt No.Document Status; [,Partially Put Away,...«Table 7320»Warehouse Shipment HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentBin CodeZone CodeDocument Status; [,Partially Picked,Pa...Posting DateShipping Agent CodeShipping Agent Service CodeShipment Method CodeShipment DateCompletely PickedStatus; [Open,Released]External Document No.Create Posted HeaderShipping No.Last Shipping No.Shipping No. Series«Table 7331»Whse. Internal Put-away HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentFrom Bin CodeFrom Zone CodeDue DateDocument Status; [,Partially Put Away,...Sorting Method; [,Item,Shelf or Bin,Du...Status; [Open,Released]«Table 7333»Whse. Internal Pick HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Shelf or Bin,Du...No. SeriesCommentTo Bin CodeTo Zone CodeDocument Status; [,Partially Picked,Co...Due DateStatus; [Open,Released]«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 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 7319»Posted Whse. Receipt 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. Put AwayQty. Put Away [Base]Put-away Qty.Put-away Qty. [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Due DateStarting DateQty. Cross-DockedQty. Cross-Docked [Base]Cross-Dock Zone CodeCross-Dock Bin CodePosted Source Document; [,Posted Recei...Posted Source No....«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 7332»Whse. Internal Put-away LineNo. [PK]Line No. [PK]Location CodeShelf No.From Bin CodeFrom Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. Put AwayQty. Put Away [Base]Put-away Qty.Put-away Qty. [Base]Status; [,Partially Put Away,Completel...Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Sorting Sequence No.Due DateCubageWeight«Table 7334»Whse. Internal Pick LineNo. [PK]Line No. [PK]Location CodeShelf No.To Bin CodeTo Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. PickedQty. Picked [Base]Pick Qty.Pick Qty. [Base]Unit of Measure Code [NN]Qty. per Unit of MeasureVariant CodeDescriptionDescription 2Status; [,Partially Picked,Completely...Sorting Sequence No.Due DateCubageWeight«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 901»Assembly LineDocument Type; [Quote,Order,,,Blanket...Document No. [PK]Line No. [PK]Type; [,Item,Resource]No.Variant CodeDescriptionDescription 2Lead-Time OffsetResource Usage Type; [,Direct,Fixed]Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodePositionPosition 2Position 3Appl.-to Item EntryAppl.-from Item EntryQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Consumed QuantityConsumed Quantity [Base]Quantity to ConsumeQuantity to Consume [Base]Reserved QuantityReserved Qty. [Base]Avail. WarningSubstitution Available...«Table 7305»Special EquipmentCode [PK,NN]Description«Table 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick<Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Destination No.><Destination No.><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Bin Code><Zone Code><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Special Equipment Code><Bin Type 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 Code><Location Code><Location Filter><Location Code><Location Filter><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Destination No.><Location Code><Location Code><Location Code><Location Code><Location Code><Location Code><Vendor No.><Alternative Item No.><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Special Equipment Code><Source No.><Item No.><Item No.><Item No.><Item No.><Item No.><No.><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Shipment Method Code><Shipping Agent Code><Pay-to Vendor No.><Destination No.><Shipment Method Code><Shipment Method Id><Shipping Agent Code><Bill-to Customer No.><Shipping Agent Service Code><Sell-to Customer No.><Bill-to Customer No.><Destination No.><Source No.><Shipment Method Code><Shipping Agent Code><Shipping Agent Service Code><Source No.><Shipping Agent Code><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Zone Code><Bin Type Code><Special Equipment Code><Bin Code><Bin Code><Bin Code><Bin Code><Cross-Dock Bin Code><Bin Code><Bin Code><From Bin Code><To Bin Code><To Bin Code><Bin Code><Bin Code><Bin Type Code><Special Equipment Code><Zone Code><Zone Code><Cross-Dock Zone Code><Zone Code><Zone Code><From Zone Code><To Zone Code><To Zone Code><Prod. Order No.><Document No.>

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

Fields

# Name Type
1 Activity Type Option Editable: No
2 No. Code20 Editable: No
3 Line No. Integer Editable: No
4 Source Type Integer Editable: No
5 Source Subtype Option Editable: No
6 Source No. Code20 Editable: No
7 Source Line No. Integer BlankZero: Yes
Editable: No
8 Source Subline No. Integer BlankZero: Yes
Editable: No
9 Source Document Option BlankZero: Yes
Editable: No
11 Location Code Code10 Editable: No
12 Shelf No. Code10
13 Sorting Sequence No. Integer Editable: No
14 Item No. Code20 Editable: No
15 Variant Code Code10 Editable: No
16 Unit of Measure Code Code10 Editable: No
17 Qty. per Unit of Measure Decimal (0:5) Editable: No
18 Description Text50 Editable: No
19 Description 2 Text50 Editable: No
20 Quantity Decimal (0:5) Editable: No
21 Qty. (Base) Decimal (0:5) Editable: No
24 Qty. Outstanding Decimal (0:5) Editable: No
25 Qty. Outstanding (Base) Decimal (0:5) Editable: No
26 Qty. to Handle Decimal (0:5)
27 Qty. to Handle (Base) Decimal (0:5)
28 Qty. Handled Decimal (0:5) Editable: No
29 Qty. Handled (Base) Decimal (0:5) Editable: No
31 Shipping Advice Option Editable: No
Normal
34 Due Date Date
39 Destination Type Option Editable: No
40 Destination No. Code20 Editable: No
42 Shipping Agent Code Code10
43 Shipping Agent Service Code Code10
44 Shipment Method Code Code10
47 Starting Date Date
900 Assemble to Order Boolean Editable: No
901 ATO Component Boolean Editable: No
6500 Serial No. Code20
6501 Lot No. Code20
6502 Warranty Date Date
6503 Expiration Date Date
6504 Serial No. Blocked Boolean Editable: No
FlowField
6505 Lot No. Blocked Boolean Editable: No
FlowField
7300 Bin Code Code20
7301 Zone Code Code10
7305 Action Type Option Editable: No
7306 Whse. Document Type Option Editable: No
7307 Whse. Document No. Code20 Editable: No
7308 Whse. Document Line No. Integer BlankZero: Yes
Editable: No
7309 Bin Ranking Integer Editable: No
7310 Cubage Decimal (0:5)
7311 Weight Decimal (0:5)
7312 Special Equipment Code Code10
7313 Bin Type Code Code10
7314 Breakbulk No. Integer BlankZero: Yes
7315 Original Breakbulk Boolean
7316 Breakbulk Boolean
7317 Cross-Dock Information Option
7318 Dedicated Boolean Editable: No

Keys

# Fields
0 Activity Type,No.,Line No. Clustered: Yes
MaintainSIFTIndex: No
1 No.,Line No.,Activity Type
2 Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.,Unit of Measure Code,Action Type,Breakbulk No.,Original Breakbulk,Activity Type,Assemble to Order MaintainSIFTIndex: No
3 Activity Type,No.,Sorting Sequence No. MaintainSQLIndex: No
4 Activity Type,No.,Shelf No. MaintainSQLIndex: No
5 Activity Type,No.,Location Code,Source Document,Source No.,Action Type,Zone Code MaintainSQLIndex: No
6 Activity Type,No.,Due Date,Action Type,Bin Code MaintainSQLIndex: No
7 Activity Type,No.,Bin Code,Breakbulk No.,Action Type MaintainSQLIndex: No
8 Activity Type,No.,Bin Ranking,Breakbulk No.,Action Type MaintainSQLIndex: No
9 Activity Type,No.,Destination Type,Destination No.,Action Type,Bin Code MaintainSQLIndex: No
10 Activity Type,No.,Whse. Document Type,Whse. Document No.,Whse. Document Line No. MaintainSQLIndex: No
11 Activity Type,No.,Action Type,Bin Code MaintainSQLIndex: No
12 Activity Type,No.,Item No.,Variant Code,Action Type,Bin Code MaintainSQLIndex: No
13 Whse. Document No.,Whse. Document Type,Activity Type,Whse. Document Line No.,Action Type,Unit of Measure Code,Original Breakbulk,Breakbulk No.,Lot No.,Serial No.,Assemble to Order MaintainSIFTIndex: No
14 Item No.,Bin Code,Location Code,Action Type,Variant Code,Unit of Measure Code,Breakbulk No.,Activity Type,Lot No.,Serial No.,Original Breakbulk,Assemble to Order,ATO Component MaintainSIFTIndex: No
15 Item No.,Location Code,Activity Type,Bin Type Code,Unit of Measure Code,Variant Code,Breakbulk No.,Action Type,Lot No.,Serial No.,Assemble to Order MaintainSIFTIndex: No
16 Bin Code,Location Code,Action Type,Breakbulk No. MaintainSQLIndex: No
MaintainSIFTIndex: No
17 Location Code,Activity Type
18 Source No.,Source Line No.,Source Subline No.,Serial No.,Lot No. MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Whse. Document No. Assembly Header No. 1..n
Whse. Document Line No. Assembly Line Line No. 1..n
Bin Code Bin Code 1..n
Bin Type Code Bin Type Code 1..n
Destination No. Customer No. 1..n
Destination No. Family No. 1..n
Destination 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
Whse. Document No. Posted Whse. Receipt Header No. 1..n
Whse. Document Line No. Posted Whse. Receipt Line Line No. 1..n
Whse. Document Line No. Prod. Order Line Line No. 1..n
Whse. Document No. Production Order No. 1..n
Destination No. Sales Header No. 1..n
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
Special Equipment Code Special Equipment Code 1..n
Destination No. Vendor No. 1..n
Whse. Document No. Warehouse Shipment Header No. 1..n
Whse. Document Line No. Warehouse Shipment Line Line No. 1..n
Whse. Document No. Whse. Internal Pick Header No. 1..n
Whse. Document Line No. Whse. Internal Pick Line Line No. 1..n
Whse. Document No. Whse. Internal Put-away Header No. 1..n
Whse. Document Line No. Whse. Internal Put-away Line Line No. 1..n
Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field