KR20220015059A - ERP Hosting Service System Using Internet and Methodthereof - Google Patents

Abstract

The present invention relates to an ERP hosting service system using the Internet, in which users can access an ERP hosting service center through the Internet using a terminal with only a web browser and can use an ERP program required for computerization of a company at a low cost, and a method thereof. The present invention includes a client including a web browser and an ERP hosting service center. The ERP hosting service center includes: a web server that sequentially displays menus in which an internet hosting service is performed when a client accesses and from which a menu of each module and one of a homepage module, an ERP package module, and an e-commerce module can be selected, and processes a user's requirement to transmit the user's requirement to the client; a DB server that includes a homepage DB, an ERP DB, and an e-commerce DB, and stores data input by users in each DB to manage the data; and a web application server that provides data stored in the DB server in response to a selection of the menu and provides user authentication and security services, wherein the ERP package module may be accessed only when the user authentication is made.

Description

Online-based ERP hosting service system and method {ERP Hosting Service System Using Internet and Methodthereof}

The present invention relates to an ERP (Enterprise Resource Planning) hosting service system using the Internet and a method therefor. In particular, each company uses a terminal equipped with only a web browser to access the ERP hosting service center through the Internet. Therefore, it relates to an ERP hosting service system and method using the Internet that can use the ERP program required for computerization at a low cost.

In general, ERP refers to the package software (S/W) of the corporate information system that integrates the overall business activities such as purchasing, production management, logistics, sales, and accounting. In other words, it means “planned and optimal use of the entire company’s management resources at the same time.” However, in a more comprehensive view, the upper/lower supply system such as customers and subcontractors and the work of related departments within the company are considered at the same time. It is an application that allows you to respond to changes in corporate activities and information technology (IT) that change every moment.

Therefore, customers break away from the approach of developing the information system to suit the corporate environment (taste), and take the method of unconditionally adapting the business process of the company to the ERP where all the cases made are verified, ending with the introduction of a simple package. Rather, there is a trend to newly build the information infrastructure within the company as an integrated system for the overall business. In this case, efforts and will to accommodate changes in the company-wide work environment are essential.

Therefore, the present invention has been devised in consideration of the problems of the prior art, and the purpose is that each company uses a terminal equipped with only a web browser to access the ERP hosting service center through the Internet, and the expensive cost required for corporate computerization It is to provide an ERP hosting service system and method using the Internet that can use the ERP program at a low cost without time and place restrictions.

Another object of the present invention is to promote the enterprise through the Internet homepage at the same time as the ERP hosting service, use the electronic bulletin board, e-mail, data room, cool site, etc. for in-house employees, and Internet integration that can strengthen corporate competitiveness through e-commerce It is to provide an ERP hosting service system using the Internet having a solution function and a method therefor.

Another object of the present invention is to maintain consistent data in real time by automatically replicating data input from e-commerce and ERP packages to interoperate between e-commerce DB and ERP DB with a single input, so that work according to double input An object of the present invention is to provide an ERP hosting service system and method using the Internet that can reduce time and input errors.

Another object of the present invention is to provide an ERP hosting service system and a method that can achieve cost reduction effects such as labor cost, installation site rental, and low maintenance cost for computerized operation personnel of the information system.

Another object of the present invention is that the ERP program is produced in object-oriented Java, so that the system can be built by selecting only the programs necessary for small and medium-sized enterprises in units of modules and sub-modules, and changes and additional extensions are possible within a short time. It is to provide an ERP hosting service system and method that is easy, flexible, and supports open architecture that can be easily operated on the platform selected by the user without being dependent on any hardware, operating system (OS), or database.

In general, such ERP is generally used as a client/server system by purchasing the necessary hardware, system software, and ERP package for each company. That is, the data stored in the server is used in a way that is executed according to the request of the client. Therefore, operating the ERP package is closely related to the client's environment, so it takes a lot of load on the client, so it has a problem that the client's performance must be excellent.

However, to establish ERP for each company in this way is a huge investment for small and medium-sized enterprises, and it requires highly trained computer operation personnel to operate the ERP system. are feeling In particular, companies with several branches or branch offices are increasingly burdened with communication costs by using their own dedicated or public networks.

As described above, in the present invention, each company uses a terminal equipped with only a web browser to access the ERP hosting service center through the Internet, and can use the ERP program required for corporate computerization without time and location restrictions. The cost savings of expensive ERP and hardware, which are difficult to introduce, and data and system maintenance, can be reduced.

In addition, in the present invention, an integrated Internet solution that simultaneously enables the ERP hosting service, corporate promotion through the Internet homepage, the use of electronic bulletin boards, e-mails, archives, cool sites, etc. By providing this function, the competitiveness of the company can be strengthened.

Moreover, in the present invention, the ERP program is produced in object-oriented Java, and the ERP is composed of a number of independent modules, and each module is composed of a number of sub-modules. The system can be built by selecting modules and sub-modules, and it is easy to change and further expand within a short time. It is possible.

In the above, the present invention has been illustrated and described with examples of specific preferred embodiments, but the present invention is not limited to the above-described embodiments, and within the scope of not departing from the spirit of the present invention, common knowledge in the art to which the invention pertains Various changes and modifications will be possible by those who have

In order to achieve the above object, the present invention provides an interface for a user and includes: a client including a web browser necessary to access a web server through an Internet network; It is connected through the Internet and consists of an ERP hosting service center that provides Internet hosting services.

The ERP hosting service center is a first that can select one of the HTTP required when communicating with the client's web browser and the homepage module, the ERP package module, and the e-commerce module that provides the Internet hosting service when the client accesses through the web browser. A web server including a servlet written in Java to sequentially display the main menu applet and a second main menu applet that can select the main menu of each module, and to process and process user requests by multi-threading and send the results to the client. a web server having an engine; Homepage DB that stores the first data necessary for operating the company’s website on the Internet and provides a memory space, ERP DB that stores the second data required for ERP package operation, and is necessary for operating the company’s e-commerce on the Internet. An Internet hosting database (DB) consisting of an e-commerce DB that stores the third data and provides a memory space, stores data input by users in each DB, and manages data extracted according to user queries a DB server having a DBMS (DataBase Management System) engine; In response to menu selections of the ERP package module, homepage module, and e-commerce module from the user, it provides data stored in the DB server, provides user authentication and security services, and includes EJB (Enterprise Java Beans) that forms an independent platform It consists of a web application server equipped with an application server engine and various business logics used in the ERP package. It is characterized in that connection is possible only when this is done.

The above ERP package module is a package program that integrates the overall business activities of the company. It is made in object-oriented Java and consists of a number of independent modules, and each module is made up of a number of sub-modules. You can build a system by selecting only the module and sub-module units.

In addition, the ERP package module is composed of 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 a manager information module, and the ERP DB is each It consists of system information DB, personnel salary information DB, accounting information DB, sales information DB, material purchase information DB, production information DB, trade information DB, and manager information DB corresponding to the modules of

The e-commerce DB includes a product master DB, a product order DB, a product inventory DB, a payment DB, and a delivery status DB, and the sales information DB corresponds to the e-commerce DB and automatically maintains consistent data in real time. Includes product master DB, product order DB, product inventory DB, payment DB, and delivery status DB that are replicated to

According to another feature of the present invention, a client having a web browser; In the ERP hosting service method using the Internet of the ERP hosting service system composed of the ERP hosting service center, the step of accessing the web server of the ERP hosting service center using a web browser installed in the client, and accessing the web server providing the main menu screen of the Internet hosting service to the client's web browser and judging whether any one of the homepage main menu, the ERP package main menu, and the e-commerce main menu is selected; When a menu is selected, the main menu screen of the ERP package is provided to the authenticated user through the user authentication procedure. In the step of providing a screen, the user selects one of the system information module, personnel pay information module, accounting information module, sales information module, material purchase information module, production information module, trade information module and manager information module on the main menu screen of the ERP package. Determining which one is selected and the plurality of submenus included in the selected main module and which application program is selected according to the selection; The step of determining whether the class corresponding to the application program exists in the DB server through the web application server to display it in the client's web browser through the web application server and search for information desired by the user; It provides an ERP hosting service method using the Internet, characterized in that it consists of a step of showing in the client's web browser through a web server.

