BC Observatoryunofficial, made by waldo
tableWarehouseofficial - Microsoftderived - from the source, no model text

Table 7326 "Whse. Worksheet Line"

Base Application · Microsoft.Warehouse.Worksheet

Open in Claude7326.mdSource on GitHub

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25unchanged
  4. BC263 procedures removed, 2 procedures added
  5. BC271 procedures added, 1 events added
  6. BC2832 fields changed, 1 events added
  7. BC29-30unchanged

Neighbourhood 34 connected objects and pages

Table 5404 "Item Unit of Measure" (relates to, 2 links)Item Unit of MeasureTable 7300 "Zone" (relates to, 2 links)ZoneTable 10 "Shipment Method" (relates to)Shipment MethodTable 14 "Location" (relates to)LocationTable 27 "Item" (relates to)Table 291 "Shipping Agent" (relates to)Shipping AgentTable 5401 "Item Variant" (relates to)Table 5790 "Shipping Agent Services" (relates to)Shipping Agent ServicesTable 7318 "Posted Whse. Receipt Header" (relates to)Posted Whse. Receipt HeaderTable 7319 "Posted Whse. Receipt Line" (relates to)Posted Whse. Receipt LineTable 7320 "Warehouse Shipment Header" (relates to)Table 7321 "Warehouse Shipment Line" (relates to)Table 7328 "Whse. Worksheet Template" (relates to)Table 7354 "Bin" (relates to)Codeunit 5778 "Whse. Create Pick" (pages and codeunits on it)Page 7345 "Pick Worksheet" (pages and codeunits on it)Page 7351 "Movement Worksheet" (pages and codeunits on it)Page 7352 "Put-away Worksheet" (pages and codeunits on it)Table extension 979 "Asm. Whse. Worksheet Line" (extended by)Table extension 99000779 "Mfg. Whse. Worksheet Line" (extended by)Codeunit 5996 "Prod. Order Warehouse Mgt." (event subscribers)Codeunit 977 "Asm. Whse. Worksheet Line" (event subscribers)Codeunit 99000767 "Mfg. Whse. Worksheet Line" (event subscribers)Codeunit 7302 "WMS Management" (calls, 4 links)WMS ManagementCodeunit 5402 "Unit of Measure Management" (calls, 3 links)Unit of Measure ManagementCodeunit 7314 "Warehouse Availability Mgt." (calls, 3 links)Warehouse Availability Mgt.Codeunit 10 "Type Helper" (calls, 2 links)Type HelperCodeunit 6500 "Item Tracking Management" (calls, 2 links)Item Tracking ManagementCodeunit 7312 "Create Pick" (calls, 2 links)Codeunit 7322 "Create Inventory Pick/Movement" (calls, 2 links)Create Inventory Pick/MovementCodeunit 8703 "Feature Telemetry" (calls)Breaking Bulk with Directed Put-away and Pick (Learn pages)Move Items (Learn pages)Move items in warehouses that use directed put-away and pick (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Learn documents this table through its pages: Page 7351 “Movement Worksheet” (2 Learn pages), Page 7352 “Put-away Worksheet” (1).

Properties

Property Value
Caption Whse. Worksheet 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 Worksheet Template Name Code[10] — TableRelation Table 7328 “Whse. Worksheet Template” (Whse. Worksheet Template); NotBlank
2 Name Code[10] — NotBlank
3 Line No. Integer — not editable
4 Source Type Integer — not editable
5 Source Subtype Option — OptionCaption: 0,1,2,3,4,5,6,7,8,9,10; not editable
6 Source No. Δ BC28 Code[20] Specifies the number of the source document that the entry originates from. not editable
7 Source Line No. Δ BC28 Integer Specifies the line number of the source document that the entry originates from. not editable
8 Source Subline No. Integer — not editable
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”; not editable
10 Location Code Code[10] — TableRelation Table 14 “Location”; not editable
11 Shelf No. Δ BC28 Code[10] Specifies the shelf number of the item for information use.
12 From Zone Code Δ BC28 Code[10] Specifies the zone from which the items should be taken. TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
13 From Bin Code Δ BC28 Code[20] Specifies the code of the bin from which the items should be taken.
14 To Bin Code Δ BC28 Code[20] Specifies the code of the bin into which the items should be placed. TableRelation Table 7354 “Bin” (if (“To Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”), Code = field(“To Bin Code”)) else if (“To Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“To Zone Code”), Code = field(“To Bin Code”)))
15 To Zone Code Δ BC28 Code[10] Specifies the code of the zone in which the items should be placed. TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
16 Item No. Δ BC28 Code[20] Specifies the number of the item that the line concerns. TableRelation Table 27 “Item” (Item where(Type = const(Inventory)))
17 Quantity Δ BC28 Decimal Specifies how many units of the item you want to move.
18 Qty. (Base) Δ BC28 Decimal Specifies the quantity that should be handled in the base unit of measure. via Page 7351 “Movement Worksheet” 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, expressed in the base unit of measure. via Page 7351 “Movement Worksheet” not editable
21 Qty. to Handle Δ BC28 Decimal Specifies how many units of the item you want to move.
22 Qty. to Handle (Base) Δ BC28 Decimal Specifies the quantity you want to handle, in the base unit of measure. via Page 7351 “Movement Worksheet”
23 Qty. Handled Δ BC28 Decimal Specifies the quantity that has been handled and registered. not editable
24 Qty. Handled (Base) Δ BC28 Decimal Specifies the quantity that has been handled and registered, in the base unit of measure. via Page 7351 “Movement Worksheet” not editable
27 From Unit of Measure Code Code[10] — TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); NotBlank
28 Qty. per From Unit of Measure Δ BC28 Decimal — 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 — 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 on the line.
33 Description 2 Δ BC28 Text[50] Specifies information in addition to the description.
35 Sorting Sequence No. Integer — not editable
36 Due Date Δ BC28 Date Specifies the due date of the line.
39 Destination Type Δ BC28 Enum “Warehouse Destination Type” Specifies the type of destination associated with the warehouse worksheet line. enum Enum 7310 “Warehouse Destination Type”; not editable
40 Destination No. Δ BC28 Code[20] Specifies the number of the customer, vendor, or location for which the items should be processed. TableRelation if (“Destination Type” = const(Customer)) Customer.“No.” else if (“Destination Type” = const(Vendor)) Vendor.“No.” else if (“Destination Type” = const(Location)) Location.Code; not editable
41 Shipping Agent Code Code[10] — TableRelation Table 291 “Shipping Agent” (Shipping Agent)
42 Shipping Agent Service Code Code[10] — TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”)))
43 Shipment Method Code Code[10] — TableRelation Table 10 “Shipment Method” (Shipment Method)
44 Shipping Advice Δ BC28 Enum “Sales Header Shipping Advice” Specifies the shipping advice on the warehouse shipment line associated with this worksheet line. enum Enum 3657 “Sales Header Shipping Advice”; not editable
45 Shipment Date Date —
46 Whse. Document Type Δ BC28 Enum “Warehouse Worksheet Document Type” Specifies the type of warehouse document this line is associated with. enum Enum 5772 “Warehouse Worksheet Document Type”; not editable
47 Whse. Document No. Δ BC28 Code[20] Specifies the number of the warehouse document. TableRelation Table 7318 “Posted Whse. Receipt Header”, Table 7320 “Warehouse Shipment Header” (if (“Whse. Document Type” = const(Receipt)) “Posted Whse. Receipt Header”.“No.” where(“No.” = field(“Whse. Document No.”)) else if (“Whse. Document Type” = const(Shipment)) “Warehouse Shipment Header”.“No.” where(“No.” = field(“Whse. Document No.”)) else if (“Whse. Document Type” = const(“Internal P…); not editable
48 Whse. Document Line No. Δ BC28 Integer Specifies the number of the line in the warehouse document that is the basis for the worksheet line. TableRelation Table 7319 “Posted Whse. Receipt Line”, Table 7321 “Warehouse Shipment Line” (if (“Whse. Document Type” = const(Receipt)) “Posted Whse. Receipt Line”.“Line No.” where(“No.” = field(“Whse. Document No.”), “Line No.” = field(“Whse. Document Line No.”)) else if (“Whse. Document Type” = const(Shipment)) “Warehouse Shipment Line”.“Line No.” where(“No.” = field(“Whse. Document No.”…); not editable
50 Qty. Rounding Precision Δ BC28 Decimal — not editable
51 Qty. Rounding Precision (Base) Δ BC28 Decimal — not editable

Keys

  • Key1: Worksheet Template Name, Name, Location Code, Line No. (clustered)
  • Key2: Worksheet Template Name, Name, Location Code, Sorting Sequence No.
  • Key3: Item No., Location Code, Worksheet Template Name, Variant Code, Unit of Measure Code
  • Key4: Whse. Document Type, Whse. Document No., Whse. Document Line No.
  • Key5: Worksheet Template Name, Name, Location Code, Item No.
  • Key6: Worksheet Template Name, Name, Location Code, Due Date
  • Key7: Worksheet Template Name, Name, Location Code, Destination Type, Destination No.
  • Key8: Worksheet Template Name, Name, Location Code, Source Document, Source No.
  • Key9: Worksheet Template Name, Name, Location Code, To Bin Code
  • Key10: Worksheet Template Name, Name, Location Code, Shelf No.
  • Key11: Source Type, Source Subtype, Source No., Source Line No., Source Subline No.
  • Key12: Item No., From Bin Code, Location Code, Variant Code, From Unit of Measure Code

Events published

  • OnAfterAutofillQtyToHandle(var WhseWorksheetLine: Record "Whse. Worksheet Line") (integration)
  • OnAfterInitLineWithItem() (integration)
  • OnAfterCheckAvailQtytoMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; xWhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal) (integration)
  • OnAfterGetItem(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var Item: Record Item; var ItemDescription: Text[100]) (integration)
  • OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var FilteredWhseWorksheetLine: Record "Whse. Worksheet Line") (integration)
  • OnAutofillQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line") (integration)
  • OnBeforeCalcAvailQtyToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal; var IsHandled: Boolean) (integration)
  • OnBeforeCheckBin(WhseWorksheetLine: Record "Whse. Worksheet Line"; LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeCheckIncreaseBin(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var Bin: Record Bin; BinCode: Code[20]; Cubage: Decimal; Weight: Decimal; var IsHandled: Boolean) (integration)
  • OnBeforeCheckTemplateName(var WkshTemplateName: Code[10]; var WkshName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean) (integration)
  • OnBeforeCheckWhseWkshName(var WkshTemplateName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean) (integration)
  • OnBeforeMovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean) (integration)
  • OnBeforeOpenItemTrackingLines(var WhseWkshLine: Record "Whse. Worksheet Line") (integration)
  • OnBeforePutAwayCreate(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean; HideValidationDialog: Boolean) (integration)
  • OnBeforeUpdatePickQtyToHandleBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; CurrFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeValidateQty(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean) (integration)
  • OnCalcAvailQtyToMoveOnAfterSetFilters(var NewWhseWorksheetLine: Record "Whse. Worksheet Line"; var WhseWorksheetLine: Record "Whse. Worksheet Line") (integration)
  • OnBeforeCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var AvailableQty: Decimal; var IsHandled: Boolean) (integration)
  • OnAfterCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var AvailableQty: Decimal) + BC28 (integration)
  • OnDeleteQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line") (integration)
  • OnLookupWhseWkshNameOnBeforeRunModal(var WhseWkshName: Record "Whse. Worksheet Name") (integration)
  • OnGetSortSeqNoOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SortMethod: Enum "Whse. Activity Sorting Method") (integration)
  • OnSortWhseWkshLinesOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SortingMethod: Enum "Whse. Activity Sorting Method") (integration)
  • OnValidateQtyToHandleOnAfterCalcQtyAvailToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; xWhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal) (integration)
  • OnAfterSetSourceFilter(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SourceType: Integer; SourceSubtype: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean) (integration)
  • OnWhseItemTrackingLinesSetSource(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var WhseItemTrackingLines: Page "Whse. Item Tracking Lines"; var IsHandled: Boolean) + BC26 (integration)
  • OnUpdateQtyHandledForProdOrderOutput(var WhseWorksheetLine: Record "Whse. Worksheet Line") + BC27 (integration)

