CN112396332A - Data synchronization method, device, equipment and medium based on multi-vehicle part change - Google Patents
Data synchronization method, device, equipment and medium based on multi-vehicle part change Download PDFInfo
- Publication number
- CN112396332A CN112396332A CN202011338352.XA CN202011338352A CN112396332A CN 112396332 A CN112396332 A CN 112396332A CN 202011338352 A CN202011338352 A CN 202011338352A CN 112396332 A CN112396332 A CN 112396332A
- Authority
- CN
- China
- Prior art keywords
- preset
- parts
- data
- vehicle type
- receiving number
- 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.)
- Pending
Links
- 230000008859 change Effects 0.000 title claims abstract description 79
- 238000000034 method Methods 0.000 title claims abstract description 32
- 239000000463 material Substances 0.000 claims abstract description 10
- 230000032683 aging Effects 0.000 claims abstract description 6
- 238000004590 computer program Methods 0.000 claims description 13
- 238000004364 calculation method Methods 0.000 claims description 5
- 230000001360 synchronised effect Effects 0.000 abstract description 2
- 238000007726 management method Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000013075 data extraction Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06312—Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Databases & Information Systems (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Manufacturing & Machinery (AREA)
- Computing Systems (AREA)
- General Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Primary Health Care (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a data synchronization method, a data synchronization device, computer equipment and a storage medium based on multi-vehicle type part change, wherein the method comprises the following steps: acquiring a breakpoint relation table of parts of multiple vehicle types from a data center station at preset time intervals, and dividing parts with changing relations in the breakpoint relation table into the same group; in the grouping, establishing a part change relation table according to the aging time of parts in the part bill of materials; acquiring the receiving number of each associated part in the group from a preset data middle station, and accumulating the receiving number of the associated parts according to the part change relation table to obtain the actual receiving number of the associated parts; and comparing the actual receiving number with the preset apportioned number, and if the actual receiving number reaches a preset threshold value taking the preset apportioned number as a reference, generating early warning information. The technical scheme of the invention solves the problem that the data cannot be synchronized in time after the part is changed, so that the cost is shared and early warning cannot be performed in time.
Description
Technical Field
The invention relates to the field of information processing, in particular to a data synchronization method, device, equipment and medium based on multi-vehicle type part change.
Background
In the automobile manufacturing industry, the part purchase price mainly consists of the apportionment cost, the manufacturing cost, the sales and general management cost and the profit. The calculation of the apportioned cost is complicated, and mainly includes tooling cost and engineering cost. When a buyer performs fixed-point pricing in the purchasing process, the unit price of a part comprises the tooling cost of a supplier, when the accumulated supply number of the part reaches the number agreed by the purchasing contract, the corresponding tooling cost is correspondingly reduced, the buyer needs to price the part again, and the tooling cost in the apportionment cost needs to be deducted from the new price, so that the purchasing cost of a company is reduced, and the purposes of cost reduction and efficiency improvement are achieved.
At present, an ERP (enterprise resource planning management) system has no accumulated receiving number of related parts, and a buyer mainly relies on manual statistics; however, under the conditions of numerous vehicle types and a large number of common-mode parts, a purchaser cannot quickly and accurately acquire part change relations, so that the problems that data cannot be updated timely and statistics is inaccurate are caused.
Disclosure of Invention
The embodiment of the invention provides a data synchronization method and device based on multi-vehicle type part change, computer equipment and a storage medium, and aims to solve the problem that data cannot be synchronized in time after the part change.
A data synchronization method based on multi-vehicle type part change comprises the following steps:
acquiring a breakpoint relation table of parts of multiple vehicle types from preset data at preset time intervals, and dividing parts with changing relations in the breakpoint relation table into the same group;
in the grouping, establishing a part change relation table according to the aging time of the parts in the part bill of materials;
acquiring the receiving number of each associated part in the group from the preset data middle station, and accumulating the receiving number of the associated part according to the part change relation table to obtain the actual receiving number of the associated part;
acquiring a preset apportioned quantity of the associated parts from a preset data report system according to the identification information of the associated parts;
and comparing the actual receiving number with the preset allocation number, and if the actual receiving number reaches a preset threshold value taking the preset allocation number as a reference, generating early warning information.
A data synchronization device based on multi-vehicle type part change comprises:
the related part grouping module is used for acquiring a breakpoint relation table of parts of multiple vehicle types from preset data at preset time intervals and grouping the parts with change relations in the breakpoint relation table into the same group;
the part change relation table establishing module is used for establishing a part change relation table according to the aging time of the parts in the part bill of materials in the group;
the actual receiving number calculation module is used for acquiring the receiving number of each associated part in the group from the preset data intermediate station and accumulating the receiving number of the associated part according to the part change relation table to obtain the actual receiving number of the associated part;
the apportionment cost acquisition module is used for acquiring the preset apportionment quantity of the associated parts from a preset data report system according to the identification information of the associated parts;
and the early warning module is used for comparing the actual receiving number with the preset apportioning number, and if the actual receiving number reaches a preset threshold value taking the preset apportioning number as a reference, generating early warning information.
A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the data synchronization method based on multi-vehicle part change when executing the computer program.
A computer-readable storage medium storing a computer program which, when executed by a processor, implements the steps of the above-described data synchronization method based on multi-vehicle type part change.
The data synchronization method, the data synchronization device, the computer equipment and the storage medium based on the multi-vehicle type part change group divide the multi-vehicle type part breakpoint relation table acquired from the preset data middle table into groups and establish a part change relation table, and all parts after part change under the multi-vehicle type condition are associated to form a traceable data chain; and calculating the actual receiving number of all the related parts according to the receiving number of the related parts and the part change relation table, and comparing the actual receiving number with the preset allocation number in real time to generate early warning information. The early warning information can remind a buyer to deduct the tooling cost in time, so that the actual receiving number and the apportioned cost number form an information closed loop, the working efficiency of the apportioned cost deduction link is improved, and the purposes of cost reduction and efficiency improvement are achieved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments of the present invention will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without inventive labor.
FIG. 1 is a schematic diagram of an application environment of a data synchronization method based on multi-vehicle part change according to an embodiment of the present invention;
FIG. 2 is a flow chart of a data synchronization method based on multi-vehicle part change in an embodiment of the invention;
FIG. 3 is a flowchart illustrating the actual receiving number of the common mode parts according to an embodiment of the present invention;
FIG. 4 is a flowchart illustrating the generation of a breakpoint relationship table according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a data synchronization apparatus based on multi-vehicle part change according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a computer device in an embodiment of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The data synchronization method based on the multi-vehicle type part change can be applied to the application environment shown in the figure 1.
The report system is a data analysis system and is used for connecting a data source; carrying out basic data processing; report design and manufacture; publishing, browsing, and analyzing data. In the present invention, a reporting system is used to import procurement data into the PSC site and enhance the templates of the output reports. The reporting system can acquire data from a supplier fixed-point management system (JPC system), and the JPC system is mainly used for managing tendering and bidding of suppliers and quotation.
The ERP is an enterprise resource planning management system and is used for providing original data, namely the receiving number of multi-vehicle type parts and the change records of the multi-vehicle type parts, acquired from the front end. The ERP system also includes a plurality of subsystems, such as EWO part breakpoint management subsystems and the like. Specifically, the ERP may be an SAP system.
The BS middle station is a preset data middle station and is used for extracting original data from the ERP system and forming data sources with various data formats, and the data sources are convenient for other users to subscribe the required data from the data sources.
The PSC middle station is a main carrier of a data association synchronization method for multi-vehicle type part change, a user can subscribe any data in the middle station according to actual requirements, and various data can be integrated, analyzed and report data can be output in the middle station according to designated logic.
In an embodiment, as shown in fig. 2, a data synchronization method based on multi-vehicle part change is provided, and a specific implementation flow thereof includes the following steps:
s1: and acquiring a breakpoint relation table of parts of multiple vehicle types from preset data at preset time intervals, and dividing the parts with changing relations in the breakpoint relation table into the same group.
The preset time interval may be daily or weekly, etc., and is not particularly limited. The part breakpoint relationship table relates to breakpoint management, which is a functional module in SAP systems. In the production process of the vehicle, with the continuous updating and iteration of products, each part can be changed along with the change, and the part number or the part identification number for identifying each part is changed, so that the part breakpoint refers to the change of the part number or the identification number, and the part breakpoint relation table is a data table for recording the change condition.
Specifically, data are obtained from the BS by an ETL data extraction mode, part change relations of multiple factories and multiple configurable materials are collected and grouped, and parts have change relations and are grouped into the same group.
S2: and in the grouping, establishing a part change relation table according to the aging time of the parts in the part bill of materials.
Specifically, the order within the group is assigned according to the part validation time. The sequence is explained as a parent part in the foregoing, and conversely, a child part, thereby obtaining a part change relation table.
S3: and acquiring the receiving number of each associated part in the group from a preset data intermediate station, and accumulating the receiving number of the associated parts according to the part change relation table to obtain the actual receiving number of the associated parts.
Specifically, the receiving number of a single part is obtained from the SAP, and then the receiving number of the associated part is automatically accumulated according to the part change relation to obtain the actual receiving number of the associated part. For example, if the modified relationship of part A is: a- > B- > C- > D, namely, the part A is changed from A to B, from B to C and then from C to D, and the part A is associated with the receiving number of A, the receiving number of B, the receiving number of C and the receiving number of D; the related receiving number of the part B is the sum of the receiving number of the part B, the receiving number of the part C and the receiving number of the part D; the associated number of receipts for part C, D and so on.
S4: and acquiring the preset apportioned quantity of the associated parts from a preset data report system according to the identification information of the associated parts.
The identification information of the associated part is an index of the part. The preset apportionment amount is a reference number when the apportionment cost is calculated. And acquiring a corresponding preset apportionment quantity value according to the index information of each associated part in the preset data report system.
S5: and comparing the actual receiving number with the preset apportioning number, and generating early warning information if the actual receiving number is reached.
Specifically, if the preset threshold value based on the preset apportionment amount is 90%, when the actual receiving number exceeds the preset threshold value, the early warning information is automatically given to remind a buyer to deduct the tooling cost.
In this embodiment, an information closed loop is formed between the apportioned amount and the actual receiving amount, so that the buyer can deduct the apportioned cost in the price in time, and further effectively control the purchasing cost. Meanwhile, part material account data (3000 ten thousand lines) of all relevant factories and global part change relations (198 ten thousand lines) are integrated, dynamic monitoring, early warning and deduction of purchasing cost sharing conditions are achieved, and data value assistance cost control is exerted.
Further, as shown in fig. 3, in an embodiment, when the associated part is a common-mode part, the method includes the following steps:
s11: if the related parts are common-mode parts, the receiving number of the common-mode parts common-mode with the related parts is obtained from the preset data.
The common-mode part is a general part under the same mould condition, has a special role in cost sharing, and is also a reason for causing complicated calculation. The receiving number of the parts of the same model is pre-stored in the data center station, and the PSC center can periodically acquire the receiving number from the data center station.
S12: and accumulating the receiving numbers of the same-mode parts to be used as the actual receiving number of any same-mode part.
Specifically, the actual receiving number of any one of the isomorphic parts is obtained by accumulating the receiving numbers of all the isomorphic parts.
In the embodiment, the data association and synchronization are carried out on the tool and die parts of the associated parts, so that the problem of high management complexity of the common-mode parts is solved.
Further, as shown in fig. 4, in an embodiment, the generation of the breakpoint relationship table includes the following steps:
s21: and the preset data center platform acquires the number of received multi-vehicle type parts and the change record of the multi-vehicle type parts from the preset ERP system.
Specifically, the BS center extracts the part receiving number and the multi-vehicle type part change record from the SAP system in an ETL data extraction mode.
S22: and generating a breakpoint relation table according to the receiving number of the multi-vehicle type parts and the change records of the multi-vehicle type parts according to the time sequence.
Specifically, the parts which are recorded in the change record are set as the associated parts according to the order of the effective time of the BOM parts, so that a breakpoint relation table is formed.
In this embodiment, the BS middlebox performs extraction and refinement on the original data in the SAP system, and forms a table form that is convenient for a user to read, which is beneficial to further subsequent data processing.
Further, in an embodiment, generating the warning information may specifically include generating a data report; the contents of the data report include but are not limited to part change records, part receiving data, cost allocation warning report, saved amount report, and the like.
In this embodiment, the output data report forms data by dividing the data in multiple dimensions to form different targeted visualized data, which is beneficial to analysis and processing by a decision maker.
Further, in an embodiment, the purchase data table is obtained from a preset data reporting system, and the purchase data table includes a preset apportioned quantity of the associated parts, tooling costs of the associated parts, and fixed-point pricing of the associated parts. The purchase data, namely purchase JPC data, is comprehensive data formed by the front end in the links of JPC pricing, contract making, material delivery, receiving and consumption, part recoil, financial settlement and the like. By acquiring the JPC data, the associated receiving number of multiple factories and multiple configurable materials can be calculated more accurately, and the application scene and the expansibility of the data association synchronization method are further improved.
It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.
In one embodiment, a data synchronization device based on multi-vehicle part change is provided, and the data synchronization device based on multi-vehicle part change is in one-to-one correspondence with the data synchronization method based on multi-vehicle part change in the above embodiment. As shown in fig. 5, the related parts grouping module 51, the parts change relation table creating module 52, the actual delivery number calculating module 53, the apportioned cost obtaining module 54, the early warning module 55, the data obtaining module 56, the breakpoint relation table generating module 57, and the report generating module 58 of the product data.
For specific limitation of the data synchronization device based on multi-vehicle type part change, reference may be made to the above limitation on the data synchronization method based on multi-vehicle type part change, and details are not repeated here. The modules in the data synchronization device based on the multi-vehicle part change can be wholly or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, as shown in fig. 6, a computer device is provided, which includes a memory, a processor and a computer program stored on the memory and executable on the processor, and the processor executes the computer program to implement the steps of the data synchronization method based on the multi-vehicle type part change in the above embodiments, such as the steps S1 to S5 shown in fig. 2. Alternatively, the processor implements the functions of the modules/units of the data synchronization device based on the multi-vehicle type part change in the above embodiment, for example, the functions of the modules 51 to 55 shown in fig. 5, when executing the computer program. To avoid repetition, further description is omitted here.
In an embodiment, a computer readable storage medium is provided, on which a computer program is stored, the computer program when executed by a processor implementing the data synchronization method based on the multi-vehicle type part change in the above method embodiment, or the computer program when executed by the processor implementing the functions of each module/unit in the data synchronization apparatus based on the multi-vehicle type part change in the above apparatus embodiment. To avoid repetition, further description is omitted here.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (10)
1. A data synchronization method based on multi-vehicle type part change is characterized by comprising the following steps:
acquiring a breakpoint relation table of parts of multiple vehicle types from preset data at preset time intervals, and dividing parts with changing relations in the breakpoint relation table into the same group;
in the grouping, establishing a part change relation table according to the aging time of the parts in the part bill of materials;
acquiring the receiving number of each associated part in the group from the preset data middle station, and accumulating the receiving number of the associated part according to the part change relation table to obtain the actual receiving number of the associated part;
acquiring a preset apportioned quantity of the associated parts from a preset data report system according to the identification information of the associated parts;
and comparing the actual receiving number with the preset allocation number, and if the actual receiving number reaches a preset threshold value taking the preset allocation number as a reference, generating early warning information.
2. The data synchronization method based on multi-vehicle type part change as claimed in claim 1, further comprising, after the obtaining the preset apportioned amount of the associated part from a preset data reporting system according to the identification information of the associated part, and before the comparing the actual receiving amount with the preset apportioned amount:
if the related parts are common-mode parts, acquiring the receiving number of the common-mode parts which are common-mode with the related parts from the preset data;
and accumulating the receiving numbers of the same-mode parts to be used as the actual receiving number of any same-mode part.
3. The data synchronization method based on multi-vehicle type part change as claimed in claim 1, further comprising, before the obtaining the breakpoint relation table of multi-vehicle type parts from the preset data at the preset time interval:
the preset data center platform acquires the number of received multi-vehicle type parts and the change record of the multi-vehicle type parts from a preset ERP system;
and generating the breakpoint relation table by the receiving number of the multi-vehicle type parts and the change record of the multi-vehicle type parts according to the time sequence.
4. The multi-vehicle type part change-based data synchronization method as claimed in claim 1, wherein the generating of the warning information comprises:
and generating a data report, wherein the data report comprises a part change record, part receiving data, a cost allocation early warning report and a money saving report.
5. The data synchronization method based on multi-vehicle type part change as claimed in claim 1, wherein the obtaining of the preset apportioned amount of the associated parts from a preset data reporting system comprises:
and acquiring a purchase data table from the preset data report system, wherein the purchase data table comprises the preset apportioned quantity of the associated parts, the tooling cost of the associated parts and the fixed-point pricing of the associated parts.
6. A data synchronization device based on multi-vehicle type part change is characterized in that the data synchronization device based on multi-vehicle type part change comprises:
the related part grouping module is used for acquiring a breakpoint relation table of parts of multiple vehicle types from preset data at preset time intervals and grouping the parts with change relations in the breakpoint relation table into the same group;
the part change relation table establishing module is used for establishing a part change relation table according to the aging time of the parts in the part bill of materials in the group;
the actual receiving number calculation module is used for acquiring the receiving number of each associated part in the group from the preset data intermediate station and accumulating the receiving number of the associated part according to the part change relation table to obtain the actual receiving number of the associated part;
the apportionment cost acquisition module is used for acquiring the preset apportionment quantity of the associated parts from a preset data report system according to the identification information of the associated parts;
and the early warning module is used for comparing the actual receiving number with the preset apportioning number, and if the actual receiving number reaches a preset threshold value taking the preset apportioning number as a reference, generating early warning information.
7. The multi-vehicle part change based data synchronization device as claimed in claim 6, wherein the receiving module comprises:
the data acquisition module is used for acquiring the receiving number of the parts of the multiple vehicle types and the change records of the parts of the multiple vehicle types from a preset ERP system in the preset data;
and the breakpoint relation table generating module is used for generating the breakpoint relation table according to the receiving number of the multi-vehicle type parts and the change record of the multi-vehicle type parts according to the time sequence.
8. The multi-vehicle type part change-based data synchronization device as claimed in claim 6, wherein the amount calculation module comprises:
and the report generation module is used for generating a data report, wherein the data report comprises a part change record, part receiving data, a cost allocation early warning report and a money saving report.
9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor when executing the computer program implements the steps of the multi-vehicle type part change based data synchronization method according to any one of claims 1 to 5.
10. A computer-readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the steps of the data synchronization method based on the multi-vehicle type part change according to any one of claims 1 to 5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011338352.XA CN112396332A (en) | 2020-11-25 | 2020-11-25 | Data synchronization method, device, equipment and medium based on multi-vehicle part change |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011338352.XA CN112396332A (en) | 2020-11-25 | 2020-11-25 | Data synchronization method, device, equipment and medium based on multi-vehicle part change |
Publications (1)
Publication Number | Publication Date |
---|---|
CN112396332A true CN112396332A (en) | 2021-02-23 |
Family
ID=74607227
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011338352.XA Pending CN112396332A (en) | 2020-11-25 | 2020-11-25 | Data synchronization method, device, equipment and medium based on multi-vehicle part change |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112396332A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113590669A (en) * | 2021-07-29 | 2021-11-02 | 奇瑞汽车股份有限公司 | Cost report generation method and device and computer storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2005346530A (en) * | 2004-06-04 | 2005-12-15 | Shimadzu Corp | Part list information sharing system |
CN108874644A (en) * | 2018-06-06 | 2018-11-23 | 平安科技(深圳)有限公司 | Data monitoring method, device, computer equipment and storage medium |
CN110659866A (en) * | 2019-04-15 | 2020-01-07 | 南京依维柯汽车有限公司 | Method for releasing BOM from PDM system to ERP system |
CN111752944A (en) * | 2020-05-27 | 2020-10-09 | 中国平安财产保险股份有限公司 | Data allocation method and device, computer equipment and storage medium |
-
2020
- 2020-11-25 CN CN202011338352.XA patent/CN112396332A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2005346530A (en) * | 2004-06-04 | 2005-12-15 | Shimadzu Corp | Part list information sharing system |
CN108874644A (en) * | 2018-06-06 | 2018-11-23 | 平安科技(深圳)有限公司 | Data monitoring method, device, computer equipment and storage medium |
WO2019232832A1 (en) * | 2018-06-06 | 2019-12-12 | 平安科技(深圳)有限公司 | Data monitoring method and device, computer device, and storage medium |
CN110659866A (en) * | 2019-04-15 | 2020-01-07 | 南京依维柯汽车有限公司 | Method for releasing BOM from PDM system to ERP system |
CN111752944A (en) * | 2020-05-27 | 2020-10-09 | 中国平安财产保险股份有限公司 | Data allocation method and device, computer equipment and storage medium |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113590669A (en) * | 2021-07-29 | 2021-11-02 | 奇瑞汽车股份有限公司 | Cost report generation method and device and computer storage medium |
CN113590669B (en) * | 2021-07-29 | 2024-03-29 | 奇瑞汽车股份有限公司 | Method and device for generating cost report forms and computer storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN113344338B (en) | Production scheduling method, system, equipment, medium and production scheduling management platform | |
Malik et al. | Impact of ABC information on product mix and costing decisions | |
CN115438912B (en) | Comprehensive management method and system for carbon emission information data of industrial purchasing supply chain | |
CN104599020A (en) | Store business management system | |
CN112100264A (en) | Power project contract monitoring system and method | |
CN109658154B (en) | Order prediction method based on regional trade data analysis | |
CN112396332A (en) | Data synchronization method, device, equipment and medium based on multi-vehicle part change | |
CN114372823A (en) | Enterprise supply chain management method | |
CN104599133A (en) | Store business management method | |
CN117332978A (en) | Logistics management method based on SCM management system | |
US20180322585A1 (en) | Management support device and management support method | |
CN116383592A (en) | Real-time computing and analyzing system and method based on Amazon finance | |
CN115481938A (en) | Regional electronic commerce development level evaluation method and system | |
Prasnowo et al. | Designing odoo’s enterprise resource planning (ERP) in micro, small and medium enterprises (MSMEs) | |
CN114819640A (en) | Automatic scheduling processing system for production management in precision casting industry | |
CN114936741A (en) | Project management system for non-standard manufacturing industry | |
CN113962581A (en) | Industrial chain factory capacity assessment method and system based on big data | |
CN114328491A (en) | Data processing method and device | |
CN113139835A (en) | Data processing method, data processing device, nonvolatile storage medium and processor | |
CN115034645B (en) | Production plan feasibility judging method, system, electronic equipment and storage medium | |
CN111126722A (en) | WeChat small program based commodity checking method | |
Chen | The impact of RFID on the supply chain based on EOQ models | |
CN109816400A (en) | A kind of product quality system for tracing and managing | |
CN112819441B (en) | Enterprise management method and system based on big data | |
CN115204787A (en) | Sock order information arrangement equipment for e-commerce platform |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |