Intelligent checking method and device for device account card data

By collecting and verifying ledger and asset data in the equipment database, a consistency analysis page is generated, which solves the problem of inconsistency between equipment ledgers and fixed asset cards, improves information consistency and synchronization rate, and reduces asset loss.

CN115578048BActive Publication Date: 2026-02-10SHENZHEN COMTOP INFORMATION TECH
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202211094165.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-09-08
Publication Date
2026-02-10
Estimated Expiration
2042-09-08

AI Technical Summary

Technical Problem

The low consistency between equipment information in equipment ledgers and fixed asset cards leads to a low rate of data maintenance and information change synchronization, increasing the cost of asset loss.

Method used

Collect ledger and asset data from the equipment database, verify the consistency of ledgers and cards for each production device, generate a ledger and card consistency analysis page, and display abnormal data so that users can make corrections.

Benefits of technology

It improved the consistency of equipment information in equipment ledgers and fixed asset cards, reduced the cost of asset losses caused by inconsistencies, and increased the synchronization rate of data maintenance and information changes.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115578048B_ABST
    Figure CN115578048B_ABST
Patent Text Reader

Abstract

The application discloses a kind of intelligent verification method and device of equipment account card data, comprising: collecting the account data and asset data of one or more production equipment in the equipment database that meets equipment statistical condition;Verify the account data and asset data of each production equipment, obtain the account card verification result corresponding to the production equipment;Analysis the account card verification result corresponding to each production equipment, obtain the account card consistency data corresponding to the device set consisting of all production equipment;Based on account card consistency data, generate the account card consistency analysis page corresponding to the device set.It can be seen that, by verifying and analyzing account data and asset data, the account card consistency data is obtained to generate the account card consistency page, which improves the efficiency of account card data verification and the update maintenance synchronization rate of account data and asset data, and reduces the isolation between the storage systems of account data and asset data, thereby improving the consistency of information in equipment account and fixed asset card.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of data verification technology, and in particular to an intelligent verification method and apparatus for device account data. Background Technology

[0002] In practice, to effectively manage production equipment, companies typically need to input equipment information into their storage systems. This includes entering technical parameters into equipment ledgers and purchase value parameters into fixed asset cards. Often, technical and purchase value parameters share core data types. Currently, these parameters are manually entered by staff into the ledgers and fixed asset cards, respectively. This leads to low consistency between the two sets of information. Furthermore, due to the isolation between storage systems, staff must maintain the equipment information separately in both ledgers and fixed asset cards. This results in a low synchronization rate when equipment information changes, further reducing consistency. Therefore, improving the consistency of equipment information between the ledgers and fixed asset cards is crucial. Summary of the Invention

[0003] The technical problem to be solved by the present invention is to provide an intelligent verification method and device for equipment account card data, which can improve the efficiency of account card data verification and thus improve the consistency of equipment information in equipment ledgers and fixed asset cards.

[0004] To address the aforementioned technical problems, the first aspect of this invention discloses an intelligent verification method for device account card data, the method comprising:

[0005] Collect ledger and asset data of one or more production equipment that meet the equipment statistics criteria from the equipment database;

[0006] For each of the aforementioned production equipment, verify the ledger data and asset data of that production equipment to obtain the corresponding account verification result;

[0007] Analyze the account card verification results corresponding to each of the production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all the production equipment.

[0008] Based on the account card consistency data, an account card consistency analysis page corresponding to the device set is generated. The account card consistency analysis page is used to display the account card consistency data to the user so that the user can correct abnormal data in the device database.

[0009] As an optional implementation, in the first aspect of the present invention, for each of the production devices, verifying the ledger data and asset data of that production device to obtain the corresponding account verification result includes:

[0010] Determine whether at least one piece of data in the ledger data and asset data of the production equipment is empty;

[0011] When it is determined that at least one data point in the ledger data and asset data of the production equipment is empty, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0012] When it is determined that neither the ledger data nor the asset data of the production equipment is empty, it is determined whether the basic equipment information corresponding to the ledger data of the production equipment matches the basic equipment information corresponding to the asset data of the production equipment. The basic equipment information includes equipment status and / or equipment identifier.

[0013] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment does not match the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0014] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the second type of verification result.

[0015] As an optional implementation, in the first aspect of the present invention, for each of the production devices, when it is determined that the basic equipment information corresponding to the ledger data of the production device matches the basic equipment information corresponding to the asset data of the production device, before determining that the account verification result corresponding to the production device is the second type of verification result, the method further includes:

[0016] Based on one or more predetermined data types, determine the core parameters of the ledger corresponding to each data type in the ledger data of the production equipment and the core parameters of the assets corresponding to each data type in the asset data of the production equipment;

[0017] Determine whether a target data type exists among all the data types, wherein the ledger core parameters corresponding to the target data type and the asset core parameters corresponding to the target data type do not match;

[0018] When it is determined that the target data type exists among all the data types, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0019] When it is determined that the target data type does not exist among all the data types, the operation of determining that the account card verification result corresponding to the production equipment is the second type of verification result is triggered.

[0020] As an optional implementation, in the first aspect of the present invention, before generating the account / card consistency analysis page corresponding to the device set based on the account / card consistency data, the method further includes:

[0021] Collect historical account consistency data within the target time period from the device database;

[0022] By analyzing the account card consistency data and the historical account card consistency data, the changed account card consistency data corresponding to the device set is obtained;

[0023] The step of generating an account-card consistency analysis page corresponding to the device set based on the account-card consistency data includes:

[0024] Based on the account card consistency data and / or the changed account card consistency data, determine one or more statistical dimensions that match the device set;

[0025] Based on all the statistical dimensions and account card analysis data, at least one data statistical chart and detailed data corresponding to each data statistical chart are generated. The account card analysis data includes the account card consistency data and / or the changed account card consistency data.

[0026] Based on each of the data statistics charts and the detailed data corresponding to the data statistics charts, an account card consistency analysis page corresponding to the device set is generated.

[0027] As an optional implementation, in the first aspect of the present invention, the inconsistency types corresponding to the account-card consistency data and the historical account-card consistency data include one or more of the following: account without card, card without account, basic information inconsistency, core parameter inconsistency, and cumulative inconsistency type. The cumulative inconsistency type includes the account without card, the card without account, the basic information inconsistency, and the core parameter inconsistency.

[0028] And, for each type of inconsistency, the analysis of the account card consistency data and the historical account card consistency data to obtain the changed account card consistency data corresponding to the device set includes:

[0029] Based on the number of devices in the current period corresponding to the inconsistency type in the account card consistency data ∑ W Y and the number of devices in the previous period corresponding to this inconsistency type in the historical account consistency data ∑ W-1Y determines the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, and the year-on-year change in the number of new devices added in the current period F, corresponding to the inconsistency type. Here, the number of devices cleared in the current period ∑C includes the number of all devices present in the previous period's devices but not present in the current period's devices corresponding to the inconsistency type; the number of devices left over from the previous period ∑Q includes the number of all devices present in both the previous period's devices and the current period's devices corresponding to the inconsistency type; and...

[0030] ΔY=∑ W Y-∑ W-1 Y, F = (∑ W Y-∑ W-1 Y)÷∑ W Y;

[0031] Based on the number of newly added devices in the current period ΔY and the number of newly added devices in the previous period corresponding to the inconsistency type Δ′Y in the historical account consistency data, determine the unit percentage K of the number of newly added devices in the current period corresponding to the inconsistency type:

[0032] K = (ΔY - Δ′Y) ÷ ΔY;

[0033] One or more of the following are determined as the change account consistency data of the device set based on the inconsistency type: the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, the year-on-year change in the number of new devices added in the current period F, and the percentage of new devices added in the current period K.

[0034] As an optional implementation, in the first aspect of the present invention, generating at least one data statistical chart and detailed data corresponding to each data statistical chart based on all the statistical dimensions and account card analysis data includes:

[0035] Based on the dimension attributes corresponding to all the statistical dimensions, determine at least one dimension set consisting of at least one statistical dimension, a comprehensive dimension attribute corresponding to each dimension set, and a set type corresponding to each dimension set; wherein, the set type corresponding to each dimension set includes a first type or a second type, each dimension set of the first type includes only one statistical dimension, and each dimension set of the second type includes the central statistical dimension corresponding to the dimension set and at least one associated statistical dimension matching the central statistical dimension;

[0036] Based on the comprehensive dimension attribute corresponding to each dimension set and the set type corresponding to that dimension set, determine the chart type corresponding to that dimension set;

[0037] For each dimension set, based on the comprehensive dimension attributes corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data, a data statistics chart corresponding to the dimension set and detailed data corresponding to the data statistics chart are generated.

[0038] As an optional implementation, in the first aspect of the present invention, for each dimension set, when the set type corresponding to the dimension set is the first type, generating a data statistics chart and detailed data corresponding to the data statistics chart based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data includes:

[0039] Based on the dimensional attributes of the statistical dimensions in the dimension set and the account card analysis data, the one-dimensional distribution data corresponding to the first type of dimension set is determined. The one-dimensional distribution data corresponding to the dimension set includes the distribution data of the account card analysis data on the statistical dimensions of the dimension set.

[0040] Import the one-dimensional distribution data corresponding to the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0041] As an optional implementation, in the first aspect of the present invention, for each dimension set, when the set type corresponding to the dimension set is the second type, generating a data statistics chart and detailed data corresponding to the data statistics chart based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data includes:

[0042] Based on the dimensional attributes of the central statistical dimension of the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the dimension set. The one-dimensional distribution data corresponding to the dimension set includes the distribution data of the account card analysis data on the central statistical dimension of the dimension set.

[0043] Based on the one-dimensional distribution data corresponding to the dimension set and the dimension attributes of each associated statistical dimension in the dimension set, determine the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set. The two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set includes the distribution data of the one-dimensional distribution data corresponding to the dimension set on the associated statistical dimension.

[0044] Import the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0045] As an optional implementation, in the first aspect of the present invention, the method further includes:

[0046] When a purchase order related instruction corresponding to a new production equipment is detected, a target equipment identifier corresponding to the new production equipment is generated based on the purchase order related instruction;

[0047] Collect the purchase value parameters associated with the order contract for the new production equipment and the equipment technical parameters associated with the order contract;

[0048] Based on the unified data model of the equipment database and the target equipment identifier, the procurement value parameters and the equipment technical parameters are stored in the equipment database;

[0049] When a material installation instruction corresponding to the new production equipment is detected, based on the unified data model, the procurement value parameters and the target equipment identifier are imported into the equipment ledger corresponding to the equipment database to obtain the target ledger data of the new production equipment; and based on the unified data model, the equipment technical parameters and the target equipment identifier are imported into the fixed asset card corresponding to the equipment database to obtain the target asset data of the new production equipment.

[0050] A second aspect of the present invention discloses an intelligent verification device for device account card data, the device comprising:

[0051] The data acquisition module is used to collect ledger data and asset data of one or more production equipment that meet the statistical conditions of the equipment from the equipment database.

[0052] The verification module is used to verify the ledger data and asset data of each production equipment to obtain the account card verification result corresponding to the production equipment.

[0053] The analysis module is used to analyze the account card verification results corresponding to each of the production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all the production equipment.

[0054] The generation module is used to generate an account consistency analysis page corresponding to the device set based on the account consistency data. The account consistency analysis page is used to display the account consistency data to the user so that the user can correct abnormal data in the device database.

[0055] As an optional implementation, in the second aspect of the present invention, for each of the production devices, the verification module verifies the ledger data and asset data of that production device to obtain the corresponding account verification result, specifically in the following ways:

[0056] Determine whether at least one piece of data in the ledger data and asset data of the production equipment is empty;

[0057] When it is determined that at least one data point in the ledger data and asset data of the production equipment is empty, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0058] When it is determined that neither the ledger data nor the asset data of the production equipment is empty, it is determined whether the basic equipment information corresponding to the ledger data of the production equipment matches the basic equipment information corresponding to the asset data of the production equipment. The basic equipment information includes equipment status and / or equipment identifier.

[0059] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment does not match the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0060] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the second type of verification result.

[0061] As an optional implementation, in the second aspect of the present invention, the verification module is further configured to, for each of the production devices, when it is determined that the basic equipment information corresponding to the ledger data of the production device matches the basic equipment information corresponding to the asset data of the production device, before determining that the account verification result corresponding to the production device is the second type of verification result, determine the ledger core parameters corresponding to each data type in the ledger data of the production device and the asset core parameters corresponding to each data type in the asset data of the production device based on one or more pre-determined data types; determine whether a target data type exists among all the data types, wherein the ledger core parameters corresponding to the target data type and the asset core parameters corresponding to the target data type do not match; when it is determined that the target data type exists among all the data types, determine that the account verification result corresponding to the production device is the first type of verification result; when it is determined that the target data type does not exist among all the data types, trigger the execution of the operation of determining that the account verification result corresponding to the production device is the second type of verification result.

[0062] As an optional implementation, in a second aspect of the present invention, the acquisition module is further configured to acquire historical account consistency data within a target time period in the device database before the generation module generates the account consistency analysis page corresponding to the device set based on the account consistency data;

[0063] The analysis module is also used to analyze the account card consistency data and the historical account card consistency data to obtain the changed account card consistency data corresponding to the device set;

[0064] Furthermore, the specific method by which the generation module generates the account / card consistency analysis page corresponding to the device set based on the account / card consistency data includes:

[0065] Based on the account card consistency data and / or the changed account card consistency data, determine one or more statistical dimensions that match the device set;

[0066] Based on all the statistical dimensions and account card analysis data, at least one data statistical chart and detailed data corresponding to each data statistical chart are generated. The account card analysis data includes the account card consistency data and / or the changed account card consistency data.

[0067] Based on each of the data statistics charts and the detailed data corresponding to the data statistics charts, an account card consistency analysis page corresponding to the device set is generated.

[0068] As an optional implementation, in the second aspect of the present invention, the inconsistency types corresponding to the account-card consistency data and the historical account-card consistency data include one or more of the following: account without card, card without account, basic information inconsistency, core parameter inconsistency, and cumulative inconsistency type. The cumulative inconsistency type includes the account without card, the card without account, the basic information inconsistency, and the core parameter inconsistency.

[0069] Furthermore, for each type of inconsistency, the analysis module analyzes the account card consistency data and the historical account card consistency data to obtain the changed account card consistency data corresponding to the device set in the following specific ways:

[0070] Based on the number of devices in the current period corresponding to the inconsistency type in the account card consistency data ∑ W Y and the number of devices in the previous period corresponding to this inconsistency type in the historical account consistency data ∑ W-1 Y determines the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, and the year-on-year change in the number of new devices added in the current period F, corresponding to the inconsistency type. Here, the number of devices cleared in the current period ∑C includes the number of all devices present in the previous period's devices but not present in the current period's devices corresponding to the inconsistency type; the number of devices left over from the previous period ∑Q includes the number of all devices present in both the previous period's devices and the current period's devices corresponding to the inconsistency type; and...

[0071] ΔY=∑ W Y-∑ W-1 Y, F = (∑ W Y-∑ W-1 Y)÷∑ W Y;

[0072] Based on the number of newly added devices in the current period ΔY and the number of newly added devices in the previous period corresponding to the inconsistency type Δ′Y in the historical account consistency data, determine the unit percentage K of the number of newly added devices in the current period corresponding to the inconsistency type:

[0073] K = (ΔY - Δ′Y) ÷ ΔY;

[0074] One or more of the following are determined as the change account consistency data of the device set based on the inconsistency type: the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, the year-on-year change in the number of new devices added in the current period F, and the percentage of new devices added in the current period K.

[0075] As an optional implementation, in the second aspect of the present invention, the specific method by which the generation module generates at least one data statistical chart and detailed data corresponding to each data statistical chart based on all the statistical dimensions and account card analysis data includes:

[0076] Based on the dimension attributes corresponding to all the statistical dimensions, determine at least one dimension set consisting of at least one statistical dimension, a comprehensive dimension attribute corresponding to each dimension set, and a set type corresponding to each dimension set; wherein, the set type corresponding to each dimension set includes a first type or a second type, each dimension set of the first type includes only one statistical dimension, and each dimension set of the second type includes the central statistical dimension corresponding to the dimension set and at least one associated statistical dimension matching the central statistical dimension;

[0077] Based on the comprehensive dimension attribute corresponding to each dimension set and the set type corresponding to that dimension set, determine the chart type corresponding to that dimension set;

[0078] For each dimension set, based on the comprehensive dimension attributes corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data, a data statistics chart corresponding to the dimension set and detailed data corresponding to the data statistics chart are generated.

[0079] As an optional implementation, in the second aspect of the present invention, for each dimension set, when the set type corresponding to the dimension set is the first type, the specific method by which the generation module generates the data statistical chart corresponding to the dimension set and the detailed data corresponding to the data statistical chart based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data includes:

[0080] Based on the dimensional attributes of the statistical dimensions in the dimension set and the account card analysis data, the one-dimensional distribution data corresponding to the first type of dimension set is determined. The one-dimensional distribution data corresponding to the dimension set includes the distribution data of the account card analysis data on the statistical dimensions of the dimension set.

[0081] Import the one-dimensional distribution data corresponding to the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0082] As an optional implementation, in the second aspect of the present invention, for each dimension set, when the set type corresponding to the dimension set is the second type, the specific method by which the generation module generates the data statistical chart corresponding to the dimension set and the detailed data corresponding to the data statistical chart based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data includes:

[0083] Based on the dimensional attributes of the central statistical dimension of the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the dimension set. The one-dimensional distribution data corresponding to the dimension set includes the distribution data of the account card analysis data on the central statistical dimension of the dimension set.

[0084] Based on the one-dimensional distribution data corresponding to the dimension set and the dimension attributes of each associated statistical dimension in the dimension set, determine the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set. The two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set includes the distribution data of the one-dimensional distribution data corresponding to the dimension set on the associated statistical dimension.

[0085] Import the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0086] As an optional implementation, in a second aspect of the present invention, the generation module is further configured to generate a target equipment identifier corresponding to the new production equipment based on the purchase order related instructions when a purchase order related instructions corresponding to the new production equipment are detected;

[0087] The acquisition module is also used to acquire the purchase value parameters associated with the order contract for the new production equipment and the equipment technical parameters associated with the order contract;

[0088] The device further includes:

[0089] A storage module is used to store the procurement value parameters and the equipment technical parameters into the equipment database based on the unified data model of the equipment database and the target equipment identifier;

[0090] The import module is used to, when a material installation instruction corresponding to the new production equipment is detected, import the procurement value parameters and the target equipment identifier into the equipment ledger corresponding to the equipment database based on the unified data model to obtain the target ledger data of the new production equipment; and import the equipment technical parameters and the target equipment identifier into the fixed asset card corresponding to the equipment database based on the unified data model to obtain the target asset data of the new production equipment.

[0091] A third aspect of the present invention discloses another intelligent verification device for device account card data, the device comprising:

[0092] Memory containing executable program code;

[0093] A processor coupled to the memory;

[0094] The processor calls the executable program code stored in the memory to execute the intelligent verification method for device account data disclosed in the first aspect of the present invention.

[0095] The fourth aspect of the present invention discloses a computer storage medium storing computer instructions, which, when invoked, are used to execute the intelligent verification method for device account data disclosed in the first aspect of the present invention.

[0096] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0097] In this embodiment of the invention, ledger data and asset data of one or more production equipment that meet the statistical conditions of the equipment are collected from the equipment database; for each production equipment, the ledger data and asset data of that production equipment are verified to obtain the corresponding account verification result; the account verification result of each production equipment is analyzed to obtain the account consistency data corresponding to the equipment set composed of all production equipment; based on the account consistency data, an account consistency analysis page corresponding to the equipment set is generated, which is used to display the account consistency data to the user so that the user can correct the abnormal data in the equipment database. As can be seen, implementing this invention can improve the efficiency of account card data verification by collecting and verifying the unified ledger data and asset data stored in the equipment database, and thereby analyzing the account card consistency data. This reduces the isolation between the storage systems of ledger data and asset data, and improves the consistency of equipment information in the equipment ledger and fixed asset cards. In addition, generating an account card consistency page based on the account card consistency data allows users to correct abnormal data in a timely manner, which can improve the data maintenance and information change synchronization rate of ledger data and asset data, further improve the consistency of equipment information in the equipment ledger and fixed asset cards, and reduce the asset loss cost caused by inconsistencies in equipment information in the equipment ledger and fixed asset cards. Attached Figure Description

[0098] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0099] Figure 1 This is a flowchart illustrating an intelligent verification method for device account card data disclosed in an embodiment of the present invention;

[0100] Figure 2 This is a flowchart illustrating another intelligent verification method for device account card data disclosed in an embodiment of the present invention;

[0101] Figure 3 This is a schematic diagram of the structure of an intelligent verification device for device account card data disclosed in an embodiment of the present invention;

[0102] Figure 4 This is a schematic diagram of the structure of another intelligent verification device for device account card data disclosed in an embodiment of the present invention;

[0103] Figure 5 This is a schematic diagram of the structure of another intelligent verification device for device account card data disclosed in an embodiment of the present invention. Detailed Implementation

[0104] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0105] The terms "first," "second," etc., used in the specification, claims, and accompanying drawings of this invention are used to distinguish different objects, not to describe a specific order. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion. For example, a process, method, apparatus, product, or end that includes a series of steps or units is not limited to the listed steps or units, but may optionally include steps or units not listed, or may optionally include other steps or units inherent to these processes, methods, products, or ends.

[0106] In this document, the term "embodiment" means that a particular feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of the invention. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a separate or alternative embodiment mutually exclusive with other embodiments. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0107] This invention discloses an intelligent verification method and apparatus for equipment ledger and asset data. It can collect and verify ledger and asset data uniformly stored in an equipment database, and analyze this data to obtain ledger-asset consistency data. This improves the efficiency of ledger-asset data verification, reduces the isolation between the storage systems of ledger and asset data, and enhances the consistency of equipment information in the equipment ledger and fixed asset cards. Furthermore, it generates a ledger-asset consistency page based on the consistency data, enabling users to promptly correct abnormal data. This improves the data maintenance and information change synchronization rate of ledger and asset data, further enhancing the consistency of equipment information in the equipment ledger and fixed asset cards, and reducing asset loss costs caused by inconsistencies in equipment information between the two. Detailed descriptions follow.

[0108] Example 1

[0109] Please see Figure 1 , Figure 1 This is a flowchart illustrating an intelligent verification method for device account card data disclosed in an embodiment of the present invention. Figure 1The described intelligent verification method for equipment ledger and fixed asset cards can be applied to the verification process of equipment ledgers and fixed asset cards corresponding to fixed assets (such as power grid equipment of a power grid company) of any enterprise, unit, or individual. This invention does not limit the scope of the application. Figure 1 As shown, the intelligent verification method for device account data may include the following operations:

[0110] 101. Collect ledger data and asset data of one or more production equipment that meet the equipment statistical conditions from the equipment database.

[0111] In this embodiment of the invention, the equipment database may include all relevant data for each piece of equipment that any enterprise, unit, or individual has previously held, currently holds, or will soon hold. Optionally, all relevant data for each piece of equipment may include ledger data, asset data, equipment usage data, and corresponding electronic documents. Further optionally, ledger data may include equipment technical parameters and equipment operating parameters, and asset data may include procurement value parameters. Equipment technical parameters may include core ledger parameters, and procurement value parameters may include core asset parameters, main equipment purchase value parameters, and auxiliary material purchase value information. Further optionally, both ledger core parameters and core asset parameters may include one or more of the following: equipment code, equipment name, equipment model, equipment full path, manufacturer, maintenance unit, voltage level, commissioning time, equipment type, equipment operating status, asset status, ownership attribute, manufacturing time, and supplier.

[0112] In this embodiment of the invention, the equipment statistics conditions may include equipment type conditions, equipment status conditions, and commissioning time conditions. For example, production equipment that meets the equipment statistics conditions is production equipment that is in use or idle and has been in operation for more than 20 days.

