Weight bill data change recording method and system, terminal equipment and storage medium

By generating records of the pound order information table and historical version data, evaluating data integrity and key field modification area, the problem of difficulty in tracing information in the traditional pound order management method is solved, and effective recording and analysis of pound order data is realized. Improve management efficiency and accuracy.

CN118917284APending Publication Date: 2024-11-08西藏众陶联供应链服务有限公司 +4
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410930127.7
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-11
Publication Date
2024-11-08

AI Technical Summary

Technical Problem

The traditional pound order management method lacks effective recording and traceability of information modification, and is difficult to meet the needs of data analysis, affecting the transparency of the logistics process and the accuracy of data.

Method used

The change recording method of the pound order data is used to generate a pound order information table including key fields, record historical version data, generate a change report, evaluate the data integrity and the modified area of ​​the key fields, and determine the credibility of the pound order information.

Benefits of technology

By recording changes in each pound information in detail, ensuring the integrity and accuracy of the data, providing clear data management and recording specifications, improving the ability of managers to take appropriate measures, and improving the authenticity and reliability of the data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118917284A_ABST
    Figure CN118917284A_ABST
Patent Text Reader

Abstract

The invention relates to the technical field of data processing, and provides a weight bill data change recording method and system, terminal equipment and a storage medium, and the method comprises the steps: recording the data of a loaded vehicle during weighing, and generating a weight bill information table comprising key fields; modifying the weight sheet information table, and recording historical version data of the weight sheet information table according to a historical table; a weight bill change report is generated, a weight bill data analysis report is generated according to historical version data of the historical table, and the weight bill data analysis report comprises data integrity and the modification area of the key field; and evaluating the credibility of the weight bill information table according to the weight bill data analysis report. According to the method, effective recording and analysis of the weight bill information are realized, the credibility of the weight bill information is determined by calculating the integrity and modifying the area, and the efficiency and accuracy of weight bill information management are improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method, system, terminal equipment and storage medium for recording weight slip data changes. Background Art

[0002] With the rapid development of the logistics industry, the accuracy and traceability of the weighing bill as one of the important documents in the logistics process are crucial to ensure the transparency of the logistics process and prevent data tampering. However, in actual operations, the weighing bill information may need to be modified for various reasons, such as input errors, business changes, etc. Traditional weighing bill management methods often lack effective records and traceability of these modifications, making it difficult to trace the causes when problems arise. In addition, with the increasing demand for data analysis in enterprise management, the statistics and analysis of weighing bill data are becoming more and more important. However, due to the lack of effective data recording and management mechanisms, traditional weighing bill management methods often find it difficult to meet these needs.

[0003] It is now necessary to establish a complete weighing bill information management system to achieve effective recording and analysis of weighing bill information and improve the efficiency and accuracy of weighing bill information management. Summary of the invention

[0004] In view of the above-mentioned defects, the purpose of the present invention is to propose a method, system, terminal device and storage medium for recording changes in weighing bill data, so as to realize the effective recording and analysis of weighing bill information, determine the credibility of weighing bill information by calculating the integrity and modification area, and improve the efficiency and accuracy of weighing bill information management.

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

[0006] A method for recording changes in weighing slip data, comprising:

[0007] Record the data of the loaded vehicle when it is weighed, and generate a weighing slip information table including key fields;

[0008] Modify the pound bill information table, and record the historical version data of the pound bill information table according to the history table;

[0009] Generate a weight order change report, and generate a weight order data analysis report based on the historical version data of the historical table, wherein the weight order data analysis report includes data integrity and the modified area of ​​the key fields;

[0010] The credibility of the weighing slip information table is evaluated based on the weighing slip data analysis report.

[0011] Preferably, the weighing slip information table includes fields: weighing slip number, shipping unit, receiving unit, factory entry time, factory exit time, license plate number, commodity, driver, gross weight, tare weight, net weight, penalty, receiving quantity and weighing unit;

[0012] Among them, entry time, exit time, license plate number, goods and quantity received are key fields.

[0013] Preferably, the history table includes all fields of the scale invoice information table; the history table also includes fields: modifier, modification time and version number.

[0014] Preferably, generating a weight bill change report includes:

[0015] Obtain the historical version data of the corresponding weight bill information table in the historical table;

[0016] A weight order change report is generated according to the historical version data, wherein the weight order change report includes a change field, a source data field, a plurality of process data fields, a current data field and a keyword field.

[0017] Preferably, the scale order data analysis report also includes: field quantity, time range, field modification quantity, field modification area and key field modification quantity;

[0018] The field modification area is the field modification quantity divided by the field quantity.

[0019] Preferably, the data integrity is the number of unmodified fields divided by the number of fields; the modification area of ​​the key fields is the number of modified key fields divided by the number of fields.

[0020] Preferably, the credibility of the weight slip information table is evaluated as follows: if the data integrity is greater than 80% and the modification area of ​​the key fields is less than 20%, the corresponding weight slip information table is credible, otherwise the corresponding weight slip information table is uncredible.

[0021] A weighing slip data change recording system, comprising:

[0022] An information table generation module is used to record the data when the loaded vehicle is weighed and generate a weighing slip information table including key fields;

[0023] A historical data recording module, used for modifying the pound bill information table and recording the historical version data of the pound bill information table according to the historical table;

[0024] A data analysis module, used for generating a weight order change report, generating a weight order data analysis report according to the historical version data of the historical table, wherein the weight order data analysis report includes data integrity and the modified area of ​​the key fields;

[0025] A data evaluation module is used to evaluate the credibility of the weight bill information table according to the weight bill data analysis report.

[0026] A terminal device comprises: a memory, a processor and a program stored in the memory and executable on the processor, wherein the program is configured to implement the steps of the method for recording changes in weight slip data as described above.

[0027] A storage medium stores a program for recording changes in weight order data. When the program for recording changes in weight order data is executed by a processor, the steps of the method for recording changes in weight order data as described above are implemented.

[0028] One of the above technical solutions has the following advantages or beneficial effects:

[0029] By recording every change in the weighing slip information in detail, the integrity and accuracy of the data can be ensured. The weighing slip change report and data report not only show the data changes, but also analyze the data modification trend and the change frequency of key fields. Each modification has a complete record of the modifier and time, which can easily meet the user's data supervision requirements. Clear data management and recording specifications help to confirm the authenticity and reliability of the data and promote managers to take appropriate improvements and measures. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0031] Figure 1 is a flow chart of a method for recording weight slip data changes provided by an embodiment of the present invention;

[0032] Figure 2 It is a structural schematic diagram of a system for recording weight slip data changes provided by an embodiment of the present invention;

[0033] Figure 3 It is a schematic diagram of a weight slip change report of a weight slip data change recording method provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0034] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and cannot be understood as limiting the present invention.

[0035] In this application, the terms "comprises", "comprising" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprising a ..." does not exclude the presence of other identical elements in the process, method, article or device comprising the element.

[0036] A method for recording changes in weighing slip data, such as Figure 1 As shown, a preferred embodiment of the present application includes:

[0037] Step S1: Record the data of the loaded vehicle when it is weighed, and generate a weighing slip information table including key fields;

[0038] Specifically, when a vehicle loaded with goods or other loads is weighed, the vehicle's weighing data, including time, weight, and corresponding driver information, is recorded, and the information to be recorded is recorded in a weighing slip information table for subsequent recording and analysis of data changes, and key fields are set to provide assistance for data analysis.

[0039] Step S2: modifying the pound bill information table, and recording the historical version data of the pound bill information table according to the history table;

[0040] Specifically, you can manually create and manage backups of historical versions or use the version control or audit function in the database to continuously monitor the weighing order information table. When the weighing order information table is modified, the data before the weighing order information table is modified will be recorded as historical version data. If it is modified twice, two versions of historical version data will be generated to trace the data change history.

[0041] Step S3: Generate a weight order change report, and generate a weight order data analysis report based on the historical version data of the history table, wherein the weight order data analysis report includes data integrity and the modified area of ​​the key fields;

[0042] Specifically, after the scale order is changed, a change report is generated based on the data before and after the change, and the process values ​​before the change will be displayed in the change report, and a scale order data analysis report is generated based on the historical version data. This report intuitively provides users with the extent of data changes in the scale order, especially the integrity of the data and the modification of key fields, provides key decision support information, and helps identify data changes and potential problems.

