Movatterモバイル変換


[0]ホーム

URL:


CN108509392B - Multi-agency reconciliation method, system, computer equipment and storage medium - Google Patents

Multi-agency reconciliation method, system, computer equipment and storage medium
Download PDF

Info

Publication number
CN108509392B
CN108509392BCN201810156913.0ACN201810156913ACN108509392BCN 108509392 BCN108509392 BCN 108509392BCN 201810156913 ACN201810156913 ACN 201810156913ACN 108509392 BCN108509392 BCN 108509392B
Authority
CN
China
Prior art keywords
reconciliation
file
standard
file format
format
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Fee Related
Application number
CN201810156913.0A
Other languages
Chinese (zh)
Other versions
CN108509392A (en
Inventor
陈杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
OneConnect Financial Technology Co Ltd Shanghai
Original Assignee
OneConnect Financial Technology Co Ltd Shanghai
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by OneConnect Financial Technology Co Ltd ShanghaifiledCriticalOneConnect Financial Technology Co Ltd Shanghai
Priority to CN201810156913.0ApriorityCriticalpatent/CN108509392B/en
Publication of CN108509392ApublicationCriticalpatent/CN108509392A/en
Application grantedgrantedCritical
Publication of CN108509392BpublicationCriticalpatent/CN108509392B/en
Expired - Fee Relatedlegal-statusCriticalCurrent
Anticipated expirationlegal-statusCritical

Links

Images

Classifications

Landscapes

Abstract

Translated fromChinese

本发明涉及计算机通信领域,特别是涉及多机构对账方法、系统、计算机设备和存储介质。一种多机构对账方法,包括步骤:解析标准对账文件格式;根据标准对账文件格式配置对账模型,从而获取对账结果;根据对账结果动态配置对账结果文件。上述方法实现一次部署,以达到多次复用的效果;对账文件格式要求低,降低客户工作量;利用批量核对方式进行对账,提高对账效率;采用滚动序号对账的方式,提高对账的灵活性,以实现对账要素动态配置和对账结果动态输出等效果。上述对账方法针对传统对账方法进行系统的分析、重构,以高效的完成对账。

Figure 201810156913

The present invention relates to the field of computer communication, in particular to a multi-organization reconciliation method, system, computer equipment and storage medium. A multi-institution reconciliation method, comprising the steps of: parsing a standard reconciliation file format; configuring a reconciliation model according to the standard reconciliation file format to obtain a reconciliation result; dynamically configuring a reconciliation result file according to the reconciliation result. The above method realizes one deployment to achieve the effect of multiple reuse; low requirements for the format of reconciliation files, reducing customer workload; using batch reconciliation for reconciliation to improve reconciliation efficiency; using rolling serial number reconciliation to improve reconciliation. The flexibility of the account is realized to realize the dynamic configuration of the reconciliation elements and the dynamic output of the reconciliation result. The above reconciliation method systematically analyzes and reconstructs the traditional reconciliation method to complete the reconciliation efficiently.

Figure 201810156913

Description

Multi-mechanism account checking method, system, computer equipment and storage medium
Technical Field
The present invention relates to the field of computer communications, and in particular, to a multi-mechanism reconciliation method, system, computer device and storage medium.
Background
The account checking system is a system for checking and verifying relevant data in order to ensure that data records of two parties or a multi-party transaction platform are correct and reliable in a clearing period. With the rapid development of internet finance, more and more services are switched from off-line to on-line, the transaction amount is larger and larger, the transaction scene related to financial affairs is often interacted with a plurality of cores, and a front-end system is connected with the plurality of cores in series to complete one transaction. Therefore, the account checking system has the problems of large transaction amount, complex transaction scene, multiple transaction systems, inconsistent results of one transaction in each core and the like when the interaction between the account checking systems is abnormal.
In addition, the current account checking system mainly has the traditional mode of printing paper account checking bills and single-thread account checking. Traditional printing of paper pairs for bills is a way to be mailed back by post office or confirmed by business customers going to banks for sealing. The mode can not meet the requirement of timely and effectively checking accounts of enterprises in the current society with developed internet. The single-thread account checking mode has limited efficiency, and the next step can be carried out only after the previous step is executed; if the account checking process has problems, the account checking system can inform the file of abnormality, and account checking data can not be restored to an initial state frequently.
Therefore, the reconciliation system needs to check the issued flow, check the consistency and the correctness of the transaction among the systems and derive errors, and the core corresponding to the reconciliation system can carry out reconciliation or replenishment according to the errors so as to solve the problems that the results of one transaction in each core are inconsistent when the transaction systems encounter the abnormal interaction. The invention provides a multi-mechanism account checking method, a multi-mechanism account checking system, computer equipment and a storage medium, which are carried out based on multiple mechanisms, solve the problems that the traditional account checking system only supports a single mechanism, checks running water item by item, has single account checking element and the like, and realize the effects of one-time deployment and repeated reuse. Meanwhile, account checking elements are dynamically configured, and account checking results are dynamically output.
Disclosure of Invention
On the basis, it is necessary to provide a multi-mechanism account checking method, a multi-mechanism account checking system, a computer device and a storage medium for the defects that the traditional account checking system only supports a single mechanism, account checking results are inconsistent in each core, the flow of checking is checked item by item, the efficiency is low, account checking elements are single, and the like.
A multi-mechanism account checking method comprises the following specific steps:
s1: analyzing the standard reconciliation file format; the standard reconciliation file format is a standard format generated after the reconciliation file provided by the reconciliation party is analyzed;
s2: configuring a reconciliation model according to the standard reconciliation file format, and acquiring a reconciliation result;
s3: and dynamically configuring a reconciliation result file according to the reconciliation result.
In one embodiment, the step S1 includes:
s101: generating a task list to be analyzed into a standard reconciliation file format, selecting a service system needing reconciliation, setting an uploading operation interface at the front end of the service system, uploading the reconciliation file needing reconciliation by using the uploading operation interface, and generating the task list to be analyzed into the standard file format in a mode of interface triggering or timing task triggering;
s102: setting an import interface at the front end of the business system, importing a template in a standard reconciliation file format into the business system by using the import interface, and storing the template in a memory;
s103: acquiring corresponding configuration required by a required standard reconciliation format from a reconciliation file to be reconciled according to a standard reconciliation file template stored in a memory;
s104, acquiring a realization logic list for analyzing the standard reconciliation file format according to the task list to be analyzed into the standard reconciliation file format and the configuration;
s105: and executing the implementation logic list, analyzing the account checking file, and acquiring a standard account checking file format.
In one embodiment, the step S2 includes:
s201: generating a reconciliation task list, and generating the reconciliation task list in a timing task triggering mode according to the analyzed standard reconciliation file format;
s202: the account checking model is imported into the business system by using an import interface at the front end of the business system and is stored in a memory of the business system;
s203: selecting a corresponding account checking model according to the generated account checking task list, and acquiring a configuration corresponding to the selected account checking model from the account checking task list;
s204: judging whether a rolling reconciliation mode is adopted or not according to the obtained reconciliation model and the configuration;
s205: and according to the judgment result of the step S204, checking the account by inquiring the account checking task list and acquiring an account checking result.
In one embodiment, the reconciliation model comprises a double-reconcilier full-volume reconciliation, a double-reconcilier rolling reconciliation and a three-reconcilier full-volume reconciliation.
In one embodiment, the step S3 includes:
s301: generating a task list of a dynamic configuration reconciliation result file, and generating the task list of the dynamic configuration reconciliation result file through a timing task triggering mode according to the obtained reconciliation result;
s302: setting an input interface in the business system, and inputting a format requirement of a reconciliation result file of a receiving reconciliation file side by using the input interface;
s303: according to the format requirement, acquiring configuration corresponding to the format requirement from the reconciliation result file;
s304: and dynamically configuring the reconciliation result file and converting the format of the reconciliation result file by inquiring the task list of the dynamically configured reconciliation result file and the acquired configuration, so as to acquire the reconciliation result file.
In one embodiment, the multi-institution reconciliation method further comprises the steps of acquiring multi-institution reconciliation permission, wherein the acquiring multi-institution reconciliation permission is used for registering institution numbers, and the method comprises the following steps: registering the organization number by calling an interface parameter of a service system, wherein the interface parameter is an unique identification ID of the organization;
and the account checking party acquires the organization number after the registration is finished and the unique organization name is marked by the organization generated in the registration request.
In one embodiment, the storage comprises NAS storage and cloud storage.
Based on the same technical concept, the invention also provides a multi-mechanism reconciliation system, which comprises an analysis unit, a reconciliation unit and a dynamic configuration reconciliation result file unit;
the analysis unit is used for analyzing a standard reconciliation file format, and the standard reconciliation file format is used for analyzing a reconciliation file provided by a reconciliation party;
the account checking unit is used for configuring an account checking model according to the standard account checking file format and acquiring an account checking result;
and the dynamic configuration reconciliation result file unit is used for dynamically configuring the format of the reconciliation result file according to the reconciliation result.
Based on the same technical concept, the invention further provides a computer device, which comprises a memory and a processor, wherein the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the multi-mechanism reconciliation method.
Based on the same technical concept, the present invention also provides a storage medium storing computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to perform the steps of the above-mentioned multi-mechanism reconciliation method.
According to the multi-mechanism reconciliation method, the system, the computer equipment and the storage medium, the task list to be analyzed into the standard reconciliation file format is generated, the standard reconciliation file format is imported into the business system by utilizing the import interface on the business system, the corresponding configuration required by the standard reconciliation file format is acquired from the reconciliation file to be reconciled according to the standard reconciliation file format, the path for analyzing the standard reconciliation file format and the realization logic list corresponding to the path are generated through the task list and the configuration, and the realization logic list is executed to acquire the standard reconciliation file format. And generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. And generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring the configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file. Compared with the prior art, the technical scheme has the advantages that when account checking is needed, the account checking file provided by a client can be analyzed into a standard account checking file format according to the multi-mechanism account checking method as long as the corresponding account checking file is provided, an obtained account checking model is obtained according to the standard account checking file format, so that account checking is completed, dynamic output is realized according to the account checking result, the account checking workload is reduced, and the account checking efficiency is improved.
Drawings
FIG. 1 is a flow chart of a multi-mechanism reconciliation method in an embodiment of the present invention;
FIG. 2 is a flow diagram of parsing into a standard reconciliation file format in accordance with an embodiment of the present invention;
FIG. 3 is a flow chart of obtaining reconciliation results in one embodiment of the present invention;
FIG. 4 is a diagram of a reconciliation model in accordance with an embodiment of the present invention;
FIG. 5 is a flow chart of obtaining multi-chassis reconciliation rights in one embodiment of the invention;
FIG. 6 is a flow diagram of dynamically configuring reconciliation result files in accordance with an embodiment of the present invention;
fig. 7 is a schematic diagram of a multi-institution reconciliation system in an embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, an embodiment of the present invention provides a multi-institution reconciliation method, where the multi-institution reconciliation method may include the following steps:
step S1: analyzing the standard reconciliation file format; the method comprises the steps that an account checking file provided by a client is obtained at the front end of the business system, a task list to be analyzed into a standard account checking file format is generated, corresponding configuration is obtained through an imported standard account checking file format template, a path for analyzing the standard account checking file format and a realization logic list corresponding to the path are generated through the task list and the configuration, and the realization logic list is executed to obtain the standard account checking file format;
step S2: configuring a reconciliation model according to the standard reconciliation file format, and acquiring a reconciliation result; generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and required configuration according to the reconciliation task list, completing reconciliation and acquiring a reconciliation result;
step S3: according to the account checking result, dynamically configuring an account checking result file; and generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation file, and acquiring the reconciliation result file.
Fig. 2 is a flowchart of parsing into a standard reconciliation file format according to an embodiment of the present invention, and as shown in fig. 2, the parsing process in step S1 includes generating a task list to be parsed into the standard reconciliation file format, importing the standard reconciliation file format, generating a path for parsing the standard reconciliation file format and an implementation logic list corresponding to the path, and executing the implementation logic list to obtain the standard reconciliation file format. Step S1 may include the following steps:
step S101: generating a task list to be analyzed into a standard reconciliation file format, selecting a service system needing reconciliation, setting an uploading operation interface at the front end of the service system, uploading the reconciliation file needing reconciliation by using the uploading operation interface, and generating the task list to be analyzed into the standard reconciliation file format by using an interface triggering or timing task triggering mode.
The interface triggering mode is a mode of calling triggering by using a peripheral interface. For example, when an external person sends a request, after the multi-mechanism reconciliation method receives the request, a task is triggered according to the request to generate a task list to be parsed into a standard reconciliation file format.
The timing task triggering mode is that the client appoints time. For example, the client reserves seven morning spots, and the multi-mechanism reconciliation method automatically triggers tasks at the seven morning spots reserved to generate a task list to be analyzed into a standard reconciliation file format, so that the tasks do not need to be triggered by using a peripheral interface.
Step S102: setting an import interface at the front end of the business system, importing a standard reconciliation file format template into the business system by using the import interface, and storing the template in a memory; the storage comprises NAS storage and cloud storage.
The NAS, namely a Network Attached Storage (Network Attached Storage), is a data transmission implemented by the Network Storage based on a standard Network protocol. The data is taken as a center, the storage equipment and the server are thoroughly separated, and the data is managed in a centralized manner, so that the bandwidth is released, the performance is improved, the total cost of ownership is reduced, and the investment is protected.
The cloud storage is a concept extended and developed from a cloud computing concept, is an emerging network storage technology, and is a system which integrates various different types of storage devices in a network through application software to cooperatively work only through functions such as cluster application, network technology or a distributed file system and the like, and provides data storage and service access functions to the outside.
Step S103: acquiring corresponding configuration required by a standard reconciliation file format from a reconciliation file required to be reconciled according to a standard reconciliation file format template stored in a memory; the configuration comprises the convention of timing task trigger time, the convention of a reconciliation file format and whether the first line in the reconciliation detail has the total number of strokes and the total number of bars; and a convention for delimiters for each field in the ledger detail.
Step S104: acquiring a logic list for realizing the analysis of the standard reconciliation file format according to the task list to be analyzed into the standard reconciliation file format and the configuration, wherein the logic list comprises: the business system checks whether the account checking file is generated by using the account checking method, and if the account checking file is not generated, the multi-mechanism account checking method stops working; and if the reconciliation file is generated, downloading the reconciliation file to a cloud storage according to the generated reconciliation file, uploading the reconciliation file to an NAS storage for file sharing and data backup, and analyzing the reconciliation file to be analyzed and converting the reconciliation file into a standard reconciliation file format according to the acquired configuration and the standard reconciliation file format. The sequence for implementing the execution logic list comprises informing a client to generate a reconciliation file required to be reconciled;
step S105: executing the implementation logic list for analyzing the standard reconciliation file format, analyzing the reconciliation file, and acquiring the standard reconciliation file format, wherein the implementation logic list comprises the following steps: generating a task list to be analyzed into a standard reconciliation file format in a service system, importing the standard reconciliation file format, generating a path for analyzing the reconciliation file needing reconciliation into the standard reconciliation file format, executing a realization logic list for analyzing the standard reconciliation file format, analyzing the reconciliation file, and acquiring the standard reconciliation file format.
Fig. 3 is a flowchart of obtaining a reconciliation result in an embodiment of the present invention, and as shown in fig. 3, step S2 is to configure a reconciliation model according to the standard reconciliation file format to obtain a reconciliation result; and generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. Step S2 may include the following steps:
step S201: generating a reconciliation task list, and generating the reconciliation task list in a timing task triggering mode according to the analyzed standard reconciliation file format; the timed task triggering mode needs to check accounts according to the time appointed by the client. For example, when a client reserves 7 am, the multi-mechanism reconciliation method can automatically trigger a reconciliation task at the reserved 7 am, so that a peripheral interface is not needed to trigger the task.
Step S202: and importing the account checking model into the business system by using an import interface at the front end of the business system, and placing the account checking model in a memory for storage. The memory comprises an NAS memory, a leading-in interface is arranged on the service system, the account checking model is led into the service system by using the leading-in interface, and the account checking model is placed in the NAS memory for storage.
Step S203: selecting a corresponding account checking model according to the generated account checking task list, and acquiring configuration corresponding to the selected account checking model from the account checking task list, wherein the configuration comprises an agreement on the trigger time of a timing task, an agreement on the format of an account checking file, and whether the first line in the account checking detail has the total number of strokes and the total number of bars; and a convention for delimiters for each field in the ledger detail. And after an account checking model is selected according to the generated account checking task list, acquiring corresponding configuration from the account checking task list according to information such as timing task trigger time, total number and the like.
Step S204: judging whether a rolling reconciliation mode is adopted or not according to the obtained reconciliation model and the configuration; the rolling reconciliation mode is determined by the obtained reconciliation model and configuration, and can be started only when the previous reconciliation is completely finished if the rolling reconciliation mode is adopted; if the rolling reconciliation mode is not adopted, plug-ins with batch insertion function need to be called for warehousing operation, and warehousing operation can be carried out in batches according to a certain quantity. For example, 50 accounting records may be inserted into the warehouse for processing each time. After all the files are inserted into the database, the batch number is used for checking whether the total number in the files is consistent with the total number in the database or not, and if not, error reporting processing is carried out.
Step S205: and according to the account checking model, the configuration and the judgment result of whether a rolling account checking mode is adopted, the account checking task list is inquired, the account checking is completed, and an account checking result is obtained. And after determining whether a rolling reconciliation mode is used or not according to the model and the configuration, reconciliation is carried out by utilizing the reconciliation model so as to obtain a reconciliation result. And after the account checking result is obtained, synchronizing the account checking result into the list table according to the account checking configuration, and updating the state of the collection table. The list represents that the records needing account checking in the aggregation table are combined into one record. And in the aggregation table, the data in the table is in one-to-one correspondence with the data in the reconciliation file.
For example, there are two records in the aggregation table, record A: serial number (0001), amount (100), reference party; b, recording: the serial number (0001), the amount (101) and the account checking party give a record according to the A record and the B record, and the list table gives the account checking, namely the serial number (0001) and the amount (100). And when the amounts in the A record and the B record are different, the multi-mechanism account checking method carries out remark, and the remark is 'please find the reason and process'.
Fig. 4 is a schematic diagram of a reconciliation model in an embodiment of the present invention, and as shown in fig. 4, the reconciliation model includes a double-reconciliation-side full-volume reconciliation, a double-reconciliation-side rolling reconciliation, and a three-reconciliation-side full-volume reconciliation.
Specifically, the double-reconciliation side full-volume reconciliation is that the client a and the client B provide full-volume records every day according to the appointed time and then summarize the records of the client a and the client B. For example, customer A provides a serial number (0002), a monetary amount (2000); the client B provides the serial number (0003) and the amount (3000), and the multi-mechanism reconciliation method can record and reconcile the total amount according to the information provided by the client A and the client B.
Specifically, the rolling reconciliation of the double reconciliation parties comprises the following specific steps: acquiring a reconciliation sequence number, wherein the reconciliation sequence number can determine whether the reconciliation sequence number needs to be provided according to the requirements of the multi-mechanism reconciliation method; discarding the pre-day doubt data; synchronizing the account checking result into an account checking list; for example, the client a chooses to provide the record of the full amount of reconciliation according to the reserved time, while the client B cannot provide the record of the full amount of reconciliation according to the reserved time, and the record which needs to be provided today may need to be delayed to be provided tomorrow.
Specifically, the three-account checking party full-amount account checking is used in the situation that the number of clients needing account checking is large, in the situation, the three-position clients needing account checking are put together to be grouped for account checking, the three-position clients provide the full-amount account checking records according to the reserved time for account checking, and finally the account checking results are recorded together.
Fig. 5 is a flowchart of acquiring multi-institution reconciliation permission in an embodiment of the present invention, and as shown in fig. 5, step S4 is to acquire multi-institution reconciliation permission for the multi-institution reconciliation method, where the acquiring multi-institution reconciliation permission is used for registering an institution number and acquiring reconciliation permission. Step S4 may include the following steps:
step S401: and registering by calling an interface parameter in the multi-mechanism reconciliation method, wherein the interface parameter is a mechanism unique identification ID which consists of numbers and letters.
Step S402: after the account checking party completes the registration link in the multi-mechanism account checking method, the multi-mechanism account checking method provides the distributed structure number, the mechanism unique mark and the mechanism name in the original message request. The owner of the organization number is the multi-organization reconciliation method, and the owner of the organization name is the name of the client, and is input by Chinese characters and used for explaining and explaining the unique mark.
For example, a company needs to be checked out, and first the company needs to provide three pieces of information, namely, the unique identifier of the organization: abcd0011, if the company does not provide the corresponding unique mechanism marking information, the multi-mechanism reconciliation method is automatically distributed; the name of the organization is as follows: XXX Ltd; if the company is the third customer that the multi-institution reconciliation method receives, the multi-institution reconciliation method will assign a reconciliation institution number to the company, with institution number 000001; thus, the following three pieces of information, namely unique labels, can be obtained: abcd 0011; the name of the organization is as follows: XXX Ltd; agency number 000001.
Fig. 6 is a flowchart of dynamically configuring a reconciliation result file in an embodiment of the present invention, and as shown in fig. 6, step S3 is that, according to the reconciliation result, dynamically configuring the reconciliation result file includes: and generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring a configuration corresponding to the format requirement, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file. Step S3 may include the following steps:
step S301: and generating a task list of the dynamic configuration reconciliation result file, and generating the task list of the dynamic configuration reconciliation result file through a timing task triggering mode according to the obtained reconciliation result.
The timing task triggering mode is that the client appoints time. For example, if the client reserves 7 am, the multi-mechanism reconciliation method will automatically trigger the reconciliation task at 7 am of the reservation, so that the task does not need to be triggered by using the peripheral interface.
Step S302: setting an input interface in the business system, and inputting a format requirement of a reconciliation result file of a receiving reconciliation file side by using the input interface; the format requirements comprise a line format requirement, a sending organ, a sending character number and the like.
Step S303: according to the format requirement, acquiring the configuration corresponding to the format requirement from the reconciliation result file; the configuration comprises an agreement on the trigger time of the timing task, an agreement on the format of the account checking file, and whether the first line in the account checking detail has the total number of strokes and the total number of bars; and a convention for delimiters for each field in the ledger detail.
Step S304: and dynamically configuring the reconciliation result file and converting the format of the reconciliation result file by inquiring the task list of the dynamically configured reconciliation result file and the acquired configuration, so as to acquire the reconciliation result file. After the account checking result file is dynamically configured, the multi-mechanism account checking method checks whether account checking on the current day is finished; if the account checking on the current day is finished, one or more end files can be generated according to the configuration and the requirements of the client; and if the account checking of the current day is not played, the multi-mechanism account checking method stops, and the process is ended. The multi-mechanism reconciliation method generates a manifest file format for the reconciliation result, wherein the manifest file format is that the reconciliation file of the client can complete the reconciliation in the reconciliation model, and finally generates a corresponding reconciliation list.
Based on the same technical concept, the invention also provides a multi-mechanism reconciliation system, as shown in fig. 7, which comprises an analysis unit, a reconciliation unit and a dynamic configuration reconciliation result file unit;
specifically, the parsing unit is configured to parse a standard reconciliation file format, where the standard reconciliation file format is a parsing of a reconciliation file provided by a reconciliation party;
specifically, the reconciliation unit is configured to configure a reconciliation model according to the standard reconciliation file format, and obtain a reconciliation result;
specifically, the dynamic configuration reconciliation result file unit is configured to dynamically configure a format of a reconciliation result file according to a reconciliation result.
Based on the same technical concept, the invention also provides a computer device, which comprises a memory and a processor, wherein the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the multi-mechanism reconciliation method. The specific steps of the multi-mechanism account checking method comprise: the method comprises the steps of generating a task list to be analyzed into a standard reconciliation file format, utilizing an importing interface on a service system to import a standard reconciliation file format template into the service system, acquiring corresponding configuration required by the standard reconciliation file format from a reconciliation file to be reconciled according to the standard reconciliation file format template, generating a path for analyzing the standard reconciliation file format and a realization logic list corresponding to the path according to the task list and the configuration, and executing the realization logic list to acquire the standard reconciliation file format. And generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. And generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file.
Based on the same technical concept, the present invention also provides a storage medium storing computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to perform the steps of a multi-mechanism reconciliation method, the steps of the multi-mechanism reconciliation method comprising: the method comprises the steps of generating a task list to be analyzed into a standard reconciliation file format, utilizing an importing interface on a service system to import a standard reconciliation file format template into the service system, acquiring corresponding configuration required by the standard reconciliation file format from a reconciliation file to be reconciled according to the standard reconciliation file format template, generating a path for analyzing the standard reconciliation file format and a realization logic list corresponding to the path according to the task list and the configuration, and executing the realization logic list to acquire the standard reconciliation file format. And generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. And generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the computer program is executed. The storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a Random Access Memory (RAM).
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims (9)

Translated fromChinese
1.一种多机构对账方法,其特征在于,所述多机构对账方法包括:1. A multi-institution reconciliation method, wherein the multi-institution reconciliation method comprises:S1:解析标准对账文件格式;所述标准对账文件格式是对对账方提供的对账文件进行解析后生成的标准格式,其中,所述步骤S1包括如下步骤:S1: Parse the standard reconciliation file format; the standard reconciliation file format is a standard format generated after parsing the reconciliation file provided by the reconciliation party, wherein the step S1 includes the following steps:S101:生成待解析成标准对账文件格式的任务列表,选定一需要进行对账的业务系统,在所述业务系统前端设置一上传操作界面,利用所述上传操作界面上传需进行对账的对账文件,通过接口触发或者定时任务触发的方式,生成待解析成标准对账文件格式的任务列表;S101: Generate a task list to be parsed into a standard reconciliation file format, select a business system that needs to be reconciled, set an upload operation interface on the front end of the business system, and use the upload operation interface to upload the files that need to be reconciled. The reconciliation file generates a task list to be parsed into a standard reconciliation file format through interface triggering or timed task triggering;S102:在所述业务系统前端设置一导入界面,利用所述导入界面,将标准对账文件格式的模板导入至所述业务系统,并将所述标准对账文件格式存入一存储器内;S102: Set an import interface at the front end of the business system, use the import interface to import a template of a standard reconciliation file format into the business system, and store the standard reconciliation file format in a memory;S103:根据存储在存储器内的标准对账文件模板,从需进行对账的对账文件中获取所述标准对账文件格式所需的对应配置,所述配置包括对定时任务触发时间的约定,对账文件格式的约定,对账明细中的第一行是否有总笔数和总条数,以及对账明细中的每个字段的分隔符的约定;S103: According to the standard reconciliation file template stored in the memory, obtain the corresponding configuration required by the standard reconciliation file format from the reconciliation file to be reconciled, and the configuration includes an agreement on the trigger time of the timing task, The agreement on the format of the reconciliation file, whether the first line in the reconciliation details has the total number of transactions and the total number of entries, and the agreement on the separator of each field in the reconciliation details;S104:根据所述待解析成标准对账文件格式的任务列表和所述配置,获取解析标准对账文件格式的实现逻辑列表,包括:所述业务系统将利用所述对账方法对对账文件是否生成进行检查,若未生成,则致使所述多机构对账方法停止工作,若生成对账文件,则根据已经生成的对账文件,将所述对账文件下载至云存储,最后将对账文件上传至NAS存储器进行文件共享和数据备份;S104: According to the task list to be parsed into the standard reconciliation file format and the configuration, obtain an implementation logic list for parsing the standard reconciliation file format, including: the business system will use the reconciliation method to reconcile the reconciliation file Check whether it is generated. If it is not generated, the multi-organization reconciliation method will stop working. If a reconciliation file is generated, download the reconciliation file to cloud storage according to the reconciliation file that has been generated. Account files are uploaded to NAS storage for file sharing and data backup;S105:执行所述实现逻辑列表,解析对账文件,获取标准对账文件格式;S105: Execute the implementation logic list, parse the reconciliation file, and obtain a standard reconciliation file format;S2:根据所述标准对账文件格式,配置对账模型,获取对账结果;S2: Configure a reconciliation model according to the standard reconciliation file format, and obtain a reconciliation result;S3:根据对账结果,动态配置对账结果文件。S3: Dynamically configure the reconciliation result file according to the reconciliation result.2.根据权利要求1所述的一种多机构对账方法,其特征在于,所述步骤S2包括:2. A multi-organization reconciliation method according to claim 1, wherein the step S2 comprises:S201:生成对账任务列表,根据解析完成的标准对账文件格式,通过定时任务触发方式,生成对账任务列表;S201: Generate a reconciliation task list, and generate a reconciliation task list according to the standard reconciliation file format that has been parsed and triggered by a timed task;S202:利用所述业务系统前端的导入界面,将对账模型导入至所述业务系统,存储至业务系统的存储器内;S202: Using the import interface of the front end of the business system, import the reconciliation model into the business system, and store it in the memory of the business system;S203:根据生成的对账任务列表,选择对应的对账模型,并从所述对账任务列表中获取所选对账模型对应的配置;S203: Select a corresponding reconciliation model according to the generated reconciliation task list, and obtain the configuration corresponding to the selected reconciliation model from the reconciliation task list;S204:根据获取的对账模型和所述所选对账模型对应的配置,判断是否采用滚动对账方式;S204: According to the acquired reconciliation model and the configuration corresponding to the selected reconciliation model, determine whether to adopt the rolling reconciliation method;S205:根据步骤S204的判断结果,通过查询所述对账任务列表,完成对账并获取对账结果。S205: According to the judgment result of step S204, by querying the reconciliation task list, complete the reconciliation and obtain the reconciliation result.3.根据权利要求1所述的一种多机构对账方法,其特征在于,所述对账模型包括双对账方全量对账、双对账方滚动对账和三对账方全量对账。3. A multi-organization reconciliation method according to claim 1, wherein the reconciliation model comprises full reconciliation by double reconciling parties, rolling reconciliation by two reconciling parties and full reconciliation by three reconciling parties .4.根据权利要求1所述的一种多机构对账方法,其特征在于,所述步骤S3包括:4. A multi-organization reconciliation method according to claim 1, wherein the step S3 comprises:S301:生成动态配置对账结果文件的任务列表,根据获取的对账结果,通过定时任务触发方式,生成动态配置对账结果文件的任务列表;S301: Generate a task list for dynamically configuring the reconciliation result file, and according to the acquired reconciliation result, generate a task list for dynamically configuring the reconciliation result file by triggering a timed task;S302:在所述业务系统设置一输入界面,利用所述输入界面,输入接受对账文件一方对对账结果文件的格式要求;S302: Set an input interface in the business system, and use the input interface to input the format requirements for the reconciliation result file of the party accepting the reconciliation file;S303:根据所述格式要求,从对账文件中获取格式要求对应的配置;S303: According to the format requirements, obtain the configuration corresponding to the format requirements from the reconciliation file;S304:通过查询动态配置对账结果文件的任务列表和获取的配置,动态配置对账结果文件并转换成对账结果文件格式,获取对账结果文件。S304: Obtain the reconciliation result file by querying the task list of dynamically configuring the reconciliation result file and the acquired configuration, dynamically configuring the reconciliation result file and converting it into a reconciliation result file format.5.根据权利要求1至4任一项所述的一种多机构对账方法,其特征在于,所述存储器包括NAS存储器和云存储。5 . The multi-organization reconciliation method according to claim 1 , wherein the storage includes NAS storage and cloud storage. 6 .6.根据权利要求1所述的一种多机构对账方法,其特征在于,所述多机构对账方法还包括获取多机构对账权限,所述获取多机构对账权限用于注册机构号,获取对账许可权限,包括如下步骤:6. A multi-institution reconciliation method according to claim 1, wherein the multi-institution reconciliation method further comprises acquiring a multi-institution reconciliation authority, and the multi-institution reconciliation authority is used for registering an institution number , to obtain the reconciliation permission, including the following steps:通过调用业务系统的接口参数进行机构号注册,其中,所述接口参数是机构标示唯一ID;The organization number registration is performed by calling the interface parameter of the business system, wherein the interface parameter is the unique ID of the organization designation;对账方在完成注册后获取机构号、注册请求中生成的机构唯一标示和机构名称。After completing the registration, the reconciling party obtains the institution number, the institution's unique identifier and institution name generated in the registration request.7.一种多机构对账系统,其特征在于,所述多机构对账系统包括解析单元、对账单元和动态配置对账结果文件单元;7. A multi-institution reconciliation system, characterized in that the multi-institution reconciliation system comprises an analysis unit, a reconciliation unit and a dynamically configured reconciliation result file unit;所述解析单元,用于解析标准对账文件格式,所述标准对账文件格式是对对账方提供的对账文件进行解析后生成的标准格式;The parsing unit is configured to parse a standard reconciliation file format, where the standard reconciliation file format is a standard format generated after parsing the reconciliation file provided by the reconciling party;其中,所述解析单元具体用于:Wherein, the parsing unit is specifically used for:生成待解析成标准对账文件格式的任务列表,选定一需要进行对账的业务系统,在所述业务系统前端设置一上传操作界面,利用所述上传操作界面上传需进行对账的对账文件,通过接口触发或者定时任务触发的方式,生成待解析成标准对账文件格式的任务列表;Generate a task list to be parsed into a standard reconciliation file format, select a business system that needs to be reconciled, set an upload operation interface on the front end of the business system, and use the upload operation interface to upload the reconciliation that needs to be reconciled file, through interface triggering or timing task triggering, generate a task list to be parsed into a standard reconciliation file format;在所述业务系统前端设置一导入界面,利用所述导入界面,将标准对账文件格式的模板导入至所述业务系统,并将所述标准对账文件格式存入一存储器内;An import interface is set at the front end of the business system, and the import interface is used to import the template of the standard reconciliation file format into the business system, and the standard reconciliation file format is stored in a memory;根据存储在存储器内的标准对账文件模板,从需进行对账的对账文件中获取所述标准对账文件格式所需的对应配置,所述配置包括对定时任务触发时间的约定,对账文件格式的约定,对账明细中的第一行是否有总笔数和总条数,以及对账明细中的每个字段的分隔符的约定;According to the standard reconciliation file template stored in the memory, the corresponding configuration required for the standard reconciliation file format is obtained from the reconciliation file to be reconciled. The agreement on the file format, whether the first line in the reconciliation details has the total number of transactions and the total number of entries, and the agreement on the separator of each field in the reconciliation details;根据所述待解析成标准对账文件格式的任务列表和所述配置,获取解析标准对账文件格式的实现逻辑列表,包括:所述业务系统将利用所述对账方法对对账文件是否生成进行检查,若未生成,则致使所述多机构对账方法停止工作,若生成对账文件,则根据已经生成的对账文件,将所述对账文件下载至云存储,最后将对账文件上传至NAS存储器进行文件共享和数据备份;According to the task list to be parsed into the standard reconciliation file format and the configuration, obtaining the implementation logic list for parsing the standard reconciliation file format, including: the business system will use the reconciliation method to check whether the reconciliation file is generated Check, if not generated, cause the multi-organization reconciliation method to stop working, if a reconciliation file is generated, download the reconciliation file to cloud storage according to the reconciliation file that has been generated, and finally reconcile the reconciliation file Upload to NAS storage for file sharing and data backup;执行所述实现逻辑列表,解析对账文件,获取标准对账文件格式;Execute the implementation logic list, parse the reconciliation file, and obtain the standard reconciliation file format;所述对账单元,用于根据所述标准对账文件格式,配置对账模型,获取对账结果;The reconciliation unit is configured to configure a reconciliation model according to the standard reconciliation file format, and obtain a reconciliation result;所述动态配置对账结果文件单元,用于根据对账结果,动态配置对账结果文件。The unit for dynamically configuring the reconciliation result file is configured to dynamically configure the reconciliation result file according to the reconciliation result.8.一种计算机设备,包括存储器和处理器,所述存储器中存储有计算机可读指令,所述计算机可读指令被所述处理器执行时,使得所述处理器执行如权利要求1至6中任一项所述多机构对账方法的步骤。8. A computer device comprising a memory and a processor, wherein computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by the processor, the processor is caused to perform as claimed in claims 1 to 6 The steps of any one of the multi-agency reconciliation methods.9.一种计算机可读存储介质,其特征在于,所述计算机可读存储介质上存储有计算机可读指令,所述计算机可读指令被一个或多个处理器执行时,使得所述处理器执行如权利要求1至6中任一项所述的多机构对账方法的步骤。9. A computer-readable storage medium, wherein computer-readable instructions are stored on the computer-readable storage medium, and when the computer-readable instructions are executed by one or more processors, the processor The steps of performing the multi-agency reconciliation method as claimed in any one of claims 1 to 6.
CN201810156913.0A2018-02-242018-02-24 Multi-agency reconciliation method, system, computer equipment and storage mediumExpired - Fee RelatedCN108509392B (en)

Priority Applications (1)

Application NumberPriority DateFiling DateTitle
CN201810156913.0ACN108509392B (en)2018-02-242018-02-24 Multi-agency reconciliation method, system, computer equipment and storage medium

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201810156913.0ACN108509392B (en)2018-02-242018-02-24 Multi-agency reconciliation method, system, computer equipment and storage medium

Publications (2)

Publication NumberPublication Date
CN108509392A CN108509392A (en)2018-09-07
CN108509392Btrue CN108509392B (en)2022-03-25

Family

ID=63375737

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201810156913.0AExpired - Fee RelatedCN108509392B (en)2018-02-242018-02-24 Multi-agency reconciliation method, system, computer equipment and storage medium

Country Status (1)

CountryLink
CN (1)CN108509392B (en)

Families Citing this family (13)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN109472688A (en)*2018-10-222019-03-15平安科技(深圳)有限公司A kind of fund clearing method and apparatus
CN110188136A (en)*2019-06-102019-08-30四川长虹电器股份有限公司A kind of modularization reconciliation system and its account checking method based on bank-corporate express
CN110378778A (en)*2019-07-102019-10-25中信百信银行股份有限公司Multi-data source account checking method, system, electronic equipment and storage medium
CN110751550B (en)*2019-10-122022-09-13未鲲(上海)科技服务有限公司Account checking method and device, computer equipment and storage medium
CN111143469B (en)*2019-12-272023-10-20杭州数梦工场科技有限公司Data reconciliation method, device, electronic equipment and storage medium
CN113095832A (en)*2020-01-092021-07-09中移智行网络科技有限公司Multi-party account checking method, device, storage medium and computer equipment
CN111598683B (en)*2020-05-182023-10-27中国邮政储蓄银行股份有限公司Data processing method and device
CN112037022A (en)*2020-09-012020-12-04中国银行股份有限公司Automatic account checking method and device
CN113591446B (en)*2021-06-292023-11-03四川新网银行股份有限公司Configurational account checking file generating device
CN115082178A (en)*2022-06-282022-09-20平安银行股份有限公司 Reconciliation and settlement method, system, electronic device and storage medium
CN115239444B (en)*2022-07-192025-10-03深圳市雁联计算系统有限公司 A method, system and device for multi-channel reconciliation to avoid confusion in results
CN116401312A (en)*2023-03-302023-07-07中国建设银行股份有限公司 Method, system, terminal device, storage medium and product for distributed parallel historical data archiving
CN119762256A (en)*2024-12-272025-04-04中国工商银行股份有限公司 Account reconciliation method, device, computer-readable storage medium and electronic device

Citations (3)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN103971197A (en)*2014-03-242014-08-06世纪禾光科技发展(北京)有限公司Cross-border e-commerce reconciliation method and cross-border e-commerce reconciliation
CN105243528A (en)*2015-09-152016-01-13普元信息技术股份有限公司Financial IT system graphical centralized reconciliation system and method under big data environment
CN107274279A (en)*2017-05-272017-10-20上海非码网络科技有限公司A kind of account checking method and system, electronic equipment based on multiple mobile payment platforms

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN106447475A (en)*2016-08-302017-02-22重庆好乐视网络科技有限公司Automatic batch checking method and system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN103971197A (en)*2014-03-242014-08-06世纪禾光科技发展(北京)有限公司Cross-border e-commerce reconciliation method and cross-border e-commerce reconciliation
CN105243528A (en)*2015-09-152016-01-13普元信息技术股份有限公司Financial IT system graphical centralized reconciliation system and method under big data environment
CN107274279A (en)*2017-05-272017-10-20上海非码网络科技有限公司A kind of account checking method and system, electronic equipment based on multiple mobile payment platforms

Also Published As

Publication numberPublication date
CN108509392A (en)2018-09-07

Similar Documents

PublicationPublication DateTitle
CN108509392B (en) Multi-agency reconciliation method, system, computer equipment and storage medium
CN110262889B (en)Link tracking method and device
CN108459939B (en)Log collection method and device, terminal equipment and storage medium
CN112017007B (en) User behavior data processing method and device, computer equipment, and storage medium
CN109166026A (en)Account checking method, device, computer equipment and storage medium
CN113326165B (en) Blockchain-based data processing method, device and computer-readable storage medium
CN112039701A (en)Interface call monitoring method, device, equipment and storage medium
CN114996281A (en)Data processing system, method, device, electronic equipment and storage medium
US11582345B2 (en)Context data management interface for contact center
CN106951225B (en)Data processing method and device based on service configuration template
CN118886836A (en) Workflow calling method, workbench, equipment, storage medium and product
CN117992115A (en)System configuration processing method, device, equipment, medium and program product
CN111324612A (en)Storage method, system, device, equipment and storage medium of order information
CN116126819A (en) System log processing method, device and medium
CN117556800A (en)Online contract file generation method and signing method
CN114979143B (en)Distributed service implementation method and distributed service system
HK1257404A1 (en)Multi-institution balancing method, system, computer equipment and storage medium
HK1257404B (en)Multi-institution balancing method, system, computer equipment and storage medium
CN114706787A (en) Service testing method, service testing device, equipment and storage medium
CN115330365A (en)Data processing method and device based on block chain and computer equipment
CN118509218B (en)Cross-data-center data processing method and device
CN101883004A (en) Method, device and system for synthesizing business data
CN109801029B (en)Cross-node service cooperation system and method
CN117667885A (en)Data migration method, device, terminal equipment and storage medium
CN116051267A (en)Real-time monitoring method and device for wind control characteristics

Legal Events

DateCodeTitleDescription
PB01Publication
PB01Publication
SE01Entry into force of request for substantive examination
SE01Entry into force of request for substantive examination
REGReference to a national code

Ref country code:HK

Ref legal event code:DE

Ref document number:1257404

Country of ref document:HK

GR01Patent grant
GR01Patent grant
CF01Termination of patent right due to non-payment of annual fee

Granted publication date:20220325

CF01Termination of patent right due to non-payment of annual fee

[8]ページ先頭

©2009-2025 Movatter.jp