CN102708213A - Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system - Google Patents
Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) systemDownload PDFInfo
- Publication number
- CN102708213A CN102708213ACN2012101796423ACN201210179642ACN102708213ACN 102708213 ACN102708213 ACN 102708213ACN 2012101796423 ACN2012101796423 ACN 2012101796423ACN 201210179642 ACN201210179642 ACN 201210179642ACN 102708213 ACN102708213 ACN 102708213A
- Authority
- CN
- China
- Prior art keywords
- bom
- module
- information
- attribute
- input
- 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.)
- Granted
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Computer And Data Communications (AREA)
Abstract
Translated fromChineseDescription
Translated fromChinese技术领域technical field
本发明涉及一种ERP（Enterprise Resource Planning，企业资源计划）系统中BOM（Bill of Material，物料清单）信息的输入方法，尤其是涉及一种在PDM（Product DataManagement，产品数据管理）系统与ERP系统之间实现BOM信息传输的方法。The present invention relates to an input method of BOM (Bill of Material, bill of materials) information in an ERP (Enterprise Resource Planning, enterprise resource planning) system, in particular to a method for inputting information in a PDM (Product Data Management, product data management) system and an ERP system The method of realizing BOM information transmission between them.
背景技术Background technique
BOM（Bill of Material，物料清单）是指产品所需的零部件的清单及组成结构，其来源于PDM系统，并且是ERP系统中重要的基础数据。传统的ERP系统中BOM信息的输入主要采用手工录入法，即将PDM系统中的BOM信息导出到EXCEL表格中，再将EXCEL表格中的BOM信息手工录入至ERP系统中。这种手工录入法存在数据多次重复录入的缺陷，即PDM系统中录入一次，ERP系统中又录入一次，从而大大降低了企业信息化效率，此外多次手工录入会不可避免的导致误操作的发生。BOM (Bill of Material, Bill of Materials) refers to the list and composition structure of the parts required by the product, which comes from the PDM system and is an important basic data in the ERP system. The input of BOM information in the traditional ERP system mainly adopts the manual entry method, that is, the BOM information in the PDM system is exported to the EXCEL form, and then the BOM information in the EXCEL form is manually entered into the ERP system. This manual entry method has the defect of repeated data entry, that is, one entry in the PDM system and another entry in the ERP system, which greatly reduces the efficiency of enterprise informatization. In addition, multiple manual entry will inevitably lead to misoperation. occur.
为了克服手工录入法存在的缺点，以保证企业里ERP系统和PDM系统的有效合理运行，相关研究人员提出了实现BOM信息的自动录入方法。目前，实现BOM信息的自动录入方法主要有三种，即采用主动式接口的自动录入方法、采用被动式接口的自动录入方法和采用中间式接口的自动录入方法。采用主动式接口的自动录入方法为：PDM系统将ERP系统所需的BOM信息直接写入ERP系统的数据库中；采用被动式接口的自动录入方法为：ERP系统从PDM系统中读取所需的BOM信息，将其写入自己的数据库中；采用中间式接口的自动录入方法为：PDM系统将ERP系统所需的BOM信息生成中间文件和中间数据表，ERP系统直接读取中间文件或中间数据表中的BOM信息写入数据库。上述前两种实现BOM信息的自动录入方法均需要访问ERP系统和PDM系统的繁冗数据库，可操作性及数据安全性不高；后一种实现BOM信息的自动录入方法由于生成的中间文件和中间数据表的结构形式较为固定，仅适用于少数的PDM系统和ERP系统，通用性差。In order to overcome the shortcomings of the manual entry method and ensure the effective and reasonable operation of the ERP system and PDM system in the enterprise, relevant researchers have proposed an automatic entry method for BOM information. At present, there are mainly three methods for realizing the automatic entry of BOM information, that is, the automatic entry method using the active interface, the automatic entry method using the passive interface, and the automatic entry method using the intermediate interface. The automatic input method using the active interface is: the PDM system directly writes the BOM information required by the ERP system into the database of the ERP system; the automatic input method using the passive interface is: the ERP system reads the required BOM from the PDM system information, and write it into its own database; the automatic entry method using the intermediate interface is: the PDM system generates intermediate files and intermediate data tables from the BOM information required by the ERP system, and the ERP system directly reads the intermediate files or intermediate data tables Write the BOM information in the database. The above-mentioned first two automatic input methods for BOM information need to access the redundant databases of ERP system and PDM system, and the operability and data security are not high; the latter automatic input method for BOM information is due to the generated intermediate files and intermediate The structural form of the data table is relatively fixed, which is only applicable to a few PDM systems and ERP systems, and has poor versatility.
发明内容Contents of the invention
本发明所要解决的技术问题是提供一种在PDM系统与ERP系统之间实现BOM信息传输的方法，其能够实现BOM信息的自动输入，且可操作性好、通用性好、安全性能高。The technical problem to be solved by the present invention is to provide a method for realizing BOM information transmission between a PDM system and an ERP system, which can realize automatic input of BOM information, and has good operability, good versatility and high safety performance.
本发明解决上述技术问题所采用的技术方案为：一种在PDM系统与ERP系统之间实现BOM信息传输的方法，其特征在于包括以下步骤：The technical solution adopted by the present invention to solve the above technical problems is: a method for realizing BOM information transmission between a PDM system and an ERP system, which is characterized in that it comprises the following steps:
①-1、在PDM系统与ERP系统之间设置一个BOM传输接口，该BOM传输接口具有一个与PDM系统中用于输出BOM信息的端口相连接的BOM信息输入端和一个与ERP系统中用于输入BOM信息的端口相连接的BOM信息输出端，该BOM传输接口设置有BOM自定义属性管理模块、BOM数据整合模块、模式设置模块和BOM信息输入模块，BOM数据整合模块的输入端分别与BOM自定义属性管理模块的输出端和PDM系统中用于输出BOM信息的端口相连接，BOM数据整合模块的输出端与BOM信息输入模块的输入端相连接，BOM信息输入模块的控制端与模块设置模块的输出端相连接，BOM信息输入模块的输出端与ERP系统中用于输入BOM信息的端口相连接；①-1. Set up a BOM transmission interface between the PDM system and the ERP system. The BOM transmission interface has a BOM information input port connected to the port used to output BOM information in the PDM system and a port used to output BOM information in the ERP system. The BOM information output terminal connected to the port for inputting BOM information. The BOM transmission interface is provided with a BOM custom attribute management module, a BOM data integration module, a mode setting module, and a BOM information input module. The input terminals of the BOM data integration module are respectively connected to the BOM The output terminal of the custom attribute management module is connected to the port used to output BOM information in the PDM system, the output terminal of the BOM data integration module is connected to the input terminal of the BOM information input module, and the control terminal of the BOM information input module is connected to the module setting The output end of the module is connected, and the output end of the BOM information input module is connected with the port used to input BOM information in the ERP system;
①-2、打开PDM系统和ERP系统，并将ERP系统的BOM信息录入界面的状态设置为BOM信息输入状态；①-2. Open the PDM system and ERP system, and set the state of the BOM information input interface of the ERP system to the BOM information input state;
①-3、在BOM自定义属性管理模块中构建一个BOM自定义属性名称表、一个BOM自定义属性内容表和一个自定义属性值存储表，在BOM自定义属性名称表中设置用于向ERP系统中输入PDM系统中不存在的BOM属性名称及针对不同的BOM属性名称设置的属性名称索引；在BOM自定义属性内容表中设置用于为BOM属性名称提供备选项的BOM属性内容、BOM属性内容对应的BOM属性名称的属性名称索引及针对不同的BOM属性内容设置的属性内容索引，并通过属性名称索引将BOM属性内容和BOM属性名称绑定；在自定义属性值存储表中设置物料代号、物料代号对应的BOM属性内容及与物料代号对应的BOM属性内容相对应的BOM属性名称的属性名称索引，并通过属性名称索引将物料代号和BOM属性名称绑定；然后BOM自定义属性管理模块将ERP系统需要的并存在于BOM自定义属性管理模块中的BOM信息中的物料代号传输给BOM数据整合模块；①-3. Construct a BOM custom attribute name table, a BOM custom attribute content table and a custom attribute value storage table in the BOM custom attribute management module, and set in the BOM custom attribute name table for sending to ERP Enter the BOM attribute name that does not exist in the PDM system and the attribute name index set for different BOM attribute names in the system; set the BOM attribute content and BOM attribute used to provide alternative options for the BOM attribute name in the BOM custom attribute content table The attribute name index of the BOM attribute name corresponding to the content and the attribute content index set for different BOM attribute content, and bind the BOM attribute content and BOM attribute name through the attribute name index; set the material code in the custom attribute value storage table , the BOM attribute content corresponding to the material code and the attribute name index of the BOM attribute name corresponding to the BOM attribute content corresponding to the material code, and bind the material code and the BOM attribute name through the attribute name index; then BOM custom attribute management module Transfer the material code required by the ERP system and in the BOM information in the BOM custom attribute management module to the BOM data integration module;
①-4、BOM数据整合模块从PDM系统中提取出ERP系统需要的并存在于PDM系统中的BOM信息，然后BOM数据整合模块根据物料代号将BOM自定义属性管理模块中的BOM信息与PDM系统中的BOM信息进行整合，并将整合后形成的符合ERP系统格式的生产BOM信息传输给BOM信息输入模块；①-4. The BOM data integration module extracts the BOM information required by the ERP system and exists in the PDM system from the PDM system, and then the BOM data integration module combines the BOM information in the BOM custom attribute management module with the BOM information in the PDM system according to the material code The integrated BOM information is integrated, and the integrated production BOM information conforming to the ERP system format is transmitted to the BOM information input module;
①-5、在模式设置模块中构建一个操作命令列表，然后模式设置模块利用HOOK技术获取ERP系统中的BOM信息录入界面上的所有待录入位置的操作点坐标，并在各个操作点坐标上设置相应的鼠标及键盘的操作命令，接着模式设置模块将所有鼠标及键盘的操作命令添加到操作命令列表中，并对操作命令列表中的各个鼠标及键盘的操作命令设置命令名称，最后模式设置模块将命令名称保存至BOM传输接口的数据库中；①-5. Construct an operation command list in the mode setting module, and then the mode setting module uses HOOK technology to obtain the operation point coordinates of all positions to be entered on the BOM information entry interface in the ERP system, and set them on the coordinates of each operation point Corresponding mouse and keyboard operation commands, then the mode setting module adds the operation commands of all mice and keyboards in the operation command list, and sets the command name for each mouse and keyboard operation commands in the operation command list, and finally the mode setting module Save the command name to the database of the BOM transmission interface;
①-6、BOM信息输入模块利用操作系统中的API函数设置并锁定用户的屏幕分辨率至BOM传输接口要求的分辨率，接着BOM信息输入模块解析存放于BOM传输接口的数据库中的命令名称对应的鼠标及键盘的操作命令，最后BOM信息输入模块调用操作系统中的API函数智能的模拟人工录入方式在ERP系统的BOM信息录入界面中输入生产BOM信息，在输入生产BOM信息的过程中BOM信息输入模块截断鼠标和键盘的输入功能，防止生产BOM信息输入过程中受到外界信号的干扰。①-6. The BOM information input module uses the API function in the operating system to set and lock the user's screen resolution to the resolution required by the BOM transmission interface, and then the BOM information input module parses the corresponding command name stored in the database of the BOM transmission interface The mouse and keyboard operation commands, and finally the BOM information input module calls the API function in the operating system to intelligently simulate the manual input method to input the production BOM information in the BOM information input interface of the ERP system, and the BOM information in the process of inputting the production BOM information The input module cuts off the input functions of the mouse and keyboard to prevent interference from external signals during the production BOM information input process.
在所述的步骤①-1中将BOM数据整合模块的输出端与PDM系统中的录入批准模块的输入端相连接，将PDM系统中的录入批准模块的输出端与BOM信息输入模块的输入端相连接；在所述的步骤①-4中将整合后形成的符合ERP系统格式的生产BOM信息提交至PDM系统中的录入批准模块，PDM系统中的录入批准模块对生产BOM信息进行审核，并将审核后的生产BOM信息传输给BOM信息输入模块。In the step ①-1, connect the output end of the BOM data integration module with the input end of the entry approval module in the PDM system, and connect the output end of the entry approval module in the PDM system with the input end of the BOM information input module In step ①-4, submit the integrated production BOM information conforming to the format of the ERP system to the input approval module in the PDM system, and the input approval module in the PDM system will review the production BOM information, and Transmit the approved production BOM information to the BOM information input module.
一种在PDM系统与ERP系统之间实现BOM信息传输的方法，其特征在于包括以下步骤：A method for realizing BOM information transmission between a PDM system and an ERP system, characterized in that it comprises the following steps:
②-1、在PDM系统与ERP系统之间设置一个BOM传输接口，该BOM传输接口具有一个与PDM系统中用于输出BOM信息的端口相连接的BOM信息输入端和一个与ERP系统中用于输入BOM信息的端口相连接的BOM信息输出端，该BOM传输接口设置有BOM自定义属性管理模块、BOM数据整合模块、模板管理模块和BOM信息输入模块，BOM数据整合模块的输入端分别与BOM自定义属性管理模块的输出端和PDM系统中用于输出BOM信息的端口相连接，BOM数据整合模块的输出端与模板管理模块的输入端相连接，模板管理模块的输出端与BOM信息输入模块的输入端相连接，BOM信息输入模块的输出端与ERP系统中用于输入BOM信息的端口相连接；②-1. Set up a BOM transmission interface between the PDM system and the ERP system. The BOM transmission interface has a BOM information input port connected to the port used to output BOM information in the PDM system and a port used to output BOM information in the ERP system. The BOM information output terminal connected to the port for inputting BOM information, the BOM transmission interface is provided with a BOM custom attribute management module, a BOM data integration module, a template management module and a BOM information input module, and the input terminals of the BOM data integration module are respectively connected to the BOM The output terminal of the custom attribute management module is connected to the port used to output BOM information in the PDM system, the output terminal of the BOM data integration module is connected to the input terminal of the template management module, and the output terminal of the template management module is connected to the BOM information input module The input end of the module is connected, and the output end of the BOM information input module is connected to the port used to input BOM information in the ERP system;
②-2、打开PDM系统和ERP系统，并将ERP系统的BOM信息录入界面的状态设置为BOM信息输入状态；②-2. Open the PDM system and ERP system, and set the state of the BOM information input interface of the ERP system to the BOM information input state;
②-3、在BOM自定义属性管理模块中构建一个BOM自定义属性名称表、一个BOM自定义属性内容表和一个自定义属性值存储表，在BOM自定义属性名称表中设置用于向ERP系统中输入PDM系统中不存在的BOM属性名称及针对不同的BOM属性名称设置的属性名称索引；在BOM自定义属性内容表中设置用于为BOM属性名称提供备选项的BOM属性内容、BOM属性内容对应的BOM属性名称的属性名称索引及针对不同的BOM属性内容设置的属性内容索引，并通过属性名称索引将BOM属性内容和BOM属性名称绑定；在自定义属性值存储表中设置物料代号、物料代号对应的BOM属性内容及与物料代号对应的BOM属性内容相对应的BOM属性名称的属性名称索引，并通过属性名称索引将物料代号和BOM属性名称绑定；然后BOM自定义属性管理模块将ERP系统需要的并存在于自定义属性管理模块中的BOM信息中的物料代号传输给BOM数据整合模块；②-3. Construct a BOM custom attribute name table, a BOM custom attribute content table and a custom attribute value storage table in the BOM custom attribute management module, and set in the BOM custom attribute name table for sending to ERP Enter the BOM attribute name that does not exist in the PDM system and the attribute name index set for different BOM attribute names in the system; set the BOM attribute content and BOM attribute used to provide alternative options for the BOM attribute name in the BOM custom attribute content table The attribute name index of the BOM attribute name corresponding to the content and the attribute content index set for different BOM attribute content, and bind the BOM attribute content and BOM attribute name through the attribute name index; set the material code in the custom attribute value storage table , the BOM attribute content corresponding to the material code and the attribute name index of the BOM attribute name corresponding to the BOM attribute content corresponding to the material code, and bind the material code and the BOM attribute name through the attribute name index; then BOM custom attribute management module Transfer the material code required by the ERP system and existing in the BOM information in the custom attribute management module to the BOM data integration module;
②-4、BOM数据整合模块从PDM系统中提取出ERP系统需要的并存在于PDM系统中的BOM信息，然后BOM数据整合模块根据物料代号将BOM自定义属性管理模块中的BOM信息与PDM系统中的BOM信息进行整合，并将整合后形成的符合ERP系统格式的生产BOM信息传输给模板管理模块；②-4. The BOM data integration module extracts the BOM information required by the ERP system and exists in the PDM system from the PDM system, and then the BOM data integration module combines the BOM information in the BOM custom attribute management module with the BOM information in the PDM system according to the material code The integrated BOM information is integrated, and the integrated production BOM information conforming to the ERP system format is transmitted to the template management module;
②-5、在模板管理模块中调用操作系统的Sniffer函数截取ERP系统客户端向ERP系统服务端存储数据时发送的数据包，然后模板管理模块分析截取的数据包，将数据包中的BOM信息替换为可识别的特殊字符串标记，接着模板管理模块将可识别的特殊字符串标记以模板的形式进行保存，再用生产BOM信息替换模板中的可识别的特殊字符串标记，最后模板管理模块将模板传输给BOM信息输入模块；②-5. Call the Sniffer function of the operating system in the template management module to intercept the data packet sent by the ERP system client to the ERP system server when storing data, then the template management module analyzes the intercepted data packet, and converts the BOM information in the data packet Replace it with a recognizable special string mark, and then the template management module saves the recognizable special string mark in the form of a template, and then replaces the recognizable special string mark in the template with the production BOM information, and finally the template management module Transfer the template to the BOM information input module;
②-6、BOM信息输入模块通过套接字模拟ERP系统客户端向ERP系统服务端发送包含有生产BOM信息的模板。②-6. The BOM information input module simulates the ERP system client to send the template containing the production BOM information to the ERP system server through the socket.
在所述的步骤②-1中将BOM数据整合模块的输出端与PDM系统中的录入批准模块的输入端相连接，将PDM系统中的录入批准模块的输出端与模板管理模块的输入端相连接；在所述的步骤②-4中将整合后形成的符合ERP系统格式的生产BOM信息提交至PDM系统中的录入批准模块，PDM系统中的录入批准模块对生产BOM信息进行审核，并将审核后的生产BOM信息传输给模板管理模块。In the step ②-1, connect the output end of the BOM data integration module with the input end of the entry approval module in the PDM system, and connect the output end of the entry approval module in the PDM system with the input end of the template management module Connection; in step ②-4, submit the integrated production BOM information conforming to the format of the ERP system to the entry approval module in the PDM system, which will review the production BOM information and send The approved production BOM information is transmitted to the template management module.
与现有技术相比，本发明的优点在于：Compared with the prior art, the present invention has the advantages of:
1）、本发明方法通过在PDM系统与ERP系统之间设置一个BOM传输接口，利用该BOM传输接口实现向ERP系统自动录入BOM信息，不仅避免了传统的手工录入方法存在的数据重复输入的问题，从而大大降低了人工成本，而且有效克服了人为因素所造成的BOM信息输入误操作。1), the method of the present invention sets a BOM transmission interface between the PDM system and the ERP system, and uses the BOM transmission interface to automatically enter BOM information into the ERP system, which not only avoids the problem of repeated data input in the traditional manual entry method , thereby greatly reducing labor costs, and effectively overcoming the misoperation of BOM information input caused by human factors.
2）、本发明方法通过模式设置模块与BOM信息输入模块模拟人工录入方式实现BOM信息的自动录入，或通过模板管理模块截取ERP系统客户端向ERP系统服务端发送数据包的过程实现BOM信息的自动录入，可操作性好，而且不受ERP系统及PDM系统繁冗数据库的限制。2), the method of the present invention realizes the automatic entry of BOM information through the mode setting module and the BOM information input module simulating the manual entry mode, or intercepts the process of sending data packets from the ERP system client to the ERP system server through the template management module to realize the BOM information Automatic input, good operability, and not limited by the complicated database of ERP system and PDM system.
3）、本发明方法通过BOM数据整合模块完成ERP系统与BOM信息的关联设置，无需借助中间文件或中间数据表，这样当用户需要更换ERP系统或对ERP系统进行升级时，无需重新设置，通用性好。3) The method of the present invention completes the association setting of the ERP system and the BOM information through the BOM data integration module, without the use of intermediate files or intermediate data tables, so that when the user needs to replace the ERP system or upgrade the ERP system, there is no need to reset, and it is universal Good sex.
4）、本发明方法模拟人工录入方式或者通过截取ERP系统客户端向ERP系统服务端发送数据包的过程将BOM信息输入到ERP系统中，信息输入安全性好，不易发生错误。4), the method of the present invention simulates the manual input method or intercepts the process of sending data packets from the ERP system client to the ERP system server to input BOM information into the ERP system, which has good information input security and is not prone to errors.
附图说明Description of drawings
图1为本发明方法中采用的BOM传输接口与PDM系统和ERP系统的连接关系示意图；Fig. 1 is the connection relation schematic diagram of the BOM transmission interface that adopts in the inventive method and PDM system and ERP system;
图2为本实施例一中的BOM传输接口的组成结构示意图；FIG. 2 is a schematic diagram of the composition structure of the BOM transmission interface in the first embodiment;
图3为本实施例三中的BOM传输接口的组成结构示意图。FIG. 3 is a schematic diagram of the composition and structure of the BOM transmission interface in the third embodiment.
具体实施方式Detailed ways
以下结合附图实施例对本发明作进一步详细描述。The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments.
实施例一：Embodiment one:
本实施例提出的一种在PDM系统与ERP系统之间实现BOM信息传输的方法，其基本思想是模拟人工录入方式向ERP系统录入BOM信息，其包括以下步骤：A method for realizing BOM information transmission between the PDM system and the ERP system proposed in this embodiment, its basic idea is to input BOM information to the ERP system by simulating the manual input method, which includes the following steps:
①-1、如图1所示，在PDM系统与ERP系统之间设置一个BOM传输接口，该BOM传输接口具有一个与PDM系统中用于输出BOM信息的端口相连接的BOM信息输入端和一个与ERP系统中用于输入BOM信息的端口相连接的BOM信息输出端，该BOM传输接口的组成结构如图2所示，其设置有BOM自定义属性管理模块、BOM数据整合模块、模式设置模块和BOM信息输入模块，BOM数据整合模块的输入端分别与BOM自定义属性管理模块的输出端和PDM系统中用于输出BOM信息的端口相连接，BOM数据整合模块的输出端与BOM信息输入模块的输入端相连接，BOM信息输入模块的控制端与模块设置模块的输出端相连接，BOM信息输入模块的输出端与ERP系统中用于输入BOM信息的端口相连接，BOM自定义属性管理模块提供ERP系统需要而PDM系统中不存在的BOM信息给BOM数据整合模块，BOM数据整合模块提取ERP系统需要并存在于PDM系统中的BOM信息，BOM数据整合模块整合BOM自定义属性管理模块中的BOM信息和PDM系统中的BOM信息，并传输整合成的生产BOM信息给BOM信息输入模块，BOM信息输入模块根据模式设置模块设置的命令名称向ERP系统输入BOM信息。①-1. As shown in Figure 1, a BOM transmission interface is set between the PDM system and the ERP system. The BOM transmission interface has a BOM information input terminal connected to a port for outputting BOM information in the PDM system and a The BOM information output terminal connected to the port used to input BOM information in the ERP system, the composition structure of the BOM transmission interface is shown in Figure 2, which is equipped with a BOM custom attribute management module, a BOM data integration module, and a mode setting module and the BOM information input module, the input end of the BOM data integration module is respectively connected with the output end of the BOM custom attribute management module and the port used to output BOM information in the PDM system, and the output end of the BOM data integration module is connected with the BOM information input module The control terminal of the BOM information input module is connected to the output terminal of the module setting module, the output terminal of the BOM information input module is connected to the port used to input BOM information in the ERP system, and the BOM custom attribute management module Provide the BOM information needed by the ERP system but not in the PDM system to the BOM data integration module. The BOM data integration module extracts the BOM information required by the ERP system and exists in the PDM system. The BOM data integration module integrates the BOM in the BOM custom attribute management module Information and BOM information in the PDM system, and transmit the integrated production BOM information to the BOM information input module, and the BOM information input module inputs BOM information to the ERP system according to the command name set by the mode setting module.
在此，BOM自定义属性管理模块用于为ERP系统提供其需要而PDM系统中不存在的BOM信息，当ERP系统需要的BOM信息在PDM系统中不存在时可向BOM传输接口的BOM自定义属性管理模块中临时调用，有效保证了ERP系统需要的BOM信息的完整性；BOM数据整合模块主要用于对PDM系统提供的BOM信息和BOM自定义属性管理模块提供的BOM信息进行整合，以使整合后的BOM信息符合ERP系统中对BOM信息的格式的要求；模式设置模块主要通过命令将向ERP系统输入BOM信息的过程设置成简单的计算机可以识别的命令列表，并保存于BOM传输接口的数据库中以备调用；BOM信息输入模块主要通过解析模式设置模块中的命令，调用操作系统的API函数智能的再现人工输入的过程向ERP系统输入BOM信息，并在输入的过程中通过采集ERP系统界面程序的反应来智能的做出对后续动作的影响和操作，最终正确的把BOM信息输入到ERP系统中。Here, the BOM custom attribute management module is used to provide the ERP system with the BOM information that it needs but does not exist in the PDM system. When the BOM information required by the ERP system does not exist in the PDM system, it can be customized to the BOM transmission interface. The temporary call in the attribute management module effectively ensures the integrity of the BOM information required by the ERP system; the BOM data integration module is mainly used to integrate the BOM information provided by the PDM system and the BOM information provided by the BOM custom attribute management module, so that The integrated BOM information conforms to the format requirements of the BOM information in the ERP system; the mode setting module mainly sets the process of inputting BOM information to the ERP system into a simple command list that can be recognized by the computer through commands, and saves it in the BOM transmission interface. The database is ready for calling; the BOM information input module mainly uses the commands in the mode setting module to call the API function of the operating system to intelligently reproduce the manual input process to input BOM information to the ERP system, and collect the ERP system information during the input process. The response of the interface program is to intelligently make influences and operations on subsequent actions, and finally correctly input the BOM information into the ERP system.
①-2、打开PDM系统和ERP系统，并将ERP系统的BOM信息录入界面的状态设置为BOM信息输入状态。①-2. Open the PDM system and ERP system, and set the status of the BOM information input interface of the ERP system to the BOM information input status.
①-3、在BOM自定义属性管理模块中构建一个BOM自定义属性名称表、一个BOM自定义属性内容表和一个自定义属性值存储表，在BOM自定义属性名称表中设置用于向ERP系统中输入PDM系统中不存在的BOM属性名称及针对不同的BOM属性名称设置的属性名称索引，表1给出了一个BOM自定义属性名称表的范例，在表1中针对BOM属性名称为颜色设置的属性名称索引为1；在BOM自定义属性内容表中设置用于为BOM属性名称提供备选项的BOM属性内容、BOM属性内容对应的BOM属性名称的属性名称索引及针对不同的BOM属性内容设置的属性内容索引，并通过属性名称索引将BOM属性内容和BOM属性名称绑定，表2给出了一个BOM自定义属性内容表的范例，在表2中绿色、红色、黄色、紫色等是BOM属性名称为颜色提供的备选项的BOM属性内容；在自定义属性值存储表中设置物料代号、物料代号对应的BOM属性内容及与物料代号对应的BOM属性内容相对应的BOM属性名称的属性名称索引，并通过属性名称索引将物料代号和BOM属性名称绑定，表3给出了一个自定义属性值存储表的范例，当需要向ERP系统中补充BOM信息时，从BOM自定义属性名称表中索引到相关属性名称，再索引BOM自定义属性内容表，获得相关属性内容；然后BOM自定义属性管理模块将ERP系统需要的并存在于BOM自定义属性管理模块中的BOM信息中的物料代号传输给BOM数据整合模块。①-3. Construct a BOM custom attribute name table, a BOM custom attribute content table and a custom attribute value storage table in the BOM custom attribute management module, and set in the BOM custom attribute name table for sending to ERP Enter the BOM attribute name that does not exist in the PDM system and the attribute name index set for different BOM attribute names in the system. Table 1 shows an example of a BOM custom attribute name table. In Table 1, the BOM attribute name is color Set the attribute name index to 1; set the BOM attribute content used to provide alternative options for the BOM attribute name in the BOM custom attribute content table, the attribute name index of the BOM attribute name corresponding to the BOM attribute content, and for different BOM attribute contents Set the attribute content index, and bind the BOM attribute content and BOM attribute name through the attribute name index. Table 2 shows an example of a BOM custom attribute content table. In Table 2, green, red, yellow, purple, etc. are The BOM attribute name is the BOM attribute content of the option provided by the color; set the material code, the BOM attribute content corresponding to the material code, and the attribute of the BOM attribute name corresponding to the BOM attribute content corresponding to the material code in the custom attribute value storage table Name index, and bind the material code and BOM attribute name through the attribute name index. Table 3 gives an example of a custom attribute value storage table. When it is necessary to supplement BOM information to the ERP system, the custom attribute name from BOM Index the relevant attribute name in the table, and then index the BOM custom attribute content table to obtain the relevant attribute content; then the BOM custom attribute management module will use the material code required by the ERP system and exists in the BOM information in the BOM custom attribute management module Transfer to the BOM data integration module.
表1BOM自定义属性名称表Table 1 BOM custom attribute name table
表2BOM自定义属性内容表Table 2 BOM custom attribute content table
表3自定义属性值存储表Table 3 Custom attribute value storage table
①-4、BOM数据整合模块从PDM系统中提取出ERP系统需要的并存在于PDM系统中的BOM信息（如表4所列，PDM系统中的BOM信息包括物料代号、物料名称、材料、数量、单重、总重和规格），然后BOM数据整合模块根据物料代号将BOM自定义属性管理模块中的BOM信息与PDM系统中的BOM信息进行整合，并将整合后形成的符合ERP系统格式的生产BOM信息传输给BOM信息输入模块。在此，可将整合成的生产BOM信息转换为EXCEL格式的文件，以便于查看。①-4. The BOM data integration module extracts the BOM information required by the ERP system and exists in the PDM system from the PDM system (as listed in Table 4, the BOM information in the PDM system includes material code, material name, material, quantity, unit weight, total weight, and specifications), and then the BOM data integration module integrates the BOM information in the BOM custom attribute management module with the BOM information in the PDM system according to the material code, and forms the production conforming to the ERP system format after the integration The BOM information is transmitted to the BOM information input module. Here, the integrated production BOM information can be converted into an EXCEL format file for easy viewing.
表4PDM系统中的BOM信息Table 4 BOM information in the PDM system
①-5、在模式设置模块中构建一个操作命令列表，然后模式设置模块利用HOOK技术获取ERP系统中的BOM信息录入界面上的所有待录入位置的操作点坐标，并在各个操作点坐标上设置相应的鼠标及键盘的操作命令，接着模式设置模块将所有鼠标及键盘的操作命令添加到操作命令列表中，并对操作命令列表中的各个鼠标及键盘的操作命令设置命令名称，最后模式设置模块将命令名称保存至BOM传输接口的数据库中。①-5. Construct an operation command list in the mode setting module, and then the mode setting module uses HOOK technology to obtain the operation point coordinates of all positions to be entered on the BOM information entry interface in the ERP system, and set them on the coordinates of each operation point Corresponding mouse and keyboard operation commands, then the mode setting module adds the operation commands of all mice and keyboards in the operation command list, and sets the command name for each mouse and keyboard operation commands in the operation command list, and finally the mode setting module Save the command name to the database of the BOM transfer interface.
①-6、BOM信息输入模块利用操作系统中的API函数设置并锁定用户的屏幕分辨率至BOM传输接口要求的分辨率，接着BOM信息输入模块解析存放于BOM传输接口的数据库中的命令名称对应的鼠标及键盘的操作命令，最后BOM信息输入模块调用操作系统中的API函数智能的模拟人工录入方式在ERP系统的BOM信息录入界面中输入生产BOM信息，在输入生产BOM信息的过程中BOM信息输入模块截断鼠标和键盘的输入功能，防止生产BOM信息输入过程中受到外界信号的干扰。①-6. The BOM information input module uses the API function in the operating system to set and lock the user's screen resolution to the resolution required by the BOM transmission interface, and then the BOM information input module parses the corresponding command name stored in the database of the BOM transmission interface The mouse and keyboard operation commands, and finally the BOM information input module calls the API function in the operating system to intelligently simulate the manual input method to input the production BOM information in the BOM information input interface of the ERP system, and the BOM information in the process of inputting the production BOM information The input module cuts off the input functions of the mouse and keyboard to prevent interference from external signals during the production BOM information input process.
实施例二：Embodiment two:
本实施例的BOM信息传输方法为在实施例一的BOM信息传输方法的基础上，在步骤①-1中将BOM数据整合模块的输出端与PDM系统中的录入批准模块的输入端相连接，将PDM系统中的录入批准模块的输出端与BOM信息输入模块的输入端相连接；在步骤①-4中将整合后形成的符合ERP系统格式的生产BOM信息提交至PDM系统中的录入批准模块，PDM系统中的录入批准模块对生产BOM信息进行审核，并将审核后的生产BOM信息传输给BOM信息输入模块。在本实施例中，PDM系统中的录入批准模块的主要作用是：将BOM数据整合模块发送过来的生产BOM信息提交至PDM系统，在PDM系统中，根据预定的审批流程对生产BOM信息进行审核，审核通过之后，录入批准模块将批准的生产BOM信息发送至BOM信息输入模块，本实施例的方法利用PDM系统中的录入批准模块对BOM数据整合模块整合成的生产BOM信息进行审核，能够进一步确保生产BOM信息的准确性。The BOM information transmission method of this embodiment is based on the BOM information transmission method of Embodiment 1, in step ①-1, the output end of the BOM data integration module is connected with the input end of the entry approval module in the PDM system, Connect the output of the input approval module in the PDM system with the input of the BOM information input module; submit the integrated production BOM information conforming to the ERP system format to the input approval module in the PDM system in steps ①-4 , the input approval module in the PDM system reviews the production BOM information, and transmits the reviewed production BOM information to the BOM information input module. In this embodiment, the main function of the entry approval module in the PDM system is to submit the production BOM information sent by the BOM data integration module to the PDM system, and in the PDM system, review the production BOM information according to the predetermined approval process After the review is passed, the input approval module sends the approved production BOM information to the BOM information input module. The method of this embodiment uses the input approval module in the PDM system to review the production BOM information integrated by the BOM data integration module, which can further Ensure the accuracy of production BOM information.
实施例三：Embodiment three:
本实施例提出的一种在PDM系统与ERP系统之间实现BOM信息传输的方法，其基本思想是模拟ERP系统客户端向ERP系统服务器发送BOM信息，其包括以下步骤：A kind of method that this embodiment proposes realizes BOM information transmission between PDM system and ERP system, its basic idea is to simulate ERP system client to send BOM information to ERP system server, it comprises the following steps:
②-1、在PDM系统与ERP系统之间设置一个BOM传输接口，该BOM传输接口具有一个与PDM系统中用于输出BOM信息的端口相连接的BOM信息输入端和一个与ERP系统中用于输入BOM信息的端口相连接的BOM信息输出端，该BOM传输接口的组成结构如图3所示，其设置有BOM自定义属性管理模块、BOM数据整合模块、模板管理模块和BOM信息输入模块，BOM数据整合模块的输入端分别与BOM自定义属性管理模块的输出端和PDM系统中用于输出BOM信息的端口相连接，BOM数据整合模块的输出端与模板管理模块的输入端相连接，模板管理模块的输出端与BOM信息输入模块的输入端相连接，BOM信息输入模块的输出端与ERP系统中用于输入BOM信息的端口相连接，BOM自定义属性管理模块提供ERP系统需要而PDM系统中不存在的BOM信息给BOM数据整合模块，BOM数据整合模块提取ERP系统需要并存在于PDM系统中的BOM信息，BOM数据整合模块整合BOM自定义属性管理模块中的BOM信息和PDM系统中的BOM信息，并传输整合成的生产BOM信息给模板管理模块，模板管理模块将审核后的生产BOM信息转换为模板信息，并传输模板信息给BOM信息输入模块，BOM信息输入模块根据模板信息产生含BOM信息的数据包，并通过套接字模拟ERP系统向ERP服务端发送产生的含BOM信息的数据包。②-1. Set up a BOM transmission interface between the PDM system and the ERP system. The BOM transmission interface has a BOM information input port connected to the port used to output BOM information in the PDM system and a port used to output BOM information in the ERP system. The BOM information output terminal connected to the port for inputting BOM information, the structure of the BOM transmission interface is shown in Figure 3, which is provided with a BOM custom attribute management module, a BOM data integration module, a template management module and a BOM information input module, The input end of the BOM data integration module is respectively connected to the output end of the BOM custom attribute management module and the port used to output BOM information in the PDM system, and the output end of the BOM data integration module is connected to the input end of the template management module. The output end of the management module is connected to the input end of the BOM information input module, and the output end of the BOM information input module is connected to the port used to input BOM information in the ERP system. The BOM custom attribute management module provides the ERP system needs and the PDM system The BOM information that does not exist in the BOM data integration module, the BOM data integration module extracts the BOM information required by the ERP system and exists in the PDM system, and the BOM data integration module integrates the BOM information in the BOM custom attribute management module and the BOM in the PDM system information, and transmit the integrated production BOM information to the template management module, the template management module converts the audited production BOM information into template information, and transmits the template information to the BOM information input module, and the BOM information input module generates BOM according to the template information Information packets, and simulate the ERP system through the socket to send the generated data packets containing BOM information to the ERP server.
本实施例中的BOM自定义属性管理模块和BOM数据整合模块的作用与实施例一中的BOM自定义属性管理模块和BOM数据整合模块的作用相同；在此，模板管理模块主要通过网络拦截ERP系统客户端向ERP系统服务端存储BOM信息时的数据包，并通过分析其数据包结构得出通信的模板信息，同时保存其模板信息；BOM信息输入模块主要用BOM数据整合模块中的BOM信息替换模板信息中相应的数据项产生数据包，再通过套接字模拟ERP系统向ERP服务端发送数据包。The functions of the BOM custom attribute management module and the BOM data integration module in this embodiment are the same as those of the BOM custom attribute management module and the BOM data integration module in Embodiment 1; here, the template management module mainly intercepts the ERP through the network The system client stores the data packets of BOM information to the ERP system server, and obtains the communication template information by analyzing the data packet structure, and saves its template information at the same time; the BOM information input module mainly uses the BOM information in the BOM data integration module Replace the corresponding data items in the template information to generate a data packet, and then simulate the ERP system through the socket to send the data packet to the ERP server.
②-2、打开PDM系统和ERP系统，并将ERP系统的BOM信息录入界面的状态设置为BOM信息输入状态。②-2. Open the PDM system and ERP system, and set the status of the BOM information input interface of the ERP system to the BOM information input status.
②-3、在BOM自定义属性管理模块中构建一个BOM自定义属性名称表、一个BOM自定义属性内容表和一个自定义属性值存储表，在BOM自定义属性名称表中设置用于向ERP系统中输入PDM系统中不存在的BOM属性名称及针对不同的BOM属性名称设置的属性名称索引；在BOM自定义属性内容表中设置用于为BOM属性名称提供备选项的BOM属性内容、BOM属性内容对应的BOM属性名称的属性名称索引及针对不同的BOM属性内容设置的属性内容索引，并通过属性名称索引将BOM属性内容和BOM属性名称绑定；在自定义属性值存储表中设置物料代号、物料代号对应的BOM属性内容及与物料代号对应的BOM属性内容相对应的BOM属性名称的属性名称索引，并通过属性名称索引将物料代号和BOM属性名称绑定；然后BOM自定义属性管理模块将ERP系统需要的并存在于自定义属性管理模块中的BOM信息中的物料代号传输给BOM数据整合模块。②-3. Construct a BOM custom attribute name table, a BOM custom attribute content table and a custom attribute value storage table in the BOM custom attribute management module, and set in the BOM custom attribute name table for sending to ERP Enter the BOM attribute name that does not exist in the PDM system and the attribute name index set for different BOM attribute names in the system; set the BOM attribute content and BOM attribute used to provide alternative options for the BOM attribute name in the BOM custom attribute content table The attribute name index of the BOM attribute name corresponding to the content and the attribute content index set for different BOM attribute content, and bind the BOM attribute content and BOM attribute name through the attribute name index; set the material code in the custom attribute value storage table , the BOM attribute content corresponding to the material code and the attribute name index of the BOM attribute name corresponding to the BOM attribute content corresponding to the material code, and bind the material code and the BOM attribute name through the attribute name index; then BOM custom attribute management module Transfer the material code required by the ERP system and existing in the BOM information in the custom attribute management module to the BOM data integration module.
②-4、BOM数据整合模块从PDM系统中提取出ERP系统需要的并存在于PDM系统中的BOM信息（如表4所列，PDM系统中的BOM信息包括物料代号、物料名称、材料、数量、单重、总重和规格），然后BOM数据整合模块根据物料代号将BOM自定义属性管理模块中的BOM信息与PDM系统中的BOM信息进行整合，并将整合后的符合ERP系统格式的生产BOM信息传输给模板管理模块。在此，可将整合成的生产BOM信息转换为EXCEL格式的文件，以便于查看。②-4. The BOM data integration module extracts the BOM information required by the ERP system and exists in the PDM system from the PDM system (as listed in Table 4, the BOM information in the PDM system includes material code, material name, material, quantity, unit weight, total weight, and specifications), and then the BOM data integration module integrates the BOM information in the BOM custom attribute management module with the BOM information in the PDM system according to the material code, and integrates the production BOM that conforms to the ERP system format The information is transmitted to the template management module. Here, the integrated production BOM information can be converted into an EXCEL format file for easy viewing.
②-5、在模板管理模块中调用操作系统的Sniffer函数截取ERP系统客户端向ERP系统服务端存储数据时发送的数据包，然后模板管理模块分析截取的数据包，将数据包中的BOM信息替换为可识别的特殊字符串标记，接着模板管理模块将可识别的特殊字符串标记以模板的形式进行保存，再用审核后的生产BOM信息替换模板中的可识别的特殊字符串标记，最后模板管理模块将模板传输给BOM信息输入模块。在此，可识别的特殊字符串标记与BOM信息中的所有属性一一对应，即可识别的特殊字符串标记与BOM信息中的物料代号、属性名称、属性内容等一一对应。②-5. Call the Sniffer function of the operating system in the template management module to intercept the data packet sent by the ERP system client to the ERP system server when storing data, then the template management module analyzes the intercepted data packet, and converts the BOM information in the data packet Replace with identifiable special string tags, and then the template management module saves the identifiable special string tags in the form of templates, and then replaces the identifiable special string tags in the template with the approved production BOM information, and finally The template management module transmits the template to the BOM information input module. Here, the identifiable special string mark corresponds to all attributes in the BOM information one-to-one, that is, the identifiable special string mark corresponds to the material code, attribute name, attribute content, etc. in the BOM information.
②-6、BOM信息输入模块通过套接字模拟ERP系统客户端向ERP系统服务端发送包含有生产BOM信息的模板。②-6. The BOM information input module simulates the ERP system client to send the template containing the production BOM information to the ERP system server through the socket.
实施例四：Embodiment four:
本实施例的BOM信息传输方法为在实施例三的BOM信息传输方法的基础上，在步骤②-1中将BOM数据整合模块的输出端与PDM系统中的录入批准模块的输入端相连接，将PDM系统中的录入批准模块的输出端与模板管理模块的输入端相连接；在步骤②-4中将整合后形成的符合ERP系统格式的生产BOM信息提交至PDM系统中的录入批准模块，PDM系统中的录入批准模块对生产BOM信息进行审核，并将审核后的生产BOM信息传输给模板管理模块。在本实施例中，PDM系统中的录入批准模块的主要作用是：将BOM数据整合模块发送过来的生产BOM信息提交至PDM系统，在PDM系统中，根据预定的审批流程对生产BOM信息进行审核，审核通过之后，录入批准模块将批准的生产BOM信息发送至模板管理模块，本实施例的方法利用PDM系统中的录入批准模块对BOM数据整合模块整合成的生产BOM信息进行审核，能够进一步确保生产BOM信息的准确性。The BOM information transmission method of this embodiment is based on the BOM information transmission method of the third embodiment, in step ②-1, the output terminal of the BOM data integration module is connected with the input terminal of the input approval module in the PDM system, Connect the output terminal of the input approval module in the PDM system with the input terminal of the template management module; in step ②-4, submit the integrated production BOM information conforming to the ERP system format to the input approval module in the PDM system, The entry approval module in the PDM system reviews the production BOM information, and transmits the reviewed production BOM information to the template management module. In this embodiment, the main function of the entry approval module in the PDM system is to submit the production BOM information sent by the BOM data integration module to the PDM system, and in the PDM system, review the production BOM information according to the predetermined approval process After the review is passed, the input approval module sends the approved production BOM information to the template management module. The method of this embodiment uses the input approval module in the PDM system to review the production BOM information integrated by the BOM data integration module, which can further ensure Accuracy of production BOM information.
Claims (4)
Translated fromChinesePriority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210179642.3ACN102708213B (en) | 2012-05-31 | 2012-05-31 | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210179642.3ACN102708213B (en) | 2012-05-31 | 2012-05-31 | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102708213Atrue CN102708213A (en) | 2012-10-03 |
| CN102708213B CN102708213B (en) | 2015-04-22 |
Family
ID=46900979
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210179642.3AExpired - Fee RelatedCN102708213B (en) | 2012-05-31 | 2012-05-31 | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102708213B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103164573A (en)* | 2013-01-18 | 2013-06-19 | 浙江大丰体育设备有限公司 | Product data management (PDM) design system |
| CN104881740A (en)* | 2015-05-21 | 2015-09-02 | 广州盖特软件有限公司 | Method and device for generating multiple bills of material (BOM) of same type in ERP (Enterprise Resource Planning) via paper grid color matching |
| CN106372532A (en)* | 2016-09-05 | 2017-02-01 | 用友优普信息技术有限公司 | Open application program interface service platform as well as calling control method and device |
| CN106558105A (en)* | 2016-11-22 | 2017-04-05 | 盐城工学院 | Using method of the product Configurable BOM in virtual reality system |
| CN106950928A (en)* | 2017-02-22 | 2017-07-14 | 首钢京唐钢铁联合有限责任公司 | Cold rolling management system |
| CN107506965A (en)* | 2017-08-26 | 2017-12-22 | 泰州星云动力有限公司 | A kind of BOM manages Core Generator |
| CN109877158A (en)* | 2019-03-01 | 2019-06-14 | 武汉钢铁工程技术集团有限责任公司 | CSP continuous casting and rolling temporary steel coil number automatic matching method and system |
| CN110659866A (en)* | 2019-04-15 | 2020-01-07 | 南京依维柯汽车有限公司 | Method for releasing BOM from PDM system to ERP system |
| CN111160683A (en)* | 2019-08-09 | 2020-05-15 | 浙江中控技术股份有限公司 | Type-selecting coding decomposition method suitable for advanced manufacturing of pressure transmitter |
| CN111680337A (en)* | 2020-06-04 | 2020-09-18 | 宁波浙大联科科技有限公司 | PDM system product design requirement information acquisition method and system |
| CN111859491A (en)* | 2020-07-16 | 2020-10-30 | 宁波浙大联科科技有限公司 | Part model engineering drawing generation method and system of PDM integrated CAD system |
| CN111898165A (en)* | 2020-07-09 | 2020-11-06 | 宁波浙大联科科技有限公司 | Method and system for traceability of technical parameter changes in PDM system |
| CN112258091A (en)* | 2020-11-19 | 2021-01-22 | 中国第一汽车股份有限公司 | Data transmission method, device, equipment and storage medium |
| CN112650798A (en)* | 2019-10-11 | 2021-04-13 | 沅圣科技股份有限公司 | Data interfacing method, electronic device and storage medium |
| CN115687522A (en)* | 2022-10-29 | 2023-02-03 | 浙江睿峰电喷系统有限公司 | Method for carrying out BOM synchronization on products between Web ERP system and PDM system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030009410A1 (en)* | 2001-06-26 | 2003-01-09 | Padman Ramankutty | Collaboration bill of material |
| CN1661607A (en)* | 2004-02-23 | 2005-08-31 | 鸿富锦精密工业（深圳）有限公司 | System and method for automatic data creation |
| CN101697216A (en)* | 2009-11-06 | 2010-04-21 | 金蝶软件（中国）有限公司 | Importing method of product data management data and enterprise resource planning system |
- 2012
- 2012-05-31CNCN201210179642.3Apatent/CN102708213B/ennot_activeExpired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030009410A1 (en)* | 2001-06-26 | 2003-01-09 | Padman Ramankutty | Collaboration bill of material |
| CN1661607A (en)* | 2004-02-23 | 2005-08-31 | 鸿富锦精密工业（深圳）有限公司 | System and method for automatic data creation |
| CN101697216A (en)* | 2009-11-06 | 2010-04-21 | 金蝶软件（中国）有限公司 | Importing method of product data management data and enterprise resource planning system |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103164573B (en)* | 2013-01-18 | 2016-06-15 | 浙江大丰体育设备有限公司 | PDM managing and designing system |
| CN103164573A (en)* | 2013-01-18 | 2013-06-19 | 浙江大丰体育设备有限公司 | Product data management (PDM) design system |
| CN104881740A (en)* | 2015-05-21 | 2015-09-02 | 广州盖特软件有限公司 | Method and device for generating multiple bills of material (BOM) of same type in ERP (Enterprise Resource Planning) via paper grid color matching |
| CN104881740B (en)* | 2015-05-21 | 2018-07-13 | 广州盖特软件有限公司 | By paper lattice color matching generation with the method and device of the multiple BOM of money in ERP |
| CN106372532B (en)* | 2016-09-05 | 2019-11-15 | 用友优普信息技术有限公司 | Open application interface service platform calls control method and device |
| CN106372532A (en)* | 2016-09-05 | 2017-02-01 | 用友优普信息技术有限公司 | Open application program interface service platform as well as calling control method and device |
| CN106558105A (en)* | 2016-11-22 | 2017-04-05 | 盐城工学院 | Using method of the product Configurable BOM in virtual reality system |
| CN106558105B (en)* | 2016-11-22 | 2018-10-30 | 盐城工学院 | Application method of the product Configurable BOM in virtual reality system |
| CN106950928A (en)* | 2017-02-22 | 2017-07-14 | 首钢京唐钢铁联合有限责任公司 | Cold rolling management system |
| CN107506965A (en)* | 2017-08-26 | 2017-12-22 | 泰州星云动力有限公司 | A kind of BOM manages Core Generator |
| CN109877158A (en)* | 2019-03-01 | 2019-06-14 | 武汉钢铁工程技术集团有限责任公司 | CSP continuous casting and rolling temporary steel coil number automatic matching method and system |
| CN110659866A (en)* | 2019-04-15 | 2020-01-07 | 南京依维柯汽车有限公司 | Method for releasing BOM from PDM system to ERP system |
| CN110659866B (en)* | 2019-04-15 | 2023-09-08 | 南京依维柯汽车有限公司 | Method for releasing BOM from PDM system to ERP system |
| CN111160683A (en)* | 2019-08-09 | 2020-05-15 | 浙江中控技术股份有限公司 | Type-selecting coding decomposition method suitable for advanced manufacturing of pressure transmitter |
| CN111160683B (en)* | 2019-08-09 | 2023-11-14 | 浙江中控技术股份有限公司 | Selective coding decomposition method suitable for advanced manufacturing of pressure transmitter |
| CN112650798A (en)* | 2019-10-11 | 2021-04-13 | 沅圣科技股份有限公司 | Data interfacing method, electronic device and storage medium |
| CN111680337B (en)* | 2020-06-04 | 2021-07-06 | 宁波智讯联科科技有限公司 | PDM system product design requirement information acquisition method and system |
| CN111680337A (en)* | 2020-06-04 | 2020-09-18 | 宁波浙大联科科技有限公司 | PDM system product design requirement information acquisition method and system |
| CN111898165A (en)* | 2020-07-09 | 2020-11-06 | 宁波浙大联科科技有限公司 | Method and system for traceability of technical parameter changes in PDM system |
| CN111859491A (en)* | 2020-07-16 | 2020-10-30 | 宁波浙大联科科技有限公司 | Part model engineering drawing generation method and system of PDM integrated CAD system |
| CN111859491B (en)* | 2020-07-16 | 2023-12-12 | 宁波智讯联科科技有限公司 | Part model engineering drawing generation method and system of PDM integrated CAD system |
| CN112258091A (en)* | 2020-11-19 | 2021-01-22 | 中国第一汽车股份有限公司 | Data transmission method, device, equipment and storage medium |
| CN115687522A (en)* | 2022-10-29 | 2023-02-03 | 浙江睿峰电喷系统有限公司 | Method for carrying out BOM synchronization on products between Web ERP system and PDM system |
| CN115687522B (en)* | 2022-10-29 | 2024-05-17 | 浙江睿峰电喷系统有限公司 | Method for product BOM synchronization between Web ERP system and PDM system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102708213B (en) | 2015-04-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102708213B (en) | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system | |
| CN102298365B (en) | Method for automatically identifying and managing spaceflight measurement and control earth station device change | |
| CN104732306B (en) | Rapid development system and method for business application system | |
| CN106569801A (en) | Complex parameter-based configuration display control system | |
| CN105677875A (en) | Visual modeling platform based on unified constraint of normal data elements | |
| CN113031936B (en) | Method and system for automatically building page and immediately publishing page | |
| CN105224631B (en) | The method built the system of the open cloud of industry and work out XBRL financial statement | |
| CN105653644A (en) | Page constructor and page construction method | |
| US9628206B2 (en) | Endpoint parameter management architecture for audio mixers | |
| CN106021099A (en) | System and method for achieving UI automatic test of intelligent terminal | |
| CN107766042A (en) | A kind of visual data manager and device of the model file based on CSAR | |
| CN104102510B (en) | Integration and configuration system for IEC (international electrotechnical commission) 61850 network processor chips | |
| CN102801565B (en) | Method for carrying out centralized management on service configuration in network management system | |
| CN103592907A (en) | Network acquisition system | |
| CN110351325A (en) | A kind of data processing method and relevant device | |
| CN101299750A (en) | Method and equipment for implementing operational management | |
| CN106558105A (en) | Using method of the product Configurable BOM in virtual reality system | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN102567066B (en) | Business system development method, business system | |
| CN103593188A (en) | System and method for managing what-you-see-is-what-you-get menus of instrument | |
| CN117573200A (en) | A dynamically configurable equivalent system and process configuration method | |
| CN117742747A (en) | A method and device for presetting an experience environment on a low-code platform | |
| CN110209722A (en) | A kind of data-interface for data exchange | |
| CN116094931A (en) | Deployment method and equipment of network function virtualization infrastructure | |
| CN115687467A (en) | A linkage batch configuration method, terminal, server, electronic device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder | Address after:Room 403-405, No.5, Lane 999, Yangfan Road, high tech Zone, Ningbo City, Zhejiang Province Patentee after:Ningbo Zhixun Lianke Technology Co.,Ltd. Address before:Room 403-405, No.5, Lane 999, Yangfan Road, high tech Zone, Ningbo City, Zhejiang Province Patentee before:NINGBO ZHEDA LIANKE TECHNOLOGY Co.,Ltd. | |
| CP01 | Change in the name or title of a patent holder | ||
| CF01 | Termination of patent right due to non-payment of annual fee | Granted publication date:20150422 | |
| CF01 | Termination of patent right due to non-payment of annual fee |