A method for generating single vehicle instance data based on service bill of materials system

Abstract

The present invention provides a method for generating single-vehicle instance data based on a service bill of materials system, comprising receiving a notification of a vehicle being offline and entering the warehouse; obtaining order configuration information and an installation list from a data warehouse, and creating a single-vehicle instance service bill of materials for the current offline vehicle according to a preset comparison logic; and publishing the single-vehicle instance service bill of materials to a service bill of materials query platform. The present invention automatically creates a single-vehicle instance service bill of materials and a schematic diagram in real time based on the vehicle model service bill of materials by obtaining the actual loading data and vehicle configuration information of the single vehicle, and automatically publishes them to the query platform. Automation is achieved in aspects such as obtaining data sources, data processing, creating condition judgments, creating data comparisons, modifying schematic diagrams, and publishing data, which significantly reduces the cost of after-sales service in the aftermarket, improves the timeliness, accuracy, and completeness of aftermarket service data, and greatly improves user satisfaction.

Description

Technical Field

[0001] The present invention relates to the technical field of commercial vehicle aftermarket service data processing, and in particular to a method for generating single vehicle instance data based on a service bill of materials system. Background Art

[0002] With the rapid development of the automotive industry, after-sales service has increasingly become the focus of enterprises. Improving the accuracy, timeliness and completeness of the company's after-sales service spare parts data management, fully building the group's global digital spare parts service information system, and providing domestic and foreign customers with accurate, value-added and satisfactory full life cycle service information systems have become the key to effectively promoting the improvement of after-sales service levels and enhancing the core competitiveness of enterprises.

[0003] Currently, service data is not generated in a timely manner, and there is a lack of means to process bicycle instance data. In after-sales service, it is impossible to perform targeted analysis and display of bicycle instance data, which affects the service effect. Summary of the Invention

[0004] The present invention provides a method for generating single-vehicle instance data based on a service bill of materials system, which is used to solve the problem that in the existing after-sales service process, there is a lack of single-vehicle instance data analysis and display, which affects the service effect.

[0005] To achieve the above object, the present invention adopts the following technical solutions:

[0006] A first aspect of the present invention provides a method for generating single-vehicle instance data based on a service bill of materials system, the method comprising the following steps:

[0007] Receive notifications of vehicle offline and storage;

[0008] According to the order number in the notification, the order configuration information and installation list are obtained from the data warehouse, and a comparison table of vehicle, order and R&D model data is established;

[0009] Create a single vehicle instance service material list for the currently offline vehicle according to the preset comparison logic and the comparison table;

[0010] The service material list of the bicycle instance is issued to the service material list query platform.

[0011] Furthermore, the order configuration information includes the order number, R&D vehicle model, the name of the relevant main business unit, the name of the production unit, the order configuration and the order sub-group list.

[0012] Furthermore, the installation list includes information on actual installed components and parts of the vehicle and assembly, production replacement information, and designated supplier information.

[0013] Furthermore, the comparison table includes vehicle identification code, frame number, order number, vehicle model, basic device table number, optional table number, vehicle product name, production unit, production lock time, off-line time and engine and gearbox installation information.

[0014] Furthermore, the preset comparison logic is specifically as follows:

[0015] The basic device number and the optional device number in the vehicle model are not compared;

[0016] Compare the existence status of the key assemblies, subgroups, subcomponents and lower-level supplier parts of the engine, gearbox, driven axle and drive axle in the vehicle model and installation list respectively, and based on the existence status, perform one of the operations of removing, not processing or creating instance versions and placing them in the basic configuration table structure.

[0017] Furthermore, the process of performing an operation based on the existence state includes:

[0018] Comparing the key assemblies of the engine, gearbox, driven axle and drive axle, the key assemblies are already in the vehicle model and in the installation list, so no processing is done;

[0019] Comparing the key assemblies of the engine, gearbox, driven axle, and drive axle, a key assembly is present in the vehicle model but not in the installation list. Its superior creates an instance version and removes the assembly;

[0020] Compare the key assemblies of the engine, gearbox, driven axle and drive axle. If the key assembly is not included in the vehicle model but is included in the installation list and the service bill of materials system, create an instance version of the basic configuration table number and place the assembly in the basic configuration table structure.

[0021] Furthermore, the process of performing an operation based on the existence state includes:

[0022] Compare the sub-components under the sub-group. If the sub-components exist in the vehicle model and the installation list, no processing will be performed.

[0023] Compare the sub-components under the sub-group. If a sub-component exists in the vehicle model but not in the installation list, create an instance version for its parent sub-group and remove the sub-component.

