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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to AMOUNT INCLUDING VAT

Seq No	Page Number	Page Name	Control Name
1	143	Posted Sales Invoices	Amount Including VAT
2	144	Posted Sales Credit Memos	Amount Including VAT
3	146	Posted Purchase Invoices	Amount Including VAT
4	147	Posted Purchase Credit Memos	Amount Including VAT
5	526	Posted Sales Invoice Lines	Amount Including VAT
6	527	Posted Sales Credit Memo Lines	Amount Including VAT
7	529	Posted Purchase Invoice Lines	Amount Including VAT
8	530	Posted Purchase Cr. Memo Lines	Amount Including VAT
9	576	VAT Specification Subform	Amount Including VAT
10	637	IC Outbox Sales Lines	Amount Including VAT
11	639	IC Outbox Purchase Lines	Amount Including VAT
12	641	Handled IC Outbox Sales Lines	Amount Including VAT
13	643	Handled IC Outbox Purch. Lines	Amount Including VAT
14	645	IC Inbox Sales Lines	Amount Including VAT
15	647	IC Inbox Purchase Lines	Amount Including VAT
16	649	Handled IC Inbox Sales Lines	Amount Including VAT
17	651	Handled IC Inbox Purch. Lines	Amount Including VAT
18	2110	O365 Sales Invoice	Amount Including VAT
19	2113	O365 Posted Sales Invoice	Amount Including VAT
20	2141	O365 Sales Quote	Amount Including VAT
21	5905	Service Lines	Amount Including VAT
22	5907	Service Item Worksheet Subform	Amount Including VAT
23	5951	Posted Service Invoice Lines	Amount Including VAT
24	5952	Posted Service Cr. Memo Lines	Amount Including VAT
25	5966	Service Quote Lines	Amount Including VAT
26	5977	Posted Service Invoices	Amount Including VAT
27	6619	Sales Line Archive List	Amount Including VAT
28	6626	Purchase Line Archive List	Amount Including VAT
29	9304	Sales Return Order List	Amount Including VAT
30	9305	Sales Order List	Amount Including VAT
31	9307	Purchase Order List	Amount Including VAT
32	9311	Purchase Return Order List	Amount Including VAT
33	9401	VAT Amount Lines	Amount Including VAT

Dynamics 365 BC Table ReferencePage Control Search