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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BILL-TO POST CODE

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

Dynamics 365 BC Table ReferencePage Control Search