Table 7326 Whse. Worksheet Line in 25
- App
- Base Application
- Namespace
- Microsoft.Warehouse.Worksheet
Fields, 45Keys, 12Procedures, 34Events, 26
Versions171819202122232425262728latest
Source29
Fields, 45
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Worksheet Template Name | Code[10] | - |
| 2 | Name | Code[10] | - |
| 3 | Line No. | Integer | - |
| 4 | Source Type | Integer | - |
| 5 | Source Subtype | Option | - |
| 6 | Source No. | Code[20] | - |
| 7 | Source Line No. | Integer | - |
| 8 | Source Subline No. | Integer | - |
| 9 | Source Document | Enum Warehouse Activity Source Document | - |
| 10 | Location Code | Code[10] | - |
| 11 | Shelf No. | Code[10] | - |
| 12 | From Zone Code | Code[10] | - |
| 13 | From Bin Code | Code[20] | - |
| 14 | To Bin Code | Code[20] | - |
| 15 | To Zone Code | Code[10] | - |
| 16 | Item No. | Code[20] | - |
| 17 | Quantity | Decimal | - |
| 18 | Qty. (Base) | Decimal | - |
| 19 | Qty. Outstanding | Decimal | - |
| 20 | Qty. Outstanding (Base) | Decimal | - |
| 21 | Qty. to Handle | Decimal | - |
| 22 | Qty. to Handle (Base) | Decimal | - |
| 23 | Qty. Handled | Decimal | - |
| 24 | Qty. Handled (Base) | Decimal | - |
| 27 | From Unit of Measure Code | Code[10] | - |
| 28 | Qty. per From Unit of Measure | Decimal | - |
| 29 | Unit of Measure Code | Code[10] | - |
| 30 | Qty. per Unit of Measure | Decimal | - |
| 31 | Variant Code | Code[10] | - |
| 32 | Description | Text[100] | - |
| 33 | Description 2 | Text[50] | - |
| 35 | Sorting Sequence No. | Integer | - |
| 36 | Due Date | Date | - |
| 39 | Destination Type | Enum Warehouse Destination Type | - |
| 40 | Destination No. | Code[20] | - |
| 41 | Shipping Agent Code | Code[10] | - |
| 42 | Shipping Agent Service Code | Code[10] | - |
| 43 | Shipment Method Code | Code[10] | - |
| 44 | Shipping Advice | Enum Sales Header Shipping Advice | - |
| 45 | Shipment Date | Date | - |
| 46 | Whse. Document Type | Enum Warehouse Worksheet Document Type | - |
| 47 | Whse. Document No. | Code[20] | - |
| 48 | Whse. Document Line No. | Integer | - |
| 50 | Qty. Rounding Precision | Decimal | - |
| 51 | Qty. Rounding Precision (Base) | Decimal | - |
Keys, 12
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Worksheet Template Name, Name, Location Code, Line No. | - |
| 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 | - |
Procedures, 34
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| CalcBaseQty | (Decimal) | Decimal | public | - | |||
| CalcQty | (Decimal) | Decimal | public | - | |||
| AutofillQtyToHandle | (var Record Whse. Worksheet Line) | public | - | ||||
| DeleteQtyToHandle | (var Record Whse. Worksheet Line) | public | - | ||||
| AssignedQtyOnReservedLines | () | Decimal | public | - | |||
| CalcAvailableQtyBase | () | Decimal | public | - | |||
| CalcReservedNotFromILEQty | (Decimal, var Decimal, var Decimal) | public | - | ||||
| CheckAvailQtytoMove | () | Decimal | public | - | |||
| SortWhseWkshLines | (Code[10], Code[10], Code[10], Enum Whse. Activity Sorting Method) | public | - | ||||
| GetItem | (Code[20], var Text[100]) | public | - | ||||
| CheckBin | (Code[10], Code[20], Boolean) | public | - | ||||
| PutAwayCreate | (var Record Whse. Worksheet Line) | public | - | ||||
| MovementCreate | (var Record Whse. Worksheet Line) | public | - | ||||
| TemplateSelection | (Integer, Option, var Record Whse. Worksheet Line, var Boolean) | public | - | ||||
| TemplateSelectionFromBatch | (var Record Whse. Worksheet Name) | public | - | ||||
| OpenWhseWksh | (var Record Whse. Worksheet Line, var Code[10], var Code[10], var Code[10]) | public | - | ||||
| OpenWhseWkshBatch | (var Record Whse. Worksheet Name) | public | - | ||||
| CheckWhseWkshName | (Code[10], Code[10], var Record Whse. Worksheet Line) | public | - | ||||
| SetWhseWkshName | (Code[10], Code[10], var Record Whse. Worksheet Line) | public | - | ||||
| LookupWhseWkshName | (var Record Whse. Worksheet Line, var Code[10], var Code[10]) | public | - | ||||
| SetHideValidationDialog | (Boolean) | public | - | ||||
| OpenItemTrackingLines | () | public | - | ||||
| AvailableQtyToPick | () | Decimal | public | - | |||
| AvailableQtyToPickExcludingQCBins | () | Decimal | public | Pending 23.0 | |||
| Replaced by procedure AvailableQtyToPick | |||||||
| SetUpNewLine | (Code[10], Code[10], Code[10], Enum Whse. Activity Sorting Method, Integer) | public | - | ||||
| GetSortSeqNo | (Enum Whse. Activity Sorting Method) | Integer | public | - | |||
| SetItemTrackingLines | (Record Warehouse Entry, Decimal) | public | - | ||||
| SetCurrentFieldNo | (Integer) | public | - | ||||
| SetSourceFilter | (Integer, Option, Code[20], Integer, Boolean) | public | - | ||||
| LookupItemTracking | (var Record Item Tracking Setup) | public | - | ||||
| InitNewLineWithItem | (Enum Warehouse Worksheet Document Type, Code[20], Integer, Code[10], Code[20], Code[10], Decimal, Decimal, Decimal) | public | - | ||||
| CheckWhseEmployee | () | public | Pending 23.0 | ||||
| Replaced by CheckUserIsWhseEmployee procedure in WMS Management codeunit | |||||||
| AvailableQtyToPickForCurrentLine | () | Decimal | internal | - | |||
| QtyOnQCBins | (Boolean) | Decimal | internal | - | |||
Events, 26
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterAutofillQtyToHandle | (var Record Whse. Worksheet Line) | - | ||||
| Integration event | OnAfterInitLineWithItem | () | - | ||||
| Integration event | OnAutofillQtyToHandleOnBeforeModify | (var Record Whse. Worksheet Line) | - | ||||
| Integration event | OnBeforeCheckBin | (Record Whse. Worksheet Line, Code[10], Code[20], Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeCheckIncreaseBin | (var Record Whse. Worksheet Line, var Record Bin, Code[20], Decimal, Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeCheckTemplateName | (var Code[10], var Code[10], var Code[10], var Boolean) | - | ||||
| Integration event | OnBeforeCheckWhseEmployee | (Code[10], var Boolean) | Pending 23.0 | ||||
| Use OnBeforeCheckUserIsWhseEmployee event in WMS Management codeunit. | |||||||
| Integration event | OnBeforeCheckWhseWkshName | (var Code[10], var Code[10], var Boolean) | - | ||||
| Integration event | OnBeforeMovementCreate | (var Record Whse. Worksheet Line, var Boolean) | - | ||||
| Integration event | OnBeforePutAwayCreate | (var Record Whse. Worksheet Line, var Boolean, Boolean) | - | ||||
| Integration event | OnBeforeValidateQty | (var Record Whse. Worksheet Line, var Boolean) | - | ||||
| Integration event | OnCalcAvailQtyToMoveOnAfterSetFilters | (var Record Whse. Worksheet Line, var Record Whse. Worksheet Line) | - | ||||
| Integration event | OnBeforeCalcAvailableQtyBase | (var Record Whse. Worksheet Line, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeQtyOnQCBins | (var Record Whse. Worksheet Line, var Decimal, var Boolean) | Pending 23.0 | ||||
| AvailableQtyToPick() removes the QC bins by default | |||||||
| Integration event | OnDeleteQtyToHandleOnBeforeModify | (var Record Whse. Worksheet Line) | - | ||||
| Integration event | OnLookupWhseWkshNameOnBeforeRunModal | (var Record Whse. Worksheet Name) | - | ||||
| Integration event | OnGetSortSeqNoOnCaseElse | (var Record Whse. Worksheet Line, Enum Whse. Activity Sorting Method) | - | ||||
| Integration event | OnSortWhseWkshLinesOnCaseElse | (var Record Whse. Worksheet Line, Enum Whse. Activity Sorting Method) | - | ||||
| Integration event | OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters | (var Record Whse. Worksheet Line, var Record Whse. Worksheet Line) | - | ||||
| Integration event | OnBeforeCalcAvailQtyToMove | (var Record Whse. Worksheet Line, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeOpenItemTrackingLines | (var Record Whse. Worksheet Line) | - | ||||
| Integration event | OnAfterCheckAvailQtytoMove | (var Record Whse. Worksheet Line, Record Whse. Worksheet Line, var Decimal) | - | ||||
| Integration event | OnAfterGetItem | (var Record Whse. Worksheet Line, var Record Item, var Text[100]) | - | ||||
| Integration event | OnBeforeUpdatePickQtyToHandleBase | (var Record Whse. Worksheet Line, Integer, var Boolean) | - | ||||
| Integration event | OnValidateQtyToHandleOnAfterCalcQtyAvailToMove | (var Record Whse. Worksheet Line, Record Whse. Worksheet Line, var Decimal) | - | ||||
| Integration event | OnAfterSetSourceFilter | (var Record Whse. Worksheet Line, Integer, Option, Code[20], Integer, Boolean) | - | ||||