Tasks, reminders and other notifications. Calendaring and scheduling resources. Smelling Including email, Instant messaging and telephone traffic. Official communications from designated sources. AS portal Figure 2-2: AS Institute Dashboard Back Office/Front Office 0 Back-office software (core ERP) -HER, Financial, and Operations 0 Front-office software integrates with customers and suppliers – supply chain management and customer relationship management 0 Bolt-ions are used to integrate more functionality to Core ERP Figure 2-3: core ERP and ERP Bolt-Ions
Relational Database Terminology tables are relations tables and forms (visuals of tables) show up on screens in ERP menus. Fields are attributes in the table (in columns) Records are instances in the table (in rows) Each table has a primary key that is the unique. Usually the primary key is some sort of code. Can not be null or empty Nonentity integrity rule the primary key in one table becomes the foreign key in another table so the tables can Interrelationship Diagram Orders are a type of system diagramming that show relationships between tables.
Relationships are rules that show how tables relate types of relationships Done-to-one: the primary key of one table is associated with only one record in another table Done-to-many: the primary key of one table is associated with more than one record in another table many-to-many: the primary key in one table is associated with more than one record in a second table and the primary key in the second table is associated with more than one record in the first table Relational Database Example Figure 2-4: Relational Database Overview
Database Query and Manipulation OH query is a question asked of the database. Again, ERP systems have many standard queries coded into the software in the form of menus. Menus can be customized to add/change/delete queries. Structured Query Language (SQL) is a database querying language 0 Simple Query – returns a response without changing the database 0 Update Query – changes records in a database Data Manipulation – operations alter the database Lingering new rows into tables Updating existing rows Deleting rows from tables Configure vs..
Customize ERP Configuration involves “setting switches” during implementation that determine how the system will execute business processes. Example of configuring: reporting relationships, options having to do with how business processes work, auditing mechanisms, organizational structure. Customization is changing software code. Only do if necessary and believed to lead to a competitive advantage. Don’t customize because you feel your employees will resist a new way of work…. That is the point of ERP! Vanilla is not customizing the software.