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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to FIELD17

Seq No	Page Number	Page Name	Control Name
1	863	CF Entries Dim. Matrix	Field17
2	2900	Demand Forecast Variant Matrix	Field17
3	8626	Config. Package Records	Field17
4	9201	Inventory Analysis Matrix	Field17
5	9205	Purchase Analysis Matrix	Field17
6	9207	Sales Analysis Matrix	Field17
7	9209	Invt. Analys by Dim. Matrix	Field17
8	9221	Res. Gr. Avail. (Serv.) Matrix	Field17
9	9223	Item Statistics Matrix	Field17
10	9225	Purch. Analysis by Dim Matrix	Field17
11	9227	Sales Analysis by Dim Matrix	Field17
12	9229	Res. Avail. (Service) Matrix	Field17
13	9231	Items by Location Matrix	Field17
14	9233	G/L Balance by Dim. Matrix	Field17
15	9241	G/L Entries Dim. Overv. Matrix	Field17
16	9247	Abs. Overview by Period Matrix	Field17
17	9249	Analysis by Dimensions Matrix	Field17
18	9251	Dimension Combinations Matrix	Field17
19	9253	Dim. Value Combinations Matrix	Field17
20	9255	Tasks Matrix	Field17
21	9257	Opportunities Matrix	Field17
22	9259	Contr. Gain/Loss (Grps) Matrix	Field17
23	9261	Contr. G/Loss (Cust.) Matrix	Field17
24	9263	Contract Gain/Loss Matrix	Field17
25	9265	Contr. G/Loss (Res.Ctr) Matrix	Field17
26	9267	Contr. G/Loss (Contr.) Matrix	Field17
27	9269	Empl. Absences by Cat. Matrix	Field17
28	9271	Qualification Overview Matrix	Field17
29	9273	Abs. Over. by Cat. Matrix	Field17
30	9275	T. Value Insured per FA Matrix	Field17
31	9277	FA Posting Types Overv. Matrix	Field17
32	9281	Misc. Articles Overview Matrix	Field17
33	9283	Conf. Info. Overview Matrix	Field17
34	9285	Transfer Routes Matrix	Field17
35	9287	Prod. BOM Mat. per Ver. Matrix	Field17
36	9291	Work Center Calendar Matrix	Field17
37	9293	Machine Center Calendar Matrix	Field17
38	9295	Work Ctr. Grp. Calendar Matrix	Field17
39	9297	Inventory – G/L Recon Matrix	Field17

Dynamics 365 BC Table ReferencePage Control Search