CN1797443A - Data exchange system and method - Google Patents
Data exchange system and method Download PDFInfo
- Publication number
- CN1797443A CN1797443A CNA2004100918876A CN200410091887A CN1797443A CN 1797443 A CN1797443 A CN 1797443A CN A2004100918876 A CNA2004100918876 A CN A2004100918876A CN 200410091887 A CN200410091887 A CN 200410091887A CN 1797443 A CN1797443 A CN 1797443A
- Authority
- CN
- China
- Prior art keywords
- data
- file
- exchange
- submodule
- inventory
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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
[technical field]
The present invention relates to a kind of data exchange system and method, relate in particular to data exchange system and method between a kind of ERP (Enterprise Resource Planning) and the Vendor managed inventory (VMI) system.
[background technology]
All there is the supply chain of oneself in each manufacturing enterprise.Need to conclude the business between buying side and the supplier, buying side constantly purchases direct material to supplier.When suppliers was directly purchased raw material and kept enough inventory levels, most of problem all appeared in the adoption process in buying side.These problems produce reason: buying side makes the relation of workflow management by hand with supplier.Along with the progress of time, these manual operationss, the transaction of wasting time and energy has become the part of daily routines.In addition, buying side is concerned about the details of transaction, analyzes integral status seldom if having time.What purchase is any raw material, that purchases is what in batches, from which suppliers buying, how supplier's cost compares, whether delivery period meets the demands, can how the frequency of shipping reaches company obtain best contractual terms and conditions etc., and these important information are all failed to be linked up well and clearly analyzed.
In the face of information economy era today, the speed of change is more and more fast, and the profit of commodity is more and more low, and aforesaid various information can help the side of buying and product manager to determine to influence the strategy of finance income.These supply data have been arranged, and they just can better consult the contract clause, and the stock is carried out more effective management, thereby reduce cost in whole enterprise.Enterprise is the self competition power that better promotes, then should be towards the strategy of the application system framework of planning with integration enterprises and external resource as enterprise operation and management.In the hope of making full use of Enterprise Resource, cut operating costs and improve whole efficient, reach the benefit of electronic enterprise.On February 5th, 2003, disclosed Chinese No. 1395203 patented invention disclosed a kind of active data warehousing and storage system.This system is between between supplier, virtual inventory center and client, process by a network backbone (Back Bone) active transfer message, and responded effectively, its workflow comprises informalization that the generation, data of data checking, data cleaning, Information integration, new data constitute and data and gathers etc.This system is mainly used in order transmission and data validation between client and the supplier.
Yet, in actual applications, as needing to get in touch more closely between the enterprise of buying side and the supplier, in time transmit both sides' up-to-date information, as inventory information of supplier etc., and the data of both sides exchange are integrated renewal, to Vendor managed inventory (VMI) system and ERP (Enterprise Resource Planning), and need to confirm both sides' whether success of exchanges data with immediate updating.
So a kind of data exchange system and method need be provided, can realize the data transfer between Vendor managed inventory (VMI) system and the ERP (Enterprise Resource Planning) is exchanged; By the hot key that sets in advance, can be with automatically updating data to Vendor managed inventory (VMI) system and ERP (Enterprise Resource Planning); Whether in data exchange process, system can realize automatic tracking enquiry function, successful to confirm exchanges data.
[summary of the invention]
Fundamental purpose of the present invention is to provide a kind of data exchange system, it can be by carrying out exchanges data between Vendor managed inventory (VMI) system and the ERP (Enterprise Resource Planning), realization is to the renewal of above-mentioned two system datas, and exchange process carried out automatic tracking enquiry, confirm whether success of exchanges data.
Another object of the present invention is to provide a kind of method for interchanging data, it can be by carrying out exchanges data between Vendor managed inventory (VMI) system and the ERP (Enterprise Resource Planning), realization is to the renewal of above-mentioned two system datas, and exchange process carried out automatic tracking enquiry, confirm whether success of exchanges data.
For reaching above-mentioned purpose, the invention provides a data exchange system, it can finish exchanges data automatically.This system comprises an application server and a database.Application server is used to obtain supplier's inventory data, order data and other desired data of enterprise, and data are integrated and exchange, be beneficial to upgrade in time ERP (Enterprise Resource Planning) and Vendor managed inventory (VMI) system, it comprises an inventory data update module, supplier's distribution module, a data processing module and a tracking enquiry module.Wherein, the inventory data update module is used for the inventory data of Vendor managed inventory (VMI) system regularly is updated to stock's detail of ERP (Enterprise Resource Planning).Supplier's distribution module is used for enterprise is dispensed to different suppliers in proportion automatically to the demand of goods.Data processing module is used to handle the stored different pieces of information of ERP (Enterprise Resource Planning) and Vendor managed inventory (VMI) system, and it comprises a data-switching submodule, a data integration submodule, a data read submodule, data judgement submodule and an exchanges data submodule.The data-switching submodule is used for (the File Transfer Protocol from FTP, file transfer protocol (FTP)) server obtain required data and with this data backup in database, change mutually according to data memory format, for example format conversion such as EDI, HTML, E-mail literal are become the XML form or the XML format conversion become forms such as EDI, HTML, E-mail literal.The data integration submodule is used for the data after the format conversion are imported system, and the identical entry of data (as amount of parts etc.) is integrated (as adding up etc.).The data read submodule is used to read the data after the integration, carries out in the single file mode during reading of data.Data judge that submodule is used for when reading of data, judge the capable data that read whether correct, and generate new file according to judged result, the data of right and wrong are stored respectively, if all data all are correct or all are wrong, then only generate a file.The exchanges data submodule is used for judgement and the data after integrating, and replaces the original of ftp server storage, then can be with data file update to ERP (Enterprise Resource Planning) and Vendor managed inventory (VMI) system by the hot key that sets in advance.The tracking enquiry module is used for data exchanges is checked automatically whether successfully to confirm exchange, and do one and check recording storage in an information kit that this information kit is deposited in the database.The data that database is used to back up the data obtained from ftp server and storage integration after upgrading.
The present invention also provides a kind of method for interchanging data, and this method may further comprise the steps: obtain required data from ftp server, and with the data backup of obtaining in database; Change mutually according to data memory format, for example format conversion such as EDI, HTML, E-mail literal are become the XML form or the XML format conversion become forms such as EDI, HTML, E-mail literal; Data after the format conversion are imported system, and the identical entry of data (as amount of parts etc.) is integrated (as adding up etc.); Read the data after the integration, carry out in the single file mode during reading of data; When reading of data, judge the capable data that read whether correct, generate new file according to judged result, the data of right and wrong are stored respectively, if all data all are correct or all are wrong that then only generate a file, this document is stored in the database; Correct file conversion in the new file that generates can be become the file of other form as required; File after the format conversion is replaced the original that ftp server is stored, and wrong file then is stored in another information kit, if judge the no any correct data in back, does not then carry out the exchange of file, only wrong file is stored in another information kit of ftp server; Exchange is checked automatically to data, confirms whether exchange is successful, checks record if exchange successfully then to preserve, if swap fault then returns a failure cause earlier, preserves and checks record, and this checks the information kit of recording storage in database.
Utilize the present invention, can realize the exchanges data between Vendor managed inventory (VMI) system and the ERP (Enterprise Resource Planning), and can be by the hot key that sets in advance, with automatically updating data to Vendor managed inventory (VMI) system and ERP (Enterprise Resource Planning), in data exchange process, whether system can realize automatic tracking enquiry function, successful to confirm exchanges data.
[description of drawings]
Fig. 1 is the Organization Chart of data exchange system of the present invention.
Fig. 2 is the functional block diagram of the application server of data exchange system of the present invention.
Fig. 3 is the part EDI data transfer synoptic diagram of data exchange system of the present invention.
Fig. 4 is a method for interchanging data process flow diagram of the present invention.
Fig. 5 is the order process flow diagram of method for interchanging data of the present invention.
[embodiment]
For ease of understanding, below brief description done in technical term involved in the present invention:
ERP:Enterprise Resource Planning, ERP (Enterprise Resource Planning).
VMI:Vendor Managed Inventory, the Vendor managed inventory (VMI) system.
FTP:File Transfer Protocol, file transfer protocol (FTP).
EDI:Electronic Data Interchange, electronic data interchange.
EDI846: be a kind of EDI form, be used for supplier and send the related data of tank farm stock, can freely be provided with according to both sides user's needs and send and the frequency that receives that as per hour sending twice, it is two inferior that the other side per hour receives to enterprise.
EDI862: be a kind of EDI form, be used for enterprise to the order notice that supplier sends, manually sent by the user, supplier can freely be provided with the frequency of reception as required.
EDI856: be a kind of EDI form, be used for supplier, the frequency that sends with reception can freely be set according to both sides user's needs to the shipment notice that enterprise sends.
EDI861: be a kind of EDI form, be used for enterprise and confirm that to the shipment that supplier sends manually sent by the user, supplier can freely be provided with the frequency of reception as required.
As shown in Figure 1, be the Organization Chart of data exchange system of the present invention.Data exchange system 1 is made up of an application server 10 and a database 11.This data exchange system 1 is connected with ERP (Enterprise Resource Planning) 3 by ftp server 2, and holds computing machine 6 to be connected by network 4 with a Vendor managed inventory (VMI) system 5 and a plurality of user.Network 4 can be an intranet (Intranet), also can be internet (Internet) or other type communication network.
As shown in Figure 2, be the functional block diagram of the application server of data exchange system of the present invention.Application server 10 is used to obtain supplier's inventory data, order data and other data of enterprise, and data are integrated and exchanged, and ERP (Enterprise Resource Planning) 3 and Vendor managed inventory (VMI) system 5 are beneficial to upgrade in time.This application server 10 comprises an inventory data update module 100, supplier's distribution module 101, a data processing module 102 and a tracking enquiry module 103.Wherein, inventory data update module 100 is used for the inventory data of Vendor managed inventory (VMI) system 5 regularly is updated to stock's detail of ERP (Enterprise Resource Planning) 3.Supplier's distribution module 101 is used for enterprise is dispensed to different suppliers in proportion automatically to the demand of goods.Data processing module 102 is used to handle the stored different pieces of information of ERP (Enterprise Resource Planning) 3 and Vendor managed inventory (VMI) system 5, and it comprises that a data-switching submodule 1020, a data integration submodule 1021, a data read submodule 1022, data judge a submodule 1023 and an exchanges data submodule 1024.Data-switching submodule 1020 be used for from ftp server 2 obtain required data and with this data backup in database 11, change mutually according to data memory format, for example format conversion such as EDI, HTML, E-mail literal are become the XML form or the XML format conversion become forms such as EDI, HTML, E-mail literal.Data integration submodule 1021 is used for the data after the format conversion are imported system, and the identical entry of data (as amount of parts etc.) is integrated (as adding up etc.).Data read submodule 1022 is used to read the data after the integration, carries out in the single file mode during reading of data.Data judge that submodule 1023 is used for when reading of data, judge the capable data that read whether correct, for example whether judgment data mates etc., the condition of its judgement can be provided with and revise.Then, generate new file, the data of right and wrong are stored respectively, all be correct or all be wrong, then only generate a file as if all data according to judged result.Exchanges data submodule 1024 is used for judgement and the data after integrating, and replaces the original of ftp server 2 storages, can be with data file update to ERP (Enterprise Resource Planning) 3 and Vendor managed inventory (VMI) system 5 by the hot key that sets in advance.Tracking enquiry module 103 is used for data exchanges is checked automatically whether successfully to confirm exchange, and do one and check recording storage in an information kit that this information kit is deposited in the database 11.
As shown in Figure 3, be the part EDI data transfer synoptic diagram of data exchange system of the present invention, the system that carries out data transfer is respectively ERP (Enterprise Resource Planning) 3 and Vendor managed inventory (VMI) system 5.Vendor managed inventory (VMI) system 5 sends data file EDI846 to ERP (Enterprise Resource Planning) 3, is data such as relevant tank farm stock.The tank farm stock that ERP (Enterprise Resource Planning) 3 reaches the other side according to demand sends the notice EDI862 that orders goods to Vendor managed inventory (VMI) system 5, promptly send shipment notice EDI856 after Vendor managed inventory (VMI) system 5 deployed types of merchandize and the quantity, after 3 pairs of shipment Notification Validations of ERP (Enterprise Resource Planning) are errorless, promptly send shipment and confirm that EDI861 is to Vendor managed inventory (VMI) system 5.
As shown in Figure 4, be method for interchanging data process flow diagram of the present invention.At first, data-switching submodule 1020 obtains required data (step S1) from ftp server 2.With the data backup (step S2) in database 11 of obtaining.Change mutually according to data memory format, for example format conversion such as EDI, HTML, E-mail literal are become the XML form or the XML format conversion become forms (step S3) such as EDI, HTML, E-mail literal.Data integration submodule 1021 imports system with the data after the format conversion, and the identical entry of data (as amount of parts etc.) is integrated (as adding up etc.) (step S4).Data read submodule 1022 reads the data after the integration, carries out (step S5) in the single file mode during reading of data.Whether correctly data are judged submodule 1023 when reading of data, judge institute's capable data that read (step S6).Generate new file according to judged result, the data of right and wrong are stored respectively, if all data all are correct or all are wrong that then only generate a file, file storage is (step S7) in database 11.Data-switching submodule 1020 can become the correct file conversion in the new file that generates the file (step S8) of other form as required.Exchanges data submodule 1024 is replaced the file after the format conversion original of ftp server 2 storages, wrong file then is stored in another information kit, if judge the no any correct data in back, then do not carry out the exchange of file, only wrong file is stored in another information kit (step S9) of ftp server 2.Whether successfully tracking enquiry module 103 will be checked automatically to the data exchange, confirm exchange (step S10).If exchange successfully then to preserve and check record (step S11); If swap fault then returns a failure cause (step S12) earlier, carry out the recorded and stored of step S11 again, this checks the information kit of recording storage in database 11, process ends.
As shown in Figure 5, be the order process flow diagram of method for interchanging data of the present invention.At first, select cargo information, and inquire about the tank farm stock (step S20) of Vendor managed inventory (VMI) system 5 by native system according to requirement of enterprise.Native system generates an inventory data with the data of the relevant tank farm stock that obtains from Vendor managed inventory (VMI) system 5, after system exchanges data, this inventory data is passed to ERP (Enterprise Resource Planning) 3 (step S21).After enterprise obtains inventory data, send the notice (step S22) of ordering goods, system generates order data (step S23) automatically according to product type in the notice and data such as quantity, and according to ratio the quantity of goods demand is dispensed to different suppliers (step S24).After supplier receives the notice of ordering goods, generate shipment data and include but not limited to Description of Goods, quantity, shipment date, Shipping Method, customer name, shipment place, the goods amount of money, data (step S25) such as the transportation amount of money, tax and total charge.System exchanges the back to data and sends shipment notice (step S26).Enterprise confirms supplier's shipment notice, and replys supplier (step S27).Supplier generates an invoice data according to the shipment data after confirming, and is sent to (step S28) in the ERP (Enterprise Resource Planning) by native system.
Claims (8)
1. a data exchange system is used for by ftp server and network the data between ERP (Enterprise Resource Planning) and the Vendor managed inventory (VMI) system being exchanged, and it comprises an application server and a database, it is characterized in that:
Described application server is used for obtaining required data from supplier and enterprise, and data are integrated and exchanged, and it comprises:
One inventory data update module is used for the inventory data of Vendor managed inventory (VMI) system regularly is updated to stock's detail of ERP (Enterprise Resource Planning);
One supplier's distribution module is used for enterprise is pro rata distributed to different suppliers to the demand of goods;
One data processing module is used to handle the stored different pieces of information of ERP (Enterprise Resource Planning) and Vendor managed inventory (VMI) system; And
One tracking enquiry module is used for data exchanges is checked automatically, whether successfully to confirm exchange, and does one and check that recording storage is in an information kit;
The data that described database is used to back up the data obtained from ftp server and storage integration after upgrading.
2. data exchange system as claimed in claim 1, it is characterized in that, described data processing module comprises a data-switching submodule, be used for from ftp server obtain desired data and with this data backup in database, change mutually according to data memory format.
3. data exchange system as claimed in claim 2 is characterized in that, described data processing module comprises a data integration submodule, is used for the data after the format conversion are imported system, and the identical entry of data is integrated.
4. data exchange system as claimed in claim 3 is characterized in that, described data processing module comprises a data read submodule, is used to read the data after the integration, carries out in the single file mode during reading of data.
5. data exchange system as claimed in claim 4, it is characterized in that, described data processing module comprises data judgement submodule, be used for when reading of data, judge the capable data that read whether correct, and generate new file according to judged result, the data of right and wrong are stored respectively, if all data all are correct or all are wrong, then only generate a file.
6. data exchange system as claimed in claim 5 is characterized in that, described data processing module comprises an exchanges data submodule, is used for judgement and the data after integrating, and replaces the original of ftp server storage.
7. method of utilizing the described data exchange system of claim 1 to carry out exchanges data is characterized in that:
Obtain required data from ftp server, and with the data backup of obtaining in database;
Change mutually according to data memory format;
Data after the format conversion are imported system, and the identical entry of data is integrated;
Read the data after the integration, carry out in the single file mode during reading of data;
When reading of data, judge whether institute's capable data that read are correct, generate new file according to judged result, and the data of right and wrong are stored respectively, all are correct or all are wrong as if all data, then only generate a file;
Correct file conversion in the new file that generates can be become the file of other form as required;
File after the format conversion is replaced the original that ftp server is stored, and wrong file then is stored in another information kit, if judge the no any correct data in back, does not then carry out the exchange of file, only wrong file is stored in another information kit of ftp server; And
Exchange is checked automatically to data, confirms whether exchange is successful, checks record if exchange successfully then to preserve, if swap fault then returns a failure cause earlier, preserves and checks record, and this checks the information kit of recording storage in database.
8. method for interchanging data as claimed in claim 7 is characterized in that, can will finish Data Update after the exchange to ERP (Enterprise Resource Planning) and Vendor managed inventory (VMI) system by the hot key that sets in advance.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2004100918876A CN1797443A (en) | 2004-12-25 | 2004-12-25 | Data exchange system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2004100918876A CN1797443A (en) | 2004-12-25 | 2004-12-25 | Data exchange system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1797443A true CN1797443A (en) | 2006-07-05 |
Family
ID=36818463
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2004100918876A Pending CN1797443A (en) | 2004-12-25 | 2004-12-25 | Data exchange system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1797443A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1976499B (en) * | 2006-12-18 | 2010-05-19 | 中兴通讯股份有限公司 | System for realizing historical short message repeating and method thereof |
| CN101923679A (en) * | 2010-08-04 | 2010-12-22 | 东莞广泽汽车饰件有限公司 | Digital processing code management and control system |
| CN104699861A (en) * | 2015-04-09 | 2015-06-10 | 成都卡莱博尔信息技术有限公司 | Data processing method for main data center |
| CN105302847A (en) * | 2014-05-29 | 2016-02-03 | 三星Sds株式会社 | System and method for processing data |
| CN109584009A (en) * | 2018-11-26 | 2019-04-05 | 上海阿米特数据系统有限公司 | A kind of website data automatic patching system |
| CN110264590A (en) * | 2019-05-09 | 2019-09-20 | 北京善义善美科技有限公司 | A kind of inventory management system and management method |
-
2004
- 2004-12-25 CN CNA2004100918876A patent/CN1797443A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1976499B (en) * | 2006-12-18 | 2010-05-19 | 中兴通讯股份有限公司 | System for realizing historical short message repeating and method thereof |
| CN101923679A (en) * | 2010-08-04 | 2010-12-22 | 东莞广泽汽车饰件有限公司 | Digital processing code management and control system |
| CN105302847A (en) * | 2014-05-29 | 2016-02-03 | 三星Sds株式会社 | System and method for processing data |
| CN105302847B (en) * | 2014-05-29 | 2018-12-07 | 三星Sds株式会社 | Data processing system and method |
| CN104699861A (en) * | 2015-04-09 | 2015-06-10 | 成都卡莱博尔信息技术有限公司 | Data processing method for main data center |
| CN109584009A (en) * | 2018-11-26 | 2019-04-05 | 上海阿米特数据系统有限公司 | A kind of website data automatic patching system |
| CN109584009B (en) * | 2018-11-26 | 2021-10-29 | 上海阿米特数据系统有限公司 | Automatic matching system for website data |
| CN110264590A (en) * | 2019-05-09 | 2019-09-20 | 北京善义善美科技有限公司 | A kind of inventory management system and management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5987423A (en) | Object oriented technology framework for order processing | |
| US7881985B2 (en) | Electronic marketplace providing service parts inventory planning and management | |
| US10102488B2 (en) | Value chain management | |
| US20050177435A1 (en) | Supply chain network | |
| US20020019761A1 (en) | Supply chain architecture | |
| US20030110104A1 (en) | Enhanced vendor managed inventory system and process | |
| Lee et al. | Supply chain integration over the Internet | |
| US20110161189A1 (en) | Extreme Capacity Management in an Electronic Marketplace Environment | |
| US10223657B2 (en) | Facilitating the negotiation of standards for inter-enterprise collaboration between trading partners | |
| US7788160B2 (en) | Method and system for configurable options in enhanced network-based auctions | |
| US20020103725A1 (en) | Inventory and order management tool | |
| US20230298042A1 (en) | System and method for carbon objects, carbon object databases and carbon platform application programming interface | |
| US20050071207A1 (en) | Visibility and synchronization in a multi tier supply chain model | |
| CN1797443A (en) | Data exchange system and method | |
| Sabri et al. | Purchase order management best practices: process, technology, and change management | |
| CN101719244A (en) | Method for processing inventory documents, application server and enterprise network system | |
| Stricker et al. | Market-based workflow management for supply chains of services | |
| WO2001052158A2 (en) | Tupply chain architecture | |
| CN1510600A (en) | Purchasing administration system and method | |
| CN1635521A (en) | Order operating system and method | |
| US8285609B2 (en) | Systems and methods to outsource service and support operations | |
| WO2001002927A2 (en) | Integrated business-to-business web commerce and business automation system | |
| CN1661608A (en) | System and method for controlling shipment | |
| EP1509852A1 (en) | Distribution/power transformers customer support, tracking problems and recalls | |
| Iordache et al. | USING THE ENTERPRISE RESOURCES PLANNING SOFTWARE AS A SAAS IN THE DIGITAL ECONOMY-A CASE STUDY ON ODOO SOFTWARE |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20060705 |