Patent ID: 6625616
Filing Date: 2003-09-23
Classification: G06F,G06Q,Y10S

Abstract:
Apparatus for materials requirements planning comprising;a) a server side processor having a network connection and provided with software to supply network server functions, server side general purpose programming functions, and database functions using SQL code, b) a client side processor connected to the network and provided with software to enable login to the server side processor via the network, and to supply software functions including data access reports and/or modification in order to be able to control server access, c) the client side processor being enabled to input data including product descriptions, bill of materials for products containing complete part numbers, an approved vendor list containing complete vendor information for each part number, schedule of the product being built with the quantity required and the date when parts are available for production, d) the server side processor initiating a Visual Basic program that runs 2 SQL programs creating two independent data sets from 2 sets of tables from a relational database, i. one independent data set being a work data set containing all current scheduled part usage requirements, current parts availability, the part required date as determined from the production schedule, and the part quantity required for that date, and then sorting by part number in ascending order by part number first and then by part date, and ii. the second independent data set being an order data set containing all current open unfulfilled parts, the date specified for delivery, and the quantity ordered, but not received.