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 = 'Field1' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to FIELD1

Seq No	Page Number	Page Name	Control Name
1	863	CF Entries Dim. Matrix	Field1
2	950	Time Sheet	Field1
3	952	Manager Time Sheet	Field1
4	954	Manager Time Sheet by Job	Field1
5	959	Time Sheet Archive	Field1
6	961	Manager Time Sheet Archive	Field1
7	974	Time Sheet Lines Subform	Field1
8	976	Time Sheet Archive Subform	Field1
9	2900	Demand Forecast Variant Matrix	Field1
10	8626	Config. Package Records	Field1
11	9201	Inventory Analysis Matrix	Field1
12	9203	Budget Matrix	Field1
13	9205	Purchase Analysis Matrix	Field1
14	9207	Sales Analysis Matrix	Field1
15	9209	Invt. Analys by Dim. Matrix	Field1
16	9219	Purch. Budget Overview Matrix	Field1
17	9221	Res. Gr. Avail. (Serv.) Matrix	Field1
18	9223	Item Statistics Matrix	Field1
19	9225	Purch. Analysis by Dim Matrix	Field1
20	9227	Sales Analysis by Dim Matrix	Field1
21	9229	Res. Avail. (Service) Matrix	Field1
22	9231	Items by Location Matrix	Field1
23	9233	G/L Balance by Dim. Matrix	Field1
24	9237	Resource Capacity Matrix	Field1
25	9239	Sales Budget Overview Matrix	Field1
26	9241	G/L Entries Dim. Overv. Matrix	Field1
27	9243	Res. Group Capacity Matrix	Field1
28	9247	Abs. Overview by Period Matrix	Field1
29	9249	Analysis by Dimensions Matrix	Field1
30	9251	Dimension Combinations Matrix	Field1
31	9253	Dim. Value Combinations Matrix	Field1
32	9255	Tasks Matrix	Field1
33	9257	Opportunities Matrix	Field1
34	9259	Contr. Gain/Loss (Grps) Matrix	Field1
35	9261	Contr. G/Loss (Cust.) Matrix	Field1
36	9263	Contract Gain/Loss Matrix	Field1
37	9265	Contr. G/Loss (Res.Ctr) Matrix	Field1
38	9267	Contr. G/Loss (Contr.) Matrix	Field1
39	9269	Empl. Absences by Cat. Matrix	Field1
40	9271	Qualification Overview Matrix	Field1
41	9273	Abs. Over. by Cat. Matrix	Field1
42	9275	T. Value Insured per FA Matrix	Field1
43	9277	FA Posting Types Overv. Matrix	Field1
44	9281	Misc. Articles Overview Matrix	Field1
45	9283	Conf. Info. Overview Matrix	Field1
46	9285	Transfer Routes Matrix	Field1
47	9287	Prod. BOM Mat. per Ver. Matrix	Field1
48	9291	Work Center Calendar Matrix	Field1
49	9293	Machine Center Calendar Matrix	Field1
50	9295	Work Ctr. Grp. Calendar Matrix	Field1
51	9297	Inventory – G/L Recon Matrix	Field1
52	9555	Record Lookup	Field1

Dynamics 365 BC Table ReferencePage Control Search