Data processing method and device based on financial system and electronic equipment
By obtaining and processing multiple financial transaction table links in the financial system, data inconsistency and reconciliation errors caused by complex loan fund trading links are solved, and full-cycle reconciliation and abnormal data are timely discovered, improving data Processing efficiency and customer satisfaction.
Patent Information
- Application Number
- CN202411156456.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-21
- Publication Date
- 2024-11-15
AI Technical Summary
The transaction links of loan funds in the existing financial system are complex, resulting in inconsistent data and errors in reconciliation, increasing the workload of the financial department and the risk of customer complaints, affecting customer satisfaction and the reputation of financial institutions.
A data processing method based on the financial system is proposed. By acquiring multiple financial transaction tables, performing link processing, receiving data processing tasks created by users, and processing data reconciliation information based on the transaction processing link, and discovering abnormal data in a timely manner. And display abnormal information and qualified information in the system.
The full-cycle reconciliation has been achieved, which reduces human errors, improves data processing efficiency, promptly detects abnormal data, reduces the risk of customer complaints, and improves the accuracy and efficiency of reconciliation.
Smart Images

Figure CN118967320A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of financial technology, and in particular to a data processing method, device and electronic equipment based on a financial system. Background Art
[0002] At present, there are many and complex links in the fund transaction based on loans. Common operations include loan disbursement, repayment, exemption, interest refund, transfer, repurchase, and account offset. The fields involving customer amounts include principal, interest, penalty interest, compound interest, liquidated damages, default penalty interest, and many other fields. This leads to complex program code logic, many database tables and fields, and it is easy to have data cross-checks between tables in the past, and reconciliation often leads to misalignment of amount fields and missing data. Inconsistent data will make the reconciliation process complicated and time-consuming, increase the workload of the finance department, and reduce work efficiency. In addition, when abnormal situations occur in the loan fund transaction, such as inconsistent data, reconciliation errors, or operational errors, the risk of customer complaints will increase significantly. These complaints not only affect customer satisfaction, but may also have a negative impact on the reputation and business of financial institutions. Summary of the invention
[0003] The main purpose of the embodiments of the present application is to propose a data processing method, device and electronic equipment based on a financial system, which can realize full-cycle reconciliation and timely discover abnormal data.
[0004] To achieve the above-mentioned purpose, a first aspect of an embodiment of the present application proposes a data processing method based on a financial system, the method comprising: Acquire a plurality of financial transaction tables of the financial system, wherein each of the financial transaction tables includes at least one fund item; Performing link processing on all the financial transaction tables to obtain transaction processing links; Receiving, through the financial system, a data processing task created by a user, and obtaining the to-be-reconciled account information of the data processing task; Performing data processing on the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result; When the processing result is that at least one of the fund items is abnormal, abnormal information is generated, and qualified information in the processing result is determined; The abnormal information and the qualified information are displayed in the financial system.
[0005] In some embodiments, the financial transaction table includes a promissory note table, a bill table, a bill document table, an account balance table, and an account detail table; and link processing is performed on all the financial transaction tables to obtain a transaction processing link, including: Acquire a first fund item set of the loan note table, a second fund item set of the bill table, a third fund item set of the bill document table, a fourth fund item set of the account balance table, and a fifth fund item set of the account details table; comparing the first fund item set, the second fund item set, the third fund item set, the fourth fund item set, and the fifth fund item set to determine an association relationship among the financial transaction tables; The loan note table, the bill table, the bill document table, the account balance table and the account detail table are sorted according to the association relationship to obtain a transaction processing link.
[0006] In some embodiments, comparing the first fund item set, the second fund item set, the third fund item set, the fourth fund item set, and the fifth fund item set to determine the association relationship of the financial transaction table includes: Determine a first primary key and a first foreign key of the first fund item set, a second primary key and a second foreign key of the second fund item set, a third primary key and a third foreign key of the third fund item set, a fourth primary key and a fourth foreign key of the fourth fund item set, and determine a fifth primary key and a fifth foreign key of the fifth fund item set; determining a dependency relationship between the financial transaction tables according to the first primary key, the first foreign key, the second primary key, the second foreign key, the third primary key, the third foreign key, the fourth primary key, the fourth foreign key, the fifth primary key, and the fifth foreign key; Performing data integrity check on all the financial transaction tables based on the dependency relationship; When all the financial transaction tables pass the data integrity test, the association relationship of the financial transaction tables is determined according to the dependency relationship.
[0007] In some embodiments, the financial transaction table includes a promissory note table, a bill table, a bill document table, an account balance table, and an account detail table; and the data processing of the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result includes: Determine the target account corresponding to the to-be-reconciled information; Update the debit note table and the bill table in the transaction processing link according to the information to be reconciled, and record the bill flow information in the information to be reconciled; Update the bill document table according to the bill flow information; Generate a deduction request according to the updated loan note table, the bill table and the bill document table; Performing a deduction operation on the target account based on the deduction request to obtain a deduction result; Update the account balance table and the account details table according to the deduction result; The updated loan note table, the bill table, the bill document table, the account balance table and the account detail table are compared to obtain a processing result.
[0008] In some embodiments, the information comparison of the updated loan note table, the bill table, the bill document table, the account balance table, and the account detail table to obtain the processing result includes: Obtaining the updated first financial field of the loan note table, the second financial field of the bill table, the third financial field of the bill document table, the fourth financial field of the account balance table, and the fifth financial field of the account details table; The first financial field, the second financial field, the third financial field, the fourth financial field, and the fifth financial field are compared with preset amount item information to obtain a processing result.
[0009] In some embodiments, when the processing result is that at least one of the fund items is abnormal, generating abnormal information includes: When the processing result is that at least one of the fund items is abnormal, determining the target financial transaction table of the fund item with the abnormality; The target financial transaction table is added to a preset abnormal registration table, and abnormal information is generated according to the target financial transaction table.
[0010] In some embodiments, after adding the target financial transaction table to a preset abnormal registration table and generating abnormal information according to the target financial transaction table, the method further includes: Determining the management personnel information associated with the abnormal registration form; The abnormal information is sent to the manager corresponding to the manager information.
[0011] To achieve the above-mentioned purpose, a second aspect of an embodiment of the present application proposes a data processing device based on a financial system, the device comprising: A data acquisition module, configured to acquire a plurality of financial transaction tables of the financial system, wherein each of the financial transaction tables includes at least one capital item; A link processing module, used to perform link processing on all the financial transaction tables to obtain a transaction processing link; A task receiving module, used to receive a data processing task created by a user through the financial system, and obtain the to-be-reconciled account information of the data processing task; A data processing module, used to process the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result; An information determination module, configured to generate abnormal information when the processing result indicates that at least one of the fund items is abnormal, and determine qualified information in the processing result; An information display module is used to display the abnormal information and the qualified information in the financial system.
[0012] To achieve the above-mentioned purpose, the third aspect of an embodiment of the present application proposes an electronic device, an electronic device comprising a memory and a processor, the memory storing a computer program, and the processor implementing the data processing method based on the financial system as described in the first aspect when executing the computer program.
[0013] To achieve the above objectives, the fourth aspect of an embodiment of the present application proposes a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the data processing method based on the financial system as described in the first aspect.
[0014] The data processing method, device, electronic device and storage medium based on the financial system proposed in the present application first obtain multiple financial transaction tables of the financial system, then link process all financial transaction tables to obtain transaction processing links, thereby formulating a complete financial reconciliation process, and then directly reconciling according to the transaction processing links, saving time and effort, and then receiving the data processing tasks created by the user through the financial system, and obtaining the to-be-reconciled information of the data processing tasks, and then processing the to-be-reconciled information of the data processing tasks according to the transaction processing links, so as to compare the to-be-reconciled information in the order of the transaction processing links, and realize the full-cycle reconciliation of the to-be-reconciled information, and can monitor the reconciliation warning for the maximum range of each fund item to obtain the processing result, when the processing result is that at least one fund item is abnormal, abnormal information is generated, and the abnormal data can be compared through the transaction processing links to timely discover the abnormal data and determine the qualified information in the processing result, and finally, the abnormal information and qualified information are displayed in the financial system to realize the comprehensive display of the financial data, which is convenient for R&D personnel to timely analyze and troubleshoot the causes, and can quickly process the abnormal information to avoid the expansion of the scope of subsequent problems. BRIEF DESCRIPTION OF THE DRAWINGS
[0015] Figure 1 is a flow chart of a data processing method based on a financial system provided in an embodiment of the present application; Figure 2 yes Figure 1 Flow chart of step S102 in FIG. Figure 3 yes Figure 2 Flow chart of step S202 in FIG. Figure 4 yes Figure 1 Flow chart of step S104 in FIG. Figure 5 yes Figure 4 Flow chart of step S407 in FIG. Figure 6 is a specific flow chart of generating abnormal information provided by an embodiment of the present application; Figure 7 is a specific flow chart of a data processing method based on a financial system provided by another embodiment of the present application; Figure 8 is a structural diagram of a data processing device based on a financial system provided in an embodiment of the present application; Fig. 9 It is a schematic diagram of the hardware structure of the electronic device provided in the embodiment of the present application. DETAILED DESCRIPTION
[0016] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0017] It should be noted that, although the functional modules are divided in the device schematic diagram and the logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first", "second", etc. in the specification, claims and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence.
[0018] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein are only for the purpose of describing the embodiments of this application and are not intended to limit this application.
[0019] First, some nouns involved in this application are analyzed: Natural Language Processing (NLP): NLP uses computers to process, understand, and apply human languages (such as Chinese, English, etc.). NLP is a branch of artificial intelligence and an interdisciplinary subject between computer science and linguistics. It is often referred to as computational linguistics. Natural language processing includes grammatical analysis, semantic analysis, and text understanding. Natural language processing is commonly used in technical fields such as machine translation, handwritten and printed character recognition, speech recognition and text-to-speech conversion, information intent recognition, information extraction and filtering, text classification and clustering, public opinion analysis, and opinion mining. It involves data mining related to language processing, machine learning, knowledge acquisition, knowledge engineering, artificial intelligence research, and linguistic research related to language computing.
[0020] Based on this, the embodiments of the present application provide a data processing method and device, an electronic device and a storage medium based on a financial system, which can realize full-cycle reconciliation and timely discover abnormal data.
[0021] The data processing method and device based on the financial system, electronic device and storage medium provided in the embodiments of the present application are specifically illustrated through the following embodiments. First, the data processing method based on the financial system in the embodiments of the present application is described.
[0022] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Artificial Intelligence (AI) is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.
[0023] The basic technologies of artificial intelligence generally include sensors, dedicated artificial intelligence chips, cloud computing, distributed storage, big data processing technology, operation / interaction systems, mechatronics, etc. Artificial intelligence software technologies mainly include computer vision technology, robotics technology, biometrics technology, module management technology of online meeting systems, natural language processing technology, and machine learning / deep learning.
[0024] The data processing method based on the financial system provided in the embodiment of the present application relates to the field of data processing technology. The data processing method based on the financial system provided in the embodiment of the present application can be applied to the terminal, can also be applied to the server side, and can also be software running in the terminal or the server side. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, etc.; the server side can be configured as an independent physical server, or it can be configured as a server cluster or a distributed system composed of multiple physical servers, and can also be configured as a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application that implements a data processing method based on a financial system, etc., but is not limited to the above forms.
[0025] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments, in which tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media including storage devices.
[0026] It should be noted that in each specific implementation of the present application, when it comes to the need to perform relevant processing based on data related to user identity or characteristics such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first, and the collection, use, and processing of these data will comply with the relevant laws, regulations, and standards of the relevant countries and regions. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.
[0027] At present, there are many and complex links in the fund transaction based on loans. Common operations include loan disbursement, repayment, exemption, interest refund, transfer, repurchase, and account offset. The fields involving customer amounts include principal, interest, penalty interest, compound interest, liquidated damages, default penalty interest, and many other fields. This leads to complex program code logic, many database tables and fields, and it is easy to have data cross-checks between tables in the past, and reconciliation often leads to misalignment of amount fields and missing data. Inconsistent data will make the reconciliation process complicated and time-consuming, increase the workload of the finance department, and reduce work efficiency. In addition, when abnormal situations occur in the loan fund transaction, such as inconsistent data, reconciliation errors, or operational errors, the risk of customer complaints will increase significantly. These complaints not only affect customer satisfaction, but may also have a negative impact on the reputation and business of financial institutions.
[0028] In order to solve the above problems, this embodiment provides a data processing method, device, electronic device and storage medium based on a financial system. First, multiple financial transaction tables of the financial system are obtained, and then link processing is performed on all financial transaction tables to obtain a transaction processing link, thereby formulating a complete financial reconciliation process. Subsequently, reconciliation can be performed directly according to the transaction processing link, which saves time and effort. After that, the data processing task created by the user is received through the financial system, and the to-be-reconciled information of the data processing task is obtained. Then, data processing is performed on the to-be-reconciled information of the data processing task according to the transaction processing link, so as to compare the to-be-reconciled information in the order of the transaction processing link, and realize the full-cycle reconciliation of the to-be-reconciled information. The reconciliation warning can be monitored for the maximum range of each fund item to obtain the processing result. When the processing result is that at least one fund item is abnormal, abnormal information is generated. By comparing the to-be-reconciled information through the transaction processing link, abnormal data can be discovered in time, and qualified information in the processing result can be determined. Finally, the abnormal information and qualified information are displayed in the financial system to realize a comprehensive display of the financial data, which is convenient for R&D personnel to analyze and troubleshoot the causes in time, and can quickly process the abnormal information to avoid the expansion of the scope of subsequent problems.
[0029] The following is a detailed description with reference to the accompanying drawings.
[0030] Figure 1 is an optional flowchart of a data processing method based on a financial system provided in an embodiment of the present application. Figure 1 The method may include but is not limited to steps S101 to S106.
[0031] Step S101: acquiring a plurality of financial transaction tables of a financial system, wherein each financial transaction table includes at least one fund item.
[0032] In step S101 of some embodiments, multiple financial transaction tables of a financial system are obtained to facilitate subsequent sorting of the multiple financial transaction tables.
[0033] It is understandable that the financial system in the embodiment of the present application can be configured according to the needs of the user. For example, the financial system in the embodiment of the present application can be a corporate financing system, an automobile financial transaction system, an installment payment system, etc., and the embodiment of the present application does not make specific limitations.
[0034] Step S102: perform link processing on all financial transaction tables to obtain transaction processing links.
[0035] In step S102 of some embodiments, link processing is performed on all financial transaction tables to obtain transaction processing links, which facilitates subsequent data comparison in the order of the financial transaction processing links, so that data can flow in each link of the transaction processing link and full-cycle reconciliation can be achieved, thereby improving data processing efficiency and enabling data monitoring and early warning to be achieved within the maximum scope.
[0036] Step S103, receiving the data processing task created by the user through the financial system, and obtaining the to-be-reconciled account information of the data processing task.
[0037] In step S103 of some embodiments, the data processing task created by the user is received through the financial system, and the reconciliation information of the data processing task is obtained. The data processing task is automatically received and processed, which reduces manual intervention and improves efficiency. Directly obtaining the reconciliation information of the data processing task can reduce human errors in the data input and processing process and improve the accuracy of the data.
[0038] Step S104, data processing is performed on the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result.
[0039] In step S104 of some embodiments, data processing is performed on the to-be-reconciled information of the data processing task according to the transaction processing link, so that the details in each financial transaction table can be compared one by one, the data consistency in each financial transaction table can be maintained, data recording errors can be avoided, and the processing results can be obtained.
[0040] Step S105, when the processing result shows that at least one fund item is abnormal, abnormal information is generated and qualified information in the processing result is determined.
[0041] In step S105 of some embodiments, when the processing result is that at least one fund item has an abnormality, it means that the information in the fund item is wrong at this time, and it is necessary to determine the target financial transaction table of the fund item with the abnormality and generate abnormal information. By recording the abnormal information, potential financial risks can be better controlled and managed, and abnormal data can be discovered and problem data can be processed in time, and qualified information in the processing results can be determined, which is convenient for the subsequent display of abnormal information and qualified information.
[0042] Step S106, displaying abnormal information and qualified information in the financial system.
[0043] In step S106 of some embodiments, abnormal information and qualified information are displayed in the financial system to achieve real-time display of abnormal information and qualified information, so that the processing status of the transaction processing link can be monitored in real time, visual management can be achieved, and abnormal information can be discovered in time.
[0044] See also Figure 2 In some embodiments, step S102 may also include but is not limited to steps S201 to S203.
[0045] It should be noted that the financial transaction table includes the IOU table, the bill table, the bill document table, the account balance table and the account details table.
[0046] Step S201, obtain the first fund item set of the loan note table, the second fund item set of the bill table, the third fund item set of the bill document table, the fourth fund item set of the account balance table and the fifth fund item set of the account details table.
[0047] Step S202, comparing the first fund item set, the second fund item set, the third fund item set, the fourth fund item set and the fifth fund item set to determine the association relationship of the financial transaction table.
[0048] Step S203, sorting the loan note table, bill table, bill document table, account balance table and account detail table according to the association relationship to obtain a transaction processing link.
[0049] In steps S201 to S203 of some embodiments, in the process of link processing all financial transaction tables, first, the first fund item set of the debit note table, the second fund item set of the bill table, the third fund item set of the bill document table, the fourth fund item set of the account balance table and the fifth fund item set of the account detail table are obtained, so as to obtain all the fund items of the debit note table, the bill table, the bill document table, the account balance table and the account detail table, and then the first fund item set, the second fund item set, the third fund item set, the fourth fund item set and the fifth fund item set are compared to determine the association relationship of the financial transaction tables, which can ensure that the data remains consistent between different tables and reduce data redundancy and errors. Finally, the debit note table, the bill table, the bill document table, the account balance table and the account detail table are sorted according to the association relationship, so as to form a complete transaction processing chain, which is convenient for subsequent data comparison in the order of the fund transaction processing chain, so that the data can circulate in each link of the transaction processing chain, and the full-cycle reconciliation can be realized, thereby improving the data processing efficiency and realizing the monitoring and early warning of the data to the maximum extent.
[0050] It is worth noting that, taking the example of associating the IOU table, bill table, bill document table, account balance table and account detail table in sequence, the IOU table, bill table, bill document table, account balance table and account detail table are sorted to form a transaction processing chain of IOU table-bill table-bill document table-account balance table-account detail table, that is, subsequent data will pass through the above-mentioned financial transaction tables in the order of the transaction processing chain.
[0051] It can be understood that the IOU table, bill table, bill document table, account balance table and account detail table in the embodiment of the present application all include at least one fund item. Specifically, the IOU table in the embodiment of the present application includes fund items such as the IOU number, principal to be repaid, interest to be repaid, compound interest to be repaid, penalty interest to be repaid, and penalty interest to be repaid for breach of contract; the bill table includes the IOU number, the current principal to be repaid, the current interest to be repaid, the current penalty interest to be repaid, the current compound interest to be repaid, and the current penalty interest to be repaid for breach of contract; the bill document table includes the IOU number, the current principal to be repaid, the current interest to be repaid, the current penalty interest to be repaid, the current compound interest to be repaid, and the current penalty interest to be repaid for breach of contract; the account detail table includes fund items such as the IOU number, account, account debit amount, account credit amount, and the account balance table includes fund items such as the IOU number, account number, account debit balance, account credit balance, and the like.
[0052] Specifically, the bill table in the embodiment of the present application contains the customer's bill summary information, such as the total amount, billing cycle, payment deadline, etc. The bill document table usually records more detailed transaction information, including the specific date, amount, description of goods or services, transaction counterparty, etc. of each transaction. And the bill table is a summary table that displays all bill information within a period of time, and the bill document table is a detailed table that lists each specific transaction record that constitutes the bill.
[0053] See also Figure 3 In some embodiments, step S202 may also include but is not limited to steps S301 to S304.
[0054] Step S301, determine the first primary key and the first foreign key of the first fund item set, the second primary key and the second foreign key of the second fund item set, the third primary key and the third foreign key of the third fund item set, the fourth primary key and the fourth foreign key of the fourth fund item set, and determine the fifth primary key and the fifth foreign key of the fifth fund item set.
[0055] Step S302, determining the dependency relationship between the financial transaction tables according to the first primary key, the first foreign key, the second primary key, the second foreign key, the third primary key, the third foreign key, the fourth primary key, the fourth foreign key, the fifth primary key and the fifth foreign key.
[0056] Step S303: Perform data integrity check on all financial transaction tables based on the dependency relationship.
[0057] Step S304: when all financial transaction tables pass the data integrity check, the association relationship of the financial transaction tables is determined according to the dependency relationship.
[0058] In steps S301 to S304 of some embodiments, in the process of comparing all fund item sets, the embodiments of the present application will first determine the primary key and foreign key of each financial transaction table, and then determine the mapping relationship of each financial transaction table based on the corresponding relationship between the primary key and the foreign key. Specifically, the embodiments of the present application determine the first primary key and the first foreign key of the first fund item set, the second primary key and the second foreign key of the second fund item set, the third primary key and the third foreign key of the third fund item set, the fourth primary key and the fourth foreign key of the fourth fund item set, and determine the fifth primary key and the fifth foreign key of the fifth fund item set, and then determine the mapping relationship of each financial transaction table based on the first primary key, the first foreign key, the second primary key, the second foreign key, the third primary key, the third foreign key, the fourth primary key, the fourth foreign key, the The fifth primary key, fifth primary key and fifth foreign key determine the dependency between financial transaction tables, so as to determine which tables depend on other tables, and further determine whether the dependency of the tables is one-to-one, one-to-many or many-to-one, etc. Afterwards, data integrity detection is performed on all financial transaction tables based on the dependency to ensure that the data in each table is complete. When all financial transaction tables pass the data integrity detection, it means that the data in the financial transaction tables is complete. The association relationship of the financial transaction tables can be determined directly based on the dependency relationship. Through clear association relationships, data consistency between different tables can be ensured, data redundancy and errors can be reduced, and the association relationship can facilitate subsequent complex data analysis.
[0059] See also Figure 4 In some embodiments, step S104 may also include but is not limited to steps S401 to S407.
[0060] Step S401, determining the target account corresponding to the information to be reconciled.
[0061] Step S402: update the debit note table and bill table in the transaction processing link according to the information to be reconciled, and record the bill flow information in the information to be reconciled.
[0062] Step S403: Update the billing document table according to the billing flow information.
[0063] Step S404, generating a deduction request according to the updated loan note table, bill table and bill document table.
[0064] Step S405: deduct money from the target account based on the deduction request to obtain a deduction result.
[0065] Step S406, updating the account balance table and account details table according to the deduction results.
[0066] Step S407, compare the updated loan note table, bill table, bill document table, account balance table and account detail table to obtain the processing result.
[0067] In steps S401 to S407 of some embodiments, in the process of data processing the to-be-reconciled information of the data processing task according to the transaction processing link, first, determine the target account corresponding to the to-be-reconciled information, that is, the account that needs to be deducted, and then update the debit note table and the bill table in the transaction processing link according to the to-be-reconciled information, thereby updating the user's bill and debit note, and record the bill flow information in the to-be-reconciled information, so as to record the transaction amount required in the to-be-reconciled information, and then update the bill document table according to the bill flow information, and then generate a deduction request according to the updated debit note table, bill table and bill document table, so that the financial system can Initiate a deduction for the target account, that is, perform a deduction operation on the target account and obtain the deduction result. Finally, update the account balance table and account detail table according to the deduction result to realize real-time update of the IOU table, bill table, bill document table, account balance table and account detail table, ensure the data consistency of the IOU table, bill table, bill document table, account balance table and account detail table, and finally, compare the information of the updated IOU table, bill table, bill document table, account balance table and account detail table, so as to compare the details in each financial transaction table one by one, maintain the data consistency in each financial transaction table, avoid data recording errors, and obtain the processing result.
[0068] See also Figure 5 In some embodiments, step S407 may also include but is not limited to steps S501 to S502.
[0069] Step S501, obtaining the updated first financial field of the loan note table, the second financial field of the bill table, the third financial field of the bill document table, the fourth financial field of the account balance table, and the fifth financial field of the account details table.
[0070] Step S502: compare the first financial field, the second financial field, the third financial field, the fourth financial field and the fifth financial field with preset amount item information to obtain a processing result.
[0071] In steps S501 to S502 of some embodiments, in the process of comparing the updated loan note table, bill table, bill document table, account balance table and account detail table, the embodiment of the present application will first obtain the financial fields of all updated financial transaction tables, so as to facilitate the subsequent comparison of the content in the financial fields, thereby determining whether the information in the financial transaction table has changed. Specifically, the embodiment of the present application will first obtain the first financial field of the updated loan note table, the second financial field of the bill table, the third financial field of the bill document table, the fourth financial field of the account balance table and the fifth financial field of the account detail table, thereby obtaining the financial fields of different financial transaction tables, and then compare the first financial field, the second financial field, the third financial field, the fourth financial field and the fifth financial field with the preset amount item information to obtain the processing result, so that the details in each financial transaction table can be compared one by one to maintain the data consistency in each financial transaction table.
[0072] It should be noted that the amount item information in the embodiment of the present application can be set according to the user's needs or the attributes of the financial field, and the amount item information corresponding to the financial fields with different attributes or names can be the same or different, and the amount item information corresponding to the financial fields with the same attributes or names must be the same. Specifically, the first financial field is the loan number, the second financial field is the current principal to be repaid, the third financial field is the loan number, the fourth financial field is the current interest to be repaid, and the fifth financial field is the account number. The amount item information at this time needs to be set according to the attributes of different financial fields, that is, the information corresponding to the first financial field is A001, the information corresponding to the second financial field is 1000, the information corresponding to the third financial field is A001, the information corresponding to the fourth financial field is 200, and the information corresponding to the fifth financial field is 15. The setting of the amount item information is not specifically limited in the embodiment of the present application.
[0073] See also Figure 6 , Figure 6 It is a specific flow chart of generating abnormal information provided by an embodiment of the present application. In some embodiments, the method includes but is not limited to steps S601 to S602.
[0074] Step S601: When the processing result is that at least one fund item is abnormal, determine the target financial transaction table of the fund item with the abnormality.
[0075] Step S602: Add the target financial transaction table to a preset abnormal registration table, and generate abnormal information according to the target financial transaction table.
[0076] In steps S601 to S602 of some embodiments, in the process of determining whether there is an abnormality in a fund item, when the processing result is that there is an abnormality in at least one fund item, it is necessary to determine the target financial transaction table of the fund item with the abnormality. For example, when the processing result is that there is an abnormality in the principal to be repaid, the promissory note table is determined to be the target financial transaction table; when the processing result is that there is an abnormality in the account number, the account balance table is determined to be the target financial transaction table, and then the target financial transaction table is added to the preset abnormality registration table. The abnormality registration table can help managers quickly identify abnormal situations in transactions, so that managers can take timely action and generate abnormal information based on the target financial transaction table. By recording abnormal information, potential financial risks can be better controlled and managed, and abnormal data and problem data can be discovered and processed in a timely manner.
[0077] It should be noted that the exception registration table in the embodiment of the present application is used to store abnormal financial data tables, and the specific financial items where the abnormalities occur will be recorded in the exception registration table to facilitate subsequent management personnel to proofread the information and avoid similar problems, further improving the efficiency of the data proofreading process, and the exception registration table helps to ensure the accuracy of all transaction records and reduce errors and omissions.
[0078] See also Figure 7 , Figure 7 It is a specific flow chart of a data processing method based on a financial system provided by another embodiment of the present application. In some embodiments, the method includes but is not limited to steps S701 to S702.
[0079] It should be noted that step S701 to step S702 occur after the target financial transaction table is added to the preset abnormal registration table and abnormal information is generated according to the target financial transaction table.
[0080] Step S701, determining the management personnel information associated with the abnormal registration table.
[0081] Step S702: Send abnormal information to the manager corresponding to the manager information.
[0082] In steps S701 to S702 of some embodiments, after generating exception information according to the target financial transaction table, the embodiments of the present application will also determine the management personnel information associated with the exception registration table, and then send the exception information to the management personnel corresponding to the management personnel information. Among them, the embodiments of the present application can notify the management personnel corresponding to the management personnel information by email, text message, telephone, etc., so that the management personnel can manually check the exception information. By checking the exception information, the reasons for the occurrence of the exception can be analyzed and checked in time, which is convenient for the subsequent rapid repair of the exception and avoids the expansion of the scope of subsequent problems.
[0083] See also Figure 8 The embodiment of the present application further provides a data processing device based on a financial system, the device comprising: The data acquisition module 801 is used to acquire multiple financial transaction tables of the financial system, wherein each financial transaction table includes at least one fund item; The link processing module 802 is used to perform link processing on all financial transaction tables to obtain transaction processing links; The task receiving module 803 is used to receive the data processing task created by the user through the financial system and obtain the to-be-reconciled account information of the data processing task; The data processing module 804 is used to process the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result; The information determination module 805 is used to generate abnormal information when the processing result shows that at least one fund item is abnormal, and determine qualified information in the processing result; The information display module 806 is used to display abnormal information and qualified information in the financial system.
[0084] In some embodiments, the data processing device based on the financial system further includes an information notification module, which is used to determine the management personnel information associated with the abnormal registration table; and send abnormal information to the management personnel corresponding to the management personnel information.
[0085] The specific implementation of the financial system-based data processing device is substantially the same as the specific implementation of the financial system-based data processing method described above, and will not be described in detail herein.
[0086] The embodiment of the present application also provides an electronic device, the electronic device comprising: a memory, a processor, a program stored in the memory and executable on the processor, and a data bus for realizing connection and communication between the processor and the memory, and the program is executed by the processor to realize the above-mentioned data processing method based on the financial system. The electronic device can be any intelligent terminal including a tablet computer, a car computer, etc.
[0087] See also Fig. 9 , Fig. 9 The hardware structure of an electronic device of another embodiment is illustrated, and the electronic device includes: The processor 901 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application; The memory 902 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 902 can store an operating system and other application programs. When the technical solution provided in the embodiment of this specification is implemented by software or firmware, the relevant program code is stored in the memory 902, and the processor 901 calls and executes the data processing method based on the financial system in the embodiment of this application; Input / output interface 903, used to implement information input and output; Communication interface 904, used to realize communication interaction between the device and other devices, which can be realized through wired mode (such as USB, network cable, etc.) or wireless mode (such as mobile network, WIFI, Bluetooth, etc.); A bus 905 that transmits information between various components of the device (e.g., the processor 901, the memory 902, the input / output interface 903, and the communication interface 904); The processor 901 , the memory 902 , the input / output interface 903 and the communication interface 904 are connected to each other in communication within the device via a bus 905 .
[0088] An embodiment of the present application also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the above-mentioned data processing method based on the financial system is implemented.
[0089] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely disposed relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.
[0090] The data processing method, device, electronic device and storage medium based on the financial system provided by the embodiment of the present application first obtain multiple financial transaction tables of the financial system, then link process all financial transaction tables to obtain transaction processing links, thereby formulating a complete financial reconciliation process, and then directly reconciling according to the transaction processing links, saving time and effort, and then receiving the data processing tasks created by the user through the financial system, and obtaining the to-be-reconciled information of the data processing tasks, and then performing data processing on the to-be-reconciled information of the data processing tasks according to the transaction processing links, so as to compare the to-be-reconciled information in the order of the transaction processing links, and realize the full-cycle reconciliation of the to-be-reconciled information, and can monitor the reconciliation warning for the maximum range of each fund item to obtain the processing result, and when the processing result is that at least one fund item is abnormal, abnormal information is generated, and the abnormal data can be compared through the transaction processing links to timely discover the abnormal data and determine the qualified information in the processing result, and finally, the abnormal information and qualified information are displayed in the financial system to realize the comprehensive display of the financial data, which is convenient for R&D personnel to timely analyze and troubleshoot the causes, and can quickly process the abnormal information to avoid the expansion of the scope of subsequent problems.
[0091] The embodiments described in the embodiments of the present application are intended to more clearly illustrate the technical solutions of the embodiments of the present application and do not constitute a limitation on the technical solutions provided in the embodiments of the present application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of the present application are also applicable to similar technical problems.
[0092] It can be understood by those skilled in the art that Figure 1-9 The technical solutions shown in the figure do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than those shown in the figure, or a combination of certain steps, or different steps.
[0093] The device embodiments described above are merely illustrative, and the units described as separate components may or may not be physically separated, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0094] Those skilled in the art will appreciate that all or some of the steps in the methods disclosed above, and the functional modules / units in the systems and devices may be implemented as software, firmware, hardware, or a suitable combination thereof.
[0095] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0096] It should be understood that in the present application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.
[0097] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the above units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.
[0098] The units described above as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0099] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0100] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including multiple instructions to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, referred to as ROM), random access memory (Random Access Memory, referred to as RAM), disk or optical disk and other media that can store programs.
[0101] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but the scope of the rights of the present invention is not limited thereto. Any modification, equivalent substitution and improvement made by a person skilled in the art without departing from the scope and essence of the present invention should be within the scope of the rights of the present invention.
Claims
1. A data processing method based on a financial system, characterized in that: The method comprises: Acquire a plurality of financial transaction tables of the financial system, wherein each of the financial transaction tables includes at least one fund item; Performing link processing on all the financial transaction tables to obtain transaction processing links; Receiving, through the financial system, a data processing task created by a user, and obtaining the to-be-reconciled account information of the data processing task; Performing data processing on the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result; When the processing result is that at least one of the fund items is abnormal, abnormal information is generated, and qualified information in the processing result is determined; The abnormal information and the qualified information are displayed in the financial system.
2. The data processing method based on the financial system according to claim 1, characterized in that: The financial transaction table includes a promissory note table, a bill table, a bill document table, an account balance table and an account detail table; The link processing is performed on all the financial transaction tables to obtain a transaction processing link, including: Acquire a first fund item set of the loan note table, a second fund item set of the bill table, a third fund item set of the bill document table, a fourth fund item set of the account balance table, and a fifth fund item set of the account details table; comparing the first fund item set, the second fund item set, the third fund item set, the fourth fund item set, and the fifth fund item set to determine an association relationship among the financial transaction tables; The loan note table, the bill table, the bill document table, the account balance table and the account detail table are sorted according to the association relationship to obtain a transaction processing link.
3. The data processing method based on the financial system according to claim 2, characterized in that: The comparing the first fund item set, the second fund item set, the third fund item set, the fourth fund item set, and the fifth fund item set to determine the association relationship of the financial transaction table includes: Determine a first primary key and a first foreign key of the first fund item set, a second primary key and a second foreign key of the second fund item set, a third primary key and a third foreign key of the third fund item set, a fourth primary key and a fourth foreign key of the fourth fund item set, and determine a fifth primary key and a fifth foreign key of the fifth fund item set; determining a dependency relationship between the financial transaction tables according to the first primary key, the first foreign key, the second primary key, the second foreign key, the third primary key, the third foreign key, the fourth primary key, the fourth foreign key, the fifth primary key, and the fifth foreign key; Performing data integrity check on all the financial transaction tables based on the dependency relationship; When all the financial transaction tables pass the data integrity check, the association relationship of the financial transaction tables is determined according to the dependency relationship.
4. The data processing method based on the financial system according to claim 1, characterized in that: The financial transaction table includes a loan note table, a bill table, a bill document table, an account balance table and an account detail table; the data processing of the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result includes: Determine the target account corresponding to the to-be-reconciled information; Update the debit note table and the bill table in the transaction processing link according to the information to be reconciled, and record the bill flow information in the information to be reconciled; Update the bill document table according to the bill flow information; Generate a deduction request according to the updated loan note table, the bill table and the bill document table; Performing a deduction operation on the target account based on the deduction request to obtain a deduction result; Update the account balance table and the account details table according to the deduction result; The updated loan note table, the bill table, the bill document table, the account balance table and the account detail table are compared to obtain a processing result.
5. The data processing method based on the financial system according to claim 4, characterized in that: The updated loan note table, the bill table, the bill document table, the account balance table and the account detail table are compared to obtain processing results, including: Obtaining the updated first financial field of the loan note table, the second financial field of the bill table, the third financial field of the bill document table, the fourth financial field of the account balance table, and the fifth financial field of the account details table; The first financial field, the second financial field, the third financial field, the fourth financial field, and the fifth financial field are compared with preset amount item information to obtain a processing result.
6. The data processing method based on the financial system according to claim 1, characterized in that: When the processing result is that at least one of the fund items is abnormal, generating abnormal information includes: When the processing result is that at least one of the fund items is abnormal, determining the target financial transaction table of the fund item with the abnormality; The target financial transaction table is added to a preset abnormal registration table, and abnormal information is generated according to the target financial transaction table.
7. The data processing method based on the financial system according to claim 6, characterized in that: After adding the target financial transaction table to a preset abnormal registration table and generating abnormal information according to the target financial transaction table, the method further includes: Determining the management personnel information associated with the abnormal registration form; The abnormal information is sent to the manager corresponding to the manager information.
8. A data processing device based on a financial system, characterized in that: The device comprises: A data acquisition module, configured to acquire a plurality of financial transaction tables of the financial system, wherein each of the financial transaction tables includes at least one capital item; A link processing module, used to perform link processing on all the financial transaction tables to obtain a transaction processing link; A task receiving module, used to receive a data processing task created by a user through the financial system, and obtain the to-be-reconciled account information of the data processing task; A data processing module, used to process the to-be-reconciled information of the data processing task according to the transaction processing link to obtain a processing result; An information determination module, configured to generate abnormal information when the processing result indicates that at least one of the fund items is abnormal, and determine qualified information in the processing result; An information display module is used to display the abnormal information and the qualified information in the financial system.
9. An electronic device, characterized in that: The electronic device comprises a memory and a processor, the memory stores a computer program, and the processor implements the data processing method based on the financial system as claimed in any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the financial system-based data processing method according to any one of claims 1 to 7 is implemented.
