Twill Brain

#1057 [Bug]: Review of the transaction table

2 min read

#1057 — [Bug]: Review of the transaction table

Repo: Twill-AI/facade State: closed | Status: done Assignee: Ahmad1809, sparsh-twillpayments

Created: 2026-02-24 · Updated: 2026-03-11

Description

Steps to reproduce

Please check within the transaction table:

  • batch_id
  • status
  • terminal_id
  • card_type

Please also check the mentioned merchant_ids especially the one included in the description and images for which we dont have statuses(pending) and for some we dont have batch_id etc

Expected behavior

  • clear status on all transactions (the transactions that we have data for in Luqra)
  • correct terminal id
  • batch_id
  • reason for a failed transaction
  • card_type
  • Separate transaction table and authorization table, mirroring what is available in Luqra

Actual behavior

we are not getting the correct statuses, batch_id, terminal_id and card_type for some transactions from Luqra (please check ems ones too). The statuses are crucial to calculating some of the kpis and we need to get have them. after checking the Luqra website I noticed we have some data there within authorization table that we probably are not ingesting, for example

Image

The terminal ids in the authorization table is 1994 for the merchant but we have multiple values for it in our database. Also, card_type is not available or being set to other for some merchants.

batch id seems to be null for some of the transactions, although they are batched and settled already in Luqra for multiple days.

In addition, in Luqra we have the reasons for a failed transactions wh

Notes

Add implementation notes, blockers, and context here

Add wikilinks to related people, meetings, or other tickets

Graph View