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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to NUMBER

Seq No	Page Number	Page Name	Control Name
1	198	Acc. Sched. KPI WS Dimensions	Number
2	1120	Cost Type Balance/Budget	Number
3	2181	O365 Excel Sheet Data SubPage	Number
4	5145	Contact Through	Number
5	5502	Trial Balance Entity	number
6	6402	Sales Document Entity	number
7	6403	Sales Document Line Entity	number
8	6404	Purchase Document Entity	number
9	6405	Purchase Document Line Entity	number
10	6408	Workflow – Customer Entity	number
11	6409	Workflow – Item Entity	number
12	6410	Workflow – Vendor Entity	number
13	9128	Invt. Doc Ship. Detail Factbox	Number
14	9970	Posted Sales Invoice API	number
15	9971	Posted Purchase Invoice API	number
16	20008	APIV1 – Items	number
17	20009	APIV1 – Customers	number
18	20010	APIV1 – Vendors	number
19	20012	APIV1 – Sales Invoices	number
20	20014	APIV1 – Accounts	number
21	20017	APIV1 – Employees	number
22	20028	APIV1 – Sales Orders	number
23	20034	APIV1 – Trial Balance	number
24	20037	APIV1 – Sales Quotes	number
25	20038	APIV1 – Sales Credit Memos	number
26	20042	APIV1 – Purchase Invoices	number
27	20048	Customer Financial Details	number
28	20050	APIV1 – Jobs	number
29	20051	APIV1 – Bank Accounts	number
30	30008	APIV2 – Items	number
31	30009	APIV2 – Customers	number
32	30010	APIV2 – Vendors	number
33	30012	APIV2 – Sales Invoices	number
34	30014	APIV2 – Accounts	number
35	30017	APIV2 – Employees	number
36	30028	APIV2 – Sales Orders	number
37	30034	APIV2 – Trial Balance	number
38	30037	APIV2 – Sales Quotes	number
39	30038	APIV2 – Sales Credit Memos	number
40	30042	APIV2 – Purchase Invoices	number
41	30048	APIV2 – Cust Financial Details	number
42	30050	APIV2 – Jobs	number
43	30051	APIV2 – Bank Accounts	number
44	30062	APIV2 – Sales Shipments	number
45	30064	APIV2 – Purchase Receipts	number
46	30066	APIV2 – Purchase Orders	number
47	30070	APIV2 – Opportunities	number
48	30071	APIV2 – Contacts	number
49	30083	APIV2 – Purchase Credit Memos	number
50	30307	API Finance – Customer	number
51	30308	API Finance – Vendor	number
52	30420	API Buf IC Inbox Purch Header	number
53	30421	API Buf IC Inbox Sales Header	number
54	130404	CAL Test Missing Codeunits	Number

Dynamics 365 BC Table ReferencePage Control Search