Urban rail material management method based on automatic construction of PLM and BOM

By automatically building PLM codes and BOM files, the large workload and error-prone problems caused by manual operations in urban rail transit material management are solved, and management efficiency and data accuracy are improved.

CN118966963APending Publication Date: 2024-11-15ZHONGHE ZHIXING RAIL TRANSIT TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410872024.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-01
Publication Date
2024-11-15

AI Technical Summary

Technical Problem

During the management of existing urban rail transit materials, PLM coding and BOM construction rely highly on manual operations, resulting in large workloads, prone to errors, and low management efficiency.

Method used

Automatic construction method based on PLM and BOM is adopted to reduce manual intervention by determining urban rail management projects, setting PLM encoding rules, automatically generating PLM encoding and BOM files, and importing them into the IFS system.

Benefits of technology

It realizes automation of PLM coding and BOM architecture, shortens manual work cycles, reduces error rates, and improves the efficiency of material management and data standardization.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118966963A_ABST
    Figure CN118966963A_ABST
Patent Text Reader

Abstract

The invention provides an urban rail material management method automatically constructed based on PLM and BOM, and the method specifically comprises the steps: determining an urban rail management project, and constructing a material purchasing table of the urban rail management project; setting a PLM coding rule, automatically coding the material equipment recorded in the material purchasing table according to the PLM coding rule, and generating a project file and a PLM coding database file; bOM automatic establishment is carried out based on the urban rail management project and the corresponding material purchasing table, and a BOM file is generated; and importing the generated engineering file, the PLM coding database file and the BOM file into an IFS system, and carrying out material management based on the IFS system. According to the invention, PLM coding and BOM architecture construction can be automatically carried out, manual intervention in an urban rail material management process is reduced, and the management efficiency of urban rail material management is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of urban rail transit material management, and in particular to an urban rail transit material management method based on automatic construction of PLM and BOM. Background Art

[0002] The equipment selection and procurement of urban rail transit signaling is a complex urban rail material management process involving multiple links and details. Specifically, it is necessary to use the project contract documents and the minutes of the joint meeting as the decision-making basis for equipment selection and procurement, select the composition, interface, performance, function, etc. of each professional equipment based on the system configuration, complete the preparation of the bill of materials of each professional equipment, that is, the BOM (Bill of Materials) table, and then compile all the information into a large table, that is, the project procurement table, to guide the entire procurement process. The equipment procurement process usually includes the key steps of material code allocation, creation, material application, order generation, equipment in and out of the warehouse management, and financial accounting using the IFS application system. In this process, the material code, that is, the PLM (Product Lifecycle Management) code is the only basis for the IFS application system to manage the process. In order to maintain the uniqueness of the codes for different businesses, different equipment types, different manufacturers, and different models, strict safeguards need to be implemented for the setting of the PLM code. The current measure is that before creating an order in the IFS application system, professionals will check for duplicates in the existing PLM coding rule library based on information such as the equipment's profession, type and model, and manually create PLM codes for new materials to ensure the uniqueness and accuracy of the PLM codes.

[0003] In the above urban rail material management process, both the construction of BOM and the management and setting of PLM codes are highly dependent on manual operation. Staff need to extract information from the large procurement table and manually enter it into the IFS application system one by one, which is labor-intensive and error-prone. The coding rules of PLM codes usually involve combinations of ten or more digits, and the amount of data is huge. It is also easy to make mistakes when manually creating and allocating PLM codes. Summary of the invention

[0004] The purpose of the present invention is to overcome the disadvantages of manual PLM coding management and BOM construction in the prior art when managing urban rail materials, which not only has a large workload, but is also prone to errors and has low management efficiency. An urban rail material management method based on automatic construction of PLM and BOM is provided, which can automatically perform PLM coding and BOM architecture construction, and use the automatically generated PLM coding and BOM architecture to manage materials through the IFS system, thereby reducing manual intervention in the urban rail material management process and improving the management efficiency of urban rail material management.

[0005] The purpose of the present invention is achieved through the following technical solutions:

[0006] Urban rail material management method based on automatic construction of PLM and BOM, including:

[0007] Determine the urban rail management project and build the material procurement table for the urban rail management project;

[0008] Set PLM coding rules, automatically code the materials and equipment recorded in the material procurement table according to the PLM coding rules, and generate engineering files and PLM coding database files;

[0009] Automatically build BOM based on urban rail management projects and corresponding material procurement tables, and generate BOM files;

[0010] Import the generated engineering files, PLM coding database files and BOM files into the IFS system, and perform material management based on the IFS system.

[0011] Furthermore, the setting of PLM coding rules includes:

[0012] Determine the type of urban rail material and set the number of digits for coding each type of urban rail material;

[0013] Divide the number of coded bits, and set the attributes of each divided part of the number of coded bits;

[0014] Determine the attribute type of the attribute corresponding to each encoding position and assign a value to each attribute type.

[0015] Furthermore, the automatic coding of the materials and equipment recorded in the material procurement table according to the PLM coding rules includes:

[0016] Identify the content of the material procurement table and divide it into professional sub-tables in combination with the urban rail management project;

[0017] Filter out the professional sub-tables for automatic coding according to the professional types corresponding to the professional sub-tables, and obtain each material equipment in each filtered professional sub-table;

[0018] Based on the table content corresponding to each material and equipment, obtain the corresponding PLM code according to the PLM coding rules, and fill in the corresponding PLM code into the material procurement table.

[0019] Furthermore, the constructing of a material procurement table for an urban rail management project also includes constructing a material procurement table for an urban rail management project, and adjusting and amending the constructed material procurement table according to preset rules.

[0020] Furthermore, the material purchase table is adjusted and modified by preset rules, including:

[0021] Obtain the header and table page of the material procurement table, and identify the header and table page of the material procurement table;

[0022] Based on the preset rules, the header and table page names of the material procurement table are checked according to the recognition results, and the header or table page names of the material procurement table are adjusted according to the check results;

[0023] Filter out materials and equipment that have no procurement demand in the urban rail management project, match the filtered materials and equipment with the material procurement table, delete the matched corresponding table content, and sequence the remaining materials and equipment in the material procurement table;

[0024] According to the serialization results, filter out the materials and equipment corresponding to the first-level serial number, determine the corresponding equipment name and equipment description information, check the equipment name and equipment description information of each filtered material and equipment according to the material procurement form template, and adjust the equipment name or equipment description information according to the check result.

[0025] Furthermore, the automatic construction of BOM based on the urban rail management project and the material procurement table includes:

[0026] Determine the BOM architecture requirements based on the sequence results of each material and equipment in the material procurement table, and set the BOM architecture construction scope based on the urban rail management project;

[0027] According to the scope of BOM architecture, determine the hierarchical relationship of BOM architecture in combination with the sequence results of each material and equipment;

[0028] Determine the parent and child materials of the BOM based on the hierarchical relationship of the BOM structure, and automatically fill in the material information of the parent and child materials based on the material procurement table.

[0029] Furthermore, the method of determining the parent material and child material of the BOM according to the hierarchical relationship of the BOM architecture also includes judging the professional type of the child material. When judging that the child material includes at least two professional types, determining that the constructed BOM is a combined BOM, and determining the corresponding parent material, and marking the child material with the serial number and associated symbol in the material procurement table under the combined BOM column of the parent material in the BOM.

[0030] Furthermore, the automatic construction of the BOM based on the urban rail management project and the corresponding material procurement table also includes determining the professional type based on the urban rail management project, generating a top-level BOM for each profession based on the corresponding material procurement table, and setting the name of the corresponding top-level BOM according to the urban rail management project and the professional type.

[0031] The beneficial effects of the present invention are:

