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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to WORK TYPE CODE

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Work Type Code
2	47	Sales Invoice Subform	Work Type Code
3	48	Sales Orders	Work Type Code
4	92	Job Ledger Entries	Work Type Code
5	93	Job Ledger Entries Preview	Work Type Code
6	95	Sales Quote Subform	Work Type Code
7	96	Sales Cr. Memo Subform	Work Type Code
8	162	Resource Ledg. Entries Preview	Work Type Code
9	163	Warranty Ledg. Entries Preview	Work Type Code
10	201	Job Journal	Work Type Code
11	202	Resource Ledger Entries	Work Type Code
12	203	Resource Costs	Work Type Code
13	204	Resource Prices	Work Type Code
14	207	Resource Journal	Work Type Code
15	289	Recurring Job Jnl.	Work Type Code
16	290	Recurring Resource Jnl.	Work Type Code
17	376	Job Journal Reconcile	Work Type Code
18	493	Resource Price Changes	Work Type Code
19	499	Available – Sales Lines	Work Type Code
20	508	Blanket Sales Order Subform	Work Type Code
21	516	Sales Lines	Work Type Code
22	950	Time Sheet	Work Type Code
23	952	Manager Time Sheet	Work Type Code
24	954	Manager Time Sheet by Job	Work Type Code
25	959	Time Sheet Archive	Work Type Code
26	961	Manager Time Sheet Archive	Work Type Code
27	965	Time Sheet Line Res. Detail	Work Type Code
28	966	Time Sheet Line Job Detail	Work Type Code
29	967	Time Sheet Line Service Detail	Work Type Code
30	974	Time Sheet Lines Subform	Work Type Code
31	976	Time Sheet Archive Subform	Work Type Code
32	1007	Job Planning Lines	Work Type Code
33	1011	Job Resource Prices	Work Type Code
34	1032	Available – Job Planning Lines	Work Type Code
35	5905	Service Lines	Work Type Code
36	5907	Service Item Worksheet Subform	Work Type Code
37	5913	Warranty Ledger Entries	Work Type Code
38	5934	Service Invoice Subform	Work Type Code
39	5936	Service Credit Memo Subform	Work Type Code
40	5949	Posted Serv. Shpt. Line List	Work Type Code
41	5966	Service Quote Lines	Work Type Code
42	5970	Posted Service Shipment Lines	Work Type Code
43	7001	Price List Lines	Work Type Code
44	7003	Duplicate Price Lines	Work Type Code
45	7005	Price List Line Review	Work Type Code
46	7010	Get Price Line	Work Type Code
47	7011	Purchase Price List Lines	Work Type Code
48	7022	Price Worksheet	Work Type Code
49	7024	Prices Overview	Work Type Code

Dynamics 365 BC Table ReferencePage Control Search