KR100325503B1 - ERP Hosting Service System Using Internet and Method thereof - Google Patents

Abstract

The present invention relates to an ERP hosting service system and method using the Internet that enables a user to access an ERP hosting service center through the Internet using a terminal equipped only with a web browser at a low cost. will be.

The present invention comprises a client comprising a web browser; It consists of an ERP hosting service center. The ERP hosting service center sequentially shows one of a homepage module, an ERP package module, an e-commerce module, and a menu to select a menu of each module when the client accesses the Internet, and processes the user's request and sends it to the client. A web server; A DB server including a homepage DB, an ERP DB, an e-commerce DB, and storing and managing data input by users in each DB; The web application server provides data stored in the DB server, user authentication, and security service in response to a menu selection. The ERP package module is accessible only when user authentication is performed.

Description

ERP Hosting Service System Using Internet and Method

The present invention relates to an enterprise resource planning (ERP) hosting service system and method using the Internet. In particular, each company accesses an ERP hosting service center through the Internet using a terminal having only a web browser. The present invention relates to an ERP hosting service system and method using the Internet that can use ERP program required for computerization at low cost.

In general, ERP refers to the packaged software (S / W) of the enterprise information system that integrates tasks across corporate activities such as purchasing and production management, logistics, sales and accounting. In other words, it means 'using the entire enterprise's management resources intentionally and at the same time.' But more comprehensively, it is an application that can cope with changing business activities and information technology (IT) by taking into consideration the work of upper and lower supply systems such as customers and subcontractors and related departments at the same time.

Thus, customers do not end up with simple package introductions, rather than taking the approach of developing an information system to suit their environment, and taking a way of unconditionally adapting the business process to the ERP where all cases have been verified. The trend is to build a new information infrastructure within the enterprise as an integrated system throughout the company's business. In this case, efforts and willingness to adapt to changes in the work environment are essential.

Typically, these ERPs are commonly used as client / server systems by purchasing hardware, system software, and ERP packages that are necessary for each company. In other words, the data stored in the server is used as a method of performing the client's request. Therefore, there is a problem that the performance of the client should be excellent because the operation of the ERP package is closely related to the environment of the client, and the load of the client is high.

However, the establishment of ERP for each enterprise requires a large investment cost and a highly trained computerized operation staff to operate the ERP system. I feel it. In particular, companies with multiple branches or branch offices are increasing the burden on communication costs by using their private or public networks.

Therefore, the present invention has been made in view of the problems of the prior art, the purpose of each company is to access the ERP hosting service center via the Internet using a terminal equipped with only a web browser, expensive ERP required for computerization of the enterprise An object of the present invention is to provide an ERP hosting service system and method using the Internet, which can use a program at a low cost without restriction of time and place.

Another object of the present invention is the integration of the Internet through the ERP hosting service and the promotion of the company through the Internet homepage, the use of electronic bulletin boards, e-mails, archives, cool sites, etc. for the company's employees and to strengthen the corporate competitiveness through electronic commerce The present invention provides an ERP hosting service system and a method using the Internet having a solution function.

Another object of the present invention is to automatically duplicate the data entered from the e-commerce and ERP package to interoperate between the e-commerce DB and the ERP DB with a single input to maintain consistent data in real time at all times according to the double input The present invention provides an ERP hosting service system and method using the Internet which can reduce time and reduce input errors.

It is still another object of the present invention to provide an ERP hosting service system and method for achieving cost reduction effects such as labor costs, installation site rent, and low cost of maintenance for the computerized operation personnel of the information system.

Another object of the present invention is that the ERP program is made of object-oriented Java (Java) to select only the programs necessary for small and medium businesses in the module and sub-module units to build a system, and can be easily changed and expanded further in a short time In addition, the present invention provides an ERP hosting service system and a method for providing flexibility and open architecture support that can be easily operated on a platform selected by a user without being dependent on any hardware, an operating system (OS), or a database.

1 is a schematic block diagram of an ERP hosting service system using the Internet according to the present invention;

2 is a system configuration diagram of an ERP hosting service center of the present invention;

3 is a configuration example of a customer system required to receive an ERP hosting service of the present invention;

4 is a detailed block diagram reconfiguring the system configuration of FIGS. 1 to 3 in order to explain the ERP hosting service system according to the present invention;

5a and 5b is a flow chart for explaining the ERP hosting service method using the Internet according to the present invention;

5c is a main menu screen of the Internet ERP hosting service according to the present invention;

6 is a flow chart showing in detail the e-commerce method according to the invention in Figure 5a,

7A is an ERP package main menu screen;

7b is an e-commerce main menu screen,

7c is a homepage screen of an internet homepage

8 is a block diagram showing a schematic structure of an Internet hosting database (DB) according to the present invention;

9 is a block diagram showing a detailed module structure for the ERP package according to the present invention.

* Explanation of Signs of Major Parts of Drawings *

1,1a-1n; Client 2; File server

3; Printer server 4a-4n; Client

5; Internet network 6; Network

7; Web browser 10; ERP Hosting Service Center

11a-11n; Web server 12; HTTP

13; Web server engine 14; Servlet

20; LAN 22; Business logic

21,21a-21n; Web application server 23; Application server engine

24; EJB 31; Homepage Main Menu

30; Internet Hosting Service Main Menu Screen

32; ERP Package Main Menu 33; E-Commerce Main Menu

