Insights Data Catalog

Mambu Insights turns your core banking data into a set of analytics ready data products. Each product is a table in your data lake, refreshed by the Mambu Insights pipeline and shaped to match the Mambu API, so the fields are the ones you already know.

This catalog lists every product, what it holds, why you would use it, and the fields it exposes. Products are grouped by domain.

Catalog version

This page reflects catalog version 1.1, published on 15 October 2026.

How to read this catalog

Each product section starts with a short description of what the product holds and why it matters, followed by a table of its top level fields.

Type is either the value's data type (text, whole number, decimal, number, true / false, timestamp, date, map, binary) or, for a field that contains others, object or list of objects. Where a field contains others, they are listed directly beneath it with their own types, prefixed with └─.

One type distinction matters for dates. A date shown as text has been normalized: it is an ISO 8601 string carrying your organization's offset. A date shown as timestamp has not been normalized, and you will see it paired with the marker See timezone note. The type tells you which you are getting.

A small number of fields have no type listed. Those are computed values whose type could not be determined from the pipeline definition alone. Ask your Mambu contact before building against one.

Where a field's description is blank, the field is available in the data but its description is still being authored.

Dates and time zones

Two conventions are in play, and the Notes column of each table tells you which applies to a date field.

Marker	Meaning
UTC	An audit timestamp: when something was recorded in the system.
Organization time	A business date: the date the event belongs to in your operating calendar.
See timezone note	This product does not yet normalize its dates. See the known limitations below.

Both normalized conventions render in ISO 8601 carrying your organization's offset, for example 2024-03-20T14:45:30+02:00. This is a numeric offset rather than a trailing Z, unless your organization's time zone is UTC. Timestamps are precise to the second.

Known limitations

Some products do not yet normalize their date fields to your organization's time zone. Where a field is marked See timezone note, treat the value as a local wall clock reading rather than a UTC instant, and confirm the intended interpretation with your Mambu contact before using it in a calculation that crosses midnight or a reporting boundary. This is being addressed, and the affected fields are marked throughout.

Core banking

Activity Log

Every action a client, teller, or system performs, such as logins, transactions, adjustments, and approvals, indexed to who did it and when.

Why it matters. The audit trail behind every operational review, dispute investigation, and regulator inquiry, with every event tied back to a specific person and moment.

Tags: activity-log, audit, operations

Field	Type	Description	Notes
encodedKey	text	Unique, system-generated identifier for the record.
transactionID	whole number
timestamp	timestamp
type	text	Record type.
notes	text	Free-text notes captured against the record.
userKey	text	User who performed the action.
assignedUserKey	text	User the record is assigned to.
branchKey	text	Branch reference.
clientKey	text	Client reference.
groupKey	text	Group reference.
centreKey	text
loanAccountKey	text
loanProductKey	text
savingsAccountKey	text
savingsProductKey	text
lineOfCreditKey	text
taskKey	text
glAccountKey	text
glAccountsClosureKey	text
assignedCentreKey	text	Centre the record is assigned to.
entityKey	text
entityType	text
parentKey	text
fieldChangeName	text
fieldChanges	list of objects, 6 fields
└─ id	whole number	Human-readable business identifier.
└─ fieldChangeName	text
└─ fieldDetailName	text
└─ fieldDetailKey	text
└─ originalValue	text
└─ newValue	text

Branch Directory

Every physical and virtual branch on the bank's operating map, with its open/closed state, region, and reporting hierarchy.

Why it matters. The organisational anchor for branch-level P&L, teller-limit control, and regional supervisory returns.

Tags: branch-network, organisation, reporting

Field	Type	Description	Notes
encodedKey	text	Unique, system-generated identifier for the record.
name	text	Display name.
creationDate	timestamp	When the record was created.	See timezone note
emailAddress	text	Email address on record.
id	text	Human-readable business identifier.
lastModifiedDate	timestamp	When the record was last changed.	See timezone note
notes	text	Free-text notes captured against the record.
phoneNumber	text
state	text	Current lifecycle state.
addresses	list of objects, 11 fields	Postal addresses held against the record.
└─ city	text
└─ country	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ indexInList	whole number
└─ latitude	decimal
└─ line1	text
└─ line2	text
└─ longitude	decimal
└─ parentKey	text
└─ postcode	text
└─ region	text
branchHolidays	list of objects, 6 fields
└─ creationDate	timestamp	When the record was created.
└─ date	whole number
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ id	whole number	Human-readable business identifier.
└─ isAnnuallyRecurring	true / false
└─ name	text	Display name.

Client Groups

The customer group hierarchy the bank tracks for exposure aggregation: related parties, connected corporates, and household groupings.

Why it matters. The connected-party lens for single-obligor limits, group-level arrears roll-ups, and beneficial-owner reviews.

Tags: connected-parties, exposure-limits, groups

Custom fields

This product also carries one additional column for each custom field set configured in your tenant, named after that set. Because they depend on your configuration, they are not listed here. Query the table to see the ones that apply to you.

