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 = 'Closed by Entry No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CLOSED BY ENTRY NO.

Seq No	Page Number	Page Name	Control Name
1	123	VAT Entries Preview	Closed by Entry No.
2	315	VAT Entries	Closed by Entry No.
3	1572	VAT Entries Preview Subform	Closed by Entry No.
4	1575	VAT Entries Preview Flat Subf.	Closed by Entry No.

Dynamics 365 BC Table ReferencePage Control Search