Table 7343 "Posted Invt. Pick Line"

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

Properties

Property	Value
Caption	Posted Invt. 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
2	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
3	Line No. Δ BC28	Integer	Specifies the number of the posted inventory pick line.
4	Source Type	Integer	—
5	Source Subtype	Option	—	OptionCaption: 0,1,2,3,4,5,6,7,8,9,10
6	Source No. Δ BC28	Code[20]	Specifies the number of the source document that the entry originates from.
7	Source Line No.	Integer	—
8	Source Subline No.	Integer	—
9	Source Document Δ BC28	Enum “Warehouse Activity Source Document”	Specifies the type of document that the line relates to.	enum Enum 5768 “Warehouse Activity Source Document”
11	Location Code Δ BC28	Code[10]	Specifies the code for the location at which the items were pick.	TableRelation Table 14 “Location”
12	Shelf No. Δ BC28	Code[10]	Specifies the shelf number of the item for informational use.
13	Sorting Sequence No.	Integer	—
14	Item No. Δ BC28	Code[20]	Specifies the number of the item that was picked.	TableRelation Table 27 “Item”
15	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.”)))
16	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.”)))
17	Qty. per Unit of Measure Δ BC28	Decimal	Specifies the quantity per unit of measure of the item that was picked.
18	Description Δ BC28	Text[100]	Specifies a description of the item that was picked.
19	Description 2 Δ BC28	Text[50]	Specifies information in addition to the description.
20	Quantity Δ BC28	Decimal	Specifies the quantity of the item that was picked.
21	Qty. (Base) Δ BC28	Decimal	Specifies the quantity, in the base unit of measure, of the item that was picked. via Page 7397 “Posted Invt. Pick Lines”
31	Shipping Advice	Enum “Sales Header Shipping Advice”	—	enum Enum 3657 “Sales Header Shipping Advice”
34	Due Date Δ BC28	Date	Specifies the date when the warehouse activity must be completed.
39	Destination Type Δ BC28	enum “Warehouse Destination Type”	Specifies the type of destination associated with the posted inventory pick line.	enum Enum 7310 “Warehouse Destination Type”
40	Destination No. Δ BC26 Δ BC28	Code[20]	Specifies the number or the code of the customer or vendor linked to the line.	TableRelation Table 14 “Location”, Table 18 “Customer”, Table 23 “Vendor” (if (“Destination Type” = const(Vendor)) Vendor else if (“Destination Type” = const(Customer)) Customer else if (“Destination Type” = const(Location)) Location else if (“Destination Type” = const(Item)) Item else if (“Destination Type” = const(“Sales Order”)) “Sales Header”.“No.” where(“Document Type…)
41	Whse. Activity No.	Code[20]	—
42	Shipping Agent Code	Code[10]	—	TableRelation Table 291 “Shipping Agent” (Shipping Agent)
43	Shipping Agent Service Code	Code[10]	—	TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”)))
44	Shipment Method Code	Code[10]	—	TableRelation Table 10 “Shipment Method” (Shipment Method)
6500	Serial No. Δ BC28	Code[50]	Specifies the serial number for the item that was picked.
6501	Lot No. Δ BC28	Code[50]	Specifies the lot number for the item that was picked.
6502	Warranty Date	Date	—
6503	Expiration Date Δ BC28	Date	Specifies the expiration date for the item that was picked.
6515	Package No. Δ BC28	Code[50]	Specifies the package number for the item that was picked.
7300	Bin Code Δ BC28	Code[20]	Specifies the bin where the items are picked or put away.	TableRelation Table 7354 “Bin” (if (“Action Type” = filter(<> Take)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”)) else if (“Action Type” = filter(<> Take), “Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Action Type” = const(Take)) “Bin Cont…)
7301	Zone Code	Code[10]	—	TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
7305	Action Type Δ BC28	Enum “Warehouse Action Type”	Specifies the action type for the inventory pick line. For posted inventory pick lines, the action type is always Take, meaning that the items are being taken out of the bin.	enum Enum 5774 “Warehouse Action Type”; not editable
7312	Special Equipment Code Δ BC28	Code[10]	Specifies the special equipment code for the item that was picked.	TableRelation Table 7305 “Special Equipment” (Special Equipment)

Keys

Key1: No., Line No. (clustered)
Key2: No., Sorting Sequence No.
Key3: Source Type, Source Subtype, Source No., Source Line No., Source Subline No.

Procedures

SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)

Relations

lookup page Page 7397 “Posted Invt. Pick Lines”
Shipment Method Code: TableRelation Table 10 “Shipment Method”
Destination No.: TableRelation Table 14 “Location” (conditional)
Location Code: TableRelation Table 14 “Location”
Destination No.: TableRelation Table 18 “Customer” (conditional)
Destination No.: TableRelation Table 23 “Vendor” (conditional)
Destination No.: TableRelation Table 27 “Item” (conditional)
Item No.: TableRelation Table 27 “Item”
Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
Destination No.: TableRelation Table 36 “Sales Header” (conditional)
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
Zone Code: TableRelation Table 7300 “Zone”
Special Equipment Code: TableRelation Table 7305 “Special Equipment”
Bin Code: TableRelation Table 7354 “Bin” (conditional)

Pages and codeunits on this table

Page 7393 “Posted Invt. Pick Subform” (source table)
Page 7397 “Posted Invt. Pick Lines” (source table)

Extended by

Ask your agent

Procedure bodies are not stored here (D10). 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: "Posted Invt. Pick Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.