Table 7321 "Warehouse Shipment Line"
Base Application · Microsoft.Warehouse.Document
Across versions
- BC23present
- BC24declaration changed
- BC252 events added
- BC262 procedures changed, 2 events added
- BC274 events added
- BC2839 fields changed, 2 events added
- BC291 procedures removed, 1 events removed
- BC30unchanged
Neighbourhood 45 connected objects and pages
Base Application · Microsoft.Warehouse.Document · BC23-30 · source at 866a524f · facts from BC29
Learn documents this table through its pages: Page 915 “Asm.-to-Order Whse. Shpt. Line” (10 Learn pages), Page 7341 “Whse. Shipment Lines” (2).
Properties
| Property | Value |
|---|---|
| Caption | Warehouse Shipment 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 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | not editable |
| 2 | Line No. Δ BC28 | Integer | Specifies the number of the warehouse shipment line. | not editable |
| 3 | Source Type Δ BC28 | Integer | Specifies the number of the table that is the source of the receipt line. | not editable |
| 4 | Source Subtype Δ BC28 | Option | Specifies the source subtype of the document to which the line relates. | 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 |
| 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 Δ BC28 | Code[10] | Specifies the code of the location from which the items on the line are being shipped. | TableRelation Table 14 “Location”; not editable |
| 11 | Shelf No. Δ BC28 | Code[10] | Specifies the shelf number of the item for informational use. | |
| 12 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (if (“Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”))) |
| 13 | Zone Code Δ BC28 | Code[10] | Specifies the code of the zone where the bin on this shipment line is located. | TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”))) |
| 14 | Item No. Δ BC28 | Code[20] | Specifies the number of the item that should be shipped. | TableRelation Table 27 “Item”; not editable |
| 15 | Quantity Δ BC28 | Decimal | Specifies the quantity that should be shipped. | not editable |
| 16 | Qty. (Base) Δ BC28 | Decimal | Specifies the quantity that should be shipped, in the base unit of measure. via Page 7341 “Whse. Shipment Lines” | 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 7341 “Whse. Shipment Lines” | not editable |
| 21 | Qty. to Ship Δ BC28 | Decimal | Specifies the quantity of items that remain to be shipped. | |
| 22 | Qty. to Ship (Base) Δ BC28 | Decimal | Specifies the quantity, in base units of measure, that will be shipped when the warehouse shipment is posted. via Page 915 “Asm.-to-Order Whse. Shpt. Line” | |
| 23 | Qty. Picked Δ BC28 | Decimal | Specifies how many of the total shipment quantity have been registered as picked. | not editable |
| 24 | Qty. Picked (Base) Δ BC28 | Decimal | Specifies how many of the total shipment quantity in the base unit of measure have been registered as picked. via Page 7341 “Whse. Shipment Lines” | not editable |
| 25 | Qty. Shipped Δ BC28 | Decimal | Specifies the quantity of the item on the line that is posted as shipped. | not editable |
| 26 | Qty. Shipped (Base) Δ BC28 | Decimal | Specifies the quantity that is posted as shipped expressed in the base unit of measure. via Page 7341 “Whse. Shipment Lines” | not editable |
| 27 | Pick Qty. Δ BC28 | Decimal | Specifies the quantity in pick instructions assigned to be picked for the warehouse shipment line. | FlowField: sum(“Warehouse Activity Line”.“Qty. Outstanding” where(“Activity Type” = const(Pick), “Whse. Document Type” = const(Shipment), “Whse. Document No.” = field(“No.”), “Whse. Document Line No.” = field(“Line No.”), “Unit of Measure Code” = field(“Unit of Measure Code”), “Action Type” = filter(” “ | Plac…; not editable |
| 28 | Pick Qty. (Base) Δ BC28 | Decimal | Specifies the quantity, in the base unit of measure, in pick instructions, that is assigned to be picked for the warehouse shipment line. via Page 7341 “Whse. Shipment Lines” | FlowField: sum(“Warehouse Activity Line”.“Qty. Outstanding (Base)” where(“Activity Type” = const(Pick), “Whse. Document Type” = const(Shipment), “Whse. Document No.” = field(“No.”), “Whse. Document Line No.” = field(“Line No.”), “Action Type” = filter(” “ | Place), “Original Breakbulk” = const(false), “Breakbu…; 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.”))); not editable |
| 30 | Qty. per Unit of Measure Δ BC28 | Decimal | Specifies the number of base units of measure that are in the unit of measure specified for the item on the line. | 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.”))); not editable |
| 32 | Description Δ BC28 | Text[100] | Specifies the description of the item in the line. | not editable |
| 33 | Description 2 Δ BC28 | Text[50] | Specifies information in addition to the description of the item in the line. | not editable |
| 34 | Status Δ BC26 Δ BC28 | Enum “Warehouse Shipment Status” | Specifies the status of the shipment line. | enum Enum 7320 “Warehouse Shipment Status”; not editable |
| 35 | Sorting Sequence No. | Integer | — | not editable |
| 36 | Due Date Δ BC28 | Date | Specifies the date when the related warehouse activity, such as a pick, must be completed to ensure items can be shipped by the shipment date. | |
| 39 | Destination Type Δ BC28 | Enum “Warehouse Destination Type” | Specifies the type of destination associated with the warehouse shipment line. | enum Enum 7310 “Warehouse Destination Type”; not editable |
| 40 | Destination No. Δ BC28 | Code[20] | Specifies the number of the customer, vendor, or location to which the items should be shipped. | 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 | Cubage Δ BC28 | Decimal | — | |
| 42 | Weight Δ BC28 | Decimal | — | |
| 44 | Shipping Advice | Enum “Sales Header Shipping Advice” | — | enum Enum 3657 “Sales Header Shipping Advice”; not editable |
| 45 | Shipment Date Δ BC28 | Date | Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time. | |
| 46 | Completely Picked | Boolean | — | not editable |
| 48 | Not upd. by Src. Doc. Post. | Boolean | — | not editable |
| 49 | Posting from Whse. Ref. | Integer | — | not editable |
| 50 | Qty. Rounding Precision Δ BC28 | Decimal | — | not editable |
| 51 | Qty. Rounding Precision (Base) Δ BC28 | Decimal | — | not editable |
| 900 | Assemble to Order Δ BC28 | Boolean | Specifies if the warehouse shipment line is for items that are assembled to a sales order before it is shipped. | not editable |
Keys
- Key1: No., Line No. (clustered)
- Key2: No., Sorting Sequence No.
- Key3: No., Item No.
- Key4: No., Source Document, Source No.
- Key5: No., Shelf No.
- Key6: No., Bin Code
- Key7: No., Due Date
- Key8: No., Destination Type, Destination No.
- Key9: Source Type, Source Subtype, Source No., Source Line No., Assemble to Order
- Key10: No., Source Type, Source Subtype, Source No., Source Line No.
- Key11: Item No., Location Code, Variant Code, Due Date
- Key12: Bin Code, Location Code
Events published
OnAfterAutofillQtyToHandle(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var HideValidationDialog: Boolean)(integration)OnAfterCreatePickDoc(var WarehouseShipmentHeader: Record "Warehouse Shipment Header"; var WhseShptLine: Record "Warehouse Shipment Line")(integration)OnAfterCreateWhseItemTrackingLines(var WarehouseShipmentLine: Record "Warehouse Shipment Line")(integration)OnAfterGetWhseShptHeader(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var WarehouseShipmentHeader: Record "Warehouse Shipment Header"; WhseShptNo: Code[20])(integration)OnAfterInitQtyToShip(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; CurrentFieldNo: Integer)(integration)OnAfterOpenItemTrackingLines(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var SecondSourceQtyArray: array[3] of Decimal)(integration)OnAfterSetSourceFilter(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)(integration)OnAutoFillQtyToHandleOnBeforeModify(var WarehouseShipmentLine: Record "Warehouse Shipment Line")(integration)OnBeforeAutofillQtyToHandle(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var HideValidationDialog: Boolean; var IsHandled: Boolean)(integration)OnBeforeGetShipmentLineStatus(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var NewStatus: Enum "Warehouse Shipment Status"; var IsHandled: Boolean)+ BC26 (integration)OnBeforeCheckBin(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var Bin: Record Bin; DeductCubage: Decimal; DeductWeight: Decimal; IgnoreErrors: Boolean; var ErrorOccured: Boolean; var IsHandled: Boolean)(integration)OnBeforeCheckSourceDocLineQty(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnBeforeCreatePickDoc(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; WarehouseShipmentHeader: Record "Warehouse Shipment Header"; HideValidationDialog: Boolean; var IsHandled: Boolean)(integration)OnBeforeCompareQtyToShipAndOutstandingQty(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnBeforeCompareShipAndPickQty(WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean; CurrentFieldNo: Integer)(integration)OnValidateQtyToShipOnBeforeCheckConfirm(var Confirmed: Boolean; WarehouseShipmentLine: Record "Warehouse Shipment Line"; CurrentFieldNo: Integer)+ BC28 (integration)OnBeforeInitOutstandingQtys(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeOpenItemTrackingLines(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)- subscribers: Codeunit 20563 “Subc. WhsePostShipment Ext” HandleWipTransferOnBeforeOpenItemTrackingLines
OnBeforeTestReleased(var WhseShptHeader: Record "Warehouse Shipment Header"; var StatusCheckSuspended: Boolean)(integration)OnBeforeUpdateDocumentStatus(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnBeforeValidateQuantityIsBalanced(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean; xWarehouseShipmentLine: Record "Warehouse Shipment Line")(integration)- subscribers: Codeunit 20563 “Subc. WhsePostShipment Ext” HandleWipTransferOnBeforeValidateQuantityIsBalanced
OnBeforeValidateQtyToShipBase(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; xWarehouseShipmentLine: Record "Warehouse Shipment Line"; CallingFieldNo: Integer; var IsHandled: Boolean)(integration)- subscribers: Codeunit 20563 “Subc. WhsePostShipment Ext” HandleWipTransferOnBeforeValidateQtyToShipBase
OnBeforeCreateWhseItemTrackingLines(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnCheckSourceDocLineQtyOnBeforeFieldError(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; WhseQtyOutstandingBase: Decimal; var QtyOutstandingBase: Decimal; QuantityBase: Decimal; var IsHandled: Boolean)(integration)OnCheckSourceDocLineQtyOnCaseSourceType(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; WhseQtyOutstandingBase: Decimal; var QtyOutstandingBase: Decimal; QuantityBase: Decimal)(integration)OnValidateQuantityStatusUpdate(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; xWarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnDeleteQtyToHandleOnBeforeModify(var WhseShptLine: Record "Warehouse Shipment Line")(integration)OnCreatePickDocOnBeforeCreatePickDoc(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var WhseShptLine: Record "Warehouse Shipment Line"; var WhseShptHeader2: Record "Warehouse Shipment Header"; HideValidationDialog: Boolean; var IsHandled: Boolean)(integration)OnBeforeDeleteQtyToHandle(var WhseShptLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnBeforeSetQuantityBase(var Rec: Record "Warehouse Shipment Line"; var QuantityBase: Decimal; var IsHandled: Boolean)(integration)OnAfterValidateQtyToShip(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var xWarehouseShipmentLine: Record "Warehouse Shipment Line")(integration)- subscribers: Codeunit 5856 “TransferOrder-Post Transfer” WarehouseShipmentLineOnValidateQtyToShip
OnBeforeCalcBaseQty(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var Qty: Decimal; FromFieldName: Text; ToFieldName: Text; var SuppressQtyPerUoMTestfield: Boolean)+ BC28 − BC28 (integration)- subscribers: Codeunit 20563 “Subc. WhsePostShipment Ext” HandleWipTransferOnBeforeCalcBaseQty
OnAfterSetItemData(var WarehouseShipmentLine: Record "Warehouse Shipment Line")(integration)OnCreatePickDocFromWhseShptOnBeforeRunWhseShipmentCreatePick(var WhseShipmentCreatePick: Report "Whse.-Shipment - Create Pick")(integration)OnDeleteOnBeforeConfirmDelete(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; var IsHandled: Boolean)(integration)OnCheckSourceDocLineQtyOnSetQtyOutstandingBase(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; QuantityBase: Decimal; WhseQtyOutstandingBase: Decimal; var QtyOutstandingBase: Decimal)+ BC25 (integration)- subscribers: Codeunit 5995 “Service Warehouse Mgt.” OnCheckSourceDocLineQtyOnSetQtyOutstandingBase
OnOpenItemTrackingLines(var WarehouseShipmentLine: Record "Warehouse Shipment Line")+ BC25 (integration)- subscribers: Codeunit 5995 “Service Warehouse Mgt.” OnOpenItemTrackingLines
OnBeforeLockTable(var Rec: Record "Warehouse Shipment Line"; var IsHandled: Boolean)+ BC26 (integration)OnInitNewLineOnAfterInit(var WarehouseShipmentLine: Record "Warehouse Shipment Line")+ BC27 (integration)OnBeforeInitQtyToShip(var WarehouseShipmentLine: Record "Warehouse Shipment Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)+ BC27 (integration)OnBeforeGetLocation(var Location: Record Location; var LocationCode: Code[10])+ BC27 (integration)OnAfterGetLocation(var Location: Record Location; var LocationCode: Code[10])+ BC27 (integration)
Procedures
InitNewLine(DocNo: Code[20])CalcQty(QtyBase: Decimal): DecimalCalcBaseQty(Qty: Decimal; FromFieldName: Text; ToFieldName: Text): DecimalCheckBin(DeductCubage: Decimal; DeductWeight: Decimal)CheckSourceDocLineQty()GetShipmentLineStatus(): Enum "Warehouse Shipment Status"+ BC26AutofillQtyToHandle(var WhseShptLine: Record "Warehouse Shipment Line")DeleteQtyToHandle(var WhseShptLine: Record "Warehouse Shipment Line")SetHideValidationDialog(NewHideValidationDialog: Boolean)GetWhseShptHeader(WhseShptNo: Code[20])(protected)CreatePickDoc(var WhseShptLine: Record "Warehouse Shipment Line"; WhseShptHeader2: Record "Warehouse Shipment Header")OpenItemTrackingLines()SetIgnoreErrors()HasErrorOccured(): BooleanGetATOAndNonATOLines(var ATOWhseShptLine: Record "Warehouse Shipment Line"; var NonATOWhseShptLine: Record "Warehouse Shipment Line"; var ATOLineFound: Boolean; var NonATOLineFound: Boolean)FullATOPosted(): BooleanInitOutstandingQtys()GetWhseShptLine(ShipmentNo: Code[20]; SourceType: Integer; SourceSubtype: Option; SourceNo: Code[20]; SourceLineNo: Integer): BooleanCreateWhseItemTrackingLines()DeleteWhseItemTrackingLines()SetItemData(ItemNo: Code[20]; ItemDescription: Text[100]; ItemDescription2: Text[50]; LocationCode: Code[10]; VariantCode: Code[10]; UoMCode: Code[10]; QtyPerUoM: Decimal)SetItemData(ItemNo: Code[20]; ItemDescription: Text[100]; ItemDescription2: Text[50]; LocationCode: Code[10]; VariantCode: Code[10]; UoMCode: Code[10]; QtyPerUoM: Decimal; QtyRndPrec: Decimal; QtyRndPrecBase: Decimal)SetSource(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer)SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)ClearSourceFilter()SuspendStatusCheck(Suspend: Boolean)CheckDirectTransfer(DirectTransfer: Boolean; DoCheck: Boolean): Boolean(internal)
Plus 11 local procedures.
Triggers
OnDelete, OnRename
Relations
- drill-down page Page 7341 “Whse. Shipment Lines”
- lookup page Page 7341 “Whse. Shipment Lines”
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Pick Qty.: CalcFormula Table 5767 “Warehouse Activity Line”
- Pick Qty. (Base): CalcFormula Table 5767 “Warehouse Activity Line”
- Zone Code: TableRelation Table 7300 “Zone”
- Bin Code: TableRelation Table 7354 “Bin” (conditional)
Referenced by
13 fields in 9 objects relate to this table (TableRelation or CalcFormula).
- Table 37 “Sales Line”: ATO Whse. Outstanding Qty., ATO Whse. Outstd. Qty. (Base), Whse. Outstanding Qty., Whse. Outstanding Qty. (Base)
- Table 27 “Item”: Qty. Assigned to ship, Qty. Picked
- Table 5741 “Transfer Line”: Whse Outbnd. Otsdg. Qty (Base)
- Table 5767 “Warehouse Activity Line”: Whse. Document Line No.
- Table 5773 “Registered Whse. Activity Line”: Whse. Document Line No.
- Table 5902 “Service Line”: Whse. Outstanding Qty. (Base)
- Table 7320 “Warehouse Shipment Header”: Completely Picked
- Table 7326 “Whse. Worksheet Line”: Whse. Document Line No.
- Table extension 20517 “Subc. Transfer Line”: Whse Outbnd. Otsdg. Qty
Pages and codeunits on this table
- Page 7336 “Whse. Shipment Subform” (source table)
- Page 7341 “Whse. Shipment Lines” (source table)
- Page 915 “Asm.-to-Order Whse. Shpt. Line” (source table)
- Codeunit 5763 “Whse.-Post Shipment” (codeunit runs on it)
- Codeunit 5764 “Whse.-Post Shipment (Yes/No)” (codeunit runs on it)
- Codeunit 5765 “Whse.-Post Shipment + Print” (codeunit runs on it)
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.
- Codeunit 6500 “Item Tracking Management” (5 calls:
CreateWhseItemTrackingLines → GetWhseItemTrkgSetup,CreateWhseItemTrackingLines → InitItemTrackingForTempWhseWorksheetLine,DeleteWhseItemTrackingLines → DeleteWhseItemTrkgLinesWithRunDeleteTrigger, …) - Codeunit 5402 “Unit of Measure Management” (4 calls:
CalcBaseQty → CalcBaseQty,CalcQty → RoundQty,SetQuantityBase → CalcBaseQty, …) - Codeunit 5775 “Whse. Management” (1 call:
SetSource → GetWhseActivSourceDocument) - Codeunit 905 “Assembly Line Management” (1 call:
CreateWhseItemTrackingLines → CreateWhseItemTrkgForAsmLines) - Codeunit 99000832 “Sales Line-Reserve” (1 call:
OpenItemTrackingLines → CallItemTrackingSecondSource) - Codeunit 99000834 “Purch. Line-Reserve” (1 call:
OpenItemTrackingLines → CallItemTracking) - Codeunit 99000836 “Transfer Line-Reserve” (1 call:
OpenItemTrackingLines → CallItemTracking)
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: "Warehouse Shipment Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.