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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to SELL-TO POST CODE

Seq No	Page Number	Page Name	Control Name
1	41	Sales Quote	Sell-to Post Code
2	42	Sales Order	Sell-to Post Code
3	43	Sales Invoice	Sell-to Post Code
4	44	Sales Credit Memo	Sell-to Post Code
5	45	Sales List	Sell-to Post Code
6	88	Job Card	Sell-to Post Code
7	130	Posted Sales Shipment	Sell-to Post Code
8	132	Posted Sales Invoice	Sell-to Post Code
9	134	Posted Sales Credit Memo	Sell-to Post Code
10	142	Posted Sales Shipments	Sell-to Post Code
11	143	Posted Sales Invoices	Sell-to Post Code
12	144	Posted Sales Credit Memos	Sell-to Post Code
13	507	Blanket Sales Order	Sell-to Post Code
14	2310	BC O365 Sales Invoice	Sell-to Post Code
15	2313	BC O365 Posted Sales Invoice	Sell-to Post Code
16	2341	BC O365 Sales Quote	Sell-to Post Code
17	5159	Sales Order Archive	Sell-to Post Code
18	5161	Sales List Archive	Sell-to Post Code
19	5162	Sales Quote Archive	Sell-to Post Code
20	6620	Blanket Sales Order Archive	Sell-to Post Code
21	6622	Blanket Sales Order Archives	Sell-to Post Code
22	6627	Sales Return Order Archive	Sell-to Post Code
23	6629	Sales Return List Archive	Sell-to Post Code
24	6630	Sales Return Order	Sell-to Post Code
25	6660	Posted Return Receipt	Sell-to Post Code
26	6662	Posted Return Receipts	Sell-to Post Code
27	9300	Sales Quotes	Sell-to Post Code
28	9301	Sales Invoice List	Sell-to Post Code
29	9302	Sales Credit Memos	Sell-to Post Code
30	9303	Blanket Sales Orders	Sell-to Post Code
31	9304	Sales Return Order List	Sell-to Post Code
32	9305	Sales Order List	Sell-to Post Code
33	9348	Sales Quote Archives	Sell-to Post Code
34	9349	Sales Order Archives	Sell-to Post Code

Dynamics 365 BC Table ReferencePage Control Search