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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to WIP POSTING DATE

Seq No	Page Number	Page Name	Control Name
1	88	Job Card	WIP Posting Date
2	1008	Job WIP Entries	WIP Posting Date
3	1009	Job WIP G/L Entries	WIP Posting Date
4	1027	Job WIP Cockpit	WIP Posting Date
5	1028	Job WIP Totals	WIP Posting Date
6	9099	Job WIP/Recognition FactBox	WIP Posting Date

Dynamics 365 BC Table ReferencePage Control Search