Table 5882 "Pstd. Phys. Invt. Record Line"

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

Properties

Property	Value
Caption	Pstd. 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 No. of the table physical inventory recording line.	TableRelation Table 5879 “Pstd. Phys. Invt. Order Hdr” (Pstd. Phys. Invt. Order Hdr); DataClassification SystemMetadata
2	Recording No. Δ BC24 Δ BC28	Integer	Specifies the Recording No. of the table physical inventory recording line.	TableRelation Table 5881 “Pstd. Phys. Invt. Record Hdr” (“Pstd. Phys. Invt. Record Hdr”.“Recording No.” where(“Order No.” = field(“Order No.”))); DataClassification SystemMetadata
3	Line No. Δ BC24 Δ BC28	Integer	Specifies the Line No. of the table physical inventory recording line.	DataClassification SystemMetadata
16	Order Line No. Δ BC24 Δ BC28	Integer	Specifies the Order Line No. of the table physical inventory recording 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 Item No. of the table physical inventory recording line.	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 Location Code of the table physical inventory recording line.	TableRelation Table 14 “Location”; DataClassification SystemMetadata
23	Bin Code Δ BC24 Δ BC28	Code[20]	Specifies the Bin Code of the table physical inventory recording line.	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 table physical inventory recording line.	DataClassification SystemMetadata
31	Description 2 Δ BC24 Δ BC28	Text[50]	Specifies the Description 2 of the table physical inventory recording line.	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
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 table physical inventory recording line.	DataClassification SystemMetadata
42	Quantity (Base) Δ BC24 Δ BC28	Decimal	Specifies the Quantity (Base) of the table physical inventory recording line. via Page 5890 “Posted Phys. Invt. Rec. Lines”	DataClassification SystemMetadata
43	Qty. per Unit of Measure Δ BC24 Δ BC28	Decimal	—	not editable; DataClassification SystemMetadata
45	Recorded Δ BC24	Boolean	—	DataClassification SystemMetadata
53	Use Item Tracking Δ BC24	Boolean	—	not editable; DataClassification SystemMetadata
99	Shelf No. Δ BC24	Code[10]	—	DataClassification SystemMetadata
100	Date Recorded Δ BC24 Δ BC28	Date	Specifies the Date Recorded of the table physical inventory recording line.	DataClassification SystemMetadata
101	Time Recorded Δ BC24 Δ BC28	Time	Specifies the Time Recorded of the table physical inventory recording line.	DataClassification SystemMetadata
102	Person Recorded Δ BC24 Δ BC28	Code[20]	Specifies the Person Recorded of the table physical inventory recording line.	TableRelation Table 5200 “Employee”
130	Serial No. Δ BC24 Δ BC28	Code[50]	Specifies the Serial No. of the table physical inventory recording line.	DataClassification SystemMetadata
131	Lot No. Δ BC24 Δ BC28	Code[50]	Specifies the Lot No. of the table physical inventory recording line.	DataClassification SystemMetadata
132	Package No. + BC24 Δ BC28	Code[50]	Specifies the Package No. of the table physical inventory recording line.	DataClassification SystemMetadata

Keys

Key1: Order No., Recording No., Line No. (clustered)
Key2: Order No., Order Line No.

Procedures

EmptyLine(): Boolean

Relations

drill-down page Page 5890 “Posted Phys. Invt. Rec. Lines”
lookup page Page 5890 “Posted Phys. Invt. Rec. 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”
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 5879 “Pstd. Phys. Invt. Order Hdr”
Recording No.: TableRelation Table 5881 “Pstd. Phys. Invt. Record Hdr”
Bin Code: TableRelation Table 7354 “Bin”

Pages and codeunits on this table

Page 30239 “APIV2 - P. Phys. Inv. R. Lines” (source table)
Page 5889 “Posted Phys. Invt. Rec. Subf.” (source table)
Page 5890 “Posted Phys. Invt. Rec. Lines” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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. Record Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.