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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to FIELD5

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

Dynamics 365 BC Table ReferencePage Control Search