Furthermore, the present invention provides the steps of displaying the latest product catalog on the screen when the user selects the e-commerce main menu as a result of the determination, and when the user places an order for a desired product by browsing the product catalog displayed on the web browser 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 at the same time, the data calculated from the product inventory calculation of the ERP package is transferred to the ERP product. When stored in the inventory DB, the step of automatically replicating to the product inventory DB of the e-commerce DB by automatic replication so that the buyer can check the latest product stock, and then processing the payment for the product ordered by the user on the web browser In the step of automatically replicating the payment data of the e-commerce payment DB to the payment DB of the ERP DB, and after that, if the product is shipped according to the payment, the product delivery processing is entered in the ERP package to process the ERP product delivery The method further includes the step of being stored in the DB and automatically replicating the data of the ERP product delivery processing DB to the product delivery status DB of the e-commerce DB, wherein the data inputted from the e-commerce and ERP package is combined with the e-commerce DB with a single input It is automatically replicated between ERP DBs to maintain consistent data in real time.

In addition, in the present invention, when the user selects the main menu of the homepage on the main menu screen of the Internet hosting service, the web server shows the main menu of the homepage to the client's web browser to the user; It further includes the step of navigating the necessary menus from the company's company introduction, data room, bulletin board, product introduction, and menus in the cool site.

As described above, in the present invention, each company uses a terminal equipped with only a web browser to access the ERP hosting service center through the Internet and can use the ERP program required for corporate computerization without time and place restrictions. The cost savings of expensive ERP and hardware, which are difficult to introduce, and low cost of data and system maintenance can be obtained.

In addition, the present invention functions as an Internet integrated solution that simultaneously enables the ERP hosting service, corporate promotion through the Internet homepage, electronic bulletin board, e-mail, and data room for in-house employees, and an electronic shopping mall that enables e-commerce. can enhance corporate competitiveness.

Moreover, in the present invention, the ERP program is produced in object-oriented Java, and the ERP is composed of a number of independent modules, and each module is composed of a number of sub-modules. The system can be built by selecting modules and sub-modules, and it is easy to change and further expand within a short time. It is possible.

(Example)

Hereinafter, the present invention will be described in more detail with reference to the accompanying drawings in which preferred embodiments are shown.

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 the ERP hosting service center of the present invention, and FIG. One configuration example of a customer system, Figure 4 is a detailed block diagram of the reconfiguration of the system configuration of Figures 1 to 3 conveniently to 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 a large number of clients 1a-1n and an ERP hosting service center 10 serving as one server in an Internet network 5 . It consists of a client/server system connected through

Therefore, each customer can receive service by connecting to the ERP hosting service center 10 and the Internet network 5 through several channels using each client 1a-1n. Here, a customer is a customer authenticated by the ERP hosting service center (10). Once the customer is authenticated, they have a customer ID, user number, and password, and these customers can use this ERP hosting service center anytime, anywhere, regardless of time and place. It can be connected to (10) to perform work. For example, salespeople or managers mainly spend a lot of life outside or abroad, so if you have a laptop, a web browser, and a modem, you can immediately connect to the Internet ERP hosting service center 10 and process the necessary business wherever you are.

2 is a schematic view of the internal system of the ERP hosting service center 10. First, a plurality of web servers 11a-11n each including a web server engine capable of serving the Internet. is connected to the LAN 20. In addition, the LAN 20 is connected to several web application servers (Application Server) 21a-21n in which various business logics used in the ERP package exist in various component formats for each function. In addition, there are several database servers (DB 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 (DB) servers (41a-41n) in the ERP hosting service center 10 are monitored and in case of failure Manager clients (Clients) 61a-61n, which are always on standby for recovery, are connected to the LAN 20 .

On the other hand, looking at the system configuration of each client 1a-1n receiving the service of the ERP hosting service center 10, the file server 2, the printer server ( 3) and a number of clients (4a-4n) have a LAN-like network (6), and this network (6) connects the ERP hosting service center (10) and a dedicated line or public network by a communication interface such as a modem. It can be accessed using In addition, people who mainly use the ERP package outside, such as salespeople or managers, can easily access it through the modem of their laptop. Therefore, various network environments of customers can be easily used without the need for special equipment or technology.

4 is a detailed block diagram reconfiguring the system configuration of FIGS. 1 to 3 conveniently to explain the ERP hosting service system according to the present invention, wherein the client 1 provides an interface to the user and connects the Internet network 5 Any kind of computer can be used as long as it includes a web browser 7 necessary to connect to the web server 11 of the ERP hosting service center 10 through.

In addition, the ERP hosting service center 10 processes user requests by HTTP 12 and multi-thread required when the web server 11 communicates with the web browser 7 of the client 1 . It has a web server engine 13 including a servlet 14 made in Java to process and send the result to the client 1, and the web application server 21 is used in the ERP package. Various business logic 22 and EJB (Enterprise Java Beans) 24 that constitute an independent platform by providing non-contradictory lifecycle, persistence, transaction, distribution, and security services of server-side applications It has an application server engine 23 that includes.

In addition, the DB server 41 is composed of a DBMS (DataBase Management System) engine 43 and an internet hosting DB 42 driven by the DBMS engine 43, and the internet hosting DB 42 is shown in FIG. As described above, it forms a branch of a tree structure (hierarchical structure) like a file structure, and is largely composed of a homepage DB 50, an ERP DB 60, and an e-commerce DB 70.

On the other hand, the client 1 and the web server 11 of the ERP hosting service center 10, the web application server 21, and the DB server 41 each have appropriate hardware (H/W) and an operating system (OS). ), and is not limited to any specific H/W or OS.

The homepage DB 50 is, for example, a member DB 51 , a data library DB 52 , a bulletin board DB 53 , a usage record DB 54 , a change history DB 55 , a cool site DB 56 , etc. And, ERP DB (60) is, for example, eight databases (DB), that is, 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 manager information DB (68), and the e-commerce DB 70 includes a product master DB (71), It includes a product order DB (72), a product inventory DB (73), a payment DB (74), a delivery status DB (75), and the like.

On the other hand, the above-mentioned business information DB 64 is a product master DB 71, product order DB 72, product inventory DB 73, and payment DB 74 included in the e-commerce DB 70 therein. , delivery status DB (75) and corresponding product master DB (641), product order DB (642), product inventory DB (643), payment DB (644), delivery status DB (645), and customer DB (646) , a tax invoice DB (647) and a visit log DB (648) and the like.

Product master DB (71), product order DB (72), product inventory DB (73), payment DB (74), delivery status DB (75) and ERP DB (60) of the e-commerce DB 70 described above Automatic replication (Triggering) between the product master DB (641), product order DB (642), product stock DB (643), payment DB (644), and delivery status DB (645) of ), it has an interlocking structure that matches the contents between the corresponding DBs in real time.

The Internet hosting DB 42 described above can be viewed as a root when compared to the file structure, and the homepage DB 50, ERP DB 60, and e-commerce DB 70 can be viewed as one parent folder, respectively. In addition, the eight information DBs 61-68 belonging to the ERP DB 60 are subfolders of the ERP DB 60, and a plurality of DBs 641-648 belonging to the sales information DB 64 are actual data. As a table to be recorded, it points to the terminal file of the file structure.

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

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

Each of the above eight information modules 61a-68a can be operated independently and can be easily integrated as if using an interface card by inserting a necessary interface card into a slot of a computer by selecting only the necessary modules.

Hereinafter, the characteristics of each module will be briefly described.

First, the system information module 61a manages various environmental settings for using the ERP package, manages usage rights for each program, and also manages the process of monitoring which users are using which programs and how much It is equipped with the overall management function of the system regarding backup of functions and data entered by the user and recovery in case of future problems.

In addition, the personnel pay information module 62a is largely composed of personnel management, basic salary management, attendance management, payroll management, year-end settlement management, and retirement management for managing personnel records. In personnel management, all employee information By comprehensively managing HR statistics at a glance, it is possible to analyze various personnel statistics, and to easily interface with data from the attendance card machine to manage time and attendance, and to adjust pay through salary simulation according to various conditions.

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

Main functions include HR record card registration/inquiry/modification, conditional search by HR information type, organizational chart status and search, HR statistics, national pension/medical insurance registration/inquiry, monthly/hourly wage table registration, differential bonus payment You can register, set up and edit dividend pay items.

Major outputs include personnel information (statistical data, number of people by type, personnel record card, organization chart, etc.), daily/monthly attendance sheet, salary/bonus details and ledger, salary slip, national pension/medical insurance/employment insurance deduction statement , wage and salary income withholding tax receipts, various year-end settlement data, data submitted to the tax office (Diskette), retirement accounts, etc.