[0032] It can automatically perform PLM coding and BOM architecture construction, and use the automatically generated PLM coding and BOM architecture to manage materials through the IFS system, reducing manual intervention in the urban rail material management process, shortening the manual work cycle, improving personnel productivity, reducing input error rates, standardizing data management, and improving the management efficiency of urban rail material management. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 It is a schematic diagram of a process of the present invention;

[0034] Figure 2 The present invention is a schematic diagram of an application flow of an ERP tool according to an embodiment of the present invention. DETAILED DESCRIPTION

[0035] The present invention is further described below in conjunction with the accompanying drawings and embodiments.

[0036] Example:

[0037] Urban rail material management method based on automatic construction of PLM and BOM, such as Figure 1 As shown, including,

[0038] Determine the urban rail management project and build the material procurement table for the urban rail management project;

[0039] Set PLM coding rules, automatically code the materials and equipment recorded in the material procurement table according to the PLM coding rules, and generate engineering files and PLM coding database files;

[0040] Automatically build BOM based on urban rail management projects and corresponding material procurement tables, and generate BOM files;

[0041] Import the generated engineering files, PLM coding database files and BOM files into the IFS system, and perform material management based on the IFS system.

[0042] This embodiment specifically uses an ERP (Enterprise Resource Planning) tool to achieve automatic construction of PLM coding and BOM, and the ERP tool includes a test platform and a formal platform for PLM coding automation, which can achieve automatic coding of uncoded equipment and automatic construction of BOM, and generate engineering files, BOM files and PLM coding database files. This reduces the workload of manual input and duplicate checking, and improves efficiency and accuracy.

[0043] In addition to PLM automatic coding, it also includes an automatically generated PLM coding database management system that can store, manage and update equipment information, reducing manual intervention.

[0044] In addition, the ERP tool also provides a visual operation interface for the IFS system material application and BOM architecture building process, supports the automatic generation of PLM coding and BOM architecture data source files and imports them into the IFS system, replacing manual coding, duplication checking and manual entry work.

[0045] In addition, the PLM coding rules can be optimized within the ERP tool to make them more intuitive and easy to understand, reducing the workload of manual number matching.

[0046] The development of the above ERP tools is based on JAVA language and MYSAL database. The front end uses VUE framework, and the back end uses Spring to manage transactions and Hibernate components to manage the database.

[0047] Among them, the material procurement table is a large procurement table, which records the corresponding information of each material and equipment.

[0048] The setting of PLM coding rules includes:

[0049] Determine the type of urban rail material and set the number of digits for coding each type of urban rail material;

[0050] Divide the number of coded bits, and set the attributes of each divided part of the number of coded bits;

[0051] Determine the attribute type of the attribute corresponding to each encoding position and assign a value to each attribute type.

[0052] Taking the PLM coding of signal engineering equipment as an example, the coding bit number is 12 bits, and the coding bit number is divided into two-bit units. The attributes corresponding to each coding position after division are: the 1st and 2nd bits are defined as business classification, the 3rd and 4th bits are defined as category classification, the 5th and 6th bits are defined as equipment type, the 7th and 8th bits are defined as manufacturer, the 9th and 10th bits are sub-item equipment name, and the 11th and 12th bits are equipment specifications and models.

[0053] The above business categories include self-research, signal system, AFC, software and general, etc., the categories include system, interlocking, ATS, DCS, train control, axle counting and microcomputer monitoring, etc., the equipment type is large equipment, including combination cabinets, lightning protection distribution cabinets, interface cabinets, power supply panels, detection and axle counting, etc., the sub-item equipment names include racks, boards, relays, etc.

[0054] Assign a value to each attribute type included in the above attributes. When encoding, the encoding value can be determined according to the attribute type.

[0055] The automatic coding of materials and equipment recorded in the material procurement table according to the PLM coding rules includes:

[0056] Identify the content of the material procurement table and divide it into professional sub-tables in combination with the urban rail management project;

[0057] Filter out the professional sub-tables for automatic coding according to the professional types corresponding to the professional sub-tables, and obtain each material equipment in each filtered professional sub-table;

[0058] Based on the table content corresponding to each material and equipment, obtain the corresponding PLM code according to the PLM coding rules, and fill in the corresponding PLM code into the material procurement table.

[0059] The automatic construction of BOM based on urban rail management projects and material procurement tables includes:

[0060] Determine the BOM architecture requirements based on the sequence results of each material and equipment in the material procurement table, and set the BOM architecture construction scope based on the urban rail management project;

[0061] According to the scope of BOM architecture, determine the hierarchical relationship of BOM architecture in combination with the sequence results of each material and equipment;

[0062] Determine the parent and child materials of the BOM based on the hierarchical relationship of the BOM structure, and automatically fill in the material information of the parent and child materials based on the material procurement table.

[0063] Specifically, the BOM for some of the equipment can be built based on the opening of the project contract for the urban rail management project.

[0064] Taking the LEU host of the signal trackside equipment as an example, when the BOM needs to be built, select "sub-station" or "overall" in the "BOM Construction" column corresponding to the "M item" to determine the scope of the BOM architecture construction. Select "sub-station" when a BOM needs to be built for each station, and select "overall" when a BOM is built for the entire line.

[0065] When building a BOM, you need to pay attention to whether the quantity of "M item" equipment and the corresponding quantity and proportion of "S item" and "T item" equipment are correct.

[0066] When building the BOM architecture, the ERP tool also supports cross-professional linkage construction. When multiple professional sub-tables need to be associated across disciplines, the ERP tool supports custom rules. For example, for the two disciplines of train control and DCS, the BOM number of the on-board switch in the DCS professional sub-table can be associated with the CC cabinet BOM of the train control discipline as its sub-item.

[0067] The method of determining the parent material and child material of the BOM according to the hierarchical relationship of the BOM architecture also includes judging the professional type of the child material. When judging that the child material includes at least two professional types, determining that the constructed BOM is a combined BOM, and determining the corresponding parent material. Under the combined BOM column of the parent material in the BOM, the child material is marked with the serial number and associated symbol in the material procurement table.

[0068] When the BOM structure construction involves the construction of cross-row sub-components, determine that the BOM structure is a combined BOM. Under the combined BOM column of the parent item "M row" of the combined BOM, you can use "serial number 1*serial number 2*serial number 3..." for combined construction, where the * is an association symbol.

[0069] The automatic construction of BOM based on the urban rail management project and the corresponding material procurement table also includes determining the professional type based on the urban rail management project, generating a top-level BOM for each profession based on the corresponding material procurement table, and setting the name of the corresponding top-level BOM according to the urban rail management project and the professional type.

[0070] By using the top-level BOM, you can reduce the workload of BOM and sub-component approval, engineering parts maintenance, etc.

[0071] In order to support ERP tools to extract information, the compilation and construction principles of the material procurement table need to be unified. The specific compilation rules are:

[0072] (1) "PLM Code" column: The equipment code of the self-developed system does not involve the ERP tool. Add 00 to the first two digits of the coding rule to distinguish it from non-self-developed equipment. After the ERP tool automatically generates the PLM code, it will be filled back into the material procurement table;

[0073] (2) "Serial Number" column: The serial number must be accurate and unique. The same serial number cannot appear in a table. There are no blank rows in the table. Rows without serial numbered devices are filled in with a dash "—".

[0074] (3) "M / S / Blank" column: Fill in the "parent-child" construction according to the needs. If the "S / T" part of the equipment sub-item in the BOM construction is blank, the corresponding blank equipment data will not be built as a "parent item". For other sub-specialties, such as the "M / S / Blank" column in the signal interlocking specialty sub-table, when the serial number column of the "M" row is filled in with "a / b / c", the "M / S / Blank" column of the sub-equipment is filled in with "Ma / Mb / Mc" accordingly.

[0075] (4) Generate corresponding PLM codes for each specialty that requires numbering, such as basic equipment, DCS, train control, ATS and other non-self-developed equipment. The specialty sub-table corresponding to each sub-specialty must fill in the equipment name, specification model, manufacturer / origin in a standardized manner. Descriptions that cannot be extracted and identified by ERP tools must not appear. For purchased equipment, the corresponding PLM codes can continue to be maintained manually.

[0076] (5) For the same equipment materials, the procurement business processes of different sections are not universal. Different material codes need to be generated according to different sections to avoid business confusion caused by mixed material codes.

[0077] (6) Each professional sub-table in the material procurement table needs to fill in the BOM construction range information to reflect the purchase batch range, including sub-station, whole and none. According to the different filled ranges, ERP's processing operations are as follows:

[0078] a. When filling in "Sub-station": The ERP tool builds n BOMs according to the station. For those that are configured in units of trains, such as train control engineering vehicles and electric passenger cars, the number of sub-components assembled can be filled in according to the number of single cabinets.

[0079] b. When filling in "overall": the ERP tool builds a BOM according to the total "M" and "S" in the "Total Purchase (excluding spare parts and tools)" column. This BOM is universal for the entire line and has a unified configuration. Taking the transponder and ATS workstation as an example, the corresponding BOM architectures are: 1 active transponder includes 1 active transponder and 1 transponder bracket, and the ATS workstation includes 1 station, n monitors and 1 speaker. BOM construction configuration: S quantity / M quantity and the "M row" of equipment for building the BOM are required items. The header column name "Total Purchase (excluding spare parts and tools)" of each professional sub-table must be unified.

[0080] c. If "Line M" is not filled in, it means that there is no need to build a BOM for this line.

[0081] (7) For ATS and DCS professional self-developed cabinets, they are divided into server cabinets and non-server cabinets. In the "Device Description" column, add the following options:

[0082] a) Tool selection: upper cable server, lower cable server, upper cable non-server cabinet, lower cable non-server cabinet.

[0083] b) Number: It should be represented as “Project number. Professional abbreviation. 800 upper wiring”.

[0084] The PLM coding platform in the ERP tool supports each profession to extract the required codes separately. Before using the PLM coding platform to generate codes, in order to generate codes correctly, the format and content of the material procurement table need to be adjusted.

[0085] The constructing of the material procurement table for the urban rail management project also includes constructing the material procurement table for the urban rail management project, and adjusting and correcting the constructed material procurement table according to preset rules.

[0086] The adjustment and correction of the material purchase table by the preset rules includes:

[0087] Obtain the header and table page of the material procurement table, and identify the header and table page of the material procurement table;

[0088] Based on preset rules, the header and table page names of the material procurement table are checked according to the recognition results, and the header or table page names of the material procurement table are adjusted according to the checking results.

[0089] Since the site names in the material procurement table must be consistent with the names on the PLM coding platform, if there is an error in the site name in the material procurement table, the site abbreviation in the subsequently generated BOM file will be prompted as "null". In addition, the site column range in the material procurement table should include columns corresponding to all sites. If some sites are not included in the site column range, the BOM for these sites will not be successfully built when the BOM is built at the substation. Therefore, it is necessary to identify the integrity of the header naming for the site names involved in the urban rail management project, and to correct the header naming based on the identification and judgment results.

[0090] The naming of the table page consists of "prefix + suffix". The prefix should be consistent with the table prefix given on the PLM coding platform, and the suffix is ​​the version number of the current material procurement table. The prefix and suffix are connected by a hyphen "_". For example, the table page of microcomputer monitoring can be named "SYS-Microcomputer Monitoring_V1.2". The naming of each table page is identified and judged according to this rule, and the table page name is modified according to the identification and judgment results.

[0091] Filter the materials and equipment that have no procurement demand in the urban rail management project, match the filtered materials and equipment with the material procurement table, delete the matched corresponding table content, and then number the remaining materials and equipment in the material procurement table.

[0092] For equipment that is not used or does not need to be purchased in the urban rail management project, since there is no procurement demand, the corresponding rows (including hidden rows) in the material procurement table are directly deleted and then sequenced to improve the efficiency of subsequent PLM coding and BOM architecture construction.

[0093] Among them, the serialization of materials and equipment in the material procurement table specifically includes primary serial numbers and secondary serial numbers, which can be specifically performed according to the M, S and T items of the materials and equipment. Item M is the primary serial number, and items S and T are secondary serial numbers. If there are materials and equipment that do not require coding, a hyphen “-” will be used instead of the serialization.

[0094] According to the serialization results, filter out the materials and equipment corresponding to the first-level serial number, determine the corresponding equipment name and equipment description information, check the equipment name and equipment description information of each filtered material and equipment according to the material procurement form template, and adjust the equipment name or equipment description information according to the check result.

[0095] For the equipment names of item M materials and equipment, it is not allowed to have the equipment names of item M outside the material procurement form template or be inconsistent with the equipment names in the material procurement form template. The equipment of items S and T also needs to be consistent with the equipment names corresponding to the material procurement form template. The equipment description information will affect the PLM coding content. In order to avoid multiple different codes for the same equipment, for equipment of the same manufacturer and model, it is necessary to ensure that its equipment description information can be consistent with the description principles in the material procurement form template.

[0096] After completing the adjustment of the material purchase list, test it on the PLM test platform of the ERP tool with the above-mentioned PLM coding rules and BOM automatic construction process. After confirming that all generated files are correct, generate the PLM coding and coding library through the PLM formal platform. The execution steps of the test platform and the formal platform are the same.

[0097] When performing the PLM coding and coding library generation test on the PLM test platform, click to upload the material procurement table, select the name of the urban rail management project, copy the name of the table page for which the code needs to be generated from the material procurement table, select the material procurement table file, click upload, and wait for the corresponding human-machine interface to display the "Upload successful" prompt, indicating that the code and coding library have been successfully generated.

[0098] If the page reports an error, you need to check whether the uploaded project name, sub-table name, and the selected material procurement table file are correct and whether there are any format errors.

[0099] The following are some common format errors.

[0100] 1) The serial numbers are not continuous. The material purchase table contains rows that have neither numbers nor numbers replaced by "-", and it is necessary to check whether some rows that need to be deleted are hidden;

[0101] 2) The table page naming does not comply with the specification or contains spaces;

[0102] 3) It is prompted that the units of some materials do not exist in the ERP tool, and new units can be added.

[0103] For the project files, BOM files and PLM coding database files generated by the ERP tool, they should be copied or saved in the specified file save path. Do not directly drag and drop from the folder to avoid losing the files in the file address.

[0104] And all generated files are checked according to the following agreed checkpoints:

[0105] (1) Are the five files generated by each table page, namely, engineering parts in .csv and .xlsx formats, BOM files in .csv and .xlsx formats, and PLM code database files in .xlsx format, complete?

[0106] (2) The parent item in the BOM file contains the site abbreviation. Is there an incorrect site abbreviation "null"? Is the quantity relationship between the parent item and the child item correct?

[0107] (3) No new codes will be generated for the equipment that has been entered into the IFS application system. The project file only contains the newly generated codes. The PLM code database contains the PLM codes of all the materials and equipment in the table page.

[0108] After confirming that the files generated by the PLM official platform are correct, you can import the .csv engineering files and BOM files into the IFS system. In the "Execute Work Interface" of the IFS system, select the .csv engineering files or BOM files to be imported. After loading, save and start online. These part numbers are saved in the engineering parts, and then the IFS system implements urban rail material management.

[0109] With the expansion of self-developed products and project equipment of different business sectors, the ERP tool proposed in this embodiment supports expansion to adapt to new coding requirements. This automated PLM coding database can also achieve integration between various disciplines, realize seamless data flow, and ensure data consistency throughout the organization, which is easy to track and maintain.

[0110] Specifically, the application process of the ERP tool in this embodiment is as follows: Figure 2 shown.

[0111] The above-described embodiment is only a preferred solution of the present invention and does not limit the present invention in any form. There are other variations and modifications without exceeding the technical solution described in the claims.

Claims

1. The urban rail material management method based on automatic construction of PLM and BOM is characterized by: Including, determining the urban rail management project and building the material procurement table for the urban rail management project; Set PLM coding rules, automatically code the materials and equipment recorded in the material procurement table according to the PLM coding rules, and generate engineering files and PLM coding database files; Automatically build BOM based on urban rail management projects and corresponding material procurement tables, and generate BOM files; Import the generated engineering files, PLM coding database files and BOM files into the IFS system, and perform material management based on the IFS system.

2. The urban rail material management method based on automatic construction of PLM and BOM according to claim 1 is characterized in that: The setting of PLM coding rules includes: Determine the type of urban rail material and set the number of digits for coding each type of urban rail material; Divide the number of coded bits, and set the attributes of each divided part of the number of coded bits; Determine the attribute type of the attribute corresponding to each encoding position and assign a value to each attribute type.

3. The urban rail material management method based on automatic construction of PLM and BOM according to claim 2 is characterized in that: The automatic coding of materials and equipment recorded in the material procurement table according to the PLM coding rules includes: Identify the content of the material procurement table and divide it into professional sub-tables in combination with the urban rail management project; Filter out the professional sub-tables for automatic coding according to the professional types corresponding to the professional sub-tables, and obtain each material equipment in each filtered professional sub-table; Based on the table content corresponding to each material and equipment, obtain the corresponding PLM code according to the PLM coding rules, and fill in the corresponding PLM code into the material procurement table.

4. The urban rail material management method based on automatic construction of PLM and BOM according to claim 1 is characterized in that: The material procurement table for constructing the management project also includes constructing the material procurement table for the management project and adjusting and correcting the constructed material procurement table according to preset rules.

5. The urban rail material management method based on automatic construction of PLM and BOM according to claim 4 is characterized in that: The adjusting and correcting of the material purchase table according to the preset rules includes obtaining the header and table page of the material purchase table, and identifying the header and table page of the material purchase table; Based on the preset rules, the header and table page names of the material procurement table are checked according to the recognition results, and the header or table page names of the material procurement table are adjusted according to the check results; Filter the materials and equipment that have no procurement demand in the management project, match the filtered materials and equipment with the material procurement table, delete the matched corresponding table content, and then sequence the remaining materials and equipment in the material procurement table; According to the serialization results, filter out the materials and equipment corresponding to the first-level serial number, determine the corresponding equipment name and equipment description information, check the equipment name and equipment description information of each filtered material and equipment according to the material procurement form template, and adjust the equipment name or equipment description information according to the check result.

6. The urban rail material management method based on automatic construction of PLM and BOM according to claim 5 is characterized in that: The automatic BOM construction based on the urban rail management project and the material procurement table includes determining the BOM architecture construction requirements according to the sequence results of each material equipment in the material procurement table, and setting the BOM architecture construction scope according to the management project; According to the scope of BOM architecture, determine the hierarchical relationship of BOM architecture in combination with the sequence results of each material and equipment; Determine the parent and child materials of the BOM based on the hierarchical relationship of the BOM structure, and automatically fill in the material information of the parent and child materials based on the material procurement table.

7. The urban rail material management method based on automatic construction of PLM and BOM according to claim 6 is characterized in that: The method of determining the parent material and child material of the BOM according to the hierarchical relationship of the BOM architecture also includes judging the professional type of the child material. When judging that the child material includes at least two professional types, determining that the constructed BOM is a combined BOM, and determining the corresponding parent material. Under the combined BOM column of the parent material in the BOM, the child material is marked with the serial number and associated symbol in the material procurement table.

8. The urban rail material management method based on automatic construction of PLM and BOM according to claim 1 is characterized in that: The automatic construction of BOM based on the urban rail management project and the corresponding material procurement table also includes determining the professional type based on the urban rail management project, generating a top-level BOM for each profession based on the corresponding material procurement table, and setting the name of the corresponding top-level BOM according to the urban rail management project and the professional type.