41,41a-41n; DB server 42; Internet hosting DB

43; DBMS engine 50; Homepage DB

50a; Homepage main menu screen 60; ERP DB

60a; ERP Package Main Menu Screen 70; E-commerce DB

70a; E-Commerce Main Menu Screen

In order to achieve the above object, the present invention provides a user interface and a client comprising a web browser required to access a web server through an Internet network; It is composed of an ERP hosting service center connected to the Internet to provide an Internet hosting service.

The ERP hosting service center may be configured to select one of an HTTP required for communicating with a client's web browser and a homepage module, an ERP package module, and an e-commerce module for which an internet hosting service is performed when the client accesses through the web browser. A web server engine that includes a menu applet and a second main menu applet that sequentially selects the main menu of each module, and a Java-generated servlet that processes and processes user requests by multithreading and sends the results to the client. A web server having a; Homepage DB that stores the first data necessary for the operation of the company's homepage on the Internet, provides a memory space, ERP DB that stores the second data required for the operation of the ERP package, and third data required for the operation of the company's e-commerce on the Internet. Internet hosting database (DB), which consists of an e-commerce DB providing memory space and storing data, and DBMS (Database Management), which stores data input by users in each DB and manages data extracted according to user queries. System) DB server having an engine; In response to a menu selection of the ERP package module, homepage module, and e-commerce module from a user, Enterprise Java Beans (EJBs), which provide data stored in the DB server, user authentication, and security services, form an independent platform. It consists of an application server engine and a web application server having various business logics utilized in the enterprise resource planning (ERP) package. The homepage module and the e-commerce module can be accessed by anyone, and the ERP package module has user authentication. The connection is possible only if made.

The ERP package module is a package program that integrates work across corporate activities. It is made of object-oriented Java and consists of a number of independent modules, and each module consists of a number of sub-modules. Only the system can be selected by selecting only modules and submodules.

The ERP package module may include a system information module, a salary information module, an accounting information module, a sales information module, a material purchase information module, a production information module, a trade information module, and an executive information module. It consists of system information DB, HR benefit information DB, accounting information DB, sales information DB, material purchasing information DB, production information DB, trade information DB and management information DB corresponding to the module.

The electronic commerce DB includes a product master DB, a product order DB, a product inventory DB, a payment DB, and a delivery status DB. The sales information DB corresponds to an electronic commerce DB and automatically maintains consistent data in real time at all times. It includes the product master DB, product order DB, product inventory DB, payment DB, and delivery status DB to be replicated.

According to another feature of the invention, the client having a web browser; An ERP hosting service method using an internet of an ERP hosting service system comprising an ERP hosting service center, comprising: accessing a web server of an ERP hosting service center using a web browser installed on the client, and accessing the web server. And providing a main menu screen of the Internet hosting service to the client's web browser, and determining whether one of the homepage main menu, the ERP package main menu, and the e-commerce main menu is selected. If is selected, the main menu screen of the ERP package is provided to the authenticated user through the user authentication procedure.If the homepage main menu or the e-commerce main menu is selected, the selected homepage main menu screen or the e-commerce main menu screen is displayed without authentication procedure. Provided Step, and the user selects one of the system information module, HR benefit information module, accounting information module, sales information module, material purchasing information module, production information module, trade information module and manager information module from the main menu screen of the ERP package. Determining whether to select a plurality of submenus included in the selected main module and which application programs therein; and selecting a corresponding screen of the selected application program according to the selection as an applet-type document through a web server of a client. Determining whether the class corresponding to the application exists in the DB server through the web application server to search for information desired by the user, and if it exists in the DB server, the retrieved data value of the client through the web server. Characterized by consisting of the steps shown in the web browser Provides an ERP hosting service method using the Internet.

In addition, the present invention shows the step of showing the latest product catalog on the screen when the user selects the e-commerce main menu as a result of the determination, when the user searches the catalog of the product displayed on the web browser to order the desired product The data entered in the product order DB of the commerce DB is automatically copied to the product order DB included in the sales information DB of the ERP DB by the automatic replication method, and the data calculated from the product inventory calculation of the ERP package is stored in the ERP product inventory DB. Automatically replicated to the product inventory DB of the e-commerce DB by automatic replication so that the buyer can check the latest product inventory when stored in the e-commerce database, and thereafter, when the user pays for the product ordered on the web browser, Automatically replicating the payment data of the payment DB to the payment DB of the ERP DB, and thereafter. When the product is processed for payment according to the payment, the product delivery process is entered in the ERP package and stored in the ERP product delivery processing DB, and the data of the ERP product delivery processing DB is automatically copied to the product delivery status DB of the e-commerce DB. It further includes, the data entered in the e-commerce and ERP package is automatically replicated between the e-commerce DB and the ERP DB with a single input to maintain consistent data at all times in real time.

In addition, when the user selects the homepage main menu on the main menu screen of the Internet hosting service, the web server shows the user the main menu of the homepage to the web browser of the client, and the user from the homepage uniquely produced for each company. The method further includes searching for a necessary menu among menus of the company's company profile, data base, bulletin board, product introduction, and cool site.

As described above, in the present invention, each company can access the ERP hosting service center through the Internet using only a terminal equipped with a web browser, and can use ERP programs required for computerization without restriction of time and place. The cost of introducing expensive ERP and hardware, which are difficult to adopt, and the maintenance of data and system can be reduced.

