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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CREDIT AMOUNT

Seq No	Page Number	Page Name	Control Name
1	16	Chart of Accounts	Credit Amount
2	20	General Ledger Entries	Credit Amount
3	25	Customer Ledger Entries	Credit Amount
4	29	Vendor Ledger Entries	Credit Amount
5	39	General Journal	Credit Amount
6	61	Applied Customer Entries	Credit Amount
7	62	Applied Vendor Entries	Credit Amount
8	63	Applied Employee Entries	Credit Amount
9	122	G/L Entries Preview	Credit Amount
10	126	Cust. Ledg. Entries Preview	Credit Amount
11	127	Det. Cust. Ledg. Entr. Preview	Credit Amount
12	128	Vend. Ledg. Entries Preview	Credit Amount
13	129	Detailed Vend. Entries Preview	Credit Amount
14	165	Bank Acc. Ledg. Entr. Preview	Credit Amount
15	179	Reverse Entries	Credit Amount
16	182	Posted General Journal	Credit Amount
17	183	Reverse Transaction Entries	Credit Amount
18	188	Posted Docs. With No Inc. Doc.	Credit Amount
19	232	Apply Customer Entries	Credit Amount
20	233	Apply Vendor Entries	Credit Amount
21	234	Apply Employee Entries	Credit Amount
22	253	Sales Journal	Credit Amount
23	254	Purchase Journal	Credit Amount
24	255	Cash Receipt Journal	Credit Amount
25	256	Payment Journal	Credit Amount
26	283	Recurring General Journal	Credit Amount
27	372	Bank Account Ledger Entries	Credit Amount
28	381	Apply Bank Acc. Ledger Entries	Credit Amount
29	414	G/L Balance	Credit Amount
30	422	G/L Balance/Budget	Credit Amount
31	558	Analysis View Entries	Credit Amount
32	573	Detailed Cust. Ledg. Entries	Credit Amount
33	574	Detailed Vendor Ledg. Entries	Credit Amount
34	610	IC General Journal	Credit Amount
35	623	Unapply Customer Entries	Credit Amount
36	624	Unapply Vendor Entries	Credit Amount
37	625	Unapply Employee Entries	Credit Amount
38	634	Chart of Accounts Overview	Credit Amount
39	752	Standard Gen. Journal Subform	Credit Amount
40	1020	Job G/L Journal	Credit Amount
41	1103	Cost Entries	Credit Amount
42	1104	Cost Registers	Credit Amount
43	1108	Cost Journal	Credit Amount
44	1120	Cost Type Balance/Budget	Credit Amount
45	1571	G/L Entries Preview Subform	Credit Amount
46	1574	G/L Entries Preview Flat Subf.	Credit Amount
47	1693	Bank Deposit Subform	Credit Amount
48	5238	Detailed Empl. Ledger Entries	Credit Amount
49	5240	Detailed Empl. Entries Preview	Credit Amount
50	5604	FA Ledger Entries	Credit Amount
51	5605	FA Error Ledger Entries	Credit Amount
52	5606	FA Ledger Entries Preview	Credit Amount
53	5628	Fixed Asset G/L Journal	Credit Amount
54	5629	Fixed Asset Journal	Credit Amount
55	5634	Recurring Fixed Asset Journal	Credit Amount
56	5641	Maintenance Ledger Entries	Credit Amount
57	5671	Maint. Ledg. Entries Preview	Credit Amount
58	9241	G/L Entries Dim. Overv. Matrix	Credit Amount
59	22207	Review G/L Entries	Credit Amount
60	41001	Hist. Gen. Journal Lines	Credit Amount

Dynamics 365 BC Table ReferencePage Control Search