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 = 'Prepayment {76828f4aca4e5c9d96357ff31387f4669f9712cdf129acc7c319a1857b1e1267}' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PREPAYMENT %

Seq No	Page Number	Page Name	Control Name
1	21	Customer Card	Prepayment %
2	26	Vendor Card	Prepayment %
3	42	Sales Order	Prepayment %
4	46	Sales Order Subform	Prepayment %
5	50	Purchase Order	Prepayment %
6	54	Purchase Order Subform	Prepayment %
7	664	Sales Prepayment Percentages	Prepayment %
8	665	Purchase Prepmt. Percentages	Prepayment %
9	1382	Customer Templ. Card	Prepayment %
10	1386	Vendor Templ. Card	Prepayment %

Dynamics 365 BC Table ReferencePage Control Search