[0113] 102. For each production equipment, verify the ledger data and asset data of that production equipment to obtain the corresponding account verification result.

[0114] As an optional implementation, for each production device, verifying the ledger data and asset data of that production device to obtain the corresponding account verification result may include:

[0115] Determine whether at least one piece of data in the ledger data and asset data of the production equipment is empty;

[0116] When it is determined that at least one data point in the ledger data and asset data of the production equipment is empty, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0117] When it is determined that neither the ledger data nor the asset data of the production equipment is empty, it is determined whether the basic equipment information corresponding to the ledger data of the production equipment matches the basic equipment information corresponding to the asset data of the production equipment. The basic equipment information may include the equipment status and / or equipment identifier.

[0118] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment does not match the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0119] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the second type of verification result.

[0120] As can be seen, implementing this optional implementation method can first detect whether the ledger data and asset data are empty, and then check whether the equipment status and equipment identifier corresponding to the ledger data and asset data match. This enables multi-level progressive verification between ledger data and asset data, which helps to improve the hierarchy, accuracy and reliability of the verification between ledger data and asset data. Furthermore, when the shallow-level verification results show data anomalies, it can reduce unnecessary deep-level verification steps, thereby improving the efficiency of ledger data and asset data verification and reducing unnecessary system memory consumption.

[0121] In this optional implementation, optionally, for each production equipment, when it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, before determining that the account verification result corresponding to the production equipment is the second type of verification result, the method may further include:

[0122] Based on one or more pre-determined data types, determine the core parameters of the ledger corresponding to each data type in the ledger data of the production equipment and the core parameters of the assets corresponding to each data type in the asset data of the production equipment;

[0123] Determine if the target data type exists among all data types, where the core ledger parameters corresponding to the target data type and the core asset parameters corresponding to the target data type do not match;

[0124] When it is determined that the target data type exists among all data types, the account card verification result corresponding to the production equipment is determined to be the first type of verification result;

[0125] When it is determined that the target data type does not exist among all data types, the operation described above, which determines that the account verification result corresponding to the production equipment is the second type of verification result, is triggered.

[0126] As can be seen, implementing this optional implementation method can further verify the core parameters of the same type when matching the equipment status and equipment identification of the ledger data and asset data, thereby further improving the hierarchy, accuracy and reliability of data verification between ledger data and asset data.

[0127] In this optional implementation, the first verification result is the account-card inconsistency result, and the second verification result is the account-card consistency result. Specifically, when the ledger data is empty, the account-card inconsistency result is the result of having a card but no account; when the asset data is empty, the account-card inconsistency result is the result of having an account but no card; when the target data type exists among all data types, the account-card inconsistency result is the result of inconsistent account-card core parameters.

[0128] 103. Analyze the account card verification results for each production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all production equipment.

[0129] In this embodiment of the invention, the account-card consistency data may optionally include account-card consistency rate, account-card inconsistency rate, number of account-card consistent devices, number of account-card inconsistent devices, account-card consistent device details, account-card inconsistent device details, etc. Further optionally, the above-mentioned account-card consistency data can be account-card consistency data based on any dimension, such as account-card consistency rate statistically calculated by unit or profession.

[0130] 104. Based on the account card consistency data, generate an account card consistency analysis page corresponding to the device set. The account card consistency analysis page is used to display account card consistency data to users so that users can correct abnormal data in the device database.

[0131] In this embodiment of the invention, optionally, the account-card consistency analysis page may include data statistics charts corresponding to account-card consistency data and detailed data corresponding to the data statistics charts. Further optionally, the detailed data may be hidden on the account-card consistency analysis page, and when the user triggers a detailed data query request, the detailed data is displayed in the corresponding position on the account-card consistency analysis page.

[0132] As can be seen, implementing the embodiments of the present invention can improve the efficiency of account card data verification by collecting and verifying the ledger data and asset data uniformly stored in the equipment database, and thereby analyzing the account card consistency data. This reduces the isolation between the storage systems of ledger data and asset data, and improves the consistency of equipment information in the equipment ledger and fixed asset cards. In addition, generating an account card consistency page based on the account card consistency data allows users to correct abnormal data in a timely manner, which can improve the data maintenance and information change synchronization rate of ledger data and asset data, further improve the consistency of equipment information in the equipment ledger and fixed asset cards, and reduce the asset loss cost caused by inconsistencies in equipment information in the equipment ledger and fixed asset cards.

[0133] In an optional embodiment, the method may further include:

[0134] When a purchase order related instruction for a new production equipment is detected, a target equipment identifier for the new production equipment is generated based on the purchase order related instruction.

[0135] Collect the purchase value parameters associated with the order contract for new production equipment and the equipment technical parameters associated with the order contract;

[0136] Based on a unified data model and target equipment identifiers in the equipment database, procurement value parameters and equipment technical parameters are stored in the equipment database.

[0137] When a material installation instruction corresponding to a new production equipment is detected, the procurement value parameters and target equipment identifier are imported into the equipment ledger corresponding to the equipment database based on a unified data model to obtain the target ledger data of the new production equipment; and based on a unified data model, the equipment technical parameters and target equipment identifier are imported into the fixed asset card corresponding to the equipment database to obtain the target asset data of the new production equipment.

[0138] As can be seen, implementing this optional embodiment can automatically identify the production equipment and store the procurement value parameters and equipment technical parameters associated with the order contract into the equipment database based on a unified data model when the order for new production equipment is completed. It can also automatically import the equipment ledger and fixed asset card, which improves the efficiency and accuracy of equipment information import and helps to improve the data maintenance and information change synchronization rate of ledger data and asset data. This improves the consistency of equipment information in the equipment ledger and fixed asset card based on the information source.

[0139] In this optional embodiment, as an alternative implementation, the method may further include:

[0140] When an asset value confirmation instruction corresponding to a new production equipment is detected, the material requisition ratio of the new production equipment on each auxiliary material in the material requisition list is determined based on the material requisition list corresponding to the target equipment identifier.

[0141] Based on the material requisition ratio of the new production equipment for each auxiliary material, the total cost corresponding to each auxiliary material determined in advance, and the allocation rules corresponding to each auxiliary material, determine the allocation cost of the new production equipment for each auxiliary material.

[0142] Calculate the asset value of the new production equipment based on the purchase value parameters and the allocated costs of each auxiliary material for the new production equipment.

[0143] It is evident that implementing this optional implementation method can quickly associate the material requisition list with the equipment identifier and thus accurately obtain the cost of auxiliary materials for the production equipment, thereby calculating the asset value corresponding to the production equipment, which can improve the efficiency and accuracy of the valuation of the production equipment asset value.

[0144] In this optional implementation, the method may further include:

[0145] When an asset original value confirmation instruction corresponding to new production equipment is detected, the allocation ratio of the new production equipment on each service in the financial document other than equipment purchase is determined based on the financial document corresponding to the target equipment identifier.

[0146] Based on the allocation ratio of the new production equipment for each service, the predetermined total cost for each service, and the allocation rules for each service, determine the allocation cost of the new production equipment for each service.

[0147] Calculate the original value of the new production equipment based on the asset value and the allocated costs for each service.

[0148] It is evident that implementing this optional implementation method can also quickly associate financial documents based on equipment identification to accurately obtain the cost of production equipment in services other than equipment purchase, thereby calculating the original value of the assets corresponding to the production equipment, which can improve the efficiency and accuracy of the total cost valuation of production equipment.

[0149] Example 2

[0150] Please see Figure 2 , Figure 2 This is a flowchart illustrating an intelligent verification method for device account card data disclosed in an embodiment of the present invention. Figure 2 The described intelligent verification method for equipment ledger and fixed asset cards can be applied to the verification process of equipment ledgers and fixed asset cards corresponding to fixed assets (such as power grid equipment of a power grid company) of any enterprise, unit, or individual. This invention does not limit the scope of the application. Figure 2 As shown, the intelligent verification method for device account data may include the following operations:

[0151] 201. Collect ledger data and asset data of one or more production equipment in the equipment database that meet the equipment statistical conditions.

[0152] 202. For each production equipment, verify the ledger data and asset data of that production equipment to obtain the corresponding account verification result.

[0153] 203. Analyze the account card verification results for each production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all production equipment.

[0154] 204. Collect historical account and card consistency data within the target time period from the device database.

[0155] In this embodiment of the invention, the target time period can be any time period, such as one month, one week, one year, etc., and this embodiment of the invention does not impose any limitation.

[0156] 205. Analyze the account card consistency data and historical account card consistency data to obtain the changed account card consistency data corresponding to the device set.

[0157] As an optional implementation method, the inconsistency types corresponding to the account card consistency data and historical account card consistency data may include one or more of the following: account without card, card without account, basic information inconsistency, core parameter inconsistency, and cumulative inconsistency. Among them, the cumulative inconsistency types may include account without card, card without account, basic information inconsistency, and core parameter inconsistency.

[0158] Furthermore, for each type of inconsistency, analyze the account consistency data and historical account consistency data to obtain the changed account consistency data corresponding to the device set, which may include:

[0159] Based on the number of devices corresponding to this inconsistency type in the account card consistency data for the current period ∑ W The number of devices in the previous period corresponding to this inconsistency type in the Y and historical account card consistency data ∑ W-1 Y determines the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, and the year-on-year change in the number of new devices added in the current period F, corresponding to the inconsistency type. Here, the number of devices cleared in the current period ∑C includes the number of all devices present in the previous period's devices but not present in the current period's devices corresponding to the inconsistency type; the number of devices left over from the previous period ∑Q includes the number of all devices present in both the previous and current periods' devices corresponding to the inconsistency type; and...

[0160] ΔY=∑ W Y-∑ W-1 Y, F = (∑ W Y-∑ W-1 Y)÷∑ W Y;

[0161] Based on the number of newly added devices ΔY in this period and the number of newly added devices Δ′Y in the previous period corresponding to the inconsistency type in the historical account consistency data, determine the unit percentage K of the number of newly added devices in this period corresponding to the inconsistency type:

[0162] K = (ΔY - Δ′Y) ÷ ΔY;

[0163] The equipment set is determined by one or more of the following: the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, the year-on-year change in the number of new devices added in the current period F, and the percentage of new devices added in the current period K. This set is based on the change account consistency data corresponding to the inconsistency type.

[0164] As can be seen, implementing this optional implementation method can calculate the change account consistency data corresponding to each inconsistency type based on the number of devices in the current period and the number of devices in the previous period corresponding to multiple inconsistency types, thereby improving the accuracy and comprehensiveness of the change account consistency data.

[0165] In this embodiment of the invention, optionally, the changed account-card consistency data may also include account-card consistency change rate, account-card inconsistency change rate, details of newly added account-card consistent devices, details of newly added account-card inconsistent devices, details of cleared account-card inconsistent devices, details of cumulative account-card inconsistent devices, details of legacy account-card inconsistent devices, etc. Further optionally, the above-mentioned changed account-card consistency data can be account-card consistency data based on any dimension, such as the account-card consistency change rate statistically analyzed monthly or annually. This embodiment of the invention does not impose any limitations.

[0166] 206. Based on the account consistency data and / or the changed account consistency data, determine one or more statistical dimensions that match the device set.

[0167] In this embodiment of the invention, the statistical dimensions may include any dimension such as time dimension, equipment dimension (e.g., equipment type), ownership dimension (e.g., unit, profession), etc., and this embodiment of the invention does not limit them.

[0168] 207. Based on all statistical dimensions and account card analysis data, generate at least one data statistical chart and detailed data corresponding to each data statistical chart. The account card analysis data may include account card consistency data and / or changed account card consistency data.

[0169] As an optional implementation, based on all statistical dimensions and account analysis data, at least one data chart and detailed data corresponding to each data chart are generated, which may include:

[0170] Based on the dimension attributes corresponding to all statistical dimensions, determine at least one dimension set consisting of at least one statistical dimension, the comprehensive dimension attribute corresponding to each dimension set, and the set type corresponding to each dimension set; wherein, the set type corresponding to each dimension set may include a first type or a second type, each dimension set of the first type may include only one statistical dimension, and each dimension set of the second type may include the central statistical dimension corresponding to the dimension set and at least one associated statistical dimension that matches the central statistical dimension;

[0171] Based on the comprehensive dimension attributes corresponding to each dimension set and the set type corresponding to that dimension set, determine the chart type corresponding to that dimension set;

[0172] For each dimension set, based on the comprehensive dimension attributes corresponding to that dimension set, the chart type corresponding to that dimension set, and the account analysis data, generate the data statistics chart corresponding to that dimension set and the detailed data corresponding to that data statistics chart.

[0173] It is evident that implementing this optional implementation method can combine different statistical dimensions into multiple dimension sets based on the dimensional attributes of the statistical dimensions, and generate data statistical charts and detailed data based on each dimension set. This can improve the diversity, flexibility, accuracy, and reliability of the generation of data statistical charts and detailed data. In addition, determining the chart type based on the comprehensive dimensional attributes and set type of the dimension set helps to improve the matching degree between the chart type and the dimension set, thereby improving the aesthetics and visibility of the data statistical charts.

[0174] In this optional implementation, optionally, for each dimension set, when the set type corresponding to the dimension set is the first type, based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data, a data statistical chart corresponding to the dimension set and detailed data corresponding to the data statistical chart are generated, which may include:

[0175] Based on the dimensional attributes of the statistical dimensions in the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the first type of dimension set. The one-dimensional distribution data corresponding to the dimension set may include the distribution data of the account card analysis data on the statistical dimensions of the dimension set.

[0176] Import the one-dimensional distribution data corresponding to the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0177] As can be seen, implementing this optional implementation method can also directly import the one-dimensional distribution data of the account card analysis data in a single statistical dimension into the chart template to obtain the data statistical charts and detailed data corresponding to that statistical dimension, thereby improving the efficiency and accuracy of generating data statistical charts and detailed data corresponding to a single statistical dimension.

[0178] In this optional implementation, optionally, for each dimension set, when the set type corresponding to the dimension set is the second type, based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data, a data statistical chart corresponding to the dimension set and detailed data corresponding to the data statistical chart are generated, which may include:

[0179] Based on the dimensional attributes of the central statistical dimension of the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the dimension set. The one-dimensional distribution data corresponding to the dimension set may include the distribution data of the account card analysis data on the central statistical dimension of the dimension set.

[0180] Based on the one-dimensional distribution data corresponding to the dimension set and the dimension attributes of each associated statistical dimension in the dimension set, determine the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set. The two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set may include the distribution data of the one-dimensional distribution data corresponding to the dimension set on the associated statistical dimension.

[0181] Import the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0182] As can be seen, implementing this optional implementation method can first determine the one-dimensional distribution data of the account card analysis data on the central statistical dimension, and then import the two-dimensional distribution data of the one-dimensional distribution data on each associated statistical dimension into the chart template to obtain the data statistical charts and detailed data corresponding to the dimension set. This improves the efficiency and accuracy of generating data statistical charts and detailed data corresponding to multiple statistical dimensions, and is conducive to promoting the organic relationship between different statistical dimensions in a single data statistical chart, thereby improving the diversity, hierarchy and information density of the data content displayed by the data statistical chart, and thus improving the visualization of the data statistical chart.

[0183] 208. Based on each data chart and the corresponding detailed data, generate an account consistency analysis page for the device set.

[0184] In this embodiment of the invention, for other descriptions of steps 201-203, please refer to the detailed description of steps 101-103 in Embodiment 1. This embodiment of the invention will not repeat them.

[0185] As can be seen, implementing the embodiments of the present invention can combine account card consistency data and historical account card consistency data to obtain changed account card consistency data. This is beneficial for users to accurately understand the historical changes and trends in account card consistency rate, and it also helps to increase users' attention to equipment data with inconsistent account cards and slow rectification speed, thereby improving the rectification efficiency of abnormal data. In addition, generating statistical charts and detailed data based on multiple dimensions, and then generating account card consistency analysis based on these, can improve the accuracy and reliability of the account card consistency analysis page generation, enrich the page content of the account card consistency page, and improve the visualization of the account card consistency page.

