Exact Online features a mixed ledger. Using transactions, you can upload completed sales invoices and purchase invoices as long as you considerate there sub-ledger nature. The same holds for the Invantive Control for Excel.
For SQL, you can consult samples like Create an Exact Online Sales Order with Details through REST Calls. Always be cautious because Exact Online has limited features to recover a corrupted company.