CN1797443A - Data exchange system and method - Google Patents

Abstract

The invention is a data exchange system, able to exchange data of a provider inventory management system and an enterprise resources planning system. The data exchange system comprises an application server and a database, and the application server is used to obtain the data of providers and enterprises and makes data integration and exchange and comprises an inventory data updating module, a provider distributing module, a data processing module and a tracking inquiry module, where the data processing module comprises a data conversion submodule, a data integration submodule, a data reading submoudle, a data judgment submodule and a data exchange submodule. And the database is used to backup the data obtained from FTP server and store and integrate the updated data. The invention also provides a data exchange method for updating the data of the above two systems.

Description

Data exchange system and method

【Technical field】

The invention relates to a data exchange system and method, in particular to a data exchange system and method between an enterprise resource planning system and a supplier management inventory system.

【Background technique】

Every manufacturing company has its own supply chain. Transactions need to take place between the buyer and the supplier, and the buyer continuously purchases direct raw materials from the supplier. Most of the problems arise during the procurement process, when buyers purchase raw materials directly from suppliers to maintain adequate inventory levels. These problems arise because buyers use manual processes to manage relationships with suppliers. Over time, these manual, time-consuming transactions became part of daily activities. In addition, buyers are concerned with the details of the transaction and have little time to analyze the overall situation. What kind of raw materials are purchased, what is the batch size of the purchase, which supplier is purchased from, how the supplier's cost is compared, whether the delivery period meets the requirements, how often the freight is shipped, and whether the company can obtain the best contract terms, etc. These are important None of the information was communicated well and analyzed clearly.

Facing today's information economy era, the speed of change is getting faster and faster, and the profit of commodities is getting lower and lower. The above-mentioned types of information can help buyers and product managers determine strategies that affect financial revenue. Armed with this supply profile, they are able to better negotiate contract terms and manage inventory more effectively, reducing costs across the business. In order to better enhance self-competitiveness, enterprises should adopt an application system architecture that integrates internal and external resource planning of the enterprise as a strategy for enterprise management. In order to make full use of enterprise resources, reduce operating costs and improve overall efficiency, to achieve the benefits of enterprise electronics. China Patent No. 1395203 published on February 5, 2003 discloses an active data storage system. The system is a process of actively transmitting information through a network backbone (Back Bone) between suppliers, virtual inventory centers and customers, and responds effectively. Its workflow includes data verification, data cleaning, data synthesis, new data generation, informalization of data composition, and data aggregation. The system is mainly used for order delivery and data confirmation between customers and suppliers.

However, in practical applications, enterprises as purchasers need closer ties with suppliers, timely transmit the latest information of both parties, such as supplier inventory information, etc., and integrate and update the data exchanged by both parties to real-time Update to the supplier management inventory system and enterprise resource planning system, and need to confirm whether the data exchange between the two parties is successful.

Therefore, it is necessary to provide a data exchange system and method, which can realize the data transfer and exchange between the supplier management inventory system and the enterprise resource planning system; through the preset hotkey, the data can be automatically updated to the supplier management inventory system and the enterprise resource planning system. Enterprise resource planning system; during the data exchange process, the system can realize the automatic tracking and query function to confirm whether the data exchange is successful.

【Content of invention】

The main purpose of the present invention is to provide a data exchange system, which can update the data of the above two systems through data exchange between the supplier management inventory system and the enterprise resource planning system, and automatically track and query the exchange process , to confirm whether the data exchange is successful.

Another object of the present invention is to provide a data exchange method, which can update the data of the above two systems through data exchange between the supplier management inventory system and the enterprise resource planning system, and automatically track the exchange process Query to confirm whether the data exchange is successful.

To achieve the above purpose, the present invention provides a data exchange system, which can automatically complete data exchange. The system includes an application server and a database. The application server is used to obtain the supplier's inventory data, the enterprise's order data and other required data, and integrate and exchange the data, so as to facilitate the timely update of the enterprise resource planning system and the supplier management inventory system, which includes an inventory data update module, a supplier allocation module, a data processing module and a tracking query module. Wherein, the inventory data update module is used to regularly update the inventory data in the supplier management inventory system to the inventory details in the enterprise resource planning system. The supplier allocation module is used to automatically allocate the enterprise's demand for goods to different suppliers in proportion. The data processing module is used to process different data stored in the enterprise resource planning system and the supplier management inventory system, which includes a data conversion sub-module, a data integration sub-module, a data reading sub-module, a data judgment sub-module and a Data exchange sub-module. The data conversion sub-module is used to obtain the required data from the FTP (File Transfer Protocol, file transfer protocol) server and back up the data in the database, and perform mutual conversion according to the data storage format, such as converting EDI, HTML, E-mail text Convert other formats into XML format or convert XML format into EDI, HTML, E-mail text and other formats. The data integration sub-module is used to import the format-converted data into the system, and integrate (such as summation, etc.) the same items of data (such as the number of parts, etc.). The data reading sub-module is used to read the integrated data, and the data is read in a single row. The data judging sub-module is used to judge whether the data of the read row is correct when reading data, and generate a new file according to the judging result, and store the correct and wrong data respectively. If all the data are correct or all If it is wrong, only one file will be generated. The data exchange sub-module is used to replace the original file stored in the FTP server with the judged and integrated data, and then the data file can be updated to the enterprise resource planning system and the supplier management inventory system through the preset hotkey. The tracking query module is used to automatically check the data exchange, confirm whether the exchange is successful, and make an audit record and store it in a folder, which is stored in the database. The database is used to back up the data obtained from the FTP server and to store and integrate updated data.

The present invention also provides a data exchange method, which includes the following steps: obtain the required data from the FTP server, and back up the obtained data in the database; perform mutual conversion according to the data storage format, such as converting EDI, HTML, E -Convert mail text and other formats into XML format or convert XML format into EDI, HTML, E-mail text and other formats; import the data after format conversion into the system, and carry out the same items of data (such as the number of parts, etc.) Integration (such as summation, etc.); read the integrated data, and read the data in a single line; when reading the data, judge whether the data of the read line is correct, generate a new file according to the judgment result, and combine the correct and Wrong data are stored separately, if all data are correct or all are wrong, only one file will be generated and stored in the database; correct files in the generated new files can be converted into other formats as needed files; the converted file will replace the original file stored on the FTP server, and the wrong file will be stored in another folder. If there is no correct data after judging, the file will not be exchanged, and only the wrong file will be stored in Another file folder of the FTP server; automatically audit the data exchange, confirm whether the exchange is successful, if the exchange is successful, save the audit record, if the exchange fails, first return a failure reason, and then save the audit record, which is stored in the database a folder of .

Utilizing the present invention, the data exchange between the supplier management inventory system and the enterprise resource planning system can be realized, and the data can be automatically updated to the supplier management inventory system and the enterprise resource planning system through the preset hotkey, and the data exchange During the process, the system can realize the automatic tracking and query function to confirm whether the data exchange is successful.

【Description of drawings】

Fig. 1 is a structure diagram of the data exchange system of the present invention.

Fig. 2 is a functional block diagram of the application server of the data exchange system of the present invention.

Fig. 3 is a schematic diagram of part of EDI data transmission of the data exchange system of the present invention.

Fig. 4 is a flow chart of the data exchange method of the present invention.

Fig. 5 is an order flow chart of the data exchange method of the present invention.

【Detailed ways】

For ease of understanding, the technical terms involved in the present invention are briefly described below:

ERP: Enterprise Resource Planning, enterprise resource planning system.

VMI: Vendor Managed Inventory, supplier management inventory system.

FTP: File Transfer Protocol, file transfer protocol.

EDI: Electronic Data Interchange, Electronic Data Interchange.

EDI846: It is an EDI format for suppliers to send inventory related data to enterprises. The frequency of sending and receiving can be freely set according to the needs of both users, such as sending twice per hour and receiving twice per hour, etc. .

EDI862: It is an EDI format used for the order notification sent by the enterprise to the supplier, which is sent manually by the user, and the supplier can freely set the receiving frequency according to the needs.

EDI856: It is an EDI format used for shipping notices sent by suppliers to enterprises, and the frequency of sending and receiving can be freely set according to the needs of both users.

EDI861: It is an EDI format, which is used for the shipment confirmation issued by the enterprise to the supplier, which is sent manually by the user, and the supplier can freely set the receiving frequency according to the needs.

As shown in FIG. 1, it is a structure diagram of the data exchange system of the present invention. The data exchange system 1 is composed of an application server 10 and a database 11 . The data exchange system 1 is connected to an enterprise resource planning system 3 through an FTP server 2 , and is connected to a supplier management inventory system 5 and a plurality of client computers 6 through a network 4 . The network 4 can be an intranet, or the Internet or other types of communication networks.

