Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Order No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to ORDER NO.

Seq No	Page Number	Page Name	Control Name
1	38	Item Ledger Entries	Order No.
2	130	Posted Sales Shipment	Order No.
3	132	Posted Sales Invoice	Order No.
4	136	Posted Purchase Receipt	Order No.
5	138	Posted Purchase Invoice	Order No.
6	143	Posted Sales Invoices	Order No.
7	146	Posted Purchase Invoices	Order No.
8	167	Item Ledger Entries Preview	Order No.
9	189	Incoming Document	Order No.
10	189	Incoming Document	Order No.
11	518	Purchase Lines	Order No.
12	522	View Applied Entries	Order No.
13	528	Posted Purchase Receipt Lines	Order No.
14	529	Posted Purchase Invoice Lines	Order No.
15	920	Posted Assembly Order	Order No.
16	922	Posted Assembly Orders	Order No.
17	1272	OCR Data Correction	Order No.
18	5802	Value Entries	Order No.
19	5804	Applied Item Entries	Order No.
20	5806	Purch. Receipt Lines	Order No.
21	5807	Value Entries Preview	Order No.
22	5832	Capacity Ledger Entries	Order No.
23	5879	Phys. Inventory Recording	Order No.
24	5880	Phys. Inventory Recording List	Order No.
25	5882	Phys. Invt. Recording Lines	Order No.
26	5887	Posted Phys. Invt. Recording	Order No.
27	5888	Posted Phys. Invt. Rec. List	Order No.
28	5890	Posted Phys. Invt. Rec. Lines	Order No.
29	5892	Phys. Inventory Comment List	Order No.
30	5975	Posted Service Shipment	Order No.
31	5977	Posted Service Invoices	Order No.
32	5978	Posted Service Invoice	Order No.
33	6121	E-Document	Order No.
34	6121	E-Document	Order No.
35	99000773	Capacity Journal	Order No.
36	99000778	Recurring Capacity Journal	Order No.
37	99000823	Output Journal	Order No.
38	99000827	Recurring Output Journal	Order No.
39	99000846	Consumption Journal	Order No.
40	99000850	Recurring Consumption Journal	Order No.

Dynamics 365 BC Table ReferencePage Control Search