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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DATEFILTER

Seq No	Page Number	Page Name	Control Name
1	113	Budget	DateFilter
2	154	G/L Account Balance/Budget	DateFilter
3	188	Posted Docs. With No Inc. Doc.	DateFilter
4	221	Resource Allocated per Job	DateFilter
5	228	Res. Gr. Allocated per Job	DateFilter
6	408	G/L Balance by Dimension	DateFilter
7	414	G/L Balance	DateFilter
8	422	G/L Balance/Budget	DateFilter
9	474	VAT Statement Preview	DateFilter
10	490	Acc. Schedule Overview	DateFilter
11	492	Item Availability by Location	DateFilter
12	520	Item Availability by Lot No.	DateFilter
13	521	Application Worksheet	DateFilter
14	554	Analysis by Dimensions	DateFilter
15	1120	Cost Type Balance/Budget	DateFilter
16	5414	Item Availability by Variant	DateFilter
17	5416	Item Availability by UOM	DateFilter
18	5493	Cash Flow Statement Entity	dateFilter
19	5497	Retained Earnings Entity	dateFilter
20	5501	Balance Sheet Entity	dateFilter
21	5502	Trial Balance Entity	dateFilter
22	5503	Income Statement Entity	dateFilter
23	5827	Item Statistics	DateFilter
24	5845	Inventory – G/L Reconciliation	DateFilter
25	6004	Res. Availability (Service)	DateFilter
26	6008	Res. Alloc. per Service Order	DateFilter
27	6009	Res. Gr. Alloc. per Serv Order	DateFilter
28	6010	Res.Gr. Availability (Service)	DateFilter
29	6408	Workflow – Customer Entity	dateFilter
30	6409	Workflow – Item Entity	dateFilter
31	6410	Workflow – Vendor Entity	dateFilter
32	7138	Purchase Budget Overview	DateFilter
33	7139	Sales Budget Overview	DateFilter
34	7157	Purch. Analysis by Dimensions	DateFilter
35	7158	Sales Analysis by Dimensions	DateFilter
36	7159	Invt. Analysis by Dimensions	DateFilter
37	8883	Sent Emails	DateFilter
38	20026	APIV1 – Cash Flow Statement	dateFilter
39	20029	APIV1 – Retained Earnings	dateFilter
40	20033	APIV1 – Balance Sheet	dateFilter
41	20034	APIV1 – Trial Balance	dateFilter
42	20035	APIV1 – Income Statement	dateFilter
43	30026	APIV2 – Cash Flow Statement	dateFilter
44	30029	APIV2 – Retained Earnings	dateFilter
45	30033	APIV2 – Balance Sheet	dateFilter
46	30034	APIV2 – Trial Balance	dateFilter
47	30035	APIV2 – Income Statement	dateFilter

Dynamics 365 BC Table ReferencePage Control Search