The accounting information module 63a manages deposits, borrowings, fixed assets, tax invoices, receivables, bills of payment, etc. using the slips and various expense slips to which data such as purchase, shipment, sale, and collection are automatically transferred, Financial statements and cost management are possible through various necessary bookkeeping and settlement of accounts. In particular, it is possible to calculate the estimated profit and loss in real time even if it is not at the end of the month, and you can check the cash flow immediately.

Main functions include basic data registration function such as account code inquiry/registration, recurring slip/department slip registration/approval, slip list inquiry, sub-books such as cash register, etc. Ledger inquiry, cost summary by cost code and cost summary by department inquiry, financial statement inquiry, bills to be paid / bills to be paid, bills to be received / statements to be paid, deposits, borrowings, etc. inquiry, purchase invoice / sales statement, purchase book / sales book inquiry, You can process asset depreciation, register/inquire on the ledger, etc.

Major outputs include account code table, slip, slip list, daily statement, cash disbursement statement, monthly statement, general ledger by type, financial statement (income statement/balance sheet/manufacturing cost statement/cash flow statement), purchase/sales book, by purchaser/seller Total statement of invoice, VAT computerized media data (Diskette), asset ledger, depreciation ledger, budget execution status by department, cost structure by product/department, bills to be paid/received, statement of deposit/borrowing status, daily/weekly/monthly funds There is a balance sheet, etc. The sales information module 64a establishes a sales target, receives an order from a customer according to the established sales target, and sells the product.

You can perform overall sales analysis by managing sales and collecting money for shipped products. At this time, if there is no product in stock at the time of ordering from the customer, it is automatically interpolated to the production plan of the production information module (66a).

It becomes a pace, and the items delivered to the customer and the contents of the bill are interfaced to the accounting information module 63a.

In particular, in order management, the delivery date can be grasped 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 status of the order received (delivery, in production, which process is in progress if it is in production), and it is also possible to analyze malicious receivables by evaluating the due date of receivables.

Main functions include unit price management, customer service reception and processing function, performance inquiry against sales target, order registration and aggregate status inquiry, transaction statement registration/sales aggregate status inquiry, profit status inquiry by order/shipment/sales, tax Invoice generation, registration and inquiry, sales status by type (by customer category, product category), collection registration/receipt status inquiry, customer ledger inquiry, product movement history and inventory status, etc. can be provided.

Major outputs include customer list, unit price list, service receipt and processing ledger, sales target performance table, transaction statement, tax invoice, order/shipment/sales status table by date/product/customer, order-by-order/shipment/sales There are profit status table, sales and collection data analysis table, account manager, product receipt and payment department, etc.

The material purchase information module 65a calculates the material purchase requirements required for production by linking the multi-step BOM and the production plan information of the production information module 66a, sends the calculated requirements to the purchaser, and passes the material import inspection Only the materials that have been purchased are received, and at this time, the accounts receivable for each 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 stock, safety stock, and purchasing unit of the material. Inventory valuation based on standard cost is possible.

Main functions include material list management, calculation and adjustment of purchase requirements based on BOM and production capacity, order processing, purchase and receipt management, external return, material import inspection function, purchase status and aggregate status inquiry by item/customer, internal material delivery You can check registration, internal carry-in registration, material shipment aggregate status inquiry, annual material shipment analysis inquiry, unused inventory inquiry, and payment/receipt balance inquiry.

Major outputs include material list, purchase requirement adjustment table, purchase agreement, purchase order, purchase status by item/customer, non-order status and non-stocking status, material receipt/delivery statement, non-receipt of materials, non-use/malicious material list, inventory of raw and subsidiary materials There is an appraisal table, etc.

Next, the production information module 66a generates an automatic production plan by analyzing the sales plan of the sales information, order information and production capacity (CAPA), and manages work order, process management, production facility management, and work daily report in self-production. And for manufactured products, only the quantity that has passed through the finished product inspection can be stored in the warehouse so that defective products can be managed.

In addition, the quality of outsourced production is guaranteed by sending out third-party materials to outsourced companies to manage outsourced production and conducting thorough outsourced inspections on outsourced products.

In particular, the optimal production plan can be established by simulating the production plan under various conditions, and the quality of the produced product can be improved by identifying defect factors for each process through each process management.

Main functions include parts list for each product and BOM management with multi-level structure, reverse reversal BOM management, process status/outsourcing status by product, production plan simulation, production daily report/process inspection status according to production instructions, outsourcing order status, outsourcing material shipment , facility management, material defect processing registration and recycling processing, shipment inspection/import inspection/outsourcing inspection registration, shipment inspection/import inspection/outsourcing inspection status inquiry, product defect status inquiry by defect factor, material defect status by defect factor Inquiry, outsourcing defect status by defect factor, production facility management, etc. can be performed.

Major outputs include process table, product list, BOM list, production plan table, work progress by lot,

There are process inspection result table, production performance by product, work performance by department, product defect status table, material defect status table, outsourced material defect status table, production facility resume, etc.

The trade information module 67a can be largely divided into export, import, and customs refund. Export management manages the export process from order to nego, and import management covers everything from order to import incidental cost management. It manages the import process of the company, and it is possible to interface with the currently commercialized customs refund EDI software by linking export information and import information.

Main functions include export order/LC/invoice/BL/myeonjang/nego management, import order/LC/BL/import cost registration, trace inquiry by export order (Drill Down), import You can search for traces by order (Drill Down), etc.

Major outputs include export progress table by order and L/C, negotiation status table, customs clearance status table, export performance (KRW, foreign currency) statistical table output by country, export performance (KRW, foreign currency) statistical table output by item, order and L/C There are import progress status table by C, receipt certificate, import incidental cost status by B/L, import performance table by importing country, etc.

Finally, the management information module 68a is a system for supporting the top management who is the most important layer in making decisions within the company. Therefore, it is made easier to access by providing graphs along with figures that decisively affect the direction of corporate activities, such as establishing corporate goals, strategies, and plans.

Main functions include personnel statistics information, daily sales/funds/collection/stock information, analysis information on company management performance (safety/profitability/growth/activity/productivity), industry trends/competitor trends, etc.

Major outputs include daily management status report, management analysis funds and graphs, personnel information (statistical data, personnel status, personal details, etc.), external information summary report, performance table against sales target, sales trend table, profit and loss trend table, cost trend table , and the current state of money balance.

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

Therefore, the system of the present invention organically connects all business processes of the company from sales to production and shipment and simultaneously manages them in engineering. It provides excellent management information by collectively processing all of the company's work flow, and includes a process that can perform BPR in parallel in this ERP package.

As mentioned above, there are many difficulties in purchasing, installing, operating, and maintaining an ERP package that provides these various functions in a small and medium-sized business unit. An Internet ERP hosting service system according to the present invention that can provide various additional services in addition to the ERP package while solving these problems will be described below with reference to FIGS. 4 to 9 .

First, when a user uses the Internet ERP hosting service system according to the present invention, the user drives the web browser 7 installed in his/her client 1 in order to access the Internet network 5 (S10). Then, the user inputs 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 a user inputs an Internet address, the client 1 is connected to the web server 11 of the ERP hosting service center 10 through the Internet network 5, and in this case, the web server 11 is the client 1 ), the main menu applet (8) of the Internet hosting service is shown to the user through the web browser (7) of the client (1) and waits for the user's command (S30). Here, the user sees 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 can be used only by registered users through the user authentication procedure described later, and the homepage main menu 31 and the e-commerce main menu 33 can be used by any user. It does not go through the authentication process so that even access is possible.

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). It is shown to the web browser 7 (S50).

Accordingly, the user inputs the customer ID, user ID, and password in the user authentication screen applet through the web browser 7 of the client 1 and transmits the input to the web server 11 (S60). Then, the web server 11 transmits the customer ID, user ID, and password received 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 input by the user exist in the DB server 41 (S80).

The DB server 41 transmits the authentication result of whether the customer ID, user ID, and password requested by the web application server 21 are in the database DB, to the EJB 24 of the web application server 21 . transmit (S90).

If the authentication result indicates that the user authentication class of the web application server 21 has failed to authenticate the unauthenticated user, the result is transmitted to the web server 11 (S91).

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

However, the result that the user authentication class of the web application server 21 has succeeded in authentication for the authenticated user is transmitted to the web server 11 (S100).

When 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, including the module 64a, the material repurchase information module 65a, the production information module 66a, the trade information module 67a, and the manager information module 68a. There are multiple submenus, and each submenu has application programs.

