---
title: "Table 7326 Whse. Worksheet Line"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/7326-whse-worksheet-line/
type: table
id: 7326
name: "Whse. Worksheet Line"
app: "Base Application"
namespace: Microsoft.Warehouse.Worksheet
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/7326-whse-worksheet-line/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 7326 Whse. Worksheet Line

Jonas Paprotka, https://jonas-paprotka.de/ref/table/7326-whse-worksheet-line/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Warehouse.Worksheet |
| Versions | 17-28 |
| Source file | Warehouse/Worksheet/WhseWorksheetLine.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Worksheet Template Name | Code[10] | 17-28 | - | - |
| 2 | Name | Code[10] | 17-28 | - | - |
| 3 | Line No. | Integer | 17-28 | - | - |
| 4 | Source Type | Integer | 17-28 | - | - |
| 5 | Source Subtype | Option | 17-28 | - | - |
| 6 | Source No. | Code[20] | 17-28 | - | - |
| 7 | Source Line No. | Integer | 17-28 | - | - |
| 8 | Source Subline No. | Integer | 17-28 | - | - |
| 9 | Source Document | Enum Warehouse Activity Source Document | 17-28 | - | - |
| 10 | Location Code | Code[10] | 17-28 | - | - |
| 11 | Shelf No. | Code[10] | 17-28 | - | - |
| 12 | From Zone Code | Code[10] | 17-28 | - | - |
| 13 | From Bin Code | Code[20] | 17-28 | - | - |
| 14 | To Bin Code | Code[20] | 17-28 | - | - |
| 15 | To Zone Code | Code[10] | 17-28 | - | - |
| 16 | Item No. | Code[20] | 17-28 | - | - |
| 17 | Quantity | Decimal | 17-28 | - | - |
| 18 | Qty. (Base) | Decimal | 17-28 | - | - |
| 19 | Qty. Outstanding | Decimal | 17-28 | - | - |
| 20 | Qty. Outstanding (Base) | Decimal | 17-28 | - | - |
| 21 | Qty. to Handle | Decimal | 17-28 | - | - |
| 22 | Qty. to Handle (Base) | Decimal | 17-28 | - | - |
| 23 | Qty. Handled | Decimal | 17-28 | - | - |
| 24 | Qty. Handled (Base) | Decimal | 17-28 | - | - |
| 27 | From Unit of Measure Code | Code[10] | 17-28 | - | - |
| 28 | Qty. per From Unit of Measure | Decimal | 17-28 | - | - |
| 29 | Unit of Measure Code | Code[10] | 17-28 | - | - |
| 30 | Qty. per Unit of Measure | Decimal | 17-28 | - | - |
| 31 | Variant Code | Code[10] | 17-28 | - | - |
| 32 | Description | Text[100] | 17-28 | - | - |
| 33 | Description 2 | Text[50] | 17-28 | - | - |
| 35 | Sorting Sequence No. | Integer | 17-28 | - | - |
| 36 | Due Date | Date | 17-28 | - | - |
| 39 | Destination Type | Enum Warehouse Destination Type | 17-28 | - | - |
| 40 | Destination No. | Code[20] | 17-28 | - | - |
| 41 | Shipping Agent Code | Code[10] | 17-28 | - | - |
| 42 | Shipping Agent Service Code | Code[10] | 17-28 | - | - |
| 43 | Shipment Method Code | Code[10] | 17-28 | - | - |
| 44 | Shipping Advice | Enum Sales Header Shipping Advice | 17-28 | - | - |
| 45 | Shipment Date | Date | 17-28 | - | - |
| 46 | Whse. Document Type | Enum Warehouse Worksheet Document Type | 17-28 | - | - |
| 47 | Whse. Document No. | Code[20] | 17-28 | - | - |
| 48 | Whse. Document Line No. | Integer | 17-28 | - | - |
| 50 | Qty. Rounding Precision | Decimal | 19-28 | - | - |
| 51 | Qty. Rounding Precision (Base) | Decimal | 19-28 | - | - |