Field	Type	Description	Notes
encodedKey	text	Unique, system-generated identifier for the record.
assignedBranchKey	text	Branch the record is assigned to.
assignedCentreKey	text	Centre the record is assigned to.
assignedUserKey	text	User the record is assigned to.
creationDate	timestamp	When the record was created.	See timezone note
emailAddress	text	Email address on record.
id	text	Human-readable business identifier.
lastModifiedDate	timestamp	When the record was last changed.	See timezone note
loanCycle	whole number	Number of loans completed to date.
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
homePhone	text	Home telephone number.
mobilePhone	text	Mobile telephone number.
notes	text	Free-text notes captured against the record.
preferredLanguage	text	Preferred language for correspondence.
groupName	text
groupRoleKey	text
addresses	list of objects, 11 fields	Postal addresses held against the record.
└─ city	text
└─ country	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ indexInList	whole number
└─ latitude	decimal
└─ line1	text
└─ line2	text
└─ longitude	decimal
└─ parentKey	text
└─ postcode	text
└─ region	text
groupMembers	list of objects, 2 fields
└─ clientKey	text	Client reference.
└─ roles
customFields	list of objects, 4 fields	Tenant-defined custom field values.
└─ fieldKey	text
└─ fieldId	text
└─ fieldName	text
└─ fieldValue	text

Client Master

Every retail, SME, and corporate customer on the bank's books, with identity, status, KYC state, and the accounts and products each one holds.

Why it matters. The customer 360 view that feeds KYC refreshes, suspicious-activity reviews, and relationship-manager targeting.

Tags: customer, kyc, onboarding

Custom fields

This product also carries one additional column for each custom field set configured in your tenant, named after that set. Because they depend on your configuration, they are not listed here. Query the table to see the ones that apply to you.

Field	Type	Description	Notes
activationDate	text	When the record became active.	Organization time
addresses	list of objects, 11 fields	Postal addresses held against the record.
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ line1	text
└─ line2	text
└─ city	text
└─ region	text
└─ postcode	text
└─ country	text
└─ indexInList	whole number
└─ latitude	decimal
└─ longitude	decimal
└─ parentKey	text
approvedDate	text	When the record was approved.	Organization time
assignedBranchKey	text	Branch the record is assigned to.
assignedCentreKey	text	Centre the record is assigned to.
assignedUserKey	text	User the record is assigned to.
birthDate	text	Date of birth.	Organization time
clientRoleKey	text
closedDate	text	When the record was closed.	Organization time
creationDate	text	When the record was created.	UTC
emailAddress	text	Email address on record.
encodedKey	text	Unique, system-generated identifier for the record.
firstName	text	Given name.
gender	text	Recorded gender.
groupKeys	list
groupLoanCycle	whole number	Number of group loans completed to date.
homePhone	text	Home telephone number.
id	text	Human-readable business identifier.
idDocuments	list of objects, 7 fields
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ documentId	text
└─ documentType	text
└─ indexInList	whole number
└─ issuingAuthority	text
└─ validUntil	timestamp
└─ identificationDocumentTemplateKey	text
lastModifiedDate	text	When the record was last changed.	UTC
lastName	text	Family name.
loanCycle	whole number	Number of loans completed to date.
middleName	text	Middle name.
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
mobilePhone	text	Mobile telephone number.
mobilePhone2	text
notes	text	Free-text notes captured against the record.
preferredLanguage	text	Preferred language for correspondence.
profilePictureKey	text
profileSignatureKey	text
state	text	Current lifecycle state.

Credit Arrangements

The umbrella facility a customer holds: the master line under which one or more loans, overdrafts, or revolving lines draw down and repay.

Why it matters. The credit-limit view for single-obligor exposure limits, arrears aggregation, and IFRS 9 group-level staging.

Tags: credit-facility, exposure, ifrs9

Field	Type	Description	Notes
amount	decimal	Monetary amount.
approvedDate	timestamp	When the record was approved.	See timezone note
availableCreditAmount
closedData	timestamp	When the record was closed. (Field name spelled “closedData” in the current release.)	See timezone note
consumedCreditAmount
creationDate	timestamp	When the record was created.	See timezone note
currency	object, 1 fields	Currency the amount is expressed in.
└─ currencyCode	text	ISO currency code.
encodedKey	text	Unique, system-generated identifier for the record.
expireDate	timestamp		See timezone note
exposureLimitType	text
holderKey
holderType
id	text	Human-readable business identifier.
lastModifiedDate	timestamp	When the record was last changed.	See timezone note
notes	text	Free-text notes captured against the record.
startDate	timestamp		See timezone note
state	text	Current lifecycle state.
subState	text	Additional lifecycle qualifier, where one applies.
customFields	list of objects, 3 fields	Tenant-defined custom field values.
└─ fieldKey
└─ fieldName
└─ fieldValue

Deposit Accounts

Every current, savings, and term deposit a customer holds, with balance, status, product, and interest state.

Why it matters. The liability book behind daily balance-sheet reporting, deposit-guarantee returns, and interest accrual.

Tags: deposits, liability-book, balances

Custom fields

This product also carries one additional column for each custom field set configured in your tenant, named after that set. Because they depend on your configuration, they are not listed here. Query the table to see the ones that apply to you.

