CN108960745A - A kind of WMS system and ERP system interconnection method - Google Patents
A kind of WMS system and ERP system interconnection method Download PDFInfo
- Publication number
- CN108960745A CN108960745A CN201810912823.XA CN201810912823A CN108960745A CN 108960745 A CN108960745 A CN 108960745A CN 201810912823 A CN201810912823 A CN 201810912823A CN 108960745 A CN108960745 A CN 108960745A
- Authority
- CN
- China
- Prior art keywords
- wms
- erp
- erp system
- middle table
- data
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Abstract
The present invention provides a kind of WMS systems and ERP system interconnection method, and the data exchange of WMS system and ERP system is integrated into the operation flow that ERP system integrates WMS system；It using data interchange platform, provides the Database Systems of WMS system and ERP system, application system, dedicated middleware system to access component, is abstracted by interface protocol demand, realize the data exchange of WMS system and ERP system；The middle table of exchange data command information is defined by data interchange platform, after the completion of defining command information middle table, the command information of different nodes is passed to data interchange platform and distributes to respective nodes；After the completion of ERP system business paper, middle table is written into qualified command information, WMS system executes outbound warehouse-in instruction according to command information.In conclusion the present invention shows the information system management level of company and technical advantage, the competitiveness and market position of enterprise are improved, company's comprehensive strength and profitability are enhanced.
Description
Technical field
The present invention relates to a kind of Computer Applied Technologies, more particularly to a kind of WMS system and ERP system interconnection method.
Background technique
To guarantee to produce the quick delivery of mouth, the needs of mistake are reduced, inventory and funds tied up is reduced, promotes my Enterprise Integrated
Benefit and management level, numerous companies can be solved using stereoscopic warehousing system (WMS) and the enterprise information management system (ERP) respectively
The certainly base application of logistics and information flow, enterprise informationization management system can be realized the unification of group financial system, calculate process
Unified, fund unified allocation of resources, financial data is shared, and report merges automatically, simplifies insider transaction；Customer order passes through electronics
Data exchange (EDI) is directly accessed EPR system, generates production order, supplier by vendor platforms can acquiring company order
It is single, it realizes industrial chain collaboration, inventory is effectively reduced；Since ERP system and WMS system are two separate payments respectively, there are letters
Cease isolated island, storage, outbound allot document and need to enter secondary typing, and inefficiency, error rate height, and the period of making an inventory is long, goods
Damage goods difference can not be found in time.
In the comprehensive docking of data, business and functional plane between realization two systems, WMS system and ERP are got through
Information bottleneck between system reaches the loose lotus root splice grafting mouth between two systems and realizes data mode adjustment and con current control,
China Patent Publication No. CN101634944A discloses a kind of interface method of ERP referencing WMS warehousing, and this method is to establish one kind
Program extension mechanism, the interface content of current ERP operation is identified by external program, and carries out legal judgement to interface, is protected
The legitimacy that external program calls is demonstrate,proved, the data that WMS is provided then are obtained by middle table in external program, combination is formed
The information format that ERP needs, the method for the inside in the step ERP that goes forward side by side realize the typing of data information, realize WMS data
It is directed into ERP system.EPR system is not associated with external program, so the independence of same interface routine may be implemented in ERP system,
Because using the method for calling directly ERP system internal standard event in the realization of external program, can also cleverly evade
Because the work of interface routine modification caused by ERP software maintenance or upgrading maintains to realize and stablize.The interconnection method is to pass through
Middle table obtains the data that WMS is provided, and combination forms the information format of ERP needs, the side of the inside in the step ERP that goes forward side by side
Method realizes the typing of data information, realizes that WMS data are directed into ERP system, which system WMS reading data and outside are global
Function call function is more complicated, and development difficulty is larger.
Chinese patent publication No. CN108052402A discloses MES system and the ERP system side of docking in a kind of traditional Chinese medicine extraction
Method includes the following steps, step 1: the data for needing to send in MES or ERP is generated intermediate file, intermediate file is put automatically
Incoming interface file；Step 2: monitor monitors interface document folder, and when monitoring intermediate file, monitor sends a message to clothes
Business device；Step 3: server obtains intermediate file and parses, and the related data of parsing is added to MES system or ERP system
In.The data sent will be needed to be converted to intermediate file, improve stability: data are realized more by monitor and server
Newly, a complete data interaction is constituted, actual information is transparent, timely in entire ERP system and MES system, swimmingly hands over
Mutually transmitting.When the ERP system external harmoniousness platform and MES system of this docking mode carry out data interaction, data transmission is unsmooth, no
It can be realized the data-transformation facility of various modes, to influence the execution efficiency of system.
Summary of the invention
For the above-mentioned prior art, the problem to be solved in the present invention is to provide a kind of WMS systems and the ERP system side of docking
Method realizes that ERP system is docked between WMS system in the comprehensive of data, business and functional plane, gets through WMS system and EPR
Information bottleneck between system realizes smart three-dimensional warehouse logistics.
For up to above-mentioned technical problem is solved, the present invention provides a kind of WMS system and ERP system interconnection method, a kind of WMS system
System and ERP system interconnection method, comprising the following steps:
Step 1: the data exchange of WMS system and ERP system is integrated into the Business Stream that ERP system integrates WMS system
Journey, the operation flow include procurement process, buying cancelling stocks process, sale process, sale cancelling stocks, neck stream journey, neck material cancelling stocks
Process, completion storage process, completion cancelling stocks process, process of making an inventory, stock relocation process, modality conversion process, other storage processes, its
His 15 outbound process, material information querying flow, storage variance analysis process processes；Other described storage processes, which refer to, to be directed to
Operation flow, the specified storage business in no source are operated by other storage processes, other described outbound processes refer to
For operation flow, the specified outbound business in no source is operated by other outbound processes；
Step 2: using data interchange platform, by Database Systems of WMS system and ERP system, application system, dedicated
Middleware system provides access component, is abstracted by interface protocol demand, realizes that the data of WMS system and ERP system are handed over
It changes；
Step 3: defining the middle table of exchange data command information by data interchange platform, defines among command information
After the completion of table, the command information of different nodes is passed to data interchange platform and distributes to respective nodes, in described instruction information
Between table include material information middle table, Classification of materials middle table, supplier's middle table, client's middle table, command service middle table
With code middle table；
Step 4: after the completion of ERP system business paper, middle table, WMS system root is written into qualified command information
Outbound warehouse-in instruction is executed according to command information.
By above step, the Real Data Exchangs between ERP system and WMS system may be implemented, by ERP system with
The synchronization of WMS system data may be implemented WMS system end cargo and go out storage information, the write-in of label information, cargo storage out
Checking information and backstage ERP system database link, so that improving cargo goes out the efficiency being put in storage；When warehouse keeper makes an inventory of goods in a warehouse, disk is realized
Library information and back-end data linkage, automatic Verification, to improve efficiency of making an inventory of goods in a warehouse.
Further, the ERP system is UF NC software, and the data interchange platform is based on Java technology and standard
The data interchange platform of database interface, the data interchange platform include multiple component custom interfaces and multiple expansion interfaces into
One step, the data exchange of the data interchange platform and WMS system is realized by http service, the data interchange platform and
The data exchange of ERP system is serviced by http and is completed jointly with the external harmoniousness platform of ERP.Use normal data bank interface
(JDBC, ODBC etc.) custom interface, accessory pass through use on the market, facilitate buying and maintenance, in addition component custom interface, Ke Yifang
Just, rapidly addition has the function of that new component, multiple expansion interfaces that data interchange platform provides facilitate user to carry out function
It can extend, there is good expandability, ease of manageability, high availability and portability.
Further, the ERP system business paper includes purchase order, buying storage bill, sales order, sale outbound
List, material delivered note, production order, finished product storage bill, material information inquiry table, storage variance analysis table and other enter
11 kinds of documents such as library list, other outbound lists, other described storage bills, other outbound lists refer to the specified storage business in no source
Or document required for outbound business operation.
Further, other storage bills of the ERP system business paper, other outbound forms data write services are by ERP
External harmoniousness platform realized by xml format, in the ERP system business paper remove other storage bills, other outbound lists
The write-in of document in addition is serviced by http and is realized, the http service parameter format is json format.
Further, the material information middle table includes material version id, name of material, COM code, figure number, rule
Lattice, model, measurement unit, Classification of materials coding, Classification of materials title, the Classification of materials middle table include that Classification of materials is compiled
Code, Classification of materials title, among Classification of materials coding, Classification of materials title and the Classification of materials in the material information middle table
Classification of materials coding, Classification of materials name field, type, format length in table is consistent.
Further, supplier's middle table includes supplier's coding and vendor name, client's middle table packet
Include encoder client, customer name.
Further, described instruction service middle table include row id, document number, line number, material version id, name of material,
Figure number, COM code, warehouse coding, basic unit title, organization, receivable main quantity, receivable quantity, paid main quantity, reality
Receive quantity, batch number, it is accumulative enter and leave quantity, whether document types encodes, close, timestamp, gauge outfit remarks, row remarks and discrepancy
Library mark.
Further, the code middle table includes buying arrival, revenue shipment list, applied ex-warehouse, stock plan, completion
Report, stock relocation list and modality conversion.
By the above ERP system business paper and command information middle table, all kinds of storage documents, the fast fast-growing of report are realized
At, and can cargo in bad order constantly early warning, cargo automatic prompt under specific environment passes through information networking and intelligent management, forms system
One information database provides reliable basis for supply chain overall operation.And it may be implemented from inventory, online product, buying
Order, production plan assign, order, accomplishes to monitor in real time to production product and the finished product situation in each stage, accurate each stage
Product situation realizes fast reaction, it is ensured that according to plan by the accurately and timely completion of production task.
In conclusion the present invention goes out warehouse-in efficiency with the raising cargo that docks of WMS system by ERP system, and realize
Warehoused cargo carries out comprehensive implementation management during alloting, and shows the information system management level of company and technical advantage
It is existing, the competitiveness and market position of enterprise are improved, company's comprehensive strength and profitability are enhanced.
Detailed description of the invention
Fig. 1 is WMS system and ERP system interconnection method work flow diagram；
Fig. 2 is the business process map of UF NC Integrated Simulation WMS.
Specific embodiment
With reference to the attached drawing in the embodiment of the present invention, technical solution in the embodiment of the present invention carries out clear, complete
Ground description, it is clear that described embodiment is only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Embodiment:
A kind of WMS system and ERP system interconnection method as shown in Figure 1:, comprising the following steps:
Step 1: the data exchange of WMS system and ERP system is developed by Java framework and integrates WMS system for ERP system
The operation flow of system, the operation flow include procurement process, buying cancelling stocks process, sale process, sale cancelling stocks, neck stream
Journey, neck material cancelling stocks process, completion storage process, completion cancelling stocks process, process of making an inventory, stock relocation process, modality conversion process, other
It is put in storage 15 processes such as process, other outbound processes, material information querying flow, storage variance analysis process；Described other enter
Library process refers to for operation flow, and the specified storage business in no source is operated by other storage processes, it is described its
He outbound process refers to for operation flow that the specified outbound business in no source is operated by other outbound processes.
Step 2: using data interchange platform, by Database Systems of WMS system and ERP system, application system, dedicated
Middleware system provides access component, is abstracted by interface protocol demand, realizes that the data of WMS system and ERP system are handed over
It changes；
Step 3: defining the middle table of exchange data command information by data interchange platform, defines among command information
After the completion of table, the command information of different nodes is passed to data interchange platform and distributes to respective nodes, in described instruction information
Between table include material information middle table, Classification of materials middle table, supplier's middle table, client's middle table, command service middle table
With code middle table；
Step 4: after the completion of ERP system business paper, middle table, WMS system root is written into qualified command information
Outbound warehouse-in instruction is executed according to command information.
A kind of WMS system provided by the invention and ERP system interconnection method, used ERP system are UF NC software,
Used data interchange platform is the data interchange platform based on Java technology and normal data bank interface, and data exchange
Platform includes multiple component custom interfaces and multiple expansion interfaces.
ERP system as shown in Figure 2 integrates the business process map of WMS system, and each operation flow detailed instructions are as schemed
Show:
Purchase order, sales order, production order, finished product storage bill, other storage bills, other outbound lists, storage are poor
After middle table data are written by ERP system in different analytical table etc., outbound or warehouse-in instruction are carried out to the write-in WMS instruction of WMS system
Operation, WMS system are completed after operating, then the data after operation are passed to ERP system.Material information middle table ginseng of the invention
Examine table 1: encoded including material version id, name of material, COM code, figure number, specification, model, measurement unit, Classification of materials,
Classification of materials title, the Classification of materials information include Classification of materials coding, Classification of materials title.
1 material information middle table of table
| Material middle table | Table name: | nc_material | |
| Field | Title | Type | Length |
| cmaterialvid | Material version id | String | 20 |
| cmaterialname | Name of material | String | 300 |
| cmaterialcode | COM code | String | 40 |
| graphid | Figure number | String | 50 |
| materialspec | Specification | String | 400 |
| materialtype | Model | String | 400 |
| cunitname | Measurement unit | String | 400 |
| cmarbasclasscode | Classification of materials coding | String | 40 |
| cmarbasclassname | Classification of materials title | String | 400 |
Supplier's middle table reference table 2 of the invention: including supplier's coding and vendor name.
2 supplier's middle table of table
| Classification of materials middle table | Table name: | nc_supplier | |
| Field | Title | Type | Length |
| csuppliercode | Supplier's coding | String | 40 |
| csuppliername | Vendor name | String | 400 |
Client's middle table reference table 3 of the invention: including encoder client, customer name.
3 client's middle table of table
| Client's middle table | Table name: | nc_customer | |
| Field | Title | Type | Length |
| ccustomercode | Encoder client | String | 40 |
| ccustomername | Customer name | String | 400 |
Command service middle table reference table 4 of the invention: including row id, document number, line number, material version id, material name
Title, figure number, COM code, warehouse coding, basic unit title, organization, receivable main quantity, receivable quantity, paid main quantity,
Actual quantity received, batch number, it is accumulative enter and leave quantity, whether document types encodes, close, timestamp, gauge outfit remarks, row remarks with out
Storage mark, wherein ninout:1 indicates storage, and 0 indicates outbound.
4 command service middle table of table
| Instruction catalogue | Table name: | nc_wms_b | ||
| Field | Title | Type | Length | It can idle running degree |
| pk_wms_b | Row id | UFID | 20 | 0 |
| vbillcode | Document number | String | 60 | 0 |
| crowno | Line number | String | 20 | 0 |
| cmaterialvid | Material version id | String | 20 | 0 |
| cmaterialname | Name of material | String | 400 | 0 |
| graphid | Figure number | String | 400 | 0 |
| cmaterialcode | COM code | String | 40 | 0 |
| cwarehousecode | Warehouse coding | String | 40 | 1 |
| cunitname | Basic unit title | String | 400 | 0 |
| castunitname | Organization | String | 400 | 0 |
| nshouldnum | Receivable main quantity | UFDouble | 28 | 0 |
| nshouldastnum | Receivable quantity | UFDouble | 28 | 0 |
| nnum | Paid main quantity | UFDouble | 28 | 0 |
| nastnum | Actual quantity received | UFDouble | 28 | 0 |
| vbatchcode | Batch number | String | 50 | 1 |
| ntotalnum | Accumulative warehousing quantity out | UFDouble | 40 | 0 |
| vfree1 | Free secondary attribute 1 | Free term | 101 | 2 |
| vfree… | Free secondary attribute ... | Free term | 101 | 2 |
| vfree10 | Free secondary attribute 10 | Free term | 101 | 2 |
| vbdef1 | Table body self-defining term 1 | Self-defining term | 101 | 0 |
| vbdef… | Table body self-defining term ... | Self-defining term | 101 | 0 |
| vbdef20 | Table body self-defining term 20 | Self-defining term | 101 | 0 |
| cbilltypecode | Document types coding | String | 20 | 0 |
| isclose | Whether close | UFBoolean | 1 | 0 |
| ts | Timestamp | String | 19 | 0 |
| vnote | Gauge outfit remarks | String | 181 | 1 |
| vnotebody | Row remarks | String | 181 | 1 |
| ninout | Storage mark out | String | 1 | 1 |
Code middle table reference table 5 of the invention: including purchase arrival, revenue shipment list, applied ex-warehouse, stock plan,
Complete report, stock relocation list and modality conversion.
5 code middle table of table
| cbilltypecode | Meaning |
| 23 | Purchase arrival |
| 4331 | Revenue shipment list |
| 4455 | Applied ex-warehouse |
| 55A3 | Stock plan |
| 55D2 | Complete report |
| 4K | Stock relocation list |
| 4N | Modality conversion |
ERP system list of the invention includes purchase order, buying storage bill, sales order, sale outbound list, other enter
Library list, material delivered note, production order, finished product storage bill, other outbound lists, material information and storage variance analysis table；ERP
Other storage bills, other outbound forms data write services in system list are real by xml format by the external harmoniousness platform of ERP
Now (identifying code 1), the operation of other documents is realized by passing through http service in ERP system list, http service parameter format
For json format (identifying code 2).
Code 1
By taking the external harmoniousness platform data call format of UF NC software as an example, other storage bills, other outbound lists are used
Xml format, application method are as follows:
String url=" http: // 10.7.3.225:8080/service/XchangeSer vlet "；
URL realURL=new URL (url)；
HttpURLConnection connection=(HttpURLConnection) realUR
L.openConnection()；
connection.setDoOutput(true)；
connection.setRequestProperty("Contect-type","text/xml")；
connection.setRequestMethod("Post")；
// will be in the output stream of Document object write-in connection
InputStream input=new FileInputStream (String)；
Document doc=XMLUtil.getDocumentBuilder () .parse (input)；Writer writer
=new OutputStreamWriter (connection.getOu tputStream (), " UTF-8 ")；
XMLUtil.printDOMTree(writer,doc,1)；// exported according to XML file format
// acknowledgement information is obtained from the inlet flow of connection
InputStream inputStream=connection.getInputStream ()；
Document resDoc=XMLUtil.getDocumentBuilder () .parse (inp utStream)；//
Resolve to Doc object
Code 2
It by taking revenue shipment single operation as an example, is serviced using http, parameter format json, format code is as follows:
[{"pk_wms_b":"id001","vbillcode":"DC20160402001","crowno
":"10","nnum":12.6,"nastnum":12.6,
"vbatchcode":"pc001","cbilltypecode":"4331","vtrantypeco
de":"","ninout":"1"},
{"pk_wms_b":"id002","vbillcode":"DC20160402001","crowno":
"10","nnum":20.6,"nastnum":20.6,
"vbatchcode":"pc002","cbilltypecode":"4331","vtrantypeco de":"","
ninout":"1"}]
Separately below by taking other storage processes, other outbound processes and sale process delivery as an example, operation flow is described
Workflow mode.
(1) other storage processes:
It is not put in storage the specified WMS storage business in source and outbound information is passed to by NC system by NC application integration platform
System generates other storage bills；It is related to type of transaction, after WMS system by hand selection, passes to NC system.Detailed process is such as
Under:
Form data is written to NC system by xml format in S1:NC application integration platform (such as office OA system), passes through
HTTP service accesses data interchange platform, and is transferred to WMS system
S2:WMS system carries out data fractionation, translation conversion and data processing and answers data feedback to NC through application server
With integrated platform (such as office OA system).
(2) other outbound processes
Outbound information is passed to NC system and generates it by the WMS business outbound for not having outbound specified by NC integrated platform
Its outbound list, detailed process is the same as other storage processes.
(3) steps are as follows for the delivery of sale process:
Command service middle table is write data into after the completion of revenue shipment list examination & approval in S1:NC system；
S2: when revenue shipment list cancels examination & approval, if outbound, do not allow to cancel and examine, if taken without outbound
Disappear and deletes command service middle table related data when examining.
S3:WMS system is instructed according to outbound, is completed outbound operation, after operating out at outbound, the http of NC is called to service,
Outbound information is passed into NC system, NC system automatically generated signs state and sells outbound list.Type of transaction is fixed by document interface
Justice obtains, and outbound information is as follows:
| pk_wms_b | Row id | UFID | 20 | 0 |
| vbillcode | Arrival document number | String | 40 | 0 |
| crowno | Line number | String | 20 | 0 |
| nnum | Paid main quantity | UFDouble | 28 | 0 |
| nastnum | Actual quantity received | UFDouble | 28 | 0 |
| vbatchcode | Batch number | String | 50 | 1 |
| cbilltypecode | Document types coding | String | 20 | 0 |
Finally, it is stated that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, this field is common
Other modifications or equivalent replacement that technical staff makes technical solution of the present invention, without departing from technical solution of the present invention
Spirit and scope, be intended to be within the scope of the claims of the invention.
Claims (9)
1. a kind of WMS system and ERP system interconnection method, which comprises the following steps:
Step 1: the data exchange of WMS system and ERP system is integrated into the operation flow that ERP system integrates WMS system, institute
State operation flow include procurement process, buying cancelling stocks process, sale process, sale cancelling stocks, neck stream journey, neck material cancelling stocks process,
Completion storage process, completion cancelling stocks process, process of making an inventory, stock relocation process, modality conversion process, other storage processes, other go out
15 processes such as library process, material information querying flow, storage variance analysis process；Other described storage processes refer to for industry
Business process, the specified storage business in no source are operated by other storage processes, other described outbound processes are pointers
To operation flow, the specified outbound business in no source is operated by other outbound processes；
Step 2: data interchange platform is used, by the Database Systems of WMS system and ERP system, application system, dedicated centre
Part system provides access component, is abstracted by interface protocol demand, realizes the data exchange of WMS system and ERP system；
Step 3: defining the middle table of exchange data command information by data interchange platform, and it is complete to define command information middle table
Cheng Hou, the command information of different nodes are passed to data interchange platform and distribute to respective nodes, described instruction information middle table
Including material information middle table, Classification of materials middle table, supplier's middle table, client's middle table, command service middle table and generation
Code middle table；
Step 4: after the completion of ERP system business paper, middle table is written into qualified command information, WMS system is according to finger
Information is enabled to execute outbound warehouse-in instruction.
2. a kind of WMS system according to claim 1 and ERP system interconnection method, it is characterised in that: the ERP system
For UF NC software, the data interchange platform is the data interchange platform based on Java technology and normal data bank interface, institute
Stating data interchange platform includes multiple component custom interfaces and multiple expansion interfaces.
3. a kind of WMS system according to claim 1 or 2 and ERP system interconnection method, it is characterised in that: the data
The data exchange of switching plane and WMS system is serviced by http and is realized, the data of the data interchange platform and ERP system are handed over
It changes and is completed jointly by http service and the external harmoniousness platform of ERP.
4. a kind of WMS system according to claim 1 and ERP system interconnection method, it is characterised in that: the ERP system
Business paper include purchase order, buying storage bill, sales order, sale outbound list, material delivered note, production order, produce at
11 kinds of documents such as product storage bill, material information inquiry table, storage variance analysis table and other storage bills, other outbound lists, institute
State other storage bills, other outbound lists refer to document required for the specified storage business in no source or outbound business operation.
5. a kind of WMS system and ERP system interconnection method according to claim 3 and 4, it is characterised in that: the ERP system
Other storage bills of system business paper, other outbound forms data write services are real by xml format by the external harmoniousness platform of ERP
Existing, the write-in of the document in addition to other storage bills, other outbound lists in the ERP system business paper is serviced by http
It realizes, the http service parameter format is json format.
6. a kind of WMS system according to claim 1 and ERP system interconnection method, it is characterised in that: the material information
Middle table include material version id, name of material, COM code, figure number, specification, model, measurement unit, Classification of materials coding,
Classification of materials title, the Classification of materials middle table includes Classification of materials coding, Classification of materials title, among the material information
The Classification of materials coding in Classification of materials coding, Classification of materials title and Classification of materials middle table in table, Classification of materials title
Field, type, format length are consistent.
7. a kind of WMS system according to claim 1 and ERP system interconnection method, it is characterised in that: in the supplier
Between table include supplier coding and vendor name, client's middle table include encoder client, customer name.
8. a kind of WMS system according to claim 1 and ERP system interconnection method, it is characterised in that: described instruction service
Middle table includes row id, document number, line number, material version id, name of material, figure number, COM code, warehouse coding, basic unit
Title, organization, receivable main quantity, receivable quantity, paid main quantity, actual quantity received, batch number, accumulative discrepancy quantity, list
According to type coding, whether close, timestamp, gauge outfit remarks, row remarks with go out storage mark.
9. a kind of WMS system according to claim 1 and ERP system interconnection method, it is characterised in that: among the code
Table includes buying arrival, revenue shipment list, applied ex-warehouse, stock plan, complete report, stock relocation list and modality conversion.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810912823.XA CN108960745A (en) | 2018-08-10 | 2018-08-10 | A kind of WMS system and ERP system interconnection method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810912823.XA CN108960745A (en) | 2018-08-10 | 2018-08-10 | A kind of WMS system and ERP system interconnection method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108960745A true CN108960745A (en) | 2018-12-07 |
Family
ID=64469512
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810912823.XA Pending CN108960745A (en) | 2018-08-10 | 2018-08-10 | A kind of WMS system and ERP system interconnection method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108960745A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110264159A (en) * | 2019-06-19 | 2019-09-20 | 农业部沼气科学研究所 | A kind of interconnection method of e-commerce platform and OA system |
| CN110414793A (en) * | 2019-07-01 | 2019-11-05 | 南京钢铁股份有限公司 | The seamless interfacing method of client's ERP system and manufacture end ERP system based on user demand |
| CN111626474A (en) * | 2020-04-18 | 2020-09-04 | 青岛奥利普自动化控制系统有限公司 | Data processing method and equipment based on manufacturing MES system |
| CN111768158A (en) * | 2020-07-04 | 2020-10-13 | 浙江锐制软件技术有限公司 | Timely and appropriate production method and system based on zero inventory management purpose |
| CN112734322A (en) * | 2020-12-18 | 2021-04-30 | 山东东辰瑞森新材料科技有限公司 | Intelligent production system and method |
| CN112884401A (en) * | 2021-01-29 | 2021-06-01 | 江苏新格尔人居科技有限公司 | Material operation system |
| CN113159622A (en) * | 2021-05-12 | 2021-07-23 | 嘉兴佳士友软件有限公司 | ERP system with OA (office automation) cooperative function |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105187559A (en) * | 2015-09-30 | 2015-12-23 | 成都智信电子技术有限公司 | Data fusion governance system |
| US20160275628A1 (en) * | 2015-03-16 | 2016-09-22 | Accenture Global Services Limited | Digital manufacturing system |
| CN106081453A (en) * | 2016-07-26 | 2016-11-09 | 深圳市固泰科自动化装备有限公司 | A kind of automated three-dimensional storage facilities |
| CN107888682A (en) * | 2017-11-09 | 2018-04-06 | 北京许继电气有限公司 | Heterogeneous system data interactive method and system based on industrial interconnection platform |
-
2018
- 2018-08-10 CN CN201810912823.XA patent/CN108960745A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160275628A1 (en) * | 2015-03-16 | 2016-09-22 | Accenture Global Services Limited | Digital manufacturing system |
| CN105187559A (en) * | 2015-09-30 | 2015-12-23 | 成都智信电子技术有限公司 | Data fusion governance system |
| CN106081453A (en) * | 2016-07-26 | 2016-11-09 | 深圳市固泰科自动化装备有限公司 | A kind of automated three-dimensional storage facilities |
| CN107888682A (en) * | 2017-11-09 | 2018-04-06 | 北京许继电气有限公司 | Heterogeneous system data interactive method and system based on industrial interconnection platform |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110264159A (en) * | 2019-06-19 | 2019-09-20 | 农业部沼气科学研究所 | A kind of interconnection method of e-commerce platform and OA system |
| CN110414793A (en) * | 2019-07-01 | 2019-11-05 | 南京钢铁股份有限公司 | The seamless interfacing method of client's ERP system and manufacture end ERP system based on user demand |
| CN111626474A (en) * | 2020-04-18 | 2020-09-04 | 青岛奥利普自动化控制系统有限公司 | Data processing method and equipment based on manufacturing MES system |
| CN111768158A (en) * | 2020-07-04 | 2020-10-13 | 浙江锐制软件技术有限公司 | Timely and appropriate production method and system based on zero inventory management purpose |
| CN111768158B (en) * | 2020-07-04 | 2024-02-13 | 浙江锐制软件技术有限公司 | Timely and appropriate production method and system based on zero inventory management purpose |
| CN112734322A (en) * | 2020-12-18 | 2021-04-30 | 山东东辰瑞森新材料科技有限公司 | Intelligent production system and method |
| CN112884401A (en) * | 2021-01-29 | 2021-06-01 | 江苏新格尔人居科技有限公司 | Material operation system |
| CN113159622A (en) * | 2021-05-12 | 2021-07-23 | 嘉兴佳士友软件有限公司 | ERP system with OA (office automation) cooperative function |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108960745A (en) | A kind of WMS system and ERP system interconnection method | |
| Christopher | Logistics and supply chain management | |
| US20210103964A1 (en) | Account manager virtual assistant using machine learning techniques | |
| US9864960B2 (en) | Manufacturing collaboration hub data exchange interface | |
| US8762415B2 (en) | Modeling of order data | |
| US7792721B2 (en) | System and method for approval and allocation of costs in electronic procurement | |
| US10552769B2 (en) | Status management framework in a distributed order orchestration system | |
| CN109949113A (en) | A kind of VAT invoice online management system | |
| MXPA06014205A (en) | Computer system for efficient design and manufacture of multiple-component devices. | |
| TW200534139A (en) | Strategic sourcing for packaging material procurement using centralized packaging data management system | |
| CN101755245A (en) | System and method for providing export services to merchants | |
| WO1999033016A9 (en) | Integrated business-to-business web commerce and business automation system | |
| KR20200129412A (en) | Online store integrated management method and system for sellers | |
| CN111242477A (en) | ERP commodity management system and method | |
| Christopher | Logistics and Supply Chain Management: Logistics & Supply Chain Management | |
| CN110322190A (en) | The method that steel industry intrabranch service order based on SAP automatically creates | |
| US7596500B1 (en) | System and method for processing import/export transactions | |
| RU2651182C1 (en) | Method of managing the enterprise and automation of operations at the enterprise | |
| US20160253728A1 (en) | Cooperation server, cooperation program, and ec system | |
| Scheer | Computer: a challenge for business administration | |
| US20160253729A1 (en) | Cooperation server, cooperation program, and ec system | |
| CN101958893A (en) | Pre-positioned business server and processing method thereof | |
| CN111461847A (en) | Method for solving SAP universal service customization | |
| US20150073856A1 (en) | Mobile terminal management server and mobile terminal management program | |
| Holmström et al. | Re‐engineering in sales and distribution‐creating a flexible and integrated operation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181207 |
|
| RJ01 | Rejection of invention patent application after publication |