from which table ,i ll get both the invoice and cleared amount ???

Hi Friends,

i am making a report for my sales client where finance part is also required.

the requirement is : the sales people want know the status of the invoice generated at their end.the report shud be like if they enter the invoice no,fiscal year and coustomer they will be able to see the status of the invoice.how much pmt has received for that particular invoice,wheather it is open or fully cleared?

From which table i can get both invoice no. and the payment/pmts rerceived against that invoce/invoices.

plz guide.

Regards,

Biswa