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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DATE

Seq No	Page Number	Page Name	Control Name
1	66	Purch. Comment Sheet	Date
2	67	Sales Comment Sheet	Date
3	68	Purch. Comment List	Date
4	69	Sales Comment List	Date
5	71	User Time Registers	Date
6	120	G/L Budget Entries	Date
7	124	Comment Sheet	Date
8	125	Comment List	Date
9	197	Acc. Sched. KPI Web Service	Date
10	198	Acc. Sched. KPI WS Dimensions	Date
11	224	Res. Capacity Entries	Date
12	311	Intrastat Journal	Date
13	442	Reminder Comment Sheet	Date
14	443	Reminder Comment List	Date
15	454	Fin. Charge Comment Sheet	Date
16	455	Fin. Charge Comment List	Date
17	620	IC Comment Sheet	Date
18	684	Date-Time Dialog	Date
19	848	Cash Flow Comment	Date
20	858	Cash Flow Comment List	Date
21	907	Assembly Comment Sheet	Date
22	955	Time Sheet Comment Sheet	Date
23	963	Time Sheet Arc. Comment Sheet	Date
24	1115	Cost Budget Entries	Date
25	1615	Office Job Journal	Date
26	1615	Office Job Journal	Date
27	1698	Bank Acc. Comment List	Date
28	1699	Bank Acc. Comment Sheet	Date
29	4813	Intrastat Report Subform	Date
30	4816	Intrastat Report Lines	Date
31	5072	Rlshp. Mgt. Comment Sheet	Date
32	5073	Contact Int. Entries Subform	Date
33	5076	Interaction Log Entries	Date
34	5077	Create Interaction	Date
35	5082	Postponed Interactions	Date
36	5089	Campaign Entries	Date
37	5091	Segment	Date
38	5092	Segment Subform	Date
39	5093	Segment List	Date
40	5096	Task List	Date
41	5097	Create Task	Date
42	5098	Task Card	Date
43	5118	Rlshp. Mgt. Comment List	Date
44	5146	Assign Activity	Date
45	5147	Make Phone Call	Date
46	5150	Contact Segment List	Date
47	5179	Purch. Archive Comment Sheet	Date
48	5180	Sales Archive Comment Sheet	Date
49	5187	Inter. Log Entry Comment Sheet	Date
50	5188	Inter. Log Entry Comment List	Date
51	5222	Human Resource Comment Sheet	Date
52	5223	Human Resource Comment List	Date
53	5234	HR Confidential Comment Sheet	Date
54	5235	HR Confidential Comment List	Date
55	5702	Stockkeeping Unit Comment List	Date
56	5704	Stock. Unit Comment Sheet	Date
57	5750	Inventory Comment Sheet	Date
58	5751	Inventory Comment List	Date
59	5776	Warehouse Comment Sheet	Date
60	5777	Warehouse Comment List	Date
61	5830	Demand Overview	Date
62	5891	Phys. Inventory Comment Sheet	Date
63	5892	Phys. Inventory Comment List	Date
64	5911	Service Comment Sheet	Date
65	6307	PBI Aged Acc. Payable	Date
66	6308	PBI Aged Acc. Receivable	Date
67	6309	PBI Aged Inventory Chart	Date
68	6506	Item Tracking Comments	Date
69	7133	Item Budget Entries	Date
70	7602	Base Calendar Changes	Date
71	7603	Customized Calendar Changes	Date
72	7607	Base Calendar Change List	Date
73	8851	Bank Statement Import Preview	Date
74	9191	User Page Personalization List	Date
75	20041	APIV1 – Time Registr. Entries	date
76	30041	APIV2 – Time Registr. Entries	date
77	30125	Shpfy Payouts	Date
78	30416	API Buf IC Comment Lines	date
79	41001	Hist. Gen. Journal Lines	Date
80	99000753	Shop Calendar Holidays	Date
81	99000759	Calendar Entries	Date
82	99000772	Capacity Absence	Date
83	99000784	Manufacturing Comment Sheet	Date
84	99000785	Manufacturing Comment List	Date
85	99000794	Routing Comment Sheet	Date
86	99000795	Prod. Order BOM Cmt. Sheet	Date
87	99000796	Routing Comment List	Date
88	99000797	Prod. BOM Comment List	Date
89	99000820	Prod. Order Capacity Need	Date
90	99000820	Prod. Order Capacity Need	Date
91	99000838	Prod. Order Comment Sheet	Date
92	99000839	Prod. Order Comment List	Date
93	99000840	Prod. Order Rtng. Cmt. Sh.	Date
94	99000841	Prod. Order Rtng. Cmt. List	Date
95	99000842	Prod. Order Comp. Cmt. Sheet	Date
96	99000843	Prod. Order BOM Cmt List	Date
97	99000920	Registered Absences	Date

Dynamics 365 BC Table ReferencePage Control Search