Core banking system (CBS) side of the transaction report for reconciliation.

Data are collected by backoffice-manager by listening to transaction-processor-manager topics

Unfortunatelly, the transaction snapshot produced by transaction-processor-manager does not contain enough data for reconciliation. That’s we are listening to very many types of messages instead of just one.

Available topics

Schema name

Reconciliation type
[MVP provider(s)]

Transaction type

Service

BankTopUpTransactionOccurredEvent{version}

Cash In [Paynamics]

BANK_TOP_UP

TOP_UP

DebitCardTopUpTransactionOccurredEvent{version}

Cash In [Paynamics]

DEBIT_CARD_TOP_UP

TOP_UP

OTCTopUpTransactionOccurredEvent{version}

Cash In [Paynamics]

OTC_TOP_UP

TOP_UP

EWalletTopUpTransactionOccurredEvent{version}

Cash In [Paynamics]

EWALLET_TOP_UP

TOP_UP

OTCWithdrawalTransactionOccurredEvent{version}

Cash Out [Paynamics]

OTC_WITHDRAWAL
()

WITHDRAWAL

InterbankTransactionOccurredEvent{version}

Cash Out [Paynamics]

INTERBANK
(WITHDRAWAL)

WITHDRAWAL

EWalletTransferTransactionOccurredEvent{version}

Cash Out [Paynamics]

EWALLET_TRANSFER
(WITHDRAWAL)

WITHDRAWAL

IntrabankTransactionOccurredEvent{version}

Internal

INTRABANK

WITHDRAWAL

PocketTransactionOccurredEvent{version}

Internal

POCKET

WITHDRAWAL

BillPaymentTransactionOccurredEvent{version}

Bill Payment [Paynamics, ECPAy]

BILL_PAYMENT

BILL_PAYMENT

(error) ??

Disbursement wallet

(error) ??

Cards

AirtimeLoadTransactionUpdatedEventV1
(not analysed below, what is it?)

(error) ??

AIRTIME_LOAD

DIGITAL_GOODS

Attribute mapping

Avro attribute name

Report attribute name

Source schemas

id

id

all

N/A

transactionType

based on the schema/topic - see table above

N/A

createdAt

based on the time of the event

[referenceNumber]

referenceNumber

to be added SM-6572 - Propagate reference number into transaction history manager To Do

vendor

vendor

all

service

service

all

paynamicsResponseId

paynamicsResponseId

all Paynamics related BankTopUp, OTCTopUp, DebitCardTopUp, EWalletTopUp, Interbank, EWalletTransfer, OTCWithdrawal, BillPayment

parentTransactionId

parentTransactionId

Interbank, EWalletTransfer

tmTransactionId

tmTransactionId

OTCWithdrawal, BillPayment, Interbank, Intrabank, Pocket, EWalletTransfer

referenceNumber

referenceNumber

OTCTopUp, OTCWithdrawal

amount

amount

all

fee

customerFee

all

vendorFee

vendorFee

all

currency

currency

all

senderName

Intrabank

customerId

customerId

all
(OTCWithdrawal has it in customerInfo)
(Interbank/Intrabank/EWalletTransfer have it in senderInfo)

accountId

customerAccountId

all
(OTCWithdrawal has it in customerInfo)
(Interbank/Intrabank/EWalletTransfer have it in senderInfo)

pocketAccountId

Pocket

toPocket

Pocket

paymentRedirectLink

EWalletTopUp

walletType

EWalletTopUp

merchantCode

merchantCode

all

bankTopUpMerchant

merchant

BankTopUp

otcTopUpMerchant

merchant

OTCTopUp

otcWithdrawalMerchant

merchant

OTCWithdrawal

billPaymentDetails

billPaymentDetails

BillPayment

beneficiaryName

otherName

OTCWithdrawal, Intrabank

interbankBeneficiaryDetails

otherName
otherAccountNumber
otherPhoneNumber

Interbank

eWalletTransferBeneficiaryDetails

otherName
otherAccountNumber
otherPhoneNumber

EWalletTransfer

beneficiaryIdentification

otherAccountNumber
otherPhoneNumber

Intrabank

beneficiaryInfo

otherCustomerId
otherAccountId

Intrabank

expiryDate

expiryDate

OTCTopUp, OTCWithdrawal

expectedDate

expectedDate

Interbank, Intrabank, EWalletTransfer

timestamp

OTCWithdrawal

status

status

all

note

note

OTCWithdrawal, Interbank, Intrabank, EWalletTransfer

noteToSelf

noteToSelf

all

Attachments: