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 = 'Applies-to Doc. Type' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to APPLIES-TO DOC. TYPE

Seq No	Page Number	Page Name	Control Name
1	39	General Journal	Applies-to Doc. Type
2	44	Sales Credit Memo	Applies-to Doc. Type
3	52	Purchase Credit Memo	Applies-to Doc. Type
4	134	Posted Sales Credit Memo	Applies-to Doc. Type
5	140	Posted Purchase Credit Memo	Applies-to Doc. Type
6	144	Posted Sales Credit Memos	Applies-to Doc. Type
7	147	Posted Purchase Credit Memos	Applies-to Doc. Type
8	253	Sales Journal	Applies-to Doc. Type
9	254	Purchase Journal	Applies-to Doc. Type
10	255	Cash Receipt Journal	Applies-to Doc. Type
11	256	Payment Journal	Applies-to Doc. Type
12	283	Recurring General Journal	Applies-to Doc. Type
13	610	IC General Journal	Applies-to Doc. Type
14	752	Standard Gen. Journal Subform	Applies-to Doc. Type
15	1020	Job G/L Journal	Applies-to Doc. Type
16	1693	Bank Deposit Subform	Applies-to Doc. Type
17	5628	Fixed Asset G/L Journal	Applies-to Doc. Type
18	5805	Item Charge Assignment (Purch)	Applies-to Doc. Type
19	5805	Item Charge Assignment (Purch)	Applies-to Doc. Type
20	5814	Item Charge Assignment (Sales)	Applies-to Doc. Type
21	5814	Item Charge Assignment (Sales)	Applies-to Doc. Type
22	5935	Service Credit Memo	Applies-to Doc. Type
23	6627	Sales Return Order Archive	Applies-to Doc. Type
24	6630	Sales Return Order	Applies-to Doc. Type
25	6640	Purchase Return Order	Applies-to Doc. Type
26	6644	Purchase Return Order Archive	Applies-to Doc. Type
27	6650	Posted Return Shipment	Applies-to Doc. Type
28	6652	Posted Return Shipments	Applies-to Doc. Type
29	9302	Sales Credit Memos	Applies-to Doc. Type
30	9304	Sales Return Order List	Applies-to Doc. Type
31	9309	Purchase Credit Memos	Applies-to Doc. Type
32	9311	Purchase Return Order List	Applies-to Doc. Type
33	9320	Service Credit Memos	Applies-to Doc. Type

Dynamics 365 BC Table ReferencePage Control Search