All applications581

Find your application

581 applications

Open full catalog

Browse applications by category or open the full catalog.

  1. KYC / AML Platform
  2. Data model
Reference

The tables behind KYC / AML Platform

KYC / AML 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 access

Organizations, team members and Users establish operating scope; financial counterparties belong to Organizations.

Banking work

Bank instructions is the parent for instruction accounts, record attachments, review decisions, bank evidence, operation receipts and screening cases.

Provider accounts

Financial accounts belong to financial counterparties and carry account snapshots and reconciliation items.

Rates

Exchange rates records effective, read-only rate values by currency and date.

Every table, by feature

Bank instructions

6 tablesAbout this feature
  • 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

Independent review

6 tablesAbout this feature
  • 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
  • Instruction accounts

    Debit and credit account scopes that make an instruction balanced.

    Linked to Bank instructions, Financial accounts
  • 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

Provider evidence

5 tablesAbout this feature
  • Bank evidence

    Provider statements, confirmations, settlement notices and corrections for an instruction.

    Linked to Bank instructions
  • Bank instructions

    Typed banking instructions moving through authorization, submission and confirmation.

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

    Idempotent operation receipts with stable operation keys and actual effect references.

    Linked to Bank instructions
  • 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

Accounts and reconciliation

6 tablesAbout this feature
  • 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
  • Reconciliation items

    Source-identified provider movements matched against banking instructions.

    Linked to Financial accounts, 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
  • Bank evidence

    Provider statements, confirmations, settlement notices and corrections for an instruction.

    Linked to Bank instructions

Screening case disposition

3 tablesAbout this feature
  • Screening cases

    Screening cases supporting disposition of a reviewed screening match against a linked instruction.

    Linked to Bank instructions, Organizations
  • Bank instructions

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, Team members, Financial counterparties
  • Organizations

    Banking organizations whose treasury operations are run in this app.

Operations control

7 tablesAbout this feature
  • 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
  • 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
  • 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.

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

The instruction record number identifies the working request. A revision ties a decision or operation receipt to a particular version of that request. Provider identifiers distinguish external instructions, evidence events, snapshots and movements. Preserve parent references when importing corrections so later reviewers can follow an instruction through its decision, provider response and reconciliation item.

The account on a reconciliation item is a financial accounts reference. A matched instruction is a bank instructions reference. Instruction accounts connect an instruction to its debit and credit accounts, so an amount match alone cannot establish that a provider movement belongs to the right account.

Migration order

  1. Load Organizations and Users, then link team members to each organization.
  2. Load financial counterparties, financial accounts and effective exchange rates.
  3. Load bank instructions, their instruction accounts and record attachments.
  4. Load review decisions, screening cases, bank evidence and operation receipts with parent references intact.
  5. Load account snapshots and reconciliation items after account and instruction identifiers are stable.
  6. Reconcile source identifiers, active values, currencies and historical revisions before operating on imported records.

Set up KYC / AML Platform your way.

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

How to get started

Proto for your workspace

Get started with Proto

Your app is selected. Download Proto, then open it with this context.

Selected appKYC / AML Platform

Choose your computer’s platform.

Download Proto

Install Proto, then return to this panel.

Already installed? Open Proto

Free to install. AI usage is charged separately.