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.