1. Remittance Platform
  2. Data model
Reference

The tables behind Remittance Platform

Remittance Platform 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 people

Organizations, team members and Users establish the operating context and actor identity.

Parties and accounts

Financial counterparties owns financial accounts; account snapshots records dated provider balances.

Work

Bank instructions carries the lifecycle; instruction accounts sets debit and credit scope; transfer quotes carries quoted terms.

Decision and evidence

Review decisions, record attachments, bank evidence and operation receipts keep the decision and observed effect.

Reconciliation

Reconciliation items records provider event identities and references to accounts and instructions; exchange rates supplies dated rate context.

Every table, by feature

Counterparties and accounts

4 tablesAbout this feature
  • Financial counterparties

    Eligible counterparties that receive or originate remittance instructions.

    Linked to Organizations
  • Financial accounts

    Provider-issued financial accounts held by counterparties.

    Linked to Financial counterparties
  • Organizations

    Legal entities operating remittance instructions in this workspace.

  • Team members

    Authenticated platform identities with an operational role in an organization.

    Linked to Users, Organizations

Transfer quotes

6 tablesAbout this feature
  • Transfer quotes

    Remittance transfer quotes submitted for independent authorization.

    Linked to Bank instructions, Organizations
  • Bank instructions

    Typed banking instructions with revision control and lifecycle state.

    Linked to Organizations, Team members, Financial counterparties
  • Review decisions

    Independent review decisions recorded against an instruction revision.

    Linked to Bank instructions, Team members
  • Record attachments

    Uploaded supporting files with visibility scope.

    Linked to Bank instructions, Team members
  • Operation receipts

    Durable receipts for guarded operations with stable operation keys.

    Linked to Bank instructions
  • Exchange rates

    Read-only effective exchange rates for this app.

Bank instructions

6 tablesAbout this feature
  • Bank instructions

    Typed banking instructions with revision control and lifecycle state.

    Linked to Organizations, Team members, Financial counterparties
  • Instruction accounts

    Balanced debit and credit account scope for an instruction.

    Linked to Bank instructions, Financial accounts
  • Financial accounts

    Provider-issued financial accounts held by counterparties.

    Linked to Financial counterparties
  • Financial counterparties

    Eligible counterparties that receive or originate remittance instructions.

    Linked to Organizations
  • Operation receipts

    Durable receipts for guarded operations with stable operation keys.

    Linked to Bank instructions
  • Bank evidence

    Provider-sourced evidence lines attached to a banking instruction.

    Linked to Bank instructions

Review and evidence

5 tablesAbout this feature
  • Review decisions

    Independent review decisions recorded against an instruction revision.

    Linked to Bank instructions, Team members
  • Record attachments

    Uploaded supporting files with visibility scope.

    Linked to Bank instructions, Team members
  • Operation receipts

    Durable receipts for guarded operations with stable operation keys.

    Linked to Bank instructions
  • Bank instructions

    Typed banking instructions with revision control and lifecycle state.

    Linked to Organizations, Team members, Financial counterparties
  • Team members

    Authenticated platform identities with an operational role in an organization.

    Linked to Users, Organizations

Settlement and reconciliation

6 tablesAbout this feature
  • Bank evidence

    Provider-sourced evidence lines attached to a banking instruction.

    Linked to Bank instructions
  • Reconciliation items

    Provider events matched against instructions during reconciliation.

    Linked to Financial accounts, Bank instructions
  • Account snapshots

    Timestamped provider balance snapshots per financial account.

    Linked to Financial accounts
  • Bank instructions

    Typed banking instructions with revision control and lifecycle state.

    Linked to Organizations, Team members, Financial counterparties
  • Operation receipts

    Durable receipts for guarded operations with stable operation keys.

    Linked to Bank instructions
  • Financial accounts

    Provider-issued financial accounts held by counterparties.

    Linked to Financial counterparties

Rates and balances

5 tablesAbout this feature
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Account snapshots

    Timestamped provider balance snapshots per financial account.

    Linked to Financial accounts
  • Financial accounts

    Provider-issued financial accounts held by counterparties.

    Linked to Financial counterparties
  • Transfer quotes

    Remittance transfer quotes submitted for independent authorization.

    Linked to Bank instructions, Organizations
  • Reconciliation items

    Provider events matched against instructions during reconciliation.

    Linked to Financial accounts, Bank instructions

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Record number identifies a bank instructions record for the team. Provider instruction ID and provider event ID connect it to the provider’s identities. Operation key identifies a guarded action, while Revision and source revision show the basis of a decision. Organization and Parent references preserve scope and lineage.

Migration order

  1. Create Organizations, Users and team members.
  2. Load financial counterparties and financial accounts, then exchange rates and account snapshots.
  3. Bring in bank instructions, instruction accounts and transfer quotes with their references.
  4. Attach record attachments, review decisions, operation receipts and bank evidence.
  5. Import reconciliation items only after account and instruction identities have been checked.

Set up Remittance Platform your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started