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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to CURRENCY CODE

Seq No	Page Number	Page Name	Control Name
1	21	Customer Card	Currency Code
2	22	Customer List	Currency Code
3	23	Cust. Invoice Discounts	Currency Code
4	25	Customer Ledger Entries	Currency Code
5	26	Vendor Card	Currency Code
6	27	Vendor List	Currency Code
7	28	Vend. Invoice Discounts	Currency Code
8	29	Vendor Ledger Entries	Currency Code
9	33	Customer Lookup	Currency Code
10	34	Vendor Lookup	Currency Code
11	39	General Journal	Currency Code
12	41	Sales Quote	Currency Code
13	42	Sales Order	Currency Code
14	43	Sales Invoice	Currency Code
15	44	Sales Credit Memo	Currency Code
16	45	Sales List	Currency Code
17	48	Sales Orders	Currency Code
18	49	Purchase Quote	Currency Code
19	50	Purchase Order	Currency Code
20	51	Purchase Invoice	Currency Code
21	52	Purchase Credit Memo	Currency Code
22	53	Purchase List	Currency Code
23	56	Purchase Orders	Currency Code
24	61	Applied Customer Entries	Currency Code
25	62	Applied Vendor Entries	Currency Code
26	63	Applied Employee Entries	Currency Code
27	88	Job Card	Currency Code
28	106	Exchange Rate Adjmt. Register	Currency Code
29	126	Cust. Ledg. Entries Preview	Currency Code
30	127	Det. Cust. Ledg. Entr. Preview	Currency Code
31	128	Vend. Ledg. Entries Preview	Currency Code
32	129	Detailed Vend. Entries Preview	Currency Code
33	132	Posted Sales Invoice	Currency Code
34	134	Posted Sales Credit Memo	Currency Code
35	138	Posted Purchase Invoice	Currency Code
36	140	Posted Purchase Credit Memo	Currency Code
37	142	Posted Sales Shipments	Currency Code
38	143	Posted Sales Invoices	Currency Code
39	144	Posted Sales Credit Memos	Currency Code
40	146	Posted Purchase Invoices	Currency Code
41	147	Posted Purchase Credit Memos	Currency Code
42	165	Bank Acc. Ledg. Entr. Preview	Currency Code
43	170	Standard Sales Code Card	Currency Code
44	172	Standard Sales Codes	Currency Code
45	175	Standard Purchase Code Card	Currency Code
46	177	Standard Purchase Codes	Currency Code
47	179	Reverse Entries	Currency Code
48	182	Posted General Journal	Currency Code
49	183	Reverse Transaction Entries	Currency Code
50	186	Exch.Rate Adjmt. Ledg.Entries	Currency Code
51	189	Incoming Document	Currency Code
52	189	Incoming Document	Currency Code
53	190	Incoming Documents	Currency Code
54	201	Job Journal	Currency Code
55	204	Resource Prices	Currency Code
56	232	Apply Customer Entries	Currency Code
57	233	Apply Vendor Entries	Currency Code
58	234	Apply Employee Entries	Currency Code
59	240	Business Unit List	Currency Code
60	241	Business Unit Card	Currency Code
61	253	Sales Journal	Currency Code
62	254	Purchase Journal	Currency Code
63	255	Cash Receipt Journal	Currency Code
64	256	Payment Journal	Currency Code
65	283	Recurring General Journal	Currency Code
66	291	Req. Worksheet	Currency Code
67	296	Recurring Req. Worksheet	Currency Code
68	370	Bank Account Card	Currency Code
69	371	Bank Account List	Currency Code
70	372	Bank Account Ledger Entries	Currency Code
71	375	Bank Account Statistics	Currency Code
72	423	Customer Bank Account Card	Currency Code
73	424	Customer Bank Account List	Currency Code
74	425	Vendor Bank Account Card	Currency Code
75	426	Vendor Bank Account List	Currency Code
76	434	Reminder	Currency Code
77	436	Reminder List	Currency Code
78	438	Issued Reminder	Currency Code
79	440	Issued Reminder List	Currency Code
80	446	Finance Charge Memo	Currency Code
81	448	Finance Charge Memo List	Currency Code
82	450	Issued Finance Charge Memo	Currency Code
83	452	Issued Fin. Charge Memo List	Currency Code
84	477	Currencies for Fin. Chrg Terms	Currency Code
85	478	Currencies for Reminder Level	Currency Code
86	483	Currency Exchange Rates	Currency Code
87	493	Resource Price Changes	Currency Code
88	507	Blanket Sales Order	Currency Code
89	509	Blanket Purchase Order	Currency Code
90	573	Detailed Cust. Ledg. Entries	Currency Code
91	574	Detailed Vendor Ledg. Entries	Currency Code
92	608	IC Partner List	Currency Code
93	609	IC Partner Card	Currency Code
94	610	IC General Journal	Currency Code
95	612	IC Outbox Jnl. Lines	Currency Code
96	614	Handled IC Outbox Jnl. Lines	Currency Code
97	616	IC Inbox Jnl. Lines	Currency Code
98	618	Handled IC Inbox Jnl. Lines	Currency Code
99	622	IC Partners List Part	Currency Code
100	623	Unapply Customer Entries	Currency Code
101	624	Unapply Vendor Entries	Currency Code
102	625	Unapply Employee Entries	Currency Code
103	636	IC Outbox Sales Doc.	Currency Code
104	638	IC Outbox Purchase Doc.	Currency Code
105	640	Handled IC Outbox Sales Doc.	Currency Code
106	642	Handled IC Outbox Purch. Doc.	Currency Code
107	644	IC Inbox Sales Doc.	Currency Code
108	646	IC Inbox Purchase Doc.	Currency Code
109	648	Handled IC Inbox Sales Doc.	Currency Code
110	650	Handled IC Inbox Purch. Doc.	Currency Code
111	654	Requests to Approve	Currency Code
112	658	Approval Entries	Currency Code
113	659	Posted Approval Entries	Currency Code
114	662	Approval Request Entries	Currency Code
115	752	Standard Gen. Journal Subform	Currency Code
116	1011	Job Resource Prices	Currency Code
117	1012	Job Item Prices	Currency Code
118	1013	Job G/L Account Prices	Currency Code
119	1020	Job G/L Journal	Currency Code
120	1050	Additional Fee Setup	Currency Code
121	1050	Additional Fee Setup	Currency Code
122	1163	Sales Invoices Due Next Week	Currency Code
123	1206	Credit Transfer Reg. Entries	Currency Code
124	1208	Direct Debit Collect. Entries	Currency Code
125	1232	Positive Pay Entry Details	Currency Code
126	1272	OCR Data Correction	Currency Code
127	1282	Payment Bank Account List	Currency Code
128	1283	Payment Bank Account Card	Currency Code
129	1292	Payment Application	Currency Code
130	1345	Sales Price and Line Discounts	Currency Code
131	1346	Purchases Price and Line Disc.	Currency Code
132	1347	Sales Pr. & Line Disc. Part	Currency Code
133	1382	Customer Templ. Card	Currency Code
134	1386	Vendor Templ. Card	Currency Code
135	1690	Bank Deposit	Currency Code
136	1691	Bank Deposit List	Currency Code
137	1692	Bank Deposits	Currency Code
138	1694	Posted Bank Deposit	Currency Code
139	1696	Posted Bank Deposit List	Currency Code
140	1826	Company Consolidation Wizard	Currency Code
141	2103	O365 Sales Document List	Currency Code
142	2109	O365 Customer Sales Documents	Currency Code
143	5050	Contact Card	Currency Code
144	5052	Contact List	Currency Code
145	5159	Sales Order Archive	Currency Code
146	5161	Sales List Archive	Currency Code
147	5162	Sales Quote Archive	Currency Code
148	5164	Purchase Quote Archive	Currency Code
149	5166	Purchase List Archive	Currency Code
150	5167	Purchase Order Archive	Currency Code
151	5238	Detailed Empl. Ledger Entries	Currency Code
152	5240	Detailed Empl. Entries Preview	Currency Code
153	5522	Order Planning	Currency Code
154	5628	Fixed Asset G/L Journal	Currency Code
155	5708	Get Shipment Lines	Currency Code
156	5709	Get Receipt Lines	Currency Code
157	5853	Get Pst.Doc-RtrnRcptLn Subform	Currency Code
158	5858	Get Pst.Doc-RtrnShptLn Subform	Currency Code
159	5900	Service Order	Currency Code
160	5933	Service Invoice	Currency Code
161	5935	Service Credit Memo	Currency Code
162	5955	Standard Service Code Card	Currency Code
163	5958	Standard Service Codes	Currency Code
164	5964	Service Quote	Currency Code
165	5971	Posted Service Credit Memos	Currency Code
166	5972	Posted Service Credit Memo	Currency Code
167	5974	Posted Service Shipments	Currency Code
168	5975	Posted Service Shipment	Currency Code
169	5977	Posted Service Invoices	Currency Code
170	5978	Posted Service Invoice	Currency Code
171	5994	Get Service Shipment Lines	Currency Code
172	6036	Service Lines Subform	Currency Code
173	6037	Service Shipment Lines Subform	Currency Code
174	6050	Service Contract	Currency Code
175	6053	Service Contract Quote	Currency Code
176	6072	Filed Service Contract	Currency Code
177	6081	Serv. Price Group Setup	Currency Code
178	6081	Serv. Price Group Setup	Currency Code
179	6121	E-Document	Currency Code
180	6121	E-Document	Currency Code
181	6620	Blanket Sales Order Archive	Currency Code
182	6622	Blanket Sales Order Archives	Currency Code
183	6623	Blanket Purchase Order Archive	Currency Code
184	6625	Blanket Purch. Order Archives	Currency Code
185	6627	Sales Return Order Archive	Currency Code
186	6629	Sales Return List Archive	Currency Code
187	6630	Sales Return Order	Currency Code
188	6633	Sales Return Orders	Currency Code
189	6638	Get Return Receipt Lines	Currency Code
190	6640	Purchase Return Order	Currency Code
191	6643	Purchase Return Orders	Currency Code
192	6644	Purchase Return Order Archive	Currency Code
193	6646	Purchase Return List Archive	Currency Code
194	6648	Get Return Shipment Lines	Currency Code
195	6650	Posted Return Shipment	Currency Code
196	6652	Posted Return Shipments	Currency Code
197	6662	Posted Return Receipts	Currency Code
198	7002	Sales Prices	Currency Code
199	7003	Duplicate Price Lines	Currency Code
200	7004	Sales Line Discounts	Currency Code
201	7005	Price List Line Review	Currency Code
202	7007	Get Sales Price	Currency Code
203	7009	Get Sales Line Disc.	Currency Code
204	7010	Get Price Line	Currency Code
205	7012	Purchase Prices	Currency Code
206	7014	Purchase Line Discounts	Currency Code
207	7015	Sales Price Lists	Currency Code
208	7017	Purchase Price Lists	Currency Code
209	7019	Sales Job Price Lists	Currency Code
210	7020	Purchase Job Price Lists	Currency Code
211	7022	Price Worksheet	Currency Code
212	7023	Sales Price Worksheet	Currency Code
213	7023	Sales Price Worksheet	Currency Code
214	7024	Prices Overview	Currency Code
215	7189	Get Purchase Line Disc.	Currency Code
216	7190	Get Purchase Price	Currency Code
217	9300	Sales Quotes	Currency Code
218	9301	Sales Invoice List	Currency Code
219	9302	Sales Credit Memos	Currency Code
220	9303	Blanket Sales Orders	Currency Code
221	9304	Sales Return Order List	Currency Code
222	9305	Sales Order List	Currency Code
223	9306	Purchase Quotes	Currency Code
224	9307	Purchase Order List	Currency Code
225	9308	Purchase Invoices	Currency Code
226	9309	Purchase Credit Memos	Currency Code
227	9310	Blanket Purchase Orders	Currency Code
228	9311	Purchase Return Order List	Currency Code
229	9321	Service Contracts	Currency Code
230	9346	Purchase Quote Archives	Currency Code
231	9347	Purchase Order Archives	Currency Code
232	9348	Sales Quote Archives	Currency Code
233	9349	Sales Order Archives	Currency Code
234	41001	Hist. Gen. Journal Lines	Currency Code
235	41002	Hist. Sales Trx. Headers	Currency Code
236	41006	Hist. Receivables Document	Currency Code
237	41006	Hist. Receivables Document	Currency Code
238	41007	Hist. Sales Trx.	Currency Code
239	41008	Hist. Payables Document	Currency Code
240	41008	Hist. Payables Document	Currency Code
241	41013	Hist. Purchase Recv.	Currency Code
242	41014	Hist. Purchase Recv. Headers	Currency Code
243	41016	Hist. Receivables Documents	Currency Code
244	41017	Hist. Payables Documents	Currency Code
245	99000886	Subcontracting Worksheet	Currency Code

Dynamics 365 BC Table ReferencePage Control Search