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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CAMPAIGN NO.

Seq No	Page Number	Page Name	Control Name
1	39	General Journal	Campaign No.
2	41	Sales Quote	Campaign No.
3	42	Sales Order	Campaign No.
4	43	Sales Invoice	Campaign No.
5	44	Sales Credit Memo	Campaign No.
6	49	Purchase Quote	Campaign No.
7	51	Purchase Invoice	Campaign No.
8	52	Purchase Credit Memo	Campaign No.
9	253	Sales Journal	Campaign No.
10	254	Purchase Journal	Campaign No.
11	255	Cash Receipt Journal	Campaign No.
12	256	Payment Journal	Campaign No.
13	283	Recurring General Journal	Campaign No.
14	507	Blanket Sales Order	Campaign No.
15	509	Blanket Purchase Order	Campaign No.
16	610	IC General Journal	Campaign No.
17	752	Standard Gen. Journal Subform	Campaign No.
18	1020	Job G/L Journal	Campaign No.
19	5073	Contact Int. Entries Subform	Campaign No.
20	5075	Interaction Templates	Campaign No.
21	5076	Interaction Log Entries	Campaign No.
22	5082	Postponed Interactions	Campaign No.
23	5091	Segment	Campaign No.
24	5092	Segment Subform	Campaign No.
25	5093	Segment List	Campaign No.
26	5096	Task List	Campaign No.
27	5098	Task Card	Campaign No.
28	5123	Opportunity List	Campaign No.
29	5124	Opportunity Card	Campaign No.
30	5132	Active Opportunity List	Campaign No.
31	5159	Sales Order Archive	Campaign No.
32	5162	Sales Quote Archive	Campaign No.
33	5628	Fixed Asset G/L Journal	Campaign No.
34	6620	Blanket Sales Order Archive	Campaign No.
35	6627	Sales Return Order Archive	Campaign No.
36	6630	Sales Return Order	Campaign No.
37	6640	Purchase Return Order	Campaign No.
38	9300	Sales Quotes	Campaign No.
39	9301	Sales Invoice List	Campaign No.
40	9302	Sales Credit Memos	Campaign No.
41	9304	Sales Return Order List	Campaign No.
42	9305	Sales Order List	Campaign No.
43	9306	Purchase Quotes	Campaign No.
44	9311	Purchase Return Order List	Campaign No.

Dynamics 365 BC Table ReferencePage Control Search