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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PERIODTYPE

Seq No	Page Number	Page Name	Control Name
1	113	Budget	PeriodType
2	154	G/L Account Balance/Budget	PeriodType
3	155	Customer Sales	PeriodType
4	156	Vendor Purchases	PeriodType
5	157	Item Availability by Periods	PeriodType
6	158	Item Turnover	PeriodType
7	159	Receivables-Payables	PeriodType
8	213	Resource Capacity	PeriodType
9	214	Res. Group Capacity	PeriodType
10	221	Resource Allocated per Job	PeriodType
11	225	Resource Availability	PeriodType
12	226	Res. Group Availability	PeriodType
13	228	Res. Gr. Allocated per Job	PeriodType
14	377	Bank Account Balance	PeriodType
15	408	G/L Balance by Dimension	PeriodType
16	414	G/L Balance	PeriodType
17	415	G/L Account Balance	PeriodType
18	422	G/L Balance/Budget	PeriodType
19	490	Acc. Schedule Overview	PeriodType
20	520	Item Availability by Lot No.	PeriodType
21	554	Analysis by Dimensions	PeriodType
22	867	CF Availability by Periods	PeriodType
23	1110	Cost Type Balance	PeriodType
24	1117	Cost Budget per Period	PeriodType
25	1118	Cost Budget by Cost Center	PeriodType
26	1119	Cost Budget by Cost Object	PeriodType
27	1120	Cost Type Balance/Budget	PeriodType
28	2623	Stat. Account Balance	PeriodType
29	5099	Tasks	PeriodType
30	5131	Opportunities	PeriodType
31	5225	Absence Overview by Periods	PeriodType
32	5226	Empl. Absences by Categories	PeriodType
33	5231	Absence Overview by Categories	PeriodType
34	5260	G/L Account Mapping	PeriodType
35	5261	G/L Account Mapping Card	PeriodType
36	5414	Item Availability by Variant	PeriodType
37	5416	Item Availability by UOM	PeriodType
38	5530	Item Availability by Event	PeriodType
39	5622	Total Value Insured per FA	PeriodType
40	5662	FA Posting Types Overview	PeriodType
41	5983	Service Item Trendscape	PeriodType
42	6004	Res. Availability (Service)	PeriodType
43	6006	Res. Availability – Overview	PeriodType
44	6008	Res. Alloc. per Service Order	PeriodType
45	6009	Res. Gr. Alloc. per Serv Order	PeriodType
46	6010	Res.Gr. Availability (Service)	PeriodType
47	6011	Res.Gr.Availability – Overview	PeriodType
48	6060	Contract Trendscape	PeriodType
49	6066	Contract Gain/Loss (Groups)	PeriodType
50	6067	Contract Gain/Loss (Customers)	PeriodType
51	6068	Contract Gain/Loss (Reasons)	PeriodType
52	6069	Contract Gain/Loss (Resp.Ctr)	PeriodType
53	6071	Contract Gain/Loss (Contracts)	PeriodType
54	7117	Sales Analysis Report	PeriodType
55	7118	Purchase Analysis Report	PeriodType
56	7119	Inventory Analysis Report	PeriodType
57	7138	Purchase Budget Overview	PeriodType
58	7139	Sales Budget Overview	PeriodType
59	7157	Purch. Analysis by Dimensions	PeriodType
60	7158	Sales Analysis by Dimensions	PeriodType
61	7159	Invt. Analysis by Dimensions	PeriodType
62	99000769	Work Center Calendar	PeriodType
63	99000770	Machine Center Calendar	PeriodType
64	99000771	Work Ctr. Group Calendar	PeriodType
65	99000887	Work Center Load	PeriodType
66	99000889	Machine Center Load	PeriodType
67	99000891	Work Center Group Load	PeriodType

Dynamics 365 BC Table ReferencePage Control Search