is there anyway to get remaining amount on an invoice through suiteql?

In my environment, I can use the

foreignamountunpaid

column on the transactionline table where

mainline = 'T'

select
	tl.foreignamountunpaid

from transaction t
inner join transactionline tl on tl.transaction = t.id and tl.mainline = 'T'

where t.recordtype = 'invoice'
	and t.id = 18833432