Table 5851 "Invt. Document Line"
Base Application · Microsoft.Inventory.Document
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC261 events added
- BC272 fields changed, 1 procedures added
- BC2834 fields changed
- BC29-30unchanged
Neighbourhood 36 connected objects and pages
Base Application · Microsoft.Inventory.Document · captioned “Item Document Line” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6774 “Invt. Document Lines” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Item Document 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 | Document Type Δ BC28 | Enum “Invt. Doc. Document Type” | Specifies the type of the related document. | enum Enum 5850 “Invt. Doc. Document Type” |
| 2 | Line No. Δ BC28 | Integer | Specifies the number of the line. | |
| 3 | Item No. Δ BC28 | Code[20] | Specifies the number of the item. | TableRelation Table 27 “Item” |
| 4 | Posting Date | Date | — | |
| 5 | Document Date Δ BC28 | Date | Specifies the date when the related document was created. | |
| 7 | Document No. Δ BC28 | Code[20] | Specifies the number of the related document. | |
| 8 | Description Δ BC28 | Text[100] | Specifies the description of the item. | |
| 9 | Location Code Δ BC28 | Code[10] | Specifies the warehouse or other place where the involved items are handled or stored. | TableRelation Table 14 “Location” |
| 10 | Inventory Posting Group | Code[20] | — | TableRelation Table 94 “Inventory Posting Group” (Inventory Posting Group); not editable |
| 13 | Quantity Δ BC28 | Decimal | Specifies the number of units for this item. | |
| 16 | Unit Amount Δ BC28 | Decimal | Specifies the price per unit for this item. | |
| 17 | Unit Cost Δ BC28 | Decimal | Specifies the cost of one unit of the item or resource on the line. | |
| 18 | Amount Δ BC28 | Decimal | Specifies the transaction amount for this line. | |
| 23 | Salespers./Purch. Code | Code[20] | — | TableRelation Table 13 “Salesperson/Purchaser” (“Salesperson/Purchaser” where(Blocked = const(false))) |
| 26 | Source Code | Code[10] | — | TableRelation Table 230 “Source Code” (Source Code); not editable |
| 29 | Applies-to Entry Δ BC28 | Integer | Specifies if the quantity on the journal line should be applied to an already-posted document. | |
| 32 | Item Shpt. Entry No. | Integer | — | not editable |
| 34 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 35 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 37 | Indirect Cost % Δ BC28 | Decimal | Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item. | |
| 38 | Gross Weight Δ BC28 | Decimal | — | |
| 39 | Net Weight Δ BC28 | Decimal | — | |
| 40 | Units per Parcel Δ BC28 | Decimal | — | |
| 41 | Unit Volume Δ BC28 | Decimal | — | |
| 42 | Reason Code Δ BC28 | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation Table 231 “Reason Code” (Reason Code) |
| 55 | Last Item Ledger Entry No. | Integer | — | TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry); not editable |
| 57 | Gen. Bus. Posting Group | Code[20] | — | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 58 | Gen. Prod. Posting Group | Code[20] | — | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 65 | Posting No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 72 | Unit Cost (ACY) Δ BC27 | Decimal | — | not editable |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 5402 | 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.”))) |
| 5403 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | |
| 5404 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 5405 | Qty. Rounding Precision Δ BC28 | Decimal | — | not editable |
| 5406 | Qty. Rounding Precision (Base) Δ BC28 | Decimal | — | not editable |
| 5407 | 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.”))) |
| 5413 | Quantity (Base) Δ BC28 | Decimal | Specifies the quantity on the line expressed in base units of measure. via Page 6873 “Available - Invt. Doc. Lines” | |
| 5470 | Reserved Quantity Inbnd. Δ BC28 | Decimal | Specifies the quantity of the item reserved at the transfer-to location. | FlowField: sum(“Reservation Entry”.Quantity where(“Source ID” = field(“Document No.”), “Source Ref. No.” = field(“Line No.”), “Source Type” = const(5851), “Source Subtype” = filter(“0” | “3”), “Reservation Status” = const(Reservation))); not editable |
| 5471 | Reserved Quantity Outbnd. Δ BC28 | Decimal | Specifies the quantity of the item reserved at the transfer-from location. | FlowField: - sum(“Reservation Entry”.Quantity where(“Source ID” = field(“Document No.”), “Source Ref. No.” = field(“Line No.”), “Source Type” = const(5851), “Source Subtype” = filter(“1” | “2”), “Reservation Status” = const(Reservation))); not editable |
| 5472 | Reserved Qty. Inbnd. (Base) Δ BC28 | Decimal | Specifies the item base quantity that is reserved at the warehouse of the receiver. via Page 6873 “Available - Invt. Doc. Lines” | FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Source ID” = field(“Document No.”), “Source Ref. No.” = field(“Line No.”), “Source Type” = const(5851), “Source Subtype” = filter(“0” | “3”), “Reservation Status” = const(Reservation))); not editable |
| 5473 | Reserved Qty. Outbnd. (Base) Δ BC28 | Decimal | Specifies the item base quantity that is reserved at the warehouse of the receiver. via Page 6873 “Available - Invt. Doc. Lines” | FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Source ID” = field(“Document No.”), “Source Ref. No.” = field(“Line No.”), “Source Type” = const(5851), “Source Subtype” = filter(“1” | “2”), “Reservation Status” = const(Reservation))); not editable |
| 5704 | Item Category Code | Code[20] | — | TableRelation Table 5722 “Item Category” (Item Category) |
| 5706 | Purchasing Code | Code[10] | — | TableRelation Table 5721 “Purchasing” |
| 5725 | Item Reference No. Δ BC28 | Code[50] | Specifies a reference to the item number as defined by the item’s barcode. | |
| 5726 | Item Reference Unit of Measure | Code[10] | — | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 5727 | Item Reference Type | Enum “Item Reference Type” | — | enum Enum 5726 “Item Reference Type” |
| 5728 | Item Reference Type No. | Code[30] | — | |
| 5801 | Item Charge No. | Code[20] | — | TableRelation Table 5800 “Item Charge” (Item Charge) |
| 5807 | Applies-from Entry Δ BC28 | Integer | Specifies the entry number of the Sales Ledger or Purchase Ledger from which the document line was applied. | |
| 5811 | Applied Amount Δ BC28 | Decimal | — | not editable |
| 5812 | Update Standard Cost | Boolean | — | |
| 5813 | Amount (ACY) Δ BC27 | Decimal | — | |
| 5819 | Applies-to Value Entry | Integer | — | |
| 12450 | FA No. | Code[20] | — | TableRelation Table 5600 “Fixed Asset” (Fixed Asset) |
| 12451 | FA Entry No. | Integer | — | TableRelation Table 5601 “FA Ledger Entry” (“FA Ledger Entry” where(“Entry No.” = field(“FA Entry No.”))) |
| 12452 | Depreciation Book Code | Code[10] | — | TableRelation Table 5612 “FA Depreciation Book” (“FA Depreciation Book”.“Depreciation Book Code” where(“FA No.” = field(“FA No.”))) |
Keys
- Key1: Document Type, Document No., Line No. (clustered)
- Key2: Location Code
- Key3: Item No., Variant Code
- Key4: Document Type, Document No., Item No., Location Code
Events published
OnAfterInitDefaultDimensionSources(var InvtDocumentLine: Record "Invt. Document Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)(integration)OnAfterFilterReceiptLinesForReservation(var InvtDocumentLine: Record "Invt. Document Line"; ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean)(integration)OnAfterFilterShipmentLinesForReservation(var InvtDocumentLine: Record "Invt. Document Line"; ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean)(integration)OnBeforeRetrieveCosts(var InvtDocumentLine: Record "Invt. Document Line"; var UnitCost: Decimal; var IsHandled: Boolean)(integration)OnAfterGetUnitAmount(var InvtDocumentLine: Record "Invt. Document Line"; var UnitCost: Decimal; CalledByFieldNo: Integer)(integration)OnAfterOpenItemTrackingLines(var InvtDocumentLine: Record "Invt. Document Line")+ BC26 (integration)OnAfterCreateDim(var InvtDocumentLine: Record "Invt. Document Line"; CurrentFieldNo: Integer; xInvtDocumentLine: Record "Invt. Document Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])+ BC27 (integration)
Procedures
SuppressRecalculateDimensions(RecalculateDimensions: Boolean)EmptyLine(): BooleanUpdateAmount()CheckItemAvailable(CalledByFieldNo: Integer)GetInvtDocHeader()IsCorrection(): BooleanGetUnitAmount(CalledByFieldNo: Integer)ShowReservation()OpenItemTrackingLines()CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])ShowDimensions()ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])RowID1(): Text[250]SuspendStatusCheck(Suspend: Boolean)Signed(Value: Decimal): DecimalReserveFromInventory(var InvtDocLine: Record "Invt. Document Line")GetRemainingQty(var RemainingQty: Decimal; var RemainingQtyBase: Decimal; Direction: Integer)GetReservationQty(var QtyReserved: Decimal; var QtyReservedBase: Decimal; var QtyToReserve: Decimal; var QtyToReserveBase: Decimal; SourceSubtype: Integer): DecimalGetSourceCaption(): TextFilterReceiptLinesForReservation(ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean)FilterShipmentLinesForReservation(ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean)ReservEntryExist(): BooleanSetReservationEntry(var ReservEntry: Record "Reservation Entry")SetReservationFilters(var ReservEntry: Record "Reservation Entry")CreateDimFromDefaultDim(FieldNo: Integer)
Plus 15 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- drill-down page Page 6774 “Invt. Document Lines”
- lookup page Page 6774 “Invt. Document Lines”
- Salespers./Purch. Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Item No.: TableRelation Table 27 “Item”
- Posting No. Series: TableRelation Table 308 “No. Series”
- Last Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
- Reserved Qty. Inbnd. (Base): CalcFormula Table 337 “Reservation Entry”
- Reserved Qty. Outbnd. (Base): CalcFormula Table 337 “Reservation Entry”
- Reserved Quantity Inbnd.: CalcFormula Table 337 “Reservation Entry”
- Reserved Quantity Outbnd.: CalcFormula Table 337 “Reservation Entry”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- FA No.: TableRelation Table 5600 “Fixed Asset”
- FA Entry No.: TableRelation Table 5601 “FA Ledger Entry”
- Depreciation Book Code: TableRelation Table 5612 “FA Depreciation Book”
- Purchasing Code: TableRelation Table 5721 “Purchasing”
- Item Category Code: TableRelation Table 5722 “Item Category”
- Item Charge No.: TableRelation Table 5800 “Item Charge”
- Inventory Posting Group: TableRelation Table 94 “Inventory Posting Group”
Pages and codeunits on this table
- Page 30241 “APIV2 - Invt. Shpt. Lines” (source table)
- Page 30243 “APIV2 - Invt. Rcpt. Lines” (source table)
- Page 6562 “Invt. Receipt Subform” (source table)
- Page 6565 “Invt. Shipment Subform” (source table)
- Page 6774 “Invt. Document Lines” (source table)
- Page 6873 “Available - Invt. Doc. Lines” (source table)
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 408 “DimensionManagement” (8 calls:
CreateDim → GetDefaultDimID,CreateDim → UpdateGlobalDimFromDimSetID,InitDefaultDimensionSources → AddDimSource, …) - Codeunit 5854 “Invt. Doc. Line-Reserve” (4 calls:
OnDelete → DeleteLine,OnInsert → VerifyQuantity,OnModify → VerifyChange, …) - Codeunit 99000845 “Reservation Management” (2 calls:
ReserveFromInventory → AutoReserveToShip,ReserveFromInventory → SetReservSource) - Codeunit 311 “Item-Check Avail.” (1 call:
CheckItemAvailable → InvtDocCheckLine) - Codeunit 5402 “Unit of Measure Management” (1 call:
CalcBaseQty → CalcBaseQty) - Codeunit 6500 “Item Tracking Management” (1 call:
RowID1 → ComposeRowID) - Page 38 “Item Ledger Entries” (1 call:
SelectItemEntry → (object))
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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: "Invt. Document Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.