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.
- Energy Trading Platform
- Data model
The tables behind Energy Trading Platform
Energy Trading 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
Organizations contains the operating entity. Team members and Counterparties belong to it; Users identifies the member account.
Instruction
Instructions holds the requested action. Instruction accounts ties its debit and credit scope to trading accounts.
Review and evidence
Review decisions records the independent decision, while execution evidence, record attachments and operation receipts retain source and outcome references.
Position and account
Energy positions connects to its parent instruction. Position snapshots and reconciliation items capture dated account facts. Exchange rates retains effective rates for the app.
Every table, by feature
- Trading instructions6
- Independent review5
- Provider evidence4
- Energy positions5
- Account reconciliation5
- Operations control6
- Shared and settings2
- Instructions
Typed trading instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Counterparties - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Instructions, Trading accounts - Trading accounts
Provider-held trading accounts owned by a counterparty.
Linked to Counterparties - Counterparties
Banks, custodians and settlement counterparties eligible for trading instructions.
Linked to Organizations - Organizations
Trading organizations whose operations are run in this app.
- Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations
- Instructions
Typed trading instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Counterparties - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Instructions, Team members - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Instructions, Trading accounts - Record attachments
Supporting documents attached to an instruction.
Linked to Instructions, Team members - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations
- Execution evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Instructions - Instructions
Typed trading instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Counterparties - Record attachments
Supporting documents attached to an instruction.
Linked to Instructions, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Instructions
- Energy positions
Records supporting approval of an energy position reconciliation against a parent instruction.
Linked to Instructions, Organizations - Instructions
Typed trading instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Counterparties - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Instructions, Team members - Execution evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Instructions - Organizations
Trading organizations whose operations are run in this app.
- Trading accounts
Provider-held trading accounts owned by a counterparty.
Linked to Counterparties - Position snapshots
Dated provider balance snapshots for a trading account.
Linked to Trading accounts - Reconciliation items
Source-identified provider movements matched against instructions.
Linked to Trading accounts, Instructions - Instructions
Typed trading instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Counterparties - Instruction accounts
Debit and credit account scopes that make an instruction balanced.
Linked to Instructions, Trading accounts
- Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Instructions - Instructions
Typed trading instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Counterparties - Execution evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Instructions - Counterparties
Banks, custodians and settlement counterparties eligible for trading instructions.
Linked to Organizations - Organizations
Trading organizations whose operations are run in this app.
- Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations
Keys and references
Use the instruction record number for human handoff and its Id for linked rows. Keep provider event IDs and provider instruction IDs as external references. The decision’s source revision and receipt’s expected revision let reviewers check whether an outcome still belongs to the current instruction. Counterparty ownership and organization references define the scope used in access review.
Migration order
- Create Organizations, Users and team members with active membership and the intended access scope.
- Add Counterparties and trading accounts with their external account identifiers.
- Import Instructions and their instruction accounts, preserving record numbers, owners and revisions.
- Attach review decisions, record attachments, execution evidence and operation receipts to the original instruction.
- Add energy positions, position snapshots and reconciliation items, checking their parent and account references.
- Load exchange rates for the applicable currencies and effective dates.
Set up Energy Trading Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.