KR20030014036A - System for supporting TEXTILE TRADE using internet EPR solution and method thereof - Google Patents

Abstract

PURPOSE: A fiber trade ERP(Enterprise Resource Planning) system using the Internet and a method thereof are provided to make a user use only endowed right in all works by extracting a usage right and a usage level of the user from a database when a member company number, a user ID, and a password are inputted in an active server page being supplied in a server. CONSTITUTION: A web browser is operated(S100). Usage authentication details are inputted in an active server page(S200). A right endowed to a user and an ERP system menu are retransmitted to a web browser(S300). A business to be processed is selected in a hypertext markup language top down menu(S400). A business is performed in accordance with a business processing processor, and a transaction process is requested(S500). A data processor is operated dynamically, and a structural query language is executed(S600). After completing the requested transaction, a processing result is fed back to the web browser(S700).

Description

Textile trading EPR system using internet and its method {System for supporting TEXTILE TRADE using internet EPR solution and method

The present invention relates to a textile trading ERP system and its method using the Internet, in particular, sales management, raw / subsidiary requirements management, purchasing management, production management, logistics management, quality control, shipping and settlement of textile trading companies using the Internet B2B transactions automatically generated by business support services and purchasing management systems for management, preliminary costs, post-cost management, personnel, payroll, finance, accounting and management information, and B2B for yarn companies, textile companies, subsidiary companies and buyers. It relates to a trading system and a service method.

The conventional enterprise resource planning (ERP) system was introduced in the 1990s through the development of distributed processing and computing technology. It was a system that eliminated the duplication of maintenance and management.

The above ERP system is developed by the necessity of unified integrated management related to personnel, salary, finance, accounting, organization, production, sales, etc. in all general companies such as manufacturing, distribution, finance, and service. And only necessary parts can be built or introduced into a separate system.

The ERP system is constructed differently according to the characteristics and requirements of the company to be introduced, and the system is developed only for the processing of the business within the building company, and this is done by the offline company itself using a local area network (LAN) or a dedicated line. It is used as a company-wide resource management system.

In this case, a separate computerized organization is required to operate and manage the system, and the ability to accurately understand and utilize the contents of the database in order to process data analysis data required by users in the organization is closely managed. Additional staff will be needed to develop the analytical program.

In addition, a person in charge must use a separate communication line to handle business in a business trip, and a foreign production plant must use a dedicated line to handle business or establish a separate computer system. The buyer can be contacted by fax or telephone. There was a problem.

Therefore, the object of the present invention to be devised to solve the above problems of the present invention is to develop and service the ERP system using the Internet, no additional computer manpower is required, there is no computer system construction cost and expensive leased line It is to provide ERP system to textile trader at low cost.

Another object is to provide an Internet ERP system method provided in the trade fiber system of the present invention.

The object of the present invention is to run a web browser, and the logic to process the necessary tasks using the ERP system is to enter the member company number, user ID and password in the server (Active Server Page: ASP) provided by the server After checking whether the user is authenticated from the database, it extracts the permission and the level of use and returns it to the web server. It saves the logged-in unique session-ID so that all subsequent operations use only the permissions granted to the user. The ERP system menu assigned to the ID is resent to the web browser.

Select the Hyper Text Markup Language (HTML) corresponding to the task to be processed from the ERP system menu sent to the web browser, and within each HyperText Markup Language document, communicate with the business process and database. Toinbee components are stored, and each Toinbee component is stored to set up a communication path for data processing between a web server, an application server, and a database server, and a structural query language stored as a file in an application server for processing business processes. (Structured Query Language: SQL) and connection variables are stored.

Therefore, the selected hypertext-language processing establishes a communication path between the web server, the application server, and the database server, and inputs and outputs data to the application server during the processing of the business process. It executes the structured query language stored as a file in the file and sends it to the database server. The database server returns the requested data to the Toynbee engine and the application server returns the data requested to the user through the web server. ERP system has achieved the system provided by using the Internet.

1 is a block diagram of the overall configuration of a trade fiber ERP system using the Internet of the preferred embodiment of the present invention,

2 is a drive block diagram of an Internet ERP system of a preferred embodiment of the present invention;

3 is a flowchart illustrating the operation of the Internet ERP system according to a preferred embodiment of the present invention;

4 is a flowchart illustrating an ERP system information providing process for buyers and customers in a preferred embodiment of the present invention;

5 is a flowchart illustrating a B2B transaction process with a yarn supplier that has been transacted by the ERP system of the preferred embodiment of the present invention;

6 is a flowchart illustrating a B2B transaction process with a fabric supplier that has been transacted by the ERP system of the preferred embodiment of the present invention;

7 is a flowchart illustrating a B2B transaction process with a subsidiary material supplier generated by a transaction by the ERP system of the preferred embodiment of the present invention;

8 is a driving flowchart of the Internet ERP system of the preferred embodiment of the present invention.

Description of the main parts of the drawing

1: Textile Company (Trading Company) 2: Internet

3: server 4: buyer, boss

5: overseas factory 6: domestic factory

7: Fabric Maker 8: Yarn Maker

9: Subsidiary Company 10: Security, Certification Company

11: Domestic Bank 12: Overseas Bank

13: Textile Machinery, Company 14: Clothing Wholesaler, Retailer

15: web browser 16: web server

17: Session SGI (CGI)

18: TOINB Agent

19: application server 20: security, authentication processing unit

21: application file system

22: TOINB engine

23: DB server 24: permission processing unit

25: user level and work authority DB

26: ERP and B2B databases

Hereinafter, the configuration of the present invention will be described in detail with reference to the accompanying drawings for a preferred embodiment.

First, the enterprise resource planning (ERP) of the present invention will be referred to as enterprise resource planning, and can manage enterprise-wide data such as financial management, accounting management, production management, sales, inventory management, human resource management, etc. It is a new information system that maximizes productivity by managing management resources in a planned and efficient manner.

In addition to all tasks, ERP is an integrated system that provides optimal decision-making about top and bottom supply systems such as client companies or subcontractors.

1 is a block diagram of the overall configuration of the trade fiber ERP system using the Internet of the preferred embodiment, the fiber company 1 (trade company) is connected to the server 3 through the Internet (2), that is, the data necessary for each operation, that is, sales Management, raw / subsidiary requirements management, purchasing management, production management, logistics management, quality management, shipping and settlement management, preliminary and post-cost management, personnel, salary, finance, accounting, business information input, modification, The buyer and supervisor (4) who accesses the server (3) through the Internet (2) can update, inquire, and print out, and can inquire and output the delivery date, logistics progress, and process work of the order. In addition, through the search for new materials or sample products, you can negotiate the trade terms by using an e-mail with the relevant company, and the overseas factory (5) or the domestic factory (6) connects to the server (3) using the Internet. Display and print the current status of Oda After delivery and production schedules to come and (trading company) goes into the production of textile companies to enter the daily production (1) it shall be managed by immediately identifying possible.

Fabric companies (7), yarn companies (8), subsidiary companies (9) access the server (3) through the Internet (2) to search the order menu, you can query the purchase request for order quantity, delivery location, delivery date, After supplying the order quantity to the delivery place for the required delivery date, the order processing content is input to the server 3 using the Internet 2 based on the confirmation of the delivery place.

In the case of the fabric manufacturer (7), the specifications, fabric conditions, and prices for new fabric materials are frequently entered in the database of the server (3) so that the fabric company (1) (trade company) can use them for cost calculation. In the case of the business (8), data about the kind, condition, price and the like is input into the database of the server (3) at any time.

Textile companies (1) (trade companies) access the servers (3) through the Internet (2) and make textile companies of domestic banks (11) and overseas banks (12) according to L / C, E / L, NEGO, etc. The textile machinery company (13), which can search and refer to the business related to settlement of accounts and accesses the server (3) through the Internet (2), provides the promotion and promotion of new products using the contents of the server, and the clothing and retail The company (14) connects to the server (2) using the Internet (2), and then orders and trades for products or surplus products planned by the textile company (1) (trade company). The security certification company (10) is connected to the server (3) through the Internet (2) and then monitors the user of each step by using the Internet or its own security network, and the result of the server ( 3), and if there is a problem, the server (3) to notify the user.

As shown in FIG. 1, a system having characteristics of flexible adaptation of DB and real-time coupling between data in performing fiber trade using ERP is an information system that can be used by combining a computer and software of a hardware company.

Fig. 2 shows a server activity area page (ASP) from the session CGI 17 (Common Gateway Interface) provided by the web server 16 after driving the web browser 15 in the driving block diagram of the Internet ERP system of the preferred embodiment. After the user inputs the user ID and password, the Toinbee agent 18 connects the user ID and password with the structured query language of the file system stored in the application server 19 as a variable value to the toinbee engine 22 and already operates. The Toynbee engine 22 process is requesting data from the DB server 23. At this time, after checking whether the user is an authenticated user from the ERP and B2B databases 26, the user can extract the permission and the level of use and return it to the web server 16. It stores only the logged-in session-ID so that all subsequent operations use only the permissions granted to the user.

In addition, the ERP system menu assigned to each session-ID is retransmitted to the web browser 15, and the hypertext writing language corresponding to the task to be processed is selected from the ERP system menu transmitted to the web browser 15. Will be processed.

3 is a flowchart illustrating the operation of the Internet ERP system according to a preferred embodiment of the present invention. The server activity area page (Active Server) from the session CGI 17 (Common Gateway Interface) provided by the web server 16 after the web browser 15 is driven. S1 step of driving a page);

