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.
- Invoice Factoring Platform
- Data model
The tables behind Invoice Factoring Platform
Invoice Factoring 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
- Change it
- Add fields and tables in Proto
How the model is organised
Operating scope
Organizations, team members and Users identify the entity and people. Business partners identify eligible counterparties.
Instruction lifecycle
Accounting documents is the parent for record attachments, review decisions, document lines, operation receipts, journal lines and factoring reviews.
Provider accounts
Ledger accounts links to business partners and anchors account snapshots and cash applications.
Reference rates
Exchange rates holds effective read-only currency rates for reporting context.
Every table, by feature
- Banking instructions5
- Independent review5
- Provider accounts5
- Evidence and receipts5
- Cash reconciliation6
- Organizations and partners6
- Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners - Record attachments
Supporting documents attached to a banking instruction.
Linked to Accounting documents, Team members - Document lines
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Accounting documents - Journal lines
Debit and credit account scopes that make an instruction balanced.
Linked to Accounting documents, Ledger accounts - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- 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 - 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
- Factoring reviews
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 - 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 - 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 - Document lines
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Accounting documents - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents - Accounting documents
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Business partners
- 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 - Journal lines
Debit and credit account scopes that make an instruction balanced.
Linked to Accounting documents, Ledger accounts - Document lines
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Accounting documents
- Organizations
Banking organizations whose treasury operations are run in this app.
- 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 - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Users
Users
Linked to Users - Exchange rates
Read-only effective exchange rates for this app.
Keys and references
Use the exact organization, counterparty, account and parent references when importing operational history. Provider instruction ID, provider application ID, provider event ID and external account ID keep external identities distinct. Operation key identifies an action receipt and expected revision ties it to the request version. A cash application refers to its matched instruction and account. A review decision refers to the parent instruction and reviewer.
Migration order
- Load Organizations and Users, then team members and business partners with their scope.
- Load ledger accounts and effective exchange rates.
- Load accounting documents and their supporting record attachments.
- Load factoring reviews, review decisions, journal lines, document lines and operation receipts against each parent.
- Load account snapshots and cash applications, then reconcile provider identifiers and occurrence dates.
Set up Invoice Factoring Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.