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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to LINE AMOUNT

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Line Amount
2	47	Sales Invoice Subform	Line Amount
3	54	Purchase Order Subform	Line Amount
4	55	Purch. Invoice Subform	Line Amount
5	92	Job Ledger Entries	Line Amount
6	93	Job Ledger Entries Preview	Line Amount
7	95	Sales Quote Subform	Line Amount
8	96	Sales Cr. Memo Subform	Line Amount
9	97	Purchase Quote Subform	Line Amount
10	98	Purch. Cr. Memo Subform	Line Amount
11	133	Posted Sales Invoice Subform	Line Amount
12	135	Posted Sales Cr. Memo Subform	Line Amount
13	139	Posted Purch. Invoice Subform	Line Amount
14	141	Posted Purch. Cr. Memo Subform	Line Amount
15	201	Job Journal	Line Amount
16	289	Recurring Job Jnl.	Line Amount
17	508	Blanket Sales Order Subform	Line Amount
18	510	Blanket Purchase Order Subform	Line Amount
19	516	Sales Lines	Line Amount
20	518	Purchase Lines	Line Amount
21	576	VAT Specification Subform	Line Amount
22	637	IC Outbox Sales Lines	Line Amount
23	639	IC Outbox Purchase Lines	Line Amount
24	641	Handled IC Outbox Sales Lines	Line Amount
25	643	Handled IC Outbox Purch. Lines	Line Amount
26	645	IC Inbox Sales Lines	Line Amount
27	647	IC Inbox Purchase Lines	Line Amount
28	649	Handled IC Inbox Sales Lines	Line Amount
29	651	Handled IC Inbox Purch. Lines	Line Amount
30	1007	Job Planning Lines	Line Amount
31	2111	O365 Sales Invoice Line Subp.	Line Amount
32	2114	O365 Posted Sales Inv. Lines	Line Amount
33	2183	O365 Sales Invoice Line Dummy	Line Amount
34	2304	BC O365 Posted Sale Inv. Lines	Line Amount
35	2311	BC O365 Sales Inv. Line Subp.	Line Amount
36	5160	Sales Order Archive Subform	Line Amount
37	5163	Sales Quote Archive Subform	Line Amount
38	5165	Purchase Quote Archive Subform	Line Amount
39	5168	Purchase Order Archive Subform	Line Amount
40	5904	Service Line List	Line Amount
41	5905	Service Lines	Line Amount
42	5907	Service Item Worksheet Subform	Line Amount
43	5934	Service Invoice Subform	Line Amount
44	5936	Service Credit Memo Subform	Line Amount
45	5966	Service Quote Lines	Line Amount
46	5973	Posted Serv. Cr. Memo Subform	Line Amount
47	5979	Posted Service Invoice Subform	Line Amount
48	6052	Service Contract Subform	Line Amount
49	6054	Service Contract Quote Subform	Line Amount
50	6074	Filed Service Contract Subform	Line Amount
51	6075	Serv. Contr. List (Serv. Item)	Line Amount
52	6078	Service Contract Line List	Line Amount
53	6086	Filed Service Contract Lines	Line Amount
54	6621	Blanket Sales Order Arch. Sub.	Line Amount
55	6624	Blanket Purch. Order Arch.Sub.	Line Amount
56	6628	Sales Return Order Arc Subform	Line Amount
57	6631	Sales Return Order Subform	Line Amount
58	6641	Purchase Return Order Subform	Line Amount
59	6645	Purch Return Order Arc Subform	Line Amount
60	9401	VAT Amount Lines	Line Amount

Dynamics 365 BC Table ReferencePage Control Search