For example, the personnel pay information module 62a includes personnel management 621, basic salary management 622, attendance management 623, salary management 624, year-end settlement management 625, and retirement management ( 626), and in the personnel management 621, the employee information status 621a, search by condition 621b, organization chart 621c, and personnel statistics 621d, such as application programs, personnel record management There are sub menus such as (621e), code management (621f), and personnel status (621g).

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

According to the above selection, if the selected 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, a condition for retrieving the desired information, that is, the employee number, is entered. It is input in the employee 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 . In this class, the web application server 21 performs various processes necessary to provide information desired by the user (S160).

The employee information status class of the web application server 21 requests a search through the EJB 24 to see if data matching the conditions 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 is in the database or not, and delivers the authentication result and the corresponding data value to the EJB 24 of the web application server 21. do (S180).

If, as a result of the authentication, the employee information status is not in the database, the result that the employee information status class of the web application server 21 has failed to retrieve the data is transmitted to the web server 11 (S181).

Then, the web application server 21 receiving the failure result shows the message 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 the input of a new corresponding condition ( S182).

On the other hand, if the employee information status as a result of the authentication is in the database, the employee information status class of the web application server 21 transmits the data value and the result that the data search was successful to the web server 11 (S190).

Next, the web server 11 sends a servlet 14 that stores the data value (detailed record of the employee corresponding to the employee number) received from the employee information status class as shown in FIG. It is displayed on the browser 7 (S200).

Then, the web browser 7 of the client 1 waits for the user's next command. That is, it is a standby state in which another application program can be selected (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 use 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 sends the main menu of the homepage 50a as shown in FIG. 7C to the client 1 ) to the web browser 7 and waits for the user's command (S300).

Accordingly, users can view, for example, the company introduction (51a), the data room (52a), the bulletin board (53a), the product introduction (54a), and the cool site (55a) of the company on the homepage 50a created uniquely for each company. It is possible to search for a necessary menu from among the menus, etc. (S310).

When the end icon is clicked on the web browser 7 after completing the menu search, the use of the homepage on the Internet is terminated (S320).

On the other hand, 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 provides the user with the e-commerce main menu screen 70a as shown in FIG. 7c. It is shown to the web browser 7 of the client 1 and waits for the user's command (S400).

After that, the user can take a closer look at the items he needs, reserve a purchase using the shopping cart menu 73a, confirm the purchase using the order confirmation menu 72a, and then make a payment (S410).

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

In FIG. 7C , reference numeral 71a denotes a user guide menu for e-commerce, and 74a denotes a product search menu for searching for a product for which a commercial transaction is desired.

Hereinafter, an e-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, it is stored in the product master DB 641 of the ERP DB 60 , and the changed data of the ERP DB 60 maintains consistency with the e-commerce DB 70 . For this reason, it is immediately and automatically copied to the product master DB 71 of the e-commerce DB 70 by the triggering rule (push method). As a result, the contents of the ERP DB 60 and the e-commerce DB 70 always coincide with each other, and thus, the latest product catalog is displayed on the e-commerce main menu screen 70a (S510).

Thereafter, the users search the catalog of products displayed on the web browser 7 (made of text, image, sound, and video) and place an order using the shopping bag 75a and the shopping cart 73a. The data input to the product order DB 72 of the e-commerce DB 70 according to the order is immediately and 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 for e-commerce is always utilized in real time in the ERP package to be used for delivery or production information (S520).

In addition, when a user orders a necessary product, the data calculated from the product inventory calculation of the ERP package is stored in the ERP product inventory DB 643 and immediately and automatically in the ERP product inventory DB 73 of the e-commerce DB by automatic replication. Replicated so you can always check the latest stock.

Thereafter, payment is processed using the online account number or credit card number for the product ordered by the user on the web browser 7 (S530). Accordingly, the payment data of the e-commerce payment DB 74 is automatically copied to the payment DB 644 of the ERP DB. These latest payment data are utilized in real-time in the ERP package to be used for accounting or receivables information.

After that, when payment is made, product delivery processing is input from the ERP package and stored in the ERP product delivery processing DB 645, and this data is immediately and automatically copied to the product delivery status DB 75 of the e-commerce DB. Therefore, by using the latest product delivery status, users can check in real time information on whether the product they have ordered has left the warehouse or is moving (S540).

