Hello, I have a question regarding SuiteQL and transaction records. We are using SuiteQL to pull Purchase Order (Transaction) data, and we want to pull transactions based on their location, in the UI and REST api I can see the location (as classification, or in the rest object), however when I try to get these transactions through SuiteQL I cant’ seem to find the appropriate field for filtering by location. I think I could possibly join the transaction lines that contain that info, but I am just curious if there is a 1-1 table join I can use to find the location. Just for context for Sales Orders, we were able to join with the salesOrdered table, and filter by location this way. I am just hoping there is a similar path for POs, is there?

You don't need to cross-post

Sorry for crossposting, just was not sure if the SuiteQL channel was active