CN107742195B - System data integration method, device and storage medium - Google Patents
System data integration method, device and storage medium Download PDFInfo
- Publication number
- CN107742195B CN107742195B CN201710824533.5A CN201710824533A CN107742195B CN 107742195 B CN107742195 B CN 107742195B CN 201710824533 A CN201710824533 A CN 201710824533A CN 107742195 B CN107742195 B CN 107742195B
- Authority
- CN
- China
- Prior art keywords
- data
- inventory
- result
- legal
- inventory 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.)
- Active
Links
Images
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a system data integration method, a device and a storage medium, wherein the method comprises the following steps: acquiring legal inventory data of a customs information system, and acquiring warehousing inventory data of a process follow-up and supervision system; correlating the legal inventory data with the warehousing inventory data to obtain a correlation result; and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result. The invention relates and integrates the legal inventory data of the customs information system and the warehousing inventory data of the process follow-up and supervision system, thereby better realizing data monitoring and management on the material inventory.
Description
Technical Field
The present invention relates to the field of system data management and control, and in particular, to a method and an apparatus for system data integration and a storage medium.
Background
The existing PTS system (Process Tracking and Supervising, translated into a Process follow-up and supervision system) only simply records warehouse physical inventory data, and reports import and export goods in a customs information system when reporting, the PTS system has too single function, can not cross-compare with customs legal inventory data, and the data types used for managing and controlling the import and export goods in the customs information system are different from the data types of the goods used by the PTS system, so that a large amount of time and labor cost are needed when warehouse data statistics and checking are performed, the operation is very inconvenient, the condition that the data cannot be checked frequently occurs, and the data management and control is not in place.
The above information is only for assisting understanding of the technical aspects of the present invention, and does not represent an admission that the above information is prior art.
Disclosure of Invention
The invention mainly aims to provide a system data integration method, a system data integration device and a storage medium, and aims to solve the technical problem that warehousing inventory data of a follow-up and supervision system are difficult to control.
In order to achieve the above object, the present invention provides a system data integration method, which includes the following steps:
acquiring legal inventory data of a customs information system, and acquiring warehousing inventory data of a process follow-up and supervision system;
correlating the legal inventory data with the warehousing inventory data to obtain a correlation result;
and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result.
Preferably, the associating the legal inventory data with the warehousing inventory data to obtain an association result specifically includes:
extracting a cargo part number from the legal inventory data, and searching a corresponding first material inventory number according to the cargo part number;
extracting goods numbers from the warehousing inventory data, and searching corresponding second material inventory numbers according to the goods numbers;
and associating the legal inventory data with the warehousing inventory data according to the first material order number and the second material order number to obtain an association result.
Preferably, the associating the legal inventory data with the warehousing inventory data according to the first material order number and the second material order number to obtain an association result specifically includes:
comparing the first material order number with the second material order number;
when the first material order number is consistent with the second material order number, associating first goods data in the legal inventory corresponding to the first material order number with second goods data in the warehousing inventory data corresponding to the second material order number to obtain associated data;
when the first material order number is inconsistent with the second material order number, marking first goods data in the legal inventory corresponding to the first material order number and second goods data in the warehousing inventory data corresponding to the second material order number to obtain marked data;
the association data and the tag data constitute the association result.
Preferably, the performing data integration according to the association result to obtain an integration result specifically includes:
and classifying the associated data in the associated result and the marked data to obtain the integrated result.
Preferably, the searching for the corresponding first material inventory number according to the cargo material part number specifically includes:
searching a first material inventory number corresponding to the cargo material part number from a first mapping relation table, wherein the first mapping relation table comprises: the corresponding relation between the cargo part number and the bill of materials.
Preferably, the searching for the corresponding second material inventory number according to the cargo number specifically includes:
searching a second material inventory number corresponding to the goods number from a second mapping relation table, wherein the second mapping relation table comprises: the corresponding relation between the goods number and the bill of materials.
Preferably, after the data integration is performed according to the association result to obtain an integration result and the integration result is displayed, the method further includes:
monitoring the legal inventory data and the warehousing inventory data in real time to obtain a monitoring result;
and updating the integration result according to the monitoring result.
Preferably, the real-time monitoring of the legal inventory data and the warehousing inventory data to obtain a monitoring result specifically includes:
monitoring the legal inventory data in real time, and acquiring first updating data when the legal inventory data is updated;
monitoring the warehousing inventory data in real time, and acquiring second updating data when the warehousing inventory data are updated;
and the first updating data and the second updating data form the monitoring result.
In addition, to achieve the above object, the present invention further provides a system data integration apparatus, including: a memory, a processor and a system data integration program stored on the memory and executable on the processor, the system data integration program configured to implement the steps of the system data integration method as described above.
In addition, to achieve the above object, the present invention further provides a computer readable storage medium, which stores thereon a system data integration program, which when executed by a processor, implements the steps of the system data integration method as described above.
The invention obtains the legal inventory data of the customs information system and the warehousing inventory data of the process follow-up and supervision system; correlating the legal inventory data with the warehousing inventory data to obtain a correlation result; and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result. And associating and integrating legal inventory data of the customs information system and inventory data of the process follow-up and supervision system, and better realizing data monitoring management on physical inventory.
Drawings
FIG. 1 is a schematic structural diagram of a system data integration apparatus of a hardware operating environment according to an embodiment of a system data integration method of the present invention;
FIG. 2 is a flowchart illustrating a system data integration method according to a first embodiment of the present invention;
FIG. 3 is a flowchart illustrating a system data integration method according to a second embodiment of the present invention;
FIG. 4 is a flowchart illustrating a system data integration method according to a third embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a system data integration apparatus in a hardware operating environment according to an embodiment of the present invention.
As shown in fig. 1, the apparatus may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Those skilled in the art will appreciate that the configuration shown in fig. 1 does not constitute a limitation of the apparatus and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and a system data integration program.
In the apparatus shown in fig. 1, the network interface 1004 is mainly used for connecting a server and performing data communication with the server; the user interface 1003 is mainly used for receiving instructions input by a user, and the apparatus calls a system data integration program stored in the memory 1005 through the processor 1001 and performs the following operations:
acquiring legal inventory data of a customs information system, and acquiring warehousing inventory data of a process follow-up and supervision system;
correlating the legal inventory data with the warehousing inventory data to obtain a correlation result;
and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
extracting a cargo part number from the legal inventory data, and searching a corresponding first material inventory number according to the cargo part number;
extracting goods numbers from the warehousing inventory data, and searching corresponding second material inventory numbers according to the goods numbers;
and associating the legal inventory data with the warehousing inventory data according to the first material order number and the second material order number to obtain an association result.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
comparing the first material order number with the second material order number;
when the first material order number is consistent with the second material order number, associating first goods data in the legal inventory corresponding to the first material order number with second goods data in the warehousing inventory data corresponding to the second material order number to obtain associated data;
when the first material order number is inconsistent with the second material order number, marking first goods data in the legal inventory corresponding to the first material order number and second goods data in the warehousing inventory data corresponding to the second material order number to obtain marked data;
the association data and the tag data constitute the association result.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
and classifying the associated data in the associated result and the marked data to obtain the integrated result.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
searching a first material inventory number corresponding to the cargo material part number from a first mapping relation table, wherein the first mapping relation table comprises: the corresponding relation between the cargo part number and the bill of materials.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
searching a second material inventory number corresponding to the goods number from a second mapping relation table, wherein the second mapping relation table comprises: the corresponding relation between the goods number and the bill of materials.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
monitoring the legal inventory data and the warehousing inventory data in real time to obtain a monitoring result;
and updating the integration result according to the monitoring result.
Further, the processor 1001 may call the system data integration program stored in the memory 1005, and further perform the following operations:
monitoring the legal inventory data in real time, and acquiring first updating data when the legal inventory data is updated;
monitoring the warehousing inventory data in real time, and acquiring second updating data when the warehousing inventory data are updated;
and the first updating data and the second updating data form the monitoring result.
According to the scheme, the legal inventory data of the customs information system are obtained, and the warehousing inventory data of the process follow-up and supervision system are obtained; correlating the legal inventory data with the warehousing inventory data to obtain a correlation result; and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result. And associating and integrating legal inventory data of the customs information system and inventory data of the process follow-up and supervision system, and better realizing data monitoring management on physical inventory.
Based on the above hardware structure, an embodiment of a system data integration method according to the present invention is provided.
Referring to fig. 2, a first embodiment of a system data integration method according to the present invention is provided.
In this embodiment, the system data integration method includes the following steps:
step S10, obtaining legal inventory data of the customs information system, and obtaining warehousing inventory data of the process follow-up and supervision system;
it should be understood that when a bill of materials of import and export goods to be declared is received, the information of the goods to be declared is recorded in the customs information system, and the customs information system can generate legal inventory data according to the recorded information of the materials of the import and export goods to be declared, and can be used as a basis for subsequently checking the import and export goods.
It can be understood that when the warehouse receives the import and export goods to be declared, the goods can be checked according to the material list to be declared, the checked goods are boxed, the boxed goods are recorded to generate a factory boxing detail list, the goods in the warehouse are confirmed according to the factory boxing detail list, the confirmed goods data information is input into a process follow-up and supervision system, and the process follow-up and supervision system generates warehousing inventory data.
Step S20, the legal inventory data and the warehousing inventory data are correlated to obtain a correlation result;
it should be noted that, in the prior art, the customs information system and the process follow-up and supervision system are two independent systems, and are also managed by the customs and each company respectively, and the customs and each company adopt different types of material information for controlling the information of goods to be declared, and when the customs audits the data of goods to be declared to be imported and exported by each company every year, because of the independent management of the two system data, when the warehousing inventory data of the process follow-up and supervision system of the company does not accord with the information of the quantity or variety of goods managed in the legal inventory data of the customs information system, the customs can require each company to explain the non-compliant data, and explain the detailed processing condition of the non-compliant goods, so that each company is very passive. Therefore, in order to better perform data monitoring management on transaction inventory, legal inventory data and warehousing inventory data need to be correlated.
It can be understood that although the statutory inventory data and the warehousing inventory data adopt different types of material information to manage goods to be declared, the different types of material information of the same goods are related, and the statutory inventory data and the warehousing inventory data can be correspondingly related according to the association relationship, so that the association relationship is obtained.
It should be understood that in the legal inventory data, the management of the goods is managed by using the application part number and item number of the goods, and in the warehousing inventory data, the management of the goods is managed by using the SKU (stock keeping unit, abbreviated as SKU) and the goods item number of the goods, the SKU is defined as the minimum available unit for keeping inventory control, for example, the SKU in the textile generally represents: specification, color, style. The BOM (Bill of Material ) single number corresponding to the goods can be found according to the application part number of the goods, the corresponding BOM single number can be found and obtained according to the SKU of the goods, and the goods in the legal inventory data and the same goods in the warehousing inventory data can be associated by the same goods according to the corresponding BOM single number to obtain an association result.
And step S30, integrating data according to the correlation result to obtain an integration result, and displaying the integration result.
It can be understood that the association result presents the association relationship between the legal inventory data and the warehousing inventory data, the association result has the cargo data information which is consistent between the legal inventory data and the warehousing inventory data, and also has the cargo data information which is inconsistent between the legal inventory data and the warehousing inventory data, the data information in the two states is classified and managed to realize data integration, obtain an integration result, and display the integration result, so that a user can analyze the integration result, analyze the inconsistent cargo data, find reasons, and timely solve the problem of data inconsistency, for example, the user can consult the client according to the integration result to determine whether the delivery is wrong; or inventory warehouse goods, whether goods are omitted, not count, and the like.
According to the scheme, the legal inventory data of the customs information system are obtained, and the warehousing inventory data of the process follow-up and supervision system are obtained; correlating the legal inventory data with the warehousing inventory data to obtain a correlation result; and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result. And associating and integrating legal inventory data of the customs information system and inventory data of the process follow-up and supervision system, and better realizing data monitoring management on physical inventory.
Further, as shown in fig. 3, a second embodiment of the system data integration method according to the present invention is provided based on the first embodiment.
In this embodiment, the step S20 specifically includes:
step S201, extracting a cargo part number from the legal inventory data, and searching a corresponding first material inventory number according to the cargo part number;
it can be understood that, in the legal inventory data, the management of the goods is performed by using the application part number and the item number of the goods, and the BOM number corresponding to the goods, that is, the first material order number, can be found according to the application part number of the goods, and can be associated with the goods in the warehousing inventory data through the first material order number.
It can be understood that the relationship table between the cargo part numbers and the BOM order numbers of all the cargos can be sorted in advance, and when the cargo part numbers are extracted from the legal inventory data, the corresponding first material order number can be found from the pre-established mapping relationship table, in this embodiment, the finding of the corresponding first material order number according to the cargo part number specifically includes finding the first material order number corresponding to the cargo part number from the first mapping relationship table, and the first mapping relationship table includes: the corresponding relation between the cargo part number and the bill of materials.
Step S202, goods numbers are extracted from the warehousing inventory data, and corresponding second material inventory numbers are searched according to the goods numbers;
it should be understood that in the warehousing inventory data, the management of the goods is performed by using a Stock Keeping Unit (SKU) and a goods number, and the BOM number corresponding to the goods, that is, the second material list number, may be found according to the goods number and may be associated with the goods in the warehousing inventory data through the second material list number.
It should be understood that the relationship table between the cargo item numbers and the BOM order numbers of all the cargos may be sorted in advance, and when the cargo item number is extracted from the warehousing inventory data, the corresponding second cargo order number may be found from the pre-established mapping relationship table, in this embodiment, the finding of the corresponding second cargo order number according to the cargo item number specifically includes finding the second cargo order number corresponding to the cargo item number from the second mapping relationship table, and the second mapping relationship table includes: the corresponding relation between the goods number and the bill of materials.
Step S203, the legal inventory data and the warehousing inventory data are correlated according to the first material order number and the second material order number, and a correlation result is obtained.
It should be noted that the material inventory number of the same cargo is unique, and when the first material inventory number is identical to the second material inventory number, it is indicated that the cargo corresponding to the first material inventory number is identical to the cargo corresponding to the second material inventory number, and the cargo corresponding to the first material inventory number is associated with the cargo corresponding to the second material inventory number, so that the data association between the legal inventory data and the inventory data is realized, and the association result is obtained.
It can be understood that when the legal inventory data and the warehousing inventory data are correlated, the same goods in the two systems can be correlated in a consistent manner according to the material inventory numbers, other information such as the corresponding quantity of the same goods can be checked one by one, and when inconsistency occurs, the information is highlighted. In the two systems, goods which cannot be checked by the material list number may exist, and need to be marked and displayed. In this embodiment, the associating the legal inventory data with the warehousing inventory data according to the first material list and the second material list to obtain an association result specifically includes: comparing the first bill of materials with the second bill of materials; when the first material list is consistent with the second material list, correlating first commodity data in the legal inventory corresponding to the first material list with second commodity data in the warehousing inventory data corresponding to the second material list to obtain correlated data; when the first material list is inconsistent with the second material list, marking first commodity data in the legal inventory corresponding to the first material list and second commodity data in the warehousing inventory data corresponding to the second material list to obtain marked data; the association data and the tag data constitute the association result.
It should be understood that, in the warehousing inventory data, the associated data in the associated result may also be the case that the quantities of the same goods in the customs information system and the process follow-up and supervision system are not consistent, and need to be highlighted or displayed in a marked manner. When the first bill of material is inconsistent with the second bill of material, the obtained marking data also needs to be analyzed by the user for reasons caused by inconsistency so as to solve the problem of data inconsistency, so that the inconsistency of the two conditions needs to be extracted and managed separately from the consistent data. In this embodiment, the performing data integration according to the association result to obtain an integration result specifically includes: and classifying the associated data in the associated result and the marked data to obtain the integrated result.
According to the scheme of the embodiment, the corresponding first material inventory number is searched according to the goods part number extracted from the legal inventory data, the second material inventory number is searched according to the goods part number extracted from the warehousing inventory data, and the legal inventory data and the warehousing inventory data are correlated according to the first material inventory number and the second material inventory number, so that data correlation can be accurately performed on the data in the customs information system and the process follow-up and supervision system, and the inconsistent data in the warehousing inventory data can be searched out, so that a user can search for the data error reason in time, and the problem of data inconsistency is solved.
Further, as shown in fig. 4, a third embodiment of the system data integration method according to the present invention is provided based on the second embodiment.
In this embodiment, after step S30, the method further includes:
step S40, real-time monitoring is carried out on the legal inventory data and the warehousing inventory data to obtain a monitoring result;
it should be understood that each company may receive a customer order every day to request for declaration of import and export goods, and when a new bill of materials of the import and export goods to be declared is received, the information of the goods to be declared is recorded in the customs information system, and the customs information system generates legal inventory data according to the recorded information of the materials of the import and export goods to be declared, and then updates the legal inventory data. Correspondingly, when the warehouse receives new import and export goods to be declared, the goods can be checked according to the material list to be declared, the checked goods are boxed, the boxed goods are recorded to generate a factory boxing detail list, the goods in the warehouse are confirmed according to the factory boxing detail list, the confirmed new goods data information is input into the process follow-up and supervision system, and the process follow-up and supervision system generates warehousing inventory data to be updated.
It can be understood that, in order to accurately control the data in the legal inventory data and the warehousing inventory data, two inventory data need to be monitored in real time. In this embodiment, the real-time monitoring of the legal inventory data and the warehousing inventory data to obtain a monitoring result specifically includes: monitoring the legal inventory data in real time, and acquiring first updating data when the legal inventory data is updated; monitoring the warehousing inventory data in real time, and acquiring second updating data when the warehousing inventory data are updated; and the first updating data and the second updating data form the monitoring result.
And step S50, updating the integration result according to the monitoring result.
It should be noted that, when monitoring that there is data update in the legal inventory data and the warehousing inventory data, the corresponding update of the integration result is performed, specifically including associating the first update data and the second update data in the monitoring result to obtain a new association result, and updating the integration result according to the new association result.
It can be understood that the first updated data includes a first updated cargo part number, and a corresponding first updated material inventory number is found according to the first updated cargo part number. The second updating data comprises a second updating cargo number, and a corresponding second updating material list number is found according to the second updating cargo number. And then associating the first updating data with the second updating data according to the first updating material list number and the second updating material list number.
In this embodiment, the legal inventory data and the warehousing inventory data are monitored in real time, and the integration result is updated according to the monitoring result, so that when data is updated, the integration result is also associated and integrated with the new data correspondingly, and a user can perform more accurate data analysis and control on the updated integration result.
Furthermore, an embodiment of the present invention further provides a computer-readable storage medium, where a system data integration program is stored on the computer-readable storage medium, and when executed by a processor, the system data integration program implements the following operations:
acquiring legal inventory data of a customs information system, and acquiring warehousing inventory data of a process follow-up and supervision system;
correlating the legal inventory data with the warehousing inventory data to obtain a correlation result;
and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result.
Further, the system data integration program when executed by the processor further implements the following operations:
extracting a cargo part number from the legal inventory data, and searching a corresponding first material inventory number according to the cargo part number;
extracting goods numbers from the warehousing inventory data, and searching corresponding second material inventory numbers according to the goods numbers;
and associating the legal inventory data with the warehousing inventory data according to the first material order number and the second material order number to obtain an association result.
Further, the system data integration program when executed by the processor further implements the following operations:
comparing the first material order number with the second material order number;
when the first material order number is consistent with the second material order number, associating first goods data in the legal inventory corresponding to the first material order number with second goods data in the warehousing inventory data corresponding to the second material order number to obtain associated data;
when the first material order number is inconsistent with the second material order number, marking first goods data in the legal inventory corresponding to the first material order number and second goods data in the warehousing inventory data corresponding to the second material order number to obtain marked data;
the association data and the tag data constitute the association result.
Further, the system data integration program when executed by the processor further implements the following operations:
and classifying the associated data in the associated result and the marked data to obtain the integrated result.
Further, the system data integration program when executed by the processor further implements the following operations:
searching a first material inventory number corresponding to the cargo material part number from a first mapping relation table, wherein the first mapping relation table comprises: the corresponding relation between the cargo part number and the bill of materials.
Further, the system data integration program when executed by the processor further implements the following operations:
searching a second material inventory number corresponding to the goods number from a second mapping relation table, wherein the second mapping relation table comprises: the corresponding relation between the goods number and the bill of materials.
Further, the system data integration program when executed by the processor further implements the following operations:
monitoring the legal inventory data and the warehousing inventory data in real time to obtain a monitoring result;
and updating the integration result according to the monitoring result.
Further, the system data integration program when executed by the processor further implements the following operations:
monitoring the legal inventory data in real time, and acquiring first updating data when the legal inventory data is updated;
monitoring the warehousing inventory data in real time, and acquiring second updating data when the warehousing inventory data are updated;
and the first updating data and the second updating data form the monitoring result.
According to the scheme, the legal inventory data of the customs information system are obtained, and the warehousing inventory data of the process follow-up and supervision system are obtained; correlating the legal inventory data with the warehousing inventory data to obtain a correlation result; and integrating data according to the correlation result to obtain an integrated result, and displaying the integrated result. And associating and integrating legal inventory data of the customs information system and inventory data of the process follow-up and supervision system, and better realizing data monitoring management on physical inventory.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
The usage of the words first, second, third, etcetera herein does not indicate any ordering. These words may be interpreted as names.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the information in the specification and drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (9)
1. A method for system data integration, the method comprising the steps of:
the method comprises the steps of obtaining legal inventory data of a customs information system, and obtaining warehousing inventory data of a process follow-up and supervision system, wherein the customs information system generates legal inventory data according to input material information of imported and exported goods to be declared, and the process follow-up and supervision system generates warehousing inventory data according to input goods data information;
correlating the legal inventory data with the warehousing inventory data to obtain a correlation result;
performing data integration according to the correlation result to obtain an integration result, and displaying the integration result;
the associating the legal inventory data with the warehousing inventory data to obtain an association result comprises the following steps:
extracting a cargo part number from the legal inventory data, and searching a corresponding first material inventory number according to the cargo part number;
extracting goods numbers from the warehousing inventory data, and searching corresponding second material inventory numbers according to the goods numbers;
and associating the legal inventory data with the warehousing inventory data according to the first material order number and the second material order number to obtain an association result.
2. The system data integration method according to claim 1, wherein the associating the legal inventory data with the warehousing inventory data according to the first material order number and the second material order number to obtain an association result comprises:
comparing the first material order number with the second material order number;
when the first material order number is consistent with the second material order number, associating first goods data in the legal inventory corresponding to the first material order number with second goods data in the warehousing inventory data corresponding to the second material order number to obtain associated data;
when the first material order number is inconsistent with the second material order number, marking first goods data in the legal inventory corresponding to the first material order number and second goods data in the warehousing inventory data corresponding to the second material order number to obtain marked data;
the association data and the tag data constitute the association result.
3. The system data integration method of claim 2, wherein the performing data integration according to the association result to obtain an integration result specifically comprises:
and classifying the associated data in the associated result and the marked data to obtain the integrated result.
4. The system data integration method according to claim 1, wherein the searching for the corresponding first material inventory number according to the cargo material part number specifically comprises:
searching a first material inventory number corresponding to the cargo material part number from a first mapping relation table, wherein the first mapping relation table comprises: the corresponding relation between the cargo part number and the bill of materials.
5. The system data integration method according to claim 1, wherein the searching for the corresponding second item list number according to the cargo number specifically comprises:
searching a second material inventory number corresponding to the goods number from a second mapping relation table, wherein the second mapping relation table comprises: the corresponding relation between the goods number and the bill of materials.
6. The system data integration method according to any one of claims 1 to 5, wherein after the data integration is performed according to the association result to obtain an integration result and the integration result is displayed, the method further comprises:
monitoring the legal inventory data and the warehousing inventory data in real time to obtain a monitoring result;
and updating the integration result according to the monitoring result.
7. The system data integration method of claim 6, wherein the real-time monitoring of the legal inventory data and the warehouse inventory data to obtain a monitoring result specifically comprises:
monitoring the legal inventory data in real time, and acquiring first updating data when the legal inventory data is updated;
monitoring the warehousing inventory data in real time, and acquiring second updating data when the warehousing inventory data are updated;
and the first updating data and the second updating data form the monitoring result.
8. A system data integration apparatus, the apparatus comprising: a memory, a processor, and a system data integration program stored on the memory and executable on the processor, the system data integration program configured to implement the steps of the system data integration method of any of claims 1 to 7.
9. A computer-readable storage medium, having stored thereon a system data integration program which, when executed by a processor, implements the steps of the system data integration method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710824533.5A CN107742195B (en) | 2017-09-13 | 2017-09-13 | System data integration method, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710824533.5A CN107742195B (en) | 2017-09-13 | 2017-09-13 | System data integration method, device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107742195A CN107742195A (en) | 2018-02-27 |
| CN107742195B true CN107742195B (en) | 2021-10-26 |
Family
ID=61235679
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710824533.5A Active CN107742195B (en) | 2017-09-13 | 2017-09-13 | System data integration method, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107742195B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109741792A (en) * | 2018-12-21 | 2019-05-10 | 北京优迅医学检验实验室有限公司 | A kind of storage processing method and processing device of genetic test sample |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1801197A (en) * | 2005-01-07 | 2006-07-12 | 环隆电气股份有限公司 | Difference data integration and comparison method |
| CN101458782A (en) * | 2007-12-11 | 2009-06-17 | 鸿富锦精密工业（深圳）有限公司 | Quality management transversal integration system and method |
| CN105653622A (en) * | 2015-12-25 | 2016-06-08 | 中国民航信息网络股份有限公司 | PRN data integrating method and system |
| CN106649408A (en) * | 2015-11-04 | 2017-05-10 | ***通信集团重庆有限公司 | Big data retrieval method and device |
| CN106777308A (en) * | 2016-12-30 | 2017-05-31 | 中国民航信息网络股份有限公司 | The synchronous method and device of civil aviaton's sequence information |
| CN106844372A (en) * | 2015-12-04 | 2017-06-13 | 阿里巴巴集团控股有限公司 | A kind of logistics information querying method and device |
-
2017
- 2017-09-13 CN CN201710824533.5A patent/CN107742195B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1801197A (en) * | 2005-01-07 | 2006-07-12 | 环隆电气股份有限公司 | Difference data integration and comparison method |
| CN101458782A (en) * | 2007-12-11 | 2009-06-17 | 鸿富锦精密工业（深圳）有限公司 | Quality management transversal integration system and method |
| CN106649408A (en) * | 2015-11-04 | 2017-05-10 | ***通信集团重庆有限公司 | Big data retrieval method and device |
| CN106844372A (en) * | 2015-12-04 | 2017-06-13 | 阿里巴巴集团控股有限公司 | A kind of logistics information querying method and device |
| CN105653622A (en) * | 2015-12-25 | 2016-06-08 | 中国民航信息网络股份有限公司 | PRN data integrating method and system |
| CN106777308A (en) * | 2016-12-30 | 2017-05-31 | 中国民航信息网络股份有限公司 | The synchronous method and device of civil aviaton's sequence information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107742195A (en) | 2018-02-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105187676B (en) | Method and device for processing call request | |
| CN107909466B (en) | Customer relationship network display method, device, equipment and readable storage medium | |
| US20050273369A1 (en) | Recall support system, recall support method, and programs therefor | |
| US7698013B2 (en) | Parts production management system and parts production management method | |
| KR20220053010A (en) | Methods, devices, electronic devices and storage media for determining where to receive and store | |
| CN111461914A (en) | Order tracking verification and cancellation management method, system and storage medium | |
| US20160110679A1 (en) | System and method for monitoring an in-progress inventory audit | |
| CN107908442A (en) | Resource loading method, device, terminal device and computer-readable recording medium based on spring | |
| CN110766520A (en) | Multi-system multi-shop order fusion method and device, computer equipment and storage medium | |
| CN107742195B (en) | System data integration method, device and storage medium | |
| CN110782142A (en) | Daily birth daily clearing accounting method, device, equipment and computer readable storage medium | |
| US20160179909A1 (en) | Method and system for tracking tools | |
| CN110874365A (en) | Information query method and related equipment thereof | |
| JP2021002138A (en) | Information system and information management method | |
| CN105677776A (en) | Data processing method and device | |
| CN113811911B (en) | System and method for deriving platform feedback data to be dynamically retrieved by downstream subsystems | |
| EP2811434A1 (en) | Mobile terminal management server, and mobile terminal management program | |
| CN114490807A (en) | Logistics timeliness tracking method and device, terminal equipment and storage medium | |
| CN111427941A (en) | Bonded storage management method | |
| CN109522014B (en) | Algorithm processing method based on new product development, electronic device and readable storage medium | |
| US20160104230A1 (en) | Cooperation server, non-transitory computer-readable storage medium storing cooperation program, and ec system | |
| CN110570206A (en) | commodity tracing method and device | |
| CN112036789B (en) | Salary statistical method and device based on warehousing data and computer equipment | |
| EP2811436A1 (en) | Mobile terminal management server, and mobile terminal management program | |
| CN109254974B (en) | Intelligent input order opening method and device and computer equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |