BC Observatoryunofficial, made by waldo
tableInventoryofficial - Microsoftderived - from the source, no model text

Table 5876 "Phys. Invt. Order Line"

Base Application · Microsoft.Inventory.Counting.Document

Open in Claude5876.mdSource on GitHub

Across versions

  1. BC23present
  2. BC248 events changed, 8 events added
  3. BC25-26unchanged
  4. BC278 events removed, 1 fields removed
  5. BC2828 fields changed
  6. BC29-30unchanged

Neighbourhood 27 connected objects and pages

Table 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 14 "Location" (relates to)LocationTable 204 "Unit of Measure" (relates to)Unit of MeasureTable 250 "Gen. Business Posting Group" (relates to)Gen. Business Posting GroupTable 251 "Gen. Product Posting Group" (relates to)Table 27 "Item" (relates to)ItemTable 32 "Item Ledger Entry" (relates to)Item Ledger EntryTable 480 "Dimension Set Entry" (relates to)Dimension Set EntryTable 5401 "Item Variant" (relates to)Item VariantTable 5404 "Item Unit of Measure" (relates to)Table 5722 "Item Category" (relates to)Item CategoryTable 5875 "Phys. Invt. Order Header" (relates to)Phys. Invt. Order HeaderTable 6026 "Exp. Invt. Order Tracking" (relates to)Exp. Invt. Order TrackingTable 7354 "Bin" (relates to)Table 7381 "Phys. Invt. Counting Period" (relates to)Table 94 "Inventory Posting Group" (relates to)Page 5878 "Physical Inventory Order Lines" (pages and codeunits on it, 3 links)Physical Inventory Order LinesCodeunit 5888 "Phys. Invt.-Calc. Qty. One" (pages and codeunits on it)Page 30233 "APIV2 - Phys. Inv. Ord. Lines" (pages and codeunits on it)Page 5877 "Physical Inventory Order Subf." (pages and codeunits on it)Codeunit 408 "DimensionManagement" (calls, 8 links)DimensionManagementCodeunit 5889 "Phys. Invt. Tracking Mgt." (calls, 5 links)Phys. Invt. Tracking Mgt.Page 5893 "Phys. Invt. Item Track. List" (calls)Table 5878 "Phys. Invt. Record Line" (referenced by)Table 5882 "Pstd. Phys. Invt. Record Line" (referenced by)Table 5886 "Exp. Phys. Invt. Tracking" (referenced by)Table 6026 "Exp. Invt. Order Tracking" (referenced by)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Inventory.Counting.Document · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Phys. Invt. Order 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 No. Δ BC28 Code[20] Specifies the document number. TableRelation Table 5875 “Phys. Invt. Order Header” (Phys. Invt. Order Header)
2 Line No. Δ BC28 Integer Specifies the number of the line.
12 On Recording Lines Δ BC28 Boolean Specifies if the item exists on one or more physical inventory recording lines. not editable
20 Item No. Δ BC28 Code[20] Specifies the number of the item, which should be counted when taking the physical inventory. TableRelation Table 27 “Item”
21 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.”)))
22 Location Code Δ BC28 Code[10] Specifies the location where the item must be counted. TableRelation Table 14 “Location”
23 Bin Code Δ BC28 Code[20] Specifies the bin where the item must be counted. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
30 Description Δ BC28 Text[100] Specifies the description of the item.
31 Description 2 Δ BC28 Text[50] Specifies an additional description of the item.
32 Unit of Measure Δ BC28 Text[50] Specifies the unit of measure, such as bottle or piece, that is currently used for the item.
40 Base Unit of Measure Code Δ BC28 Code[10] Specifies the unit of measure, such as bottle or piece, that is currently used for the item. TableRelation Table 204 “Unit of Measure” (Unit of Measure); not editable
50 Qty. Expected (Base) Δ BC28 Decimal Specifies the expected inventory quantity in the base unit of measure. via Page 5878 “Physical Inventory Order Lines” not editable
51 Qty. Exp. Calculated Δ BC28 Boolean Specifies if the Qty. Expected (Base) field has been updated with the Calculate Expected Qty. function. not editable
53 Use Item Tracking Δ BC28 Boolean Specifies that the counting of the item is done by counting its serial, lot and package numbers.
54 Qty. Exp. Tracking (Base) + BC24 Δ BC28 Decimal Specifies the item’s expected inventory of serial, lot and package numbers in the base unit of measure. via Page 5877 “Physical Inventory Order Subf.” FlowField: sum(“Exp. Invt. Order Tracking”.“Quantity (Base)” where(“Order No” = field(“Document No.”), “Order Line No.” = field(“Line No.”))); not editable
55 Last Item Ledger Entry No. Integer — TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry); not editable
60 Unit Amount Δ BC28 Decimal Specifies the unit price of the item.
62 Unit Cost Δ BC28 Decimal Specifies the unit costs of the item, which will be used when posting the physical inventory.
70 No. Finished Rec.-Lines Δ BC28 Integer Specifies how many of the related physical inventory recordings are closed. not editable
71 Qty. Recorded (Base) Δ BC28 Decimal Specifies the counted quantity in the base unit of measure on the physical inventory order line. via Page 5878 “Physical Inventory Order Lines” not editable
72 Quantity (Base) Δ BC28 Decimal Specifies the difference between the Qty. Expected (Base) and the Qty. Recorded (Base) fields. via Page 5878 “Physical Inventory Order Lines” not editable
73 Entry Type Δ BC28 Option Specifies if the difference in the Quantity (Base) field on the related closed recording is positive or negative. OptionCaption: ,Positive Adjmt.,Negative Adjmt.; not editable
74 Pos. Qty. (Base) Δ BC28 Decimal Specifies the positive difference between the Qty. Expected (Base) and the Qty. Recorded (Base) fields. via Page 5877 “Physical Inventory Order Subf.” not editable
75 Neg. Qty. (Base) Δ BC28 Decimal Specifies the negative difference between the Qty. Expected (Base) and the Qty. Recorded (Base) fields. via Page 5877 “Physical Inventory Order Subf.” not editable
76 Without Difference Boolean — not editable
80 Recorded Without Order Δ BC28 Boolean Specifies whether the Inventory Order Line was automatically created by finishing a Phys. Inventory. not editable
90 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)))
91 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)))
100 Shelf No. Δ BC28 Code[10] Specifies the shelf number where the item can be found normally.
110 Gen. Bus. Posting Group Code[20] — TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
111 Gen. Prod. Posting Group Code[20] — TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
112 Inventory Posting Group Code[20] — TableRelation Table 94 “Inventory Posting Group” (Inventory Posting Group)
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
5704 Item Category Code Code[20] — TableRelation Table 5722 “Item Category” (Item Category)
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] —
7380 Phys Invt Counting Period Code Code[10] — TableRelation Table 7381 “Phys. Invt. Counting Period” (Phys. Invt. Counting Period); not editable
7381 Phys Invt Counting Period Type Option — OptionCaption: ,Item,SKU; not editable

