Table 5878 "Phys. Invt. Record Line"

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

Properties

Property	Value
Caption	Phys. Invt. Record 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	Order No. Δ BC24 Δ BC28	Code[20]	Specifies the order number.	TableRelation Table 5877 “Phys. Invt. Record Header” (Phys. Invt. Record Header); DataClassification SystemMetadata
2	Recording No. Δ BC24 Δ BC28	Integer	Specifies a number that is assigned to the physical inventory recording.	TableRelation Table 5877 “Phys. Invt. Record Header” (“Phys. Invt. Record Header”.“Recording No.” where(“Order No.” = field(“Order No.”))); DataClassification SystemMetadata
3	Line No. Δ BC24 Δ BC28	Integer	Specifies the number of the line.	DataClassification SystemMetadata
16	Order Line No. Δ BC24 Δ BC28	Integer	Specifies the Line No. of the linked physical inventory order line.	TableRelation Table 5876 “Phys. Invt. Order Line” (“Phys. Invt. Order Line”.“Line No.” where(“Document No.” = field(“Order No.”))); not editable; DataClassification SystemMetadata
17	Recorded Without Order Δ BC24	Boolean	—	not editable; DataClassification SystemMetadata
20	Item No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the item that was counted when taking the physical inventory.	TableRelation Table 27 “Item”; DataClassification SystemMetadata
21	Variant Code Δ BC24 Δ 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.”))); DataClassification SystemMetadata
22	Location Code Δ BC24 Δ BC28	Code[10]	Specifies the code of the location where the item was counted during taking the physical inventory.	TableRelation Table 14 “Location”; DataClassification SystemMetadata
23	Bin Code Δ BC24 Δ BC28	Code[20]	Specifies the code of the bin where the item was counted while performing the physical inventory.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))); DataClassification SystemMetadata
30	Description Δ BC24 Δ BC28	Text[100]	Specifies the description of the item.	DataClassification SystemMetadata
31	Description 2 Δ BC24 Δ BC28	Text[50]	Specifies the additional description of the item.	DataClassification SystemMetadata
32	Unit of Measure Δ BC24 Δ BC28	Text[50]	Specifies the unit of measure used for the item, for example bottle or piece.	DataClassification SystemMetadata
33	Qty. Rounding Precision Δ BC24 Δ BC28	Decimal	—	not editable; DataClassification SystemMetadata
34	Qty. Rounding Precision (Base) Δ BC24 Δ BC28	Decimal	—	not editable; DataClassification SystemMetadata
40	Unit of Measure Code Δ BC24 Δ 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.”))); DataClassification SystemMetadata
41	Quantity Δ BC24 Δ BC28	Decimal	Specifies the quantity of the item of the physical inventory recording line.	DataClassification SystemMetadata
42	Quantity (Base) Δ BC24 Δ BC28	Decimal	Specifies the Quantity on the line, expressed in base units of measure. via Page 5882 “Phys. Invt. Recording Lines”	DataClassification SystemMetadata
43	Qty. per Unit of Measure Δ BC24 Δ BC28	Decimal	—	not editable; DataClassification SystemMetadata
45	Recorded Δ BC24 Δ BC28	Boolean	Specifies if a value was entered in Quantity of the physical inventory recording line.	DataClassification SystemMetadata
53	Use Item Tracking Δ BC24 Δ BC28	Boolean	Specifies if it is necessary to record the item using serial, lot or package numbers.	not editable; DataClassification SystemMetadata
99	Shelf No. Δ BC24	Code[10]	—	DataClassification SystemMetadata
100	Date Recorded Δ BC24 Δ BC28	Date	Specifies the date when the physical inventory was taken.	DataClassification SystemMetadata
101	Time Recorded Δ BC24 Δ BC28	Time	Specifies the time when the physical inventory was taken.	DataClassification SystemMetadata
102	Person Recorded Δ BC24 Δ BC28	Code[20]	Specifies the code of the person who performed the physical inventory.	TableRelation Table 5200 “Employee”; DataClassification SystemMetadata
103	Recorded by User ID	Code[50]	Created by User caption	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
130	Serial No. Δ BC24 Δ BC28	Code[50]	Specifies the serial number of the entered item.	DataClassification SystemMetadata
131	Lot No. Δ BC24 Δ BC28	Code[50]	Specifies the lot number of the entered item.	DataClassification SystemMetadata
132	Package No. + BC24 Δ BC28	Code[50]	Specifies the package number of the entered item.	DataClassification SystemMetadata
5725	Item Reference No. Δ BC24 Δ BC28	Code[50]	Specifies a reference to the item number as defined by the item’s barcode.	DataClassification SystemMetadata
5726	Item Reference Unit of Measure Δ BC24	Code[10]	Reference Unit of Measure caption	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); DataClassification SystemMetadata
5727	Item Reference Type Δ BC24	Enum “Item Reference Type”	—	enum Enum 5726 “Item Reference Type”; DataClassification SystemMetadata
5728	Item Reference Type No. Δ BC24	Code[30]	—	DataClassification SystemMetadata

Keys

Key1: Order No., Recording No., Line No. (clustered)
Key2: Order No., Order Line No.
Key3: Order No., Item No., Variant Code, Location Code, Bin Code
Key4: Order No., Recording No., Location Code, Bin Code
Key5: Order No., Recording No., Shelf No.

Events published

OnBeforeInsertTrackingBufferLocationIsBinMandatory(var WarehouseEntry: Record "Warehouse Entry"; PhysInvtRecordLine: Record "Phys. Invt. Record Line") (integration)
OnBeforeValidateBinCode(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var IsHandled: Boolean) (integration)
OnShowUsedTrackLinesOnAfterInsertFromItemLedgEntry2(var TempInvtOrderTracking: Record "Invt. Order Tracking" temporary; ItemLedgerEntry: Record "Item Ledger Entry") + BC24 (integration)
OnShowUsedTrackLinesOnAfterInsertFromWhseEntry2(var TempInvtOrderTracking: Record "Invt. Order Tracking" temporary; WarehouseEntry: Record "Warehouse Entry") + BC24 (integration)
OnShowUsedTrackLinesOnAfterLookupOK2(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var TempInvtOrderTracking: Record "Invt. Order Tracking" temporary) + BC24 (integration)
OnShowUsedTrackLinesSetItemLedgerEntryFilters2(var ItemLedgerEntry: Record "Item Ledger Entry"; PhysInvtRecordLine: Record "Phys. Invt. Record Line") + BC24 (integration)
OnShowUsedTrackLinesSetWhseEntryFilters(var WarehouseEntry: Record "Warehouse Entry"; PhysInvtRecordLine: Record "Phys. Invt. Record Line") (integration)
OnQuatityOnValidateOnAfterCalcShouldCheckSerialNo(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var ShouldCheckSerialNo: Boolean) (integration)
OnValidateItemNoOnAfterInitFromTempRecord(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; TempPhysInvtRecordLine: Record "Phys. Invt. Record Line" temporary) (integration)
OnValidateItemNoOnBeforeTestfieldBlocked(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var Item: Record Item; var IsHandled: Boolean) (integration)
OnValidateVariantCodeOnBeforeTestFieldBlocked(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var ItemVariant: Record "Item Variant"; var IsHandled: Boolean) (integration)
OnBeforeShowUsedTrackLines(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
OnAfterValidateItemNo(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; PhysInvtRecordHeader: Record "Phys. Invt. Record Header"; Item: Record Item) (integration)
OnBeforeCheckSerialNo(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var IsHandled: Boolean) + BC25 (integration)
OnValidateSerialNoOnAfterCheckSerialNo(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var IsHandled: Boolean) + BC25 (integration)
OnBeforeRunPhysInvtTrackingLinesOnShowUsedTrackLines(var PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var TempInvtOrderTracking: Record "Invt. Order Tracking" temporary; var IsHandled: Boolean) + BC25 (integration)

Procedures

GetPhysInvtRecordHeader() Δ BC26
EmptyLine(): Boolean
ShowUsedTrackLines()
CheckSerialNo()
InsertTrackingBuffer(var TempInvtOrderTracking: Record "Invt. Order Tracking" temporary; ItemTrackingSetup: Record "Item Tracking Setup"; ExpirationDate: Date; QtyBase: Decimal) + BC24 Δ BC26 − BC27
GetDateForCalculations(): Date
TrackingExists(): Boolean + BC24

Plus 3 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

drill-down page Page 5882 “Phys. Invt. Recording Lines”
lookup page Page 5882 “Phys. Invt. Recording Lines”
Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Person Recorded: TableRelation Table 5200 “Employee”
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”
Order Line No.: TableRelation Table 5876 “Phys. Invt. Order Line”
Order No.: TableRelation Table 5877 “Phys. Invt. Record Header”
Recording No.: TableRelation Table 5877 “Phys. Invt. Record Header”
Bin Code: TableRelation Table 7354 “Bin”

Pages and codeunits on this table

Page 30237 “APIV2 - Phys. Inv. Rec. Lines” (source table)
Page 5881 “Phys. Invt. Recording Subform” (source table)
Page 5882 “Phys. Invt. Recording 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 5889 “Phys. Invt. Tracking Mgt.” (2 calls: ShowUsedTrackLines → GetTrackingNosFromWhse, ShowUsedTrackLines → LocationIsBinMandatory)

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