Pulling Invoice Item details through ODBC
Hello.
I'm using ODBC to pull transaction records to make a custom module for commissions and I need to separate the commissionable items by Item Class. However, I am only able to pull Invoice Header and custom fields, but no Item sublist fields.
I checked the permissions for the role used for the ODBC connection (via SuiteTalk) and I added everything I could think of.
For example, in this text, the class field returns as unrecognized while the rest works fine.
SELECT SuiteTalk.Invoice.InternalId, Job_InternalId,Job_name, [Project Name Only],[Amount after discount], class
FROM SuiteTalk.Invoice;
How do I pull the Item sublist fields through ODBC?
Thank you very much