Adding a financial transaction with Invantive SQL

I’m looking for a way to add the invoices as a financial transaction to ExactOnline using Invantive SQL. The invoices are read in from AutoTask and then added to ExactOnline. I understand the select from AutoTask well enough, but not the insert into ExactOnline. How do I do that?

An example for loading Autotask invoices into Exact Online can be found at: