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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to SERVICE ITEM NO.

Seq No	Page Number	Page Name	Control Name
1	5903	Service Item Lines	Service Item No.
2	5904	Service Line List	Service Item No.
3	5905	Service Lines	Service Item No.
4	5906	Service Item Worksheet	Service Item No.
5	5915	Service Tasks	Service Item No.
6	5924	Loaner Entries	Service Item No.
7	5934	Service Invoice Subform	Service Item No.
8	5936	Service Credit Memo Subform	Service Item No.
9	5950	Posted Shpt. Item Line List	Service Item No.
10	5965	Service Quote Subform	Service Item No.
11	5966	Service Quote Lines	Service Item No.
12	5970	Posted Service Shipment Lines	Service Item No.
13	5976	Posted Service Shpt. Subform	Service Item No.
14	5979	Posted Service Invoice Subform	Service Item No.
15	5989	Service Item Log	Service Item No.
16	5989	Service Item Log	Service Item No.
17	6001	Service Order Allocations	Service Item No.
18	6003	Cancelled Allocation Entries	Service Item No.
19	6005	Resource Allocations	Service Item No.
20	6036	Service Lines Subform	Service Item No.
21	6038	Service Invoice Lines Subform	Service Item No.
22	6039	Service Cr. Memo Lines Subform	Service Item No.
23	6052	Service Contract Subform	Service Item No.
24	6054	Service Contract Quote Subform	Service Item No.
25	6063	Contract Change Log	Service Item No.
26	6063	Contract Change Log	Service Item No.
27	6074	Filed Service Contract Subform	Service Item No.
28	6075	Serv. Contr. List (Serv. Item)	Service Item No.
29	6076	Serv. Item List (Contract)	Service Item No.
30	6078	Service Contract Line List	Service Item No.
31	6084	Service Line Price Adjmt.	Service Item No.
32	6084	Service Line Price Adjmt.	Service Item No.
33	6086	Filed Service Contract Lines	Service Item No.
34	9088	Service Item Line FactBox	Service Item No.

Dynamics 365 BC Table ReferencePage Control Search