[0186] Example 3

[0187] Please see Figure 3 , Figure 3 This is a schematic diagram of the structure of an intelligent verification device for device account card data disclosed in an embodiment of the present invention. Figure 3 The intelligent verification device for equipment ledger and fixed asset cards described herein can be applied to the verification process of equipment ledgers and fixed asset cards corresponding to fixed assets (such as power grid equipment of a power grid company) of any enterprise, unit, or individual. This invention does not limit the scope of the application. Figure 3 As shown, the intelligent verification device for the device's account card data may include:

[0188] The data acquisition module 301 is used to collect ledger data and asset data of one or more production equipment that meet the statistical conditions of equipment from the equipment database.

[0189] The verification module 302 is used to verify the ledger data and asset data of each production equipment and obtain the corresponding account card verification result for the production equipment.

[0190] Analysis module 303 is used to analyze the account card verification results corresponding to each production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all production equipment;

[0191] The generation module 304 is used to generate an account consistency analysis page corresponding to the device set based on the account consistency data. The account consistency analysis page is used to display the account consistency data to the user so that the user can correct the abnormal data in the device database.

[0192] It is evident that implementation Figure 3The described device can collect and verify ledger data and asset data uniformly stored in the equipment database, and analyze the data to obtain account-card consistency data. This improves the efficiency of account-card data verification and reduces the isolation between the storage systems of ledger data and asset data, thereby improving the consistency of equipment information in the equipment ledger and fixed asset cards. In addition, it generates account-card consistency pages based on the account-card consistency data, enabling users to correct abnormal data in a timely manner. This improves the data maintenance and information change synchronization rate of ledger data and asset data, further enhancing the consistency of equipment information in the equipment ledger and fixed asset cards, and reducing the asset loss costs caused by inconsistencies in equipment information between the two.

[0193] In an optional embodiment, such as Figure 3 As shown, for each production device, the verification module 302 verifies the ledger data and asset data of that production device to obtain the corresponding account verification result. The specific methods for this can include:

[0194] Determine whether at least one piece of data in the ledger data and asset data of the production equipment is empty;

[0195] When it is determined that at least one data point in the ledger data and asset data of the production equipment is empty, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0196] When it is determined that neither the ledger data nor the asset data of the production equipment is empty, it is determined whether the basic equipment information corresponding to the ledger data of the production equipment matches the basic equipment information corresponding to the asset data of the production equipment. The basic equipment information may include the equipment status and / or equipment identifier.

[0197] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment does not match the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the first type of verification result.

[0198] When it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the second type of verification result.

[0199] It is evident that implementation Figure 3The described device can first detect whether the ledger data and asset data are empty, and then detect whether the equipment status and equipment identifier corresponding to the ledger data and asset data match. This enables multi-level progressive verification between ledger data and asset data, which helps to improve the hierarchy, accuracy and reliability of the verification between ledger data and asset data. Furthermore, when the shallow verification results show data anomalies, it can reduce unnecessary deep verification steps, thereby improving the efficiency of ledger data and asset data verification and reducing unnecessary system memory consumption.

[0200] In another alternative embodiment, such as Figure 3 As shown, the verification module 302 is further configured to, for each production equipment, when it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, before determining that the account card verification result corresponding to the production equipment is the second type of verification result, determine the ledger core parameters corresponding to each data type in the ledger data of the production equipment and the asset core parameters corresponding to each data type in the asset data of the production equipment based on one or more pre-determined data types; determine whether there is a target data type among all data types, wherein the ledger core parameters corresponding to the target data type and the asset core parameters corresponding to the target data type do not match; when it is determined that there is a target data type among all data types, determine that the account card verification result corresponding to the production equipment is the first type of verification result; when it is determined that there is no target data type among all data types, trigger the operation of determining that the account card verification result corresponding to the production equipment is the second type of verification result.

[0201] It is evident that implementation Figure 3 The described device can further verify the core parameters of the same type when matching the equipment status and equipment identification of the ledger data and asset data, thereby further improving the hierarchy, accuracy and reliability of data verification between ledger data and asset data.

[0202] In yet another alternative embodiment, such as Figure 4 As shown, the acquisition module 301 is also used to acquire historical account consistency data within the target time period in the device database before the generation module 304 generates the account consistency analysis page corresponding to the device set based on the account consistency data.

[0203] Analysis module 303 is also used to analyze account card consistency data and historical account card consistency data to obtain the changed account card consistency data corresponding to the device set;

[0204] Furthermore, the specific method by which the generation module 304 generates the account-card consistency analysis page corresponding to the device set based on the account-card consistency data may include:

[0205] Based on the account consistency data and / or changed account consistency data, determine one or more statistical dimensions that match the device set;

[0206] Based on all statistical dimensions and account card analysis data, generate at least one data statistical chart and detailed data corresponding to each data statistical chart. The account card analysis data may include account card consistency data and / or changed account card consistency data.

[0207] Based on each data chart and the corresponding detailed data, generate an account consistency analysis page for the device set.

[0208] It is evident that implementation Figure 4 The described device can combine account card consistency data and historical account card consistency data to obtain changed account card consistency data. This helps users accurately understand the historical changes and trends in account card consistency rates, and increases users' attention to equipment data with inconsistent accounts card data and slow rectification speeds, thereby improving the rectification efficiency of abnormal data. In addition, by generating statistical charts and detailed data based on multiple dimensions, and then using this as a basis to generate account card consistency analysis, the accuracy and reliability of the account card consistency analysis page can be improved, the page content of the account card consistency page can be enriched, and the visualization of the account card consistency page can be enhanced.

[0209] In yet another alternative embodiment, such as Figure 4 As shown, the inconsistency types corresponding to the account card consistency data and historical account card consistency data can include one or more of the following: account without card, card without account, basic information inconsistency, core parameter inconsistency, and cumulative inconsistency. Among them, the cumulative inconsistency type can include account without card, card without account, basic information inconsistency, and core parameter inconsistency.

[0210] Furthermore, for each type of inconsistency, the analysis module 303 analyzes the account card consistency data and historical account card consistency data to obtain the specific methods for obtaining the changed account card consistency data corresponding to the device set, which may include:

[0211] Based on the number of devices corresponding to this inconsistency type in the account card consistency data for the current period ∑ W The number of devices in the previous period corresponding to this inconsistency type in the Y and historical account card consistency data ∑ W-1Y determines the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, and the year-on-year change in the number of new devices added in the current period F, corresponding to the inconsistency type. Here, the number of devices cleared in the current period ∑C includes the number of all devices present in the previous period's devices but not present in the current period's devices corresponding to the inconsistency type; the number of devices left over from the previous period ∑Q includes the number of all devices present in both the previous and current periods' devices corresponding to the inconsistency type; and...

[0212] ΔY=∑ W Y-∑ W-1 Y, F = (∑ W Y-∑ W-1 Y)÷∑ W Y;

[0213] Based on the number of newly added devices ΔY in this period and the number of newly added devices Δ′Y in the previous period corresponding to the inconsistency type in the historical account consistency data, determine the unit percentage K of the number of newly added devices in this period corresponding to the inconsistency type:

[0214] K = (ΔY - Δ′Y) ÷ ΔY;

[0215] The equipment set is determined by one or more of the following: the number of devices cleared in the current period ∑C, the number of devices left over from the previous period ∑Q, the number of new devices added in the current period ΔY, the year-on-year change in the number of new devices added in the current period F, and the percentage of new devices added in the current period K. This set is based on the change account consistency data corresponding to the inconsistency type.

[0216] It is evident that implementation Figure 4 The described device can also calculate change account consistency data corresponding to each inconsistency type based on the current period's number of devices and the previous period's number of devices corresponding to multiple inconsistency types, thereby improving the accuracy and comprehensiveness of change account consistency data.

[0217] In yet another alternative embodiment, such as Figure 4 As shown, the specific method by which the generation module 304 generates at least one data chart and the detailed data corresponding to each data chart based on all statistical dimensions and account card analysis data may include:

[0218] Based on the dimension attributes corresponding to all statistical dimensions, determine at least one dimension set consisting of at least one statistical dimension, the comprehensive dimension attribute corresponding to each dimension set, and the set type corresponding to each dimension set; wherein, the set type corresponding to each dimension set may include a first type or a second type, each dimension set of the first type may include only one statistical dimension, and each dimension set of the second type may include the central statistical dimension corresponding to the dimension set and at least one associated statistical dimension that matches the central statistical dimension;

[0219] Based on the comprehensive dimension attributes corresponding to each dimension set and the set type corresponding to that dimension set, determine the chart type corresponding to that dimension set;

[0220] For each dimension set, based on the comprehensive dimension attributes corresponding to that dimension set, the chart type corresponding to that dimension set, and the account analysis data, generate the data statistics chart corresponding to that dimension set and the detailed data corresponding to that data statistics chart.

[0221] It is evident that implementation Figure 4 The described device can also combine different statistical dimensions into multiple dimension sets based on the dimensional attributes of the statistical dimensions, and generate data statistical charts and detailed data based on each dimension set. This can improve the diversity, flexibility, accuracy and reliability of the generation of data statistical charts and detailed data. In addition, determining the chart type based on the comprehensive dimensional attributes and set type of the dimension set helps to improve the matching degree between the chart type and the dimension set, and improve the aesthetics and visibility of the data statistical charts.

[0222] In yet another alternative embodiment, such as Figure 4 As shown, for each dimension set, when the set type corresponding to the dimension set is the first type, the specific method by which the generation module 304 generates the data statistics chart and the detailed data corresponding to the data statistics chart based on the comprehensive dimension attribute, the chart type, and the account analysis data of the dimension set may include:

[0223] Based on the dimensional attributes of the statistical dimensions in the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the first type of dimension set. The one-dimensional distribution data corresponding to the dimension set may include the distribution data of the account card analysis data on the statistical dimensions of the dimension set.

[0224] Import the one-dimensional distribution data corresponding to the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0225] It is evident that implementation Figure 4 The described device can also directly import one-dimensional distribution data of account card analysis data in a single statistical dimension into a chart template to obtain the corresponding statistical charts and detailed data for that statistical dimension, thereby improving the efficiency and accuracy of generating statistical charts and detailed data for a single statistical dimension.

[0226] In yet another alternative embodiment, such as Figure 4As shown, for each dimension set, when the set type corresponding to the dimension set is the second type, the specific method by which the generation module 304 generates the data statistics chart and the detailed data corresponding to the data statistics chart based on the comprehensive dimension attribute, the chart type, and the account analysis data of the dimension set may include:

[0227] Based on the dimensional attributes of the central statistical dimension of the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the dimension set. The one-dimensional distribution data corresponding to the dimension set may include the distribution data of the account card analysis data on the central statistical dimension of the dimension set.

[0228] Based on the one-dimensional distribution data corresponding to the dimension set and the dimension attributes of each associated statistical dimension in the dimension set, determine the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set. The two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set may include the distribution data of the one-dimensional distribution data corresponding to the dimension set on the associated statistical dimension.

[0229] Import the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

[0230] It is evident that implementation Figure 4 The described device can first determine the one-dimensional distribution data of the account card analysis data on the central statistical dimension, and then import the two-dimensional distribution data of the one-dimensional distribution data on each associated statistical dimension into the chart template to obtain the data statistical charts and detailed data corresponding to the dimension set. This improves the efficiency and accuracy of generating data statistical charts and detailed data corresponding to multiple statistical dimensions, and is conducive to promoting the organic relationship between different statistical dimensions in a single data statistical chart, thereby improving the diversity, hierarchy and information density of the data content displayed by the data statistical chart, and thus improving the visualization of the data statistical chart.

[0231] In yet another alternative embodiment, such as Figure 4 As shown, the generation module 304 is also used to generate a target equipment identifier corresponding to the new production equipment based on the purchase order related instructions when a purchase order related instructions corresponding to the new production equipment are detected;

[0232] The data acquisition module 301 is also used to acquire the purchase value parameters associated with the order contract for new production equipment and the equipment technical parameters associated with the order contract;

[0233] The device may also include:

[0234] Storage module 305 is used to store procurement value parameters and equipment technical parameters into the equipment database based on the unified data model and target equipment identifier of the equipment database;

[0235] The import module 306 is used to import the procurement value parameters and target equipment identifier into the equipment ledger corresponding to the equipment database based on a unified data model when a material installation instruction corresponding to a new production equipment is detected, so as to obtain the target ledger data of the new production equipment; and to import the equipment technical parameters and target equipment identifier into the fixed asset card corresponding to the equipment database based on a unified data model, so as to obtain the target asset data of the new production equipment.

[0236] It is evident that implementation Figure 4 The described device can also automatically generate equipment identification and store the purchase value parameters and equipment technical parameters associated with the order contract into an equipment database based on a unified data model when a new production equipment order is placed. It can also automatically import the equipment ledger and fixed asset card, improving the efficiency and accuracy of equipment information import. This also helps to improve the data maintenance and information change synchronization rate of ledger and asset data, thereby improving the consistency of equipment information in the equipment ledger and fixed asset card based on the information source.

[0237] Example 4

[0238] Please see Figure 5 , Figure 5 This is a schematic diagram of the structure of another intelligent verification device for device account card data disclosed in an embodiment of the present invention. For example... Figure 5 As shown, the intelligent verification device for the device's account card data may include:

[0239] Memory 401 storing executable program code;

[0240] Processor 402 coupled to memory 401;

[0241] The processor 402 calls the executable program code stored in the memory 401 to execute the steps in the intelligent verification method for device account card data described in Embodiment 1 or Embodiment 2 of the present invention.

[0242] Example 5

[0243] This invention discloses a computer storage medium storing computer instructions. When these computer instructions are invoked, they are used to execute the steps in the intelligent verification method for device account data described in Embodiment 1 or Embodiment 2 of this invention.

[0244] Example 6

[0245] This invention discloses a computer program product, which includes a non-transitory computer-readable storage medium storing a computer program, and the computer program is operable to cause a computer to perform the steps in the intelligent verification method for device account card data described in Embodiment 1 or Embodiment 2.

[0246] The device embodiments described above are merely illustrative. The modules described as separate components may or may not be physically separate. The components shown as modules may or may not be physical modules; that is, they may be located in one place or distributed across multiple network modules. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0247] Through the detailed description of the above embodiments, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, including read-only memory (ROM), random access memory (RAM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), one-time programmable read-only memory (OTPROM), electrically-Erasable Programmable Read-Only Memory (EEPROM), compact disc read-only memory (CD-ROM) or other optical disc storage, disk storage, magnetic tape storage, or any other computer-readable medium that can be used to carry or store data.

[0248] Finally, it should be noted that the intelligent verification method and apparatus for device account card data disclosed in the embodiments of the present invention are merely preferred embodiments of the present invention and are only used to illustrate the technical solutions of the present invention, not to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for intelligent verification of device account card data, characterized in that, The method includes: Collect ledger and asset data of one or more production equipment that meet the equipment statistics criteria from the equipment database; For each of the aforementioned production equipment, verify the ledger data and asset data of that production equipment to obtain the corresponding account verification result; Analyze the account card verification results corresponding to each of the production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all the production equipment. Based on the account card consistency data, an account card consistency analysis page corresponding to the device set is generated. The account card consistency analysis page is used to display the account card consistency data to the user so that the user can correct the abnormal data in the device database. And, before generating the account / card consistency analysis page corresponding to the device set based on the account / card consistency data, the method further includes: Collect historical account consistency data within the target time period from the device database; By analyzing the account card consistency data and the historical account card consistency data, the changed account card consistency data corresponding to the device set is obtained; Furthermore, the inconsistency types corresponding to the account-card consistency data and the historical account-card consistency data include one or more of the following: account without card, card without account, basic information inconsistency, core parameter inconsistency, and cumulative inconsistency. The cumulative inconsistency types include the account without card, the card without account, the basic information inconsistency, and the core parameter inconsistency. And, for each type of inconsistency, the analysis of the account card consistency data and the historical account card consistency data to obtain the changed account card consistency data corresponding to the device set includes: Based on the number of devices in the current period corresponding to the inconsistency type in the account card consistency data. The number of devices in the previous period corresponding to this inconsistency type in the historical account card consistency data. Determine the number of devices cleaned up in the current period corresponding to this inconsistency type. Number of devices left over from the previous period Number of newly added equipment in this period And the number of newly added equipment in this period, unit F, wherein the number of equipment cleared in this period This includes the number of all devices that exist in the previous period's devices corresponding to this inconsistency type but not in the current period's devices corresponding to this inconsistency type, and the number of legacy devices from the previous period. This includes the number of all devices that exist in the previous period's devices corresponding to this inconsistency type and in the current period's devices corresponding to this inconsistency type, and, , ; Based on the number of newly added equipment in this period The number of newly added devices in the previous period corresponding to this inconsistency type in the historical account card consistency data. Determine the percentage (K) of newly added equipment in the current period corresponding to this inconsistency type: ; The number of devices cleaned in this period The number of devices left over from the previous period The number of newly added equipment in this period One or more of the following are determined as the change account consistency data of the device set based on the inconsistency type: F is the month-on-month change in the number of newly added devices in the current period, and K is the percentage of newly added devices in the current period.

