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 = 'Pay-to Vendor No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PAY-TO VENDOR NO.

Seq No	Page Number	Page Name	Control Name
1	26	Vendor Card	Pay-to Vendor No.
2	53	Purchase List	Pay-to Vendor No.
3	136	Posted Purchase Receipt	Pay-to Vendor No.
4	145	Posted Purchase Receipts	Pay-to Vendor No.
5	146	Posted Purchase Invoices	Pay-to Vendor No.
6	147	Posted Purchase Credit Memos	Pay-to Vendor No.
7	638	IC Outbox Purchase Doc.	Pay-to Vendor No.
8	642	Handled IC Outbox Purch. Doc.	Pay-to Vendor No.
9	646	IC Inbox Purchase Doc.	Pay-to Vendor No.
10	650	Handled IC Inbox Purch. Doc.	Pay-to Vendor No.
11	1386	Vendor Templ. Card	Pay-to Vendor No.
12	5164	Purchase Quote Archive	Pay-to Vendor No.
13	5166	Purchase List Archive	Pay-to Vendor No.
14	5167	Purchase Order Archive	Pay-to Vendor No.
15	5709	Get Receipt Lines	Pay-to Vendor No.
16	5856	Get Post.Doc – P.RcptLn Sbfrm	Pay-to Vendor No.
17	5858	Get Pst.Doc-RtrnShptLn Subform	Pay-to Vendor No.
18	6623	Blanket Purchase Order Archive	Pay-to Vendor No.
19	6625	Blanket Purch. Order Archives	Pay-to Vendor No.
20	6646	Purchase Return List Archive	Pay-to Vendor No.
21	6650	Posted Return Shipment	Pay-to Vendor No.
22	6652	Posted Return Shipments	Pay-to Vendor No.
23	9306	Purchase Quotes	Pay-to Vendor No.
24	9307	Purchase Order List	Pay-to Vendor No.
25	9308	Purchase Invoices	Pay-to Vendor No.
26	9309	Purchase Credit Memos	Pay-to Vendor No.
27	9310	Blanket Purchase Orders	Pay-to Vendor No.
28	9311	Purchase Return Order List	Pay-to Vendor No.
29	9346	Purchase Quote Archives	Pay-to Vendor No.
30	9347	Purchase Order Archives	Pay-to Vendor No.

Dynamics 365 BC Table ReferencePage Control Search