The subject matter herein generally relates to an electronic device implementing a data docking method, and more particularly to a bill of materials (BOM) data docking method.
From the perspective of enterprise information system architecture, the ERP system and other systems require enterprise R&D departments to provide complete, accurate, and consistent product data through the PLM platform. Therefore, how to make data connection between different systems and even systems provided by different vendors is extremely important. The Bill of Materials (BOM) is one of the most important data. When the PLM system and the ERP system record parts, they define their respective version states, so that when it is required to transfer the BOM data of a part, the corresponding part version must be known in advance. Therefore, how to connect the bill of materials in the PLM system with the bill of materials in the ERP system is an urgent problem which needs to be solved.
Implementations of the present disclosure will now be described, by way of embodiments, with reference to the attached figures.
It will be appreciated that for simplicity and clarity of illustration, where appropriate, reference numerals have been repeated among the different figures to indicate corresponding or analogous elements. Additionally, numerous specific details are set forth in order to provide a thorough understanding of the embodiments described herein. However, it will be understood by those of ordinary skill in the art that the embodiments described herein can be practiced without these specific details. In other instances, methods, procedures and components have not been described in detail so as not to obscure the related relevant feature being described. The drawings are not necessarily to scale and the proportions of certain parts may be exaggerated to better illustrate details and features. The description is not to be considered as limiting the scope of the embodiments described herein.
Several definitions that apply throughout this disclosure will now be presented.
The term “comprising” means “including, but not necessarily limited to”; it specifically indicates open-ended inclusion or membership in a so-described combination, group, series and the like.
In general, the word “module” as used hereinafter refers to logic embodied in hardware or firmware, or to a collection of software instructions, written in a programming language such as, for example, Java, C, or assembly. One or more software instructions in the modules may be embedded in firmware such as in an erasable-programmable read-only memory (EPROM). It will be appreciated that the modules may comprise connected logic units, such as gates and flip-flops, and may comprise programmable units, such as programmable gate arrays or processors. The modules described herein may be implemented as either software and/or hardware modules and may be stored in any type of computer-readable medium or other computer storage device.
The at least one processor 12, when executing the computer program, implements steps of a data docking method as described below.
The database 13 is a repository built on the electronic device 1 that organizes, stores, and manages data in accordance with a data structure. Databases are usually divided into hierarchical databases, networked databases, and relational databases. In one embodiment, the database 13 is used to store a BOM display structure of a graphical display.
The computer program can be segmented into one or more modules/units, which are stored in the memory 11 and executed by the at least one processor 12. The one or more modules/units may be a series of computer program instruction segments capable of performing a particular function of the computer program.
The electronic device 1 may be, but is not limited to, a smart phone, a tablet computer, a desktop computer, or an all-in-one computer. It can be understood by those skilled in the art that the schematic diagram 1 is only an example of the electronic device 1, does not constitute a limitation on the electronic device 1, and may include more or less components than those illustrated, or combine some components thereof. The components of the electronic device 1 may further include circuitry, I/O interfaces, batteries, operating systems, a Wireless Fidelity (WI-FI) unit, a BLUETOOTH unit, a speaker, and the like not described further herein.
At block S01, the docking system of the electronic device 1 can receive BOM data sent by a first system, wherein the BOM data is BOM data created and modified by a user of the first system.
In one embodiment, the first system may be a Product Lifecycle Management (PLM) system or a Product Data Management (PDM) system.
When the first system is a PLM system, a user can create and modify BOM data in the PLM system. The PLM system may provide basic data to a second system, the basic data including BOM data, and the BOM data including component information, component structure information, and associated map document data of the component. In one embodiment, the BOM data includes a BOM table structure. BOM data refers to bill of materials data. BOM structure refers to a BOM data table of a part or product, and the BOM structure is a data table constructed according to a certain data structure. Different data structure storage forms determine a form of BOM form construction.
In one embodiment, the second system is an Enterprise Resource Planning system (ERP) system.
Because the PLM system and the ERP system define their own version status when recording parts. the BOM structure cannot be sent by the first system (e.g., the PLM system) to the second system (e.g., the ERP system) if the version status of the second system is unknown. Therefore, the task of concatenating the BOM data in the PLM system and the ERP system is performed by the docking system, so that the PLM system and the ERP system do not need to know the corresponding version of the other system.
It can be understood that the parts in the existing PLM system allow the addition of sub-parts into the BOM data, and the same parts are allowed to be used by other parts. If a version of a BOM data lifecycle state is released, this version of the BOM data is recorded in the system as a snapshot form.
In receiving the BOM data sent by the first system, the data docking method further includes storing the BOM data in a database, and graphically constructing the BOM data.
For example, when the BOM data sent by the first system is a composite product 20 constructed by raw material A and raw material B, the BOM data can be graphically displayed in the database as shown in
The part point may further include other attribute information of the part, such as PLM system version information, ERP system version information, and version information of the docking system. The version of the docking system for each part is unique in the database. Therefore, no matter how the BOM structure of any part in the PLM system is changed, or whether the version of the PLM system or the ERP system changes, each change record is recorded on the docking system to become a record history of concatenation of the PLM system or of the ERP system.
In block S02, the electronic device 1 can determine whether the BOM data has been sent to the second system. When the electronic device 1 determined that the BOM data has been transmitted to the second system, block S03 is implemented. When the electronic device 1 determined that the BOM data has not been transmitted to the second system, block S04 is implemented.
In one embodiment, whether the BOM data has been transmitted to the second system is determined by querying the BOM data history stored in the database 13.
When the docking system receives the BOM data sent by the first system, the BOM data is stored in the database 13, whether the BOM data has been sent to the second system is recorded, and the BOM data and whether the BOM data has been sent to the second system is stored as a history record. When there is information in the history record that the BOM data has been sent to the second system, it is determined that the BOM data has been sent to the second system. When there is no information in the history record that the BOM data has been sent to the second system, it is determined that the BOM data has not been sent to the second system.
For example, as shown in
For example, if the composite product 20 formed from the raw material A and the raw material B corresponds to the first version of the PLM system and corresponds to the first version of the ERP system, a correspondence relationship of a first version of the docking system, the first version of the PLM system, and the first version of the ERP system to the composite product 20 is created. If the raw material C replaces the raw material B to form the composite product 21, a correspondence relationship of a second version of the docking system, the first version of the PLM system, and the first version of the ERP system to the composite product 21 is created. Thus, when the composite product 21 is sent from the PLM system to the ERP system, the corresponding ERP system version may be searched according to the correspondence relationship.
In block S03, the electronic device 1 can create a new version of a parent item according to the BOM data, and then block S06 is implemented.
When it is confirmed that the BOM data has not been transmitted to the second system, the received BOM data is the latest data in the database. Therefore, a new version of the parent item needs to be created based on the BOM data. In one embodiment, the BOM can be shows as a tree diagram. In the BOM tree diagram, the parent item is an uppermost layer of the tree diagram, and the direct child or indirect child items are shown below the parent item connected directly or indirectly to the parent item.
In block S04, the electronic device 1 can query a latest BOM data from the history record.
When it is confirmed that the BOM data is sent to the second system, the latest BOM data is queried from the history record, and the parent item of the queried BOM data is updated according to the received BOM data. It should be noted that the latest BOM data in the history record is the most recent BOM data received by the docking system.
In block S05, the electronic device 1 can create a new version of the parent item, wherein the new version of the parent item is obtained according to the latest BOM data queried according to the received BOM data.
In block S06, the electronic device 1 can establish a master-slave relationship according to the new parent item and the child item of the received BOM data, and graphically construct the received BOM data according to the master-slave relationship.
In block S07, the electronic device 1 can convert the graphically constructed BOM data into a BOM data structure supported by the second system.
It can be understood that a method for converting the graphically constructed BOM data into the BOM data structure supported by the second system is known in the related art, and details are not described herein again.
In block S08, the electronic device 1 can transmit the converted BOM data to the second system.
Through the above blocks S01 to S08, correspondence of items between the PLM system and the ERP system can be graphically represented, and a complete BOM data docking mechanism is provided between the PLM system and the ERP system, which is beneficial for data integration between the PLM system and the ERP system.
Referring to
The receiving module 101 is configured to receive BOM data sent by a first system, wherein the BOM data is BOM data created and modified by a user of the first system
The determining module 102 is configured to determine whether the BOM data has been sent to a second system.
The establishing module 103 is configured to create a new version of a parent item according to the BOM data when the BOM data is not sent to the second system.
The establishing module 103 is further configured to establish a master-slave relationship according to the new parent item and a child item of the received BOM data, and graphically construct the received BOM data according to the master-slave relationship.
The conversion module 104 is configured to convert the graphically constructed BOM data into a BOM data structure supported by the second system.
The sending module 105 is configured to send the converted BOM data to the second system.
The docking system 10 can graphically represent the correspondence of items between the PLM system and the ERP system, not only to achieve the purpose of visually presenting the correspondence between materials, but also to more flexibly access the BOM data corresponding to the materials. For details, refer to the foregoing embodiment of the data docking method, which is not described in detail herein.
In this embodiment, the memory 11 may be an internal memory of the electronic device 1, that is, a memory built in the electronic device 1. In other embodiments, the memory 11 may also be an external memory of the electronic device 1, that is, a memory external to the electronic device 1.
In some embodiments, the memory 11 is used to store program codes and various data, for example, program code of the docking system 10 installed in the electronic device 1.
The memory 11 may include a random access memory, and may also include a non-volatile memory such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), and a Secure Digital (SD) card, a Flash Card, at least one disk storage device, flash memory device, or other volatile solid-state storage device.
The processor 12 may be a central processing unit (CPU), or may be another general-purpose processor, a digital signal processor (DSP), or an application specific integrated circuit (ASIC), a Field-Programmable Gate Array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. The general-purpose processor may be a microprocessor or any other conventional processor or the like.
The embodiments shown and described above are only examples. Even though numerous characteristics and advantages of the present technology have been set forth in the foregoing description, together with details of the structure and function of the present disclosure, the disclosure is illustrative only, and changes may be made in the detail, including in matters of shape, size and arrangement of the parts within the principles of the present disclosure up to, and including, the full extent established by the broad general meaning of the terms used in the claims.
Number | Date | Country | Kind |
---|---|---|---|
108136782 | Oct 2019 | TW | national |