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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BUDGETEDAMOUNT

Seq No	Page Number	Page Name	Control Name
1	350	G/L Acc. Balance/Budget Lines	BudgetedAmount
2	570	Chart of Accounts (G/L)	BudgetedAmount
3	6408	Workflow – Customer Entity	budgetedAmount
4	6409	Workflow – Item Entity	budgetedAmount
5	6410	Workflow – Vendor Entity	budgetedAmount

Dynamics 365 BC Table ReferencePage Control Search