Field	Type	Description	Notes
accountHolderKey	text	Client or group that holds the account.
accountHolderType	text	Whether the account is held by a client or a group.
accountState	text
accountType	text
accruedAmounts	object, 4 fields
└─ interestAccrued	decimal
└─ negativeInterestAccrued	decimal
└─ overdraftInterestAccrued	decimal
└─ technicalOverdraftInterestAccrued	decimal
activationDate	text	When the record became active.	Organization time
approvedDate	text	When the record was approved.	Organization time
assignedBranchKey	text	Branch the record is assigned to.
assignedCentreKey	text	Centre the record is assigned to.
balance	decimal
assignedUserKey	text	User the record is assigned to.
balances	object, 10 fields	Balance breakdown for the account.
└─ blockedBalance	decimal
└─ feesDue	decimal
└─ forwardAvailableBalance	decimal
└─ holdBalance	decimal
└─ lockedBalance	decimal
└─ overdraftAmount	decimal
└─ overdraftInterestDue	decimal
└─ technicalOverdraftAmount	decimal
└─ technicalOverdraftInterestDue	decimal
└─ totalBalance	decimal
closedDate	text	When the record was closed.	Organization time
creationDate	text	When the record was created.	UTC
creditArrangementKey	text
currencyCode	text	ISO currency code.
encodedKey	text	Unique, system-generated identifier for the record.
id	text	Human-readable business identifier.
interestSettings	list of objects, 2 fields
└─ interestPaymentSettings	text
└─ interestRateSettings
internalControls	object, 4 fields
└─ maxdepositbalance	decimal
└─ maxwithdrawalamount	decimal
└─ recommendedDepositAmount	decimal
└─ targetAmount	decimal
lastAccountAppraisalDate	text		Organization time
lastInterestCalculationDate	text		Organization time
lastInterestReviewDate	text		Organization time
lastInterestStoredDate	text		Organization time
lastModifiedDate	text	When the record was last changed.	UTC
lastOverdraftInterestReviewDate	text		Organization time
lastSetToArrearsDate	text		Organization time
lockedDate	text		Organization time
maturityDate	text	Contractual maturity date.	Organization time
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
name	text	Display name.
notes	text	Free-text notes captured against the record.
overdraftInterestSettings	object, 1 fields
└─ interestRateSettings
overdraftSettings	object, 3 fields
└─ allowOverdraft	true / false
└─ overdraftExpiryDate	text
└─ overdraftLimit	decimal
productTypeKey	text	Product the account was opened under.
withholdingTaxSourceKey	text
customFields		Tenant-defined custom field values.

Deposit Products

The bank's deposit product catalogue (savings, current, and term) with pricing, tiers, and eligibility rules.

Why it matters. The reference layer for product P&L, price benchmarking, and shelf reviews.

Tags: product-catalogue, deposits, pricing

Field	Type	Description	Notes
customFields	list of objects, 3 fields	Tenant-defined custom field values.
└─ fieldKey
└─ fieldName
└─ fieldValue
encodedKey	object, 1 fields	Unique, system-generated identifier for the record.
└─ encodedKey		Unique, system-generated identifier for the record.
id	text	Human-readable business identifier.
name	text	Display name.
creationDate	timestamp	When the record was created.	UTC
lastModifiedDate	timestamp	When the record was last changed.	UTC
notes	text	Free-text notes captured against the record.
type	text	Record type.
category	text
state	true / false	Current lifecycle state.
accountingSettings	object, 4 fields
└─ accountingMethod	text
└─ interestAccrualCalculation	text
└─ interestAccruedAccountingMethod	text
└─ accountingRules
availabilitySettings	list of objects, 2 fields
└─ availableFor	true / false
└─ branchSettings	true / false
currencySettings	object, 1 fields
└─ currencies
feesSettings	object, 2 fields
└─ allowArbitraryFees	true / false
└─ fees
interestSettings	object, 9 fields
└─ collectInterestWhenLocked	true / false
└─ daysInYear	text
└─ interestCalculationBalance	text
└─ interestGainsProvidedStartDate	timestamp
└─ interestGainsProvidedEndDate	timestamp
└─ interestPaidIntoAccount	true / false
└─ interestPaymentSettings	binary
└─ interestRateSettings
└─ maximumBalance	decimal
internalControls	object, 4 fields
└─ dormancyPeriodDays	whole number
└─ maxWithdrawalAmount	decimal
└─ openingBalance	decimal
└─ recommendedDepositAmount	decimal
maturitySettings	object, 2 fields
└─ maturityPeriod	whole number
└─ maturityPeriodUnit	text
newAccountSettings	object, 2 fields
└─ idGeneratorType	text
└─ idPattern	text
offsetSettings	object, 1 fields
└─ allowOffset	true / false
overdraftInterestSettings	object, 3 fields
└─ daysInYear	text
└─ interestCalculationBalance	text
└─ interestRateSettings	text
overdraftSettings	object, 3 fields
└─ allowOverdraft	true / false
└─ allowTechnicalOverdraft	true / false
└─ maxOverdraftLimit	decimal
taxSettings	object, 1 fields
└─ withholdingTaxEnabled	true / false

Deposit Transactions

Every deposit account movement, including top-ups, withdrawals, fees, and interest postings, with the counterparty and channel captured.

Why it matters. The transactional feed for AML monitoring, channel-mix reporting, and daily fee-income roll-up.

Tags: transactions, aml, fee-income

Custom fields

This product also carries one additional column for each custom field set configured in your tenant, named after that set. Because they depend on your configuration, they are not listed here. Query the table to see the ones that apply to you.

Field	Type	Description	Notes
customFields	list of objects, 3 fields	Tenant-defined custom field values.
└─ fieldKey
└─ fieldName
└─ fieldValue
accountBalances	object, 1 fields
└─ totalBalance	decimal
adjustmentTransactionKey	text
affectedAmounts	object, 9 fields
└─ feesAmount	decimal
└─ fractionAmount	decimal
└─ fundsAmount	decimal
└─ interestAmount	decimal
└─ overdraftAmount	decimal
└─ overdraftFeesAmount	decimal
└─ overdraftInterestAmount	decimal
└─ technicalOverdraftAmount	decimal
└─ technicalOverdraftInterestAmount	decimal
amount	decimal	Monetary amount.
branchKey	text	Branch reference.
cardTransaction	object, 9 fields
└─ advice	true / false
└─ amount	decimal	Monetary amount.
└─ cardAcceptor	text
└─ cardToken	text
└─ currencyCode	text	ISO currency code.
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ externalAuthorizationReferenceId	text
└─ externalReferenceId	text
└─ userTransactionTime	text
centreKey	text
creationDate	text	When the record was created.	UTC
currencyCode	text	ISO currency code.
encodedKey	text	Unique, system-generated identifier for the record.
externalId	text	Identifier supplied by an external system.
fees
holdExternalReferenceId	text
id	whole number	Human-readable business identifier.
interestAccruedAmounts	object, 4 fields
└─ interestAccrued	decimal
└─ negativeInterestAccrued	decimal
└─ overdraftInterestAccrued	decimal
└─ technicalOverdraftInterestAccrued	decimal
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
notes	text	Free-text notes captured against the record.
parentAccountKey	text	Parent account reference.
paymentDetails	object, 9 fields
└─ creditor	text
└─ creditorAccount	text
└─ creditorAgent	text
└─ debtor	text
└─ debtorAccount	text
└─ debtorAgent	text
└─ paymentIdentfication	text
└─ paymentTypeInformation	text
└─ remittanceInformation	text
paymentOrderId	text
taxes	object, 1 fields
└─ taxRate
terms	object, 3 fields
└─ interestSettings	decimal
└─ overdraftInterestSettings	decimal
└─ overdraftSettings	decimal
tillKey	text
transactionDetails	object, 2 fields
└─ transactionChannelId	text
└─ transactionChannelKey	text
transferDetails	object, 2 fields	Links to the matching transaction on the other side of a transfer.
└─ linkedDepositTransactionKey	text	The deposit transaction on the other side of the transfer.
└─ linkedLoandTransactionKey	text	The loan transaction on the other side of the transfer. (Field name spelled “linkedLoandTransactionKey” in the current release.)
type	text	Record type.
userKey	text	User who performed the action.
valueDate	text	Business date on which the entry takes effect.	Organization time

General Ledger Accounts

Every general-ledger account on the bank's chart of accounts, with its posting rules and current closing state.

Why it matters. The chart of accounts that anchors financial close, regulatory returns, and management P&L.

Tags: general-ledger, chart-of-accounts, financial-close

Field	Type	Description	Notes
activated	true / false
allowManualJournalEntries	true / false
balance	decimal
creationDate	timestamp	When the record was created.	See timezone note
currency	object, 2 fields	Currency the amount is expressed in.
└─ code	text
└─ currencyCode	text	ISO currency code.
description	text
encodedKey	text	Unique, system-generated identifier for the record.
glCode	text	General ledger account code.
lastModifiedDate	timestamp	When the record was last changed.	See timezone note
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
name	text	Display name.
stripTrailingZeros	true / false
type	text	Record type.
usage	text

General Ledger Daily Summary

The daily balance and turnover of every GL account, rolled up from the underlying postings.

Why it matters. The one-row-per-account-per-day feed that drives balance-sheet, trial-balance, and regulatory-report generation without re-scanning the full journal.

Tags: general-ledger, trial-balance, reporting

Field	Type	Description	Notes
balance
assignedBranchKey		Branch the record is assigned to.
bookingDate	text	Date the entry was booked to the ledger.	Organization time
creationDate	text	When the record was created.	UTC
encodedKey		Unique, system-generated identifier for the record.
foreignBalance
glAccount	object, 14 fields	The general ledger account the entry posts to.
└─ activated
└─ allowManualJournalEntries
└─ balance
└─ creationDate	text	When the record was created.
└─ currency		Currency the amount is expressed in.
└─ description
└─ encodedKey		Unique, system-generated identifier for the record.
└─ glCode		General ledger account code.
└─ lastModifiedDate	text	When the record was last changed.
└─ migrationEventKey		Reference to the data-migration event that created the record, where it was migrated.
└─ name		Display name.
└─ stripTrailingZeros
└─ type		Record type.
└─ usage
type		Record type.

General Ledger Journal Entries

Every general ledger posting generated by the bank's activity, the raw material of financial close and audit.

Why it matters. The line-level ledger that finance uses to explain movements between period-ends and that internal audit tests during controls work.

Tags: general-ledger, financial-close, audit

