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.
- Financial Risk Management
- Data model
The tables behind Financial Risk Management
Financial Risk Management 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, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and providers
Organizations contains the operating entities; financial counterparties and financial accounts identify eligible provider relationships and accounts. Team members links people to organizations and Users.
Instruction work
Bank instructions holds the request and status. Instruction accounts records debit and credit account scopes. Record attachments supplies supporting documents; review decisions preserves independent decisions.
Provider and application work
Bank evidence holds provider events, operation receipts tracks action attempts, and risk model runs holds provider account applications linked to instructions.
Position and matching
Account snapshots retains dated provider balances. Reconciliation items links source movements to accounts and matched instructions. Exchange rates is a read-only effective-rate reference.
Every table, by feature
- Banking instructions7
- Independent review6
- Provider outcomes5
- Account applications6
- Accounts and counterparties7
- Bank reconciliation6
- Shared and settings1
- 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 - 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
- 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 - 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 - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - 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 - Bank evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Bank instructions - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Bank instructions - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Bank instructions, Team members - Reconciliation items
Source-identified provider movements matched against banking instructions.
Linked to Financial accounts, Bank instructions
- Risk model runs
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.
- 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 - Exchange rates
Read-only effective exchange rates for this app.
- Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Bank instructions, Financial accounts - Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties
- 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 - Account snapshots
Dated provider balance snapshots for a financial account.
Linked to Financial accounts - Bank instructions
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Financial counterparties - Bank evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Bank instructions - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Bank instructions, Financial accounts
Keys and references
Bank instructions has a record number and provider instruction identifier. Bank evidence and reconciliation items retain provider event identifiers. Operation receipts has a stable operation key and effect references. These identifiers should be preserved during migration so repeated provider messages can be distinguished from new work. Account and instruction references are explicit, allowing an auditor to move from a reconciliation item to the financial account and confirmed instruction that explain it.
Migration order
- People and organizations. Import Users, Organizations and team members with the intended organization scope.
- Provider directory. Import financial counterparties and financial accounts with active state and currency.
- Opening position. Load account snapshots and the effective exchange rates reference where applicable.
- Instructions and applications. Bring in bank instructions, instruction accounts, record attachments and risk model runs with their original identities.
- Decisions and outcomes. Attach review decisions, bank evidence and operation receipts to their parent instructions.
- Movements. Import reconciliation items with source event identifiers and validate account and instruction links.
Set up Financial Risk Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.