When the above-mentioned delivery status inquiry is completed, the web browser 7 waits for the next command while continuously showing the e-commerce menu to the user (S550). That is, it waits whether to place an order for a new product or terminate the 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 data input from the ERP package site (product category) Log information, product inventory information, product delivery information) are automatically replicated between the e-commerce DB 70 and the ERP DB 60 when they are stored only once, so that consistent data can be maintained in real time and work by double input It reduces processing time and also brings efficiency to work by eliminating input errors caused by double input.

In the e-commerce of the present invention, as the data of the e-commerce DB is automatically copied to the ERP DB as described above, the user can place an order for a product even at a time other than normal working hours, for example, early in the morning or at night.

Moreover, in the present invention, when using the ERP package as well as the data matching function by automatic replication between the e-commerce DB 70 and the ERP DB 60, the transaction is performed in any one transaction generating department (One Place). It provides the function of an integrated database that is processed in real time to the final accounting department by inputting one fact only once. Since this integrated database function can repeatedly utilize the data entered once, the end user is always able to search/process the data consistently.

Claims (4)

a client that provides an interface to a user and includes a web browser necessary to access a web server through an Internet network;
A first main menu applet that can select one of HTTP required for communication with the client's web browser, and a homepage module, ERP package module, and e-commerce module that provides Internet hosting service when the client accesses through the web browser, and each A web having a web server engine including a servlet created by Java to sequentially display a second main menu applet that can select the main menu of a module and to process and process user requests by multi-threading and send the results to the client server and
Homepage DB that stores the first data required for the operation of the company's website on the Internet and provides a memory space, the ERP DB that stores the second data necessary for the ERP package operation, and the third data necessary for the operation of the company's e-commerce on the Internet An Internet hosting database (DB) consisting of an e-commerce DB that remembers System) a DB server equipped with an engine,
In response to menu selections of the ERP package module, homepage module, and e-commerce module from the user, it provides data stored in the DB server, provides user authentication and security services, and includes EJB (Enterprise Java Beans) that forms an independent platform It is composed of an ERP hosting service center including an application server engine that
The website module and the e-commerce module can be accessed by anyone, and the ERP package module can be accessed only when user authentication is performed.
The method according to claim 1, wherein the ERP package module is a package program that integrates the overall business activities of the company. ERP hosting service system using the Internet, characterized in that the user can build the system by selecting only the programs necessary for the company in units of modules and sub-modules.
The ERP package module according to claim 2, wherein the ERP package module is composed of 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 a manager information module, DB is composed of system information DB, personnel salary information DB, accounting information DB, sales information DB, material purchase information DB, production information DB, trade information DB and manager information DB corresponding to each module above,
The e-commerce DB includes a product master DB, a product order DB, a product stock DB, a payment DB, and a delivery status DB, and the sales information DB corresponds to the e-commerce DB and automatically maintains consistent data in real time An ERP hosting service system using the Internet that includes the product master DB, product order DB, product inventory DB, payment DB, and delivery status DB that is replicated through the Internet.
a client having a web browser; A web server showing the homepage module, ERP package module, and e-commerce module where the Internet hosting service is provided when a client connects, a DB server that manages the Internet hosting DB including the homepage DB, ERP DB and e-commerce DB, and the client's 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 DB through a web server in response to module selection,
accessing the web server of the ERP hosting service center using the web browser installed in the client;
providing the main menu screen of the Internet hosting service to the client's web browser as the web server is accessed and determining whether any one of the homepage main menu, ERP package main menu, and e-commerce main menu is selected;
As a result of the above determination, if the user selects the ERP package main menu, the main menu screen of the ERP package is provided to the authenticated user through the user authentication procedure. providing a main menu screen or an e-commerce main menu screen;
The user selects any one of the system information module, personnel pay information module, accounting information module, sales information module, material purchase information module, production information module, trade information module and manager information module on the main menu screen of the ERP package and selects the selected state A step of determining which submenu included in the module and which application program included therein to be selected;
According to the above selection, the screen of the selected application program is displayed in the form of an applet on the client's web browser through the web server, and the class corresponding to the application program exists in the DB server through the web application server to retrieve the information desired by the user. judging and
ERP hosting service method using the Internet, characterized in that it comprises the step of showing the retrieved data value on the client's web browser through the web server if the determination result exists in the DB server.