galoy-personal-notes/uif_07_notes.md

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?