I'm trying to understand what are all the tables in lana's backend I need to look at to find transactions.

These are my first candidates:
- `core_deposit_accounts` ( + `_events` + `_rollup` )
- `core_deposits` ( + `_events` + `_rollup` )
- `core_withdrawals` ( + `_events` + `_rollup` )
- sumsub tables for personal details of the 


I would like to perform this flow and find the created data along in the DB:
- Create a customer (`alice@alice.com`)
  - DB: find his ID
  - DB: check that it got a deposit account created
- Make a deposit for his deposit account of 999USD
- Make a withdrawal of 333USD



## Field mapping

---
    null as numeroRegistroBancario, 
    Don't know what's the best ID for this. Should be int but example shows differently. I would put whatever we have then fight it out with UIF.
---
    null as estacionServicio,
    DTO with branch details. hould have hardcoded data for volcano bank HQ.
    - direccionAgencia: Address where the transaction is performed (string)
    - idDepartamento: Municipality based on catalog (string)
    - idMunicipio: Department based on catalog (string)
---
    null as fechaTransaccion,
    I would assume this is the date where we confirm the transactions. I guess that would match the posting date for the accounting book.
---
    null as tipoPersonaA,
    I think this is actually stored in Lana when creating the customer.
---
    null as detallesPersonaA,
    I need to dig into the info we have in Sumsub
---
    null as tipoPersonaB,
    Same as persona A.
---
    null as detallesPersonaB,
    Same as persona B.
---
    null as numeroCuentaPO,
    public id for the deposit account
---
    null as claseCuentaPO,
    Probably some hardcoded value, such as "Cuenta corriente" or the like.
    Applies to the Persona Ordenante (personaA in the above fields).
---
    null as conceptoTransaccionPO,
    In our withdrawals, we can get the reference.
    On a deposit, it must be fetched from... somewhere?
---
    null as valorOtrosMediosElectronicosPO,
    Money amount.
---
    null as numeroProductoPB,
    Somehow appear in Sumsub I guess?
---
    null as claseCuentaPB,
    Somehow appear in Sumsub I guess?
---
    null as montoTransaccionPB,
    Somehow appear in Sumsub I guess?
---
    null as valorMedioElectronicoPB,
    Somehow appear in Sumsub I guess?
---
    null as bancoCuentaDestinatariaPB
    Bank name. Where do we get this from?
---

## Q&A

- Where do we get an integer ID for the accounts to be reported in the transactions?
    - `core_deposit_accounts` has a public id for each account.
- What state should we report?
    - Deposits 

- Reversability
    - Which transactions can be reversed? What are the time limits? How does it get managed accounting wise?