Table 46 "Item Register"

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

Properties

Property	Value
Caption	Item Register
DataClassification	CustomerContent
Permissions	TableData “Item Register” = 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	No. Δ BC28	Integer	Specifies the number of the involved entry or record, according to the specified number series.
2	From Entry No. Δ BC28	Integer	Specifies the first item entry number in the register.	TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
3	To Entry No. Δ BC28	Integer	Specifies the last item entry number in the register.	TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
4	Creation Date Δ BC28	Date	Specifies the date when the entries in the register were posted.
5	Source Code Δ BC28	Code[10]	Specifies the source code that specifies where the entry was created.	TableRelation Table 230 “Source Code” (Source Code)
6	User ID Δ BC28	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
7	Journal Batch Name Δ BC28	Code[10]	Specifies the name of the journal batch, a personalized journal layout, that the entries were posted from.	TableRelation Table 233 “Item Journal Batch” (“Item Journal Batch”.Name)
9	Creation Time Δ BC28	Time	Specifies the time when the entries in the register were posted.
10	From Phys. Inventory Entry No. Δ BC28	Integer	Specifies the first physical inventory ledger entry number in the register.	TableRelation Table 281 “Phys. Inventory Ledger Entry” (Phys. Inventory Ledger Entry)
11	To Phys. Inventory Entry No. Δ BC28	Integer	Specifies the last physical inventory ledger entry number in the register.	TableRelation Table 281 “Phys. Inventory Ledger Entry” (Phys. Inventory Ledger Entry)
5800	From Value Entry No. Δ BC28	Integer	Specifies the first value entry number in the register.	TableRelation Table 5802 “Value Entry” (Value Entry)
5801	To Value Entry No. Δ BC28	Integer	Specifies the last value entry number in this register.	TableRelation Table 5802 “Value Entry” (Value Entry)
5831	From Capacity Entry No. Δ BC26 Δ BC28	Integer	Specifies the first capacity entry number in the register.	TableRelation Table 5832 “Capacity Ledger Entry” (Microsoft.Manufacturing.Capacity.“Capacity Ledger Entry”)
5832	To Capacity Entry No. Δ BC26 Δ BC28	Integer	Specifies the last capacity ledger entry number in this register.	TableRelation Table 5832 “Capacity Ledger Entry” (Microsoft.Manufacturing.Capacity.“Capacity Ledger Entry”)
5895	Cost Adjustment Run Guid + BC24	Guid	—

Keys

Key1: No. (clustered)
Key2: Creation Date
Key3: Source Code, Journal Batch Name, Creation Date
Key4: Cost Adjustment Run Guid

Procedures

GetNextEntryNo(UseLegacyPosting: Boolean): Integer + BC26 + BC26
GetNextEntryNo(): Integer + BC26 + BC26
GetLastEntryNo(): Integer Δ BC26

Relations

lookup page Page 117 “Item Registers”
Source Code: TableRelation Table 230 “Source Code”
Journal Batch Name: TableRelation Table 233 “Item Journal Batch”
From Phys. Inventory Entry No.: TableRelation Table 281 “Phys. Inventory Ledger Entry”
To Phys. Inventory Entry No.: TableRelation Table 281 “Phys. Inventory Ledger Entry”
From Entry No.: TableRelation Table 32 “Item Ledger Entry”
To Entry No.: TableRelation Table 32 “Item Ledger Entry”
From Value Entry No.: TableRelation Table 5802 “Value Entry”
To Value Entry No.: TableRelation Table 5802 “Value Entry”
From Capacity Entry No.: TableRelation Table 5832 “Capacity Ledger Entry”
To Capacity Entry No.: TableRelation Table 5832 “Capacity Ledger Entry”

Referenced by

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

Table 281 “Phys. Inventory Ledger Entry”: Item Register No.
Table 32 “Item Ledger Entry”: Item Register No.
Table 339 “Item Application Entry”: Item Register No.
Table 5802 “Value Entry”: Item Register No.
Table 5806 “Cost Adjustment Log”: Item Register No.
Table 5815 “Inventory Period Entry”: Closing Item Register No.
Table 5832 “Capacity Ledger Entry”: Item Register No.
Table 87 “Date Compr. Register”: Register No.

Pages and codeunits on this table

Page 117 “Item Registers” (source table)
Codeunit 245 “Item Reg.-Show Ledger” (codeunit runs on it)
Codeunit 390 “Item Reg.-Show Inventory Ledg.” (codeunit runs on it)
Codeunit 5800 “Item Reg.- Show Value Entries” (codeunit runs on it)
Codeunit 5835 “Item Reg.-Show Cap. Ledger” (codeunit runs on it)

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 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)

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: "Item Register"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 20 connected objects and pages