How to get transaction values for the nominal ledger in ODBC Sage 200 connection.

SUGGESTED

Hi,

i'm new to using sage 200 and have been given access to our ODBC connection to review some of the reporting tables available to us. I'd like to create a connection that allows me to pull nominal transactions but while the table "NLPostedNominalTran" holds every transaction, it does not give any financial values for some reason?

please can someone help me with what other table i may need to join in to get this information?

thanks

Dom