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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to JOB TASK NO.

Seq No	Page Number	Page Name	Control Name
1	38	Item Ledger Entries	Job Task No.
2	47	Sales Invoice Subform	Job Task No.
3	54	Purchase Order Subform	Job Task No.
4	55	Purch. Invoice Subform	Job Task No.
5	92	Job Ledger Entries	Job Task No.
6	93	Job Ledger Entries Preview	Job Task No.
7	96	Sales Cr. Memo Subform	Job Task No.
8	97	Purchase Quote Subform	Job Task No.
9	98	Purch. Cr. Memo Subform	Job Task No.
10	131	Posted Sales Shpt. Subform	Job Task No.
11	133	Posted Sales Invoice Subform	Job Task No.
12	135	Posted Sales Cr. Memo Subform	Job Task No.
13	137	Posted Purchase Rcpt. Subform	Job Task No.
14	139	Posted Purch. Invoice Subform	Job Task No.
15	141	Posted Purch. Cr. Memo Subform	Job Task No.
16	167	Item Ledger Entries Preview	Job Task No.
17	168	Service Ledger Entries Preview	Job Task No.
18	201	Job Journal	Job Task No.
19	289	Recurring Job Jnl.	Job Task No.
20	518	Purchase Lines	Job Task No.
21	950	Time Sheet	Job Task No.
22	952	Manager Time Sheet	Job Task No.
23	954	Manager Time Sheet by Job	Job Task No.
24	959	Time Sheet Archive	Job Task No.
25	961	Manager Time Sheet Archive	Job Task No.
26	966	Time Sheet Line Job Detail	Job Task No.
27	974	Time Sheet Lines Subform	Job Task No.
28	976	Time Sheet Archive Subform	Job Task No.
29	1001	Job Task Lines Subform	Job Task No.
30	1002	Job Task Lines	Job Task No.
31	1003	Job Task Card	Job Task No.
32	1004	Job Task List	Job Task No.
33	1007	Job Planning Lines	Job Task No.
34	1011	Job Resource Prices	Job Task No.
35	1012	Job Item Prices	Job Task No.
36	1013	Job G/L Account Prices	Job Task No.
37	1020	Job G/L Journal	Job Task No.
38	1026	Job WIP Warnings	Job Task No.
39	1028	Job WIP Totals	Job Task No.
40	1615	Office Job Journal	Job Task No.
41	1615	Office Job Journal	Job Task No.
42	5160	Sales Order Archive Subform	Job Task No.
43	5163	Sales Quote Archive Subform	Job Task No.
44	5165	Purchase Quote Archive Subform	Job Task No.
45	5168	Purchase Order Archive Subform	Job Task No.
46	5802	Value Entries	Job Task No.
47	5807	Value Entries Preview	Job Task No.
48	5904	Service Line List	Job Task No.
49	5905	Service Lines	Job Task No.
50	5912	Service Ledger Entries	Job Task No.
51	6036	Service Lines Subform	Job Task No.
52	6621	Blanket Sales Order Arch. Sub.	Job Task No.
53	6641	Purchase Return Order Subform	Job Task No.

Dynamics 365 BC Table ReferencePage Control Search