The application server 10 is used to obtain the supplier's inventory data, the enterprise's order data and other data, and integrate and exchange the data, so as to facilitate timely updating of the enterprise resource planning system 3 and the supplier management inventory system 5 . The database 11 is used for backing up the data acquired from the FTP server 2 and for storing integrated and updated data. The FTP server 2 is used to obtain files such as order data provided by the enterprise resource planning system 3 and obtain files such as inventory data provided by the supplier management inventory system 5 through the network 4, and store the processed data files. Data files can be updated to the enterprise resource planning system 3 as well as the vendor managed inventory system 5 . The client computer 6 provides an interactive user interface for users to select and view relevant data.

As shown in Fig. 2, it is a functional block diagram of the application server of the data exchange system of the present invention. The application server 10 is used to obtain the supplier's inventory data, the enterprise's order data and other data, and integrate and exchange the data, so as to facilitate timely updating of the enterprise resource planning system 3 and the supplier management inventory system 5 . The application server 10 includes an inventory data update module 100 , a supplier allocation module 101 , a data processing module 102 and a tracking query module 103 . Wherein, the inventory data update module 100 is used to periodically update the inventory data of the supplier management inventory system 5 to the inventory details in the enterprise resource planning system 3 . The supplier allocation module 101 is used to automatically allocate the enterprise's demand for goods to different suppliers in proportion. The data processing module 102 is used to process different data stored by the enterprise resource planning system 3 and the supplier management inventory system 5, and it includes a data conversion submodule 1020, a data integration submodule 1021, a data reading submodule 1022, a A data judgment sub-module 1023 and a data exchange sub-module 1024 . The data conversion sub-module 1020 is used to obtain the required data from the FTP server 2 and back up the data in the database 11, and perform mutual conversion according to the data storage format, such as converting EDI, HTML, E-mail text and other formats into XML format Or convert XML format into EDI, HTML, E-mail text and other formats. The data integration sub-module 1021 is used to import the format-converted data into the system, and integrate (such as summation, etc.) the same items of data (such as the number of components, etc.). The data reading sub-module 1022 is used to read the integrated data, and read the data in a single row. The data judging sub-module 1023 is used for judging whether the data of the read row is correct when reading data, for example judging whether the data matches, etc. The judging conditions can be set and modified. Then, a new file is generated according to the judgment result, and the correct and wrong data are stored separately. If all the data are correct or all are wrong, only one file is generated. The data exchange sub-module 1024 is used to replace the original file stored in the FTP server 2 with the judged and integrated data, and update the data file to the enterprise resource planning system 3 and the supplier management inventory system 5 through a preset hotkey. The tracking query module 103 is used to automatically audit the data exchange, confirm whether the exchange is successful, and make an audit record and store it in a folder, which is stored in the database 11 .

As shown in FIG. 3 , it is a schematic diagram of part of the EDI data transfer of the data exchange system of the present invention, and the systems for data transfer are the enterprise resource planning system 3 and the supplier management inventory system 5 respectively. The supplier management inventory system 5 sends the data file EDI846 to the enterprise resource planning system 3, which is the data about inventory and so on. The enterprise resource planning system 3 sends an order notification EDI862 to the supplier management inventory system 5 according to the demand and the inventory of the other party. After the shipping notification is confirmed to be correct, the shipping confirmation EDI861 is sent to the supplier management inventory system 5.

As shown in FIG. 4 , it is a flow chart of the data exchange method of the present invention. First, the data conversion sub-module 1020 obtains the required data from the FTP server 2 (step S1). The acquired data is backed up in the database 11 (step S2). Mutual conversion is carried out according to the data storage format, such as converting EDI, HTML, E-mail text and other formats into XML format or converting XML format into EDI, HTML, E-mail text and other formats (step S3). The data integration sub-module 1021 imports the format-converted data into the system, and integrates (such as sums, etc.) the same items of data (such as the number of components, etc.) (step S4). The data reading sub-module 1022 reads the integrated data in a single-line manner (step S5). When the data judging sub-module 1023 reads data, it judges whether the data of the read line is correct (step S6). Generate a new file according to the judgment result, store correct and wrong data respectively, if all data are correct or all wrong, then only generate a file, and the file is stored in the database 11 (step S7). The data conversion sub-module 1020 can convert the correct files in the generated new files into files of other formats as needed (step S8). The data exchange sub-module 1024 replaces the original file stored by the FTP server 2 with the file after the format conversion, and the wrong file is then stored in another folder. If there is no correct data after the judgment, then the exchange of the file will not be carried out, and only the wrong file will be stored. The file is stored in another folder of the FTP server 2 (step S9). The tracking query module 103 will automatically audit the data exchange to confirm whether the exchange is successful (step S10). If the exchange is successful, then save the audit record (step S11); if the exchange fails, then return a failure reason (step S12), and then carry out the record preservation of step S11, the audit record is stored in a file folder in the database 11, and this flow process is ended .

