Payables Invoice Comment - Where does the Comment field reside?

Ann Schlange

We are on prem and need to be able to get to the PayablesInvoiceComment.Comment field within the SQL tables for data integration.  What table does the Comment field reside?  When looking at the PayablesInvoiceComment table itself the field does not exist.

Thanks,

Ann

andy

You need to join the table that stores the nvarchar(max) fields: S$APAPC


You can usually find these tables by searching for the prefix specified in the source LPL of the related business class