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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to INV. DISCOUNT AMOUNT

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Inv. Discount Amount
2	47	Sales Invoice Subform	Inv. Discount Amount
3	54	Purchase Order Subform	Inv. Discount Amount
4	55	Purch. Invoice Subform	Inv. Discount Amount
5	95	Sales Quote Subform	Inv. Discount Amount
6	96	Sales Cr. Memo Subform	Inv. Discount Amount
7	98	Purch. Cr. Memo Subform	Inv. Discount Amount
8	526	Posted Sales Invoice Lines	Inv. Discount Amount
9	527	Posted Sales Credit Memo Lines	Inv. Discount Amount
10	529	Posted Purchase Invoice Lines	Inv. Discount Amount
11	530	Posted Purchase Cr. Memo Lines	Inv. Discount Amount
12	5160	Sales Order Archive Subform	Inv. Discount Amount
13	5168	Purchase Order Archive Subform	Inv. Discount Amount
14	5852	Get Post.Doc – S.InvLn Subform	Inv. Discount Amount
15	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Inv. Discount Amount
16	5857	Get Post.Doc – P.InvLn Subform	Inv. Discount Amount
17	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Inv. Discount Amount
18	5905	Service Lines	Inv. Discount Amount
19	5934	Service Invoice Subform	Inv. Discount Amount
20	5936	Service Credit Memo Subform	Inv. Discount Amount
21	5951	Posted Service Invoice Lines	Inv. Discount Amount
22	5966	Service Quote Lines	Inv. Discount Amount
23	6036	Service Lines Subform	Inv. Discount Amount
24	6038	Service Invoice Lines Subform	Inv. Discount Amount
25	6039	Service Cr. Memo Lines Subform	Inv. Discount Amount
26	6621	Blanket Sales Order Arch. Sub.	Inv. Discount Amount
27	6624	Blanket Purch. Order Arch.Sub.	Inv. Discount Amount
28	6628	Sales Return Order Arc Subform	Inv. Discount Amount
29	6631	Sales Return Order Subform	Inv. Discount Amount
30	6641	Purchase Return Order Subform	Inv. Discount Amount
31	6645	Purch Return Order Arc Subform	Inv. Discount Amount

Dynamics 365 BC Table ReferencePage Control Search