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 = 'Blanket Order Line No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BLANKET ORDER LINE NO.

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Blanket Order Line No.
2	47	Sales Invoice Subform	Blanket Order Line No.
3	54	Purchase Order Subform	Blanket Order Line No.
4	55	Purch. Invoice Subform	Blanket Order Line No.
5	95	Sales Quote Subform	Blanket Order Line No.
6	96	Sales Cr. Memo Subform	Blanket Order Line No.
7	97	Purchase Quote Subform	Blanket Order Line No.
8	98	Purch. Cr. Memo Subform	Blanket Order Line No.
9	5160	Sales Order Archive Subform	Blanket Order Line No.
10	5163	Sales Quote Archive Subform	Blanket Order Line No.
11	5165	Purchase Quote Archive Subform	Blanket Order Line No.
12	5168	Purchase Order Archive Subform	Blanket Order Line No.
13	5851	Get Post.Doc – S.ShptLn Sbfrm	Blanket Order Line No.
14	5852	Get Post.Doc – S.InvLn Subform	Blanket Order Line No.
15	5853	Get Pst.Doc-RtrnRcptLn Subform	Blanket Order Line No.
16	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Blanket Order Line No.
17	5856	Get Post.Doc – P.RcptLn Sbfrm	Blanket Order Line No.
18	5857	Get Post.Doc – P.InvLn Subform	Blanket Order Line No.
19	5858	Get Pst.Doc-RtrnShptLn Subform	Blanket Order Line No.
20	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Blanket Order Line No.
21	6621	Blanket Sales Order Arch. Sub.	Blanket Order Line No.
22	6624	Blanket Purch. Order Arch.Sub.	Blanket Order Line No.
23	6628	Sales Return Order Arc Subform	Blanket Order Line No.
24	6631	Sales Return Order Subform	Blanket Order Line No.
25	6641	Purchase Return Order Subform	Blanket Order Line No.
26	6645	Purch Return Order Arc Subform	Blanket Order Line No.

Dynamics 365 BC Table ReferencePage Control Search