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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to FIELD2

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

Dynamics 365 BC Table ReferencePage Control Search