2. The intelligent verification method for equipment account card data according to claim 1, characterized in that, For each of the aforementioned production devices, the verification of the ledger data and asset data for that production device to obtain the corresponding account verification result includes: Determine whether at least one piece of data in the ledger data and asset data of the production equipment is empty; When it is determined that at least one data point in the ledger data and asset data of the production equipment is empty, the account card verification result corresponding to the production equipment is determined to be the first type of verification result. When it is determined that neither the ledger data nor the asset data of the production equipment is empty, it is determined whether the basic equipment information corresponding to the ledger data of the production equipment matches the basic equipment information corresponding to the asset data of the production equipment. The basic equipment information includes equipment status and / or equipment identifier. When it is determined that the equipment basic information corresponding to the ledger data of the production equipment does not match the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the first type of verification result. When it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, the account card verification result corresponding to the production equipment is determined to be the second type of verification result.

3. The intelligent verification method for equipment account card data according to claim 2, characterized in that, For each of the aforementioned production equipment, when it is determined that the equipment basic information corresponding to the ledger data of the production equipment matches the equipment basic information corresponding to the asset data of the production equipment, before determining that the account verification result corresponding to the production equipment is the second type of verification result, the method further includes: Based on one or more predetermined data types, determine the core parameters of the ledger corresponding to each data type in the ledger data of the production equipment and the core parameters of the assets corresponding to each data type in the asset data of the production equipment; Determine whether a target data type exists among all the data types, wherein the ledger core parameters corresponding to the target data type and the asset core parameters corresponding to the target data type do not match; When it is determined that the target data type exists among all the data types, the account card verification result corresponding to the production equipment is determined to be the first type of verification result. When it is determined that the target data type does not exist among all the data types, the operation of determining that the account card verification result corresponding to the production equipment is the second type of verification result is triggered.

4. The intelligent verification method for equipment account card data according to claim 3, characterized in that, The step of generating an account-card consistency analysis page corresponding to the device set based on the account-card consistency data includes: Based on the account card consistency data and / or the changed account card consistency data, determine one or more statistical dimensions that match the device set; Based on all the statistical dimensions and account card analysis data, at least one data statistical chart and detailed data corresponding to each data statistical chart are generated. The account card analysis data includes the account card consistency data and / or the changed account card consistency data. Based on each of the data statistics charts and the detailed data corresponding to the data statistics charts, an account card consistency analysis page corresponding to the device set is generated.

5. The intelligent verification method for equipment account card data according to claim 1 or 4, characterized in that, Based on all the statistical dimensions and account analysis data, at least one data statistical chart and detailed data corresponding to each data statistical chart are generated, including: Based on the dimension attributes corresponding to all the statistical dimensions, determine at least one dimension set consisting of at least one statistical dimension, a comprehensive dimension attribute corresponding to each dimension set, and a set type corresponding to each dimension set; wherein, the set type corresponding to each dimension set includes a first type or a second type, each dimension set of the first type includes only one statistical dimension, and each dimension set of the second type includes the central statistical dimension corresponding to the dimension set and at least one associated statistical dimension matching the central statistical dimension; Based on the comprehensive dimension attribute corresponding to each dimension set and the set type corresponding to that dimension set, determine the chart type corresponding to that dimension set; For each dimension set, based on the comprehensive dimension attributes corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data, a data statistics chart corresponding to the dimension set and detailed data corresponding to the data statistics chart are generated.

6. The intelligent verification method for equipment account card data according to claim 5, characterized in that, For each dimension set, when the set type corresponding to the dimension set is the first type, the step of generating a data statistics chart and detailed data corresponding to the data statistics chart based on the comprehensive dimension attribute corresponding to the dimension set, the chart type corresponding to the dimension set, and the account analysis data includes: Based on the dimensional attributes of the statistical dimensions in the dimension set and the account card analysis data, the one-dimensional distribution data corresponding to the first type of dimension set is determined. The one-dimensional distribution data corresponding to the dimension set includes the distribution data of the account card analysis data on the statistical dimensions of the dimension set. Import the one-dimensional distribution data corresponding to the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

7. The intelligent verification method for equipment account card data according to claim 5, characterized in that, For each dimension set, when the set type corresponding to the dimension set is the second type, the step of generating a data statistics chart and detailed data corresponding to the data statistics chart based on the comprehensive dimension attribute, the chart type, and the account analysis data of the dimension set includes: Based on the dimensional attributes of the central statistical dimension of the dimension set and the account card analysis data, determine the one-dimensional distribution data corresponding to the dimension set. The one-dimensional distribution data corresponding to the dimension set includes the distribution data of the account card analysis data on the central statistical dimension of the dimension set. Based on the one-dimensional distribution data corresponding to the dimension set and the dimension attributes of each associated statistical dimension in the dimension set, determine the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set. The two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set includes the distribution data of the one-dimensional distribution data corresponding to the dimension set on the associated statistical dimension. Import the two-dimensional distribution data corresponding to each associated statistical dimension in the dimension set into a chart template of a pre-determined chart type corresponding to the dimension set to obtain the data statistics chart and the detailed data corresponding to the data statistics chart.

8. The intelligent verification method for equipment account card data according to any one of claims 1, 2, 3, 4, 6, and 7, characterized in that, The method further includes: When a purchase order related instruction corresponding to a new production equipment is detected, a target equipment identifier corresponding to the new production equipment is generated based on the purchase order related instruction; Collect the purchase value parameters associated with the order contract for the new production equipment and the equipment technical parameters associated with the order contract; Based on the unified data model of the equipment database and the target equipment identifier, the procurement value parameters and the equipment technical parameters are stored in the equipment database; When a material installation instruction corresponding to the new production equipment is detected, based on the unified data model, the procurement value parameters and the target equipment identifier are imported into the equipment ledger corresponding to the equipment database to obtain the target ledger data of the new production equipment; and based on the unified data model, the equipment technical parameters and the target equipment identifier are imported into the fixed asset card corresponding to the equipment database to obtain the target asset data of the new production equipment.

9. An intelligent verification device for equipment account card data, characterized in that, The device is used to perform the intelligent verification method for device account card data as described in any one of claims 1-8, and the device comprises: The data acquisition module is used to collect ledger data and asset data of one or more production equipment that meet the statistical conditions of the equipment from the equipment database. The verification module is used to verify the ledger data and asset data of each production equipment to obtain the account card verification result corresponding to the production equipment. The analysis module is used to analyze the account card verification results corresponding to each of the production equipment to obtain the account card consistency data corresponding to the equipment set consisting of all the production equipment. The generation module is used to generate an account consistency analysis page corresponding to the device set based on the account consistency data. The account consistency analysis page is used to display the account consistency data to the user so that the user can correct abnormal data in the device database.

Citation Information

Patent Citations

  • Equipment accounting, card and real object consistency verification method

    CN107590600A

  • PMS power transformation equipment data verification and identification method and system

    CN114386745A