In addition, the present invention provides an integrated Internet solution capable of simultaneously promoting the enterprise through the Internet homepage, the use of electronic bulletin boards, e-mails, archives, etc., and electronic shopping malls capable of electronic commerce and ERP hosting services at the same time It can strengthen the competitiveness of the company.

Furthermore, in the present invention, the ERP program is made of object-oriented Java, and ERP is composed of a plurality of independent modules, and each module is composed of a plurality of submodules. It is possible to build the system by selecting by module and sub module, and it is easy to change and add in a short time, and it can be easily operated on the platform selected by the user without being dependent on any hardware, operating system (OS) or database. .

(Example)

Hereinafter, the present invention will be described in more detail with reference to the accompanying drawings.

1 is a schematic block diagram of an ERP hosting service system using the Internet according to the present invention, FIG. 2 is a system configuration diagram of an ERP hosting service center of the present invention, and FIG. 3 is a customer required to receive an ERP hosting service of the present invention. One configuration example of the system, FIG. 4 is a detailed block diagram reconfiguring the system configuration of FIGS. 1 to 3 to conveniently explain the ERP hosting service system according to the present invention.

First, referring to FIG. 1, the ERP hosting service system using the Internet according to the present invention has an ERP hosting service center 10 serving as a plurality of clients 1a-1n and one server when viewed in large scale. It consists of a client / server system connected via.

Therefore, each customer can receive services by connecting to the Internet network 5 through the ERP hosting service center 10 and various channels using the respective clients 1a-1n. Here, the customer is a customer who is authenticated by the ERP hosting service center (10). Once the customer has been authenticated, he or she will have a customer ID, a user number, and a password. These customers can see the ERP hosting service center anytime, anywhere. ) To do business. For example, salespeople and managers often live outside or abroad, so if they have a laptop, a web browser, and a modem, they can immediately connect with the Internet ERP hosting service center 10 to handle the necessary work.

FIG. 2 schematically illustrates a system inside the ERP hosting service center 10. First, a plurality of web servers 11a-11n including a web server engine capable of serving the Internet, respectively. Is connected to the LAN 20. In addition, a plurality of web application servers 21a to 21n in which various business logics used in an ERP package exist in various component formats are connected to each LAN 20 by function. In addition, there are several database servers 41a-41n that store data input by users and manage data extracted according to user queries. Finally, a plurality of web servers 11a-11n, a plurality of application servers 21a-21n, and a plurality of database servers 41a-41n in the ERP hosting service center 10 are recovered and recovered in case of failure. The manager clients 61a-61n, which are always waiting to be connected, are connected to the LAN 20.

On the other hand, look at the configuration of each client (1a-1n) system receiving the service of the ERP hosting service center 10, as shown in Figure 3 of the customer's own existing company in the file server (2), printer server ( 3) and a plurality of clients 4a-4n have a network 6 such as a LAN, which is connected to the ERP hosting service center 10 and a dedicated line or public network by a communication interface such as a modem. Connection is possible. In addition, people who use ERP packages from outside, such as salespeople or managers, can easily access them via the laptop's modem. Therefore, various network environments of customers can be easily used without the need for special equipment or technology.

FIG. 4 is a detailed block diagram reconfiguring the system configuration of FIGS. 1 to 3 in order to explain the ERP hosting service system according to the present invention. The client 1 provides an interface to a user and provides an internet network 5. Any type of computer can be used as long as it includes a web browser 7 required to access the web server 11 of the ERP hosting service center 10.

In addition, the ERP hosting service center 10 handles the HTTP 12 required when the web server 11 communicates with the web browser 7 of the client 1, and user requests by multi-threads. And a web server engine 13 including a servlet 14 made in Java to process and send the result to the client 1, the web application server 21 having various kinds of applications utilized in the ERP package. Business logic 22 and Enterprise Java Beans (EJB) 24 that provide a non-conforming lifecycle, persistence, transaction, distribution, and security services for server-side applications and that form an independent platform. The application server engine 23 is provided.

In addition, the DB server 41 is composed of a Database Management System (DBMS) engine 43 and an Internet Hosting DB 42 driven by the DBMS Engine 43. The Internet Hosting DB 42 is shown in FIG. As shown in the figure, the tree structure (hierarchical structure) has a branch like a file structure, and is composed of a homepage DB 50, an ERP DB 60, and an e-commerce DB 70.

Meanwhile, the web server 11, the web application server 21, and the DB server 41 of the client 1 and the ERP hosting service center 10 respectively have hardware (H / W) and operating system (OS) suitable for them. It is not limited to any specific hardware or OS.

The homepage DB 50 may be, for example, a member DB 51, a library DB 52, a bulletin board DB 53, a usage record DB 54, a change history DB 55, a cool site DB 56, or the like. ERP DB (60) includes, for example, eight databases (DB), that is, the system information DB (61), personnel salary information DB (62), accounting information DB (63), sales information DB ( 64), material purchase information DB (65), production information DB (66), trade information DB (67) and management information DB (68), the e-commerce DB (70) is a commodity master DB (71), The product order DB 72, the product inventory DB 73, the payment DB 74, the delivery status DB 75, and the like are included.