[0024] Compare the sub-components under the sub-group. If the sub-component does not exist in the vehicle model but exists in the installed list and the service bill of material system, create an instance version of the sub-group to which it belongs and place the sub-component in the sub-group structure.

[0025] Furthermore, the process of performing an operation based on the existence state includes:

[0026] If the sub-supplier of an assembly part exists in both the vehicle model and the installation list, retain this sub-supplier and delete all other sub-suppliers of the assembly part.

[0027] If the sub-supplier parts of the assembly are not included in the vehicle model but are included in the installation list, no action will be taken;

[0028] If the sub-supplier parts of the assembly are included in the vehicle model but not in the installation list, no action will be taken.

[0029] Furthermore, before creating the single vehicle instance service material list of the currently offline vehicle, the following steps are also included:

[0030] Check whether the service material list of the first vehicle off the production line under the current order has been issued based on the order configuration information;

[0031] If not, the service material list system will send a vehicle model service material list compilation task;

[0032] If it has been issued, the service material list system will add the currently offline vehicle to the service material list queue of the single vehicle instance.

[0033] Furthermore, after creating the single vehicle instance service bill of materials for the currently offline vehicle, the method further includes:

[0034] The comparison results obtained based on the preset comparison logic are generated into a report and associated with the bill of materials of the bicycle instance service;

[0035] Based on the comparison result, the schematic diagram of the bicycle instance is modified or created according to the schematic diagram change logic.

[0036] The effects provided in the summary of the invention are only the effects of the embodiments, not all the effects of the invention. One of the above technical solutions has the following advantages or beneficial effects:

[0037] This invention obtains actual vehicle loading data and vehicle configuration information, automatically creates a single vehicle instance service bill of materials and schematic diagram in real time based on the vehicle model service bill of materials, and automatically publishes it to the query platform. This automates data source acquisition, data processing, creation condition judgment, data creation comparison, schematic modification, and data publishing, significantly reducing aftermarket service costs, improving the timeliness, accuracy, and completeness of aftermarket service data, and significantly increasing user satisfaction. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0039] Figure 1 is a schematic flow chart of an embodiment of the method of the present invention;

[0040] Figure 2 It is a topological diagram of one implementation method in the embodiment of the method of the present invention. DETAILED DESCRIPTION

[0041] In order to clearly illustrate the technical features of this solution, the present invention is described in detail below through specific implementation methods and in conjunction with the accompanying drawings. The disclosure below provides many different embodiments or examples for realizing different structures of the present invention. In order to simplify the disclosure of the present invention, the components and settings of specific examples are described below. In addition, the present invention may repeat reference numbers and / or letters in different examples. This repetition is for the purpose of simplicity and clarity and does not itself indicate the relationship between the various embodiments and / or settings discussed. It should be noted that the components illustrated in the accompanying drawings are not necessarily drawn to scale. The present invention omits descriptions of well-known components and processing technologies and processes to avoid unnecessary limitations on the present invention.

[0042] like Figure 1 As shown, an embodiment of the present invention provides a method for generating single-vehicle instance data based on a service bill of materials system, the method comprising the following steps:

[0043] Receive notifications of vehicle offline and storage;

[0044] According to the order number in the notification, the order configuration information and installation list are obtained from the data warehouse, and a comparison table of vehicle, order and R&D model data is established;

[0045] Create a single vehicle instance service material list for the currently offline vehicle according to the preset comparison logic and the comparison table;

[0046] The service material list of the bicycle instance is issued to the service material list query platform.

[0047] like Figure 2 As shown, in step S1, the production unit enters the information of vehicles entering the warehouse into the data warehouse. The service bill of materials system regularly reads vehicle entry notifications from the data warehouse and updates the entry notifications to the database table. The data warehouse contains all data such as materials and configurations.

[0048] In step S2, the service bill of materials (BOM) retrieves the vehicle's order configuration information and assembly list from the data warehouse. The service bill of materials system creates a comparison table of vehicle, order, and R&D vehicle model data. It also stores the order configuration information and incoming vehicle information from the database table, transmitted through the data warehouse interface with the service bill of materials system. The service bill of materials system retrieves the assembly list for the vehicle and assembly using an identification code.

[0049] The order configuration information includes the order number, R&D vehicle model, the name of the relevant main business unit, the name of the production unit, the order configuration and the order sub-group list.

[0050] The vehicle, order, and R&D vehicle model data comparison table includes the vehicle identification number, frame number, order number, vehicle model, basic equipment table number, option table number, vehicle product name, manufacturer, production start time, production end time, and engine and transmission installation information. The vehicle product name in this comparison table comes from the service bill of materials system, while the vehicle identification number, frame number, order number, vehicle model, basic equipment table number, option table number, manufacturer, production start time, production end time, and engine and transmission installation information all come from the data warehouse.

[0051] The installation list includes information on actual installed components and parts for the vehicle and assembly, production replacement information, and designated supplier information.

[0052] In step S3, creating a single vehicle instance service BOM instance involves three main steps: the first is ensuring that the conditions for creating the single vehicle instance service BOM instance are met; the second is modifying the vehicle model service BOM according to the comparison logic, generating a report based on the comparison results and associating it with the single vehicle instance service BOM; and the third is modifying the schematic diagram. After completing all three steps, the single vehicle instance service BOM instance can be viewed.

[0053] The condition for creating a single vehicle instance service bill of materials instance is that the service bill of materials system checks whether the service bill of materials for the first vehicle model off the production line in the order has been issued. If not, the service bill of materials system sends a vehicle model service bill of materials compilation task to the relevant responsible person. If it has been issued, the service bill of materials system adds the products belonging to the order to the common queue of the single vehicle instance service bill of materials; the service bill of materials is automatically created according to the queue at a scheduled time every day.

[0054] Modifying a schematic means that the service material system automatically changes the schematic according to the schematic change logic based on the comparison results of the service material list.

[0055] The comparison logic has the following 13 cases:

[0056] 1. The basic equipment table number and the optional equipment table number in the vehicle model are not compared.

[0057] 2. Compare the key assemblies of the engine, gearbox, driven axle and drive axle. The key assemblies are included in the vehicle model and the installation list and will not be processed.

[0058] 3. Compare the key assemblies of the engine, transmission, driven axle, and drive axle. If a key assembly is present in the vehicle model but not in the installation list, its superior creates an instance version and removes the assembly.

[0059] 4. Compare the key assemblies of the engine, gearbox, driven axle and drive axle. If a key assembly is not included in the vehicle model but is included in the installation list, the system will determine whether the assembly exists in the system. If so, it will create an instance version of the basic configuration table number and place the assembly in the basic configuration table structure.

[0060] 5. Compare the subgroups. The subgroups exist in the vehicle model and in the installation list, so no processing is done.

[0061] 6. Compare the subgroups. The subgroup exists in the vehicle model but not in the installation list. Its parent creates an instance version and removes the subgroup.

[0062] 7. Compare the subgroups. If the subgroup does not exist in the vehicle model but exists in the installation list, the system will determine whether the subgroup exists in the system. If so, it will create an instance version of the basic configuration table number and place the subgroup in the basic configuration table structure.

[0063] 8. Compare the sub-components under the sub-group. The sub-components exist in the vehicle model and in the installation list, so no processing is required.

[0064] 9. Compare the sub-components under the sub-group. The sub-component exists in the vehicle model but not in the installation list. Create an instance version for its parent sub-group and remove the sub-component.

[0065] 10. Compare the sub-components under the sub-group. If the sub-component does not exist in the vehicle model but exists in the installation list, the system will determine whether the sub-component exists in the system. If so, it will create an instance version of the sub-group to which it belongs and place the component in the sub-group structure.

[0066] 11. If the sub-supplier parts of the assembly are included in the vehicle model and the installation list, retain this supplier part and delete all other supplier parts of the assembly.

[0067] 12. If the sub-supplier parts of the assembly are not included in the vehicle model but are included in the installation list, no action will be taken.

[0068] 13. If the sub-supplier parts of the assembly are included in the vehicle model but not in the installation list, no action will be taken.

[0069] The schematic diagram is generated by converting the lightweight model. Links are established between each part in the model and the service bill of materials data of the bicycle instance. If the subordinate parts of the subgroup in the service bill of materials of the bicycle instance are modified during comparison, the subgroup status changes to the working status, triggering the service material system to pull the lightweight model of the newly added part from the data warehouse, modify the original model, and regenerate the schematic diagram to associate it with the subgroup.

[0070] Modifying a schematic means that the service material system automatically changes the schematic according to the schematic change logic based on the comparison results of the service material list.

[0071] There are four scenarios for schematic change logic:

[0072] 1. The bill of materials for the single-vehicle instance service is consistent with the bill of materials for the vehicle model service, and the schematic diagram remains unchanged.

[0073] 2. When a new part is added to the bill of materials for the bicycle instance service, the system obtains its lightweight model based on the new part number, adds it to the original model of the subgroup, and adds the drawing serial number in sequence.

