These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Core Banking System
- Data model
The tables behind Core Banking System
Core Banking System ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 15
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Operating scope
Organizations, team members, Users and financial counterparties identify the people and provider relationships involved.
Instruction work
Bank instructions carries the requested movement; instruction accounts states debit and credit account scope; account applications cover provider-authorized account requests.
Provider position
Financial accounts, account snapshots, bank evidence and reconciliation items carry account identity, dated balances, notices and movements.
Review trail
Review decisions, record attachments and operation receipts keep decisions, source material and verified effects.
Every table, by feature
- Bank instructions6
- Independent review6
- Provider accounts7
- Account applications6
- Evidence and reconciliation6
- Operations control7
- Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Bank instructions, Financial accounts - Financial accounts
Provider-held financial accounts owned by a counterparty.
Linked to Financial counterparties - Financial counterparties
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations - Record attachments
Supporting documents attached to a banking instruction.
Linked to Bank instructions, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Bank instructions
- Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Bank instructions, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Bank instructions - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Record attachments
Supporting documents attached to a banking instruction.
Linked to Bank instructions, Team members - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Bank instructions, Financial accounts
- Organizations
Banking organizations whose treasury operations are run in this app.
- Financial counterparties
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations - Financial accounts
Provider-held financial accounts owned by a counterparty.
Linked to Financial counterparties - Account snapshots
Dated provider balance snapshots for a financial account.
Linked to Financial accounts - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Bank instructions, Financial accounts - Reconciliation items
Source-identified provider movements matched against banking instructions.
Linked to Financial accounts, Bank instructions - Exchange rates
Read-only effective exchange rates for this app.
- Account applications
Applications to open a provider-authorized account against a banking instruction.
Linked to Bank instructions, Organizations - Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Bank instructions, Team members - Record attachments
Supporting documents attached to a banking instruction.
Linked to Bank instructions, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Bank instructions - Organizations
Banking organizations whose treasury operations are run in this app.
- Bank evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Bank instructions - Account snapshots
Dated provider balance snapshots for a financial account.
Linked to Financial accounts - Reconciliation items
Source-identified provider movements matched against banking instructions.
Linked to Financial accounts, Bank instructions - Financial accounts
Provider-held financial accounts owned by a counterparty.
Linked to Financial counterparties - Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Bank instructions, Financial accounts
- Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Bank instructions - Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Bank instructions, Team members - Bank evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Bank instructions - Organizations
Banking organizations whose treasury operations are run in this app.
- Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Users
Sign-in accounts for the people who use the app.
Keys and references
The parent instruction connects applications, evidence, decisions, attachments and receipts. Each instruction account scope and reconciliation item points to a financial account. Provider instruction, application, snapshot and event identifiers connect local records to the originating provider material. Revision and operation key protect guarded actions from stale or repeated requests.
Migration order
- Load organizations, users, team members and financial counterparties with their ownership scope.
- Load provider-held financial accounts and verify external identifiers and currency.
- Add instructions with account scopes and related applications or attachments.
- Import dated snapshots, provider evidence, decisions and reconciliation movements with their source identifiers.
- Review operation receipts and reconcile open exceptions before routine operation.
Set up Core Banking System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.