Join of data from Account to Invoice to Payment

[DHanft]

I am trying to determine how the data is linked to determine the Payment of an Invoice and how it is linked to the Account data?

ie:  AcountNumber > Invoice.AccountNumber, to some id of the Payment data.

This is a urgent need can someone help me by pointing me to the right person or notes to explain this connections of data?

Thanks,

kfschaefer

[bmesa]

Via API or Workflow?

There is an InvoicePayment table, which links Payments to Invoices and both are linked to the Account.