Intelligent verification method and system for automatic import of order file

Abstract

The application discloses an intelligent verification method and system for automatic import of order files, and the method comprises the following steps: a third-party intelligent verification system is built, wherein the third-party intelligent verification system comprises an order file import library, a fund file import library, a file auditing library and a data verification library; a set of imported transaction order files is obtained based on the order file import library; a set of imported fund files is obtained based on the fund file import library; the two sets of files are transferred to the file auditing library for auditing, and according to a first auditing result, the files that pass the auditing are imported into an order formal table and a fund formal table; meanwhile, the two sets of files are transferred to the data verification library for intelligent verification within a predetermined time.

Description

Technical Field

[0001] This invention relates to the field of data verification, and in particular to an intelligent verification method and system for automatically importing order files. Background Technology

[0002] With the widespread adoption of the internet, various consumer platforms across industries are emerging, changing people's consumption habits. Car owner service platforms, which provide services to car consumers, typically focus on offering genuine, professional, and efficient services to simplify car maintenance. Online, through mini-programs, official websites, and telephone, users can enjoy a wide range of car-related services, including car washes, maintenance, chauffeur services, and annual inspections. Offline, they maintain close partnerships with well-known banks and insurance companies through external verification code services. These external verification code services involve directly providing information about the car owner service platform's physical stores to third parties, integrating these stores into their systems, and then allowing users to place orders through these systems while the car owner service platform's stores provide the relevant car services.

[0003] However, existing technologies suffer from the problem of relying solely on tedious manual calculations of monetary data in massive order files, requiring the verification of large amounts of data. This not only consumes manpower but is also prone to errors, thus reducing the efficiency of monetary data verification and processing. Summary of the Invention

[0004] The purpose of this invention is to provide an intelligent verification method and system for automatically importing order files, in order to solve the technical problem in the prior art that relying solely on manual calculation of monetary data in massive order files requires the verification of a large amount of data, which is not only labor-intensive but also prone to errors, thus reducing the efficiency of monetary data verification.

[0005] In view of the above problems, the present invention provides an intelligent verification method and system for automatically importing order files.

[0006] In a first aspect, the present invention provides an intelligent reconciliation method for automatically importing order files. The method is implemented through an intelligent reconciliation system for automatically importing order files. The method includes: building a third-party intelligent reconciliation system for a target project, wherein the third-party intelligent reconciliation system includes an order file import library, a fund file import library, a file review library, and a data reconciliation library; importing a set of transaction order files for the target project into a transaction order import table based on the order file import library to obtain a set of imported transaction order files; importing a set of fund files for the target project into a fund file import table based on the fund file import library to obtain a set of imported fund files; transferring the set of imported transaction order files and the set of imported fund files to the file review library for review to generate a first review result; according to the first review result, importing the approved files from the set of imported transaction order files into a formal order table, and importing the approved files from the set of imported fund files into a formal fund table; transferring the formal order table and the formal fund table to the data reconciliation library, and performing timed intelligent reconciliation of the data in the formal order table and the formal fund table based on a preset reconciliation time.

[0007] On the other hand, the present invention also provides an intelligent verification system for automatically importing order files, used to execute an intelligent verification method for automatically importing order files as described in the first aspect, wherein the system includes: a first building unit, the first building unit being used to build a third-party intelligent verification system for the target project, wherein the third-party intelligent verification system includes an order file import library, a fund file import library, a file review library, and a data verification library; a first import unit, the first import unit being used to import a set of transaction order files of the target project into a transaction order import table based on the order file import library, thereby obtaining a set of imported transaction order files; and a second import unit, the second import unit being used to import the fund files of the target project based on the fund file import library. The system is as follows: A first transfer unit transfers the imported transaction order file set and the imported fund file set to the file review database for review, generating a first review result; a third import unit imports the approved files from the imported transaction order file set into the formal order table and the approved files from the imported fund file set into the formal fund table, based on the first review result; a first reconciliation unit transfers the formal order table and the formal fund table to the data reconciliation database, and performs timed intelligent reconciliation of the data in the formal order table and the formal fund table based on a preset reconciliation time.

[0008] Thirdly, the present invention also provides an intelligent verification system for automatic import of order documents, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps of the method described in the first aspect above.

[0009] Fourthly, an electronic device, comprising a processor and a memory;

[0010] This memory is used for storage;

[0011] The processor is used to execute the method described in any one of the first aspects above by means of a call.

[0012] Fifthly, a computer program product comprising a computer program and / or instructions that, when executed by a processor, implement the steps of the method described in any of the first aspects above.

[0013] One or more technical solutions provided in this invention have at least the following technical effects or advantages:

[0014] By building a third-party intelligent verification system, including an order file import library, a funds file import library, a document review library, and a data verification library, the system obtains a set of imported transaction order files and a set of imported funds files based on the order file import library. Both are then transferred to the document review library for review. Based on the first review result, approved files are imported into the official order table, and approved files are imported into the official funds table. Simultaneously, both are transferred to the data verification library for intelligent verification at a predetermined time. Through the effective connection between the order file import library, funds file import library, document review library, and data verification library, the system allows for searching funds files based on order files, eliminating the need for bidirectional data searches. This enables accurate location and rapid retrieval of verification data from either order or funds files, achieving precise positioning and rapid searching of monetary data from massive order files. It avoids the tediousness and errors of manual calculations, saving manpower and resources while achieving intelligent verification of funds data for external verification code orders. This improves data processing efficiency and enhances the user experience for efficient car owner services.

[0015] The above description is merely an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention and to implement it in accordance with the contents of the specification, and in order to make the above and other objects, features and advantages of the present invention more apparent and understandable, specific embodiments of the present invention are described below. Attached Figure Description

[0016] To more clearly illustrate the technical solutions in this invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are merely exemplary. For those skilled in the art, other drawings can be obtained based on the provided drawings without creative effort.

[0017] Figure 1 This is a flowchart illustrating an intelligent verification method for automatically importing order files according to the present invention.

[0018] Figure 2 This is a schematic diagram illustrating the process of performing timed intelligent reconciliation of data in the formal order table and the formal funds table in an intelligent reconciliation method for automatic import of order files according to the present invention.

[0019] Figure 3 This is a schematic diagram illustrating the process of comparing the amounts in the order data set and the funds data set in an intelligent reconciliation method for automatic import of order files according to the present invention.

[0020] Figure 4 This is a schematic diagram of the structure of an intelligent verification system for automatic import of order files according to the present invention;

[0021] Figure 5 This is a schematic diagram of the structure of an exemplary electronic device of the present invention.

[0022] Explanation of reference numerals in the attached figures:

[0023] First assembly unit 11, first import unit 12, second import unit 13, first transfer unit 14, third import unit 15, first verification unit 16, bus 300, receiver 301, processor 302, transmitter 303, memory 304, bus interface 305. Detailed Implementation

[0024] This invention provides an intelligent verification method and system for automatically importing order files. It solves the technical problem in existing technologies where tedious manual calculations of monetary data from massive order files are required, necessitating extensive data verification. This is not only labor-intensive but also prone to errors, reducing the efficiency of monetary data verification. Based on the effective connection between the order file import library, the funds file import library, the file review library, and the data verification library, it searches for funds files from the order file dimension, eliminating the need for bidirectional data searches. This allows for accurate location and rapid retrieval of monetary data from either the order file or the funds file dimension, achieving precise positioning and rapid searching of monetary data from massive order files. It avoids the tediousness and errors of manual calculations, saving manpower and resources while enabling intelligent verification of funds data for orders with external verification codes. This improves data processing efficiency and enhances the user experience for efficient car owner services.

[0025] The acquisition, storage, use, and processing of data in the technical solution of this invention all comply with the relevant provisions of national laws and regulations.

[0026] The technical solutions of the present invention will now be clearly and completely described with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of them. It should be understood that the present invention is not limited to the exemplary embodiments described herein. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative effort are within the scope of protection of the present invention. It should also be noted that, for ease of description, only the parts related to the present invention are shown in the accompanying drawings, not all of them.

[0027] This invention provides an intelligent reconciliation method for automatically importing order files. The method is applied to an intelligent reconciliation system for automatically importing order files. The method includes: building a third-party intelligent reconciliation system for a target project, wherein the third-party intelligent reconciliation system includes an order file import library, a fund file import library, a file review library, and a data reconciliation library; importing a set of transaction order files for the target project into a transaction order import table based on the order file import library to obtain an imported set of transaction order files; importing a set of fund files for the target project into a fund file import table based on the fund file import library to obtain an imported set of fund files; transferring the imported set of transaction order files and the imported set of fund files to the file review library for review to generate a first review result; according to the first review result, importing the approved files from the imported set of transaction order files into a formal order table, and importing the approved files from the imported set of fund files into a formal fund table; transferring the formal order table and the formal fund table to the data reconciliation library, and performing timed intelligent reconciliation of the data in the formal order table and the formal fund table based on a preset reconciliation time.

[0028] After introducing the basic principles of the present invention, various non-limiting embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

[0029] Example 1

[0030] Please see the appendix Figure 1 This invention provides an intelligent verification method for automatically importing order files. The method is applied to an intelligent verification system for automatically importing order files, and specifically includes the following steps:

[0031] Step S100: Build a third-party intelligent verification system for the target project, wherein the third-party intelligent verification system includes an order file import library, a fund file import library, a file review library, and a data verification library;

[0032] Specifically, with the comprehensive development of IoT technology, online, users can enjoy a wide range of car-related services, including car washing, maintenance, chauffeur services, and annual vehicle inspections, through channels such as mini-programs, official websites, and telephone. Offline, close cooperation is maintained with some well-known banks and insurance companies through external verification code services. External verification code services involve financial transactions, such as the number of orders placed at stores, the cost of these services, and whether the funds have been deposited into the car owner's service account. Third-party systems provide order files and fund files. Verification here involves matching the order number in the order file with the order number in the fund file to see if their amounts match. If they match, the transaction is verified; otherwise, it's partially verified or not verified. Initially, this required tedious manual calculations and verification of large amounts of data, which was not only labor-intensive but also prone to errors. To solve this problem, this application proposes an external verification code order fund verification function, which can easily resolve these issues.

[0033] Specifically, intelligent verification of business transactions can be achieved based on a third-party intelligent verification system. This system includes an order file import library, a funds file import library, a document review library, and a data verification library. The target project is currently popular car owner services. The order file import library imports order data for car owner services, the funds file import library imports funds data for car owner services, the document review library reviews the imported order and funds data, and the data verification library verifies the approved data. This progressive and interconnected process enables intelligent verification of order files for car owner services.

[0034] Step S200: Based on the order file import library, import the set of transaction order files for the target project into the transaction order import table to obtain the set of imported transaction order files;

[0035] Specifically, when importing the transaction order file set of the target project based on the order file import library, the transaction order file set contains the following information: merchant order number, product order number, product name, store name, purchase amount, order mobile phone number, license plate number, order completion time, product category, coupon number, order status, file type, etc. This data represents important information such as when the user of the third-party system purchased services at which Chefuli store, at which time, and what services. During the import process, the data is validated to check whether the merchant order number and product order number are duplicated in the system, only orders with a completed status are allowed to be imported, and whether the order amount and time format are correct. After successful import, the imported transaction order file set is obtained and stored in the transaction order import table. Simultaneously, the number of successfully imported records and the number of failed imports are calculated.

[0036] Step S300: Based on the fund file import library, import the fund file set of the target project into the fund file import table to obtain the imported fund file set;

[0037] Specifically, when importing the target project's set of funds files based on the aforementioned funds file import library, the set of funds files includes the following information: merchant order number, product order number, product quantity, total order amount, total settlement amount, and file type. This data indicates which order numbers the third-party system used to make payments to the car owner service platform. During the import process, the data is validated to ensure the order amounts are correct. Duplicate merchant order numbers and product order numbers in the funds files are not checked, as one order file may correspond to multiple funds files. After successful import, the imported funds file set is obtained and stored in the funds file import table. Simultaneously, the number of successfully imported files and the number of failed imports are calculated.

[0038] Step S400: Transfer the imported transaction order file set and the imported fund file set to the file review library for review, and generate the first review result;

[0039] Step S500: Based on the first review result, import the approved files from the imported transaction order file set into the formal order form, and import the approved files from the imported funds file set into the formal funds form;

[0040] Specifically, after obtaining the set of imported transaction order files and the set of imported fund files, they can be reviewed. Specifically, the set of imported transaction order files and the set of imported fund files can be transferred to the file review library for review. That is, successfully imported transaction orders and fund files will be transferred to the file review system for review by relevant personnel. These files can be downloaded and imported, thereby generating the first review result. The first review result includes two scenarios: if there is data that failed to import, the reason for the failure will be displayed; if the data is deemed acceptable, the review is successful; otherwise, the review fails.

[0041] If the review is successful, the approved files from the imported transaction order file set can be imported into the official order table, and the transaction order data will be added to the official order table; similarly, the approved files from the imported funds file set can be imported into the official funds table, and the funds data will be added to the official funds table. It should be noted that the data in both the official order table and the official funds table consists of only approved data, facilitating subsequent verification of approved data.

[0042] Step S600: Transfer the formal order table and the formal funds table to the data verification database, and perform timed intelligent verification of the data in the formal order table and the formal funds table based on the preset verification time.

[0043] Furthermore, after performing timed intelligent reconciliation of the data in the formal order table and the formal funds table, the process further includes step S700:

[0044] Step S710: Obtain the first intelligent verification result;

[0045] Step S720: Display and export the first intelligent verification result in the background.

[0046] Specifically, after importing the approved data, further verification is performed. Specifically, the official order form and the official funds form can be transferred to the data verification database. Based on a preset verification time, which can be customized to a specific time point, the form data in the data verification database is verified. For example, the system will start a scheduled task to verify funds, which is executed at 1 p.m. every day to perform scheduled intelligent verification of the data in the official order form and the official funds form.

[0047] After performing timed intelligent reconciliation on the data in the official order table and the official funds table, the reconciliation results need to be visualized. That is, based on the first intelligent reconciliation result, the data is displayed and exported in the background. Specifically, the background can display and export the data in the reconciliation table into Excel report data according to the order type (funds file or order file), order completion time, and reconciliation status.

[0048] Based on the effective connection between the order file import library, the funds file import library, the file review library, and the data verification library, the system finds funds files by order file dimension, eliminating the need for bidirectional data searches. This makes it capable of finding verification data from either the order file dimension or the funds file dimension, achieving accurate location and rapid search of monetary data in massive order files. It avoids the tediousness and errors of manual calculation, saving manpower and resources while realizing intelligent verification of funds data for external verification code orders. This improves data processing efficiency and enhances the user experience of efficient car owner services.

[0049] Furthermore, such as Figure 2 As shown, the step S600 of performing timed intelligent reconciliation of the data in the formal order table and the formal funds table includes:

[0050] Step S610: The data reconciliation database is embedded with reconciliation tables and file configuration tables;

[0051] Step S620: Loop through the formal order table, import the data from the formal order table into the reconciliation table, and initialize the reconciliation categories;

[0052] Step S630: Iterate through the formal funds table, import the data from the formal funds table into the write-off table, and initialize the write-off categories;

[0053] Step S640: Perform intelligent verification of the imported data based on the imported data in the file configuration table and the verification table.

[0054] Specifically, when performing timed intelligent reconciliation of data in the formal order table and the formal funds table, it can be based on the reconciliation table and file configuration table in the data reconciliation library. Specifically, the reconciliation table includes order number, reconciliation amount, unreconciled amount, order time, file type, and reconciliation status, etc.; there is also a file configuration table, which configures the relationship between order file type and fund file type, as well as the file type. Different third parties will have different relationships.

[0055] Furthermore, the formal order table can be iterated through, and the data in the formal order table can be imported into the reconciliation table. That is, the data in the formal order transaction table is iterated, and the unimported data is put into the reconciliation table one by one. Each time the data is put in place, a mark is added to the order transaction table indicating that it has been imported. At the same time, the reconciliation categories are initialized. That is, at the beginning, the reconciliation amount is uniformly set to 0, the unreconciled amount is uniformly set to the purchase amount, and the reconciliation status is uniformly set to unreconciled.

[0056] Furthermore, the formal funds table can be iterated through, and the data in the formal funds table can be imported into the reconciliation table. That is, the formal funds table is iterated, and unimported data is added to the reconciliation table one by one. Each time data is added, a mark indicating import is made on the formal funds table. Simultaneously, the reconciliation categories are initialized; initially, the reconciliation amount is uniformly set to 0, the unreconciled amount is uniformly set to the settlement amount, and the reconciliation status is uniformly set to unreconciled. Finally, based on the file configuration table and the imported data in the reconciliation table, intelligent reconciliation of the imported data is achieved.

[0057] Furthermore, such as Figure 3 As shown, step S640 includes:

[0058] Step S641: Loop through the file configuration table to extract the order-file type;

[0059] Step S642: Obtain the order type code corresponding to the order-file type;

[0060] Step S643: Based on the order type code, traverse the unredeemed data in the reconciliation table to extract the order data set;

[0061] Step S644: Perform a second loop on the file configuration table to extract the fund-file type and obtain the fund type code corresponding to the fund-file type;

[0062] Step S645: Based on the fund type code, traverse the unrecovered data in the write-off table to extract the fund data set;

[0063] Step S646: Compare the amounts in the order data set and the funds data set, and perform intelligent reconciliation based on the comparison results.

[0064] Specifically, the file configuration table is the core algorithm for order funds. By looping through the file configuration table, the order-file type can be extracted. That is, the data whose file type is order is first taken out, and then the order type code corresponding to the order-file type is obtained. After obtaining the type code, the unredeemed data in the reconciliation table is traversed according to the order type code. That is, the data with this file type code that has not been redeemed is taken out from the reconciliation table, so as to obtain the transaction order data set, that is, the order data set.

[0065] Then, the file configuration table is looped twice to extract the fund-file type, that is, to take out the data whose file type is fund, and then to obtain the fund type code corresponding to the fund-file type. Then, based on the fund type code, the unredeemed data in the reconciliation table is traversed, that is, the data with this fund type code that has not been reconciled and has the same order number as the merchant is taken out from the reconciliation table, so that the fund data set is extracted.

[0066] Finally, by comparing the amounts in the extracted order data set and the fund data set, intelligent verification of the order amounts is achieved.

[0067] Furthermore, the step S646, which compares the amounts in the order data set and the funds data set, includes:

[0068] Step S6461: Obtain the first order data in the order data set, and obtain the first funds data in the funds data set according to the order number of the first order data;

[0069] Step S6462: Determine whether the purchase amount of the first order data is equal to the settlement amount of the first funds data;

[0070] Step S6462-a1: If the purchase amount of the first order data is equal to the settlement amount of the first funds data, call the first reconciliation instruction;

[0071] Step S6462-a2: According to the first reconciliation instruction, set the first order data and the first funds data to the reconciliation status, and the reconciliation amount corresponds to the purchase amount and the settlement amount.

[0072] Specifically, when comparing the amounts in the order data set and the funds data set, the first order data in the order data set can be obtained. The first order data can be understood as the order data of a certain user in a third-party system. Then, the order number corresponding to the first order data is obtained. At the same time, based on the order number of the first order data, the first funds data in the funds data set is obtained. The first funds data is the related fund flow of the first order data, because one order file may correspond to multiple funds files.

[0073] Furthermore, it is determined whether the purchase amount of the first order data is equal to the settlement amount of the first funds data, that is, whether the purchase amount of the user's applied order service is consistent with the settlement amount of the actual order service. If the purchase amount of the first order data is equal to the settlement amount of the first funds data, it means that the user has fully paid for the applied order service amount. Then, according to the first cancellation instruction, the first order data and the first funds data can be set to the cancellation status. At the same time, the cancellation amount is set to the corresponding purchase amount and settlement amount, and the uncancelled amount is set to 0. For example, if the user's applied order service purchase amount is 500 yuan, and the user has actually paid 500 yuan, then the purchase amount and settlement amount in this order service are both set to the cancellation status, and there is no uncancelled amount, that is, the uncancelled amount is set to 0.

[0074] Furthermore, step S6462, which involves determining whether the purchase amount of the first order data is equal to the settlement amount of the first funds data, further includes:

[0075] Step S6462-b1: If the purchase amount of the first order data is greater than the settlement amount of the first fund data, call the second reconciliation instruction;

[0076] Step S6462-b2: According to the second write-off instruction, set the first fund data to the write-off status, and the write-off amount corresponds to the settlement amount;

[0077] Step S6462-b3: Set the first order data to a partially cleared status, and the uncleared amount corresponds to the difference between the purchase amount and the cleared amount.

[0078] Specifically, if the purchase amount of the first order data is greater than the settlement amount of the first funds data, it indicates that the user has not fully paid for the applied order service amount. Therefore, according to the second reconciliation instruction, the first funds data can be set to a reconciled state, with the reconciled amount corresponding to the settlement amount, and the unreconciled amount set to 0. Alternatively, the first order data can be set to a partially reconciled state, where the reconciled amount equals the purchase amount minus the total settlement amount of all funds, and the unreconciled amount corresponds to the difference between the purchase amount and the reconciled amount. For example, if the user's applied order service purchase amount is 500 yuan, but the user has actually paid 300 yuan and has not fully paid for the service, the funds data, i.e., the paid 300 yuan, can be set to a reconciled state, with the reconciled amount being the paid 300 yuan. Similarly, if there is still 200 yuan unpaid, the corresponding order data, i.e., the 500 yuan that needs to be paid, can be set to a partially reconciled state, with the unreconciled 200 yuan being the difference between the purchase amount of 500 yuan and the reconciled amount of 300 yuan.

[0079] Furthermore, step S6462, which involves determining whether the purchase amount of the first order data is equal to the settlement amount of the first funds data, further includes:

[0080] Step S6462-c1: If the purchase amount of the first order data is less than the settlement amount of the first fund data, call the third reconciliation instruction;

[0081] Step S6462-c2: According to the third reconciliation instruction, set the first order data to a reconciled status, and the reconciliation amount corresponds to the purchase amount;

[0082] Step S6462-c3: Accumulate the settlement amount of the first fund data until the target accumulated amount is obtained;

[0083] Step S6462-c4: Compare the target accumulated amount with the purchase amount, and perform intelligent reconciliation based on the comparison result.

[0084] Specifically, if the purchase amount of the first order data is less than the settlement amount of the first fund data, it means that the user has overpaid for the applied order service amount on the basis of full payment. Here, the overpayment is explained with 500 yuan as an example. Then, according to the third cancellation instruction, the first order data can be set to the cancellation status, and the cancellation amount corresponds to the purchase amount of 500 yuan, which is the amount of service that needs to be purchased.

[0085] For the financial data, the settlement amounts of the first financial data can be accumulated until a target accumulated amount is obtained. That is, the settlement amounts are accumulated one by one until they are greater than or equal to the purchase amount of the transaction order of 500 yuan. After that, the financial data is marked, and all financial data before the accumulation is set as written off. Then, the target accumulated amount and the purchase amount are compared. That is, the marked financial data is compared with the previously accumulated amount and the purchase amount of the order. If they are equal, it is set as written off; if they are less than, it is set as partially written off. All subsequent financial data marked as written off are set as unwritten off.

[0086] In summary, the intelligent verification method for automatic import of order files provided by this invention has the following technical effects:

[0087] 1. By building a third-party intelligent verification system, including an order file import library, a funds file import library, a document review library, and a data verification library; based on the order file import library, a set of imported transaction order files is obtained; based on the funds file import library, a set of imported funds files is obtained; both are transferred to the document review library for review, and based on the first review result, the approved files are imported into the official order table, and the approved files are imported into the official funds table; simultaneously, both are transferred to the data verification library for intelligent verification at a scheduled time. Based on the effective connection between the order file import library, funds file import library, document review library, and data verification library, funds files are located by order file dimension, eliminating the need for bidirectional data searches. This allows for accurate location and rapid retrieval of verification data from either the order or funds file dimension, achieving precise positioning and rapid searching of monetary data in massive order files. This avoids the tediousness and errors of manual calculation, saving manpower and resources while realizing intelligent verification of funds data for external verification code orders, improving data processing efficiency and providing users with a more efficient experience in car owner services.

[0088] 2. By classifying and comparing the purchase amount of order data and the settlement amount of financial data, three situations are identified: the purchase amount of order data and the settlement amount of financial data are equal; the purchase amount of order data is greater than the settlement amount of financial data; and the purchase amount of order data is less than the settlement amount of financial data. Then, a single reconciliation is performed on the data in each situation, which meets the requirements of fast, accurate and intelligent reconciliation of order data.

[0089] Example 2

[0090] Based on the intelligent verification method for automatically importing order files described in the foregoing embodiments, and using the same inventive concept, this invention also provides an intelligent verification system for automatically importing order files. Please refer to the appendix. Figure 4 The system includes:

[0091] The first construction unit 11 is used to build a third-party intelligent verification system for the target project, wherein the third-party intelligent verification system includes an order file import library, a fund file import library, a file review library, and a data verification library.

[0092] The first import unit 12 is used to import the set of transaction order files of the target project into the transaction order import table based on the order file import library, so as to obtain the set of imported transaction order files.

[0093] The second import unit 13 is used to import the set of funds files of the target project into the fund file import table based on the fund file import library, so as to obtain the set of imported fund files.

[0094] The first transfer unit 14 is used to transfer the imported transaction order file set and the imported fund file set to the file review library for review and generate a first review result;

[0095] The third import unit 15 is used to import the approved files from the imported transaction order file set into the formal order form and the approved files from the imported fund file set into the formal fund form, based on the first review result.

[0096] The first verification unit 16 is used to transfer the formal order table and the formal funds table to the data verification database, and to perform timed intelligent verification of the data in the formal order table and the formal funds table based on a preset verification time.

[0097] Furthermore, the system also includes:

[0098] The first embedding unit is used to embed a reconciliation table and a file configuration table into the data reconciliation database;

[0099] The fourth import unit is used to loop through the formal order table, import the data in the formal order table into the reconciliation table, and initialize the reconciliation categories.

[0100] The fifth import unit is used to traverse the formal funds table, import the data in the formal funds table into the write-off table, and initialize the write-off categories.

[0101] The second verification unit is used to perform intelligent verification of the imported data based on the file configuration table and the imported data in the verification table.

[0102] Furthermore, the system also includes:

[0103] The first extraction unit is used to loop through the file configuration table and extract the order-file type;

[0104] The first obtaining unit is used to obtain the order type code corresponding to the order-file type;

[0105] The second extraction unit is used to traverse the unredeemed data in the reconciliation table based on the order type code and extract the order data set.

[0106] The third extraction unit is used to perform a second loop on the file configuration table to extract the fund-file type and obtain the fund type code corresponding to the fund-file type;

[0107] The fourth extraction unit is used to traverse the unrecovered data in the write-off table based on the fund type code to extract a set of fund data.

[0108] The first comparison unit is used to compare the amounts in the order data set and the funds data set, and to perform intelligent verification based on the comparison results.

[0109] Furthermore, the system also includes:

[0110] The second obtaining unit is used to obtain the first order data in the order data set, and to obtain the first funds data in the funds data set according to the order number of the first order data;

[0111] The first judgment unit is used to determine whether the purchase amount of the first order data is equal to the settlement amount of the first funds data.

[0112] The first calling unit is used to call the first reconciliation instruction if the purchase amount of the first order data is equal to the settlement amount of the first funds data.

[0113] The first setting unit is configured to set the first order data and the first funds data to a cancelled status according to the first cancellation instruction, wherein the cancelled amount corresponds to the purchase amount and the settlement amount.

[0114] Furthermore, the system also includes:

[0115] The second calling unit is used to call the second reconciliation instruction if the purchase amount of the first order data is greater than the settlement amount of the first funds data.

[0116] The second setting unit is used to set the first fund data to a written-off status according to the second write-off instruction, and the write-off amount corresponds to the settlement amount.

[0117] The third setting unit is used to set the first order data to a partially cleared state, and the uncleared amount corresponds to the difference between the purchase amount and the cleared amount.

[0118] Furthermore, the system also includes:

[0119] The third calling unit is used to call the third reconciliation instruction if the purchase amount of the first order data is less than the settlement amount of the first funds data.

[0120] The fourth setting unit is used to set the first order data to a verified status according to the third verification instruction, and the verification amount corresponds to the purchase amount;

[0121] The first accumulation unit is used to accumulate the settlement amount of the first fund data until the target accumulated amount is obtained.

[0122] The second matching unit is used to compare the target accumulated amount with the purchase amount, and to perform intelligent reconciliation based on the comparison result.

[0123] Furthermore, the system also includes:

[0124] The third obtaining unit is used to obtain the first intelligent verification result;

[0125] The first output unit is used to display and export the first intelligent verification result in the background.

[0126] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on its differences from other embodiments. Figure 1The intelligent verification method and specific example for automatically importing order documents in Embodiment 1 are also applicable to the intelligent verification system for automatically importing order documents in this embodiment. Through the foregoing detailed description of the intelligent verification method for automatically importing order documents, those skilled in the art can clearly understand the intelligent verification system for automatically importing order documents in this embodiment. Therefore, for the sake of brevity, it will not be described in detail here. As for the apparatus disclosed in the embodiments, since it corresponds to the method disclosed in the embodiments, the description is relatively simple; relevant details can be found in the method section.

[0127] The above description of the disclosed embodiments enables those skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the invention is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

[0128] Exemplary electronic devices

[0129] The following is for reference. Figure 5 The electronic device of the present invention is described below.

[0130] Figure 5 The figure shows a schematic diagram of the structure of an electronic device according to the present invention.

[0131] Based on the inventive concept of the intelligent verification method for automatically importing order documents in the foregoing embodiments, the present invention also provides an intelligent verification system for automatically importing order documents, which stores a computer program that, when executed by a processor, implements the steps of any of the methods of the intelligent verification method for automatically importing order documents described above.

[0132] Among them, Figure 5 In this document, a bus architecture (represented by bus 300) is used. Bus 300 may include any number of interconnected buses and bridges, linking various circuits including one or more processors represented by processor 302 and memory represented by memory 304. Bus 300 may also link various other circuits such as peripheral devices, voltage regulators, and power management circuits, which are well known in the art and therefore will not be described further herein. Bus interface 305 provides an interface between bus 300 and receiver 301 and transmitter 303. Receiver 301 and transmitter 303 may be the same element, i.e., a transceiver, providing a unit for communicating with various other devices over a transmission medium.

[0133] The processor 302 is responsible for managing the bus 300 and general processing, while the memory 304 can be used to store the data used by the processor 302 when performing operations.

[0134] This invention provides an intelligent reconciliation method for automatically importing order files. The method is applied to an intelligent reconciliation system for automatically importing order files. The method includes: building a third-party intelligent reconciliation system for a target project, wherein the third-party intelligent reconciliation system includes an order file import library, a fund file import library, a file review library, and a data reconciliation library; importing a set of transaction order files for the target project into a transaction order import table based on the order file import library to obtain an imported set of transaction order files; importing a set of fund files for the target project into a fund file import table based on the fund file import library to obtain an imported set of fund files; transferring the imported set of transaction order files and the imported set of fund files to the file review library for review to generate a first review result; according to the first review result, importing the approved files from the imported set of transaction order files into a formal order table, and importing the approved files from the imported set of fund files into a formal fund table; transferring the formal order table and the formal fund table to the data reconciliation library, and performing timed intelligent reconciliation of the data in the formal order table and the formal fund table based on a preset reconciliation time. Based on the effective connection between the order file import library, the funds file import library, the file review library, and the data verification library, the system finds funds files by order file dimension, eliminating the need for bidirectional data searches. This makes it capable of finding verification data from either the order file dimension or the funds file dimension, achieving accurate location and rapid search of monetary data in massive order files. It avoids the tediousness and errors of manual calculation, saving manpower and resources while realizing intelligent verification of funds data for external verification code orders. This improves data processing efficiency and enhances the user experience of efficient car owner services.

[0135] The present invention also provides an electronic device, wherein the device includes a processor and a memory;

[0136] This memory is used for storage;

[0137] The processor is used to execute the method described in any one of the above embodiments by means of a call.

[0138] The present invention also provides a computer program product, including a computer program and / or instructions, which, when executed by a processor, implement the steps of the method described in any of the above embodiments.

[0139] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, apparatus, or computer program products. Therefore, the present invention can take the form of a completely software embodiment, a completely hardware embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention is in the form of a computer program product executable on one or more computer-usable storage media containing computer-usable program code. Such computer-usable storage media include, but are not limited to, various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), disk storage, compact disc read-only memory (CD-ROM), and optical storage.

[0140] This invention is described with reference to flowchart illustrations and / or block diagrams of the methods, apparatus (systems), and computer program products of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing device, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A system that specifies functions in one or more boxes.

[0141] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including an instruction set implemented in a process. Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0142] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the functions specified in one or more boxes. Although preferred embodiments of the invention have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments.

[0143] Obviously, those skilled in the art can make various modifications and variations to this invention without departing from its spirit and scope. Therefore, if these modifications and variations fall within the scope of this invention and its equivalents, this invention also intends to include these modifications and variations.

