Table 7317 "Warehouse Receipt Line"
Base Application · Microsoft.Warehouse.Document
Across versions
- BC23present
- BC24declaration changed
- BC252 procedures changed, 1 events added
- BC262 events added
- BC27unchanged
- BC2835 fields changed, 2 events added
- BC29-30unchanged
Neighbourhood 26 connected objects and pages
Base Application · Microsoft.Warehouse.Document · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7342 “Whse. Receipt Lines” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Warehouse Receipt 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 line number. | not editable |
| 3 | Source Type | Integer | — | not editable |
| 4 | Source Subtype | Option | — | 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 where the items should be received. | TableRelation Table 14 “Location”; not editable |
| 11 | Shelf No. Δ BC28 | Code[10] | Specifies the shelf number of the item for information 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 zone in which the items are being received. | 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 is expected to be received. | TableRelation Table 27 “Item”; not editable |
| 15 | Quantity Δ BC28 | Decimal | Specifies the quantity that should be received. | not editable |
| 16 | Qty. (Base) Δ BC28 | Decimal | Specifies the quantity to be received, in the base unit of measure. via Page 7342 “Whse. Receipt 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, in the base unit of measure. via Page 7342 “Whse. Receipt Lines” | not editable |
| 21 | Qty. to Receive Δ BC28 | Decimal | Specifies the quantity of items that remains to be received. | |
| 22 | Qty. to Receive (Base) Δ BC28 | Decimal | Specifies the Qty. to Receive in the base unit of measure. via Page 5769 “Whse. Receipt Subform” | |
| 23 | Qty. Received Δ BC28 | Decimal | Specifies the quantity for this line that has been posted as received. | not editable |
| 24 | Qty. Received (Base) Δ BC28 | Decimal | Specifies the quantity received, in the base unit of measure. via Page 7342 “Whse. Receipt Lines” | 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 Δ BC28 | Option | Specifies the status of the warehouse receipt. | OptionCaption: ,Partially Received,Completely Received; not editable |
| 35 | Sorting Sequence No. | Integer | — | not editable |
| 36 | Due Date Δ BC28 | Date | Specifies the date on which you expect to receive the items on the line. | |
| 37 | Starting Date | Date | — | |
| 38 | Cubage Δ BC28 | Decimal | — | |
| 39 | Weight Δ BC28 | Decimal | — | |
| 48 | Not upd. by Src. Doc. Post. | Boolean | — | not editable |
| 49 | Posting from Whse. Ref. | Integer | — | not editable |
| 50 | Qty. to Cross-Dock Δ BC28 | Decimal | Specifies the suggested quantity to put into the cross-dock bin on the put-away document when the receipt is posted. | |
| 51 | Qty. to Cross-Dock (Base) Δ BC28 | Decimal | Specifies the suggested base quantity to put into the cross-dock bin on the put-away document hen the receipt is posted. via Page 5769 “Whse. Receipt Subform” | |
| 52 | Cross-Dock Zone Code Δ BC28 | Code[10] | Specifies the zone code that will be used for the quantity of items to be cross-docked. | TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”), “Cross-Dock Bin Zone” = const(true))) |
| 53 | Cross-Dock Bin Code Δ BC28 | Code[20] | Specifies the bin code that will be used for the quantity of items to be cross-docked. | TableRelation Table 7354 “Bin” (if (“Cross-Dock Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Cross-Dock Bin” = const(true)) else if (“Cross-Dock Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Cross-Dock Zone Code”), “Cross-Dock Bin” = …) |
| 55 | Qty. Rounding Precision Δ BC28 | Decimal | — | not editable |
| 56 | Qty. Rounding Precision (Base) Δ BC28 | Decimal | — | not editable |
| 8509 | Over-Receipt Quantity Δ BC28 | Decimal | Specifies over-receipt quantity. | |
| 8510 | Over-Receipt Code Δ BC28 | Code[20] | Specifies over-receip code. | TableRelation Table 8510 “Over-Receipt Code” (Over-Receipt Code) |
Keys
- Key1: No., Line No. (clustered)
- Key2: Source Type, Source Subtype, Source No., Source Line No.
- Key3: No., Source Type, Source Subtype, Source No., Source Line No.
- Key4: No., Sorting Sequence No.
- Key5: No., Shelf No.
- Key6: No., Item No.
- Key7: No., Source Document, Source No.
- Key8: No., Due Date
- Key9: No., Bin Code
- Key10: Item No., Location Code, Variant Code
- Key11: Bin Code, Location Code
Events published
OnAfterOpenItemTrackingLines(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; SecondSourceQtyArray: array[3] of Decimal)(integration)OnAfterInitQtyToReceive(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; CurrentFieldNo: Integer)(integration)OnAfterSetItemData(var WarehouseReceiptLine: Record "Warehouse Receipt Line")(integration)OnAutoFillQtyToReceiveOnBeforeModify(var WarehouseReceiptLine: Record "Warehouse Receipt Line")(integration)OnBeforeCheckBin(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var IsHandled: Boolean)(integration)OnBeforeConfirmDelete(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var SkipConfirm: Boolean)(integration)OnBeforeInitOutstandingQtys(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeOpenItemTrackingLines(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var IsHandled: Boolean; CallingFieldNo: Integer)(integration)- subscribers: Codeunit 20551 “Subc. WhsePostReceipt Ext” CheckOverDeliveryOnBeforeOpenItemTrackingLines
OnBeforeValidateQtyToReceive(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var IsHandled: Boolean; CurrentFieldNo: Integer; xWarehouseReceiptLine: Record "Warehouse Receipt Line")+ BC25 − BC25 (integration)OnBeforeValidateQtyToReceiveBase(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; xWarehouseReceiptLine: Record "Warehouse Receipt Line"; CallingFieldNo: Integer; var IsHandled: Boolean)(integration)OnValidateOverReceiptQuantity(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; xWarehouseReceiptLine: Record "Warehouse Receipt Line"; CalledByFieldNo: Integer; var Handled: Boolean)(integration)OnDeleteQtyToReceiveOnBeforeModify(var WhseReceiptLine: Record "Warehouse Receipt Line")(integration)OnBeforeAutofillQtyToReceive(var WhseReceiptLine: Record "Warehouse Receipt Line"; var IsHandled: Boolean)(integration)OnBeforeDeleteQtyToReceive(var WhseReceiptLine: Record "Warehouse Receipt Line"; var IsHandled: Boolean)(integration)OnCheckBinOnAfterCheckIncreaseBin(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var Bin: Record Bin; DeductCubage: Decimal; DeductWeight: Decimal; IgnoreErrors: Boolean; var ErrorOccured: Boolean)(integration)OnBeforeOverReceiptProcessing(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var Result: Boolean; var IsHandled: Boolean; xWarehouseReceiptLine: Record "Warehouse Receipt Line")(integration)OnGetWhseRcptLineOnAfterSetFilters(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; ReceiptNo: Code[20]; SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer)(integration)OnValidateQtyToReceiveOnBeforeUOMMgtValidateQtyIsBalanced(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; xWarehouseReceiptLine: Record "Warehouse Receipt Line"; var IsHandled: Boolean)(integration)- subscribers: Codeunit 20551 “Subc. WhsePostReceipt Ext” SkipValidateQtyBalancedForSubcontracting_OnValidateQtyToReceiveOnBeforeUOMMgtValidateQtyIsBalanced
OnBeforeCalcBaseQty(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; var Qty: Decimal; FromFieldName: Text; ToFieldName: Text; var SuppressQtyPerUoMTestfield: Boolean)+ BC28 − BC28 (integration)- subscribers: Codeunit 20551 “Subc. WhsePostReceipt Ext” SuppressQtyPerUoMTestfieldForSubcontracting_OnBeforeCalcBaseQty
OnBeforeInitNewLine(DocumentNo: Code[20]; var SkipLocking: Boolean)+ BC26 (integration)OnValidateQtyToCrossDockOnBeforeGetUseCrossDock(var WarehouseReceiptLine: Record "Warehouse Receipt Line"; CallingFieldNo: Integer; var ShouldGetUseCrossDock: Boolean; var UseCrossDock: Boolean)+ BC26 (integration)OnBeforeOpenItemTrackingLineForPurchLine(PurchaseLine: Record "Purchase Line"; SecondSourceQtyArray: array[3] of Decimal; var SkipCallItemTracking: Boolean)+ BC28 (integration)- subscribers: Codeunit 20551 “Subc. WhsePostReceipt Ext” OpenItemTrackingForSubcontracting_OnBeforeOpenItemTrackingLineForPurchLine
Procedures
InitNewLine(DocNo: Code[20])CalcBaseQty(Qty: Decimal; FromFieldName: Text; ToFieldName: Text): DecimalΔ BC25AutofillQtyToReceive(var WhseReceiptLine: Record "Warehouse Receipt Line")DeleteQtyToReceive(var WhseReceiptLine: Record "Warehouse Receipt Line")GetLineStatus(): IntegerGetLocation(LocationCode: Code[10])Δ BC25OpenItemTrackingLines()SetIgnoreErrors()HasErrorOccured(): BooleanInitOutstandingQtys()GetWhseRcptLine(ReceiptNo: Code[20]; SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer): BooleanSetItemData(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)
Plus 8 local procedures.
Triggers
OnDelete, OnRename
Relations
- drill-down page Page 7342 “Whse. Receipt Lines”
- lookup page Page 7342 “Whse. Receipt 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”
- Cross-Dock Zone Code: TableRelation Table 7300 “Zone”
- Zone Code: TableRelation Table 7300 “Zone”
- Bin Code: TableRelation Table 7354 “Bin” (conditional)
- Cross-Dock Bin Code: TableRelation Table 7354 “Bin” (conditional)
- Over-Receipt Code: TableRelation Table 8510 “Over-Receipt Code”
Referenced by
4 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 39 “Purchase Line”: Whse. Outstanding Qty. (Base)
- Table 5741 “Transfer Line”: Whse. Inbnd. Otsdg. Qty (Base)
- Table extension 20512 “Subc. Purchase Line”: Subc.Whse.Outstanding Quantity
- Table extension 20517 “Subc. Transfer Line”: Whse. Inbnd. Otsdg. Qty
Pages and codeunits on this table
- Page 5769 “Whse. Receipt Subform” (source table)
- Page 7342 “Whse. Receipt Lines” (source table)
- Codeunit 5760 “Whse.-Post Receipt” (codeunit runs on it)
- Codeunit 5761 “Whse.-Post Receipt (Yes/No)” (codeunit runs on it)
- Codeunit 5762 “Whse.-Post Receipt + Print” (codeunit runs on it)
- Codeunit 5766 “Whse.-Post Receipt + Pr. Pos.” (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 5402 “Unit of Measure Management” (2 calls:
CalcBaseQty → CalcBaseQty,ValidateQuantityIsBalanced → ValidateQtyIsBalanced) - Codeunit 5775 “Whse. Management” (2 calls:
SetSource → GetWhseActivSourceDocument,SetSourceFilter → SetSourceFilterForWhseRcptLine) - Codeunit 8510 “Over-Receipt Mgt.” (1 call:
OverReceiptProcessing → IsOverReceiptAllowed) - Codeunit 99000832 “Sales Line-Reserve” (1 call:
OpenItemTrackingLines → CallItemTracking) - 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 Receipt Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.