Field	Type	Description	Notes
accountKey		Account reference.
amount		Monetary amount.
assignedBranchKey		Branch the record is assigned to.
bookingDate	text	Date the entry was booked to the ledger.	Organization time
creationDate	text	When the record was created.	UTC
encodedKey		Unique, system-generated identifier for the record.
entryID
foreignAmount	object, 3 fields
└─ accountingRate	text
└─ amount		Monetary amount.
└─ currency		Currency the amount is expressed in.
glAccount	object, 14 fields	The general ledger account the entry posts to.
└─ activated
└─ allowManualJournalEntries
└─ balance
└─ creationDate	text	When the record was created.
└─ currency		Currency the amount is expressed in.
└─ description
└─ encodedKey		Unique, system-generated identifier for the record.
└─ glCode		General ledger account code.
└─ lastModifiedDate	text	When the record was last changed.
└─ migrationEventKey		Reference to the data-migration event that created the record, where it was migrated.
└─ name		Display name.
└─ stripTrailingZeros
└─ type		Record type.
└─ usage
notes		Free-text notes captured against the record.
productKey
productType
reversalEntryKey
transactionId		Identifier grouping related ledger entries.
type		Record type.
userKey		User who performed the action.

Interest Accrual Breakdown

Why it matters. >-

Tags: accounting, interest, general-ledger

Field	Type	Description	Notes
accountId
accountKey		Account reference.
accrualType
amount		Monetary amount.
bookingDate	text	Date the entry was booked to the ledger.	Organization time
branchKey		Branch reference.
branchName
creationDate	text	When the record was created.	UTC
entryId
entryType
foreignAmount	object, 3 fields
└─ accountingRate	text
└─ amount		Monetary amount.
└─ currency		Currency the amount is expressed in.
glAccountId
glAccountKey
glAccountName
glAccountType
parentEntryId
productId
productKey
productType
transactionId		Identifier grouping related ledger entries.

Loan Accounts

Every loan a customer holds, with the current balance, arrears state, interest terms, and stage under the credit loss policy.

Why it matters. The core asset book behind arrears reporting, IFRS 9 staging, and portfolio-quality reviews.

Tags: loans, arrears, ifrs9

Custom fields

This product also carries one additional column for each custom field set configured in your tenant, named after that set. Because they depend on your configuration, they are not listed here. Query the table to see the ones that apply to you.

Field	Type	Description	Notes
customFields		Tenant-defined custom field values.
accountArrearsSettings	object, 8 fields
└─ dateCalculationMethod	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ monthlyToleranceDay	whole number
└─ nonWorkingDaysMethod	text
└─ toleranceCalculationMethod	text
└─ toleranceFloorAmount	decimal
└─ tolerancePercentageOfOutstandingPrincipal	decimal
└─ tolerancePeriod	whole number
accountHolderKey	text	Client or group that holds the account.
accountHolderType	text	Whether the account is held by a client or a group.
accountState	text
accountSubState	text
accruedInterest	decimal
accruedPenalty	decimal
activationTransactionKey	text
allowOffset	true / false
approvedDate	text	When the record was approved.	Organization time
arrearsTolerancePeriod	whole number
assets	list of objects, 8 fields
└─ amount	decimal	Monetary amount.
└─ assetName	text
└─ depositAccountKey	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ guarantorKey	text
└─ guarantorType	text
└─ originalAmount	decimal
└─ originalCurrency	text
assignedBranchKey	text	Branch the record is assigned to.
assignedCentreKey	text	Centre the record is assigned to.
assignedUserKey	text	User the record is assigned to.
balances	object, 17 fields	Balance breakdown for the account.
└─ feesBalance	decimal
└─ feesDue	decimal
└─ feesPaid	decimal
└─ holdBalance	decimal
└─ interestBalance	decimal
└─ interestDue	decimal
└─ interestPaid	decimal
└─ interestFromArrearsBalance	decimal
└─ interestFromArrearsDue	decimal
└─ interestFromArrearsPaid	decimal
└─ penaltyBalance	decimal
└─ penaltyDue	decimal
└─ penaltyPaid	decimal
└─ principalBalance	decimal
└─ principalDue	decimal
└─ principalPaid	decimal
└─ redrawBalance	decimal
closedDate	text	When the record was closed.	Organization time
creationDate	text	When the record was created.	UTC
creditArrangementKey	text
currency	object, 1 fields	Currency the amount is expressed in.
└─ code	text
daysInArrears
daysLate
disbursementDetails	object, 6 fields
└─ disbursementDate
└─ encodedKey		Unique, system-generated identifier for the record.
└─ expectedDisbursementDate
└─ fees
└─ firstRepaymentDate
└─ transactionDetails
encodedKey	text	Unique, system-generated identifier for the record.
productTypeKey	text	Product the account was opened under.
fundingSources	list of objects, 9 fields
└─ amount	decimal	Monetary amount.
└─ assetName	text
└─ depositAccountKey	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ guarantorKey	text
└─ guarantorType	text
└─ id	text	Human-readable business identifier.
└─ interestCommission	decimal
└─ sharePercentage	decimal
futurePaymentsAcceptance	text
guarantors	list of objects, 6 fields
└─ amount	decimal	Monetary amount.
└─ assetName	text
└─ depositAccountKey	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ guarantorKey	text
└─ guarantorType	text
id	text	Human-readable business identifier.
interestCommission	decimal
interestFromArrearsAccrued	decimal
accountInterestRateSettings	list of objects, 10 fields
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ indexSourceKey	text
└─ interestRate	decimal
└─ interestRateCeilingValue	decimal
└─ interestRateFloorValue	decimal
└─ interestRateReviewCount	whole number
└─ interestRateReviewUnit	text
└─ interestRateSource	text
└─ interestSpread	decimal
└─ validFrom	timestamp
interestSettings	object, 11 fields
└─ accrueInterestAfterMaturity	true / false
└─ accrueLateInterest	true / false
└─ interestApplicationMethod	text
└─ interestBalanceCalculationMethod	text
└─ interestCalculationMethod	text
└─ interestChargeFrequency	text
└─ interestRate	decimal
└─ interestRateReviewCount	whole number
└─ interestRateSource	text
└─ interestSpread	decimal
└─ interestType	text
lastAccountAppraisalDate	text		Organization time
lastInterestAppliedDate	text		Organization time
lastInterestReviewDate	text		Organization time
lastLockedDate	text		Organization time
lastModifiedDate	text	When the record was last changed.	UTC
lastSetToArrearsDate	text		Organization time
lastTaxRateReviewDate	text		Organization time
latePaymentsRecalculationMethod	text
loanAmount	decimal
loanName	text
lockedOperations	binary
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
notes	text	Free-text notes captured against the record.
originalAccountKey	text
paymentMethod	text
scheduleSettings	list of objects, 14 fields
└─ principalRepaymentInterval	whole number
└─ gracePeriod	whole number
└─ gracePeriodType	text
└─ repaymentInstallments	whole number
└─ repaymentPeriodCount	whole number
└─ scheduleDueDatesMethod	text
└─ periodicPayment	decimal
└─ repaymentPeriodUnit	text
└─ repaymentScheduleMethod	text
└─ interestApplicationDays	text
└─ hasCustomSchedule	true / false
└─ defaultFirstRepaymentDueDateOffset	whole number
└─ fixedDaysOfMonth	list
└─ paymentPlan	list
penaltySettings	object, 2 fields
└─ loanPenaltyCalculationMethod	text
└─ penaltyRate	decimal

Loan Products

The bank's lending product catalogue (personal, mortgage, SME, and revolving) with terms, pricing tiers, and eligibility rules.

Why it matters. The reference layer for loan-book product mix, pricing reviews, and new-product approval evidence.

Tags: product-catalogue, lending, pricing

Field	Type	Description	Notes
accountLinkSettings	object, 4 fields
└─ enabled	true / false
└─ linkableDepositProductKey	text
└─ linkedAccountOptions	true / false
└─ settlementMethod	text
accountingSettings	object, 4 fields
└─ accountingMethod	text
└─ accountingRules
└─ interestAccrualCalculation	text
└─ interestAccruedAccountingMethod	text
allowCustomRepaymentAllocation	true / false
arrearsSettings	object, 8 fields
└─ dateCalculationMethod	text
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ monthlyToleranceDay	whole number
└─ nonWorkingDaysMethod	text
└─ toleranceCalculationMethod	text
└─ toleranceFloorAmount	decimal
└─ tolerancePercentageOfOutstandingPrincipal	decimal
└─ tolerancePeriod	whole number
availabilitySettings
category	text
creationDate	timestamp	When the record was created.	See timezone note
creditArrangementRequirement	text
currency	text	Currency the amount is expressed in.
encodedKey	text	Unique, system-generated identifier for the record.
feesSettings	object, 2 fields
└─ allowArbitraryFees	true / false
└─ fees
fundingSettings	object, 6 fields
└─ enabled	true / false
└─ funderInterestCommission
└─ funderInterestCommissionAllocationType	text
└─ lockFundsAtApproval	true / false
└─ organizationInterestCommission
└─ requiredFunds	decimal
gracePeriodSettings	object, 2 fields
└─ gracePeriod	whole number
└─ gracePeriodType	text
id	text	Human-readable business identifier.
interestSettings	object, 11 fields
└─ accrueLateInterest	true / false
└─ compoundingFrequency	text
└─ daysInYear	text
└─ indexRateSettings	true / false
└─ interestApplicationDays	text
└─ interestApplicationMethod	text
└─ interestBalanceCalculationMethod	text
└─ interestCalculationMethod	text
└─ interestType	text
└─ pmtAdjustmentThreshold	text
└─ scheduleInterestDaysCountMethod	text
internalControls	object, 3 fields
└─ dormancyPeriodDays	whole number
└─ fourEyesPrinciple	true / false
└─ lockSettings	text
lastModifiedDate	timestamp	When the record was last changed.	See timezone note
loanAmountSettings	object, 6 fields
└─ defaultValue	decimal
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ maxValue	decimal
└─ minValue	decimal
└─ loanAmount	true / false
└─ trancheSettings	whole number
name	text	Display name.
newAccountSettings	object, 3 fields
└─ accountInitialState	text
└─ idGeneratorType	text
└─ idPattern	text
notes	text	Free-text notes captured against the record.
paymentSettings	object, 14 fields
└─ amortizationMethod	text
└─ latePaymentRecalculationMethod	text
└─ paymentMethod	text
└─ prepaymentSettings	text
└─ principalPaymentSettings	decimal
└─ defaultPrincipalRepaymentInterval	whole number
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ includeFeesInFloorAmount	true / false
└─ includeInterestInFloorAmount	true / false
└─ percentage	decimal
└─ principalCeilingValue	decimal
└─ principalFloorValue	decimal
└─ principalPaymentMethod	text
└─ repaymentAllocationOrder	binary
penaltySettings	object, 2 fields
└─ loanPenaltyCalculationMethod	text
└─ penaltyRate	decimal
redrawSettings	object, 1 fields
└─ allowRedraw	true / false
scheduleSettings	object, 11 fields
└─ defaultRepaymentPeriodCount	whole number
└─ firstRepaymentDueDateOffset	decimal
└─ fixedDaysOfMonth	binary
└─ numInstallments	whole number
└─ repaymentPeriodUnit	text
└─ repaymentReschedulingMethod	text
└─ repaymentScheduleEditOptions	binary
└─ repaymentScheduleMethod	text
└─ roundingSettings	text
└─ scheduleDueDatesMethod	text
└─ shortMonthHandlingMethod	text
securitySettings	object, 3 fields
└─ isCollateralEnabled	true / false
└─ isGuarantorsEnabled	true / false
└─ requiredGuaranties	decimal
status
taxSettings	object, 5 fields
└─ taxCalculationMethod	text
└─ taxSourceKey	text
└─ taxesOnFeesEnabled	true / false
└─ taxesOnInterestEnabled	true / false
└─ taxesOnPenaltyEnabled	true / false
type	text	Record type.

Loan Repayment Schedules

The instalment plan for every loan: due dates, expected principal and interest, and per instalment settlement state.

Why it matters. The projected-cashflow view behind arrears aging, collections queues, and forward-cashflow modelling.

Tags: repayment-schedule, arrears, collections

Field	Type	Description	Notes
loanAccountKey
currency	object, 2 fields	Currency the amount is expressed in.
└─ code
└─ currencyCode		ISO currency code.
installments	list of objects, 22 fields
└─ carryForwardInterestSplit
└─ customSettingDetails
└─ dueDate	timestamp
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ expectedClosingBalance	decimal
└─ fee	decimal
└─ feeDetails
└─ fundersInterestDue	decimal
└─ interest	decimal
└─ interestAccrued	decimal
└─ isPaymentHoliday
└─ lastPaidDate	timestamp
└─ lastPenaltyAppliedDate	timestamp
└─ nonScheduledPrincipalBalanceOverpayment	decimal
└─ notes	text	Free-text notes captured against the record.
└─ number	text
└─ organizationCommissionDue	decimal
└─ parentAccountKey	text	Parent account reference.
└─ penalty	decimal
└─ principal	decimal
└─ repaidDate	timestamp
└─ state	text	Current lifecycle state.

Loan Transactions

Every loan account movement, including disbursements, repayments, fees, interest capitalisations, and write-offs, with the value date and source captured.

Why it matters. The line-level record behind arrears reconciliation, dispute investigation, and write-off attribution.

Tags: transactions, arrears, write-offs

Field	Type	Description	Notes
accountBalances	object, 6 fields
└─ advancePosition	decimal
└─ arrearsPosition	decimal
└─ expectedPrincipalRedraw	decimal
└─ principalBalance	decimal
└─ redrawBalance	decimal
└─ totalBalance	decimal
adjustmentTransactionKey	text
affectedAmounts	object, 8 fields
└─ deferredInterestAmount	decimal
└─ feesAmount	decimal
└─ fundersInterestAmount	decimal
└─ interestAmount	decimal
└─ interestFromArrearsAmount	decimal
└─ organizationCommissionAmount	decimal
└─ penaltyAmount	decimal
└─ principalAmount	decimal
amount	decimal	Monetary amount.
bookingDate	text	Date the entry was booked to the ledger.	Organization time
branchKey	text	Branch reference.
cardTransaction	object, 8 fields
└─ advice	true / false
└─ amount	decimal	Monetary amount.
└─ cardAcceptor	text
└─ cardToken	text
└─ currencyCode	text	ISO currency code.
└─ encodedKey	text	Unique, system-generated identifier for the record.
└─ externalAuthorizationReferenceId	text
└─ userTransactionTime	text
centreKey	text
creationDate	text	When the record was created.	UTC
currency		Currency the amount is expressed in.
customPaymentAmounts	list of objects, 4 fields
└─ customPaymentAmountType	text
└─ amount	decimal	Monetary amount.
└─ taxOnAmount	decimal
└─ predefinedFeeKey	text
encodedKey	text	Unique, system-generated identifier for the record.
externalId	text	Identifier supplied by an external system.
fees
id	whole number	Human-readable business identifier.
migrationEventKey	text	Reference to the data-migration event that created the record, where it was migrated.
notes	text	Free-text notes captured against the record.
originalAmount	decimal
originalCurrencyCode	text
originalTransactionEncodedKey
parentAccountKey	text	Parent account reference.
parentLoanTransactionKey	text
prepaymentRecalculationMethod	text
taxes	object, 6 fields
└─ deferredTaxOnInterestAmount	decimal
└─ taxOnFeesAmount	decimal
└─ taxOnInterestAmount	decimal
└─ taxOnInterestFromArrearsAmount	decimal
└─ taxOnPenaltyAmount	decimal
└─ taxRate	decimal
terms	object, 4 fields
└─ interestSettings	decimal
└─ periodicPayment	decimal
└─ principalPaymentAmount	decimal
└─ principalPaymentPercentage	decimal
tillKey	text
transactionDetails	object, 2 fields
└─ transactionChannelKey	text
└─ transactionChannelId	text
type	text	Record type.
userKey	text	User who performed the action.
valueDate	text	Business date on which the entry takes effect.	Organization time

