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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to TYPE

Seq No	Page Number	Page Name	Control Name
1	30	Item Card	Type
2	31	Item List	Type
3	36	Assembly BOM	Type
4	46	Sales Order Subform	Type
5	47	Sales Invoice Subform	Type
6	48	Sales Orders	Type
7	54	Purchase Order Subform	Type
8	55	Purch. Invoice Subform	Type
9	56	Purchase Orders	Type
10	65	Rounding Methods	Type
11	76	Resource Card	Type
12	77	Resource List	Type
13	92	Job Ledger Entries	Type
14	93	Job Ledger Entries Preview	Type
15	95	Sales Quote Subform	Type
16	96	Sales Cr. Memo Subform	Type
17	97	Purchase Quote Subform	Type
18	98	Purch. Cr. Memo Subform	Type
19	101	General Journal Templates	Type
20	102	Item Journal Templates	Type
21	123	VAT Entries Preview	Type
22	131	Posted Sales Shpt. Subform	Type
23	133	Posted Sales Invoice Subform	Type
24	135	Posted Sales Cr. Memo Subform	Type
25	137	Posted Purchase Rcpt. Subform	Type
26	139	Posted Purch. Invoice Subform	Type
27	141	Posted Purch. Cr. Memo Subform	Type
28	163	Warranty Ledg. Entries Preview	Type
29	168	Service Ledger Entries Preview	Type
30	171	Standard Sales Code Subform	Type
31	176	Standard Purchase Code Subform	Type
32	193	Incoming Doc. Attach. FactBox	Type
33	194	Incoming Document Attachments	Type
34	199	Unlinked Attachments	Type
35	201	Job Journal	Type
36	203	Resource Costs	Type
37	204	Resource Prices	Type
38	250	General Journal Template List	Type
39	289	Recurring Job Jnl.	Type
40	291	Req. Worksheet	Type
41	296	Recurring Req. Worksheet	Type
42	311	Intrastat Journal	Type
43	315	VAT Entries	Type
44	317	VAT Statement	Type
45	380	Bank Acc. Reconciliation Lines	Type
46	384	Bank Account Statement Lines	Type
47	435	Reminder Lines	Type
48	439	Issued Reminder Lines	Type
49	443	Reminder Comment List	Type
50	444	Reminder/Fin. Charge Entries	Type
51	447	Finance Charge Memo Lines	Type
52	451	Issued Fin. Charge Memo Lines	Type
53	455	Fin. Charge Comment List	Type
54	475	VAT Statement Preview Line	Type
55	493	Resource Price Changes	Type
56	508	Blanket Sales Order Subform	Type
57	510	Blanket Purchase Order Subform	Type
58	516	Sales Lines	Type
59	517	Requisition Lines	Type
60	518	Purchase Lines	Type
61	525	Posted Sales Shipment Lines	Type
62	526	Posted Sales Invoice Lines	Type
63	527	Posted Sales Credit Memo Lines	Type
64	528	Posted Purchase Receipt Lines	Type
65	529	Posted Purchase Invoice Lines	Type
66	530	Posted Purchase Cr. Memo Lines	Type
67	741	VAT Report Subform	Type
68	901	Assembly Order Subform	Type
69	903	Assembly Lines	Type
70	912	Component – Resource Details	Type
71	914	Assemble-to-Order Lines	Type
72	921	Posted Assembly Order Subform	Type
73	931	Assembly Quote Subform	Type
74	941	Blanket Assembly Order Subform	Type
75	950	Time Sheet	Type
76	952	Manager Time Sheet	Type
77	959	Time Sheet Archive	Type
78	961	Manager Time Sheet Archive	Type
79	974	Time Sheet Lines Subform	Type
80	976	Time Sheet Archive Subform	Type
81	1007	Job Planning Lines	Type
82	1008	Job WIP Entries	Type
83	1009	Job WIP G/L Entries	Type
84	1011	Job Resource Prices	Type
85	1100	Chart of Cost Types	Type
86	1101	Cost Type Card	Type
87	1124	Cost Type List	Type
88	1210	Data Exch Def Card	Type
89	1211	Data Exch Def List	Type
90	1284	Outstanding Bank Transactions	Type
91	1345	Sales Price and Line Discounts	Type
92	1347	Sales Pr. & Line Disc. Part	Type
93	1384	Item Templ. Card	Type
94	1504	Workflow Step Instances	Type
95	1511	Notification Entries	Type
96	1514	Sent Notification Entries	Type
97	1530	Archived WF Step Instances	Type
98	1572	VAT Entries Preview Subform	Type
99	1575	VAT Entries Preview Flat Subf.	Type
100	1625	Office Contact Associations	Type
101	1625	Office Contact Associations	Type
102	1630	Office Contact Details Dlg	Type
103	1750	Field Data Classification	Type
104	1916	MigrationQB ItemTable	Type
105	1992	Checklist Administration	Type
106	2118	O365 Payment History List	Type
107	2119	O365 Payment History ListPart	Type
108	2122	O365 Incoming Doc. Attch. List	Type
109	2125	O365 Payment History Card	Type
110	2160	O365 Sales Graph	Type
111	2322	BC O365 Inc. Doc. Attch. List	Type
112	2379	BC O365 Contact Lookup	Type
113	4813	Intrastat Report Subform	Type
114	4816	Intrastat Report Lines	Type
115	5050	Contact Card	Type
116	5096	Task List	Type
117	5102	Activity Step Subform	Type
118	5110	Profile Questionnaire Setup	Type
119	5114	Contact Profile Answers	Type
120	5133	Close Opportunity Codes	Type
121	5143	Segment Criteria	Type
122	5144	Saved Segment Criteria Subform	Type
123	5145	Contact Through	Type
124	5160	Sales Order Archive Subform	Type
125	5163	Sales Quote Archive Subform	Type
126	5165	Purchase Quote Archive Subform	Type
127	5168	Purchase Order Archive Subform	Type
128	5172	Answer Points	Type
129	5199	Attendee Scheduling	Type
130	5206	Employee Qualifications	Type
131	5207	Qualified Employees	Type
132	5338	Integration Synch. Job List	Type
133	5510	Production Journal	Type
134	5530	Item Availability by Event	Type
135	5555	Permission Conflicts Overview	Type
136	5555	Permission Conflicts Overview	Type
137	5708	Get Shipment Lines	Type
138	5709	Get Receipt Lines	Type
139	5774	Warehouse Activity List	Type
140	5797	Registered Whse. Activity List	Type
141	5802	Value Entries	Type
142	5806	Purch. Receipt Lines	Type
143	5807	Value Entries Preview	Type
144	5824	Sales Shipment Lines	Type
145	5830	Demand Overview	Type
146	5832	Capacity Ledger Entries	Type
147	5841	Standard Cost Worksheet	Type
148	5841	Standard Cost Worksheet	Type
149	5846	Inventory Report Entry	Type
150	5846	Inventory Report Entry	Type
151	5847	Average Cost Calc. Overview	Type
152	5847	Average Cost Calc. Overview	Type
153	5851	Get Post.Doc – S.ShptLn Sbfrm	Type
154	5852	Get Post.Doc – S.InvLn Subform	Type
155	5853	Get Pst.Doc-RtrnRcptLn Subform	Type
156	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Type
157	5856	Get Post.Doc – P.RcptLn Sbfrm	Type
158	5857	Get Post.Doc – P.InvLn Subform	Type
159	5858	Get Pst.Doc-RtrnShptLn Subform	Type
160	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Type
161	5870	BOM Structure	Type
162	5872	BOM Cost Shares	Type
163	5904	Service Line List	Type
164	5905	Service Lines	Type
165	5907	Service Item Worksheet Subform	Type
166	5912	Service Ledger Entries	Type
167	5913	Warranty Ledger Entries	Type
168	5934	Service Invoice Subform	Type
169	5936	Service Credit Memo Subform	Type
170	5949	Posted Serv. Shpt. Line List	Type
171	5951	Posted Service Invoice Lines	Type
172	5952	Posted Service Cr. Memo Lines	Type
173	5956	Standard Service Code Subform	Type
174	5966	Service Quote Lines	Type
175	5970	Posted Service Shipment Lines	Type
176	5973	Posted Serv. Cr. Memo Subform	Type
177	5979	Posted Service Invoice Subform	Type
178	5986	Service Item Component List	Type
179	5987	Replaced Component List	Type
180	5993	Troubleshooting Setup	Type
181	5993	Troubleshooting Setup	Type
182	5994	Get Service Shipment Lines	Type
183	6019	Resource Skills	Type
184	6036	Service Lines Subform	Type
185	6037	Service Shipment Lines Subform	Type
186	6038	Service Invoice Lines Subform	Type
187	6039	Service Cr. Memo Lines Subform	Type
188	6058	Contract/Service Discounts	Type
189	6083	Serv. Price Adjmt. Detail	Type
190	6084	Service Line Price Adjmt.	Type
191	6084	Service Line Price Adjmt.	Type
192	6322	Power BI WS Report Selection	Type
193	6403	Sales Document Line Entity	type
194	6405	Purchase Document Line Entity	type
195	6409	Workflow – Item Entity	type
196	6619	Sales Line Archive List	Type
197	6621	Blanket Sales Order Arch. Sub.	Type
198	6624	Blanket Purch. Order Arch.Sub.	Type
199	6626	Purchase Line Archive List	Type
200	6628	Sales Return Order Arc Subform	Type
201	6631	Sales Return Order Subform	Type
202	6633	Sales Return Orders	Type
203	6638	Get Return Receipt Lines	Type
204	6641	Purchase Return Order Subform	Type
205	6643	Purchase Return Orders	Type
206	6645	Purch Return Order Arc Subform	Type
207	6648	Get Return Shipment Lines	Type
208	6651	Posted Return Shipment Subform	Type
209	6653	Posted Return Shipment Lines	Type
210	6657	Return Shipment Lines	Type
211	6661	Posted Return Receipt Subform	Type
212	6663	Posted Return Receipt Lines	Type
213	6667	Return Receipt Lines	Type
214	7004	Sales Line Discounts	Type
215	7009	Get Sales Line Disc.	Type
216	7115	Inventory Analysis Lines	Type
217	7120	Sales Analysis Lines	Type
218	7121	Purchase Analysis Lines	Type
219	7321	Whse. Journal Templates	Type
220	7353	Whse. Worksheet Templates	Type
221	7366	Whse. Worksheet Template List	Type
222	7370	Bin Creation Wksh. Templates	Type
223	7500	Item Attributes	Type
224	7503	Item Attribute	Type
225	7503	Item Attribute	Type
226	8619	Config. Template Subform	Type
227	9312	Warehouse Put-aways	Type
228	9313	Warehouse Picks	Type
229	9314	Warehouse Movements	Type
230	9315	Inventory Put-aways	Type
231	9316	Inventory Picks	Type
232	9330	Inventory Movements	Type
233	9343	Registered Whse. Put-aways	Type
234	9344	Registered Whse. Picks	Type
235	9345	Registered Whse. Movements	Type
236	9620	Page Fields	Type
237	9650	Custom Report Layouts	Type
238	9652	Report Layout Selection	Type
239	9652	Report Layout Selection	Type
240	9653	Report Layouts Part	Type
241	9802	Permission Sets	Type
242	9840	Tenant Permissions FactBox	Type
243	9850	Tenant Permissions	Type
244	9851	Permission Set List	Type
245	9853	Effective Permissions By Set	Type
246	9856	Metadata Permission Subform	Type
247	9859	Tenant Permission Subform	Type
248	9864	Permission Set Subform	Type
249	9993	Code Coverage AL Object	Type
250	10530	MTD Liabilities	Type
251	20008	APIV1 – Items	type
252	20009	APIV1 – Customers	type
253	30008	APIV2 – Items	type
254	30009	APIV2 – Customers	type
255	30071	APIV2 – Contacts	type
256	30111	Shpfy Gift Card Transactions	Type
257	30124	Shpfy Payment Transactions	Type
258	30131	Shpfy Order Transactions	Type
259	30134	Shpfy Transactions	Type
260	30152	Shpfy Bulk Operations	Type
261	30307	API Finance – Customer	type
262	50101	Fields List	Type
263	130409	AL Test Objects To Select	Type
264	99000764	Routing List	Type
265	99000765	Routing Lines	Type
266	99000766	Routing	Type
267	99000767	Routing Version Lines	Type
268	99000773	Capacity Journal	Type
269	99000778	Recurring Capacity Journal	Type
270	99000788	Production BOM Lines	Type
271	99000789	Production BOM Version Lines	Type
272	99000802	Capacity Units of Measure	Type
273	99000808	Routing Version List	Type
274	99000810	Routing Version	Type
275	99000810	Routing Version	Type
276	99000817	Prod. Order Routing	Type
277	99000820	Prod. Order Capacity Need	Type
278	99000820	Prod. Order Capacity Need	Type
279	99000823	Output Journal	Type
280	99000827	Recurring Output Journal	Type
281	99000852	Planning Worksheet	Type
282	99000863	Planning Routing	Type
283	99000886	Subcontracting Worksheet	Type

Dynamics 365 BC Table ReferencePage Control Search