All applications611

Find your application

611 applications

Open full catalog

Browse applications by category or open the full catalog.

  1. ATM Management System
  2. Data model
Reference

The tables behind ATM Management System

ATM Management 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
7, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Organization and access

Organizations, People, Users and service providers establish operational scope.

Instructions and accounts

Work orders connect to work order accounts and financial accounts; provider-held account snapshots retain dated balances.

Decisions and evidence

Review decisions, record attachments, work evidence and operation receipts preserve decisions, source files and action results.

Applications and settlement

Account applications belong to a parent instruction. Reconciliation items identify provider movements against an account and matched instruction.

Reference rates

Exchange rates carry read-only currency rates with effective dates.

Every table, by feature

Banking instructions

5 tablesAbout this feature
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Work orders, People
  • Organizations

    Banking organizations whose treasury operations are run in this app.

  • People

    Preparers, approvers, auditors and administrators working in the organization.

    Linked to Users, Organizations
  • Service providers

    Banks, custodians and settlement counterparties eligible for banking instructions.

    Linked to Organizations

Account scope

4 tablesAbout this feature
  • Work order accounts

    Debit and credit account scopes that make an instruction balanced.

    Linked to Work orders, Financial accounts
  • Financial accounts

    Provider-held financial accounts owned by a counterparty.

    Linked to Service providers
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers
  • Service providers

    Banks, custodians and settlement counterparties eligible for banking instructions.

    Linked to Organizations

Independent review

5 tablesAbout this feature
  • Review decisions

    Independent approver decisions recorded against a frozen instruction revision.

    Linked to Work orders, People
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Work orders, People
  • People

    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 Work orders

Provider outcomes

4 tablesAbout this feature
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers
  • Work evidence

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

    Linked to Work orders
  • Service providers

    Banks, custodians and settlement counterparties eligible for banking instructions.

    Linked to Organizations
  • Operation receipts

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

    Linked to Work orders

Account applications

5 tablesAbout this feature
  • Account applications

    Applications to open a provider-authorized account against a banking instruction.

    Linked to Work orders, Organizations
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers
  • Review decisions

    Independent approver decisions recorded against a frozen instruction revision.

    Linked to Work orders, People
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Work orders, People
  • Organizations

    Banking organizations whose treasury operations are run in this app.

Settlement reconciliation

5 tablesAbout this feature
  • Reconciliation items

    Source-identified provider movements matched against banking instructions.

    Linked to Financial accounts, Work orders
  • Account snapshots

    Dated provider balance snapshots for a financial account.

    Linked to Financial accounts
  • Financial accounts

    Provider-held financial accounts owned by a counterparty.

    Linked to Service providers
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers
  • Work order accounts

    Debit and credit account scopes that make an instruction balanced.

    Linked to Work orders, Financial accounts

Operations control

5 tablesAbout this feature
  • Operation receipts

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

    Linked to Work orders
  • Review decisions

    Independent approver decisions recorded against a frozen instruction revision.

    Linked to Work orders, People
  • Work evidence

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

    Linked to Work orders
  • Record attachments

    Supporting documents attached to a banking instruction.

    Linked to Work orders, People
  • Work orders

    Typed banking instructions moving through authorization, submission and confirmation.

    Linked to Organizations, People, Service providers

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Use the instruction record number, provider instruction ID, provider event ID, operation key and external account ID for their separate purposes. A provider reference is not the same as a local row identifier. Keep the parent instruction link when recording a decision, attachment, receipt or application. Work order accounts supplies the account path used when matching a provider movement to confirmed work.

Migration order

  1. Import Organizations and service providers, then map active People to Users.
  2. Load financial accounts and dated account snapshots with provider identifiers intact.
  3. Import work orders and their work order accounts and supporting attachments.
  4. Bring forward account applications, review decisions, work evidence and operation receipts without rewriting decision history.
  5. Load reconciliation items, preserve provider event IDs and compare the first account balances.

Set up ATM Management System your way.

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

How to get started