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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to FIELD3

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

Dynamics 365 BC Table ReferencePage Control Search