## Keys

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

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| CalcBaseQty | (Decimal) | Decimal | public | 17-28 | - | - |
| CalcQty | (Decimal) | Decimal | public | 17-28 | - | - |
| AutofillQtyToHandle | (var Record Whse. Worksheet Line) | - | public | 17-28 | - | - |
| DeleteQtyToHandle | (var Record Whse. Worksheet Line) | - | public | 17-28 | - | - |
| AssignedQtyOnReservedLines | () | Decimal | public | 17-28 | - | - |
| CalcAvailableQtyBase | () | Decimal | public | 17-28 | - | - |
| CalcReservedNotFromILEQty | (Decimal, var Decimal, var Decimal) | - | public | 17-28 | - | - |
| CheckAvailQtytoMove | () | Decimal | public | 17-28 | - | - |
| SortWhseWkshLines | (Code[10], Code[10], Code[10], Enum Whse. Activity Sorting Method) | - | public | 17-28 | - | - |
| GetItem | (Code[20], var Text[100]) | - | public | 17-28 | - | - |
| CheckBin | (Code[10], Code[20], Boolean) | - | public | 17-28 | - | - |
| PutAwayCreate | (var Record Whse. Worksheet Line) | - | public | 17-28 | - | - |
| MovementCreate | (var Record Whse. Worksheet Line) | - | public | 17-28 | - | - |
| TemplateSelection | (Integer, Option, var Record Whse. Worksheet Line, var Boolean) | - | public | 17-28 | - | - |
| TemplateSelectionFromBatch | (var Record Whse. Worksheet Name) | - | public | 17-28 | - | - |
| OpenWhseWksh | (var Record Whse. Worksheet Line, var Code[10], var Code[10], var Code[10]) | - | public | 17-28 | - | - |
| OpenWhseWkshBatch | (var Record Whse. Worksheet Name) | - | public | 17-28 | - | - |
| CheckWhseWkshName | (Code[10], Code[10], var Record Whse. Worksheet Line) | - | public | 17-28 | - | - |
| SetWhseWkshName | (Code[10], Code[10], var Record Whse. Worksheet Line) | - | public | 17-28 | - | - |
| LookupWhseWkshName | (var Record Whse. Worksheet Line, var Code[10], var Code[10]) | - | public | 17-28 | - | - |
| SetHideValidationDialog | (Boolean) | - | public | 17-28 | - | - |
| OpenItemTrackingLines | () | - | public | 17-28 | - | - |
| AvailableQtyToPick | () | Decimal | public | 17-28 | - | - |
| AvailableQtyToPickExcludingQCBins | () | Decimal | public | 17-25 | Pending 23.0 | Replaced by procedure AvailableQtyToPick |
| InitLineWithItem | (Option, Code[20], Integer, Code[10], Code[20], Code[10], Decimal, Decimal, Decimal) | - | public | 17-21 | Pending 19.0 | Replaced by InitNewLineWithItem(). |
| SetUpNewLine | (Code[10], Code[10], Code[10], Enum Whse. Activity Sorting Method, Integer) | - | public | 17-28 | - | - |
| GetSortSeqNo | (Enum Whse. Activity Sorting Method) | Integer | public | 17-28 | - | - |
| SetItemTrackingLines | (Record Warehouse Entry, Decimal) | - | public | 17-28 | - | - |
| SetCurrentFieldNo | (Integer) | - | public | 17-28 | - | - |
| SetSourceFilter | (Integer, Option, Code[20], Integer, Boolean) | - | public | 17-28 | - | - |
| RetrieveItemTracking | (var Code[50], var Code[50]) | - | public | 17-19 | Pending 17.0 | Replaced by LookupItemTracking() |
| LookupItemTracking | (var Record Item Tracking Setup) | - | public | 17-28 | - | - |
| InitNewLineWithItem | (Enum Warehouse Worksheet Document Type, Code[20], Integer, Code[10], Code[20], Code[10], Decimal, Decimal, Decimal) | - | public | 19-28 | - | - |
| CheckWhseEmployee | () | - | public | 23-25 | Pending 23.0 | Replaced by CheckUserIsWhseEmployee procedure in WMS Management codeunit |
| AvailableQtyToPickForCurrentLine | () | Decimal | internal | 23-28 | - | - |
| QtyOnQCBins | (Boolean) | Decimal | internal | 23-25 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterAutofillQtyToHandle | (var Record Whse. Worksheet Line) | 17-28 | - | - |
| Integration event | OnAfterInitLineWithItem | () | 17-28 | - | - |
| Integration event | OnAfterGetItem | (var Record Whse. Worksheet Line, var Record Item) | 17-18 | - | - |
| Integration event | OnAutofillQtyToHandleOnbeforeModift | (var Record Whse. Worksheet Line) | 17-18 | Pending 16.0 | Replaced by OnAutofillQtyToHandleOnBeforeModify. |
| Integration event | OnAutofillQtyToHandleOnBeforeModify | (var Record Whse. Worksheet Line) | 17-28 | - | - |
| Integration event | OnBeforeCheckBin | (Record Whse. Worksheet Line, Code[10], Code[20], Boolean, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeCheckIncreaseBin | (var Record Whse. Worksheet Line, var Record Bin, Code[20], Decimal, Decimal, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeCheckTemplateName | (var Code[10], var Code[10], var Code[10], var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeCheckWhseEmployee | (Code[10], var Boolean) | 17-25 | Pending 23.0 | Use OnBeforeCheckUserIsWhseEmployee event in WMS Management codeunit. |
| Integration event | OnBeforeCheckWhseWkshName | (var Code[10], var Code[10], var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeMovementCreate | (var Record Whse. Worksheet Line, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforePutAwayCreate | (var Record Whse. Worksheet Line, var Boolean, Boolean) | 17-28 | - | - |
| Integration event | OnBeforeValidateQty | (var Record Whse. Worksheet Line, var Boolean) | 17-28 | - | - |
| Integration event | OnCalcAvailQtyToMoveOnAfterSetFilters | (var Record Whse. Worksheet Line, var Record Whse. Worksheet Line) | 17-28 | - | - |
| Integration event | OnBeforeCalcAvailableQtyBase | (var Record Whse. Worksheet Line, var Decimal, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeQtyOnQCBins | (var Record Whse. Worksheet Line, var Decimal, var Boolean) | 17-25 | Pending 23.0 | AvailableQtyToPick() removes the QC bins by default |
| Integration event | OnDeleteQtyToHandleOnBeforeModify | (var Record Whse. Worksheet Line) | 17-28 | - | - |
| Integration event | OnLookupWhseWkshNameOnBeforeRunModal | (var Record Whse. Worksheet Name) | 17-28 | - | - |
| Integration event | OnGetSortSeqNoOnCaseElse | (var Record Whse. Worksheet Line, Enum Whse. Activity Sorting Method) | 17-28 | - | - |
| Integration event | OnSortWhseWkshLinesOnCaseElse | (var Record Whse. Worksheet Line, Enum Whse. Activity Sorting Method) | 17-28 | - | - |
| Integration event | OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters | (var Record Whse. Worksheet Line, var Record Whse. Worksheet Line) | 18-28 | - | - |
| Integration event | OnBeforeCalcAvailQtyToMove | (var Record Whse. Worksheet Line, var Decimal, var Boolean) | 18-28 | - | - |
| Integration event | OnBeforeOpenItemTrackingLines | (var Record Whse. Worksheet Line) | 18-28 | - | - |
| Integration event | OnAfterCheckAvailQtytoMove | (var Record Whse. Worksheet Line, Record Whse. Worksheet Line, var Decimal) | 19-28 | - | - |
| Integration event | OnAfterGetItem | (var Record Whse. Worksheet Line, var Record Item, var Text[100]) | 19-28 | - | - |
| Integration event | OnBeforeUpdatePickQtyToHandleBase | (var Record Whse. Worksheet Line, Integer, var Boolean) | 19-28 | - | - |
| Integration event | OnValidateQtyToHandleOnAfterCalcQtyAvailToMove | (var Record Whse. Worksheet Line, Record Whse. Worksheet Line, var Decimal) | 19-28 | - | - |
| Integration event | OnAfterSetSourceFilter | (var Record Whse. Worksheet Line, Integer, Option, Code[20], Integer, Boolean) | 22-28 | - | - |
| Integration event | OnWhseItemTrackingLinesSetSource | (var Record Whse. Worksheet Line, var Page Whse. Item Tracking Lines, var Boolean) | 26-28 | - | - |
| Integration event | OnUpdateQtyHandledForProdOrderOutput | (var Record Whse. Worksheet Line) | 27-28 | - | - |
| Integration event | OnAfterCalcAvailableQtyBase | (var Record Whse. Worksheet Line, var Decimal) | 28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.