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 = 'Cash Flow Payment Terms Code' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CASH FLOW PAYMENT TERMS CODE

Seq No	Page Number	Page Name	Control Name
1	21	Customer Card	Cash Flow Payment Terms Code
2	26	Vendor Card	Cash Flow Payment Terms Code
3	1382	Customer Templ. Card	Cash Flow Payment Terms Code
4	1386	Vendor Templ. Card	Cash Flow Payment Terms Code

Dynamics 365 BC Table ReferencePage Control Search