We have a requirement to create a Custom Expense Report for the client. However, we can't find the table for the Business Segment of a certain expense. Please see attached file for the screenshot of Account information. We are able to extract some of the information such as the BTL_INDUSTRY, BTL_COSTCENTER and BTL_ACCOUNT. However, we need also the value from BTL_BUSINESS but we can't find the table for it. We are using the following tables in our SQL Query:
Thanks in advance.