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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to JOB NO.

Seq No	Page Number	Page Name	Control Name
1	20	General Ledger Entries	Job No.
2	38	Item Ledger Entries	Job No.
3	47	Sales Invoice Subform	Job No.
4	54	Purchase Order Subform	Job No.
5	55	Purch. Invoice Subform	Job No.
6	92	Job Ledger Entries	Job No.
7	93	Job Ledger Entries Preview	Job No.
8	96	Sales Cr. Memo Subform	Job No.
9	97	Purchase Quote Subform	Job No.
10	98	Purch. Cr. Memo Subform	Job No.
11	122	G/L Entries Preview	Job No.
12	131	Posted Sales Shpt. Subform	Job No.
13	133	Posted Sales Invoice Subform	Job No.
14	135	Posted Sales Cr. Memo Subform	Job No.
15	137	Posted Purchase Rcpt. Subform	Job No.
16	139	Posted Purch. Invoice Subform	Job No.
17	141	Posted Purch. Cr. Memo Subform	Job No.
18	162	Resource Ledg. Entries Preview	Job No.
19	167	Item Ledger Entries Preview	Job No.
20	168	Service Ledger Entries Preview	Job No.
21	201	Job Journal	Job No.
22	202	Resource Ledger Entries	Job No.
23	289	Recurring Job Jnl.	Job No.
24	290	Recurring Resource Jnl.	Job No.
25	516	Sales Lines	Job No.
26	518	Purchase Lines	Job No.
27	525	Posted Sales Shipment Lines	Job No.
28	526	Posted Sales Invoice Lines	Job No.
29	527	Posted Sales Credit Memo Lines	Job No.
30	528	Posted Purchase Receipt Lines	Job No.
31	529	Posted Purchase Invoice Lines	Job No.
32	530	Posted Purchase Cr. Memo Lines	Job No.
33	637	IC Outbox Sales Lines	Job No.
34	639	IC Outbox Purchase Lines	Job No.
35	641	Handled IC Outbox Sales Lines	Job No.
36	643	Handled IC Outbox Purch. Lines	Job No.
37	645	IC Inbox Sales Lines	Job No.
38	647	IC Inbox Purchase Lines	Job No.
39	649	Handled IC Inbox Sales Lines	Job No.
40	651	Handled IC Inbox Purch. Lines	Job No.
41	950	Time Sheet	Job No.
42	952	Manager Time Sheet	Job No.
43	954	Manager Time Sheet by Job	Job No.
44	959	Time Sheet Archive	Job No.
45	961	Manager Time Sheet Archive	Job No.
46	966	Time Sheet Line Job Detail	Job No.
47	974	Time Sheet Lines Subform	Job No.
48	976	Time Sheet Archive Subform	Job No.
49	1001	Job Task Lines Subform	Job No.
50	1002	Job Task Lines	Job No.
51	1004	Job Task List	Job No.
52	1007	Job Planning Lines	Job No.
53	1008	Job WIP Entries	Job No.
54	1009	Job WIP G/L Entries	Job No.
55	1011	Job Resource Prices	Job No.
56	1012	Job Item Prices	Job No.
57	1013	Job G/L Account Prices	Job No.
58	1020	Job G/L Journal	Job No.
59	1026	Job WIP Warnings	Job No.
60	1615	Office Job Journal	Job No.
61	1615	Office Job Journal	Job No.
62	2583	Dim. Correct Ledger Entries	Job No.
63	2584	Dim Correct Posted Ledg Entr	Job No.
64	5160	Sales Order Archive Subform	Job No.
65	5163	Sales Quote Archive Subform	Job No.
66	5165	Purchase Quote Archive Subform	Job No.
67	5168	Purchase Order Archive Subform	Job No.
68	5708	Get Shipment Lines	Job No.
69	5709	Get Receipt Lines	Job No.
70	5802	Value Entries	Job No.
71	5807	Value Entries Preview	Job No.
72	5824	Sales Shipment Lines	Job No.
73	5851	Get Post.Doc – S.ShptLn Sbfrm	Job No.
74	5852	Get Post.Doc – S.InvLn Subform	Job No.
75	5853	Get Pst.Doc-RtrnRcptLn Subform	Job No.
76	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Job No.
77	5856	Get Post.Doc – P.RcptLn Sbfrm	Job No.
78	5857	Get Post.Doc – P.InvLn Subform	Job No.
79	5858	Get Pst.Doc-RtrnShptLn Subform	Job No.
80	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Job No.
81	5904	Service Line List	Job No.
82	5905	Service Lines	Job No.
83	5912	Service Ledger Entries	Job No.
84	6036	Service Lines Subform	Job No.
85	6621	Blanket Sales Order Arch. Sub.	Job No.
86	6624	Blanket Purch. Order Arch.Sub.	Job No.
87	6628	Sales Return Order Arc Subform	Job No.
88	6638	Get Return Receipt Lines	Job No.
89	6641	Purchase Return Order Subform	Job No.
90	6645	Purch Return Order Arc Subform	Job No.
91	6648	Get Return Shipment Lines	Job No.
92	6651	Posted Return Shipment Subform	Job No.
93	6653	Posted Return Shipment Lines	Job No.
94	6657	Return Shipment Lines	Job No.
95	6661	Posted Return Receipt Subform	Job No.
96	9154	My Jobs	Job No.

Dynamics 365 BC Table ReferencePage Control Search