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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to PAYMENT TERMS CODE

Seq No	Page Number	Page Name	Control Name
1	21	Customer Card	Payment Terms Code
2	22	Customer List	Payment Terms Code
3	26	Vendor Card	Payment Terms Code
4	27	Vendor List	Payment Terms Code
5	33	Customer Lookup	Payment Terms Code
6	34	Vendor Lookup	Payment Terms Code
7	39	General Journal	Payment Terms Code
8	41	Sales Quote	Payment Terms Code
9	42	Sales Order	Payment Terms Code
10	43	Sales Invoice	Payment Terms Code
11	44	Sales Credit Memo	Payment Terms Code
12	49	Purchase Quote	Payment Terms Code
13	50	Purchase Order	Payment Terms Code
14	51	Purchase Invoice	Payment Terms Code
15	52	Purchase Credit Memo	Payment Terms Code
16	88	Job Card	Payment Terms Code
17	132	Posted Sales Invoice	Payment Terms Code
18	138	Posted Purchase Invoice	Payment Terms Code
19	143	Posted Sales Invoices	Payment Terms Code
20	146	Posted Purchase Invoices	Payment Terms Code
21	173	Standard Customer Sales Codes	Payment Terms Code
22	253	Sales Journal	Payment Terms Code
23	254	Purchase Journal	Payment Terms Code
24	283	Recurring General Journal	Payment Terms Code
25	507	Blanket Sales Order	Payment Terms Code
26	509	Blanket Purchase Order	Payment Terms Code
27	610	IC General Journal	Payment Terms Code
28	752	Standard Gen. Journal Subform	Payment Terms Code
29	1020	Job G/L Journal	Payment Terms Code
30	1382	Customer Templ. Card	Payment Terms Code
31	1386	Vendor Templ. Card	Payment Terms Code
32	2310	BC O365 Sales Invoice	Payment Terms Code
33	2313	BC O365 Posted Sales Invoice	Payment Terms Code
34	5159	Sales Order Archive	Payment Terms Code
35	5162	Sales Quote Archive	Payment Terms Code
36	5164	Purchase Quote Archive	Payment Terms Code
37	5167	Purchase Order Archive	Payment Terms Code
38	5628	Fixed Asset G/L Journal	Payment Terms Code
39	5900	Service Order	Payment Terms Code
40	5933	Service Invoice	Payment Terms Code
41	5935	Service Credit Memo	Payment Terms Code
42	5964	Service Quote	Payment Terms Code
43	6050	Service Contract	Payment Terms Code
44	6053	Service Contract Quote	Payment Terms Code
45	6072	Filed Service Contract	Payment Terms Code
46	6620	Blanket Sales Order Archive	Payment Terms Code
47	6623	Blanket Purchase Order Archive	Payment Terms Code
48	6630	Sales Return Order	Payment Terms Code
49	6640	Purchase Return Order	Payment Terms Code
50	9084	Customer Details FactBox	Payment Terms Code
51	9301	Sales Invoice List	Payment Terms Code
52	9302	Sales Credit Memos	Payment Terms Code
53	9304	Sales Return Order List	Payment Terms Code
54	9305	Sales Order List	Payment Terms Code
55	9307	Purchase Order List	Payment Terms Code
56	9308	Purchase Invoices	Payment Terms Code
57	9309	Purchase Credit Memos	Payment Terms Code
58	9311	Purchase Return Order List	Payment Terms Code
59	9317	Service Quotes	Payment Terms Code
60	9318	Service Orders	Payment Terms Code
61	9319	Service Invoices	Payment Terms Code
62	9320	Service Credit Memos	Payment Terms Code
63	9321	Service Contracts	Payment Terms Code
64	9346	Purchase Quote Archives	Payment Terms Code
65	9347	Purchase Order Archives	Payment Terms Code
66	9348	Sales Quote Archives	Payment Terms Code
67	9349	Sales Order Archives	Payment Terms Code

Dynamics 365 BC Table ReferencePage Control Search