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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to ENDING DATE

Seq No	Page Number	Page Name	Control Name
1	88	Job Card	Ending Date
2	107	Date Compr. Registers	Ending Date
3	240	Business Unit List	Ending Date
4	241	Business Unit Card	Ending Date
5	245	Consolidations in Progress	Ending Date
6	386	Extended Text	Ending Date
7	391	Extended Text List	Ending Date
8	664	Sales Prepayment Percentages	Ending Date
9	665	Purchase Prepmt. Percentages	Ending Date
10	687	Payment Practice Card	Ending Date
11	689	Payment Practice List	Ending Date
12	857	Cash Flow Manual Revenues	Ending Date
13	859	Cash Flow Manual Expenses	Ending Date
14	900	Assembly Order	Ending Date
15	902	Assembly Orders	Ending Date
16	904	Assembly List	Ending Date
17	920	Posted Assembly Order	Ending Date
18	922	Posted Assembly Orders	Ending Date
19	930	Assembly Quote	Ending Date
20	932	Assembly Quotes	Ending Date
21	940	Blanket Assembly Order	Ending Date
22	942	Blanket Assembly Orders	Ending Date
23	951	Time Sheet List	Ending Date
24	953	Manager Time Sheet List	Ending Date
25	960	Time Sheet Archive List	Ending Date
26	962	Manager Time Sheet Arc. List	Ending Date
27	973	Time Sheet Card	Ending Date
28	975	Time Sheet Archive Card	Ending Date
29	1345	Sales Price and Line Discounts	Ending Date
30	1346	Purchases Price and Line Disc.	Ending Date
31	1347	Sales Pr. & Line Disc. Part	Ending Date
32	1826	Company Consolidation Wizard	Ending Date
33	5058	Alt. Addr. Date Ranges	Ending Date
34	5059	Contact Alt. Addr. Date Ranges	Ending Date
35	5086	Campaign Card	Ending Date
36	5087	Campaign List	Ending Date
37	5097	Create Task	Ending Date
38	5406	Prod. Order Line List	Ending Date
39	5735	Item Reference List	Ending Date
40	5736	Item References	Ending Date
41	5737	Item Reference Entries	Ending Date
42	5828	Inventory Periods	Ending Date
43	5829	Inventory Period Entries	Ending Date
44	7002	Sales Prices	Ending Date
45	7003	Duplicate Price Lines	Ending Date
46	7004	Sales Line Discounts	Ending Date
47	7005	Price List Line Review	Ending Date
48	7007	Get Sales Price	Ending Date
49	7009	Get Sales Line Disc.	Ending Date
50	7010	Get Price Line	Ending Date
51	7012	Purchase Prices	Ending Date
52	7014	Purchase Line Discounts	Ending Date
53	7015	Sales Price Lists	Ending Date
54	7017	Purchase Price Lists	Ending Date
55	7019	Sales Job Price Lists	Ending Date
56	7020	Purchase Job Price Lists	Ending Date
57	7022	Price Worksheet	Ending Date
58	7023	Sales Price Worksheet	Ending Date
59	7023	Sales Price Worksheet	Ending Date
60	7024	Prices Overview	Ending Date
61	7189	Get Purchase Line Disc.	Ending Date
62	7190	Get Purchase Price	Ending Date
63	9323	Simulated Production Orders	Ending Date
64	9324	Planned Production Orders	Ending Date
65	9325	Firm Planned Prod. Orders	Ending Date
66	9326	Released Production Orders	Ending Date
67	9327	Finished Production Orders	Ending Date
68	99000788	Production BOM Lines	Ending Date
69	99000789	Production BOM Version Lines	Ending Date
70	99000813	Planned Production Order	Ending Date
71	99000814	Planned Prod. Order Lines	Ending Date
72	99000815	Production Order List	Ending Date
73	99000817	Prod. Order Routing	Ending Date
74	99000822	Order Tracking	Ending Date
75	99000829	Firm Planned Prod. Order	Ending Date
76	99000830	Firm Planned Prod. Order Lines	Ending Date
77	99000831	Released Production Order	Ending Date
78	99000832	Released Prod. Order Lines	Ending Date
79	99000852	Planning Worksheet	Ending Date
80	99000860	Planning Worksheet Line List	Ending Date
81	99000863	Planning Routing	Ending Date
82	99000867	Finished Production Order	Ending Date
83	99000868	Finished Prod. Order Lines	Ending Date
84	99000912	Simulated Production Order	Ending Date
85	99000913	Simulated Prod. Order Lines	Ending Date
86	99000914	Change Production Order Status	Ending Date
87	99000915	Work Center Task List	Ending Date
88	99000916	Machine Center Task List	Ending Date

Dynamics 365 BC Table ReferencePage Control Search