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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to POSTINGDATE

Seq No	Page Number	Page Name	Control Name
1	579	Post Application	PostingDate
2	591	Payment Tolerance Warning	PostingDate
3	599	Payment Disc Tolerance Warning	PostingDate
4	1014	Job Transfer Job Planning Line	PostingDate
5	1702	Deferral Schedule	PostingDate
6	1808	Data Migration Wizard	PostingDate
7	2634	Statistical Ledger Entry List	PostingDate
8	2674	Allocation Account Preview	PostingDate
9	2678	Redistribute Acc. Allocations	PostingDate
10	5510	Production Journal	PostingDate
11	6402	Sales Document Entity	postingDate
12	6403	Sales Document Line Entity	postingDate
13	6404	Purchase Document Entity	postingDate
14	6407	Gen. Journal Line Entity	postingDate
15	9970	Posted Sales Invoice API	postingDate
16	9971	Posted Purchase Invoice API	postingDate
17	20012	APIV1 – Sales Invoices	postingDate
18	20018	APIV1 – G/L Entries	postingDate
19	20028	APIV1 – Sales Orders	postingDate
20	20037	APIV1 – Sales Quotes	postingDate
21	20038	APIV1 – Sales Credit Memos	postingDate
22	20042	APIV1 – Purchase Invoices	postingDate
23	20049	APIV1 – JournalLines	postingDate
24	20058	APIV1 – Customer Payments	postingDate
25	30012	APIV2 – Sales Invoices	postingDate
26	30018	APIV2 – G/L Entries	postingDate
27	30028	APIV2 – Sales Orders	postingDate
28	30037	APIV2 – Sales Quotes	postingDate
29	30038	APIV2 – Sales Credit Memos	postingDate
30	30042	APIV2 – Purchase Invoices	postingDate
31	30049	APIV2 – JournalLines	postingDate
32	30055	APIV2 – Customer Payments	postingDate
33	30060	APIV2 – Vendor Payments	postingDate
34	30062	APIV2 – Sales Shipments	postingDate
35	30064	APIV2 – Purchase Receipts	postingDate
36	30066	APIV2 – Purchase Orders	postingDate
37	30069	APIV2 – Item Ledger Entries	postingDate
38	30073	APIV2 – Apply Vendor Entries	postingDate
39	30083	APIV2 – Purchase Credit Memos	postingDate
40	30400	API – Handled IC Inbox Trans.	postingDate
41	30411	API – IC Inbox Transactions	postingDate
42	30420	API Buf IC Inbox Purch Header	postingDate
43	30421	API Buf IC Inbox Sales Header	postingDate
44	30423	API Buf IC Inbox Transaction	postingDate
45	99000882	Change Status on Prod. Order	PostingDate

Dynamics 365 BC Table ReferencePage Control Search