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 = 'VAT Bus. Posting Group' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to VAT BUS. POSTING GROUP

Seq No	Page Number	Page Name	Control Name
1	16	Chart of Accounts	VAT Bus. Posting Group
2	17	G/L Account Card	VAT Bus. Posting Group
3	18	G/L Account List	VAT Bus. Posting Group
4	20	General Ledger Entries	VAT Bus. Posting Group
5	21	Customer Card	VAT Bus. Posting Group
6	22	Customer List	VAT Bus. Posting Group
7	26	Vendor Card	VAT Bus. Posting Group
8	27	Vendor List	VAT Bus. Posting Group
9	33	Customer Lookup	VAT Bus. Posting Group
10	34	Vendor Lookup	VAT Bus. Posting Group
11	39	General Journal	VAT Bus. Posting Group
12	41	Sales Quote	VAT Bus. Posting Group
13	42	Sales Order	VAT Bus. Posting Group
14	43	Sales Invoice	VAT Bus. Posting Group
15	44	Sales Credit Memo	VAT Bus. Posting Group
16	46	Sales Order Subform	VAT Bus. Posting Group
17	47	Sales Invoice Subform	VAT Bus. Posting Group
18	49	Purchase Quote	VAT Bus. Posting Group
19	50	Purchase Order	VAT Bus. Posting Group
20	51	Purchase Invoice	VAT Bus. Posting Group
21	52	Purchase Credit Memo	VAT Bus. Posting Group
22	54	Purchase Order Subform	VAT Bus. Posting Group
23	55	Purch. Invoice Subform	VAT Bus. Posting Group
24	95	Sales Quote Subform	VAT Bus. Posting Group
25	96	Sales Cr. Memo Subform	VAT Bus. Posting Group
26	97	Purchase Quote Subform	VAT Bus. Posting Group
27	98	Purch. Cr. Memo Subform	VAT Bus. Posting Group
28	123	VAT Entries Preview	VAT Bus. Posting Group
29	133	Posted Sales Invoice Subform	VAT Bus. Posting Group
30	135	Posted Sales Cr. Memo Subform	VAT Bus. Posting Group
31	139	Posted Purch. Invoice Subform	VAT Bus. Posting Group
32	141	Posted Purch. Cr. Memo Subform	VAT Bus. Posting Group
33	182	Posted General Journal	VAT Bus. Posting Group
34	253	Sales Journal	VAT Bus. Posting Group
35	254	Purchase Journal	VAT Bus. Posting Group
36	255	Cash Receipt Journal	VAT Bus. Posting Group
37	256	Payment Journal	VAT Bus. Posting Group
38	283	Recurring General Journal	VAT Bus. Posting Group
39	284	Allocations	VAT Bus. Posting Group
40	315	VAT Entries	VAT Bus. Posting Group
41	317	VAT Statement	VAT Bus. Posting Group
42	472	VAT Posting Setup	VAT Bus. Posting Group
43	472	VAT Posting Setup	VAT Bus. Posting Group
44	473	VAT Posting Setup Card	VAT Bus. Posting Group
45	475	VAT Statement Preview Line	VAT Bus. Posting Group
46	507	Blanket Sales Order	VAT Bus. Posting Group
47	508	Blanket Sales Order Subform	VAT Bus. Posting Group
48	509	Blanket Purchase Order	VAT Bus. Posting Group
49	510	Blanket Purchase Order Subform	VAT Bus. Posting Group
50	569	Chart of Accs. (Analysis View)	VAT Bus. Posting Group
51	570	Chart of Accounts (G/L)	VAT Bus. Posting Group
52	610	IC General Journal	VAT Bus. Posting Group
53	634	Chart of Accounts Overview	VAT Bus. Posting Group
54	741	VAT Report Subform	VAT Bus. Posting Group
55	752	Standard Gen. Journal Subform	VAT Bus. Posting Group
56	1020	Job G/L Journal	VAT Bus. Posting Group
57	1382	Customer Templ. Card	VAT Bus. Posting Group
58	1386	Vendor Templ. Card	VAT Bus. Posting Group
59	1572	VAT Entries Preview Subform	VAT Bus. Posting Group
60	1575	VAT Entries Preview Flat Subf.	VAT Bus. Posting Group
61	5160	Sales Order Archive Subform	VAT Bus. Posting Group
62	5163	Sales Quote Archive Subform	VAT Bus. Posting Group
63	5165	Purchase Quote Archive Subform	VAT Bus. Posting Group
64	5168	Purchase Order Archive Subform	VAT Bus. Posting Group
65	5628	Fixed Asset G/L Journal	VAT Bus. Posting Group
66	5900	Service Order	VAT Bus. Posting Group
67	5907	Service Item Worksheet Subform	VAT Bus. Posting Group
68	5934	Service Invoice Subform	VAT Bus. Posting Group
69	5936	Service Credit Memo Subform	VAT Bus. Posting Group
70	5964	Service Quote	VAT Bus. Posting Group
71	5973	Posted Serv. Cr. Memo Subform	VAT Bus. Posting Group
72	5979	Posted Service Invoice Subform	VAT Bus. Posting Group
73	6038	Service Invoice Lines Subform	VAT Bus. Posting Group
74	6039	Service Cr. Memo Lines Subform	VAT Bus. Posting Group
75	6627	Sales Return Order Archive	VAT Bus. Posting Group
76	6628	Sales Return Order Arc Subform	VAT Bus. Posting Group
77	6630	Sales Return Order	VAT Bus. Posting Group
78	6631	Sales Return Order Subform	VAT Bus. Posting Group
79	6640	Purchase Return Order	VAT Bus. Posting Group
80	6641	Purchase Return Order Subform	VAT Bus. Posting Group
81	6644	Purchase Return Order Archive	VAT Bus. Posting Group
82	6645	Purch Return Order Arc Subform	VAT Bus. Posting Group
83	30101	Shpfy Shop Card	VAT Bus. Posting Group

Dynamics 365 BC Table ReferencePage Control Search