---
id: object/table/281
type: object
title: Table 281 "Phys. Inventory Ledger Entry"
summary: Table 281 "Phys. Inventory Ledger Entry" in Base Application (Microsoft.Inventory.Counting.Journal). 38 fields, 3 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 046486dfe50eaff218ce35d9eb8576500c77528269d43fe7e8a4b33f32d6eafc
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Counting/Journal/PhysInventoryLedgerEntry.Table.al
    title: src/Layers/W1/BaseApp/Inventory/Counting/Journal/PhysInventoryLedgerEntry.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 281
name: Phys. Inventory Ledger Entry
namespace: Microsoft.Inventory.Counting.Journal
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "26"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 38
  procedures: 3
  events: 0
  subscribers: 0
relations:
  out: 23
  referenced_by: 4
  pages: 1
  extended_by: 0
  event_subscribers: 2
  calls: 3
  called_by: 0
  implements: 0
---

# Table 281 "Phys. Inventory Ledger Entry"

> Table 281 "Phys. Inventory Ledger Entry" in Base Application (Microsoft.Inventory.Counting.Journal). 38 fields, 3 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28.

Base Application · Microsoft.Inventory.Counting.Journal · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Counting/Journal/PhysInventoryLedgerEntry.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Phys. Inventory Ledger Entry |
| DataClassification | CustomerContent |
| Permissions | TableData "Phys. Inventory Ledger Entry" = ri |

## 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 | Entry No. | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. |  |
| 2 | Item No. | Code[20] | Specifies the number of the item in the ledger entry. | TableRelation [Table 27 "Item"](../table/27.md) |
| 3 | Posting Date | Date | Specifies the date on which you posted the Physical Inventory Journal that created this ledger entry. |  |
| 4 | Entry Type | Enum "Item Ledger Entry Type" | Specifies the type of transaction that was posted from the Physical Inventory Journal that created the ledger entry. | enum [Enum 78 "Item Ledger Entry Type"](../enum/78.md) |
| 6 | Document No. | Code[20] | Specifies the document number on the physical inventory ledger entry. |  |
| 7 | Description | Text[100] | Specifies a description of the item in the ledger entry. |  |
| 8 | Location Code | Code[10] | Specifies the code of the location for the item in the ledger entry. | TableRelation [Table 14 "Location"](../table/14.md) |
| 9 | Inventory Posting Group | Code[20] | — | TableRelation [Table 94 "Inventory Posting Group"](../table/94.md) (Inventory Posting Group) |
| 12 | Quantity | Decimal | Specifies the difference between the quantities in the Quantity (Calculated) field and the Quantity (Physical Inventory) field for ledger entry. |  |
| 15 | Unit Amount | Decimal | Specifies the amount for one unit of the item in the ledger entry. |  |
| 16 | Unit Cost | Decimal | Specifies the cost of one unit of the item or resource on the line. |  |
| 17 | Amount | Decimal | Specifies the total amount for the items in the ledger entry. |  |
| 20 | Item Register No. | Integer | — | TableRelation [Table 46 "Item Register"](../table/46.md) (Item Register); not editable |
| 21 | SIFT Bucket No. | Integer | Specifies an automatically generated number that is used by the system to enable better concurrency. | not editable |
| 22 | Salespers./Purch. Code | Code[20] | — | TableRelation [Table 13 "Salesperson/Purchaser"](../table/13.md) (Salesperson/Purchaser) |
| 24 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation |
| 25 | Source Code | Code[10] | Specifies the source code that specifies where the entry was created. | TableRelation [Table 230 "Source Code"](../table/230.md) (Source Code) |
| 33 | Global Dimension 1 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 34 | Global Dimension 2 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 45 | Journal Batch Name | Code[10] | — |  |
| 46 | Reason Code | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation [Table 231 "Reason Code"](../table/231.md) (Reason Code) |
| 54 | Qty. (Calculated) | Decimal | Specifies the quantity on hand, as calculated by the program, of the item in the ledger entry. <small>via [Page 390 "Phys. Inventory Ledger Entries"](../page/390.md)</small> |  |
| 55 | Qty. (Phys. Inventory) | Decimal | Specifies the actual quantity on hand, as determined by taking a physical inventory, of the item in the ledger entry. <small>via [Page 390 "Phys. Inventory Ledger Entries"](../page/390.md)</small> |  |
| 56 | Last Item Ledger Entry No. | Integer | Specifies the number of the last item ledger entry that provided the basis for the physical inventory ledger entry. | TableRelation [Table 32 "Item Ledger Entry"](../table/32.md) (Item Ledger Entry) |
| 60 | Document Date | Date | — |  |
| 61 | External Document No. | Code[35] | — |  |
| 64 | No. Series | Code[20] | — | TableRelation [Table 308 "No. Series"](../table/308.md) (No. Series) |
| 480 | Dimension Set ID | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8))); not editable |
| 5402 | Variant Code | Code[10] | Specifies the variant of the item on the line. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) ("Item Variant".Code where("Item No." = field("Item No."))) |
| 5407 | Unit of Measure Code | Code[10] | — | TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) ("Item Unit of Measure".Code where("Item No." = field("Item No."))) |
| 7380 | Phys Invt Counting Period Code | Code[10] | — | TableRelation [Table 7381 "Phys. Invt. Counting Period"](../table/7381.md) (Phys. Invt. Counting Period); not editable |
| 7381 | Phys Invt Counting Period Type | Option | — | OptionCaption: ,Item,SKU; not editable |

