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]
|
Specifies the number of the source document that the entry originates from.
|
| "Source Line No." |
Integer
|
Specifies the line number of the source document that the entry originates from.
|
| "Source Subline No." |
Integer
|
|
| "Source Document" |
Enum Microsoft.Warehouse.Activity."Warehouse Activity Source Document"
|
Specifies the type of document that the line relates to.
|
| "Location Code" |
Code[10]
|
|
| "Shelf No." |
Code[10]
|
Specifies the shelf number of the item for information use.
|
| "From Zone Code" |
Code[10]
|
Specifies the zone from which the items should be taken.
|
| "From Bin Code" |
Code[20]
|
Specifies the code of the bin from which the items should be taken.
|
| "To Bin Code" |
Code[20]
|
Specifies the code of the bin into which the items should be placed.
|
| "To Zone Code" |
Code[10]
|
Specifies the code of the zone in which the items should be placed.
|
| "Item No." |
Code[20]
|
Specifies the number of the item that the line concerns.
|
| Quantity |
Decimal
|
Specifies how many units of the item you want to move.
|
| "Qty. (Base)" |
Decimal
|
|
| "Qty. Outstanding" |
Decimal
|
Specifies the quantity that still needs to be handled.
|
| "Qty. Outstanding (Base)" |
Decimal
|
|
| "Qty. to Handle" |
Decimal
|
Specifies how many units of the item you want to move.
|
| "Qty. to Handle (Base)" |
Decimal
|
|
| "Qty. Handled" |
Decimal
|
Specifies the quantity that has been handled and registered.
|
| "Qty. Handled (Base)" |
Decimal
|
|
| "From Unit of Measure Code" |
Code[10]
|
|
| "Qty. per From Unit of Measure" |
Decimal
|
|
| "Unit of Measure Code" |
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.
|
| "Qty. per Unit of Measure" |
Decimal
|
|
| "Variant Code" |
Code[10]
|
Specifies the variant of the item on the line.
|
| Description |
Text[100]
|
Specifies the description of the item on the line.
|
| "Description 2" |
Text[50]
|
Specifies information in addition to the description.
|
| "Sorting Sequence No." |
Integer
|
|
| "Due Date" |
Date
|
Specifies the due date of the line.
|
| "Destination Type" |
Enum Microsoft.Warehouse.Request."Warehouse Destination Type"
|
Specifies the type of destination associated with the warehouse worksheet line.
|
| "Destination No." |
Code[20]
|
Specifies the number of the customer, vendor, or location for which the items should be processed.
|
| "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"
|
Specifies the shipping advice on the warehouse shipment line associated with this worksheet line.
|
| "Shipment Date" |
Date
|
|
| "Whse. Document Type" |
Enum Microsoft.Warehouse.Worksheet."Warehouse Worksheet Document Type"
|
Specifies the type of warehouse document this line is associated with.
|
| "Whse. Document No." |
Code[20]
|
Specifies the number of the warehouse document.
|
| "Whse. Document Line No." |
Integer
|
Specifies the number of the line in the warehouse document that is the basis for the worksheet line.
|
| "Qty. Rounding Precision" |
Decimal
|
|
| "Qty. Rounding Precision (Base)" |
Decimal
|
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemCreatedByUserName |
Text[50]
|
|
| SystemCreatedByFullName |
Text[80]
|
|
| SystemModifiedByUserName |
Text[50]
|
|
| SystemModifiedByFullName |
Text[80]
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
CalcBaseQty
procedure CalcBaseQty(Qty: Decimal): Decimal
Parameters
| Name |
Type |
Description |
|
Qty
|
Decimal |
|
Returns
CalcQty
procedure CalcQty(QtyBase: Decimal): Decimal
Parameters
| Name |
Type |
Description |
|
QtyBase
|
Decimal |
|
Returns
AutofillQtyToHandle
procedure AutofillQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")
Parameters
DeleteQtyToHandle
procedure DeleteQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")
Parameters
AssignedQtyOnReservedLines
procedure AssignedQtyOnReservedLines(): Decimal
Returns
CalcAvailableQtyBase
procedure CalcAvailableQtyBase(): Decimal
Returns
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
SortWhseWkshLines
procedure SortWhseWkshLines(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method")
Parameters
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
MovementCreate
procedure MovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line")
Parameters
TemplateSelection
procedure TemplateSelection(PageID: Integer; PageTemplate: Option; var WhseWkshLine: Record "Whse. Worksheet Line"; var WhseWkshSelected: Boolean)
Parameters
TemplateSelectionFromBatch
procedure TemplateSelectionFromBatch(var WhseWkshName: Record "Whse. Worksheet Name")
Parameters
OpenWhseWksh
procedure OpenWhseWksh(var WhseWkshLine: Record "Whse. Worksheet Line"; var CurrentWkshTemplateName: Code[10]; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])
Parameters
OpenWhseWkshBatch
procedure OpenWhseWkshBatch(var WhseWkshName: Record "Whse. Worksheet Name")
Parameters
CheckWhseWkshName
procedure CheckWhseWkshName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var WhseWkshLine: Record "Whse. Worksheet Line")
Parameters
SetWhseWkshName
procedure SetWhseWkshName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var WhseWkshLine: Record "Whse. Worksheet Line")
Parameters
LookupWhseWkshName
procedure LookupWhseWkshName(var WhseWkshLine: Record "Whse. Worksheet Line"; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])
Parameters
SetHideValidationDialog
procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)
Parameters
| Name |
Type |
Description |
|
NewHideValidationDialog
|
Boolean |
|
OpenItemTrackingLines
procedure OpenItemTrackingLines()
AvailableQtyToPick
procedure AvailableQtyToPick(): Decimal
Returns
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
SetUpNewLine
procedure SetUpNewLine(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method"; LineNo: Integer)
Parameters
GetSortSeqNo
procedure GetSortSeqNo(SortMethod: Enum "Whse. Activity Sorting Method"): Integer
Parameters
Returns
SetItemTrackingLines
procedure SetItemTrackingLines(WhseEntry: Record "Warehouse Entry"; QtyToEmpty: Decimal)
Parameters
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")
Parameters
Events
OnAfterAutofillQtyToHandle
[IntegrationEvent(False,False)]
local procedure OnAfterAutofillQtyToHandle(var WhseWorksheetLine: Record "Whse. Worksheet Line")
Parameters
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
OnAfterGetItem
[IntegrationEvent(False,False)]
local procedure OnAfterGetItem(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var Item: Record Item; var ItemDescription: Text[100])
Parameters
OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters
[IntegrationEvent(True,False)]
local procedure OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var FilteredWhseWorksheetLine: Record "Whse. Worksheet Line")
Parameters
OnAutofillQtyToHandleOnBeforeModify
[IntegrationEvent(False,False)]
local procedure OnAutofillQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line")
Parameters
OnBeforeCalcAvailQtyToMove
[IntegrationEvent(False,False)]
local procedure OnBeforeCalcAvailQtyToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal; var IsHandled: Boolean)
Parameters
OnBeforeCheckBin
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckBin(WhseWorksheetLine: Record "Whse. Worksheet Line"; LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean; var IsHandled: Boolean)
Parameters
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
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
OnBeforeOpenItemTrackingLines
[IntegrationEvent(False,False)]
local procedure OnBeforeOpenItemTrackingLines(var WhseWkshLine: Record "Whse. Worksheet Line")
Parameters
OnBeforePutAwayCreate
[IntegrationEvent(False,False)]
local procedure OnBeforePutAwayCreate(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean; HideValidationDialog: Boolean)
Parameters
OnBeforeUpdatePickQtyToHandleBase
[IntegrationEvent(False,False)]
local procedure OnBeforeUpdatePickQtyToHandleBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; CurrFieldNo: Integer; var IsHandled: Boolean)
Parameters
OnBeforeValidateQty
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateQty(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean)
Parameters
OnCalcAvailQtyToMoveOnAfterSetFilters
[IntegrationEvent(False,False)]
local procedure OnCalcAvailQtyToMoveOnAfterSetFilters(var NewWhseWorksheetLine: Record "Whse. Worksheet Line"; var WhseWorksheetLine: Record "Whse. Worksheet Line")
Parameters
OnBeforeCalcAvailableQtyBase
[IntegrationEvent(False,False)]
local procedure OnBeforeCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var AvailableQty: Decimal; var IsHandled: Boolean)
Parameters
OnAfterCalcAvailableQtyBase
[IntegrationEvent(False,False)]
local procedure OnAfterCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var AvailableQty: Decimal)
Parameters
OnDeleteQtyToHandleOnBeforeModify
[IntegrationEvent(False,False)]
procedure OnDeleteQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line")
Parameters
OnLookupWhseWkshNameOnBeforeRunModal
[IntegrationEvent(False,False)]
local procedure OnLookupWhseWkshNameOnBeforeRunModal(var WhseWkshName: Record "Whse. Worksheet Name")
Parameters
OnGetSortSeqNoOnCaseElse
[IntegrationEvent(False,False)]
local procedure OnGetSortSeqNoOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SortMethod: Enum "Whse. Activity Sorting Method")
Parameters
OnSortWhseWkshLinesOnCaseElse
[IntegrationEvent(False,False)]
local procedure OnSortWhseWkshLinesOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SortingMethod: Enum "Whse. Activity Sorting Method")
Parameters
OnValidateQtyToHandleOnAfterCalcQtyAvailToMove
[IntegrationEvent(False,False)]
local procedure OnValidateQtyToHandleOnAfterCalcQtyAvailToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; xWhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal)
Parameters
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
OnWhseItemTrackingLinesSetSource
[IntegrationEvent(False,False)]
local procedure OnWhseItemTrackingLinesSetSource(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var WhseItemTrackingLines: Page "Whse. Item Tracking Lines"; var IsHandled: Boolean)
Parameters
OnUpdateQtyHandledForProdOrderOutput
[IntegrationEvent(False,False)]
local procedure OnUpdateQtyHandledForProdOrderOutput(var WhseWorksheetLine: Record "Whse. Worksheet Line")
Parameters
See also