Hi all! can anyone please help troubleshoot my query?

var queryString = `
                SELECT
                    t.entity AS customerId,
                    SUM(t.amountremaining) AS openBalance,
                    t.subsidiary AS subsidiaryId,
                FROM
                    transaction AS t
                JOIN
                    customer AS c ON t.entity = c.id
                WHERE
                    t.status = 'Open' AND t.type IN ('Invoice', 'SalesOrder')
                    AND (c.custentity_laststatementdate IS NULL OR c.custentity_laststatementdate < ADD_MONTHS(CURRENT_DATE, -1))
                GROUP BY
                    t.entity, t.subsidiary
                HAVING
                    SUM(t.amountremaining) > 0
            `;

            // Capture result in log for now
            log.debug('Input Data', query.runSuiteQL({query: queryString}).asMappedResults());

Search error occurred: Field 'amountremaining' for record 'transaction' was not found.
Field 'subsidiary' for record 'transaction' was not found. Reason: NOT_EXPOSED - Field is marked as internal for channel SEARCH