Table 5881 "Pstd. Phys. Invt. Record Hdr"

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

Properties

Property	Value
Caption	Pstd. Phys. Invt. Record Hdr
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. Δ BC28	Code[20]	Specifies the number of the related physical inventory order.	TableRelation Table 5875 “Phys. Invt. Order Header” (Phys. Invt. Order Header)
2	Recording No. Δ BC28	Integer	Specifies the number of the related physical inventory recording.	not editable
10	Description Δ BC28	Text[100]	Specifies the Description of the table physical inventory recording header.
11	Status Δ BC28	Option	Specifies if the recording is Open or Finished	OptionCaption: Open,Finished; not editable
30	Comment	Boolean	—	FlowField: exist(“Phys. Invt. Comment Line” where(“Document Type” = const(“Posted Recording”), “Order No.” = field(“Order No.”), “Recording No.” = field(“Recording No.”))); not editable
31	Person Responsible Δ BC28	Code[20]	Specifies the Person Responsible of the table physical inventory recording header.	TableRelation Table 5200 “Employee”
40	Allow Recording Without Order Δ BC28	Boolean	Specifies that recording lines were automatically created for items that did not exist on the physical inventory order. This can only happen if none of the values in these four fields exist for an item on the order: Item No., Variant Code, Location Code, and Bin Code.
100	Date Recorded Δ BC28	Date	Specifies the Date Recorded of the table physical inventory recording header.
101	Time Recorded Δ BC28	Time	Specifies the time when the recording was performed.
102	Person Recorded Δ BC28	Code[20]	Specifies the person who performed the recording.	TableRelation Table 5200 “Employee”
110	Location Code Δ BC28	Code[10]	Specifies the location where the recording was performed.	TableRelation Table 14 “Location”
111	Bin Code	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))

Keys

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

Triggers

OnDelete

Relations

drill-down page Page 5888 “Posted Phys. Invt. Rec. List”
lookup page Page 5888 “Posted Phys. Invt. Rec. List”
Location Code: TableRelation Table 14 “Location”
Person Recorded: TableRelation Table 5200 “Employee”
Person Responsible: TableRelation Table 5200 “Employee”
Order No.: TableRelation Table 5875 “Phys. Invt. Order Header”
Comment: CalcFormula Table 5883 “Phys. Invt. Comment Line”
Bin Code: TableRelation Table 7354 “Bin”

Referenced by

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

Table 5879 “Pstd. Phys. Invt. Order Hdr”: No. Finished Recordings
Table 5882 “Pstd. Phys. Invt. Record Line”: Recording No.
Table 5883 “Phys. Invt. Comment Line”: Recording No.

Pages and codeunits on this table

Page 30238 “APIV2 - P. Phys. Inv. Recs.” (source table)
Page 5887 “Posted Phys. Invt. Recording” (source table)
Page 5888 “Posted Phys. Invt. Rec. List” (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 Hdr"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.