How do I get the subsidiary value of a transaction in SuiteQL? The only column I see on the transaction table is

tosubsidiary

and the value is null even when the UI and Saved Search confirm that there’s a retrievable value for the subsidiary of the transaction.

Not defending it or anything, but I assume the logic is that on some transactions, subsidiary can be a line field (mostly interco JEs), so in lieu of having different fields for header and line sub, they just put it all at the line.