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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to AMOUNT

Seq No	Page Number	Page Name	Control Name
1	20	General Ledger Entries	Amount
2	25	Customer Ledger Entries	Amount
3	29	Vendor Ledger Entries	Amount
4	39	General Journal	Amount
5	40	Item Journal	Amount
6	48	Sales Orders	Amount
7	56	Purchase Orders	Amount
8	61	Applied Customer Entries	Amount
9	62	Applied Vendor Entries	Amount
10	63	Applied Employee Entries	Amount
11	120	G/L Budget Entries	Amount
12	122	G/L Entries Preview	Amount
13	123	VAT Entries Preview	Amount
14	127	Det. Cust. Ledg. Entr. Preview	Amount
15	129	Detailed Vend. Entries Preview	Amount
16	143	Posted Sales Invoices	Amount
17	144	Posted Sales Credit Memos	Amount
18	146	Posted Purchase Invoices	Amount
19	147	Posted Purchase Credit Memos	Amount
20	160	Sales Statistics	Amount
21	161	Purchase Statistics	Amount
22	163	Warranty Ledg. Entries Preview	Amount
23	165	Bank Acc. Ledg. Entr. Preview	Amount
24	168	Service Ledger Entries Preview	Amount
25	179	Reverse Entries	Amount
26	182	Posted General Journal	Amount
27	183	Reverse Transaction Entries	Amount
28	232	Apply Customer Entries	Amount
29	233	Apply Vendor Entries	Amount
30	234	Apply Employee Entries	Amount
31	253	Sales Journal	Amount
32	254	Purchase Journal	Amount
33	255	Cash Receipt Journal	Amount
34	256	Payment Journal	Amount
35	283	Recurring General Journal	Amount
36	284	Allocations	Amount
37	286	Recurring Item Jnl.	Amount
38	303	Vendor Entry Statistics	Amount
39	311	Intrastat Journal	Amount
40	315	VAT Entries	Amount
41	372	Bank Account Ledger Entries	Amount
42	374	Check Ledger Entries	Amount
43	381	Apply Bank Acc. Ledger Entries	Amount
44	382	Apply Check Ledger Entries	Amount
45	390	Phys. Inventory Ledger Entries	Amount
46	392	Phys. Inventory Journal	Amount
47	393	Item Reclass. Journal	Amount
48	413	Applied Bank Acc. Ledger Entry	Amount
49	435	Reminder Lines	Amount
50	439	Issued Reminder Lines	Amount
51	447	Finance Charge Memo Lines	Amount
52	451	Issued Fin. Charge Memo Lines	Amount
53	519	Item Journal Lines	Amount
54	526	Posted Sales Invoice Lines	Amount
55	527	Posted Sales Credit Memo Lines	Amount
56	529	Posted Purchase Invoice Lines	Amount
57	530	Posted Purchase Cr. Memo Lines	Amount
58	558	Analysis View Entries	Amount
59	559	Analysis View Budget Entries	Amount
60	573	Detailed Cust. Ledg. Entries	Amount
61	574	Detailed Vendor Ledg. Entries	Amount
62	599	Payment Disc Tolerance Warning	Amount
63	610	IC General Journal	Amount
64	612	IC Outbox Jnl. Lines	Amount
65	614	Handled IC Outbox Jnl. Lines	Amount
66	616	IC Inbox Jnl. Lines	Amount
67	618	Handled IC Inbox Jnl. Lines	Amount
68	623	Unapply Customer Entries	Amount
69	624	Unapply Vendor Entries	Amount
70	625	Unapply Employee Entries	Amount
71	654	Requests to Approve	Amount
72	662	Approval Request Entries	Amount
73	741	VAT Report Subform	Amount
74	742	VAT Report Statement Subform	Amount
75	752	Standard Gen. Journal Subform	Amount
76	755	Standard Item Journal Subform	Amount
77	851	Chart of Cash Flow Accounts	Amount
78	855	Cash Flow Account List	Amount
79	857	Cash Flow Manual Revenues	Amount
80	859	Cash Flow Manual Expenses	Amount
81	985	Document Search	Amount
82	986	Document Search Result	Amount
83	986	Document Search Result	Amount
84	1020	Job G/L Journal	Amount
85	1103	Cost Entries	Amount
86	1108	Cost Journal	Amount
87	1115	Cost Budget Entries	Amount
88	1121	Cost Budget Registers	Amount
89	1232	Positive Pay Entry Details	Amount
90	1234	Positive Pay Export Detail	Amount
91	1284	Outstanding Bank Transactions	Amount
92	1297	Transfer Difference to Account	Amount
93	1571	G/L Entries Preview Subform	Amount
94	1572	VAT Entries Preview Subform	Amount
95	1574	G/L Entries Preview Flat Subf.	Amount
96	1575	VAT Entries Preview Flat Subf.	Amount
97	1632	Office Invoice Selection	Amount
98	1661	Payroll Import Transactions	Amount
99	1693	Bank Deposit Subform	Amount
100	1695	Posted Bank Deposit Lines	Amount
101	1697	Posted Bank Deposit Subform	Amount
102	1703	Deferral Schedule Subform	Amount
103	1705	Deferral Schedule View Subform	Amount
104	1707	Deferral Sched. Arch. Subform	Amount
105	1913	MigrationQB CustomerTrans	Amount
106	1913	MigrationQB CustomerTrans	Amount
107	1915	MigrationQB VendorTrans	Amount
108	1915	MigrationQB VendorTrans	Amount
109	2110	O365 Sales Invoice	Amount
110	2113	O365 Posted Sales Invoice	Amount
111	2118	O365 Payment History List	Amount
112	2119	O365 Payment History ListPart	Amount
113	2125	O365 Payment History Card	Amount
114	2141	O365 Sales Quote	Amount
115	2310	BC O365 Sales Invoice	Amount
116	2313	BC O365 Posted Sales Invoice	Amount
117	2341	BC O365 Sales Quote	Amount
118	2624	Stat. Account Balance Lines	Amount
119	2629	Stat. Acc. Reverse Entries	Amount
120	2633	Statistical Accounts Journal	Amount
121	2634	Statistical Ledger Entry List	Amount
122	2674	Allocation Account Preview	Amount
123	2678	Redistribute Acc. Allocations	Amount
124	4093	GP Customer	AMOUNT
125	4093	GP Customer	AMOUNT
126	4096	GP Vendor	AMOUNT
127	4096	GP Vendor	AMOUNT
128	4700	VAT Group Submission Lines	amount
129	4704	VAT Group Member Calculation	Amount
130	4706	VAT Group Sub. Lines Subform	Amount
131	4813	Intrastat Report Subform	Amount
132	4816	Intrastat Report Lines	Amount
133	5237	Employee Ledger Entries	Amount
134	5238	Detailed Empl. Ledger Entries	Amount
135	5240	Detailed Empl. Entries Preview	Amount
136	5604	FA Ledger Entries	Amount
137	5605	FA Error Ledger Entries	Amount
138	5606	FA Ledger Entries Preview	Amount
139	5628	Fixed Asset G/L Journal	Amount
140	5629	Fixed Asset Journal	Amount
141	5634	Recurring Fixed Asset Journal	Amount
142	5641	Maintenance Ledger Entries	Amount
143	5647	Ins. Coverage Ledger Entries	Amount
144	5651	Insurance Journal	Amount
145	5671	Maint. Ledg. Entries Preview	Amount
146	5803	Revaluation Journal	Amount
147	5912	Service Ledger Entries	Amount
148	5913	Warranty Ledger Entries	Amount
149	5951	Posted Service Invoice Lines	Amount
150	5952	Posted Service Cr. Memo Lines	Amount
151	5977	Posted Service Invoices	Amount
152	6033	Service Invoice Statistics	Amount
153	6034	Service Credit Memo Statistics	Amount
154	6064	Contract Gain/Loss Entries	Amount
155	6081	Serv. Price Group Setup	Amount
156	6081	Serv. Price Group Setup	Amount
157	6084	Service Line Price Adjmt.	Amount
158	6084	Service Line Price Adjmt.	Amount
159	6090	FA Ledger Entries Issues	Amount
160	6402	Sales Document Entity	amount
161	6403	Sales Document Line Entity	amount
162	6404	Purchase Document Entity	amount
163	6405	Purchase Document Line Entity	amount
164	6407	Gen. Journal Line Entity	amount
165	6408	Workflow – Customer Entity	amount
166	6562	Invt. Receipt Subform	Amount
167	6565	Invt. Shipment Subform	Amount
168	6568	Posted Invt. Receipt Subform	Amount
169	6571	Posted Invt. Shipment Subform	Amount
170	6619	Sales Line Archive List	Amount
171	6626	Purchase Line Archive List	Amount
172	6633	Sales Return Orders	Amount
173	6643	Purchase Return Orders	Amount
174	8851	Bank Statement Import Preview	Amount
175	9219	Purch. Budget Overview Matrix	Amount
176	9223	Item Statistics Matrix	Amount
177	9239	Sales Budget Overview Matrix	Amount
178	9241	G/L Entries Dim. Overv. Matrix	Amount
179	9300	Sales Quotes	Amount
180	9301	Sales Invoice List	Amount
181	9302	Sales Credit Memos	Amount
182	9304	Sales Return Order List	Amount
183	9305	Sales Order List	Amount
184	9307	Purchase Order List	Amount
185	9308	Purchase Invoices	Amount
186	9309	Purchase Credit Memos	Amount
187	9311	Purchase Return Order List	Amount
188	10531	MTD Payments	Amount
189	20049	APIV1 – JournalLines	amount
190	20058	APIV1 – Customer Payments	amount
191	22207	Review G/L Entries	Amount
192	30049	APIV2 – JournalLines	amount
193	30055	APIV2 – Customer Payments	amount
194	30060	APIV2 – Vendor Payments	amount
195	30110	Shpfy Gift Cards	Amount
196	30111	Shpfy Gift Card Transactions	Amount
197	30124	Shpfy Payment Transactions	Amount
198	30125	Shpfy Payouts	Amount
199	30128	Shpfy Order Shipping Charges	Amount
200	30128	Shpfy Order Shipping Charges	Amount
201	30131	Shpfy Order Transactions	Amount
202	30134	Shpfy Transactions	Amount
203	30146	Shpfy Refund Lines	Amount
204	30418	API Buf IC Inbox Jnl Line	amount
205	99000827	Recurring Output Journal	Amount

Dynamics 365 BC Table ReferencePage Control Search