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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to TOTAL COST (LCY)

Seq No	Page Number	Page Name	Control Name
1	92	Job Ledger Entries	Total Cost (LCY)
2	93	Job Ledger Entries Preview	Total Cost (LCY)
3	201	Job Journal	Total Cost (LCY)
4	289	Recurring Job Jnl.	Total Cost (LCY)
5	1007	Job Planning Lines	Total Cost (LCY)

Dynamics 365 BC Table ReferencePage Control Search