System Users

Every bank staff user with access to the core system, with role, department, and current active state.

Why it matters. The access-review roster behind segregation-of-duties checks, joiner-mover-leaver control, and SOX 404 evidence.

Tags: user-access, sod, sox

Field	Type	Description	Notes
access	object, 11 fields
└─ administratorAccess	true / false
└─ apiAccess	true / false
└─ canManageAllBranches	true / false
└─ canManageEntitiesAssignedToOtherOfficers	true / false
└─ creditOfficerAccess	true / false
└─ deliveryAccess	true / false
└─ mambuAccess	true / false
└─ managedBranches	list
└─ permissions	list
└─ supportAccess	true / false
└─ tellerAccess	true / false
assignedBranchKey	text	Branch the record is assigned to.
creationDate	text	When the record was created.	UTC
email	text
encodedKey	text	Unique, system-generated identifier for the record.
firstName	text	Given name.
homePhone	text	Home telephone number.
id	text	Human-readable business identifier.
language	text
lastLoggedInDate	text		UTC
lastModifiedDate	text	When the record was last changed.	UTC
lastName	text	Family name.
mobilePhone	text	Mobile telephone number.
notes	text	Free-text notes captured against the record.
role	object, 2 fields
└─ encodedKey		Unique, system-generated identifier for the record.
└─ id		Human-readable business identifier.
title	text
transactionLimits	map
twoFactorAuthentication	true / false
userState	text
username	text	Username of the person who performed the action.
customFields	map	Tenant-defined custom field values.

UF Daily Readjustment Accrual

Daily UF-indexed balance and the CLP readjustment accrual for every Chilean UF-indexed savings account, computed under Banco Estado's readjustment rules.

Why it matters. The daily line-level record Chilean banks with UF-indexed deposit portfolios need to post the CLP readjustment into the ledger, and to defend the accrual to auditors and the supervisor.

Tags: inflation-indexed, accrual, deposits

info

The field list for this product is assembled dynamically at run time and cannot be listed statically. Contact your Mambu representative for the field list.

Payments

Payments ↔ Core Banking Reconciliation

Matches every incoming and outgoing payment to the customer account it settled against, with the reconciliation status on the same row.

Why it matters. Replaces the daily manual match-off and surfaces unlinked payments before they land in the disputes queue.

Tags: payments, reconciliation, operations

Field	Type	Description	Notes
tenant_id	text	Identifier of the tenant the row belongs to.
payment_id	text
payment_type	text
direction	text
amount	decimal	Monetary amount.
currency	text	Currency the amount is expressed in.
payment_status	text
legal_entity_id	text
internal_account_id	text
cbs_account_short_id	text
cbs_account_type	text
cbs_transaction_types	list
link_source	text
cbe_account_encoded_key	text
cbe_account_state	text
reconciliation_status	text
schema_version	whole number	Version of this product's output schema.

Compliance

DORA ICT Incident Detection

Groups related payment failures into DORA Article 17 ICT incidents, each pre-linked to the affected customers and loans.

Why it matters. Turns days of manual triage into a review queue: every incident is pre-classified against the RTS thresholds with the supporting evidence attached.

Tags: DORA, compliance, incidents

Field	Type	Description	Notes
tenant_id	text	Identifier of the tenant the row belongs to.
as_of_date	date	Date the row describes.
incident_id	text
incident_type	text
started_at	timestamp
ended_at	timestamp
detected_at	timestamp
materialised_at	timestamp
duration_minutes	whole number
clients_affected	whole number
economic_impact_eur	decimal
verdict	text
rts_dimensions_active	whole number
rts_dimensions_exceeded	whole number
affected_account_keys	list
event_count	whole number
request_uri_pattern	text
detection_run_id	text
schema_version	whole number	Version of this product's output schema.

Audit

Admin Control Event Candidates

Flags privileged admin actions, such as unapproved write-offs, manual GL adjustments, and fee waivers, that may breach segregation of duties controls.

Why it matters. Gives internal audit a daily worklist of segregation of duties exceptions, the raw material for SOX 404 and RCSA control testing.

Tags: audit, sod, controls

Field	Type	Description	Notes
tenant_id	text	Identifier of the tenant the row belongs to.
as_of_date	date	Date the row describes.
event_id	text
schema_version	whole number	Version of this product's output schema.
event_type	text
kri_id	text
occurred_at	timestamp	When the underlying event happened.
username	text	Username of the person who performed the action.
user_role	text
severity	text
amount_eur	number
cbe_entity_key	text
cbe_entity_type	text
transaction_id	text
gl_account_codes	list
gl_account_name	text
gl_account_type	text
provenance	object, 2 fields
└─ source_versions	map
└─ computed_at	timestamp
context	map

Risk

NPL-Ratio KRI (Daily Drift)

Tracks the portfolio Non-Performing Loan ratio every day and flags 30-day drift (green / amber / red) against your policy thresholds.

Why it matters. Gives the CRO an early warning signal on portfolio credit quality drift, weeks before it lands in the month end reporting cycle.

Tags: risk, kri, credit

Field	Type	Description	Notes
tenant_id	text	Identifier of the tenant the row belongs to.
kri_id	text
as_of_date	date	Date the row describes.
computed_at	timestamp
value	number
threshold	number
status	text
trend_window_days	whole number
trend_data	map
source_version	whole number