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 = 'Job Line Discount {f72fa0f1322670fc01a34cb9ef1082ac82598d190ad54e9cbcd428866d41998a}' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to JOB LINE DISCOUNT %

Seq No	Page Number	Page Name	Control Name
1	54	Purchase Order Subform	Job Line Discount %
2	55	Purch. Invoice Subform	Job Line Discount %
3	97	Purchase Quote Subform	Job Line Discount %
4	98	Purch. Cr. Memo Subform	Job Line Discount %
5	1020	Job G/L Journal	Job Line Discount %
6	5165	Purchase Quote Archive Subform	Job Line Discount %
7	5168	Purchase Order Archive Subform	Job Line Discount %

Dynamics 365 BC Table ReferencePage Control Search