On the other hand, the sales information DB 64 is a product master DB 71, product order DB 72, product inventory DB (73), payment DB 74 contained in the e-commerce DB 70 therein In addition to the product status DB (641), product master DB (641), product order DB (642), product inventory DB (643), payment DB (644), delivery status DB (645) And a tax invoice DB 647 and a visit destination DB 648.

Product master DB (71), product order DB (72), product inventory DB (73), payment DB (74), delivery status DB (75) of the e-commerce DB (70), and ERP DB (60) Commodity master DB (641), product order DB (642), product inventory DB (643), billing DB (644), delivery status DB (645) as shown in Figure 6 to be described later automatic triggering (Triggering) ), It has a linkage structure that matches the contents between the corresponding DBs in real time.

The Internet hosting DB 42 can be viewed as a root when compared to the file structure, and the homepage DB 50, the ERP DB 60 and the e-commerce DB 70 can be viewed as one upper folder. The eight information DBs 61-68 belonging to the ERP DB 60 are subfolders of the ERP DB 60, and the plurality of DBs 641-648 belonging to the sales information DB 64 have actual data. A table to be recorded, indicating the terminal file of the file structure.

The system information DB 61, the personnel salary information DB 62, the accounting information DB 63, the sales information DB 64, the material purchase information DB 65, and the production information DB (belonging to the ERP DB 60). 66, the trade information DB 67 and the manager information DB 68 each consist of a plurality of subfolders. Such subfolders may also consist of a number of subfolders and / or files.

First, the ERP package of the present invention, as shown in FIG. 9, the above eight system information DB 61, personnel salary information DB 62, accounting information DB 63, sales information DB 64, material purchase Eight system information modules 61a, HR benefit information module 62a, accounting information module supported by the information DB 65, the production information DB 66, the trade information DB 67, and the manager information DB 68. It consists of 63a, the sales information module 64a, the material purchase information module 65a, the production information module 66a, the trade information module 67a, and the manager information module 68a.

Each of the eight information modules 61a-68a can be operated independently of each unit module, and can be easily integrated by selecting only necessary modules as if using an interface card inserted in a slot of a computer.

The features are briefly described for each module below.

First, the system information module 61a manages matters relating to various environment settings for using the ERP package, the authority for each program, and also monitors which user is using which program and how much. And the overall management function of the system regarding the backup of the data input by the user and the recovery in the event of a future problem.

In addition, the personnel salary information module 62a is largely composed of personnel management, salary basic management, attendance management, salary management, year-end settlement management, and retirement management that manage personnel records. It is possible to analyze various personnel statistics by comprehensively managing the data at a glance, and to easily manage the time and attendance management by easily interfacing the data from the time and attendance carding machine.

In addition, data required by the tax office or bank among documents generated from salary, year-end settlement, etc. can be stored on diskette and submitted to the computer.

Main functions include HR record card registration / inquiry / modification, condition search by personnel information type, organization chart status and search, HR statistics, national pension / medical insurance registration / inquiry, salary / paid pay table registration, bonus differential payment registration You can set and modify the allowance items.

Main outputs include personnel information (statistical data, personnel status by type, personnel record card, organization chart, etc.), daily / monthly attendance table, monthly salary / bonus statement and account book, salary statement, national pension / medical insurance / employment insurance deduction statement , Income tax withholding receipts, various year-end settlement data, taxable documents (Diskette), and retirement statement.

The accounting information module 63a manages deposits, borrowings, fixed assets, tax invoices, bills of paper, notes payables, etc., by using documents and cost documents that are automatically transferred, such as purchase, release, sale, and collection. Financial statements and cost management are possible through various necessary books management and settlement. In particular, it is possible to calculate the estimated profit or loss in real time even if it is not at the end of the month, and immediately see the cash flow.

Main functions include basic data registration function such as account code inquiry / registration, recurring document / department document registration / approval, document list inquiry, cash journal etc. by subsidiary and type (by subsidiary subject, control number, and customer) Inquiry, cost statement by cost code and cost statement by department, financial statement inquiry, bill / payment note, bill receipt / payment statement, deposit, loan, etc., purchase invoice / sales statement, purchase book / sales inquiry, asset Depreciation processing, account registration and inquiry can be done.

Main outputs include account code table, document, document list, schedule, cash statement, monthly statement, general ledger by type, financial statement (profit and loss statement / balance sheet / manufacture cost statement / cash flow statement), purchase / sale book, purchaser / source statement Total table, VAT diskette, asset account book, depreciation book book, budget execution status by department, cost structure by product / department, bill / payment bill, deposit / debt statement, daily / weekly / monthly balance of payment There is a status table.

The sales information module 64a may set sales targets, receive orders from customers according to the established sales targets, ship products, manage sales of the shipped products, and collect money to perform overall sales analysis.

At this time, if there is no stock of the product at the time of order from the customer is automatically interfaced to the production plan of the production information module 66a, the information delivered to the customer and the bill contents are interfaced to the accounting information module 63a.

In particular, in order management, it is possible to identify the delivery date in real time at the same time as the customer's order, and credit evaluation according to the credit limit of the customer is possible. In addition, it is possible to immediately check the progress of the order received (delivered, in production, and if any process is in progress), and also to analyze bad receivables by evaluating the due date of receivables.

Main functions include sales price management, customer service reception and processing function, performance comparison to sales target, order registration and aggregate status inquiry, transaction statement registration / sales accounting status, order status, shipment status, revenue status inquiry, tax Invoice generation, registration and inquiry, sales status by type (by customer category, product classification), collection / receipt status inquiry, account ledger inquiry, product movement and inventory status can be provided.