## 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"](../codeunit/20.md) OnInsertPhysInventoryLedgerEntry
- OnAfterModifyEvent: [Codeunit 20 "Posting Preview Event Handler"](../codeunit/20.md) OnModifyPhysInventoryLedgerEntry

## Procedures

- `GetNextEntryNo(): Integer`
- `GetLastEntryNo(): Integer`
- `ShowDimensions()`

## Triggers

OnInsert

## Relations

- drill-down page [Page 390 "Phys. Inventory Ledger Entries"](../page/390.md)
- lookup page [Page 390 "Phys. Inventory Ledger Entries"](../page/390.md)
- Salespers./Purch. Code: TableRelation [Table 13 "Salesperson/Purchaser"](../table/13.md)
- Location Code: TableRelation [Table 14 "Location"](../table/14.md)
- Source Code: TableRelation [Table 230 "Source Code"](../table/230.md)
- Reason Code: TableRelation [Table 231 "Reason Code"](../table/231.md)
- Item No.: TableRelation [Table 27 "Item"](../table/27.md)
- No. Series: TableRelation [Table 308 "No. Series"](../table/308.md)
- Last Item Ledger Entry No.: TableRelation [Table 32 "Item Ledger Entry"](../table/32.md)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Item Register No.: TableRelation [Table 46 "Item Register"](../table/46.md)
- Shortcut Dimension 3 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 4 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 5 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 6 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 7 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 8 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Unit of Measure Code: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md)
- Phys Invt Counting Period Code: TableRelation [Table 7381 "Phys. Invt. Counting Period"](../table/7381.md)
- Inventory Posting Group: TableRelation [Table 94 "Inventory Posting Group"](../table/94.md)

## Referenced by

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

- [Table 46 "Item Register"](../table/46.md): From Phys. Inventory Entry No., To Phys. Inventory Entry No.
- [Table 27 "Item"](../table/27.md): Last Phys. Invt. Date
- [Table 5700 "Stockkeeping Unit"](../table/5700.md): Last Phys. Invt. Date

## Pages and codeunits on this table

- [Page 390 "Phys. Inventory Ledger Entries"](../page/390.md) (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"](../codeunit/408.md) (1 call: `ShowDimensions → ShowDimensionSet`)
- [Codeunit 703 "Find Record Management"](../codeunit/703.md) (1 call: `GetLastEntryNo → GetLastEntryIntFieldValue`)
- [Codeunit 9500 "Sequence No. Mgt."](../codeunit/9500.md) (1 call: `GetNextEntryNo → GetNextSeqNo`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26, BC28

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