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

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DEPRECIATION BOOK CODE

Seq No	Page Number	Page Name	Control Name
1	46	Sales Order Subform	Depreciation Book Code
2	47	Sales Invoice Subform	Depreciation Book Code
3	55	Purch. Invoice Subform	Depreciation Book Code
4	98	Purch. Cr. Memo Subform	Depreciation Book Code
5	139	Posted Purch. Invoice Subform	Depreciation Book Code
6	141	Posted Purch. Cr. Memo Subform	Depreciation Book Code
7	283	Recurring General Journal	Depreciation Book Code
8	529	Posted Purchase Invoice Lines	Depreciation Book Code
9	530	Posted Purchase Cr. Memo Lines	Depreciation Book Code
10	5160	Sales Order Archive Subform	Depreciation Book Code
11	5604	FA Ledger Entries	Depreciation Book Code
12	5605	FA Error Ledger Entries	Depreciation Book Code
13	5606	FA Ledger Entries Preview	Depreciation Book Code
14	5608	FA Posting Type Setup	Depreciation Book Code
15	5608	FA Posting Type Setup	Depreciation Book Code
16	5609	FA Journal Setup	Depreciation Book Code
17	5609	FA Journal Setup	Depreciation Book Code
18	5619	FA Depreciation Books	Depreciation Book Code
19	5628	Fixed Asset G/L Journal	Depreciation Book Code
20	5629	Fixed Asset Journal	Depreciation Book Code
21	5634	Recurring Fixed Asset Journal	Depreciation Book Code
22	5636	FA Reclass. Journal	Depreciation Book Code
23	5641	Maintenance Ledger Entries	Depreciation Book Code
24	5666	FA Depreciation Books Subform	Depreciation Book Code
25	5671	Maint. Ledg. Entries Preview	Depreciation Book Code
26	6621	Blanket Sales Order Arch. Sub.	Depreciation Book Code
27	6628	Sales Return Order Arc Subform	Depreciation Book Code
28	6641	Purchase Return Order Subform	Depreciation Book Code
29	9277	FA Posting Types Overv. Matrix	Depreciation Book Code

Dynamics 365 BC Table ReferencePage Control Search