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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to ORDER DATE

Seq No	Page Number	Page Name	Control Name
1	41	Sales Quote	Order Date
2	42	Sales Order	Order Date
3	49	Purchase Quote	Order Date
4	50	Purchase Order	Order Date
5	54	Purchase Order Subform	Order Date
6	137	Posted Purchase Rcpt. Subform	Order Date
7	291	Req. Worksheet	Order Date
8	296	Recurring Req. Worksheet	Order Date
9	507	Blanket Sales Order	Order Date
10	509	Blanket Purchase Order	Order Date
11	517	Requisition Lines	Order Date
12	5159	Sales Order Archive	Order Date
13	5162	Sales Quote Archive	Order Date
14	5164	Purchase Quote Archive	Order Date
15	5167	Purchase Order Archive	Order Date
16	5168	Purchase Order Archive Subform	Order Date
17	5522	Order Planning	Order Date
18	5875	Physical Inventory Order	Order Date
19	5876	Physical Inventory Orders	Order Date
20	5883	Posted Phys. Invt. Order	Order Date
21	5884	Posted Phys. Invt. Order List	Order Date
22	5900	Service Order	Order Date
23	5901	Service List	Order Date
24	5949	Posted Serv. Shpt. Line List	Order Date
25	5964	Service Quote	Order Date
26	5974	Posted Service Shipments	Order Date
27	5975	Posted Service Shipment	Order Date
28	6000	Dispatch Board	Order Date
29	6620	Blanket Sales Order Archive	Order Date
30	6623	Blanket Purchase Order Archive	Order Date
31	6624	Blanket Purch. Order Arch.Sub.	Order Date
32	6627	Sales Return Order Archive	Order Date
33	6630	Sales Return Order	Order Date
34	6640	Purchase Return Order	Order Date
35	6644	Purchase Return Order Archive	Order Date
36	6645	Purch Return Order Arc Subform	Order Date
37	9317	Service Quotes	Order Date
38	9318	Service Orders	Order Date
39	9319	Service Invoices	Order Date
40	9320	Service Credit Memos	Order Date
41	99000852	Planning Worksheet	Order Date
42	99000886	Subcontracting Worksheet	Order Date

Dynamics 365 BC Table ReferencePage Control Search