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 = 'Payment Discount {7ca59fd2b7c1ceac724619fc566e3d39d85d1766d66963f3ecc3ae50d1d7df19}' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PAYMENT DISCOUNT %

Seq No	Page Number	Page Name	Control Name
1	41	Sales Quote	Payment Discount %
2	42	Sales Order	Payment Discount %
3	43	Sales Invoice	Payment Discount %
4	44	Sales Credit Memo	Payment Discount %
5	49	Purchase Quote	Payment Discount %
6	50	Purchase Order	Payment Discount %
7	51	Purchase Invoice	Payment Discount %
8	52	Purchase Credit Memo	Payment Discount %
9	132	Posted Sales Invoice	Payment Discount %
10	138	Posted Purchase Invoice	Payment Discount %
11	143	Posted Sales Invoices	Payment Discount %
12	146	Posted Purchase Invoices	Payment Discount %
13	253	Sales Journal	Payment Discount %
14	254	Purchase Journal	Payment Discount %
15	507	Blanket Sales Order	Payment Discount %
16	509	Blanket Purchase Order	Payment Discount %
17	612	IC Outbox Jnl. Lines	Payment Discount %
18	614	Handled IC Outbox Jnl. Lines	Payment Discount %
19	616	IC Inbox Jnl. Lines	Payment Discount %
20	618	Handled IC Inbox Jnl. Lines	Payment Discount %
21	636	IC Outbox Sales Doc.	Payment Discount %
22	638	IC Outbox Purchase Doc.	Payment Discount %
23	640	Handled IC Outbox Sales Doc.	Payment Discount %
24	642	Handled IC Outbox Purch. Doc.	Payment Discount %
25	644	IC Inbox Sales Doc.	Payment Discount %
26	646	IC Inbox Purchase Doc.	Payment Discount %
27	648	Handled IC Inbox Sales Doc.	Payment Discount %
28	650	Handled IC Inbox Purch. Doc.	Payment Discount %
29	5159	Sales Order Archive	Payment Discount %
30	5162	Sales Quote Archive	Payment Discount %
31	5164	Purchase Quote Archive	Payment Discount %
32	5167	Purchase Order Archive	Payment Discount %
33	5900	Service Order	Payment Discount %
34	5933	Service Invoice	Payment Discount %
35	5935	Service Credit Memo	Payment Discount %
36	5964	Service Quote	Payment Discount %
37	6620	Blanket Sales Order Archive	Payment Discount %
38	6623	Blanket Purchase Order Archive	Payment Discount %
39	9301	Sales Invoice List	Payment Discount %
40	9304	Sales Return Order List	Payment Discount %
41	9305	Sales Order List	Payment Discount %
42	9307	Purchase Order List	Payment Discount %
43	9308	Purchase Invoices	Payment Discount %
44	9309	Purchase Credit Memos	Payment Discount %
45	9311	Purchase Return Order List	Payment Discount %
46	9317	Service Quotes	Payment Discount %
47	9318	Service Orders	Payment Discount %
48	9319	Service Invoices	Payment Discount %
49	9346	Purchase Quote Archives	Payment Discount %
50	9347	Purchase Order Archives	Payment Discount %
51	9348	Sales Quote Archives	Payment Discount %
52	9349	Sales Order Archives	Payment Discount %

Dynamics 365 BC Table ReferencePage Control Search