Major output includes customer list, unit price list, service receipt and processing account book, sales target performance table, transaction statement, tax invoice, date / product / contractor / sales / sales / sales status table, by order / shipment / sales It includes profit statement, sales and collection data analysis table, account ledger, and product collection.

The material purchase information module 65a links the multi-level BOM with the production plan information of the production information module 66a, calculates the material purchase requirements for production, sends the order to the purchaser, and passes the material import inspection. Received only for the material, and at this time, the purchase price of credit accounts by the purchaser is automatically transferred to the accounting information module (63a).

In particular, the purchase requirement calculation calculates the optimal purchase requirement by evaluating the current high, safety inventory, and purchase unit of the material, and the system automatically calculates insoluble / bad material by ABC analysis for the material stored in the warehouse. Inventory valuation at standard cost is possible.

Key functions include inventory management, billing and calculation of purchase requirements based on BOM and production capacity, order processing, purchase receipt management, external returns issue, material import inspection, purchase status and aggregate status by item and customer, and in-house material issue You can register, carry-on registration, inquiry on the status of material release, annual analysis of material issue, inquiry of unused stock, inquiry of balance sheet / refund.

The main outputs include material inventory, purchase requirement adjustment table, purchase invoice, purchase order, purchase status table by item / contractor, non-order status and non-receipt status, material receipt statement, material insolvency, unusable / malignant inventory list, raw and subsidiary inventory Evaluation tables.

Next, the production information module 66a generates an automatic production plan by analyzing sales information, order information, and production capacity (CAPA) of sales information. In its own production, it manages work orders, process management, production equipment management, and workday. As for the produced products, only the quantity passed through the finished product inspection is received in the warehouse so that the management of the defective products can be performed.

In addition, by supplying subsidiary materials to subcontractors, the subcontractor manages the outsourcing production and performs outsourcing inspections on outsourcing products to ensure the quality of outsourcing production.

In particular, it is possible to establish an optimal production plan by simulating the production plan under various conditions, and to improve the quality of the produced product by identifying defects by process through each process control.

The main functions include BOM management with parts table and multi-level structure for each product, reverse BOM management, process status / outsourcing status by product, production plan simulation, production daily report / process inspection status by production instruction, outsourcing status, outsourcing materials release , Facility management, material defect registration and recycling processing, shipment inspection / import inspection / outsourcing inspection registration, shipment inspection / import inspection / outsourcing inspection status inquiry, product defect status inquiry by defective factors, material defect status inquiry by defective factors, Outsourcing defects by defect factors, production equipment management, etc.

Major outputs include process table, product list, BOM list, production plan table, work progress status by lot, process inspection result table, production performance by product, work performance by department, product defect status table, material defect status table, and outsourcing material defect status. There is a table and a production facility resume.

The trade information module (67a) can be broadly divided into export, import, and tariff refund. Export management manages the export progress procedure from Order to Nego. It manages the import process of the company, and links the export information with the import information to interface with the currently available customs refund EDI software.

Main functions include Export Order / LC / Invoice / BL / Invoice / Nego Management, Import Order / LC / BL / Import Cost Registration, Trace Order by Export Order, Drill Down, Import Order You can do drill down for each trace.

The main outputs include export progress table by order and L / C, nego status table, customs clearance table, export report by country (KRW, foreign currency), export report by item (KRW, foreign currency), print order and L / C. There are import progress table by C, receipts, import unit cost by B / L, and import performance table by importing country.

Lastly, the manager information module 68a is a system for supporting the chief executives who are the most important layer of decision making in the enterprise. Therefore, various information that has a decisive influence on the direction of the company's activities, such as the establishment of the company's goals, strategies, and plans, is provided to provide a graph with numbers to make it more accessible.

Key functions include HR statistics, daily sales / funds / collections / inventory information, analysis of the company's business performance (safety / profitability / growth / activity / productivity), and industry trends / competitor trends.

Major outputs include daily management status reports, management analysis funds and graphs, personnel information (statistical data, personnel status, new details, etc.), external information summary reports, performance targets against sales targets, sales trends, profit and loss charts, cost charts And the balance sheet.

As mentioned above, the ERP package is a large-scale management software that links and manages key tasks such as production, material sales, accounting, and human resources. It has scalability that can be easily extended according to its characteristics and characteristics, and integrates the integrated management of information in the company by managing the information in the company in one information system.

Therefore, the present invention system connects all the business processes of the company from sales to production shipments and manages them concurrently to manage production planning, material purchasing, inventory management, and ordering. It provides excellent management information by processing all the company's business flows in a batch and includes a process to perform BPR in parallel in this ERP package.

As such, there are many difficulties in purchasing, installing, operating, and maintaining an ERP package that provides various functions. While solving this problem, the Internet ERP hosting service system according to the present invention that can provide various additional services in addition to the ERP package will be described below with reference to FIGS. 4 to 9.

First, when the user uses the Internet ERP hosting service system according to the present invention, the user drives the web browser 7 installed in his client 1 to access the Internet network 5 (S10). The user then enters a URL (Uniform Resource Locator; Internet or web address) to be accessed in the web browser 7 of the client 1. That is, the Internet address of the ERP hosting service center 10 of the Internet ERP hosting service system of the present invention is input (S20).

