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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BILL-TO CONTACT

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

Dynamics 365 BC Table ReferencePage Control Search