S2 step of entering the member company number, user ID and password after the step S1;

Toynbee agent 18 connects the user ID and password with the structured query language of the file system stored in the application server 19 as variable values, passes them to the Toinbee engine 22, and is already running. Requesting data to the DB server 23 in the process S3, and confirming whether the member company is authenticated from the ERP and B2B databases 26;

Step S4 and S5 of searching for an employee belonging to a member company and extracting a use level and a use authority;

The information extracted in the steps S4 and S5 is returned to the WEB server 16 and confirmed by the authentication staff;

The authentication staff identified in step S6 manages and stores the only session-ID that is logged in, and then, based on the department and use authority, the sales management (S7), requirements management (S8), purchasing management (S9), and production / logistics management. (S10), Quality Management (S11), Shipping and Closing (S12), Pre / Post Cost (S13), Personnel / Payment (S14), Financial / Accounting (S15), Management Information (S16), Buyer Management (S17) (CRM), Fabric company management (S18) (SCM), Yarn company management (S19) (SCM), Subsidiary company management (S20) (SCM), Textile machine company management (S21) (SCM), Overseas factory management ( Process all data input, modification, update, deletion, inquiry and output of the task of S22) for use in the authorized task.

Employees of member companies who do not have access to the ERP system can only use the CONTENTS search (S23) as the certified employees.

FIG. 4 is a flowchart illustrating an ERP system information providing process for buyers and customers. The server activity area page (CGI) is provided from a session CGI (17) provided by the web server 16 after the web browser 15 is driven. Step S24 of driving an Active Server Page: ASP);

Step S25 of inputting a buyer ID and a password after step S24;

Toynbee agent 18 sends the buyer ID and password to the Toinbee engine 22 by connecting the structured query language (SQL) of the file system stored in the application server 19 to the tonbee engine 22 as variable values. (22) requesting data to the DB server 23 in the process, in which step S26 confirms whether the authenticated buyer is from the ERP and B2B databases 26;

Step S27 for searching for a buyer in a trading relationship with the member company after the step S26;

Extracting the use right and returning it to the web server 16 to confirm it as an authentication buyer;

Manage and save the only session-ID logged in, search for ODA progress status (S29), logistics progress status (S30), delivery date search (S31), ODA fee search (S32), quality inspection Performing a status search (S33), a new material search (S34), and a sample product search (S35);

Receiving services of a trade company information search (S36), a sales person search (S37), and an email exchange (S38) in the connected server (3);

In addition, unauthenticated buyers are provided with the services of trading company information search (S36), sales person search (S37), and email exchange (S38) in the server 3 connected as a guest.

FIG. 5 is a flowchart illustrating a B2B transaction process with a yarn supplier generated by an ERP system according to a preferred embodiment. The session CGI 17 (Common Gateway Interface) provided by the web server 16 after running the web browser 15 is shown in FIG. Step S39 of driving a server active area page (Active Server Page);

Step S40 of inputting a yarn company ID and a password after step S39;

Toynbee agent 18 connects the company ID and password to the Toinbee engine 22 by connecting the structured query language (SQL) of the file system stored in the application server 19 to the tonbee engine 22 as variable values. Requesting data to the DB server 23 in the engine 22 process, and at step S41, checking whether or not the authorized textile member company is authenticated from the ERP and B2B databases 26;

Step S42 of searching for basic information on the textile member company after step S41;

S43 step of extracting the order;

After the step S43 is returned to the web server 16, if there is an order, order content search (S49), yarn order history output (S50), order receipt and delivery place confirmation (S46), delivery and delivery amount input (S47), Performing a business process of order processing completion check (S48);

If there is no order when connecting, enter the details by yarn type (S49), preliminary items and payment inquiry (S50), search for trade companies (S51), search for textile companies (S52), search for representatives (S53), email exchange (S54) It consists of the steps of receiving work.

FIG. 6 is a flowchart illustrating a B2B transaction process with a fabric supplier generated by a preferred ERP system, and the session CGI (Common Gateway Interface) 17 provided by the web server 16 after the web browser 15 is run. Step S55 of driving a server active area page;

Step S56 of inputting the company ID and password;

After the step S56, the Toynbee agent 18 connects the fabric company ID and password to the Toinbee engine 22 by connecting the structured query language (SQL) of the file system stored in the application server 19 as variable values. Requesting data to the DB server 23 in the already-running Toynbee engine 22 process, wherein step S57 checks whether the authenticated member company is authenticated from the ERP and B2B databases 26;

Step S58 to search for basic information on the fabric member company after step S57;

Step S59 of extracting whether there is an order;

After the step S59 is returned to the web server 16, if there is an order, order content search (S60), fabric order history output (S61), order receipt and delivery place confirmation (S62), delivery and delivery amount input (S63), order Performing business processing of the processing completion confirmation (S64);

If there is no order at the time of connection (S55), enter the fabric condition and unit price (S65), pre-payment and payment expected inquiry (S66), trader search (S67), buyer search (S68), contact search (S69), email exchange The job of (S70) is provided.

FIG. 7 is a flowchart illustrating a B2B transaction process with a subsidiary material supplier that has been transacted by an ERP system. The server is executed from a session CGI (Common Gateway Interface) 17 provided by the web server 16 after the web browser 15 is run. Step S71 of driving an active area page;

Step S72 of inputting a subsidiary company ID and password after step S71;

Toynbee agent 18 transfers the subsidiary company ID and password to the Toinbee engine 22 by connecting to the structured query language (SQL) of the file system stored in the application server 19 as variable values. Requesting data to the DB server 23 in the engine 22 process, and at this time, checking whether the subsidiary member is authenticated from the ERP and B2B databases 26;

Step S74 of retrieving basic information on the subsidiary member company;

S75 step of extracting whether there is an order;

After the step S75 is returned to the web server 16, if there is an order Oda contents search (S76), subsidiary order history output (S77), order receipt and delivery place confirmation (S78), delivery and delivery amount input (S79), orders Performing business processing of the processing completion confirmation (S80);

If there is no order at the time of connection (S71), input of subsidiary materials and unit price (S81), inquiry of inquiries and estimated payment (S82), search of trade company (S83), search of buyer (S84), search of contact person (S85), e-mail It consists of receiving the work of the exchange (S86).

