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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to RETURN REASON CODE

Seq No	Page Number	Page Name	Control Name
1	38	Item Ledger Entries	Return Reason Code
2	46	Sales Order Subform	Return Reason Code
3	47	Sales Invoice Subform	Return Reason Code
4	54	Purchase Order Subform	Return Reason Code
5	55	Purch. Invoice Subform	Return Reason Code
6	96	Sales Cr. Memo Subform	Return Reason Code
7	98	Purch. Cr. Memo Subform	Return Reason Code
8	131	Posted Sales Shpt. Subform	Return Reason Code
9	133	Posted Sales Invoice Subform	Return Reason Code
10	135	Posted Sales Cr. Memo Subform	Return Reason Code
11	137	Posted Purchase Rcpt. Subform	Return Reason Code
12	139	Posted Purch. Invoice Subform	Return Reason Code
13	141	Posted Purch. Cr. Memo Subform	Return Reason Code
14	167	Item Ledger Entries Preview	Return Reason Code
15	5160	Sales Order Archive Subform	Return Reason Code
16	5168	Purchase Order Archive Subform	Return Reason Code
17	5802	Value Entries	Return Reason Code
18	5807	Value Entries Preview	Return Reason Code
19	5851	Get Post.Doc – S.ShptLn Sbfrm	Return Reason Code
20	5852	Get Post.Doc – S.InvLn Subform	Return Reason Code
21	5853	Get Pst.Doc-RtrnRcptLn Subform	Return Reason Code
22	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Return Reason Code
23	5856	Get Post.Doc – P.RcptLn Sbfrm	Return Reason Code
24	5857	Get Post.Doc – P.InvLn Subform	Return Reason Code
25	5858	Get Pst.Doc-RtrnShptLn Subform	Return Reason Code
26	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Return Reason Code
27	5934	Service Invoice Subform	Return Reason Code
28	5936	Service Credit Memo Subform	Return Reason Code
29	5973	Posted Serv. Cr. Memo Subform	Return Reason Code
30	5979	Posted Service Invoice Subform	Return Reason Code
31	6036	Service Lines Subform	Return Reason Code
32	6037	Service Shipment Lines Subform	Return Reason Code
33	6038	Service Invoice Lines Subform	Return Reason Code
34	6039	Service Cr. Memo Lines Subform	Return Reason Code
35	6621	Blanket Sales Order Arch. Sub.	Return Reason Code
36	6624	Blanket Purch. Order Arch.Sub.	Return Reason Code
37	6628	Sales Return Order Arc Subform	Return Reason Code
38	6631	Sales Return Order Subform	Return Reason Code
39	6633	Sales Return Orders	Return Reason Code
40	6638	Get Return Receipt Lines	Return Reason Code
41	6641	Purchase Return Order Subform	Return Reason Code
42	6645	Purch Return Order Arc Subform	Return Reason Code
43	6648	Get Return Shipment Lines	Return Reason Code
44	6651	Posted Return Shipment Subform	Return Reason Code
45	6661	Posted Return Receipt Subform	Return Reason Code

Dynamics 365 BC Table ReferencePage Control Search