[0074] 3. If there are deleted parts in the service material list of the bicycle instance, the system will delete these parts in the original model of the subgroup.

[0075] 4. If there are replaced parts in the bill of materials for the bicycle instance service, the system obtains its lightweight model based on the replaced part number, identifies the original part in the subgroup model before replacement, and assigns the original drawing serial number to the replaced part.

[0076] In step S4, the service material list system sends the compared single-vehicle instance service material list to the service material list query platform.

[0077] Although the above describes the specific embodiments of the present invention in conjunction with the accompanying drawings, it is not intended to limit the scope of protection of the present invention. Those skilled in the art should understand that various modifications or variations that can be made by those skilled in the art on the basis of the technical solution of the present invention without any creative work are still within the scope of protection of the present invention.

Claims

1. A method for generating single-vehicle instance data based on a service bill of materials system, characterized in that: The method comprises the following steps: Receive notifications of vehicle offline and storage; According to the order number in the notification, the order configuration information and installation list are obtained from the data warehouse, and a comparison table of vehicle, order and R&D model data is established; Create a single vehicle instance service material list for the currently offline vehicle according to the preset comparison logic and the comparison table; Sending the service material list of the bicycle instance to the service material list query platform; The order configuration information includes the order number, R&D vehicle model, the name of the relevant main business unit, the name of the production unit, the order configuration and the order sub-group list; The installation list includes information on actual installed components and parts for the vehicle and assembly, production replacement information, and designated supplier information; The comparison table includes vehicle identification code, frame number, order number, vehicle model, basic device table number, optional table number, vehicle product name, production unit, production lock time, production line time, engine and gearbox installation information; The comparison logic has the following 13 cases: 1) The basic device numbers and optional device numbers in the vehicle model are not compared; 2) Compare the key assemblies of the engine, gearbox, driven axle and drive axle. If the key assemblies are already in the vehicle model and in the installation list, no processing will be done; 3) Compare the key assemblies of the engine, transmission, driven axle, and drive axle. If a key assembly is present in the vehicle model but not in the installation list, its superior creates an instance version and removes the assembly; 4) Compare the key assemblies of the engine, transmission, driven axle, and drive axle. If a key assembly is not present in the vehicle model but is present in the installation list, the system determines whether the assembly exists in the system. If so, it creates an instance version of the basic configuration table number and places the assembly in the basic configuration table structure. 5) Comparing subgroups, if the subgroup exists in the vehicle model and the installation list, no processing will be done; 6) Compare the subgroups. If a subgroup exists in the vehicle model but not in the installation list, its parent creates an instance version and removes the subgroup. 7) Compare subgroups. If a subgroup does not exist in the vehicle model but exists in the installation list, the system determines whether the subgroup exists in the system. If so, it creates an instance version of the basic configuration table number and places the subgroup in the basic configuration table structure. 8) Compare the sub-components under the sub-group. If the sub-components exist in the vehicle model and in the installation list, no action will be taken. 9) Compare the sub-components under the sub-group. If a sub-component exists in the vehicle model but not in the installation list, create an instance version for its parent sub-group and remove the sub-component. 10) Compare the sub-components under the sub-group. If a sub-component does not exist in the vehicle model but exists in the installation list, the system determines whether the sub-component exists in the system. If so, it creates an instance version of the sub-group to which it belongs and places the sub-component in the sub-group structure. 11) If the lower-level supplier of an assembly part exists in the vehicle model and in the installation list, retain this supplier part and delete all other supplier parts of the assembly part; 12) If the sub-supplier parts of the assembly part are not included in the vehicle model but are included in the installation list, no action will be taken; 13) If the sub-supplier parts of the assembly are included in the vehicle model but not in the installation list, no action will be taken.

2. The method for generating single vehicle instance data based on a service bill of materials system according to claim 1 is characterized in that: The step of creating a single vehicle instance service bill of materials for the currently offline vehicle also includes the following steps: Check whether the service material list of the first vehicle off the production line under the current order has been issued based on the order configuration information; If not, the service material list system will send a vehicle model service material list compilation task; If it has been issued, the service material list system will add the currently offline vehicle to the service material list queue of the single vehicle instance.

3. The method for generating single vehicle instance data based on a service bill of materials system according to claim 1 is characterized in that: After creating a single vehicle instance service bill of materials for the currently offline vehicle, the method further includes: The comparison results obtained based on the preset comparison logic are generated into a report and associated with the bill of materials of the bicycle instance service; Based on the comparison result, the schematic diagram of the bicycle instance is modified or created according to the schematic diagram change logic.

Images