Table 7334 "Whse. Internal Pick Line"

Base Application · Microsoft.Warehouse.InternalDocument · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Whse. Internal Pick Line
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.	not editable
2	Line No. Δ BC28	Integer	Specifies the number of the line.	not editable
10	Location Code Δ BC28	Code[10]	Specifies the code of the location of the internal pick line.	TableRelation Table 14 “Location”; not editable
11	Shelf No. Δ BC28	Code[10]	Specifies the shelf number of the item for informational use.
12	To Bin Code Δ BC28	Code[20]	Specifies the code of the bin into which the items should be placed when they are picked.	TableRelation Table 7354 “Bin” (if (“To Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“To Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“To Zone Code”)))
13	To Zone Code Δ BC28	Code[10]	Specifies the To Zone Code of the zone where items should be placed once they are picked.	TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
14	Item No. Δ BC28	Code[20]	Specifies the number of the item that should be picked.	TableRelation Table 27 “Item”
15	Quantity Δ BC28	Decimal	Specifies the quantity that should be picked.
16	Qty. (Base) Δ BC28	Decimal	Specifies the quantity that should be picked, in the base unit of measure. via Page 7360 “Whse. Internal Pick Lines”	not editable
19	Qty. Outstanding Δ BC28	Decimal	Specifies the quantity that still needs to be handled.	not editable
20	Qty. Outstanding (Base) Δ BC28	Decimal	Specifies the quantity that still needs to be handled, in the base unit of measure. via Page 7360 “Whse. Internal Pick Lines”	not editable
23	Qty. Picked Δ BC28	Decimal	Specifies the quantity of the line that is registered as picked.	not editable
24	Qty. Picked (Base) Δ BC28	Decimal	Specifies the quantity of the line that is registered as picked, in the base unit of measure. via Page 7360 “Whse. Internal Pick Lines”	not editable
27	Pick Qty. Δ BC28	Decimal	Specifies the quantity of the item in pick instructions that are assigned to be picked for the line.	FlowField: sum(“Warehouse Activity Line”.“Qty. Outstanding” where(“Activity Type” = const(Pick), “Whse. Document Type” = const(“Internal Pick”), “Whse. Document No.” = field(“No.”), “Whse. Document Line No.” = field(“Line No.”), “Action Type” = filter(” “ \| Place), “Unit of Measure Code” = field(“Unit of Measu…; not editable
28	Pick Qty. (Base) Δ BC28	Decimal	Specifies the quantity of the item in pick instructions assigned to be picked for the line, in the base unit of measure. via Page 7358 “Whse. Internal Pick Line”	FlowField: sum(“Warehouse Activity Line”.“Qty. Outstanding (Base)” where(“Activity Type” = const(Pick), “Whse. Document Type” = const(“Internal Pick”), “Whse. Document No.” = field(“No.”), “Whse. Document Line No.” = field(“Line No.”), “Action Type” = filter(” “ \| Place), “Original Breakbulk” = const(false), “…; not editable
29	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); NotBlank
30	Qty. per Unit of Measure Δ BC28	Decimal	Specifies the number of base units of measure, that are in the unit of measure, specified for the item on the line.	not editable
31	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
32	Description Δ BC28	Text[100]	Specifies the description of the item in the line.
33	Description 2 Δ BC28	Text[50]	Specifies a second description of the item on the line.
34	Status Δ BC28	Option	Specifies if the status is Blank, Partially Picked, or Completely Picked.	OptionCaption: ,Partially Picked,Completely Picked; not editable
35	Sorting Sequence No.	Integer	—	not editable
36	Due Date Δ BC28	Date	Specifies the date when the warehouse activity must be completed.
37	Cubage Δ BC28	Decimal	—
38	Weight Δ BC28	Decimal	—

Keys

Key1: No., Line No. (clustered)
Key2: No., Sorting Sequence No.
Key3: No., Item No.
Key4: No., Shelf No.
Key5: No., To Bin Code
Key6: No., Due Date
Key7: To Bin Code, Location Code

Events published

OnBeforeCheckIncreaseBin(var RecWhseInternalPickLine: Record "Whse. Internal Pick Line"; var Bin: Record Bin; WhseInternalPickLine: Record "Whse. Internal Pick Line"; var IsHandled: Boolean) (integration)
OnBeforeInitItemFields(var RecWhseInternalPickLine: Record "Whse. Internal Pick Line"; var IsHandled: Boolean) (integration)
OnBeforeRunCreatePickFromWhseSource(var WhseInternalPickLine: Record "Whse. Internal Pick Line"; var WhseInternalPickHeader2: Record "Whse. Internal Pick Header"; HideValidationDialog: Boolean; var IsHandled: Boolean) (integration)
OnOpenItemTrackingLinesOnBeforeSetSource(var WhseInternalPickLine: Record "Whse. Internal Pick Line"; var WhseWorksheetLine: Record "Whse. Worksheet Line") (integration)

Procedures

SetUpNewLine(LastWhseInternalPickLine: Record "Whse. Internal Pick Line")
CalcStatusPickLine(): Integer
SetHideValidationDialog(NewHideValidationDialog: Boolean)
CreatePickDoc(var WhseInternalPickLine: Record "Whse. Internal Pick Line"; WhseInternalPickHeader2: Record "Whse. Internal Pick Header")
OpenItemTrackingLines()
CheckBin(CalcDeduction: Boolean)

Plus 12 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

lookup page Page 7360 “Whse. Internal Pick Lines”
Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Pick Qty.: CalcFormula Table 5767 “Warehouse Activity Line”
Pick Qty. (Base): CalcFormula Table 5767 “Warehouse Activity Line”
To Zone Code: TableRelation Table 7300 “Zone”
To Bin Code: TableRelation Table 7354 “Bin” (conditional)

Pages and codeunits on this table

Page 7358 “Whse. Internal Pick Line” (source table)
Page 7360 “Whse. Internal Pick Lines” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 6500 “Item Tracking Management” (1 call: OnDelete → DeleteWhseItemTrkgLines)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Whse. Internal Pick Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.