Keys

  • Key1: Document No., Line No. (clustered)
  • Key2: Document No., Item No., Variant Code, Location Code, Bin Code
  • Key3: Document No., Entry Type, Without Difference

Events published

  • OnAfterInitDefaultDimensionSources(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) (integration)
  • OnAfterGetFieldsFromSKU(var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnAfterCreateDim(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) (integration)
  • OnAfterResetQtyExpected(var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnAfterValidateShortcutDimCode(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var xPhysInvtOrderLine: Record "Phys. Invt. Order Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnAfterValidateItemNo(var PhysInvtRecordLine: Record "Phys. Invt. Order Line"; PhysInvtRecordHeader: Record "Phys. Invt. Order Header"; Item: Record Item) (integration)
  • OnBeforeValidateShortcutDimCode(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var xPhysInvtOrderLine: Record "Phys. Invt. Order Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnBeforeShowItemLedgerEntries(var ItemLedgerEntry: Record "Item Ledger Entry"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnBeforeShowPhysInvtLedgerEntries(var PhysInventoryLedgerEntry: Record "Phys. Inventory Ledger Entry"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnBeforeTestItemNotBlocked(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var Item: Record Item; var IsHandled: Boolean) (integration)
  • OnBeforeTestItemVariantNotBlocked(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var ItemVariant: Record "Item Variant"; var IsHandled: Boolean) (integration)
  • OnBeforeValidateBinCode(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var IsHandled: Boolean) (integration)
  • OnCalcCostsOnAfterInitItemJnlLine(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var ItemJnlLine: Record "Item Journal Line") (integration)
  • OnCalcQtyAndLastItemLedgExpectedSetItemLedgEntryFilters(var ItemLedgerEntry: Record "Item Ledger Entry"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnCalcQtyAndLastItemLedgExpectedSetWhseEntryFilters(var WarehouseEntry: Record "Warehouse Entry"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnCalcQtyAndTrackLinesExpectedSetItemLedgEntryFilters(var ItemLedgerEntry: Record "Item Ledger Entry"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterExpPhysInvtTrackingInsertLine2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; var ItemLedgerEntry: Record "Item Ledger Entry") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterExpPhysInvtTrackingInsertLineFromWhseEntry2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; WarehouseEntry: Record "Warehouse Entry") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterSetWhseEntryFilters(var WarehouseEntry: Record "Warehouse Entry"; PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterHandleItemLedgerEntryTracking2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; ItemLedgerEntry: Record "Item Ledger Entry") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterHandleWarehouseEntryTracking2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; WarehouseEntry: Record "Warehouse Entry") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnBeforeModifyFromItemLedgEntry2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; var ItemLedgerEntry: Record "Item Ledger Entry") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnBeforeInsertFromWhseEntry2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; var WarehouseEntry: Record "Warehouse Entry") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnPhysInvtTrackingNotGet(var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnCalcQtyAndTrackLinesExpectedOnBeforeCalcQtyAndLastItemLedgExpected(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; PhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)
  • OnCalcQtyAndLastItemLedgExpectedOnAfterCalcItemLedgEntryQtyExpected(var ItemLedgEntry: Record "Item Ledger Entry"; var QtyExpected: Decimal) (integration)
  • OnCalcQtyAndLastItemLedgExpectedOnAfterCalcWhseEntryQtyExpected(var WhseEntry: Record "Warehouse Entry"; var QtyExpected: Decimal) (integration)
  • OnTestQtyRecordedOnAfterPhysInvtRecordLineSetFilters(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var PhysInvtRecordLine: Record "Phys. Invt. Record Line") (integration)
  • OnTestQtyRecordedOnBeforeValidateRecordLine(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var SkipTestFieldBinCode: Boolean) + BC27 (integration)
  • OnValidateItemNoOnAfterInitFromItem(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; xPhysInvtOrderLine: Record "Phys. Invt. Order Line"; Item: Record Item; PhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)
  • OnAfterPrepareLine(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; PhysInvtOrderLineArgs: Record "Phys. Invt. Order Line") (integration)
  • OnAfterPrepareLineArgs(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; ItemLedgEntry: Record "Item Ledger Entry"; WhseEntry: Record "Warehouse Entry") (integration)
  • OnAfterCalcQtyAndLastItemLedgExpected(var QtyExpected: Decimal; var LastItemLedgEntryNo: Integer; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") (integration)
  • OnBeforeCheckLine(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var IsHandled: Boolean) (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterDeleteLineWhseEntry2(var ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") + BC24 (integration)
  • OnCalcQtyAndTrackLinesExpectedOnAfterDeleteLineItemLedgEntry2(var ExpPhysInvtTracking: Record "Exp. Invt. Order Tracking"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line") + BC24 (integration)
  • OnAfterInitTableValuePair(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var TableValuePair: Dictionary of [Integer, Code[20]]; FieldNo: Integer) (integration)

Procedures

  • GetPhysInvtOrderHeader()
  • TestStatusOpen()
  • CalcQtyAndTrackLinesExpected()
  • CalcQtyAndLastItemLedgExpected(var QtyExpected: Decimal; var LastItemLedgEntryNo: Integer)
  • ResetQtyExpected()
  • TestQtyExpected()
  • TestQtyRecorded()
  • CalcCosts()
  • CheckLine()
  • EmptyLine(): Boolean
  • PrepareLineArgs(WhseEntry: Record "Warehouse Entry")
  • PrepareLineArgs(ItemLedgEntry: Record "Item Ledger Entry")
  • PrepareLineArgs(WhseEntry: Record "Warehouse Entry"; ItemLedgEntry: Record "Item Ledger Entry")
  • PrepareLine(DocNo: Code[20]; LineNo: Integer; ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; BinCode: Code[20]; PeriodCode: Code[10]; PeriodType: Option)
  • PrepareLine(DocNo: Code[20]; LineNo: Integer; PhysInvtOrderLineArgs: Record "Phys. Invt. Order Line"; PeriodCode: Code[10]; PeriodType: Option)
  • ShowDimensions()
  • CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • LookupShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])
  • ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
  • ShowPhysInvtRecordingLines()
  • ShowExpectPhysInvtTrackLines()
  • ShowItemTrackingLines(Which: Option All,Positive,Negative)
  • ShowItemLedgerEntries()
  • ShowPhysInvtLedgerEntries()
  • GetFieldsFromSKU()
  • ShowBinContentItem()
  • ShowBinContentBin()
  • CreateDimFromDefaultDim()
  • CreateDimFromDefaultDim(FieldNo: Integer)
  • GetDateForCalculations(): Date

Plus 9 local procedures.

Triggers

OnDelete, OnInsert, OnRename

Relations

Referenced by

4 fields in 4 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

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: "Phys. Invt. Order Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources