Table 5877 "Phys. Invt. Record Header"

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

Properties

Property	Value
Caption	Phys. Invt. Record Header
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 physical inventory header number that is linked to the physical inventory recording.	TableRelation Table 5875 “Phys. Invt. Order Header” (Phys. Invt. Order Header)
2	Recording No. Δ BC28	Integer	Specifies a number that is assigned to the physical inventory recording, when you link a physical inventory recording to a physical inventory order.	not editable
10	Description Δ BC28	Text[100]	Specifies the description of the inventory recording.
11	Status Δ BC28	Option	Specifies if the physical inventory recording is open or finished.	OptionCaption: Open,Finished; not editable
30	Comment	Boolean	—	FlowField: exist(“Phys. Invt. Comment Line” where(“Document Type” = const(Recording), “Order No.” = field(“Order No.”), “Recording No.” = field(“Recording No.”))); not editable
31	Person Responsible Δ BC28	Code[20]	Specifies the code of the person responsible for performing this physical inventory recording.	TableRelation Table 5200 “Employee”
40	Allow Recording Without Order Δ BC28	Boolean	Specifies that recording lines are automatically created for items that do 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 when the physical inventory was taken.
101	Time Recorded Δ BC28	Time	Specifies the time when physical inventory was taken.
102	Person Recorded Δ BC28	Code[20]	Specifies the user ID of the person who performed the physical inventory.	TableRelation Table 5200 “Employee”
103	Recorded by User ID	Code[50]	Created by User caption	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
110	Location Code Δ BC28	Code[10]	Specifies the location where the items must be counted.	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)
Key2: Status

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

drill-down page Page 5880 “Phys. Inventory Recording List”
lookup page Page 5880 “Phys. Inventory Recording 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

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

Table 5878 “Phys. Invt. Record Line”: Order No., Recording No.
Table 5883 “Phys. Invt. Comment Line”: Order No., Recording No.
Table 5875 “Phys. Invt. Order Header”: No. Finished Recordings

Pages and codeunits on this table

Page 30236 “APIV2 - Phys. Invt. Recordings” (source table)
Page 5879 “Phys. Inventory Recording” (source table)
Page 5880 “Phys. Inventory Recording List” (source table)
Codeunit 5875 “Phys. Invt. Rec.-Finish (Y/N)” (codeunit runs on it)
Codeunit 5876 “Phys. Invt. Rec.-Finish” (codeunit runs on it)
Codeunit 5877 “Phys. Invt. Rec.-Reopen (Y/N)” (codeunit runs on it)
Codeunit 5878 “Phys. Invt. Rec.-Reopen” (codeunit runs on it)

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