Database view for General Ledger User Defined Fields

Looking for database information for User Defined fields for General Ledger from EERP.

• EERP version 2019 and above

• SSRS Reports

• OnPrem, SaaS Hosted

• General Ledger

• User Defined Fields

Need database view to build custom report.

User Defined Fields for General Ledger can be found in the gl_user_defined_data TRS view. This view can be tied back to gl_master using the example query below:

select

m.a_fund_seg1, 

m.a_account_desc,

m.s_segment1_desc,

f.uf_name, d.ud_data,

*

from gl_master m

inner join gl_user_defined_data d

on m.a_account_id = d.ud_record_key

inner join gl_user_defined_fields f

d.a_field_number = f.a_field_number