API – Billing Tables Relationships

I’ve been working on the most complicated report a client has ever wanted, and finally broke down and made an ERD for the billing tables in Infusionsoft®. Enjoy!

And…

  • RecurringOrder is related to Job in two different ways, and the two different ways are for two different purposes.
  • Invoice is related to Job in two different ways (although the two relationships should ALWAYS generate the same results).
  • RecurringOrder is also JobRecurring, which in the front end is called Subscriptions.
  • Jobs are Orders.