Heyhey, I'm trying to migrate some scripts to use the sql module for lookups, but I'm struggling to understand how some of this data is structured. Here's the first naive attempt to list customer deposits related to a sales order, but that salesorder field wasn't where I expected to find it:

query.runSuiteQL({
    query: 'SELECT id, paymentmethod FROM transaction WHERE type = ? AND salesorder = ?',
    params: ['CustDep', salesOrderId],
})

thank you! I'll attempt the same then 😁