As shown in FIG. 5 , it is an order flow chart of the data exchange method of the present invention. First, select the goods data according to the needs of the enterprise, and query the inventory quantity of the supplier management inventory system 5 through this system (step S20). The system generates inventory data from the data about inventory obtained from the supplier management inventory system 5, and after the system exchanges the data, the inventory data is transferred to the enterprise resource planning system 3 (step S21). After the enterprise obtains the inventory data, it sends out an order notification (step S22), and the system automatically generates an order data according to the product type and quantity in the notification (step S23), and distributes the required quantity of goods to different suppliers in proportion ( Step S24). After receiving the order notification, the supplier generates a shipment data including but not limited to the name of the goods, quantity, date of shipment, shipping method, customer name, place of shipment, amount of goods, amount of transportation, taxes and total amount (step S25). After exchanging the data, the system sends a shipping notice (step S26). The enterprise confirms the supplier's shipping notice and replies to the supplier (step S27). The supplier generates an invoice according to the confirmed shipment data, and sends it to the enterprise resource planning system through the system (step S28).

Claims (8)

1. A data exchange system for exchanging data between an enterprise resource planning system and a supplier management inventory system by an FTP server and a network, comprising an application server and a database, characterized in that: The application server is used to obtain the required data from suppliers and enterprises, and integrate and exchange the data, including: An inventory data update module, used to regularly update the inventory data in the supplier management inventory system to the inventory details in the enterprise resource planning system; A supplier allocation module, which is used to allocate the enterprise's demand for goods to different suppliers in proportion; a data processing module for processing different data stored in the enterprise resource planning system and the supplier management inventory system; and A tracking query module, which is used to automatically audit the data exchange, confirm whether the exchange is successful, and store an audit record in a folder; The database is used for backing up the data acquired from the FTP server and storing and integrating updated data. 2. data exchange system as claimed in claim 1, is characterized in that, described data processing module comprises a data conversion submodule, is used for obtaining required data from FTP server and this data is backed up in database, according to data storage formats to convert each other. 3. The data exchange system according to claim 2, wherein the data processing module includes a data integration sub-module, which is used to import the format-converted data into the system and integrate the same items of data. 4. The data exchange system according to claim 3, wherein the data processing module comprises a data reading sub-module for reading the integrated data, and the data is read in a single row. 5. The data exchange system according to claim 4, wherein the data processing module includes a data judging sub-module for judging whether the data of the read row is correct when reading data, and according to the judgment As a result, a new file is generated, and the correct and incorrect data are stored separately. If all the data are correct or all are wrong, only one file is generated. 6. The data exchange system according to claim 5, wherein the data processing module comprises a data exchange sub-module for replacing the original file stored by the FTP server with the judged and integrated data. 7. A method utilizing the data exchange system according to claim 1 to carry out data exchange, characterized in that: Obtain the required data from the FTP server, and back up the obtained data in the database; Mutual conversion according to the data storage format; Import the format-converted data into the system and integrate the same items of data; Read the integrated data, and read the data in a single row; When reading data, judge whether the data of the read line is correct, generate a new file according to the judgment result, and store the correct and wrong data separately. If all the data are correct or all are wrong, only one file will be generated. documents; The correct files in the generated new files can be converted into files in other formats as needed; Replace the original file stored on the FTP server with the converted file, and store the wrong file in another folder. If there is no correct data after judging, the file will not be exchanged, and only the wrong file will be stored in the FTP server. another folder; and Automatically check the data exchange to confirm whether the exchange is successful, if the exchange is successful, save the audit record, if the exchange fails, first return a failure reason, and then save the audit record, which is stored in a folder in the database. 8. The data exchange method according to claim 7, characterized in that the exchanged data can be updated to the enterprise resource planning system and the supplier management inventory system through a preset hotkey.

Images