Happy Business Starts Here

Highlighted
New Student

Join of data from Account to Invoice to Payment

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

1 REPLY 1
Valued Scholar

Re: Join of data from Account to Invoice to Payment

Via API or Workflow?

 

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