Procedures

  • CalcBaseQty(Qty: Decimal): Decimal
  • CalcQty(QtyBase: Decimal): Decimal
  • AutofillQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")
  • DeleteQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")
  • AssignedQtyOnReservedLines(): Decimal
  • CalcAvailableQtyBase(): Decimal
  • CalcReservedNotFromILEQty(QtyBaseAvailToPick: Decimal; var QtyToPick: Decimal; var QtyToPickBase: Decimal)
  • CheckAvailQtytoMove(): Decimal
  • SortWhseWkshLines(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method")
  • GetItem(ItemNo: Code[20]; var ItemDescription: Text[100])
  • CheckBin(LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean)
  • PutAwayCreate(var WhsePutAwayWkshLine: Record "Whse. Worksheet Line")
  • MovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line")
  • TemplateSelection(PageID: Integer; PageTemplate: Option "Put-away",Pick,Movement; var WhseWkshLine: Record "Whse. Worksheet Line"; var WhseWkshSelected: Boolean)
  • TemplateSelectionFromBatch(var WhseWkshName: Record "Whse. Worksheet Name")
  • OpenWhseWksh(var WhseWkshLine: Record "Whse. Worksheet Line"; var CurrentWkshTemplateName: Code[10]; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])
  • OpenWhseWkshBatch(var WhseWkshName: Record "Whse. Worksheet Name")
  • CheckWhseWkshName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var WhseWkshLine: Record "Whse. Worksheet Line")
  • SetWhseWkshName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var WhseWkshLine: Record "Whse. Worksheet Line")
  • LookupWhseWkshName(var WhseWkshLine: Record "Whse. Worksheet Line"; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])
  • SetHideValidationDialog(NewHideValidationDialog: Boolean)
  • OpenItemTrackingLines()
  • AvailableQtyToPick(): Decimal
  • AvailableQtyToPickForCurrentLine(): Decimal (internal)
  • InitNewLineWithItem(DocumentType: Enum "Warehouse Worksheet Document Type"; DocumentNo: Code[20]; DocumentLineNo: Integer; LocationCode: Code[10]; ItemNo: Code[20]; VariantCode: Code[10]; Qty: Decimal; QtyToHandle: Decimal; QtyPerUoM: Decimal)
  • SetUpNewLine(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method"; LineNo: Integer)
  • GetSortSeqNo(SortMethod: Enum "Whse. Activity Sorting Method"): Integer
  • SetItemTrackingLines(WhseEntry: Record "Warehouse Entry"; QtyToEmpty: Decimal)
  • SetCurrentFieldNo(FieldNo: Integer)
  • SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)
  • LookupItemTracking(var WhseItemTrackingSetup: Record "Item Tracking Setup")

Plus 20 local procedures.

Triggers

OnDelete

Relations

Pages and codeunits on this table

Extended by

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.

Recent changes

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. Worksheet Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources