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

Keys

# Fields
0 No.,Line No. (No.,Line No.) Clustered: Yes
1 No.,Item No. (No.,Item No.) MaintainSQLIndex: No
2 No.,From Bin Code (No.,From Bin Code) MaintainSQLIndex: No
3 No.,Shelf No. (No.,Shelf No.) MaintainSQLIndex: No
4 No.,Sorting Sequence No. (No.,Sorting Sequence No.)
5 No.,Due Date (No.,Due Date) MaintainSQLIndex: No
6 Item No.,From Bin Code,Location Code,Unit of Measure Code,Variant Code (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 (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n

Table Relations From Other Tables

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