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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to TAX AREA CODE

Seq No	Page Number	Page Name	Control Name
1	21	Customer Card	Tax Area Code
2	26	Vendor Card	Tax Area Code
3	41	Sales Quote	Tax Area Code
4	46	Sales Order Subform	Tax Area Code
5	47	Sales Invoice Subform	Tax Area Code
6	49	Purchase Quote	Tax Area Code
7	50	Purchase Order	Tax Area Code
8	51	Purchase Invoice	Tax Area Code
9	52	Purchase Credit Memo	Tax Area Code
10	54	Purchase Order Subform	Tax Area Code
11	55	Purch. Invoice Subform	Tax Area Code
12	95	Sales Quote Subform	Tax Area Code
13	96	Sales Cr. Memo Subform	Tax Area Code
14	97	Purchase Quote Subform	Tax Area Code
15	98	Purch. Cr. Memo Subform	Tax Area Code
16	132	Posted Sales Invoice	Tax Area Code
17	133	Posted Sales Invoice Subform	Tax Area Code
18	134	Posted Sales Credit Memo	Tax Area Code
19	135	Posted Sales Cr. Memo Subform	Tax Area Code
20	138	Posted Purchase Invoice	Tax Area Code
21	139	Posted Purch. Invoice Subform	Tax Area Code
22	253	Sales Journal	Tax Area Code
23	254	Purchase Journal	Tax Area Code
24	507	Blanket Sales Order	Tax Area Code
25	508	Blanket Sales Order Subform	Tax Area Code
26	509	Blanket Purchase Order	Tax Area Code
27	510	Blanket Purchase Order Subform	Tax Area Code
28	1382	Customer Templ. Card	Tax Area Code
29	1386	Vendor Templ. Card	Tax Area Code
30	5159	Sales Order Archive	Tax Area Code
31	5160	Sales Order Archive Subform	Tax Area Code
32	5162	Sales Quote Archive	Tax Area Code
33	5163	Sales Quote Archive Subform	Tax Area Code
34	5164	Purchase Quote Archive	Tax Area Code
35	5165	Purchase Quote Archive Subform	Tax Area Code
36	5167	Purchase Order Archive	Tax Area Code
37	5168	Purchase Order Archive Subform	Tax Area Code
38	5900	Service Order	Tax Area Code
39	5933	Service Invoice	Tax Area Code
40	5934	Service Invoice Subform	Tax Area Code
41	5936	Service Credit Memo Subform	Tax Area Code
42	6630	Sales Return Order	Tax Area Code
43	6631	Sales Return Order Subform	Tax Area Code
44	6640	Purchase Return Order	Tax Area Code
45	6641	Purchase Return Order Subform	Tax Area Code
46	30101	Shpfy Shop Card	Tax Area Code

Dynamics 365 BC Table ReferencePage Control Search