MES Core Dispatch

Summary

This process kicks off other processes and decides what to do next. It is the heart of the MES and directly interacts with customer orders, returns and other data to decide how to manage all other processes.

SQL architecture

• SQL Architecture:
  • Primer -
    • SQL views - A SQL view is an aggregate of many SQL table columns that makes the data more presentable and easy to use. It avoids forcing the user to Join many tables to get stuff done. Instead these views store the data in this usable joined together format. For instance, you will likely want a table that uses columns from products orders and traceability to show what product serial numbers are with what customer.
    • Foreign keys - when the ID (one ID pre row is critical) of another table is used in this table.
  • Orders Master Table View
    • Overview: This table shows the current placed orders and links to the customer that placed it. Also has keys to
    • Columns:
      • PID - Foreign key to the Products table for what product is ordered
      • Qty - how much was ordered
  • Products Master Table View
    • Columns:

• • Traceability Master Table View
    • Columns:
  • Customer Data Table View