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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to LINE DISCOUNT AMOUNT

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Line Discount Amount
2	47	Sales Invoice Subform	Line Discount Amount
3	54	Purchase Order Subform	Line Discount Amount
4	55	Purch. Invoice Subform	Line Discount Amount
5	92	Job Ledger Entries	Line Discount Amount
6	93	Job Ledger Entries Preview	Line Discount Amount
7	95	Sales Quote Subform	Line Discount Amount
8	96	Sales Cr. Memo Subform	Line Discount Amount
9	97	Purchase Quote Subform	Line Discount Amount
10	98	Purch. Cr. Memo Subform	Line Discount Amount
11	133	Posted Sales Invoice Subform	Line Discount Amount
12	135	Posted Sales Cr. Memo Subform	Line Discount Amount
13	139	Posted Purch. Invoice Subform	Line Discount Amount
14	141	Posted Purch. Cr. Memo Subform	Line Discount Amount
15	201	Job Journal	Line Discount Amount
16	289	Recurring Job Jnl.	Line Discount Amount
17	508	Blanket Sales Order Subform	Line Discount Amount
18	510	Blanket Purchase Order Subform	Line Discount Amount
19	526	Posted Sales Invoice Lines	Line Discount Amount
20	527	Posted Sales Credit Memo Lines	Line Discount Amount
21	529	Posted Purchase Invoice Lines	Line Discount Amount
22	530	Posted Purchase Cr. Memo Lines	Line Discount Amount
23	637	IC Outbox Sales Lines	Line Discount Amount
24	639	IC Outbox Purchase Lines	Line Discount Amount
25	641	Handled IC Outbox Sales Lines	Line Discount Amount
26	643	Handled IC Outbox Purch. Lines	Line Discount Amount
27	645	IC Inbox Sales Lines	Line Discount Amount
28	647	IC Inbox Purchase Lines	Line Discount Amount
29	649	Handled IC Inbox Sales Lines	Line Discount Amount
30	651	Handled IC Inbox Purch. Lines	Line Discount Amount
31	1007	Job Planning Lines	Line Discount Amount
32	2114	O365 Posted Sales Inv. Lines	Line Discount Amount
33	2157	O365 Sales Invoice Line Card	Line Discount Amount
34	5160	Sales Order Archive Subform	Line Discount Amount
35	5163	Sales Quote Archive Subform	Line Discount Amount
36	5165	Purchase Quote Archive Subform	Line Discount Amount
37	5168	Purchase Order Archive Subform	Line Discount Amount
38	5852	Get Post.Doc – S.InvLn Subform	Line Discount Amount
39	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Line Discount Amount
40	5857	Get Post.Doc – P.InvLn Subform	Line Discount Amount
41	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Line Discount Amount
42	5904	Service Line List	Line Discount Amount
43	5905	Service Lines	Line Discount Amount
44	5907	Service Item Worksheet Subform	Line Discount Amount
45	5934	Service Invoice Subform	Line Discount Amount
46	5936	Service Credit Memo Subform	Line Discount Amount
47	5951	Posted Service Invoice Lines	Line Discount Amount
48	5952	Posted Service Cr. Memo Lines	Line Discount Amount
49	5966	Service Quote Lines	Line Discount Amount
50	5973	Posted Serv. Cr. Memo Subform	Line Discount Amount
51	5979	Posted Service Invoice Subform	Line Discount Amount
52	6036	Service Lines Subform	Line Discount Amount
53	6038	Service Invoice Lines Subform	Line Discount Amount
54	6039	Service Cr. Memo Lines Subform	Line Discount Amount
55	6052	Service Contract Subform	Line Discount Amount
56	6054	Service Contract Quote Subform	Line Discount Amount
57	6074	Filed Service Contract Subform	Line Discount Amount
58	6075	Serv. Contr. List (Serv. Item)	Line Discount Amount
59	6086	Filed Service Contract Lines	Line Discount Amount
60	6621	Blanket Sales Order Arch. Sub.	Line Discount Amount
61	6624	Blanket Purch. Order Arch.Sub.	Line Discount Amount
62	6628	Sales Return Order Arc Subform	Line Discount Amount
63	6631	Sales Return Order Subform	Line Discount Amount
64	6641	Purchase Return Order Subform	Line Discount Amount
65	6645	Purch Return Order Arc Subform	Line Discount Amount

Dynamics 365 BC Table ReferencePage Control Search