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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PURCHASER CODE

Seq No	Page Number	Page Name	Control Name
1	26	Vendor Card	Purchaser Code
2	27	Vendor List	Purchaser Code
3	29	Vendor Ledger Entries	Purchaser Code
4	34	Vendor Lookup	Purchaser Code
5	49	Purchase Quote	Purchaser Code
6	50	Purchase Order	Purchaser Code
7	51	Purchase Invoice	Purchaser Code
8	52	Purchase Credit Memo	Purchaser Code
9	53	Purchase List	Purchaser Code
10	62	Applied Vendor Entries	Purchaser Code
11	128	Vend. Ledg. Entries Preview	Purchaser Code
12	136	Posted Purchase Receipt	Purchaser Code
13	138	Posted Purchase Invoice	Purchaser Code
14	140	Posted Purchase Credit Memo	Purchaser Code
15	145	Posted Purchase Receipts	Purchaser Code
16	146	Posted Purchase Invoices	Purchaser Code
17	147	Posted Purchase Credit Memos	Purchaser Code
18	291	Req. Worksheet	Purchaser Code
19	509	Blanket Purchase Order	Purchaser Code
20	1386	Vendor Templ. Card	Purchaser Code
21	5164	Purchase Quote Archive	Purchaser Code
22	5166	Purchase List Archive	Purchaser Code
23	5167	Purchase Order Archive	Purchaser Code
24	6567	Posted Invt. Receipt	Purchaser Code
25	6623	Blanket Purchase Order Archive	Purchaser Code
26	6625	Blanket Purch. Order Archives	Purchaser Code
27	6640	Purchase Return Order	Purchaser Code
28	6644	Purchase Return Order Archive	Purchaser Code
29	6646	Purchase Return List Archive	Purchaser Code
30	6650	Posted Return Shipment	Purchaser Code
31	6652	Posted Return Shipments	Purchaser Code
32	9306	Purchase Quotes	Purchaser Code
33	9307	Purchase Order List	Purchaser Code
34	9308	Purchase Invoices	Purchaser Code
35	9309	Purchase Credit Memos	Purchaser Code
36	9310	Blanket Purchase Orders	Purchaser Code
37	9311	Purchase Return Order List	Purchaser Code
38	9346	Purchase Quote Archives	Purchaser Code
39	9347	Purchase Order Archives	Purchaser Code

Dynamics 365 BC Table ReferencePage Control Search