When the user enters the Internet address, the client 1 is connected to the web server 11 of the ERP hosting service center 10 through the Internet network 5, in which case the web server 11 is connected to the client 1. The main menu applet 8 of the Internet hosting service is displayed to the web browser 7 of the client 1 through the user and waits for the user's command (S30). Here, the user can select the homepage main menu 31, the ERP package main menu 32, and the e-commerce main menu on the main menu screen 30 of the Internet hosting service implemented by the main menu applet 8 shown in FIG. 5C. Any one of (33) can be selected.

In the ERP hosting service of the present invention, the ERP package main menu 32 may be used only by registered users through a user authentication procedure described below, and the homepage main menu 31 and the e-commerce main menu 33 may be any user. There is no authentication process to enable access.

If the user selects the ERP package main menu 32, the user authentication screen applet for the URL of the Internet hosting service requested by the web browser 7 is downloaded from the web server 11 to the user client 1 and the web is Show to the browser (7) (S50).

Accordingly, the user inputs the client company ID, the user ID, and the password into the user authentication screen applet through the web browser 7 of the client 1 and transmits the same to the web server 11 (S60). After that, the web server 11 delivers the customer ID, the user ID, and the password inputted from the web browser 7 to the EJB 24 of the user authentication class of the web application server 21 and waits for the result (S70).

The user authentication class of the web application server 21 requests a search through the EJB 24 whether the customer ID, user ID, and password entered by the user exist in the DB server 41 (S80).

DB server 41, if the client ID, user ID, password requested by the web application server 21 is present in the database (DB), the authentication result of whether there is a permission to the EJB (24) of the web application server 21 Transfer (S90).

If the authentication result, the user authentication class of the web application server 21 transmits the result of the authentication failure to the unauthenticated user to the web server 11 (S91).

The web application server 21 receiving the authentication failure result shows a message applet indicating that the user authentication has failed to the web browser 7 of the user client 1 through the web server 11, and the new client ID, user ID, password Wait for input (S92).

However, the user authentication class of the web application server 21 transmits a result of successful authentication for the authenticated user to the web server 11 (S100).

If the user is authenticated, the web server 11 shows the main module applet of the ERP package to the web browser 7 of the client 1 to the authenticated user and waits for the user's command (S110).

Here, the main menu screen 60a of the ERP package implemented by the ERP main module applet is a system information module 61a, a personnel salary information module 62a, an accounting information module 63a, and sales information as shown in FIG. 7A. There are eight main modules, namely the main menu, which are the module 64a, the material purchase information module 65a, the production information module 66a, the trade information module 67a, and the manager information module 68a. There are a number of submenus, and each submenu has applications.

For example, the personnel salary information module 62a includes personnel matter management 621, payroll basic management 622, time attendance management 623, payroll management 624, year-end settlement management 625, and retirement management 626. ), There is also a sub-menu such as personnel information management (621), employee information status (621a), conditional search (621b), organization chart (621c) and personnel statistics (621d) and personnel records management ( 621e), code management (621f) and personnel status (621g) there is a couple menu.

The user authenticated on the web browser 7 selects the personnel salary information module 62a among the main modules of the ERP package, and then selects the personnel matter management submenu of the personnel salary information module 62a (S120 and 130). Subsequently, the employee information status program is selected from the personnel information management submenu of the ERP package (S140).

According to the selection, when the selected corresponding screen as shown in FIG. 7A is displayed on the web browser 7 in the form of an applet from the web server 11 to the client 1, the condition for retrieving the desired information, that is, the employee number is displayed. Enter the number input field (620) (S150).

In this case, the web server 11 calls the employee information status class corresponding to the employee information status program selected by the user from the web application server 21. This class performs various processes necessary for giving information desired by the user in the web application server 21 (S160).

The employee information status class of the web application server 21 requests a search through the EJB 24 whether data corresponding to a condition input by the user exists in the DB server 41 (S170). The DB server 41 determines whether the employee information status requested by the web application server 21 exists in the database or not, and transmits the authentication result and the corresponding data value to the EJB 24 of the web application server 21 ( S180).

If the employee information status does not exist in the database as a result of the authentication, the employee information status class of the web application server 21 transmits a result of failing to search for the corresponding data to the web server 11 (S181).

Subsequently, the web application server 21 receiving the failure result shows a message indicating that the employee information status search has failed to the web browser 7 of the user client 1 through the web server 11 and waits for input of a new corresponding condition ( S182).

On the other hand, when the authentication result employee information status is in the database, the employee information status class of the web application server 21 transfers the result and data value that the search succeeds for the corresponding data to the web server 11 (S190).

Subsequently, the web server 11 stores the sublet 14 storing the data value (the detailed record of the employee corresponding to the employee number) received from the employee information status class as shown in FIG. 10A. (7) shows on (S200).

The web browser 7 of the client 1 then waits for the next command from the user. That is, the standby state to select a different application (S210).

If the user clicks the end icon 70 in the main menu of the ERP package on the web browser 7, the application is terminated while displaying the usage time of the ERP package (S220).

On the other hand, when the user selects the homepage main menu 31 on the main menu screen 30 of the Internet hosting service, the web server 11 provides the user with the main menu of the homepage 50a as shown in FIG. 7C. ) Shows to the web browser 7 and waits for the user's command (S300).

