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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CURRENCYCODE

Seq No	Page Number	Page Name	Control Name
1	511	Change Exchange Rate	CurrencyCode
2	591	Payment Tolerance Warning	CurrencyCode
3	599	Payment Disc Tolerance Warning	CurrencyCode
4	697	IC Bank Account List	CurrencyCode
5	698	IC Bank Account Card	CurrencyCode
6	5499	Aged AR Entity	currencyCode
7	5500	Aged AP Entity	currencyCode
8	5551	Fixed Asset Acquisition Wizard	CurrencyCode
9	6402	Sales Document Entity	currencyCode
10	6403	Sales Document Line Entity	currencyCode
11	6404	Purchase Document Entity	currencyCode
12	6405	Purchase Document Line Entity	currencyCode
13	6407	Gen. Journal Line Entity	currencyCode
14	6408	Workflow – Customer Entity	currencyCode
15	6410	Workflow – Vendor Entity	currencyCode
16	7001	Price List Lines	CurrencyCode
17	7011	Purchase Price List Lines	CurrencyCode
18	7013	Price List Filters	CurrencyCode
19	7016	Sales Price List	CurrencyCode
20	7018	Purchase Price List	CurrencyCode
21	9970	Posted Sales Invoice API	currencyCode
22	9971	Posted Purchase Invoice API	currencyCode
23	20009	APIV1 – Customers	currencyCode
24	20010	APIV1 – Vendors	currencyCode
25	20011	APIV1 – Company Information	currencyCode
26	20012	APIV1 – Sales Invoices	currencyCode
27	20028	APIV1 – Sales Orders	currencyCode
28	20031	APIV1 – Aged AR	currencyCode
29	20032	APIV1 – Aged AP	currencyCode
30	20037	APIV1 – Sales Quotes	currencyCode
31	20038	APIV1 – Sales Credit Memos	currencyCode
32	20042	APIV1 – Purchase Invoices	currencyCode
33	20106	AMC Bank Assist Bank Account	CurrencyCode
34	30009	APIV2 – Customers	currencyCode
35	30010	APIV2 – Vendors	currencyCode
36	30011	APIV2 – Company Information	currencyCode
37	30012	APIV2 – Sales Invoices	currencyCode
38	30028	APIV2 – Sales Orders	currencyCode
39	30031	APIV2 – Aged AR	currencyCode
40	30032	APIV2 – Aged AP	currencyCode
41	30037	APIV2 – Sales Quotes	currencyCode
42	30038	APIV2 – Sales Credit Memos	currencyCode
43	30042	APIV2 – Purchase Invoices	currencyCode
44	30051	APIV2 – Bank Accounts	currencyCode
45	30062	APIV2 – Sales Shipments	currencyCode
46	30064	APIV2 – Purchase Receipts	currencyCode
47	30066	APIV2 – Purchase Orders	currencyCode
48	30083	APIV2 – Purchase Credit Memos	currencyCode
49	30085	APIV2- Currency Exchange Rates	currencyCode
50	30101	Shpfy Shop Card	CurrencyCode
51	30113	Shpfy Order	CurrencyCode
52	30121	Shpfy Orders to Import	CurrencyCode
53	30121	Shpfy Orders to Import	CurrencyCode
54	30301	API Finance – Business Unit	currencyCode
55	30307	API Finance – Customer	currencyCode
56	30308	API Finance – Vendor	currencyCode
57	30413	API – IC Partners	currencyCode
58	30418	API Buf IC Inbox Jnl Line	currencyCode
59	30419	API Buf IC Inbox Purchase Line	currencyCode
60	30420	API Buf IC Inbox Purch Header	currencyCode
61	30421	API Buf IC Inbox Sales Header	currencyCode
62	30422	API Buf IC Inbox Sales Line	currencyCode

Dynamics 365 BC Table ReferencePage Control Search