I have this query which pulls vendor credit records and total amount in that credit, linked to specific bills.

select 
	billcredit.id billcreditid,
	billcredit.foreignTotal,
	vendbill.id billid
from 
	transaction billcredit
join
	PreviousTransactionLink link ON billcredit.id = link.nextdoc
join
	transaction vendbill ON vendbill.id=link.previousDoc
where
	vendbill.id in (160135,160236)

Now I need to get amounts applied to these bills, instead of total credit amount. I was trying

AppliedCreditTransactionLineLink

table but it seems it only provides data for fully paid bills. I need it for open and partially paid bills. TIA

This did the trick for me (this can be stripped to fewer fields and tables)

SELECT 
	BillCredit.ID bill_credit_id,
	BillCredit.ForeignTotal bill_credit_total, 
	NTLL.ForeignAmount bill_credit_applied_to_bill,
	Bill.ID bill_id,
FROM 
	NextTransactionLineLink AS NTLL 
INNER JOIN Transaction AS BillCredit
	ON BillCredit.ID = NTLL.NextDoc
INNER JOIN Transaction AS Bill
	ON NTLL.PreviousDoc = Bill.ID
WHERE
	BillCredit.type = 'VendCred' AND
	NTLL.PreviousDoc in (160135,160236)