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 = 'Units per Parcel' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to UNITS PER PARCEL

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Units per Parcel
2	47	Sales Invoice Subform	Units per Parcel
3	54	Purchase Order Subform	Units per Parcel
4	55	Purch. Invoice Subform	Units per Parcel
5	95	Sales Quote Subform	Units per Parcel
6	96	Sales Cr. Memo Subform	Units per Parcel
7	97	Purchase Quote Subform	Units per Parcel
8	98	Purch. Cr. Memo Subform	Units per Parcel
9	131	Posted Sales Shpt. Subform	Units per Parcel
10	133	Posted Sales Invoice Subform	Units per Parcel
11	135	Posted Sales Cr. Memo Subform	Units per Parcel
12	137	Posted Purchase Rcpt. Subform	Units per Parcel
13	139	Posted Purch. Invoice Subform	Units per Parcel
14	141	Posted Purch. Cr. Memo Subform	Units per Parcel
15	508	Blanket Sales Order Subform	Units per Parcel
16	510	Blanket Purchase Order Subform	Units per Parcel
17	5160	Sales Order Archive Subform	Units per Parcel
18	5163	Sales Quote Archive Subform	Units per Parcel
19	5165	Purchase Quote Archive Subform	Units per Parcel
20	5168	Purchase Order Archive Subform	Units per Parcel
21	6621	Blanket Sales Order Arch. Sub.	Units per Parcel
22	6624	Blanket Purch. Order Arch.Sub.	Units per Parcel
23	6628	Sales Return Order Arc Subform	Units per Parcel
24	6631	Sales Return Order Subform	Units per Parcel
25	6641	Purchase Return Order Subform	Units per Parcel
26	6645	Purch Return Order Arc Subform	Units per Parcel
27	6651	Posted Return Shipment Subform	Units per Parcel
28	6661	Posted Return Receipt Subform	Units per Parcel

Dynamics 365 BC Table ReferencePage Control Search