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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DIRECT UNIT COST (LCY)

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

Dynamics 365 BC Table ReferencePage Control Search