Accordingly, the user can select, for example, the homepage 50a that is uniquely made for each company, for example, the company introduction 51a, the library 52a, the bulletin board 53a, the product introduction 54a, and the cool site 55a. The necessary menu can be searched among menus such as S310.

After completing the menu navigation, clicking the end icon on the web browser 7 terminates the use of the homepage on the Internet (S320).

Meanwhile, when the user selects the e-commerce main menu 33 on the main menu screen 30 of the internet hosting service, the web server 11 displays the main menu screen 70a of the e-commerce as shown in FIG. 7C to the user. Show to the web browser 7 of the client 1 and wait for the user's command (S400).

Thereafter, the user may examine details of the items he / she needs in detail, reserve a purchase using the shopping cart menu 73a, and confirm the purchase using the order confirmation menu 72a to make a payment (S410).

When the e-commerce is finished, when the end icon is clicked on the web browser 7, the use of the e-commerce on the Internet is terminated (S420).

In FIG. 7C, the member number 71a is a user guide menu for electronic commerce, and 74a is a product search menu for searching for a product for commerce.

Hereinafter, the electronic commerce method according to the present invention will be described in more detail with reference to FIG. 6.

First, the user selects the e-commerce main menu 33 on the main menu screen 30 of the Internet hosting service using the web browser 7 to start the e-commerce (S500).

Meanwhile, in the present invention, when a product catalog is input from the ERP package, the product master DB 641 of the ERP DB 60 is stored and the changed data of the ERP DB 60 maintains consistency with the e-commerce DB 70. In order to automatically duplicate the product master DB 71 of the electronic commerce DB 70 by a triggering rule (push method). As a result, the contents of the ERP DB 60 and the e-commerce DB 70 always match each other, and thus, the latest product catalog is displayed on the screen in the e-commerce main menu screen 70a (S510).

Thereafter, the user searches through the catalog (produced by text, image, fight, and video) of the goods displayed on the web browser 7 and places an order using the shopping bag 75a and the shopping cart 73a. According to the order, the data inputted to the product order DB 72 of the electronic commerce DB 70 is automatically copied to the product order DB 642 of the ERP DB 60 by an automatic replication method (push method). Therefore, the latest order data of the e-commerce is utilized in the delivery or production information by utilizing in real time in the ERP package (S520).

In addition, when the user orders the required product, the data calculated in the product inventory calculation of the ERP package is stored in the ERP product inventory DB (643) and automatically automatically to the ERP product inventory DB (73) of the e-commerce DB by automatic replication. It is duplicated so you always have the latest stock.

Thereafter, the user pays for the goods ordered on the web browser 7 using the online account number or credit card number (S530). Accordingly, the billing data of the e-commerce billing DB 74 is automatically replicated to the billing DB 644 of the ERP DB. This latest payment data is utilized in real time in the ERP package for accounting or accounts receivable information.

Thereafter, when the payment is made, the product delivery process is input from the ERP package and stored in the ERP product delivery process DB 645, and this data is automatically and immediately replicated in the product delivery status DB 75 of the e-commerce DB. Therefore, by using the latest shipping status of the product, the user can check in real time the information of whether the goods he ordered from the current warehouse or on the move (S540).

When the delivery status inquiry is completed, the web browser 7 waits for the next command while continuing to show the e-commerce menu to the user (S550). That is, it waits to place an order for a new product or to end an e-commerce.

As described above, in the present invention, as the data of the ERP package and the e-commerce DB (60, 70) are linked, various data (order information, payment information) input from the e-commerce site and the data (product catalog information) input from the ERP package site , Product inventory information, product delivery information) is stored only once once automatically replicated between the e-commerce DB (70) and ERP DB (60), so that it is possible to maintain consistent data at all times in real time and work processing time by double input In addition, the efficiency of the work can be obtained by eliminating the input error caused by the double input.

In the electronic commerce of the present invention, as the data of the electronic commerce DB is automatically copied to the ERP DB as described above, the user can order goods even at dawn or at night, for example, outside of normal working hours.

Furthermore, in the present invention, in addition to the data matching function by the automatic replication between the electronic commerce DB 70 and the ERP DB 60, when using an ERP package, the transaction details in any one transaction generation unit (One Place). Simply enter (One fact) once, providing the functionality of an integrated database that is processed in real time to the final accounting department. This integrated database function can be used repeatedly to input data, so that end-users can always search and process consistent data.

As described above, in the present invention, each company can access the ERP hosting service center through the Internet using only a terminal equipped with a web browser, and can use ERP programs required for computerization without restriction of time and place. The cost of introducing expensive ERP and hardware, which are difficult to adopt, and the maintenance of data and system can be reduced.

In addition, the present invention provides an Internet integrated solution that enables an electronic shopping mall capable of using the ERP hosting service and the use of electronic bulletin boards, e-mails, archives, cool sites, and e-commerce as well as promotion of the company through the Internet homepage. It can enhance your company's competitiveness by providing functions.

Furthermore, in the present invention, the ERP program is made of object-oriented Java, and ERP is composed of a plurality of independent modules, and each module is composed of a plurality of submodules. It is possible to build the system by selecting by module and sub module, and it is easy to change and add in a short time, and it can be easily operated on the platform selected by the user without being dependent on any hardware, operating system (OS) or database. .

In the above, the present invention has been illustrated and described with reference to specific preferred embodiments, but the present invention is not limited to the above-described embodiments and is not limited to the spirit of the present invention. Various changes and modifications can be made by those who have

