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.
- Food Distribution SCM
- Data model
The tables behind Food Distribution SCM
Food Distribution SCM ships with 18 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
- 18
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Operating context
Organizations, delivery points, team members and Users identify where and by whom work is done.
Customer commitments
Distribution orders hold the service commitment; order lines hold menu scope; dispatch tickets hold reviewed release requests.
Catalogue and kitchen
Products, Ingredients, product recipes and recipe ingredients define the menu and its approved ingredient basis; ingredient movements record signed use and waste.
Movement and evidence
Distribution events retain product movement; operation receipts, review decisions, record attachments and payment evidence retain decisions and results.
Currency reference
Exchange rates hold effective rates for the operating organization context.
Every table, by feature
- Distribution orders6
- Delivery points6
- Kitchen preparation7
- Dispatch review6
- Distribution events7
- Evidence and exceptions7
- Shared and settings1
- Distribution orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery points - Order lines
Individual menu item lines within a meal order.
Linked to Distribution orders - Delivery points
Dining rooms, outlets, venues and delivery destinations served by the operation.
Linked to Organizations - Products
Sellable menu products and packaged goods.
- Product recipes
Versioned recipe headers for products, with yield and approval state.
Linked to Products - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Distribution orders
- Delivery points
Dining rooms, outlets, venues and delivery destinations served by the operation.
Linked to Organizations - Organizations
Operating organizations within the food and beverage group.
- Team members
Staff members linked to an organization and platform identity.
Linked to Organizations, Users - Users
Users
Linked to Users - Distribution orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery points - Dispatch tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Distribution orders, Organizations
- Order lines
Individual menu item lines within a meal order.
Linked to Distribution orders - Distribution orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery points - Products
Sellable menu products and packaged goods.
- Product recipes
Versioned recipe headers for products, with yield and approval state.
Linked to Products - Recipe ingredients
Ingredient quantities required per recipe yield.
Linked to Ingredients, Product recipes - Ingredients
Ingredient master data with allergen declarations and base units.
- Ingredient movements
Signed inventory movements for ingredient consumption and waste.
Linked to Ingredients
- Dispatch tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Distribution orders, Organizations - Distribution orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery points - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Distribution orders, Team members - Record attachments
Files and evidence attached to operational records.
Linked to Distribution orders, Team members - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Distribution orders - Distribution events
Allocation, picking, shipping, delivery and return events.
Linked to Distribution orders, Products
- Distribution events
Allocation, picking, shipping, delivery and return events.
Linked to Distribution orders, Products - Distribution orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery points - Products
Sellable menu products and packaged goods.
- Dispatch tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Distribution orders, Organizations - Order lines
Individual menu item lines within a meal order.
Linked to Distribution orders - Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Distribution orders - Record attachments
Files and evidence attached to operational records.
Linked to Distribution orders, Team members
- Operation receipts
Durable receipts for guarded operations and their outcomes.
Linked to Distribution orders - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Distribution orders, Team members - Record attachments
Files and evidence attached to operational records.
Linked to Distribution orders, Team members - Payment evidence
Provider-issued authorization, capture, refund and void receipts.
Linked to Distribution orders - Distribution orders
Customer orders accepted and fulfilled by the kitchen and service team.
Linked to Organizations, Team members, Delivery points - Dispatch tickets
Kitchen tickets submitted for review and release against a meal order.
Linked to Distribution orders, Organizations - Distribution events
Allocation, picking, shipping, delivery and return events.
Linked to Distribution orders, Products
Keys and references
Distribution orders links to Organizations, team members and delivery points. Order lines, dispatch tickets, distribution events, operation receipts, record attachments, review decisions and payment evidence link to their parent distribution orders record. Distribution events also links to Products. Product recipes links to Products; recipe ingredients connects product recipes and Ingredients. Ingredient movements links to Ingredients and carries the source meal-line identity. Preserve each record’s native identifier and revision when importing or reconciling activity.
Migration order
- Load Organizations, Users and team members, then active delivery points.
- Load Products and Ingredients, followed by product recipes and recipe ingredients.
- Load distribution orders and order lines with their owners and destinations.
- Load dispatch tickets and their decision or attachment evidence.
- Load distribution events, ingredient movements, operation receipts and payment evidence with original identities and occurrence times.
- Reconcile current statuses and open exceptions against the actual linked effects.
Set up Food Distribution SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.