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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to STATUS

Seq No	Page Number	Page Name	Control Name
1	41	Sales Quote	Status
2	42	Sales Order	Status
3	43	Sales Invoice	Status
4	44	Sales Credit Memo	Status
5	45	Sales List	Status
6	49	Purchase Quote	Status
7	50	Purchase Order	Status
8	51	Purchase Invoice	Status
9	52	Purchase Credit Memo	Status
10	88	Job Card	Status
11	89	Job List	Status
12	245	Consolidations in Progress	Status
13	247	VAT Registration Log Details	Status
14	247	VAT Registration Log Details	Status
15	249	VAT Registration Log	Status
16	249	VAT Registration Log	Status
17	321	ECSL Report	Status
18	323	EC Sales List Reports	Status
19	507	Blanket Sales Order	Status
20	509	Blanket Purchase Order	Status
21	578	Change Global Dim. Log Entries	Status
22	613	Handled IC Outbox Transactions	Status
23	617	Handled IC Inbox Transactions	Status
24	654	Requests to Approve	Status
25	658	Approval Entries	Status
26	659	Posted Approval Entries	Status
27	662	Approval Request Entries	Status
28	672	Job Queue Entries	Status
29	673	Job Queue Entry Card	Status
30	674	Job Queue Log Entries	Status
31	675	My Job Queue	Status
32	710	Activity Log	Status
33	710	Activity Log	Status
34	737	VAT Return Period List	Status
35	738	VAT Return Period Card	Status
36	740	VAT Report	Status
37	744	VAT Report List	Status
38	780	Certificates of Supply	Status
39	832	Approvals	Status
40	900	Assembly Order	Status
41	930	Assembly Quote	Status
42	940	Blanket Assembly Order	Status
43	950	Time Sheet	Status
44	952	Manager Time Sheet	Status
45	954	Manager Time Sheet by Job	Status
46	959	Time Sheet Archive	Status
47	961	Manager Time Sheet Archive	Status
48	974	Time Sheet Lines Subform	Status
49	976	Time Sheet Archive Subform	Status
50	1032	Available – Job Planning Lines	Status
51	1205	Credit Transfer Registers	Status
52	1207	Direct Debit Collections	Status
53	1208	Direct Debit Collect. Entries	Status
54	1278	Service Connections Part	Status
55	1279	Service Connections	Status
56	1286	Payment Rec Match Details	Status
57	1504	Workflow Step Instances	Status
58	1529	Workflow Overview	Status
59	1530	Archived WF Step Instances	Status
60	1752	Data Classification Wizard	Status
61	1795	Data Migration Overview Part	Status
62	1799	Data Migration Overview	Status
63	1830	MS – QBO Data Migration	Status
64	2023	Image Analysis Scenarios Part	Status
65	2313	BC O365 Posted Sales Invoice	Status
66	2508	Extension Deployment Status	Status
67	2509	Extn Deployment Status Detail	Status
68	2588	Dimension Correction	Status
69	2588	Dimension Correction	Status
70	2591	Dimension Correction Draft	Status
71	2592	Dimension Corrections	Status
72	4003	Intelligent Cloud Management	Status
73	4006	Intelligent Cloud Details	Status
74	4812	Intrastat Report	Status
75	5096	Task List	Status
76	5098	Task Card	Status
77	5123	Opportunity List	Status
78	5124	Opportunity Card	Status
79	5132	Active Opportunity List	Status
80	5159	Sales Order Archive	Status
81	5162	Sales Quote Archive	Status
82	5164	Purchase Quote Archive	Status
83	5167	Purchase Order Archive	Status
84	5199	Attendee Scheduling	Status
85	5200	Employee Card	Status
86	5266	Audit File Export Documents	Status
87	5267	Audit File Export Doc. Card	Status
88	5269	Audit File Export Subpage	Status
89	5361	Integration Field Mapping List	Status
90	5406	Prod. Order Line List	Status
91	5407	Prod. Order Comp. Line List	Status
92	5448	Automation Extension Depl.	status
93	5461	API Webhook Logs	status
94	5740	Transfer Order	Status
95	5742	Transfer Orders	Status
96	5875	Physical Inventory Order	Status
97	5876	Physical Inventory Orders	Status
98	5879	Phys. Inventory Recording	Status
99	5880	Phys. Inventory Recording List	Status
100	5887	Posted Phys. Invt. Recording	Status
101	5900	Service Order	Status
102	5901	Service List	Status
103	5961	Service Email Queue	Status
104	5961	Service Email Queue	Status
105	5964	Service Quote	Status
106	5980	Service Item Card	Status
107	5981	Service Item List	Status
108	6000	Dispatch Board	Status
109	6001	Service Order Allocations	Status
110	6005	Resource Allocations	Status
111	6050	Service Contract	Status
112	6051	Service Contract List	Status
113	6053	Service Contract Quote	Status
114	6065	Customer Service Contracts	Status
115	6072	Filed Service Contract	Status
116	6122	E-Documents	Status
117	6125	E-Document Logs	Status
118	6135	E-Document Service Status	Status
119	6135	E-Document Service Status	Status
120	6402	Sales Document Entity	status
121	6404	Purchase Document Entity	status
122	6561	Invt. Receipt	Status
123	6564	Invt. Shipment	Status
124	6620	Blanket Sales Order Archive	Status
125	6623	Blanket Purchase Order Archive	Status
126	6627	Sales Return Order Archive	Status
127	6630	Sales Return Order	Status
128	6640	Purchase Return Order	Status
129	6644	Purchase Return Order Archive	Status
130	7005	Price List Line Review	Status
131	7015	Sales Price Lists	Status
132	7016	Sales Price List	Status
133	7017	Purchase Price Lists	Status
134	7018	Purchase Price List	Status
135	7019	Sales Job Price Lists	Status
136	7020	Purchase Job Price Lists	Status
137	7022	Price Worksheet	Status
138	7024	Prices Overview	Status
139	7233	Master Data Synch. Tables	Status
140	7236	Master Data Synch. Fields	Status
141	7335	Warehouse Shipment	Status
142	7339	Warehouse Shipment List	Status
143	7341	Whse. Shipment Lines	Status
144	7342	Whse. Receipt Lines	Status
145	7354	Whse. Internal Put-away	Status
146	7356	Whse. Internal Put-away List	Status
147	7357	Whse. Internal Pick	Status
148	7359	Whse. Internal Pick List	Status
149	7360	Whse. Internal Pick Lines	Status
150	8630	Config. Tables	Status
151	8632	Config. Worksheet	Status
152	8882	Email Outbox	Status
153	8882	Email Outbox	Status
154	9092	Approval FactBox	Status
155	9154	My Jobs	Status
156	9300	Sales Quotes	Status
157	9301	Sales Invoice List	Status
158	9302	Sales Credit Memos	Status
159	9303	Blanket Sales Orders	Status
160	9304	Sales Return Order List	Status
161	9305	Sales Order List	Status
162	9306	Purchase Quotes	Status
163	9307	Purchase Order List	Status
164	9308	Purchase Invoices	Status
165	9309	Purchase Credit Memos	Status
166	9310	Blanket Purchase Orders	Status
167	9311	Purchase Return Order List	Status
168	9317	Service Quotes	Status
169	9318	Service Orders	Status
170	9319	Service Invoices	Status
171	9320	Service Credit Memos	Status
172	9321	Service Contracts	Status
173	9322	Service Contract Quotes	Status
174	9323	Simulated Production Orders	Status
175	9324	Planned Production Orders	Status
176	9325	Firm Planned Prod. Orders	Status
177	9326	Released Production Orders	Status
178	9327	Finished Production Orders	Status
179	9620	Page Fields	Status
180	9656	Report Layout Update Log	Status
181	9656	Report Layout Update Log	Status
182	9994	API Data Upgrade List	Status
183	20007	APIV1 – Aut. Extension Depl.	status
184	20012	APIV1 – Sales Invoices	status
185	20017	APIV1 – Employees	status
186	20028	APIV1 – Sales Orders	status
187	20037	APIV1 – Sales Quotes	status
188	20038	APIV1 – Sales Credit Memos	status
189	20041	APIV1 – Time Registr. Entries	status
190	20042	APIV1 – Purchase Invoices	status
191	20107	AMC Bank Webcall Log	Status
192	30007	APIV2 – Aut. Extension Depl.	status
193	30012	APIV2 – Sales Invoices	status
194	30017	APIV2 – Employees	status
195	30028	APIV2 – Sales Orders	status
196	30037	APIV2 – Sales Quotes	status
197	30038	APIV2 – Sales Credit Memos	status
198	30041	APIV2 – Time Registr. Entries	status
199	30042	APIV2 – Purchase Invoices	status
200	30066	APIV2 – Purchase Orders	status
201	30068	APIV2 – Aut. Scheduled Jobs	status
202	30070	APIV2 – Opportunities	status
203	30083	APIV2 – Purchase Credit Memos	status
204	30111	Shpfy Gift Card Transactions	Status
205	30112	Shpfy Order Fulfillments	Status
206	30125	Shpfy Payouts	Status
207	30126	Shpfy Products	Status
208	30131	Shpfy Order Transactions	Status
209	30134	Shpfy Transactions	Status
210	30140	Shpfy Fulfillment Order Card	Status
211	30150	Shpfy Returns	Status
212	30151	Shpfy Return	Status
213	30152	Shpfy Bulk Operations	Status
214	30153	Shpfy Order Fulfillment	Status
215	30153	Shpfy Order Fulfillment	Status
216	30400	API – Handled IC Inbox Trans.	status
217	40020	Cloud Migration Companies API	status
218	40021	Cloud Migration Status API	status
219	40026	Cloud Mig Status Detail API	status
220	40027	Hybrid DA Approval	Status
221	40027	Hybrid DA Approval	Status
222	40033	Hybrid Migration Log	Status
223	40034	Migration Table Overview	Status
224	99000764	Routing List	Status
225	99000766	Routing	Status
226	99000786	Production BOM	Status
227	99000787	Production BOM List	Status
228	99000808	Routing Version List	Status
229	99000809	Production BOM Version	Status
230	99000809	Production BOM Version	Status
231	99000810	Routing Version	Status
232	99000810	Routing Version	Status
233	99000815	Production Order List	Status
234	99000884	Create Order From Sales	Status
235	99000897	Available – Prod. Order Lines	Status
236	99000898	Available – Prod. Order Comp.	Status
237	99000915	Work Center Task List	Status
238	99000916	Machine Center Task List	Status

Dynamics 365 BC Table ReferencePage Control Search