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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DEBIT AMOUNT

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

Dynamics 365 BC Table ReferencePage Control Search