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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CITY

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	City
2	1	Company Information	City
3	21	Customer Card	City
4	26	Vendor Card	City
5	33	Customer Lookup	City
6	34	Vendor Lookup	City
7	76	Resource Card	City
8	300	Ship-to Address	City
9	300	Ship-to Address	City
10	301	Ship-to Address List	City
11	367	Post Codes	City
12	368	Order Address	City
13	368	Order Address	City
14	369	Order Address List	City
15	370	Bank Account Card	City
16	423	Customer Bank Account Card	City
17	425	Vendor Bank Account Card	City
18	434	Reminder	City
19	436	Reminder List	City
20	438	Issued Reminder	City
21	440	Issued Reminder List	City
22	446	Finance Charge Memo	City
23	448	Finance Charge Memo List	City
24	450	Issued Finance Charge Memo	City
25	452	Issued Fin. Charge Memo List	City
26	1165	COHUB Enviroment Card	City
27	1382	Customer Templ. Card	City
28	1386	Vendor Templ. Card	City
29	1388	Employee Templ. Card	City
30	1803	Assisted Company Setup Wizard	City
31	2148	O365 Address	City
32	2318	BC O365 Sales Customer Card	City
33	2330	BC O365 Business Info Settings	City
34	2368	Remit Address	City
35	2368	Remit Address	City
36	2369	Remit Address List	City
37	4093	GP Customer	CITY
38	4093	GP Customer	CITY
39	4096	GP Vendor	CITY
40	4096	GP Vendor	CITY
41	5050	Contact Card	City
42	5054	Company Details	City
43	5056	Contact Alt. Address Card	City
44	5057	Contact Alt. Address List	City
45	5200	Employee Card	City
46	5203	Alternative Address Card	City
47	5204	Alternative Address List	City
48	5213	Unions	City
49	5703	Location Card	City
50	5714	Responsibility Center Card	City
51	5900	Service Order	City
52	5933	Service Invoice	City
53	5935	Service Credit Memo	City
54	5964	Service Quote	City
55	5972	Posted Service Credit Memo	City
56	5975	Posted Service Shipment	City
57	5978	Posted Service Invoice	City
58	5980	Service Item Card	City
59	6050	Service Contract	City
60	6053	Service Contract Quote	City
61	6072	Filed Service Contract	City
62	6408	Workflow – Customer Entity	city
63	6410	Workflow – Vendor Entity	city
64	8629	Config. Wizard	City
65	9128	Invt. Doc Ship. Detail Factbox	City
66	30009	APIV2 – Customers	city
67	30010	APIV2 – Vendors	city
68	30011	APIV2 – Company Information	city
69	30017	APIV2 – Employees	city
70	30071	APIV2 – Contacts	city
71	30076	APIV2 – Locations	city
72	30105	Shpfy Customer Adresses	City
73	30307	API Finance – Customer	city
74	30308	API Finance – Vendor	city

Dynamics 365 BC Table ReferencePage Control Search