Where does one find the vendor bill payment details in the table - like how to work out from the tables that it was a partial payment - what flag tells me this? I am working with the awesome free sql query tool