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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to IN-TRANSIT CODE

Seq No	Page Number	Page Name	Control Name
1	5740	Transfer Order	In-Transit Code
2	5742	Transfer Orders	In-Transit Code
3	5743	Posted Transfer Shipment	In-Transit Code
4	5745	Posted Transfer Receipt	In-Transit Code
5	5748	Transfer Route Specification	In-Transit Code

Dynamics 365 BC Table ReferencePage Control Search