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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BILL-TO NAME

Seq No	Page Number	Page Name	Control Name
1	41	Sales Quote	Bill-to Name
2	42	Sales Order	Bill-to Name
3	43	Sales Invoice	Bill-to Name
4	44	Sales Credit Memo	Bill-to Name
5	45	Sales List	Bill-to Name
6	88	Job Card	Bill-to Name
7	130	Posted Sales Shipment	Bill-to Name
8	132	Posted Sales Invoice	Bill-to Name
9	134	Posted Sales Credit Memo	Bill-to Name
10	142	Posted Sales Shipments	Bill-to Name
11	143	Posted Sales Invoices	Bill-to Name
12	144	Posted Sales Credit Memos	Bill-to Name
13	507	Blanket Sales Order	Bill-to Name
14	1356	Posted Service Inv. – Update	Bill-to Name
15	5159	Sales Order Archive	Bill-to Name
16	5162	Sales Quote Archive	Bill-to Name
17	5900	Service Order	Bill-to Name
18	5933	Service Invoice	Bill-to Name
19	5935	Service Credit Memo	Bill-to Name
20	5964	Service Quote	Bill-to Name
21	5971	Posted Service Credit Memos	Bill-to Name
22	5972	Posted Service Credit Memo	Bill-to Name
23	5974	Posted Service Shipments	Bill-to Name
24	5975	Posted Service Shipment	Bill-to Name
25	5977	Posted Service Invoices	Bill-to Name
26	5978	Posted Service Invoice	Bill-to Name
27	6050	Service Contract	Bill-to Name
28	6053	Service Contract Quote	Bill-to Name
29	6072	Filed Service Contract	Bill-to Name
30	6620	Blanket Sales Order Archive	Bill-to Name
31	6627	Sales Return Order Archive	Bill-to Name
32	6629	Sales Return List Archive	Bill-to Name
33	6630	Sales Return Order	Bill-to Name
34	6660	Posted Return Receipt	Bill-to Name
35	6662	Posted Return Receipts	Bill-to Name
36	9154	My Jobs	Bill-to Name
37	9211	Resource Alloc. per Job Matrix	Bill-to Name
38	9213	ResGrp. Alloc. per Job Matrix	Bill-to Name
39	9300	Sales Quotes	Bill-to Name
40	9301	Sales Invoice List	Bill-to Name
41	9302	Sales Credit Memos	Bill-to Name
42	9303	Blanket Sales Orders	Bill-to Name
43	9304	Sales Return Order List	Bill-to Name
44	9305	Sales Order List	Bill-to Name

Dynamics 365 BC Table ReferencePage Control Search