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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to ID

Seq No	Page Number	Page Name	Control Name
1	199	Unlinked Attachments	ID
2	356	Printers	ID
3	674	Job Queue Log Entries	ID
4	683	Server Printers	ID
5	703	Merge Duplicate Subform	ID
6	709	Error Message Register	ID
7	709	Error Message Register	ID
8	831	Workflow Webhook Subscriptions	id
9	1102	Cost Allocation Sources	ID
10	1105	Cost Allocation	ID
11	1109	Cost Allocation Target Card	ID
12	1170	User Task List	ID
13	1230	SEPA Direct Debit Mandates	ID
14	1316	Accountant Portal User Tasks	ID
15	1504	Workflow Step Instances	ID
16	1511	Notification Entries	ID
17	1514	Sent Notification Entries	ID
18	1530	Archived WF Step Instances	ID
19	1550	Restricted Records	ID
20	1927	Detached Media Cleanup	Id
21	2182	O365 Excel Columns	ID
22	2513	Extn. Orphaned App Details	Id
23	2616	Printer Management	ID
24	2650	Email Printer Settings	ID
25	2650	Email Printer Settings	ID
26	2753	Universal Print Shares List	ID
27	3845	Scheduled Tasks	ID
28	4094	GP Customer Transactions	Id
29	4094	GP Customer Transactions	Id
30	4097	GP Vendor Transactions	Id
31	4097	GP Vendor Transactions	Id
32	4690	Recurrence Schedule Card	ID
33	4700	VAT Group Submission Lines	id
34	4701	VAT Group Submissions	id
35	4703	VAT Group Approved Member List	ID
36	5395	Dataverse Entity Changes API	id
37	5461	API Webhook Logs	id
38	6307	PBI Aged Acc. Payable	ID
39	6308	PBI Aged Acc. Receivable	ID
40	6309	PBI Aged Inventory Chart	ID
41	6314	PBI Sales Pipeline	ID
42	6315	PBI Top 5 Opportunities	ID
43	6322	Power BI WS Report Selection	ID
44	6402	Sales Document Entity	id
45	6404	Purchase Document Entity	id
46	6406	Gen. Journal Batch Entity	id
47	6407	Gen. Journal Line Entity	id
48	6408	Workflow – Customer Entity	id
49	6409	Workflow – Item Entity	id
50	6410	Workflow – Vendor Entity	id
51	9166	Support Contact Info. Entity	id
52	9182	Generic Charts	ID
53	9183	Generic Chart Setup	ID
54	9183	Generic Chart Setup	ID
55	9216	Time Zones Lookup	ID
56	9877	Security Group Lookup	ID
57	9970	Posted Sales Invoice API	id
58	9971	Posted Purchase Invoice API	id
59	9988	Word Templates Table Lookup	ID
60	9993	Code Coverage AL Object	ID
61	20001	APIV1 – Aut. Companies	id
62	20002	APIV1 – Aut. Extensions	id
63	20005	APIV1 – Aut. Permission Sets	id
64	20006	APIV1 – Aut. Extension Upload	id
65	20008	APIV1 – Items	id
66	20009	APIV1 – Customers	id
67	20010	APIV1 – Vendors	id
68	20011	APIV1 – Company Information	id
69	20012	APIV1 – Sales Invoices	id
70	20013	APIV1 – Cust. Paym. Journals	id
71	20014	APIV1 – Accounts	id
72	20015	APIV1 – Tax Groups	id
73	20016	APIV1 – Journals	id
74	20017	APIV1 – Employees	id
75	20018	APIV1 – G/L Entries	id
76	20019	APIV1 – Currencies	id
77	20020	APIV1 – Payment Methods	id
78	20021	APIV1 – Dimensions	id
79	20022	APIV1 – Dimension Lines	id
80	20023	APIV1 – Payment Terms	id
81	20024	APIV1 – Shipment Methods	id
82	20025	APIV1 – Item Categories	id
83	20027	APIV1 – Countries/Regions	id
84	20028	APIV1 – Sales Orders	id
85	20030	APIV1 – Units of Measure	id
86	20036	APIV1 – Tax Areas	id
87	20037	APIV1 – Sales Quotes	id
88	20038	APIV1 – Sales Credit Memos	id
89	20039	APIV1 – Attachments	id
90	20040	APIV1 – G/L Entry Attachments	id
91	20041	APIV1 – Time Registr. Entries	id
92	20042	APIV1 – Purchase Invoices	id
93	20043	APIV1 – Sales Invoice Lines	id
94	20044	APIV1 – Sales Order Lines	id
95	20045	APIV1 – Sales Quote Lines	id
96	20046	APIV1 – Sales Credit Mem Lines	id
97	20047	APIV1 – Purchase Invoice Lines	id
98	20048	Customer Financial Details	id
99	20049	APIV1 – JournalLines	id
100	20050	APIV1 – Jobs	id
101	20051	APIV1 – Bank Accounts	id
102	20052	APIV1 – Item Variants	id
103	20053	APIV1 Dimension Values Entity	id
104	20055	APIV1 – Pictures	id
105	20058	APIV1 – Customer Payments	id
106	20060	APIV1 – Aut. User Permission	id
107	30000	APIV2 – Aut. Config. Packages	id
108	30001	APIV2 – Aut. Companies	id
109	30002	APIV2 – Aut. Extensions	id
110	30003	APIV2 – Aut. User Groups	id
111	30005	APIV2 – Aut. Permission Sets	id
112	30008	APIV2 – Items	id
113	30009	APIV2 – Customers	id
114	30010	APIV2 – Vendors	id
115	30011	APIV2 – Company Information	id
116	30012	APIV2 – Sales Invoices	id
117	30013	APIV2 – Cust. Paym. Journals	id
118	30014	APIV2 – Accounts	id
119	30015	APIV2 – Tax Groups	id
120	30016	APIV2 – Journals	id
121	30017	APIV2 – Employees	id
122	30018	APIV2 – G/L Entries	id
123	30019	APIV2 – Currencies	id
124	30020	APIV2 – Payment Methods	id
125	30021	APIV2 – Dimensions	id
126	30022	APIV2 – Dimension Set Lines	id
127	30023	APIV2 – Payment Terms	id
128	30024	APIV2 – Shipment Methods	id
129	30025	APIV2 – Item Categories	id
130	30026	APIV2 – Cash Flow Statement	id
131	30027	APIV2 – Countries/Regions	id
132	30028	APIV2 – Sales Orders	id
133	30029	APIV2 – Retained Earnings	id
134	30030	APIV2 – Units of Measure	id
135	30033	APIV2 – Balance Sheet	id
136	30035	APIV2 – Income Statement	id
137	30036	APIV2 – Tax Areas	id
138	30037	APIV2 – Sales Quotes	id
139	30038	APIV2 – Sales Credit Memos	id
140	30039	APIV2 – Attachments	id
141	30040	APIV2 Dimension Values Entity	id
142	30041	APIV2 – Time Registr. Entries	id
143	30042	APIV2 – Purchase Invoices	id
144	30043	APIV2 – Sales Invoice Lines	id
145	30044	APIV2 – Sales Order Lines	id
146	30045	APIV2 – Sales Quote Lines	id
147	30046	APIV2 – Sales Credit Mem Lines	id
148	30047	APIV2 – Purchase Invoice Lines	id
149	30048	APIV2 – Cust Financial Details	id
150	30049	APIV2 – JournalLines	id
151	30050	APIV2 – Jobs	id
152	30051	APIV2 – Bank Accounts	id
153	30052	APIV2 – Item Variants	id
154	30053	APIV2 – Pictures	id
155	30054	APIV2 – Default Dimensions	id
156	30055	APIV2 – Customer Payments	id
157	30056	APIV2 – PDF Document	id
158	30058	APIV2 – Aut. User Gr. Members	id
159	30059	APIV2 – Aut. User Permissions	id
160	30060	APIV2 – Vendor Payments	id
161	30061	APIV2 – Vendor Paym. Journals	id
162	30062	APIV2 – Sales Shipments	id
163	30063	APIV2 – Sales Shipment Lines	id
164	30064	APIV2 – Purchase Receipts	id
165	30065	APIV2 – Purch Receipt Lines	id
166	30066	APIV2 – Purchase Orders	id
167	30067	APIV2 – Purchase Order Lines	id
168	30068	APIV2 – Aut. Scheduled Jobs	id
169	30069	APIV2 – Item Ledger Entries	id
170	30070	APIV2 – Opportunities	id
171	30071	APIV2 – Contacts	id
172	30073	APIV2 – Apply Vendor Entries	id
173	30075	APIV2 – Aut. User Group Perm.	id
174	30076	APIV2 – Locations	id
175	30077	APIV2 – Cust. Return Reasons	id
176	30079	APIV2 – Gen. Prod. Post. Group	id
177	30080	APIV2 – Document Attachments	id
178	30082	APIV2 – Aut. Security Groups	id
179	30083	APIV2 – Purchase Credit Memos	id
180	30084	APIV2 – Purch. Cr. Memo Lines	id
181	30085	APIV2- Currency Exchange Rates	id
182	30086	APIV2 – Accounting Periods	id
183	30087	APIV2 – G/L Setup	id
184	30096	APIV2 – Inventory Post. Group	id
185	30105	Shpfy Customer Adresses	Id
186	30106	Shpfy Customer Card	Id
187	30107	Shpfy Customers	Id
188	30110	Shpfy Gift Cards	Id
189	30117	Shpfy Shop Locations Mapping	Id
190	30121	Shpfy Orders to Import	Id
191	30121	Shpfy Orders to Import	Id
192	30126	Shpfy Products	Id
193	30127	Shpfy Variants	Id
194	30143	Shpfy Products Overview	Id
195	30300	API Finance – Acc Periods	id
196	30301	API Finance – Business Unit	id
197	30302	API Finance – Dimension Values	id
198	30303	API Finance – Dim Set Entries	id
199	30304	API Finance – GL Account	id
200	30305	API Finance – GL Budgets	id
201	30307	API Finance – Customer	id
202	30308	API Finance – Vendor	id
203	30400	API – Handled IC Inbox Trans.	id
204	30402	API – IC Dimensions	id
205	30403	API – IC Dimension Values	id
206	30405	API – IC G/L Accounts	id
207	30411	API – IC Inbox Transactions	id
208	30413	API – IC Partners	id
209	30414	API – IC Setup	id
210	30415	API IC Incoming Notification	id
211	30416	API Buf IC Comment Lines	id
212	30417	API Buf IC Document Dimension	id
213	30418	API Buf IC Inbox Jnl Line	id
214	30419	API Buf IC Inbox Purchase Line	id
215	30420	API Buf IC Inbox Purch Header	id
216	30421	API Buf IC Inbox Sales Header	id
217	30422	API Buf IC Inbox Sales Line	id
218	30423	API Buf IC Inbox Transaction	id
219	30424	API Buf IC InOut Jnl Line Dim	id
220	30425	API IC Outgoing Notification	id
221	40020	Cloud Migration Companies API	id
222	40021	Cloud Migration Status API	id
223	40022	Cloud Mig Table Mapping API	id
224	40023	Setup Cloud Migration API	id
225	40024	Cloud Mig Product Type API	id
226	40026	Cloud Mig Status Detail API	id
227	130409	AL Test Objects To Select	ID

Dynamics 365 BC Table ReferencePage Control Search