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 = 'Bill-to Customer No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to BILL-TO CUSTOMER NO.

Seq No	Page Number	Page Name	Control Name
1	21	Customer Card	Bill-to Customer No.
2	45	Sales List	Bill-to Customer No.
3	88	Job Card	Bill-to Customer No.
4	89	Job List	Bill-to Customer No.
5	130	Posted Sales Shipment	Bill-to Customer No.
6	142	Posted Sales Shipments	Bill-to Customer No.
7	143	Posted Sales Invoices	Bill-to Customer No.
8	144	Posted Sales Credit Memos	Bill-to Customer No.
9	163	Warranty Ledg. Entries Preview	Bill-to Customer No.
10	168	Service Ledger Entries Preview	Bill-to Customer No.
11	636	IC Outbox Sales Doc.	Bill-to Customer No.
12	640	Handled IC Outbox Sales Doc.	Bill-to Customer No.
13	644	IC Inbox Sales Doc.	Bill-to Customer No.
14	648	Handled IC Inbox Sales Doc.	Bill-to Customer No.
15	1382	Customer Templ. Card	Bill-to Customer No.
16	5159	Sales Order Archive	Bill-to Customer No.
17	5162	Sales Quote Archive	Bill-to Customer No.
18	5708	Get Shipment Lines	Bill-to Customer No.
19	5824	Sales Shipment Lines	Bill-to Customer No.
20	5851	Get Post.Doc – S.ShptLn Sbfrm	Bill-to Customer No.
21	5852	Get Post.Doc – S.InvLn Subform	Bill-to Customer No.
22	5853	Get Pst.Doc-RtrnRcptLn Subform	Bill-to Customer No.
23	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Bill-to Customer No.
24	5900	Service Order	Bill-to Customer No.
25	5912	Service Ledger Entries	Bill-to Customer No.
26	5913	Warranty Ledger Entries	Bill-to Customer No.
27	5933	Service Invoice	Bill-to Customer No.
28	5935	Service Credit Memo	Bill-to Customer No.
29	5964	Service Quote	Bill-to Customer No.
30	5971	Posted Service Credit Memos	Bill-to Customer No.
31	5972	Posted Service Credit Memo	Bill-to Customer No.
32	5974	Posted Service Shipments	Bill-to Customer No.
33	5975	Posted Service Shipment	Bill-to Customer No.
34	5977	Posted Service Invoices	Bill-to Customer No.
35	5978	Posted Service Invoice	Bill-to Customer No.
36	5994	Get Service Shipment Lines	Bill-to Customer No.
37	6036	Service Lines Subform	Bill-to Customer No.
38	6037	Service Shipment Lines Subform	Bill-to Customer No.
39	6038	Service Invoice Lines Subform	Bill-to Customer No.
40	6039	Service Cr. Memo Lines Subform	Bill-to Customer No.
41	6050	Service Contract	Bill-to Customer No.
42	6053	Service Contract Quote	Bill-to Customer No.
43	6072	Filed Service Contract	Bill-to Customer No.
44	6620	Blanket Sales Order Archive	Bill-to Customer No.
45	6629	Sales Return List Archive	Bill-to Customer No.
46	6638	Get Return Receipt Lines	Bill-to Customer No.
47	6660	Posted Return Receipt	Bill-to Customer No.
48	6662	Posted Return Receipts	Bill-to Customer No.
49	6667	Return Receipt Lines	Bill-to Customer No.
50	9300	Sales Quotes	Bill-to Customer No.
51	9301	Sales Invoice List	Bill-to Customer No.
52	9302	Sales Credit Memos	Bill-to Customer No.
53	9303	Blanket Sales Orders	Bill-to Customer No.
54	9304	Sales Return Order List	Bill-to Customer No.
55	9305	Sales Order List	Bill-to Customer No.
56	30145	Shpfy Refund	Bill-to Customer No.
57	30147	Shpfy Refunds	Bill-to Customer No.
58	30150	Shpfy Returns	Bill-to Customer No.
59	30151	Shpfy Return	Bill-to Customer No.

Dynamics 365 BC Table ReferencePage Control Search