In order to achieve the embodiment of FIGS. 3 to 7 as shown in FIG.

Driving a web browser (S100);

Inputting the use authentication details in the server activity area page (S200);

Re-sending the authority granted to the user and the menu of the ERP system to the web browser (S300);

Selecting a task to be processed from the hypertext creation language TOP DOWN menu (S400);

Working according to the business process processor and requesting transaction processing (S500);

Executing the structural query language by sequentially executing the Toynbee components and dynamically driving the data processing processor (S600);

After the completion of the requested transaction is a step of feeding back the processing result to the web browser (S700).

The driving of the web browser (S100) is to access a web browser on the Internet to access the present invention.

In the step S200 of inputting the use authentication details in the server activity area page, the logic for processing a necessary task using the ERP system is to enter a member company number, user ID and password in the server activity area page provided by the server.

In step S300, the authority and ERP system menu granted to the user are retransmitted to the web browser, after checking whether the user is authenticated from the database, and extracting the use authority and use level, the web server is returned to the web server, and the logged-in only session-ID is returned. It saves and handles only the authority assigned to the user in all subsequent operations, and the ERP system menu assigned to each session-ID is re-sent to the web browser.

In the step S400 of selecting a task to be processed from the hypertext writing language TOP DOWN menu, the hypertext writing language corresponding to the task to be processed from the ERP system menu transmitted to the web browser is selected from the TOP DOWN menu.

The step S500 of requesting transaction processing by working according to the business process processor performs a task of inputting, modifying, updating, deleting, and outputting business content according to the business process processor in the selected hypertext language document. It is a demand.

Step S600 of sequentially executing the ToinBee component to dynamically execute a data processing processor to execute a structural query language is performed by sequentially executing the ToinBy component for transaction processing to a database server. Dynamically running the processor for data processing with the database server executes the structural query language stored as a file in the application server.

After completing the requested transaction, the step of feeding back the processing result to the web browser (S700) is to complete the required transaction in the database server and return the transaction processing result to the web browser through the web server.

Each step described above is a fiber trade ERP system provided by the dynamic engine structure using the Internet.

As described above, the present invention facilitates the efficient use and management of all in-house resources and tasks, and has the effect of optimizing, managing, and integrating enterprise-wide resources. It is an excellent invention in the e-commerce industry because it can provide an ERP system to a textile trader at low cost without cost.

Claims (2)

In an ERP system, The authentication information is extracted from the access information to the ERP database 26 transmitted from the web browser 15 to form a data structure of the session, and the session ID is checked to confirm whether the connection is duplicated among the access information and to give a unique ID to a unique user. Session CGI 17; A toinbee agent 18 requesting user authentication using ASP-ODBC as a web agent; An application server 19 for processing a file system composed of a file system for security and authentication, an SQL linked with the web agent, and performing all system tasks; A security / authentication processor (20) for storing or processing files for security and authentication and for use in the application server (19); An application file system (21) for storing and processing files for use in the session CGI (17) and toinbee agent (18); A toinbee engine 22 which recognizes a component in HTML stored in the web server by a middleware engine unit and requests a DB server to search for data; A DB server 23 which services input / output, update and retrieval of data; A usage right processing unit 24 for processing a user account; A user-specific level and work authority DB 25 for processing a user-specific level; Fiber trading ERP system using the Internet, characterized in that the dynamic engine structure consisting of ERP and B2B database (26) to store and manage all data. ERP fiber trade service method using the Internet Driving a web browser (S100); Inputting the use authentication details in the server activity area page (S200); Re-sending the authority granted to the user and the menu of the ERP system to the web browser (S300); Selecting a task to be processed from the hypertext creation language TOP DOWN menu (S400); Working according to the business process processor and requesting transaction processing (S500); Executing the structural query language by sequentially executing the Toynbee components and dynamically driving the data processing processor (S600); After the transaction is completed, the web trading ERP system service method using the Internet comprising the step of feeding back the processing result to the web browser (S700).