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.
- Trade Finance Platform
- Data model and import order
The tables behind Trade Finance Platform
Trade Finance Platform ships with 19 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
- 19
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Financing Applications:
Loan applications, application evidence, Borrowers, record attachments. Each application names a borrower and owner and carries a version.
Underwriting Review:
Review decisions record the decision, reason and approver against an application version.
Letters of Credit:
Credit instruments belong to an application; letters of credit belong to an applicant borrower; credit drawings belong to a credit.
Loan Accounts and Disbursement:
Loan accounts belong to an application; Disbursements and repayment schedules belong to a loan.
Repayments and Servicing:
Repayments belong to a loan; repayment allocations link a repayment to an installment; loan changes record approved changes with the prior schedule version.
Operations Control:
Operation receipts record guarded actions; Organizations, team members and Users scope access; exchange rates holds read-only rates.
Every table, by feature
- Financing Applications4
- Underwriting Review4
- Letters of Credit4
- Loan Accounts and Disbursement4
- Repayments and Servicing4
- Operations Control4
- Shared and settings2
- Loan applications
Operational loan applications
Linked to Organizations, Team members, Borrowers - Application evidence
Evidence lines supporting an application
Linked to Loan applications - Borrowers
Eligible borrowing counterparties
Linked to Organizations - Record attachments
Files attached to an application
Linked to Loan applications, Team members
- Review decisions
Independent review decisions
Linked to Loan applications, Team members - Loan applications
Operational loan applications
Linked to Organizations, Team members, Borrowers - Credit instruments
Trade-finance credit instruments under review
Linked to Loan applications, Organizations - Loan changes
Approved servicing changes
Linked to Loan accounts
- Credit instruments
Trade-finance credit instruments under review
Linked to Loan applications, Organizations - Letters of credit
Issued letters of credit
Linked to Borrowers - Credit drawings
Documentary presentations against a credit
Linked to Letters of credit - Borrowers
Eligible borrowing counterparties
Linked to Organizations
- Loan accounts
Funded loan accounts
Linked to Loan applications - Disbursements
Verified provider disbursements
Linked to Loan accounts - Repayment schedules
Versioned installment schedules
Linked to Loan accounts - Loan applications
Operational loan applications
Linked to Organizations, Team members, Borrowers
- Repayments
Verified provider repayments
Linked to Loan accounts - Repayment allocations
Allocation of receipts to schedule installments
Linked to Repayments, Repayment schedules - Loan changes
Approved servicing changes
Linked to Loan accounts - Repayment schedules
Versioned installment schedules
Linked to Loan accounts
- Operation receipts
Durable operation receipts
Linked to Loan applications - Organizations
Lending and operating organizations
- Team members
Platform members with role scope
Linked to Users, Organizations - Loan applications
Operational loan applications
Linked to Organizations, Team members, Borrowers
Keys and references
Every application keeps a stable record number, every borrower a code, every loan an account number and provider account ID, and every credit its bank reference. Import disbursements and repayments by provider event ID so repeats are recognized. Keep schedule versions intact when migrating rescheduled loans.
The platform holds 19 tables and 24 relationships.
Migration order
- Load Organizations, Users and team members.
- Load Borrowers with eligibility notes.
- Load open loan applications with evidence and attachments.
- Load credit instruments, letters of credit and credit drawings.
- Load loan accounts, Disbursements, repayment schedules with versions, Repayments and repayment allocations.
- Reconcile limits, principal outstanding and installments due with the source before taking new applications.
Set up Trade Finance Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.