Table "Whse. Worksheet Line"

ID 7326

Namespace: Microsoft.Warehouse.Worksheet

Properties

Name	Value
Caption	Whse. Worksheet Line
DataClassification	CustomerContent

Fields

Name	Type	Description
"Worksheet Template Name"	Code[10]
Name	Code[10]
"Line No."	Integer
"Source Type"	Integer
"Source Subtype"	Option
"Source No."	Code[20]
"Source Line No."	Integer
"Source Subline No."	Integer
"Source Document"	Enum Microsoft.Warehouse.Activity."Warehouse Activity Source Document"
"Location Code"	Code[10]
"Shelf No."	Code[10]
"From Zone Code"	Code[10]
"From Bin Code"	Code[20]
"To Bin Code"	Code[20]
"To Zone Code"	Code[10]
"Item No."	Code[20]
Quantity	Decimal
"Qty. (Base)"	Decimal
"Qty. Outstanding"	Decimal
"Qty. Outstanding (Base)"	Decimal
"Qty. to Handle"	Decimal
"Qty. to Handle (Base)"	Decimal
"Qty. Handled"	Decimal
"Qty. Handled (Base)"	Decimal
"From Unit of Measure Code"	Code[10]
"Qty. per From Unit of Measure"	Decimal
"Unit of Measure Code"	Code[10]
"Qty. per Unit of Measure"	Decimal
"Variant Code"	Code[10]
Description	Text[100]
"Description 2"	Text[50]
"Sorting Sequence No."	Integer
"Due Date"	Date
"Destination Type"	Enum Microsoft.Warehouse.Request."Warehouse Destination Type"
"Destination No."	Code[20]
"Shipping Agent Code"	Code[10]
"Shipping Agent Service Code"	Code[10]
"Shipment Method Code"	Code[10]
"Shipping Advice"	Enum Microsoft.Foundation.Shipping."Sales Header Shipping Advice"
"Shipment Date"	Date
"Whse. Document Type"	Enum Microsoft.Warehouse.Worksheet."Warehouse Worksheet Document Type"
"Whse. Document No."	Code[20]
"Whse. Document Line No."	Integer
"Qty. Rounding Precision"	Decimal
"Qty. Rounding Precision (Base)"	Decimal
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

CalcBaseQty

procedure CalcBaseQty(Qty: Decimal): Decimal

Parameters

Name	Type	Description
Qty	Decimal

Returns

Type	Description
Decimal

CalcQty

procedure CalcQty(QtyBase: Decimal): Decimal

Parameters

Name	Type	Description
QtyBase	Decimal

Returns

Type	Description
Decimal

AutofillQtyToHandle

procedure AutofillQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

DeleteQtyToHandle

procedure DeleteQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

AssignedQtyOnReservedLines

procedure AssignedQtyOnReservedLines(): Decimal

Returns

Type	Description
Decimal

CalcAvailableQtyBase

procedure CalcAvailableQtyBase(): Decimal

Returns

Type	Description
Decimal

CalcReservedNotFromILEQty

procedure CalcReservedNotFromILEQty(QtyBaseAvailToPick: Decimal, var QtyToPick: Decimal, var QtyToPickBase: Decimal)

Parameters

Name	Type	Description
QtyBaseAvailToPick	Decimal
QtyToPick	Decimal
QtyToPickBase	Decimal

CheckAvailQtytoMove

procedure CheckAvailQtytoMove(): Decimal

Returns

Type	Description
Decimal

SortWhseWkshLines

procedure SortWhseWkshLines(WhseWkshTemplate: Code[10], WhseWkshName: Code[10], LocationCode: Code[10], SortingMethod: Enum "Whse. Activity Sorting Method")

Parameters

Name	Type	Description
WhseWkshTemplate	Code[10]
WhseWkshName	Code[10]
LocationCode	Code[10]
SortingMethod	Enum Microsoft.Warehouse.Activity."Whse. Activity Sorting Method"

GetItem