[0043] Step S4: Evaluate the credibility of the weighing bill information table according to the weighing bill data analysis report.

[0044] Specifically, based on the results of the weighing order data analysis report, users can evaluate the credibility and accuracy of the weighing order information table data, and can conduct quantitative or qualitative evaluations based on the indicators in the data analysis report or formulate evaluation standards and processes for regular review and verification. For example, if the data integrity is within a certain range, the staff needs to verify the authenticity of the data and the reasons for the data changes, make accurate decisions in a timely manner, improve the trust in data use, and ensure the compliance and accuracy of the data.

[0045] Furthermore, the weighing slip information table includes fields: weighing slip number, shipping unit, receiving unit, factory entry time, factory exit time, license plate number, commodity, driver, gross weight, tare weight, net weight, penalty, receiving quantity and weighing unit;

[0046] Among them, entry time, exit time, license plate number, goods and quantity received are key fields.

[0047] Specifically, the weighing slip number is a unique identifier of a weighing slip in the system, which distinguishes and identifies different weighing slip records, ensuring that each weighing slip has a unique identifier so that data confusion and conflict do not occur. The shipping unit and the receiving unit show the source and destination of the goods, helping to record and trace the flow of goods; the entry time and the exit time are used to describe the changes in the weighing slip data during this period, and the license plate number and the driver's record ensure that each weighing corresponds to the correct means of transport and driver for subsequent responsibility tracking and contact; it is used to identify the specific type of goods or product name for goods, so as to accurately record and handle. Among them, the gross weight is the total weight of the vehicle and the goods, the tare weight is the weight of the vehicle itself, the net weight is the actual weight of the goods, the penalty is used to record possible additional fees or fines, and the weighing unit identifies the specific unit or location where the weighing operation is performed. Among them, the entry time, the exit time, the license plate number, the goods and the quantity of goods received are key fields. The accurate record of the harvested quantity is crucial to ensure the correct loading and unloading and delivery of goods, and provides an important basis for subsequent data analysis and business decisions.

[0048] In this embodiment, the history table includes all the fields of the scale invoice information table; the history table also includes the fields: modifier, modification time and version number.

[0049] Specifically, the modifier is the user or operator who performs the modification of the weighing order information table data, and records who modified the weighing order information for responsibility tracing and operation logs. The modification time is the timestamp of the modification of the weighing order information table, which records the exact time when the weighing order information is modified, and is used for auditing, tracing, and confirmation of data consistency. The version number is the version identifier of the weighing order information table, which can be a number or a string that can uniquely identify different versions, and is used to distinguish and track different versions of the weighing order information table. Each time the weighing order information is modified, the version number will be updated accordingly to track historical changes and support data recovery and version management. These additional fields are very important for establishing a complete historical record. They not only record the changes in the weighing order information itself, but also record the time and executor of these changes. In this way, data transparency, traceability, and compliance can be ensured, while supporting data analysis and auditing needs.

[0050] In another preferred embodiment of the present application, the generating of the weight bill change report comprises:

[0051] Obtain the historical version data of the corresponding weight bill information table in the historical table;

[0052] A weight order change report is generated according to the historical version data, wherein the weight order change report includes a change field, a source data field, a plurality of process data fields, a current data field and a keyword field.

[0053] Specifically, first, obtain the historical version data related to the weighing bill information table from the history table. These historical version data include various fields of the weighing bill information table, such as factory entry time, factory exit time, license plate number, commodity, quantity of goods received, etc., as well as additional fields of modifier, modification time and version number. The weighing bill change report needs to clearly list the fields that have changed. These fields represent the data items that have changed between different historical versions. For example, if the factory entry time is different in two historical versions, the factory entry time is a change field. The source data field refers to the data in the weighing bill information table when it has not been modified. The field value of the process data field is an additional information field generated based on the historical version data. These fields are usually used to record or calculate the intermediate values ​​in the process of change. Users can clearly see how the data has changed. The current data field refers to the latest data item in the weighing bill information table. These fields show the weighing bill information in the current state. Marking whether the key field in the report provides an important basis for subsequent data analysis and business decision-making.

