Table 281 "Phys. Inventory Ledger Entry"

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

Properties

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.

Keys

• Key1: Entry No. (clustered)
• Key2: Item No., Variant Code, Location Code, Posting Date, SIFT Bucket No.
• Key3: Item No., Variant Code, Global Dimension 1 Code, Global Dimension 2 Code, Location Code, Posting Date, SIFT Bucket No.
• Key4: Document No., Posting Date
• Key5: Item No., Phys Invt Counting Period Type, Posting Date

Trigger event subscribers

• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertPhysInventoryLedgerEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyPhysInventoryLedgerEntry

Procedures

• GetNextEntryNo(): Integer + BC26
• GetLastEntryNo(): Integer Δ BC26
• ShowDimensions()

Triggers

OnInsert

Relations

• drill-down page Page 390 “Phys. Inventory Ledger Entries”
• lookup page Page 390 “Phys. Inventory Ledger Entries”
• 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”
• Item No.: TableRelation Table 27 “Item”
• No. Series: TableRelation Table 308 “No. Series”
• Last Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Item Register No.: TableRelation Table 46 “Item Register”
• Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
• Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
• Variant Code: TableRelation Table 5401 “Item Variant”
• Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
• Phys Invt Counting Period Code: TableRelation Table 7381 “Phys. Invt. Counting Period”
• Inventory Posting Group: TableRelation Table 94 “Inventory Posting Group”

Referenced by

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

• Table 46 “Item Register”: From Phys. Inventory Entry No., To Phys. Inventory Entry No.
• Table 27 “Item”: Last Phys. Invt. Date
• Table 5700 “Stockkeeping Unit”: Last Phys. Invt. Date

Pages and codeunits on this table

• Page 390 “Phys. Inventory Ledger Entries” (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” (1 call: ShowDimensions → ShowDimensionSet)
• Codeunit 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 9500 “Sequence No. Mgt.” (1 call: GetNextEntryNo → GetNextSeqNo)

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. Inventory Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.