I am about to build a data warehouse from an Odoo instance, I am not sure how to track the previous status of the invoices, journals, or leads. I am pulling data from the account.move but it has only the current state. I am looking for another model(table) which has the status change information.
account.move
and crm.lead
has column named message_ids which contains ids of records to mail.messenger
. Each id contains state change related information and other information related to messaging.