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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BALANCE

Seq No	Page Number	Page Name	Control Name
1	16	Chart of Accounts	Balance
2	17	G/L Account Card	Balance
3	39	General Journal	Balance
4	253	Sales Journal	Balance
5	254	Purchase Journal	Balance
6	255	Cash Receipt Journal	Balance
7	256	Payment Journal	Balance
8	283	Recurring General Journal	Balance
9	370	Bank Account Card	Balance
10	375	Bank Account Statistics	Balance
11	380	Bank Acc. Reconciliation Lines	Balance
12	381	Apply Bank Acc. Ledger Entries	Balance
13	384	Bank Account Statement Lines	Balance
14	569	Chart of Accs. (Analysis View)	Balance
15	570	Chart of Accounts (G/L)	Balance
16	610	IC General Journal	Balance
17	634	Chart of Accounts Overview	Balance
18	1020	Job G/L Journal	Balance
19	1100	Chart of Cost Types	Balance
20	1101	Cost Type Card	Balance
21	1108	Cost Journal	Balance
22	1124	Cost Type List	Balance
23	1158	Cash Account Balances	Balance
24	1282	Payment Bank Account List	Balance
25	1810	Data Migration Entities	Balance
26	2631	Statistical Account Card	Balance
27	2632	Statistical Account List	Balance
28	2633	Statistical Accounts Journal	Balance
29	5501	Balance Sheet Entity	balance
30	5628	Fixed Asset G/L Journal	Balance
31	6408	Workflow – Customer Entity	balance
32	6410	Workflow – Vendor Entity	balance
33	9153	My Accounts	Balance
34	20010	APIV1 – Vendors	balance
35	20033	APIV1 – Balance Sheet	balance
36	20048	Customer Financial Details	balance
37	22207	Review G/L Entries	Balance
38	30010	APIV2 – Vendors	balance
39	30033	APIV2 – Balance Sheet	balance
40	30048	APIV2 – Cust Financial Details	balance
41	30308	API Finance – Vendor	balance

Dynamics 365 BC Table ReferencePage Control Search