Claims (6)

A client that provides an interface to a user and includes a web browser required to access a web server through an Internet network; First main menu applet and each module for selecting one of HTTP necessary for communicating with the client's web browser and a homepage module, an ERP package module, and an e-commerce module in which an Internet hosting service is performed when the client accesses through the web browser. A web server with a web server engine that includes a servlet written in Java to sequentially display a second main menu applet that allows the user to select the main menu, and to process, process, and send the result to the client by multi-threading. Wow, Homepage DB that stores the first data necessary for the operation of the company's homepage on the Internet, provides a memory space, ERP DB that stores the second data required for the operation of the ERP package, and third data required for the operation of the company's e-commerce on the Internet. Internet hosting database (DB), which consists of an e-commerce DB providing memory space and storing data, and DBMS (Database Management), which stores data input by users in each DB and manages data extracted according to user queries. DB server equipped with System) engine, In response to a menu selection of the ERP package module, homepage module, and e-commerce module from a user, Enterprise Java Beans (EJBs), which provide data stored in the DB server, user authentication, and security services, form an independent platform. It consists of an ERP hosting service center including an application server engine and a web application server having various business logics utilized in the enterprise resource planning (ERP) package. Anyone can access the homepage module and the electronic commerce module, and the ERP package module is accessible only when user authentication is made. The method of claim 1, wherein the ERP package module is a package program that integrates tasks throughout the enterprise activities, is made of object-oriented Java and composed of a plurality of independent modules, each module is composed of a plurality of submodules ERP hosting service system using the Internet, characterized in that the user can build a system by selecting only the programs necessary for the company in the module and sub-module units. The ERP package module of claim 2, wherein the ERP package module includes a system information module, a personnel salary information module, an accounting information module, a sales information module, a material purchase information module, a production information module, a trade information module, and an executive information module. DB is composed of the system information DB, personnel salary information DB, accounting information DB, sales information DB, material purchase information DB, production information DB, trade information DB and management information DB corresponding to each module, The electronic commerce DB includes a product master DB, a product order DB, a product inventory DB, a payment DB, and a delivery status DB. The sales information DB corresponds to an electronic commerce DB and automatically maintains consistent data in real time at all times. ERP hosting service system using the Internet that includes a product master DB, product order DB, product inventory DB, payment DB, delivery status DB that is replicated to. A client having a web browser; A web server showing a homepage module, an ERP package module, and an e-commerce module in which an internet hosting service is performed when the client is connected, a DB server managing an internet hosting DB including a homepage DB, an ERP DB, and an e-commerce DB, and In the ERP hosting service method using the Internet of the ERP hosting service system consisting of an ERP hosting service center having a web application server that provides data of the corresponding DB through a web server in response to the module selection, Accessing a web server of an ERP hosting service center using a web browser installed on the client; Providing the main menu screen of the Internet hosting service to the client's web browser upon accessing the web server, and determining whether one of the homepage main menu, the ERP package main menu, and the e-commerce main menu is selected; As a result of the determination, when the user selects the ERP package main menu, the user is provided with the main menu screen of the ERP package through the user authentication procedure, and when the homepage main menu or the e-commerce main menu is selected, the homepage main selected without the authentication procedure is selected. Providing a menu screen or an e-commerce main menu screen; On the main menu screen of the ERP package, the user selects one of the system information module, human resources benefit information module, accounting information module, sales information module, material purchasing information module, production information module, trade information module, and manager information module. Determining a plurality of submenus included in the module and which applications are included in the module; According to the selection, the selected screen of the selected application program is displayed in the web browser of the client through the web server in the form of an applet, and the class corresponding to the application is searched in the DB server through the web application server to search for the desired information. To do that, If the determination result is present in the DB server ERP hosting service method using the Internet comprising the step of showing the retrieved data value to the web browser of the client through the web server. The method of claim 4, further comprising: displaying the latest product catalog on the screen when the user selects an e-commerce main menu as a result of the determination; When the user searches the catalog of the product displayed on the web browser and orders the desired product, the data entered in the product order DB of the e-commerce DB is transferred to the product order DB included in the sales information DB of the ERP DB by an automatic replication method. When the data calculated from the product inventory calculation of the ERP package is stored in the ERP product inventory database, the data is automatically replicated to the product inventory DB of the e-commerce DB by automatic replication so that the buyer can check the latest product inventory. Steps, Thereafter, when the user pays for the product ordered on the web browser, automatically replicating the billing data of the e-commerce billing DB to the billing DB of the ERP DB; After that, if the product is processed for payment according to the payment, the product delivery process is entered in the ERP package and stored in the ERP product delivery process DB, and the data of the ERP product delivery process DB is automatically copied to the product delivery status DB of the e-commerce DB. More steps, ERP hosting service method using the Internet, characterized in that the data input from the e-commerce and ERP package is automatically replicated between the e-commerce DB and the ERP DB with a single input to always maintain consistent data in real time. The method of claim 4, wherein when the user selects the homepage main menu on the main menu screen of the Internet hosting service, the web server shows the user the main menu of the homepage to the web browser of the client; The user further comprises the step of exploring the necessary menu from the menu of the company, library, bulletin board, product introduction, cool site of the company from the home page that is uniquely produced for each ERP hosting service using the Internet.