Claims

1. A smart verification method for automatically importing order files, characterized in that, The method includes: Build a third-party intelligent verification system for the target project, wherein the third-party intelligent verification system includes an order file import library, a fund file import library, a file review library, and a data verification library; Based on the order file import library, import the set of transaction order files for the target project into the transaction order import table to obtain the set of imported transaction order files; Based on the aforementioned fund file import library, import the set of fund files for the target project into the fund file import table to obtain the set of imported fund files; The imported transaction order file set and the imported fund file set are transferred to the file review library for review, and a first review result is generated; Based on the first review result, the files that have passed the review in the imported transaction order file set are imported into the formal order form, and the files that have passed the review in the imported funds file set are imported into the formal funds form. The formal order form and the formal funds form are transferred to the data verification database. Based on the preset verification time, the data in the formal order form and the formal funds form are intelligently verified on a regular schedule. The step of performing timed intelligent reconciliation of the data in the formal order table and the formal funds table includes: The data reconciliation database is embedded with reconciliation tables and file configuration tables; The formal order table is looped through, and the data in the formal order table is imported into the reconciliation table. The reconciliation categories are also initialized. The formal funds table is iterated through and the data in the formal funds table is imported into the write-off table, and the write-off categories are initialized. Based on the imported data in the file configuration table and the reconciliation table, intelligent reconciliation is performed on the imported data. The method includes: Loop through the file configuration table to extract the order-file type; Obtain the order type code corresponding to the order-file type; Based on the order type code, the unredeemed data in the reconciliation table is traversed to extract the order data set. The file configuration table is looped twice to extract the fund-file type and obtain the fund type code corresponding to the fund-file type; Based on the fund type code, the unrecovered data in the write-off table is traversed to extract the fund data set. The amounts in the order data set and the fund data set are compared, and intelligent reconciliation is performed based on the comparison results; The comparison of amounts in the order data set and the funds data set includes: Obtain the first order data from the order data set, and obtain the first funds data from the funds data set based on the order number of the first order data; Determine whether the purchase amount of the first order data is equal to the settlement amount of the first funds data; If the purchase amount of the first order data is equal to the settlement amount of the first funds data, invoke the first reconciliation instruction; According to the first write-off instruction, the first order data and the first funds data are set to the write-off status, and the write-off amount corresponds to the purchase amount and the settlement amount; The step of determining whether the purchase amount of the first order data is equal to the settlement amount of the first funds data includes: If the purchase amount of the first order data is greater than the settlement amount of the first funds data, the second reconciliation instruction is invoked. According to the second write-off instruction, the first fund data is set to a write-off status, and the write-off amount corresponds to the settlement amount; The first order data is set to a partially cleared status, and the uncleared amount corresponds to the difference between the purchase amount and the cleared amount; The step of determining whether the purchase amount of the first order data is equal to the settlement amount of the first funds data further includes: If the purchase amount of the first order data is less than the settlement amount of the first fund data, the third reconciliation instruction is invoked. According to the third reconciliation instruction, the first order data is set to a reconciled status, and the reconciliation amount corresponds to the purchase amount; The settlement amounts of the first set of funds data are summed up until the target summation amount is obtained; The target cumulative amount is compared with the purchase amount, and intelligent reimbursement is performed based on the comparison result.

2. The method as described in claim 1, characterized in that, The step of periodically and intelligently reconciling the data in the formal order table and the formal funds table includes: Obtain the first intelligent verification result; The first intelligent verification result is displayed and exported in the background.

3. An intelligent verification system for automatically importing order documents, characterized in that, The system is used to execute the intelligent verification method for automatically importing order files according to any one of claims 1 to 2, the system comprising: The first building unit is used to build a third-party intelligent verification system for the target project, wherein the third-party intelligent verification system includes an order file import library, a fund file import library, a file review library, and a data verification library; The first import unit is used to import the set of transaction order files of the target project into the transaction order import table based on the order file import library, thereby obtaining the set of imported transaction order files. The second import unit is used to import the set of funds files of the target project into the fund file import table based on the fund file import library, so as to obtain the set of imported fund files. The first transfer unit is used to transfer the imported transaction order file set and the imported fund file set to the file review library for review and generate a first review result; The third import unit is used to import the approved files from the imported transaction order file set into the formal order form, and to import the approved files from the imported fund file set into the formal fund form, based on the first review result. The first verification unit is used to transfer the formal order table and the formal funds table to the data verification database, and to perform timed intelligent verification of the data in the formal order table and the formal funds table based on a preset verification time.

4. An electronic device, characterized in that, Including processor and memory; The memory is used for storage; The processor is configured to execute the method of any one of claims 1 to 2 by means of a call.

5. A computer program product, comprising a computer program and / or instructions, characterized in that, When the computer program and / or instructions are executed by a processor, they implement the steps of the method described in any one of claims 1 to 2.

Images