Table 5875 "Phys. Invt. Order Header"

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

Properties

Property	Value
Caption	Phys. Invt. Order 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	No. Δ BC28	Code[20]	Specifies a number for the physical inventory order.
10	Description Δ BC28	Text[100]	Specifies a short description of the physical inventory order.
11	Status Δ BC28	Enum “Phys. Invt. Order Status”	Specifies if the physical inventory order is open or finished.	enum Enum 5875 “Phys. Invt. Order Status”; not editable
20	Order Date Δ BC28	Date	Specifies the order date for the physical inventory order.
21	Posting Date Δ BC28	Date	Specifies the posting date of the physical inventory order.
30	Comment	Boolean	—	FlowField: exist(“Phys. Invt. Comment Line” where(“Document Type” = const(Order), “Order No.” = field(“No.”), “Recording No.” = const(0))); not editable
31	Person Responsible Δ BC28	Code[20]	Specifies the code of the person who is responsible for performing this physical inventory order.	TableRelation Table 5200 “Employee”
40	Reason Code	Code[10]	—	TableRelation Table 231 “Reason Code” (Reason Code)
41	Gen. Bus. Posting Group	Code[20]	—	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
50	Shortcut Dimension 1 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 1, whose dimension values you can then enter directly on journals and sales or purchase lines.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
51	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.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
60	Posting No. Series	Code[20]	—	TableRelation Table 308 “No. Series” (No. Series)
61	No. Series	Code[20]	—	TableRelation Table 308 “No. Series” (No. Series); not editable
64	Posting No.	Code[20]	—
65	Last Posting No.	Code[20]	—	TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header); not editable
71	No. Finished Recordings Δ BC28	Integer	Specifies the number of entered physical inventory recording documents that have the status set to Finished.	FlowField: count(“Phys. Invt. Record Header” where(“Order No.” = field(“No.”), Status = const(Finished))); not editable
110	Location Code Δ BC28	Code[10]	Specifies the code of the location where items on this line should be counted.	TableRelation Table 14 “Location”
111	Bin Code	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable

Keys

Key1: No. (clustered)
Key2: Status

Events published

OnAfterGetNoSeriesCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var NoSeriesCode: Code[20]) (integration)
OnAfterInitRecord(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)
OnAfterTestNoSeries(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)
OnBeforeGetNoSeriesCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; InventorySetup: Record "Inventory Setup"; var NoSeriesCode: Code[20]; var IsHandled: Boolean) (integration)
OnBeforeInitRecord(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; xPhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var IsHandled: Boolean) (integration)
OnBeforeTestNoSeries(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var IsHandled: Boolean) (integration)
OnAfterValidateShortcutDimCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var xPhysInvtOrderHeader: Record "Phys. Invt. Order Header"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
OnBeforeValidateShortcutDimCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var xPhysInvtOrderHeader: Record "Phys. Invt. Order Header"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
OnBeforeValidateBinCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var IsHandled: Boolean) (integration)
OnGetSamePhysInvtOrderLineOnAfterSetFilters(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; PhysInvtOrderLineArgs: Record "Phys. Invt. Order Line") (integration)
OnInitInsertOnBeforeInitSeries(var xPhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var IsHandled: Boolean) (integration)
OnInitInsertOnBeforeInitRecord(var xPhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)
OnAfterSetErrorText(NoOfOrderLines: Integer; OrderNo: Code[20]; PhysInvtOrderLineArgs: Record "Phys. Invt. Order Line"; var ErrorText: Text[250]) (integration)
OnShowDocDimOnBeforeModify(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; xPhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)
OnUpdateAllLineDimOnBeforePhysInvtOrderLineModify(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; xPhysInvtOrderHeader: Record "Phys. Invt. Order Header") (integration)

Procedures

InitRecord()
AssistEdit(OldPhysInvtOrderHeader: Record "Phys. Invt. Order Header"): Boolean
ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
GetSamePhysInvtOrderLine(ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; BinCode: Code[20]; var ErrorText: Text[250]; var PhysInvtOrderLine2: Record "Phys. Invt. Order Line"): Integer
GetSamePhysInvtOrderLine(PhysInvtOrderLineArgs: Record "Phys. Invt. Order Line"; var ErrorText: Text[250]; var PhysInvtOrderLine2: Record "Phys. Invt. Order Line"): Integer
CreateDimFromDefaultDim(FieldNo: Integer)
CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
ShowDocDim()
PhysInvtOrderLinesExist(): Boolean
UpdateAllLineDim(NewParentDimSetID: Integer; OldParentDimSetID: Integer)

Plus 5 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

drill-down page Page 5876 “Physical Inventory Orders”
lookup page Page 5876 “Physical Inventory Orders”
Last Posting No.: TableRelation Table 112 “Sales Invoice Header”
Location Code: TableRelation Table 14 “Location”
Reason Code: TableRelation Table 231 “Reason Code”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
No. Series: TableRelation Table 308 “No. Series”
Posting No. Series: TableRelation Table 308 “No. Series”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Person Responsible: TableRelation Table 5200 “Employee”
No. Finished Recordings: CalcFormula Table 5877 “Phys. Invt. Record Header”
Comment: CalcFormula Table 5883 “Phys. Invt. Comment Line”
Bin Code: TableRelation Table 7354 “Bin”

Referenced by

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

Table 5876 “Phys. Invt. Order Line”: Document No.
Table 5877 “Phys. Invt. Record Header”: Order No.
Table 5881 “Pstd. Phys. Invt. Record Hdr”: Order No.
Table 5883 “Phys. Invt. Comment Line”: Order No.
Table 5886 “Exp. Phys. Invt. Tracking”: Order No
Table 6026 “Exp. Invt. Order Tracking”: Order No
Table 9050 “Warehouse Basic Cue”: Open Phys. Invt. Orders

Pages and codeunits on this table

Page 30232 “APIV2 - Phys. Invt. Orders” (source table)
Page 5875 “Physical Inventory Order” (source table)
Page 5876 “Physical Inventory Orders” (source table)
Page 5897 “Phys. Invt. Order Statistics” (source table)
Codeunit 5879 “Phys. Invt. Order-Finish (Y/N)” (codeunit runs on it)
Codeunit 5880 “Phys. Invt. Order-Finish” (codeunit runs on it)
Codeunit 5881 “Phys. Invt. Order-Reopen (Y/N)” (codeunit runs on it)
Codeunit 5882 “Phys. Invt. Order-Reopen” (codeunit runs on it)
Codeunit 5883 “Phys. Invt. Order-Post (Y/N)” (codeunit runs on it)
Codeunit 5884 “Phys. Invt. Order-Post” (codeunit runs on it)
Codeunit 5885 “Phys. Invt. Order-Post + Print” (codeunit runs on it)
Codeunit 5886 “Phys. Invt.-Show Duplicates” (codeunit runs on it)
Codeunit 5887 “Phys. Invt.-Calc. Qty. All” (codeunit runs on it)

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” (7 calls: CreateDim → GetRecDefaultDimID, CreateDim → UpdateGlobalDimFromDimSetID, InitDefaultDimensionSources → AddDimSource, …)
Page 456 “No. Series” (3 calls: AssistEdit → (object), InitInsert → (object), InitRecord → (object))

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