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.
- Electricity Billing System
- Data model
The tables behind Electricity Billing System
Electricity Billing 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Instruction and lines
Accounting documents owns document lines and links to Organizations, team members and business partners.
Provider accounts
Business partners owns ledger accounts; account snapshots and cash applications reference those accounts.
Applications
Meter bill runs belongs to accounting documents and Organizations.
Evidence
Cash receipts, record attachments, review decisions and operation receipts retain the parent instruction.
Membership and reference
Team members links Users to Organizations; exchange rates is read-only effective reference data.
Every table, by feature
- Accounting instructions4
- Partners and accounts5
- Independent review4
- Provider applications4
- Cash and reconciliation5
- Operations evidence4
- Shared and settings1
- Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners - Document lines
Debit and credit account scopes that make an instruction balanced.
Linked to Accounting documents, Ledger accounts - Ledger accounts
Provider-held financial accounts owned by a counterparty.
Linked to Business partners - Business partners
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations
- Business partners
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations - Ledger accounts
Provider-held financial accounts owned by a counterparty.
Linked to Business partners - Organizations
Banking organizations whose treasury operations are run in this app.
- Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Exchange rates
Read-only effective exchange rates for this app.
- Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, 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 Accounting documents
- Meter bill runs
Applications to open a provider-authorized account against a banking instruction.
Linked to Accounting documents, Organizations - Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, Team members - Record attachments
Supporting documents attached to a banking instruction.
Linked to Accounting documents, Team members
- Cash receipts
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Accounting documents - Cash applications
Source-identified provider movements matched against banking instructions.
Linked to Ledger accounts, Accounting documents - Account snapshots
Dated provider balance snapshots for a financial account.
Linked to Ledger accounts - Ledger accounts
Provider-held financial accounts owned by a counterparty.
Linked to Business partners - Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners
- Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents - Record attachments
Supporting documents attached to a banking instruction.
Linked to Accounting documents, Team members - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, Team members - Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners
Keys and references
Keep provider identifiers on the source records: Accounting documents.provider instruction ID, meter bill runs.provider application ID, cash receipts.provider event ID, cash applications.provider event ID and account snapshots.provider snapshot ID. Operation receipts.operation key supports repeat recognition; review decisions.source revision identifies the instruction revision decided. Preserve each Parent and Document reference when importing historical work.
Migration order
- Organization and users. Create Organizations, Users and team members with correct membership.
- Counterparties and accounts. Import business partners and ledger accounts, then exchange rates and account snapshots.
- Instructions. Import accounting documents and their document lines.
- Linked work. Bring in meter bill runs, record attachments, review decisions, cash receipts, cash applications and operation receipts with their original references.
- Reconcile. Compare provider event and operation keys with the external source before allowing new actions.
Set up Electricity Billing System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.