Table 5880 "Pstd. Phys. Invt. Order Line"

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

Properties

Property	Value
Caption	Pstd. 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 physical inventory order that the line exists on.	TableRelation Table 5879 “Pstd. Phys. Invt. Order Hdr” (Pstd. Phys. Invt. Order Hdr)
2	Line No. Δ BC28	Integer	Specifies the line on the physical inventory order line.
12	On Recording Lines	Boolean	—	not editable
20	Item No. Δ BC28	Code[20]	Specifies the item on the physical inventory order line.	TableRelation Table 27 “Item”
21	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the physical inventory order line.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
22	Location Code Δ BC28	Code[10]	Specifies the location of the item on the physical inventory order line.	TableRelation Table 14 “Location”
23	Bin Code Δ BC28	Code[20]	Specifies the Bin Code of the table physical inventory order line.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
30	Description Δ BC28	Text[100]	Specifies the description of the item on the physical inventory order line.
31	Description 2 Δ BC28	Text[50]	Specifies an additional part of the description of the item on the physical inventory order line.
32	Unit of Measure Δ BC28	Text[50]	Specifies the unit of measure, such as bottle or piece, that is used for the item on the physical inventory order line.
40	Base Unit of Measure Code Δ BC28	Code[10]	Specifies the base unit of measure that is set up for the item on the physical inventory order line.	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 on the physical inventory order line. via Page 5886 “Posted Phys. Invt. Order Lines”	not editable
51	Qty. Exp. Calculated	Boolean	—	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 current expected inventory of serial, lot and package numbers in the base unit of measure. via Page 5885 “Posted Phys. Invt. Order Subf.”	FlowField: sum(“Pstd.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 sum of unit costs of the item quantity on the line.
62	Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the item on the line.
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 Qty. Recorded (Base) of the physical inventory order line. via Page 5886 “Posted Phys. Invt. Order Lines”	not editable
72	Quantity (Base) Δ BC28	Decimal	Specifies the quantity in the base unit of measure on the physical inventory order line. via Page 5886 “Posted Phys. Invt. Order Lines”	not editable
73	Entry Type Δ BC28	Option	Specifies the Entry Type of the physical inventory order line.	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 5885 “Posted Phys. Invt. 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 5885 “Posted Phys. Invt. Order Subf.”	not editable
76	Without Difference	Boolean	—	not editable
80	Recorded Without Order Δ BC28	Boolean	Specifies that no physical inventory order lines existed for the recorded item, and that the line was generated based on the related recording.	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.
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.
100	Shelf No. Δ BC28	Code[10]	Specifies the shelf number where the item is placed.
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)
130	Intern Item Track. Pos. Qut.	Integer	—	not editable
131	Intern Item Track. Neg. Qut.	Integer	—
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)
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., Entry Type, Without Difference

Procedures

EmptyLine(): Boolean
ShowDimensions()
ShowPostPhysInvtRecordingLines()
ShowPostedItemTrackingLines()
ShowPostExpPhysInvtTrackLines()

Triggers

OnDelete

Relations

drill-down page Page 5886 “Posted Phys. Invt. Order Lines”
lookup page Page 5886 “Posted Phys. Invt. Order Lines”
Location Code: TableRelation Table 14 “Location”
Base Unit of Measure Code: TableRelation Table 204 “Unit of Measure”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Item No.: TableRelation Table 27 “Item”
Last Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Variant Code: TableRelation Table 5401 “Item Variant”
Item Category Code: TableRelation Table 5722 “Item Category”
Document No.: TableRelation Table 5879 “Pstd. Phys. Invt. Order Hdr”
Qty. Exp. Tracking (Base): CalcFormula Table 6027 “Pstd.Exp.Invt.Order.Tracking”
Bin Code: TableRelation Table 7354 “Bin”
Phys Invt Counting Period Code: TableRelation Table 7381 “Phys. Invt. Counting Period”
Inventory Posting Group: TableRelation Table 94 “Inventory Posting Group”

Referenced by

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

Table 5887 “Pstd. Exp. Phys. Invt. Track”: Order Line No.
Table 6027 “Pstd.Exp.Invt.Order.Tracking”: Order Line No.

Pages and codeunits on this table

Page 30235 “APIV2 - P. Phys. Inv. O. Lines” (source table)
Page 5885 “Posted Phys. Invt. Order Subf.” (source table)
Page 5886 “Posted Phys. Invt. Order 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 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
Codeunit 6503 “Item Tracking Doc. Management” (1 call: ShowPostedItemTrackingLines → ShowItemTrackingForShptRcptLine)

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