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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to MATRIX_CAPTIONRANGE

Seq No	Page Number	Page Name	Control Name
1	491	Items by Location	MATRIX_CaptionRange
2	563	G/L Entries Dimension Overview	MATRIX_CaptionRange
3	860	CF Entries Dim. Overview	MATRIX_CaptionRange
4	5131	Opportunities	MATRIX_CaptionRange
5	5226	Empl. Absences by Categories	MATRIX_CaptionRange
6	5228	Misc. Articles Overview	MATRIX_CaptionRange
7	5229	Confidential Info. Overview	MATRIX_CaptionRange
8	5230	Qualification Overview	MATRIX_CaptionRange
9	5231	Absence Overview by Categories	MATRIX_CaptionRange
10	5622	Total Value Insured per FA	MATRIX_CaptionRange
11	5662	FA Posting Types Overview	MATRIX_CaptionRange
12	5747	Transfer Routes	MATRIX_CaptionRange
13	5827	Item Statistics	MATRIX_CaptionRange
14	6066	Contract Gain/Loss (Groups)	MATRIX_CaptionRange
15	6067	Contract Gain/Loss (Customers)	MATRIX_CaptionRange
16	6068	Contract Gain/Loss (Reasons)	MATRIX_CaptionRange
17	6069	Contract Gain/Loss (Resp.Ctr)	MATRIX_CaptionRange
18	6071	Contract Gain/Loss (Contracts)	MATRIX_CaptionRange
19	7159	Invt. Analysis by Dimensions	MATRIX_CaptionRange
20	99000769	Work Center Calendar	MATRIX_CaptionRange
21	99000770	Machine Center Calendar	MATRIX_CaptionRange
22	99000771	Work Ctr. Group Calendar	MATRIX_CaptionRange
23	99000812	Prod. BOM Matrix per Version	MATRIX_CaptionRange

Dynamics 365 BC Table ReferencePage Control Search