Diagrams


Table

Whse. Internal Put-away Line

DynamicsDocs.comWhse. Internal Put-away Line«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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Location Code><Variant Code><Whse. Document Line No.><Whse. Document Line No.><Whse. Document Line No.><Location Code><Destination No.><Variant Code><Location Code><Destination No.><Variant Code><Location Code><Destination No.><Variant Code>

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
10 Location Code Code10 Editable: No
11 Shelf No. Code10
12 From Bin Code Code20
13 From Zone Code Code10
14 Item No. Code20
15 Quantity Decimal (0:5)
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
23 Qty. Put Away Decimal (0:5) Editable: No
24 Qty. Put Away (Base) Decimal (0:5) Editable: No
25 Put-away Qty. Decimal (0:5) Editable: No
FlowField
26 Put-away Qty. (Base) Decimal (0:5) Editable: No
FlowField
27 Status Option Editable: No
29 Unit of Measure Code Code10 Editable: No
30 Qty. per Unit of Measure Decimal (0:5) Editable: No
31 Variant Code Code10 Editable: Yes
32 Description Text50
33 Description 2 Text50
35 Sorting Sequence No. Integer Editable: No
36 Due Date Date
37 Cubage Decimal (0:5)
38 Weight Decimal (0:5)

Keys

# Fields
0 No.,Line No. Clustered: Yes
1 No.,Item No. MaintainSQLIndex: No
2 No.,From Bin Code MaintainSQLIndex: No
3 No.,Shelf No. MaintainSQLIndex: No
4 No.,Sorting Sequence No.
5 No.,Due Date MaintainSQLIndex: No
6 Item No.,From Bin Code,Location Code,Unit of Measure Code,Variant Code MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Variant Code Item Variant Code 1..n
Location Code Location 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