looking for database design for ERP

Posted on 2006-05-02
Last Modified: 2013-11-23

i want study the structure of ERP system

1. Business process of ERP system
2. Datamodels,tables structure
3. workflow diagrams
4. database design
5. dataflow diagrams

cover all modules with integrating all modules of ERP.
pls recommend some downloads,url stuff,
so that i can able to study indepth also
Question by:bsarahim
    LVL 1

    Accepted Solution

    Thats kind of a loaded question. In order to chose an ERP, in order to study it, you have to know the structure of the organization that would work best with an ERP package.  So really what are your business practices and how does your companies workflow work with an ERP package out there....also....database designs will vary from ERP to ERP.  And as for Dataflow diagrams you need to truly know how your company does business in order to map out the appropriate data flow in an ERP....Sorry to cause you any confusions on this....
    LVL 5

    Assisted Solution

    Ninpokai has hit this one on the head....

    Even though the end of most ERP systems are the same.... Product out the door, sold, to a customer and accounted for,  The MEANS of getting there are very VERY different..  Somethings are simple.. Customer Tables, vendor master table, order entry headers and bodies...  But others are a real piece of work.. matrixed pricing by customer,  General Ledger mapping by type,  Manufacturing, Inventorying and so on..

    all the things you have listed are specific to the business that is being studied that it would be impossible to state the structure of anything without a designated system to begin studying.

    If education you want, go get your PMC (project management certificate), take a couple of APICS classes (american Production and inventory control society), throw some advanced accounting classes.  Work for an IT department for a minimum of 5 years and your about there. Even the ERP vendors run classes, take a couple of them and you'll begin to understand THEIR system.

    I will check a couple of sites for diagrams, workflow startup and others, but I do not believe you will find what it is you are looking for...

    Have a good one...
    LVL 4

    Assisted Solution

    As per my knowledge and some experience, MOST of ERP applications can accommodate all the business process of varying fields of business; and THIS IS THE CONCEPT of ERP.  As of my experience Oracle and SAP are the most valuable ones, and most famous.

    For Oracle, there is a good reference collection in their support site:
    (eTRM stands for Electronical Technical Reference Manuals)
    THIS ACCESSIBLE ONLY FOR ORACLE CUSTOMERS (You need to have been purchased their ERP, or otherwise, check any customer you know who can help you)

    also you can check:
    You can download FREE PDFs here.

    I hope this will help you. Regards;

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Supply Chain Event Management Supply chain visibility is the ability of a company to track its products and business processes in supply chain towards building operational excellence. The goal of supply chain visibility is to improve and strength…
    Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now