[0054] Furthermore, the scale order data analysis report also includes: number of fields, time range, number of field modifications, field modification area and number of key field modifications;

[0055] The field modification area is the field modification quantity divided by the field quantity.

[0056] Specifically, the number of fields is the total number of fields present in the weighing slip data. Each field corresponds to a specific data item of the weighing slip information, such as the time of entry into the factory, the time of leaving the factory, the license plate number, the name of the product, etc. The time range is the time period covered by the weighing slip data, and the time range of the present embodiment is the time difference between the time of leaving the factory and the time of entry into the factory. The number of field modifications is the number of fields whose field values ​​have changed within the time range, and the field modification area is a ratio, which is calculated by dividing the number of field modifications by the number of fields. This ratio can reflect the degree to which the fields in the weighing slip data have been modified. If the field modification area is high, it means that the data changes frequently, a large number of data updates have been made, and the credibility of the data is reduced.

[0057] Further, the data integrity is the number of unmodified fields divided by the number of fields;

[0058] The modification area of ​​the key field is the number of key field modifications divided by the number of fields.

[0059] Specifically, Figure 3 This is a weighing slip change report of an embodiment of the present application, and its weighing slip information table is weighing slip number: BD202406050001, shipping unit: Guangdong XX Company, receiving unit: Beijing XX Company, factory entry time: 2024-06-01 12:12:11, factory departure time: 2024-06-01 13:12:11, license plate number: Guangdong BGS034, commodity: sand and gravel, driver: Zhang San, gross weight: 15, tare: 2, net weight: 13, penalty: 0.01, received quantity: 12.99, weighing unit: ton;

[0060] The historical table data corresponding to the weighing order information table is weighing order number: BD202406050001, shipping unit: Shanghai XX Company, receiving unit: Guangxi XX Company, factory entry time: 2024-06-01 12:12:11, factory departure time: 2024-06-01 13:12:11, license plate number: Yue E1234, 4, commodity: sand and gravel, driver: Li Si, gross weight: 15.1, tare: 2, net weight: 13.1, penalty: 0.01, received quantity: 13.09, weighing unit: tons, version number: 1;

[0061] Weighing slip number: BD202406050001, shipping unit: Nanjing XX Company, receiving unit: Beijing XX Company, entry time: 2024-06-01 12:12:11, leaving factory time: 2024-06-01 13:12:11, license plate number: Yue E1235, commodity: sand and gravel, driver: Li Si, gross weight: 15.2, tare weight: 2.1, net weight: 13.1, penalty: 0.01, quantity received: 12.99, weighing unit: tons version number: 2.

[0062] The number of fields in the pound order data analysis report is 14, the number of field modifications is 7, the time range is 2024-06-01 12:12:11 to 2024-06-01 13:12:11, and the data integrity is (number of fields - number of field modifications) / number of fields, that is Field modification area is Similarly, the number of key field modifications is 4, and the key field modification area is 28.57%.

[0063] Furthermore, in this embodiment, the credibility of the weight slip information table is evaluated as follows: if the data integrity is greater than 80% and the modification area of ​​the key fields is less than 20%, the corresponding weight slip information table is credible, otherwise the corresponding weight slip information table is uncredible.

[0064] For the above example, the data integrity is 50% and the modified area of ​​key fields is 28.57%. If the data integrity is less than 80% and the modified area of ​​key fields exceeds 20%, the weight order information table is considered unreliable, indicating that the data changes frequently or there are many data anomalies, and further data cleaning, verification or investigation may be required.

[0065] like Figure 2 As shown, the embodiment of the present invention also provides a system for recording weight bill data changes, including:

[0066] An information table generation module is used to record the data when the loaded vehicle is weighed and generate a weighing slip information table including key fields;

[0067] A historical data recording module, used for modifying the pound bill information table and recording the historical version data of the pound bill information table according to the historical table;

[0068] A data analysis module, used for generating a weight order change report, generating a weight order data analysis report according to the historical version data of the historical table, wherein the weight order data analysis report includes data integrity and the modified area of ​​the key fields;

[0069] A data evaluation module is used to evaluate the credibility of the weight bill information table according to the weight bill data analysis report.

[0070] This embodiment implements the method and implementation process of recording the change of the scale data. Please refer to the above embodiments and will not be described in detail here.

[0071] In addition, an embodiment of the present invention further proposes a terminal device, which includes a memory, a processor, and a program stored in the memory and executable on the processor, wherein the program is configured to implement the steps of the weight slip data change recording method as described above.

[0072] Since the program is configured to implement the steps of the weight slip data change recording method as described above, the program at least has all the beneficial effects brought about by all the technical solutions of all the aforementioned embodiments, which will not be described one by one here.

[0073] In addition, an embodiment of the present application also proposes a computer-readable storage medium, on which a weight order data change recording program is stored. When the weight order data change recording program is executed by a processor, the steps of the weight order data change recording method described above are implemented.

[0074] Since all the technical solutions of all the aforementioned embodiments are adopted when this weight slip data change recording program is executed by the processor, it has at least all the beneficial effects brought by all the technical solutions of all the aforementioned embodiments, which will not be described one by one here.

[0075] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "illustrative embodiments", "examples", "specific examples", or "some examples" means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0076] Although the embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the claims and their equivalents.

Claims

1. A method for recording changes in weighing slip data, characterized in that: include: Record the data of the loaded vehicle when it is weighed, and generate a weighing slip information table including key fields; Modify the pound bill information table, and record the historical version data of the pound bill information table according to the history table; Generate a weight order change report, and generate a weight order data analysis report based on the historical version data of the historical table, wherein the weight order data analysis report includes data integrity and the modified area of ​​the key fields; The credibility of the weighing slip information table is evaluated based on the weighing slip data analysis report.

2. The method for recording weight slip data changes according to claim 1, characterized in that: The weighing slip information table includes fields: weighing slip number, shipping unit, receiving unit, factory entry time, factory exit time, license plate number, commodity, driver, gross weight, tare weight, net weight, penalty, receiving quantity and weighing unit; Among them, entry time, exit time, license plate number, goods and quantity received are key fields.

3. The method for recording weight slip data changes according to claim 2, characterized in that: The history table includes all fields of the scale information table; The history table also includes fields: modifier, modification time and version number.

4. The method for recording weight slip data changes according to claim 1, characterized in that: The generation of the weight bill change report includes: Obtain the historical version data of the corresponding weight bill information table in the historical table; A weight order change report is generated according to the historical version data, wherein the weight order change report includes a change field, a source data field, a plurality of process data fields, a current data field and a keyword field.

5. The method for recording weight slip data changes according to claim 1, characterized in that: The scale data analysis report also includes: field quantity, time range, field modification quantity, field modification area and key field modification quantity; The field modification area is the field modification quantity divided by the field quantity.

6. The method for recording weight slip data changes according to claim 5, characterized in that: The data integrity is the number of unmodified fields divided by the number of fields; The modification area of ​​the key field is the number of key field modifications divided by the number of fields.

7. The method for recording weight slip data changes according to claim 6, characterized in that: The credibility of the weight slip information table is evaluated specifically as follows: if the data integrity is greater than 80% and the modified area of ​​the key fields is less than 20%, the corresponding weight slip information table is credible, otherwise the corresponding weight slip information table is uncredible.

8. A weighing bill data change recording system, characterized in that: include: An information table generation module is used to record the data when the loaded vehicle is weighed and generate a weighing slip information table including key fields; A historical data recording module, used for modifying the pound bill information table and recording the historical version data of the pound bill information table according to the historical table; A data analysis module, used for generating a weight order change report, generating a weight order data analysis report according to the historical version data of the historical table, wherein the weight order data analysis report includes data integrity and the modified area of ​​the key fields; A data evaluation module is used to evaluate the credibility of the weight bill information table according to the weight bill data analysis report.

9. A terminal device, characterized in that: The terminal device comprises: a memory, a processor and a program stored in the memory and executable on the processor, wherein the program is configured to implement the steps of the method for recording changes in weight slip data as described in any one of claims 1 to 7.

10. A storage medium, characterized in that: The storage medium stores a weight slip data change recording program, and when the weight slip data change recording program is executed by the processor, the steps of the weight slip data change recording method as described in any one of claims 1 to 7 are implemented.