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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to AMOUNT (LCY)

Seq No	Page Number	Page Name	Control Name
1	25	Customer Ledger Entries	Amount (LCY)
2	29	Vendor Ledger Entries	Amount (LCY)
3	39	General Journal	Amount (LCY)
4	127	Det. Cust. Ledg. Entr. Preview	Amount (LCY)
5	129	Detailed Vend. Entries Preview	Amount (LCY)
6	165	Bank Acc. Ledg. Entr. Preview	Amount (LCY)
7	168	Service Ledger Entries Preview	Amount (LCY)
8	179	Reverse Entries	Amount (LCY)
9	182	Posted General Journal	Amount (LCY)
10	183	Reverse Transaction Entries	Amount (LCY)
11	253	Sales Journal	Amount (LCY)
12	254	Purchase Journal	Amount (LCY)
13	255	Cash Receipt Journal	Amount (LCY)
14	256	Payment Journal	Amount (LCY)
15	283	Recurring General Journal	Amount (LCY)
16	372	Bank Account Ledger Entries	Amount (LCY)
17	573	Detailed Cust. Ledg. Entries	Amount (LCY)
18	574	Detailed Vendor Ledg. Entries	Amount (LCY)
19	623	Unapply Customer Entries	Amount (LCY)
20	624	Unapply Vendor Entries	Amount (LCY)
21	625	Unapply Employee Entries	Amount (LCY)
22	654	Requests to Approve	Amount (LCY)
23	658	Approval Entries	Amount (LCY)
24	659	Posted Approval Entries	Amount (LCY)
25	662	Approval Request Entries	Amount (LCY)
26	841	Cash Flow Worksheet	Amount (LCY)
27	850	Cash Flow Forecast Entries	Amount (LCY)
28	863	CF Entries Dim. Matrix	Amount (LCY)
29	1020	Job G/L Journal	Amount (LCY)
30	1439	Headline Details	Amount (LCY)
31	1439	Headline Details	Amount (LCY)
32	5237	Employee Ledger Entries	Amount (LCY)
33	5238	Detailed Empl. Ledger Entries	Amount (LCY)
34	5240	Detailed Empl. Entries Preview	Amount (LCY)
35	5912	Service Ledger Entries	Amount (LCY)

Dynamics 365 BC Table ReferencePage Control Search