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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to FIELD7

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

Dynamics 365 BC Table ReferencePage Control Search