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.
- Cross-border Trade SCM
- Data model
The tables behind Cross-border Trade SCM
Cross-border Trade SCM ships with 10 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
- 10
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Purchase demand
Purchase requests holds the case, and purchase lines holds line detail and accepted quantities.
Counterparty and people
Organizations contains the trading entity; Suppliers and team members belong to it, and team members connects to Users.
Decision and customs
Review decisions records a source-revision decision, while customs declarations records entry, duty and release status.
Evidence and attempts
Record attachments holds files and visibility; operation receipts holds operation keys and result states.
Every table, by feature
- Purchase demand5
- Suppliers4
- Independent review6
- Customs declarations4
- Evidence and receipts4
- Organization and access6
- Purchase requests
Cross-border purchase demand with lifecycle, owner, counterparty and revision.
Linked to Organizations, Team members, Suppliers - Purchase lines
Line items with requested and accepted quantities and USD unit price.
Linked to Purchase requests - Suppliers
Eligible active suppliers in the same organization.
Linked to Organizations - Organizations
Trading organizations that own cross-border purchase and customs operations.
- Team members
Authenticated platform identities with organization membership and role scope.
Linked to Organizations, Users
- Suppliers
Eligible active suppliers in the same organization.
Linked to Organizations - Organizations
Trading organizations that own cross-border purchase and customs operations.
- Purchase requests
Cross-border purchase demand with lifecycle, owner, counterparty and revision.
Linked to Organizations, Team members, Suppliers - Team members
Authenticated platform identities with organization membership and role scope.
Linked to Organizations, Users
- Purchase requests
Cross-border purchase demand with lifecycle, owner, counterparty and revision.
Linked to Organizations, Team members, Suppliers - Purchase lines
Line items with requested and accepted quantities and USD unit price.
Linked to Purchase requests - Review decisions
Independent review decisions on a specific source revision.
Linked to Purchase requests, Team members - Record attachments
Evidence files attached to a purchase request with visibility scope.
Linked to Purchase requests, Team members - Operation receipts
Idempotent operation receipts with stable operation key and result state.
Linked to Purchase requests - Team members
Authenticated platform identities with organization membership and role scope.
Linked to Organizations, Users
- Customs declarations
Customs declarations supporting record verified customs release.
Linked to Purchase requests, Organizations - Purchase requests
Cross-border purchase demand with lifecycle, owner, counterparty and revision.
Linked to Organizations, Team members, Suppliers - Organizations
Trading organizations that own cross-border purchase and customs operations.
- Record attachments
Evidence files attached to a purchase request with visibility scope.
Linked to Purchase requests, Team members
- Record attachments
Evidence files attached to a purchase request with visibility scope.
Linked to Purchase requests, Team members - Operation receipts
Idempotent operation receipts with stable operation key and result state.
Linked to Purchase requests - Purchase requests
Cross-border purchase demand with lifecycle, owner, counterparty and revision.
Linked to Organizations, Team members, Suppliers - Team members
Authenticated platform identities with organization membership and role scope.
Linked to Organizations, Users
- Organizations
Trading organizations that own cross-border purchase and customs operations.
- Team members
Authenticated platform identities with organization membership and role scope.
Linked to Organizations, Users - Users
Users
Linked to Users - Suppliers
Eligible active suppliers in the same organization.
Linked to Organizations - Purchase requests
Cross-border purchase demand with lifecycle, owner, counterparty and revision.
Linked to Organizations, Team members, Suppliers - Customs declarations
Customs declarations supporting record verified customs release.
Linked to Purchase requests, Organizations
Keys and references
Purchase requests links to Organizations, team members as Owner and Suppliers as Counterparty. Purchase lines, review decisions, record attachments, operation receipts and customs declarations link back to a purchase through Parent. Customs declarations also links directly to Organizations. Keep these references intact when importing history. Record number identifies the purchase in conversation; the linked record remains the join key.
Migration order
- Set up identity and organization. Load Users, Organizations and team members with their references.
- Prepare counterparties. Load Suppliers in their organization.
- Load purchase cases. Add purchase requests with owner and counterparty, then purchase lines.
- Attach decisions and filing history. Add review decisions, customs declarations, record attachments and operation receipts against the intended purchase.
- Check a full case. Trace a request from its supplier and lines to its review and customs records.
Set up Cross-border Trade SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.