procedure GetItem(ItemNo: Code[20], var ItemDescription: Text[100])

Parameters

Name	Type	Description
ItemNo	Code[20]
ItemDescription	Text[100]

CheckBin

procedure CheckBin(LocationCode: Code[10], BinCode: Code[20], Inbound: Boolean)

Parameters

Name	Type	Description
LocationCode	Code[10]
BinCode	Code[20]
Inbound	Boolean

PutAwayCreate

procedure PutAwayCreate(var WhsePutAwayWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhsePutAwayWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

MovementCreate

procedure MovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

TemplateSelection

procedure TemplateSelection(PageID: Integer, PageTemplate: Option, var WhseWkshLine: Record "Whse. Worksheet Line", var WhseWkshSelected: Boolean)

Parameters

Name	Type	Description
PageID	Integer
PageTemplate	Option
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
WhseWkshSelected	Boolean

TemplateSelectionFromBatch

procedure TemplateSelectionFromBatch(var WhseWkshName: Record "Whse. Worksheet Name")

Parameters

Name	Type	Description
WhseWkshName	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Name"

OpenWhseWksh

procedure OpenWhseWksh(var WhseWkshLine: Record "Whse. Worksheet Line", var CurrentWkshTemplateName: Code[10], var CurrentWkshName: Code[10], var CurrentLocationCode: Code[10])

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
CurrentWkshTemplateName	Code[10]
CurrentWkshName	Code[10]
CurrentLocationCode	Code[10]

OpenWhseWkshBatch

procedure OpenWhseWkshBatch(var WhseWkshName: Record "Whse. Worksheet Name")

Parameters

Name	Type	Description
WhseWkshName	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Name"

CheckWhseWkshName

procedure CheckWhseWkshName(CurrentWkshName: Code[10], CurrentLocationCode: Code[10], var WhseWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
CurrentWkshName	Code[10]
CurrentLocationCode	Code[10]
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

SetWhseWkshName

procedure SetWhseWkshName(CurrentWkshName: Code[10], CurrentLocationCode: Code[10], var WhseWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
CurrentWkshName	Code[10]
CurrentLocationCode	Code[10]
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

LookupWhseWkshName

procedure LookupWhseWkshName(var WhseWkshLine: Record "Whse. Worksheet Line", var CurrentWkshName: Code[10], var CurrentLocationCode: Code[10])

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
CurrentWkshName	Code[10]
CurrentLocationCode	Code[10]

SetHideValidationDialog

procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)

Parameters

Name	Type	Description
NewHideValidationDialog	Boolean

OpenItemTrackingLines

procedure OpenItemTrackingLines()

AvailableQtyToPick

procedure AvailableQtyToPick(): Decimal

Returns

Type	Description
Decimal

InitNewLineWithItem

procedure 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)

Parameters

Name	Type	Description
DocumentType	Enum Microsoft.Warehouse.Worksheet."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

procedure SetUpNewLine(WhseWkshTemplate: Code[10], WhseWkshName: Code[10], LocationCode: Code[10], SortingMethod: Enum "Whse. Activity Sorting Method", LineNo: Integer)

Parameters

Name	Type	Description
WhseWkshTemplate	Code[10]
WhseWkshName	Code[10]
LocationCode	Code[10]
SortingMethod	Enum Microsoft.Warehouse.Activity."Whse. Activity Sorting Method"
LineNo	Integer

GetSortSeqNo

procedure GetSortSeqNo(SortMethod: Enum "Whse. Activity Sorting Method"): Integer

Parameters

Name	Type	Description
SortMethod	Enum Microsoft.Warehouse.Activity."Whse. Activity Sorting Method"

Returns

Type	Description
Integer

SetItemTrackingLines

procedure SetItemTrackingLines(WhseEntry: Record "Warehouse Entry", QtyToEmpty: Decimal)

Parameters

Name	Type	Description
WhseEntry	Table Microsoft.Warehouse.Ledger."Warehouse Entry"
QtyToEmpty	Decimal

SetCurrentFieldNo

procedure SetCurrentFieldNo(FieldNo: Integer)

Parameters

Name	Type	Description
FieldNo	Integer

SetSourceFilter

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

Parameters

Name	Type	Description
SourceType	Integer
SourceSubType	Option
SourceNo	Code[20]
SourceLineNo	Integer
SetKey	Boolean

LookupItemTracking

procedure LookupItemTracking(var WhseItemTrackingSetup: Record "Item Tracking Setup" temporary)

Parameters

Name	Type	Description
WhseItemTrackingSetup	Table Microsoft.Inventory.Tracking."Item Tracking Setup"

Events

OnAfterAutofillQtyToHandle

[IntegrationEvent(False,False)]
local procedure OnAfterAutofillQtyToHandle(var WhseWorksheetLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

OnAfterInitLineWithItem

[IntegrationEvent(True,False)]
local procedure OnAfterInitLineWithItem()

OnAfterCheckAvailQtytoMove

[IntegrationEvent(False,False)]
local procedure OnAfterCheckAvailQtytoMove(var WhseWorksheetLine: Record "Whse. Worksheet Line", xWhseWorksheetLine: Record "Whse. Worksheet Line", var QtyAvailToMoveBase: Decimal)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
xWhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
QtyAvailToMoveBase	Decimal

OnAfterGetItem

[IntegrationEvent(False,False)]
local procedure OnAfterGetItem(var WhseWorksheetLine: Record "Whse. Worksheet Line", var Item: Record Item, var ItemDescription: Text[100])

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
Item	Table Microsoft.Inventory.Item.Item
ItemDescription	Text[100]

OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters

[IntegrationEvent(True,False)]
local procedure OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters(var WhseWorksheetLine: Record "Whse. Worksheet Line", var FilteredWhseWorksheetLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
FilteredWhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

OnAutofillQtyToHandleOnBeforeModify

[IntegrationEvent(False,False)]
local procedure OnAutofillQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

OnBeforeCalcAvailQtyToMove

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcAvailQtyToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line", var QtyAvailToMoveBase: Decimal, var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
QtyAvailToMoveBase	Decimal
IsHandled	Boolean

OnBeforeCheckBin

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckBin(WhseWorksheetLine: Record "Whse. Worksheet Line", LocationCode: Code[10], BinCode: Code[20], Inbound: Boolean, var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
LocationCode	Code[10]
BinCode	Code[20]
Inbound	Boolean
IsHandled	Boolean

OnBeforeCheckIncreaseBin

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckIncreaseBin(var WhseWorksheetLine: Record "Whse. Worksheet Line", var Bin: Record Bin, BinCode: Code[20], Cubage: Decimal, Weight: Decimal, var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
Bin	Table Microsoft.Warehouse.Structure.Bin
BinCode	Code[20]
Cubage	Decimal
Weight	Decimal
IsHandled	Boolean

OnBeforeCheckTemplateName

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckTemplateName(var WkshTemplateName: Code[10], var WkshName: Code[10], var LocationCode: Code[10], var IsHandled: Boolean)

Parameters

Name	Type	Description
WkshTemplateName	Code[10]
WkshName	Code[10]
LocationCode	Code[10]
IsHandled	Boolean

OnBeforeCheckWhseWkshName

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckWhseWkshName(var WkshTemplateName: Code[10], var LocationCode: Code[10], var IsHandled: Boolean)

Parameters

Name	Type	Description
WkshTemplateName	Code[10]
LocationCode	Code[10]
IsHandled	Boolean

OnBeforeMovementCreate

[IntegrationEvent(False,False)]
local procedure OnBeforeMovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line", var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
IsHandled	Boolean

OnBeforeOpenItemTrackingLines

[IntegrationEvent(False,False)]
local procedure OnBeforeOpenItemTrackingLines(var WhseWkshLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWkshLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

OnBeforePutAwayCreate

[IntegrationEvent(False,False)]
local procedure OnBeforePutAwayCreate(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line", var IsHandled: Boolean, HideValidationDialog: Boolean)

Parameters

Name	Type	Description
PutAwayWhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
IsHandled	Boolean
HideValidationDialog	Boolean

OnBeforeUpdatePickQtyToHandleBase

[IntegrationEvent(False,False)]
local procedure OnBeforeUpdatePickQtyToHandleBase(var WhseWorksheetLine: Record "Whse. Worksheet Line", CurrFieldNo: Integer, var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
CurrFieldNo	Integer
IsHandled	Boolean

OnBeforeValidateQty

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateQty(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line", var IsHandled: Boolean)

Parameters

Name	Type	Description
PutAwayWhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
IsHandled	Boolean

OnCalcAvailQtyToMoveOnAfterSetFilters

[IntegrationEvent(False,False)]
local procedure OnCalcAvailQtyToMoveOnAfterSetFilters(var NewWhseWorksheetLine: Record "Whse. Worksheet Line", var WhseWorksheetLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
NewWhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

OnBeforeCalcAvailableQtyBase

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line", var AvailableQty: Decimal, var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
AvailableQty	Decimal
IsHandled	Boolean

OnDeleteQtyToHandleOnBeforeModify

[IntegrationEvent(False,False)]
procedure OnDeleteQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"

OnLookupWhseWkshNameOnBeforeRunModal

[IntegrationEvent(False,False)]
local procedure OnLookupWhseWkshNameOnBeforeRunModal(var WhseWkshName: Record "Whse. Worksheet Name")

Parameters

Name	Type	Description
WhseWkshName	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Name"

OnGetSortSeqNoOnCaseElse

[IntegrationEvent(False,False)]
local procedure OnGetSortSeqNoOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line", SortMethod: Enum "Whse. Activity Sorting Method")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
SortMethod	Enum Microsoft.Warehouse.Activity."Whse. Activity Sorting Method"

OnSortWhseWkshLinesOnCaseElse

[IntegrationEvent(False,False)]
local procedure OnSortWhseWkshLinesOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line", SortingMethod: Enum "Whse. Activity Sorting Method")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
SortingMethod	Enum Microsoft.Warehouse.Activity."Whse. Activity Sorting Method"

OnValidateQtyToHandleOnAfterCalcQtyAvailToMove

[IntegrationEvent(False,False)]
local procedure OnValidateQtyToHandleOnAfterCalcQtyAvailToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line", xWhseWorksheetLine: Record "Whse. Worksheet Line", var QtyAvailToMoveBase: Decimal)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
xWhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
QtyAvailToMoveBase	Decimal

OnAfterSetSourceFilter

[IntegrationEvent(False,False)]
local procedure OnAfterSetSourceFilter(var WhseWorksheetLine: Record "Whse. Worksheet Line", SourceType: Integer, SourceSubtype: Option, SourceNo: Code[20], SourceLineNo: Integer, SetKey: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
SourceType	Integer
SourceSubtype	Option
SourceNo	Code[20]
SourceLineNo	Integer
SetKey	Boolean

OnWhseItemTrackingLinesSetSource

[IntegrationEvent(False,False)]
local procedure OnWhseItemTrackingLinesSetSource(var WhseWorksheetLine: Record "Whse. Worksheet Line", var WhseItemTrackingLines: Page "Whse. Item Tracking Lines", var IsHandled: Boolean)

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"
WhseItemTrackingLines	Page Microsoft.Warehouse.Tracking."Whse. Item Tracking Lines"
IsHandled	Boolean

OnUpdateQtyHandledForProdOrderOutput

[IntegrationEvent(False,False)]
local procedure OnUpdateQtyHandledForProdOrderOutput(var WhseWorksheetLine: Record "Whse. Worksheet Line")

Parameters

Name	Type	Description
WhseWorksheetLine	Table Microsoft.Warehouse.Worksheet."Whse. Worksheet Line"