Changing status of SI in database directly?

Long story short I imported several thousands of Sale Invoices from another system and a lot of the statuses are wrong.

What would happen if I changed the status of each using sql queries in the tabSales Invoice table, say from submitted to paid or cancelled. Will that be enough? I suspect that is not the case.

What other tables will need to be altered so that all data is correct in the end?