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.
- SCM with Landed Cost Calculation
- Data model
The tables behind SCM with Landed Cost Calculation
SCM with Landed Cost Calculation 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
Purchasing
Purchase requests hold supplier, owner, amount, required date and status; purchase lines carry requested and accepted quantities.
Landed charges
Freight allocations hold shipment reference, cost and allocation basis against a parent request.
Decisions and evidence
Review decisions record revision decisions, operation receipts preserve action results, and record attachments hold supporting files.
Scope
Organizations, Suppliers, team members and Users identify the legal entity, counterparty and acting person.
Every table, by feature
- Purchase requests3
- Purchase lines3
- Suppliers and organizations5
- Approvals4
- Freight allocations4
- Receipt evidence4
- Purchase requests
Purchase requests with lifecycle, counterparty and requested amount.
Linked to Organizations, Team members, Suppliers - Purchase lines
Requested and accepted quantities and prices per purchase request.
Linked to Purchase requests - Operation receipts
Durable operation receipts for guarded workflow executions.
Linked to Purchase requests
- Purchase lines
Requested and accepted quantities and prices per purchase request.
Linked to Purchase requests - Purchase requests
Purchase requests with lifecycle, counterparty and requested amount.
Linked to Organizations, Team members, Suppliers - Operation receipts
Durable operation receipts for guarded workflow executions.
Linked to Purchase requests
- Suppliers
Eligible suppliers that fulfil purchase requests.
Linked to Organizations - Organizations
Legal entities operating procurement and landed-cost operations.
- Team members
Membership roster linking authenticated users to organizations and role scope.
Linked to Organizations, Users - Users
Users
Linked to Users - Purchase requests
Purchase requests with lifecycle, counterparty and requested amount.
Linked to Organizations, Team members, Suppliers
- Review decisions
Independent approver decisions for a source revision.
Linked to Purchase requests, Team members - Purchase requests
Purchase requests with lifecycle, counterparty and requested amount.
Linked to Organizations, Team members, Suppliers - Team members
Membership roster linking authenticated users to organizations and role scope.
Linked to Organizations, Users - Operation receipts
Durable operation receipts for guarded workflow executions.
Linked to Purchase requests
- Freight allocations
Landed-cost freight, duty and insurance allocations against a purchase request.
Linked to Purchase requests, Organizations - Purchase requests
Purchase requests with lifecycle, counterparty and requested amount.
Linked to Organizations, Team members, Suppliers - Review decisions
Independent approver decisions for a source revision.
Linked to Purchase requests, Team members - Operation receipts
Durable operation receipts for guarded workflow executions.
Linked to Purchase requests
- Operation receipts
Durable operation receipts for guarded workflow executions.
Linked to Purchase requests - Record attachments
Uploaded evidence files linked to purchase requests.
Linked to Purchase requests, Team members - Purchase requests
Purchase requests with lifecycle, counterparty and requested amount.
Linked to Organizations, Team members, Suppliers - Review decisions
Independent approver decisions for a source revision.
Linked to Purchase requests, Team members
Keys and references
Each purchase lines, freight allocations, review decisions, operation receipts and record attachments record points to its parent purchase requests record. The request points to Organizations, Suppliers and team members. Review decisions keep the reviewer and source revision. Operation receipts keep the operation key and expected revision used for reconciliation.
Migration order
- Load Organizations and Users, then team members with organization membership.
- Load Suppliers under the correct organization.
- Load purchase requests and their purchase lines.
- Bring forward freight allocations, review decisions, record attachments and operation receipts with their parent references.
- Reconcile status, revisions, order references and accepted quantities before operational use.
Set up SCM with Landed Cost Calculation your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.