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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to AMOUNTTYPE

Seq No	Page Number	Page Name	Control Name
1	154	G/L Account Balance/Budget	AmountType
2	155	Customer Sales	AmountType
3	156	Vendor Purchases	AmountType
4	157	Item Availability by Periods	AmountType
5	158	Item Turnover	AmountType
6	159	Receivables-Payables	AmountType
7	221	Resource Allocated per Job	AmountType
8	225	Resource Availability	AmountType
9	226	Res. Group Availability	AmountType
10	377	Bank Account Balance	AmountType
11	408	G/L Balance by Dimension	AmountType
12	414	G/L Balance	AmountType
13	415	G/L Account Balance	AmountType
14	422	G/L Balance/Budget	AmountType
15	492	Item Availability by Location	AmountType
16	520	Item Availability by Lot No.	AmountType
17	867	CF Availability by Periods	AmountType
18	1110	Cost Type Balance	AmountType
19	1117	Cost Budget per Period	AmountType
20	1118	Cost Budget by Cost Center	AmountType
21	1119	Cost Budget by Cost Object	AmountType
22	1120	Cost Type Balance/Budget	AmountType
23	2623	Stat. Account Balance	AmountType
24	5414	Item Availability by Variant	AmountType
25	5416	Item Availability by UOM	AmountType
26	5622	Total Value Insured per FA	AmountType
27	5662	FA Posting Types Overview	AmountType
28	5827	Item Statistics	AmountType
29	5983	Service Item Trendscape	AmountType
30	6006	Res. Availability – Overview	AmountType
31	6011	Res.Gr.Availability – Overview	AmountType
32	6060	Contract Trendscape	AmountType
33	6066	Contract Gain/Loss (Groups)	AmountType
34	6067	Contract Gain/Loss (Customers)	AmountType
35	6068	Contract Gain/Loss (Reasons)	AmountType
36	6069	Contract Gain/Loss (Resp.Ctr)	AmountType
37	6071	Contract Gain/Loss (Contracts)	AmountType
38	7013	Price List Filters	AmountType
39	7016	Sales Price List	AmountType
40	7018	Purchase Price List	AmountType
41	7024	Prices Overview	AmountType
42	99000887	Work Center Load	AmountType
43	99000889	Machine Center Load	AmountType
44	99000891	Work Center Group Load	AmountType

Dynamics 365 BC Table ReferencePage Control Search