技术领域technical field
本发明涉及计算机通信领域，特别是涉及多机构对账方法、系统、计算机设备和存储介质。The invention relates to the field of computer communication, in particular to a multi-institution account reconciliation method, system, computer equipment and storage medium.
背景技术Background technique
对账系统，是指在一个清算周期内，为保证双方或多方交易平台数据记录正确可靠，对数据中的有关数据进行检查和核对的系统。随着互联网金融的迅猛发展，越来越多的业务从线下转到线上，交易量越来越大，而往往账务相关的交易场景往往会与多个核心进行交互，由前置系统串接多个核心来完成一笔交易。因此，对账系统存在交易量大、交易场景复杂、多个交易系统，同时对账系统之间的交互异常时就会导致一笔交易在各个核心的结果不一致等问题。The reconciliation system refers to a system that checks and checks the relevant data in the data in order to ensure that the data records of two or more trading platforms are correct and reliable within a clearing cycle. With the rapid development of Internet finance, more and more businesses are shifting from offline to online, and the transaction volume is increasing. Often, accounting-related transaction scenarios often interact with multiple cores, and the front-end system Connect multiple cores in series to complete a transaction. Therefore, the reconciliation system has problems such as large transaction volume, complex transaction scenarios, and multiple transaction systems. At the same time, when the interaction between the reconciliation systems is abnormal, it will lead to inconsistent results of a transaction in each core.
另外，当前的对账系统主要有传统的打印纸质对账单，单线程对账方式。传统的打印纸质对账单是通过邮局快递回邮或者由企业客户前往银行盖章确认的方式。该种方式在互联网如此发达的现在社会早已无法满足企业及时、有效的核对账务的需求。单线程对账方式效率有限，下一步必须在上一步执行完成之后才能进行；若对账过程出现问题，对账系统会告知文件异常，经常会导致对账数据无法恢复到初始状态。In addition, the current reconciliation system mainly includes traditional printed paper reconciliation and single-thread reconciliation. Traditionally printed paper statements are returned by post office express or corporate customers go to the bank to stamp and confirm. This method has long been unable to meet the needs of enterprises to check accounts in a timely and effective manner in the current society where the Internet is so developed. The efficiency of the single-threaded reconciliation method is limited, and the next step must be executed after the previous step is completed; if there is a problem in the reconciliation process, the reconciliation system will notify the file that the file is abnormal, which often causes the reconciliation data to fail to return to the original state.
因此，需要对账系统需要核对下发的流水，核对各个系统间交易的一致性和正确性，导出差错，对账系统对应核心能够根据差错进行冲账或补账，解决各交易系统之间在碰到交互异常时致使一笔交易在各个核心的结果不一致等问题。本发明提供多机构对账方法、系统、计算机设备和存储介质，是基于多机构来进行的，解决传统对账系统只支持单一机构、逐条核对流水、对账要素单一等问题，实现一次部署，多次复用的效果。同时，动态配置对账要素，以及动态输出对账结果。Therefore, it is necessary for the reconciliation system to check the issued flow, check the consistency and correctness of the transactions between the various systems, and derive errors. When an interaction exception is encountered, the results of a transaction in each core are inconsistent. The present invention provides a multi-institution account reconciliation method, system, computer equipment and storage medium, which is based on multiple institutions, solves the problems that the traditional account reconciliation system only supports a single institution, checks the flow one by one, and has a single reconciliation element, and realizes one-time deployment. The effect of multiple repetitions. At the same time, dynamically configure the reconciliation elements and dynamically output the reconciliation results.
发明内容Contents of the invention
基于此，有必要针对传统对账系统只支持单一机构、以及对账结果在各核心出现不一致的情况，存在逐条核对流水，效率低、对账要素单一等弊端，提供多机构对账方法、系统、计算机设备和存储介质。Based on this, it is necessary to provide multi-institutional reconciliation methods and systems in view of the fact that the traditional reconciliation system only supports a single institution, and the reconciliation results are inconsistent in each core, and there are disadvantages such as one-by-one reconciliation flow, low efficiency, and single reconciliation elements. , computer equipment and storage media.
一种多机构对账方法，所述多机构对账方法，具体步骤如下：A multi-institution account reconciliation method, the multi-institution account reconciliation method, the specific steps are as follows:
S1：解析标准对账文件格式；所述标准对账文件格式是对对账方提供的对账文件进行解析后生成的标准格式；S1: Analyzing 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;
S2：根据所述标准对账文件格式，配置对账模型，获取对账结果；S2: Configure a reconciliation model according to the standard reconciliation file format, and obtain a reconciliation result;
S3：根据对账结果，动态配置对账结果文件。S3: According to the reconciliation result, dynamically configure the reconciliation result file.
在其中一个实施例中，所述步骤S1包括：In one of the embodiments, the step S1 includes:
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 at the front end of the business system, and use the upload operation interface to upload the reconciliation required For reconciliation files, generate a task list to be parsed into a standard file format through interface triggering or timing task triggering;
S102：在所述业务系统前端设置一导入界面，利用所述导入界面，将标准对账文件格式的模板导入至所述业务系统，并存放于存储器内；S102: Setting an import interface at the front end of the business system, using the import interface, importing the template in the standard reconciliation file format into the business system, and storing it in the memory;
S103：根据存储在存储器内的标准对账文件模板，从需进行对账的对账文件中获取所需标准对账格式所需的对应配置；S103: According to the standard reconciliation file template stored in the memory, obtain the corresponding configuration required for the required standard reconciliation format from the reconciliation file to be reconciled;
S104根据所述待解析成标准对账文件格式的任务列表和所述配置，获取解析标准对账文件格式的实现逻辑列表；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;
S105：执行所述实现逻辑列表，解析对账文件，获取标准对账文件格式。S105: Execute the implementation logic list, parse the reconciliation file, and obtain a standard reconciliation file format.
在其中一个实施例中，所述步骤S2包括：In one of the embodiments, the step S2 includes:
S201：生成对账任务列表，根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表；S201: Generate a reconciliation task list, and generate a reconciliation task list by triggering a scheduled task according to the parsed standard reconciliation file format;
S202：利用所述业务系统前端的导入界面，将对账模型导入至所述业务系统，存放至业务系统的存储器内；S202: Using the import interface at 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 account reconciliation model according to the generated account reconciliation task list, and obtain a configuration corresponding to the selected account reconciliation model from the account reconciliation task list;
S204：根据获取的对账模型和所述配置，判断是否采用滚动对账方式；S204: According to the obtained reconciliation model and the configuration, determine whether to adopt the rolling reconciliation method;
S205：根据步骤S204的判断结果，通过查询所述对账任务列表，完成对账并获取对账结果。S205: According to the judgment result of step S204, by querying the account reconciliation task list, complete the account reconciliation and obtain the reconciliation result.
在其中一个实施例中，所述对账模型包括双对账方全量对账、双对账方滚动对账和三对账方全量对账。In one of the embodiments, the reconciliation model includes full reconciliation with double reconciliation parties, rolling reconciliation with double reconciliation parties and full reconciliation with three reconciliation parties.
在其中一个实施例中，所述步骤S3包括：In one of the embodiments, the step S3 includes:
S301：生成动态配置对账结果文件的任务列表，根据获取的对账结果，通过定时任务触发方式，生成动态配置对账结果文件的任务列表；S301: Generate a task list of the dynamically configured reconciliation result file, and generate a task list of the dynamically configured reconciliation result file by triggering a scheduled task according to the obtained reconciliation result;
S302：在所述业务系统设置一输入界面，利用所述输入界面，输入接收对账文件一方对对账结果文件的格式要求；S302: Setting an input interface in the business system, using the input interface to input the format requirements of the party receiving the reconciliation file for the reconciliation result file;
S303：根据所述格式要求，从对账结果文件中获取格式要求对应的配置；S303: Acquire the configuration corresponding to the format requirement from the reconciliation result file according to the format requirement;
S304：通过查询动态配置对账结果文件的任务列表和获取的配置，动态配置对账结果文件并转换对账结果文件格式，获取对账结果文件。S304: Dynamically configure the reconciliation result file and convert the format of the reconciliation result file to obtain the reconciliation result file by querying the task list of the dynamically configured reconciliation result file and the obtained configuration.
在其中一个实施例中，所述多机构对账方法还包括获取多机构对账权限，所述获取多机构对账权限用于注册机构号，获取对账许可权限，包括如下步骤：通过调用业务系统的接口参数进行机构号注册，其中，所述接口参数是机构唯一标示ID；In one of the embodiments, the multi-institution account reconciliation method further includes obtaining the multi-institution account reconciliation authority, the acquisition of the multi-institution account reconciliation authority is used to register the institution number, and obtaining the account reconciliation permission authority includes the following steps: The interface parameters of the system are registered with the organization number, wherein the interface parameters are the unique ID of the organization;
对账方在完成注册后获取机构号、注册请求中生成的机构唯一标示机构名称。After completing the registration, the reconciling party obtains the organization number and the unique organization name generated in the registration request.
在其中一个实施例中，所述存储器包括NAS存储器和云存储。In one of the embodiments, the storage includes NAS storage and cloud storage.
基于相同的技术构思，本发明还提供一种多机构对账系统，所述多机构对账系统包括解析单元、对账单元和动态配置对账结果文件单元；Based on the same technical idea, the present invention also provides a multi-institution account reconciliation system, which includes an analysis unit, an account reconciliation unit, and a dynamically configured account reconciliation result file unit;
所述解析单元，用于解析标准对账文件格式，所述标准对账文件格式是对对账方提供的对账文件进行解析；The parsing unit is used to parse the standard reconciliation file format, and the standard reconciliation file format is to parse the reconciliation file provided by the reconciliation party;
所述对账单元，用于根据所述标准对账文件格式，配置对账模型，获取对账结果；The reconciliation unit is configured to configure a reconciliation model according to the standard reconciliation file format, and obtain reconciliation results;
所述动态配置对账结果文件单元，用于根据对账结果，动态配置对账结果文件格式。The dynamic configuration reconciliation result file unit is used to dynamically configure the reconciliation result file format according to the reconciliation result.
基于相同的技术构思，本发明还提供一种计算机设备，包括存储器和处理器，所述存储器中存储有计算机可读指令，所述计算机可读指令被所述处理器执行时，使得所述处理器执行上述多机构对账方法的步骤。Based on the same technical concept, the present invention also provides a computer device, including 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 processing The server executes the steps of the above-mentioned multi-institution reconciliation method.
基于相同的技术构思，本发明还提供一种存储有计算机可读指令的存储介质，所述计算机可读指令被一个或多个处理器执行时，使得一个或多个处理器执行如上述多机构对账方法的步骤。Based on the same technical concept, the present invention also provides a storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, one or more processors execute the above-mentioned multi-mechanism Steps in the reconciliation method.
上述多机构对账方法、系统、计算机设备和存储介质，通过生成待解析成标准对账文件格式的任务列表，利用所述业务系统上的导入界面将标准对账文件格式导入所述业务系统，根据标准对账文件格式，从需进行对账的对账文件中获取所述标准对账文件格式所需的对应配置，通过所述任务列表和配置生成解析标准对账文件格式的路径，以及与路径相对应的实现逻辑列表，执行所述实现逻辑列表获取标准对账文件格式。根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表，在业务系统前端导入对账模型，根据对账任务列表获取对账模型和所需配置，完成对账并获取对账结果。通过定时任务触发方式，生成动态配置对账文件格式的任务列表，在业务系统前端导入接收对账文件一方所需的要求，获取配置，完成动态配置对账结果文件并转换对账结果文件格式，获取对账结果文件。与现有技术相比，本技术方案的有益技术效果在于，当需要进行对账时，只要提供对应的对账文件，即可根据所述多机构对账方法将客户提供的所述对账文件解析成标准对账文件格式，根据所述标准对账文件格式并获取得到的对账模型，从而完成对账，根据所述对账结果，实现动态输出，缩小对账的工作量，提高了对账的效率。The above multi-institution reconciliation method, system, computer equipment and storage medium, by generating a task list to be parsed into a standard reconciliation file format, using the import interface on the business system to import the standard reconciliation file format into the business system, According to the standard reconciliation file format, obtain the corresponding configuration required for the standard reconciliation file format from the reconciliation file that needs to be reconciled, generate a path for parsing the standard reconciliation file format through the task list and configuration, and communicate with The implementation logic list corresponding to the path is executed to obtain the standard reconciliation file format. According to the parsed standard reconciliation file format, the reconciliation task list is generated through the timing task trigger method, the reconciliation model is imported into the front end of the business system, the reconciliation model and required configuration are obtained according to the reconciliation task list, and the reconciliation is completed and obtained Reconciliation results. Generate a task list in the format of the dynamic configuration reconciliation file through the timing task trigger method, import the requirements required by the party receiving the reconciliation file at the front end of the business system, obtain the configuration, complete the dynamic configuration reconciliation result file and convert the reconciliation result file format, Obtain the reconciliation result file. Compared with the prior art, the beneficial technical effect of this technical solution is that when reconciliation is required, as long as the corresponding reconciliation file is provided, the reconciliation file provided by the customer can be transferred according to the multi-institution reconciliation method Parse into a standard reconciliation file format, and obtain the reconciliation model according to the standard reconciliation file format, thereby completing reconciliation, and realize dynamic output according to the reconciliation results, reduce the workload of reconciliation, and improve the reconciliation. account efficiency.
附图说明Description of drawings
图1为本发明一个实施例中一种多机构对账方法的流程图；Fig. 1 is the flow chart of a kind of multi-institution reconciliation method in one embodiment of the present invention;
图2为本发明一个实施例中解析成标准对账文件格式的流程图；Fig. 2 is a flow chart of parsing into a standard reconciliation file format in one embodiment of the present invention;
图3为本发明一个实施例中获取对账结果的流程图；Fig. 3 is the flowchart of obtaining reconciliation results in one embodiment of the present invention;
图4为本发明一个实施例中对账模型的示意图；Fig. 4 is a schematic diagram of an account reconciliation model in an embodiment of the present invention;
图5为本发明一个实施例中获取多机构对账权限的流程图；Fig. 5 is a flow chart of obtaining multi-institution reconciliation authority in one embodiment of the present invention;
图6为本发明一个实施例中动态配置对账结果文件的流程图；Fig. 6 is a flow chart of dynamically configuring the reconciliation result file in one embodiment of the present invention;
图7为本发明一个实施例中一种多机构对账系统的示意图。Fig. 7 is a schematic diagram of a multi-institution reconciliation system in an embodiment of the present invention.
具体实施方式Detailed ways
为了使本发明的目的、技术方案及优点更加清楚明白，以下结合附图及实施例，对本发明进行进一步详细说明。应当理解，此处所描述的具体实施例仅仅用以解释本发明，并不用于限定本发明。In order to make the object, technical solution and advantages of the present invention more clear, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.
如图1所示，本发明实施例提供一种多机构对账方法，所述多机构对账方法，可以包括如下步骤：As shown in Figure 1, an embodiment of the present invention provides a multi-institution account reconciliation method, which may include the following steps:
步骤S1：解析标准对账文件格式；在所述业务系统前端获取客户提供的对账文件，生成待解析成标准对账文件格式的任务列表，通过导入的标准对账文件格式模板，获取对应配置，通过所述任务列表和配置生成解析标准对账文件格式的路径，以及与路径相对应的实现逻辑列表，执行所述实现逻辑列表获取标准对账文件格式；Step S1: Parse the standard reconciliation file format; obtain the reconciliation file provided by the customer at the front end of the business system, generate a task list to be parsed into the standard reconciliation file format, and obtain the corresponding configuration through the imported standard reconciliation file format template generating a path for parsing a standard reconciliation file format through the task list and configuration, and an implementation logic list corresponding to the path, and executing the implementation logic list to obtain a standard reconciliation file format;
步骤S2：根据所述标准对账文件格式，配置对账模型，获取对账结果；根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表，在业务系统前端导入对账模型，根据对账任务列表获取对账模型和所需配置，完成对账并获取对账结果；Step S2: According to the standard reconciliation file format, configure the reconciliation model to obtain reconciliation results; according to the parsed standard reconciliation file format, generate a reconciliation task list by triggering a scheduled task, and import the reconciliation task list at the front end of the business system. Account model, obtain the account reconciliation model and required configuration according to the account reconciliation task list, complete the account reconciliation and obtain the account reconciliation result;
步骤S3：根据对账结果，动态配置对账结果文件；通过定时任务触发方式，生成动态配置对账文件格式的任务列表，在业务系统前端导入接收对账文件一方所需的格式要求，获取配置，完成动态配置对账结果文件并转换对账文件格式，获取对账结果文件。Step S3: Dynamically configure the reconciliation result file according to the reconciliation result; generate a task list for dynamically configuring the reconciliation file format by triggering a scheduled task, import the format requirements required by the party receiving the reconciliation file at the front end of the business system, and obtain the configuration , complete the dynamic configuration of the reconciliation result file and convert the reconciliation file format to obtain the reconciliation result file.
图2为本发明一个实施例中解析成标准对账文件格式的流程图，如图2所述，步骤S1的解析过程包括生成待解析成标准对账文件格式的任务列表，导入标准对账文件格式，生成解析标准对账文件格式的路径以及与路径相对应的实现逻辑列表，执行所述实现逻辑列表获取标准对账文件格式。步骤S1可以包括下述步骤：Fig. 2 is a flow chart of parsing into a standard reconciliation file format in one embodiment of the present invention, as shown in Fig. 2, the parsing process of step S1 includes generating the task list to be parsed into a standard reconciliation file format, and importing a 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:
步骤S101：生成待解析成标准对账文件格式的任务列表，选定一需要进行对账的业务系统，在所述业务系统前端设置一上传操作界面，利用所述上传操作界面上传需进行对账的对账文件，通过接口触发或者定时任务触发的方式，生成待解析成标准对账文件格式的任务列表。Step 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 at the front end of the business system, and use the upload operation interface to upload the reconciliation required The account reconciliation file is triggered by the interface or a scheduled task to generate a task list to be parsed into a standard reconciliation file format.
所述接口触发的方式，即利用外围接口调用触发的方式。举例来说，当外部有人发送一个请求过来，当所述多机构对账方法接收到请求后，将会根据该请求触发任务，以生成待解析成标准对账文件格式的任务列表。The way of triggering by the interface refers to the way of triggering by calling the peripheral interface. For example, when an external person sends a request, when the multi-institution reconciliation method receives the request, a task will be triggered according to the request to generate a task list to be parsed into a standard reconciliation file format.
所述定时任务触发的方式，则由客户约定时间。举例来说，客户预约早上七点，所述多机构对账方法则会自动在预约的早上七点触发任务，以生成待解析成标准对账文件格式的任务列表，故而不再需要利用外围接口的方式触发任务。The method of triggering the timed task is determined by the client. For example, if a customer makes an appointment at 7:00 in the morning, the multi-institution account reconciliation method will automatically trigger a task at 7:00 in the morning of the appointment to generate a task list to be parsed into a standard reconciliation file format, so it is no longer necessary to use the peripheral interface way to trigger the task.
步骤S102：在所述业务系统前端设置一导入界面，利用所述导入界面，将标准对账文件格式模板导入至所述业务系统，并存放于存储器内；所述存储器包括NAS存储器和云存储。Step S102: Set up an import interface at the front end of the business system, use the import interface to import the standard reconciliation file format template into the business system, and store it in the storage; the storage includes NAS storage and cloud storage.
所述NAS，即为网络附属存储（Network Attached Storage），是网络存储基于标准网络协议实现的数据传输。以数据为中心，将存储设备与服务器彻底分离，集中管理数据，从而释放带宽、提高性能、降低总拥有成本、保护投资。The NAS refers to network attached storage (Network Attached Storage), which is data transmission implemented by network storage based on standard network protocols. Taking data as the center, it completely separates storage devices from servers and manages data centrally, thereby releasing bandwidth, improving performance, reducing total cost of ownership, and protecting investment.
所述云存储，是云计算概念上延伸和发展出来的一个概念，是一种新兴的网络存储技术，是只通过集群应用、网络技术或分布式文件系统等功能，将网络中各种不同类型的存储设备通过应用软件集合起来协同工作，共同对外提供数据存储和业务访问功能的系统。The cloud storage is a concept extended and developed from the concept of cloud computing. It is an emerging network storage technology, and it is only through functions such as cluster applications, network technology or distributed file systems, which can store various types of data in the network. It is a system in which various storage devices work together through application software to jointly provide data storage and business access functions.
步骤S103：根据存储在存储器内的标准对账文件格式模板，从需进行对账的对账文件中获取所述标准对账文件格式所需的对应配置；所述配置包括对定时任务触发时间的约定，对账文件格式的约定，对账明细中的第一行是否有总笔数和总条数；以及对账明细中的每个字段的分隔符的约定。Step S103: According to the standard reconciliation file format template stored in the memory, obtain the corresponding configuration required for the standard reconciliation file format from the reconciliation file that needs to be reconciled; the configuration includes the trigger time of the scheduled task Agreement, 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存储器进行文件共享和数据备份，根据获取的配置和标准对账文件格式，将需进行解析的对账文件进行解析并转换成标准对账文件格式。其中，所述实现执行逻辑列表的顺序包括通知客户生成所需进行对账的对账文件；Step 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 Check whether the file is generated, if not generated, then cause the multi-institution reconciliation method to stop working; if generate a reconciliation file, then download the reconciliation file to cloud storage according to the reconciliation file that has been generated, and finally save the reconciliation file The reconciliation file is uploaded to the NAS storage for file sharing and data backup. According to the obtained configuration and standard reconciliation file format, the reconciliation file that needs to be parsed is parsed and converted into a standard reconciliation file format. Wherein, the order of realizing and executing the logic list includes informing the client to generate the reconciliation file required for reconciliation;
步骤S105：执行所述解析标准对账文件格式的实现逻辑列表，解析对账文件，获取标准对账文件格式，包括：在业务系统生成待解析成标准对账文件格式的任务列表，导入标准对账文件格式，生成将需进行对账的对账文件解析成标准对账文件格式的路径，以执行所述解析标准对账文件格式的实现逻辑列表，解析对账文件，获取标准对账文件格式。Step S105: Execute the implementation logic list for parsing the standard reconciliation file format, parse the reconciliation file, and obtain the standard reconciliation file format, including: generating a task list to be parsed into a standard reconciliation file format in the business system, and importing the standard reconciliation file format. Account file format, generating a path for parsing the reconciliation file that needs to be reconciled into a standard reconciliation file format, so as to execute the implementation logic list of parsing the standard reconciliation file format, parse the reconciliation file, and obtain the standard reconciliation file format .
图3为本发明一个实施例中获取对账结果的流程图，如图3所示，步骤S2为根据所述标准对账文件格式，配置对账模型，获取对账结果；根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表，在业务系统前端导入对账模型，根据对账任务列表获取对账模型和所需配置，完成对账并获取对账结果。步骤S2可以包括下述步骤：Fig. 3 is the flow chart of obtaining reconciliation result in one embodiment of the present invention, as shown in Fig. 3, step S2 is according to described standard reconciliation file format, configuration reconciliation model, obtains reconciliation result; The reconciliation file format generates a reconciliation task list by triggering a scheduled task, imports the reconciliation model at the front end of the business system, obtains the reconciliation model and required configuration according to the reconciliation task list, completes the reconciliation and obtains the reconciliation results. Step S2 may include the following steps:
步骤S201：生成对账任务列表，根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表；所述定时任务触发的方式，需要根据客户约定的时间来进行对账。比如，客户预约早上7点，所述多机构对账方法则会自动在预约的7点的时候触发对账任务，故而不需要再利用外围接口的方式来触发任务。Step S201: Generate a reconciliation task list, and generate a reconciliation task list according to the parsed standard reconciliation file format through a timing task trigger method; the timing task trigger method needs to perform account reconciliation according to the time agreed by the customer. For example, if a customer makes an appointment at 7 o'clock in the morning, the multi-institution account reconciliation method will automatically trigger the account reconciliation task at the scheduled 7 o'clock, so there is no need to use the peripheral interface to trigger the task.
步骤S202：利用所述业务系统前端的导入界面，将对账模型导入至所述业务系统，并将所述对账模型放置在一存储器内进行存储。所述存储器包括选用NAS存储器，在所述业务系统上设置一导入界面，利用所述导入界面，将对账模型导入至所述业务系统，并将所述对账模型放置在NAS存储器内进行存储。Step S202: Using the import interface at the front end of the business system, import the reconciliation model into the business system, and store the reconciliation model in a memory. The storage includes selecting NAS storage, setting an import interface on the business system, using the import interface, importing the reconciliation model into the business system, and placing the reconciliation model in the NAS storage for storage .
步骤S203：根据生成的对账任务列表，选择对应的对账模型，并从所述对账任务列表中获取所选对账模型对应的配置，所述配置包括对定时任务触发时间的约定，对账文件格式的约定，对账明细中的第一行是否有总笔数和总条数；以及对账明细中的每个字段的分隔符的约定。根据生成的对账任务列表，选择好对账模型后，根据定时任务触发时间、总条数、总笔数等信息，从所述对账任务列表中获取对应的配置。Step S203: According to the generated account reconciliation task list, select the corresponding account reconciliation model, and obtain the configuration corresponding to the selected account reconciliation model from the account reconciliation task list, the configuration includes the agreement on the trigger time of the scheduled task, and the The agreement on the format of the account 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. After the account reconciliation model is selected according to the generated account reconciliation task list, the corresponding configuration is obtained from the account reconciliation task list according to information such as the trigger time of the scheduled task, the total number of entries, and the total number of transactions.
步骤S204：根据获取对账模型和所述配置，判断是否采用滚动对账方式；所述滚动对账方式由获取的对账模型和配置决定，若采用滚动对账方式则在前一轮对账完全结束的情况下才能开始；若不采用滚动对账方式，则需调用具有批量插入功能的插件进行入库操作，可按照一定数量批量进行入库操作。举例来说，可以每次插入50条，50条账务流水记录进行入库处理。在一个文件全部插入完成之后，使用批次号检查文件中的总条数和数据库中的总条数是否一致，若不一致，则进行报错处理。Step S204: According to the obtained reconciliation model and the configuration, determine whether to adopt the rolling reconciliation method; the rolling reconciliation method is determined by the obtained reconciliation model and configuration, if the rolling reconciliation method is adopted, the previous round of reconciliation It can only start when it is completely completed; if the rolling reconciliation method is not used, it is necessary to call a plug-in with a batch insertion function to perform storage operations, and the storage operations can be performed in batches according to a certain amount. For example, 50 or 50 accounting records can be inserted each time for warehousing. After a file is all inserted, use the batch number to check whether the total number of entries in the file is consistent with the total number of entries in the database, and if not, report an error.
步骤S205：根据所述对账模型、所述配置和是否采用滚动对账方式的判断结果，通过查询所述对账任务列表，完成对账并获取对账结果。根据模型和配置决定是否使用滚动对账方式之后，利用对账模型进行对账，以获取对账结果。在得到对账结果之后，根据对账配置，将对账结果同步至清单表中，并更新归集表状态。所述清单表示将所述归集表中需要对账的记录合并成一条记录。所述归集表，其表中的数据是与对账文件中的数据是一一对应的关系。Step S205: According to the reconciliation model, the configuration and the judgment result of whether rolling reconciliation is adopted, by querying the reconciliation task list, complete reconciliation and obtain reconciliation results. After deciding whether to use the rolling reconciliation method according to the model and configuration, use the reconciliation model to reconcile to obtain the reconciliation results. After the reconciliation result is obtained, according to the reconciliation configuration, the reconciliation result is synchronized to the list table, and the status of the collection table is updated. The list indicates that the records that need to be reconciled in the collection table are combined into one record. In the collection table, the data in the table is in a one-to-one correspondence with the data in the reconciliation file.
举例来说，所述归集表中有两条记录，A记录：流水号（0001），金额（100），参考方；B记录：流水号（0001），金额（101），对账方，根据A记录和B记录，清单表会对账给出一条记录，即为流水号（0001），金额（100）。当所述A记录和所述B记录中的金额不一样时，所述多机构对账方法将会进行备注，备注为“请查明原因，进行处理”。For example, there are two records in the collection table, A record: serial number (0001), amount (100), reference party; B record: serial number (0001), amount (101), reconciliation party, According to the A record and the B record, the list table will give a record to the account, which is the serial number (0001) and the amount (100). When the amount in the A record and the B record is different, the multi-institution reconciliation method will make a note, and the note is "please find out the reason and deal with it".
图4为本发明一个实施例中对账模型的示意图，如图4所示，所述对账模型包括双对账方全量对账、双对账方滚动对账和三对账方全量对账。Fig. 4 is a schematic diagram of the reconciliation model in an embodiment of the present invention. As shown in Fig. 4, the reconciliation model includes full reconciliation of double reconciliation parties, rolling reconciliation of double reconciliation parties and full reconciliation of three reconciliation parties .
具体的，所述双对账方全量对账为，A客户和B客户按照约定的时间会每天提供全量的记录后将两者的记录汇总。举例来说，A客户提供流水号（0002），金额（2000）；B客户提供流水号（0003），金额（3000），所述多机构对账方法会按照A客户和B客户提供的信息，进行全量的记录和对账。Specifically, the full reconciliation of the two reconciliation parties is that the A customer and the B customer will provide a full amount of records every day according to the agreed time, and then summarize the records of the two. For example, client A provides the serial number (0002) and the amount (2000); client B provides the serial number (0003) and the amount (3000). The multi-institution reconciliation method will follow the information provided by client A and client B, Carry out full record and reconciliation.
具体的，所述双对账方滚动对账，其具体步骤包括：获取对账序号，所述对账序号可以根据所述多机构对账方法的要求决定是否需要提供；废弃日前的存疑数据；将所述对账结果同步到对账清单中；举例来说，A客户选择按照预约的时间提供全量对账的记录，而B客户不能按照预约的时间提供全量对账的记录，有可能需要将今天需要提供的记录延迟到明天才能提供，针对此种情况，所述多机构对账方法会将A客户相对于B客户提前提供的记录进行暂时性的保存，放置第二天再进行对账。Specifically, the double reconciliation party performs rolling reconciliation, and its specific steps include: obtaining the reconciliation serial number, and the reconciliation serial number can be determined according to the requirements of the multi-institution reconciliation method whether it needs to be provided; discarding the doubtful data before the date; Synchronize the reconciliation results to the reconciliation list; for example, if customer A chooses to provide full reconciliation records according to the scheduled time, but customer B cannot provide full reconciliation records according to the scheduled time, it may be necessary to The records that need to be provided today are delayed until tomorrow. In view of this situation, the multi-institution account reconciliation method will temporarily save the records provided by customer A in advance relative to customer B, and then reconcile the account the next day.
具体的，所述三对账方全量对账用于需要进行对账的客户数量较多的场合，此场合中，将三位需要进行对账的客户放在一起成组进行对账，根据三位客户按照预约时间提供的全量对账的记录进行对账，最终将所述对账结果一起进行记录。Specifically, the full reconciliation of the three account reconciliation parties is used for occasions where there are a large number of customers who need reconciliation. Each customer will reconcile according to the full reconciliation record provided by the appointment time, and finally record the reconciliation results together.
图5为本发明一个实施例中获取多机构对账权限的流程图，如图5所示，步骤S4为所述多机构对账方法获取多机构对账权限，所述获取多机构对账权限用于注册机构号，获取对账许可权限。步骤S4可以包括下述步骤：Fig. 5 is a flow chart of obtaining multi-institution account reconciliation authority in one embodiment of the present invention, as shown in Fig. 5, step S4 is described multi-institution account reconciliation method obtains multi-institution account reconciliation authority, and described acquisition multi-institution account reconciliation authority It is used to register the institution number and obtain permission for reconciliation. Step S4 may include the following steps:
步骤S401：通过调用所述多机构对账方法中的接口参数进行注册，其中，所述接口参数是机构唯一标示ID，其是由数字和字母组成。Step S401: register by calling the interface parameter in the multi-institution reconciliation method, wherein the interface parameter is the organization's unique ID, which is composed of numbers and letters.
步骤S402：对账方在完成所述多机构对账方法中的注册环节后，所述多机构对账方法将提供其分配的结构号、原报文请求中的机构唯一标示和机构名称。所述机构号的属主即为所述多机构对账方法，所述机构名称的属主则是客户的名称，用汉字输入，用来解释和说明唯一标示。Step S402: After the account reconciliation party completes the registration process in the multi-institution account reconciliation method, the multi-institution account reconciliation method will provide its assigned structure number, the organization's unique identifier and organization name in the original message request. The owner of the organization number is the multi-institution reconciliation method, and the owner of the organization name is the name of the customer, which is input in Chinese characters and used to explain and explain the unique mark.
举例来说，某公司需要对账，首先该公司需要提供三个信息，即机构唯一标示：abcd0011，若该公司没有提供对应的机构唯一标示信息，所述多机构对账方法则会自动分配；机构名称：XXX有限公司；如果该公司是所述多机构对账方法接收的第三位客户，则所述多机构对账方法将会分配一个对账机构号给该公司，其机构号为000001；故而，可以得到以下三个信息，即唯一标示：abcd0011；机构名称：XXX有限公司；机构号为000001。For example, if a company needs to reconcile accounts, first the company needs to provide three pieces of information, that is, the unique identification of the organization: abcd0011. If the company does not provide the corresponding information of the unique identification of the organization, the multi-institution reconciliation method will be automatically assigned; Institution name: XXX Co., Ltd.; if the company is the third customer received by the multi-institution account reconciliation method, the multi-institution account reconciliation method will assign an account reconciliation institution number to the company, and its institution number is 000001 ;Therefore, the following three information can be obtained, that is, the unique mark: abcd0011; the name of the institution: XXX Co., Ltd.; the institution number is 000001.
图6为本发明一个实施例中动态配置对账结果文件的流程图，如图6所示，步骤S3为所述根据对账结果，动态配置对账结果文件包括：通过定时任务触发方式，生成动态配置对账文件格式的任务列表，在业务系统前端导入接收对账文件一方所需的格式要求，获取与格式要求相对应的配置，完成动态配置对账结果文件并转换对账结果文件格式，获取对账结果文件。步骤S3可以包括下述步骤：Fig. 6 is a flow chart of dynamically configuring the reconciliation result file in one embodiment of the present invention. As shown in Fig. 6, step S3 is that according to the reconciliation result, dynamically configuring the reconciliation result file includes: triggering by a scheduled task, generating Dynamically configure the task list of the reconciliation file format, import the format requirements required by the party receiving the reconciliation file at the front end of the business system, obtain the configuration corresponding to the format requirements, complete the dynamic configuration of the reconciliation result file and convert the reconciliation result file format, Obtain the reconciliation result file. Step S3 may include the following steps:
步骤S301：生成动态配置对账结果文件的任务列表，根据获取的对账结果，通过定时任务触发方式，生成动态配置对账结果文件的任务列表。Step S301: Generate a task list of the dynamically configured reconciliation result file, and generate a task list of the dynamically configured reconciliation result file by triggering a scheduled task according to the obtained reconciliation result.
所述定时任务触发的方式，则是由客户约定时间。举例来说，客户预约早上7点，所述多机构对账方法则会自动在预约的7点的时候触发对账任务，故而不需要再利用外围接口的方式来触发任务。The method of triggering the timed task is to specify the time by the client. For example, if a customer makes an appointment at 7 o'clock in the morning, the multi-institution account reconciliation method will automatically trigger the account reconciliation task at the scheduled 7 o'clock, so there is no need to use the peripheral interface to trigger the task.
步骤S302：在所述业务系统设置一输入界面，利用所述输入界面，输入接收对账文件一方对对账结果文件的格式要求；所述格式要求包括行文格式要求、发文机关、发文字号等。Step S302: Set up an input interface in the business system, use the input interface to input the format requirements of the party receiving the reconciliation file for the reconciliation result file;
步骤S303：根据所述格式要求，从所述对账结果文件中获取所述格式要求对应的配置；其中，所述配置包括对定时任务触发时间的约定，对账文件格式的约定，对账明细中的第一行是否有总笔数和总条数；以及对账明细中的每个字段的分隔符的约定。Step S303: According to the format requirements, obtain the configuration corresponding to the format requirements from the reconciliation result file; wherein, the configuration includes the agreement on the trigger time of the scheduled task, the agreement on the format of the reconciliation file, and the reconciliation details Whether there is a total number of transactions and a total number of entries in the first line; and the agreement on the separator of each field in the reconciliation details.
步骤S304：通过查询动态配置对账结果文件的任务列表和获取的配置，动态配置对账结果文件并转换对账结果文件格式，获取对账结果文件。在完成动态配置对账结果文件后，所述多机构对账方法会检查当天的对账是否已经完成；若当天的对账已经完成，则可以根据配置，按照客户的要求生成一份或多份结束文件；若当天的对账没有玩成，所述多机构对账方法将会停止，流程将会结束。其中，所述多机构对账方法会对对账结果生成清单文件格式，所述清单文件格式是客户的对账文件将会在对账模型中完成对账，并最终生成相应的对账清单。Step S304: By querying the task list of dynamically configuring the reconciliation result file and the obtained configuration, dynamically configuring the reconciliation result file and converting the format of the reconciliation result file, and obtaining the reconciliation result file. After completing the dynamic configuration reconciliation result file, the multi-institution reconciliation method will check whether the reconciliation of the day has been completed; End the file; if the reconciliation of the day is not completed, the multi-institution reconciliation method will stop, and the process will end. Wherein, the multi-institution reconciliation method will generate a list file format for the reconciliation results, and the list file format is that the customer's reconciliation file will complete the reconciliation in the reconciliation model, and finally generate a corresponding reconciliation list.
基于相同的技术构思，本发明还提供一种多机构对账系统，如图7所示，所述多机构对账系统包括解析单元、对账单元和动态配置对账结果文件单元；Based on the same technical idea, the present invention also provides a multi-institution account reconciliation system, as shown in Figure 7, the multi-institution account reconciliation system includes an analysis unit, an account reconciliation unit and a dynamic configuration reconciliation result file unit;
具体的，所述解析单元，用于解析标准对账文件格式，所述标准对账文件格式是对对账方提供的对账文件进行解析；Specifically, the parsing unit is used to parse the standard reconciliation file format, and the standard reconciliation file format is to parse the reconciliation file provided by the reconciliation party;
具体的，所述对账单元，用于根据所述标准对账文件格式，配置对账模型，获取对账结果；Specifically, the reconciliation unit is configured to configure a reconciliation model according to the standard reconciliation file format, and obtain reconciliation results;
具体的，所述动态配置对账结果文件单元，用于根据对账结果，动态配置对账结果文件格式。Specifically, the dynamic configuration reconciliation result file unit is configured to dynamically configure the reconciliation result file format according to the reconciliation result.
基于相同的技术构思，本发明还提供一种计算机设备，包括存储器和处理器，所述存储器中存储有计算机可读指令，所述计算机可读指令被所述处理器执行时，使得所述处理器执行多机构对账方法的步骤。所述多机构对账方法的具体步骤包括：通过生成待解析成标准对账文件格式的任务列表，利用所述业务系统上的导入界面将标准对账文件格式模板导入所述业务系统，根据标准对账文件格式模板从需进行对账的对账文件中获取所述标准对账文件格式所需的对应配置，通过所述任务列表和配置生成解析标准对账文件格式的路径，以及与路径相对应的实现逻辑列表，执行所述实现逻辑列表获取标准对账文件格式。根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表，在业务系统前端导入对账模型，根据对账任务列表获取对账模型和所需配置，完成对账并获取对账结果。通过定时任务触发方式，生成动态配置对账文件格式的任务列表，在业务系统前端导入接收对账文件一方所需的格式要求，获取配置，完成动态配置对账结果文件并转换对账结果文件格式，获取对账结果文件。Based on the same technical concept, the present invention also provides a computer device, including 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 processing The server performs the steps of the multi-institution reconciliation method. The specific steps of the multi-institution reconciliation method include: by generating a task list to be parsed into a standard reconciliation file format, using the import interface on the business system to import the standard reconciliation file format template into the business system, according to the standard The reconciliation file format template obtains the corresponding configuration required for the standard reconciliation file format from the reconciliation file that needs to be reconciled, generates a path for parsing the standard reconciliation file format through the task list and configuration, and The corresponding implementation logic list is executed to obtain the standard reconciliation file format. According to the parsed standard reconciliation file format, the reconciliation task list is generated through the timing task trigger method, the reconciliation model is imported into the front end of the business system, the reconciliation model and required configuration are obtained according to the reconciliation task list, and the reconciliation is completed and obtained Reconciliation results. Generate a task list of the dynamic configuration reconciliation file format through the timing task trigger method, import the format requirements required by the party receiving the reconciliation file at the front end of the business system, obtain the configuration, complete the dynamic configuration reconciliation result file and convert the reconciliation result file format , to obtain the reconciliation result file.
基于相同的技术构思，本发明还提供一种存储有计算机可读指令的存储介质，所述计算机可读指令被一个或多个处理器执行时，使得一个或多个处理器执行多机构对账方法的步骤，所述多机构对账方法的步骤包括：通过生成待解析成标准对账文件格式的任务列表，利用所述业务系统上的导入界面将标准对账文件格式模板导入所述业务系统，根据标准对账文件格式模板从需进行对账的对账文件中获取所述标准对账文件格式所需的对应配置，通过所述任务列表和配置生成解析标准对账文件格式的路径，以及与路径相对应的实现逻辑列表，执行所述实现逻辑列表获取标准对账文件格式。根据解析完成的标准对账文件格式，通过定时任务触发方式，生成对账任务列表，在业务系统前端导入对账模型，根据对账任务列表获取对账模型和所需配置，完成对账并获取对账结果。通过定时任务触发方式，生成动态配置对账文件格式的任务列表，在业务系统前端导入接收对账文件一方所需的格式要求，获取配置，完成动态配置对账结果文件并转换对账结果文件格式，获取对账结果文件。Based on the same technical concept, the present invention also provides a storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, one or more processors execute multi-institution reconciliation The steps of the method, the steps of the multi-institution reconciliation method include: by generating a task list to be parsed into a standard reconciliation file format, using the import interface on the business system to import the standard reconciliation file format template into the business system Obtaining the corresponding configuration required for the standard reconciliation file format from the reconciliation file to be reconciled according to the standard reconciliation file format template, generating a path for parsing the standard reconciliation file format through the task list and configuration, and An implementation logic list corresponding to the path, which is executed to obtain a standard reconciliation file format. According to the parsed standard reconciliation file format, the reconciliation task list is generated through the timing task trigger method, the reconciliation model is imported into the front end of the business system, the reconciliation model and required configuration are obtained according to the reconciliation task list, and the reconciliation is completed and obtained Reconciliation results. Generate a task list of the dynamic configuration reconciliation file format through the timing task trigger method, import the format requirements required by the party receiving the reconciliation file at the front end of the business system, obtain the configuration, complete the dynamic configuration reconciliation result file and convert the reconciliation result file format , to obtain the reconciliation result file.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，是可以通过计算机程序来指令相关的硬件来完成，该计算机程序可存储于一计算机可读取存储介质中，该程序在执行时，可包括如上述各方法的实施例的流程。其中，前述的存储介质可为磁碟、光盘、只读存储记忆体（Read-Only Memory，ROM）等非易失性存储介质，或随机存储记忆体（Random Access Memory，RAM）等。Those of ordinary skill in the art can understand that realizing all or part of the processes in the methods of the above embodiments can be completed by instructing related hardware through a computer program, and the computer program can be stored in a computer-readable storage medium. During execution, it may include the processes of the embodiments of the above-mentioned methods. Wherein, the aforementioned storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a read-only memory (Read-Only Memory, ROM), or a random access memory (Random Access Memory, RAM).
以上所述实施例的各技术特征可以进行任意的组合，为使描述简洁，未对上述实施例中的各个技术特征所有可能的组合都进行描述，然而，只要这些技术特征的组合不存在矛盾，都应当认为是本说明书记载的范围。The technical features of the above-mentioned embodiments can be combined arbitrarily. To make the description concise, all possible combinations of the technical features in the above-mentioned embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, should be considered as within the scope of this specification.
以上所述实施例仅表达了本发明的几种实施方式，其描述较为具体和详细，但并不能因此而理解为对本发明专利范围的限制。应当指出的是，对于本领域的普通技术人员来说，在不脱离本发明构思的前提下，还可以做出若干变形和改进，这些都属于本发明的保护范围。因此，本发明专利的保护范围应以所附权利要求为准。The above-mentioned embodiments only express several implementation modes of the present invention, and the description thereof is relatively specific and detailed, but should not be construed as limiting the patent scope of the present invention. It should be pointed out that those skilled in the art can make several modifications and improvements without departing from the concept of the present invention, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent for the present invention should be based on the appended claims.
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810156913.0ACN108509392B (en) | 2018-02-24 | 2018-02-24 | Multi-agency reconciliation method, system, computer equipment and storage medium |
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810156913.0ACN108509392B (en) | 2018-02-24 | 2018-02-24 | Multi-agency reconciliation method, system, computer equipment and storage medium |
| Publication Number | Publication Date |
|---|---|
| CN108509392Atrue CN108509392A (en) | 2018-09-07 |
| CN108509392B CN108509392B (en) | 2022-03-25 |
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810156913.0AExpired - Fee RelatedCN108509392B (en) | 2018-02-24 | 2018-02-24 | Multi-agency reconciliation method, system, computer equipment and storage medium |
| Country | Link |
|---|---|
| CN (1) | CN108509392B (en) |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472688A (en)* | 2018-10-22 | 2019-03-15 | 平安科技（深圳）有限公司 | A kind of fund clearing method and apparatus |
| CN110188136A (en)* | 2019-06-10 | 2019-08-30 | 四川长虹电器股份有限公司 | A kind of modularization reconciliation system and its account checking method based on bank-corporate express |
| CN110378778A (en)* | 2019-07-10 | 2019-10-25 | 中信百信银行股份有限公司 | Multi-data source account checking method, system, electronic equipment and storage medium |
| CN110751550A (en)* | 2019-10-12 | 2020-02-04 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Account checking method and device, computer equipment and storage medium |
| CN111143469A (en)* | 2019-12-27 | 2020-05-12 | 杭州数梦工场科技有限公司 | Data reconciliation method and device, electronic equipment and storage medium |
| CN111598683A (en)* | 2020-05-18 | 2020-08-28 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN112037022A (en)* | 2020-09-01 | 2020-12-04 | 中国银行股份有限公司 | Automatic account checking method and device |
| CN113095832A (en)* | 2020-01-09 | 2021-07-09 | 中移智行网络科技有限公司 | Multi-party account checking method, device, storage medium and computer equipment |
| CN113591446A (en)* | 2021-06-29 | 2021-11-02 | 四川新网银行股份有限公司 | Configuration reconciliation file generation device |
| CN114298003A (en)* | 2021-12-21 | 2022-04-08 | 上海品顺信息科技有限公司 | Method and device for outputting standardized files |
| CN115082178A (en)* | 2022-06-28 | 2022-09-20 | 平安银行股份有限公司 | Reconciliation and settlement method, system, electronic device and storage medium |
| CN115239444A (en)* | 2022-07-19 | 2022-10-25 | 深圳市雁联计算系统有限公司 | A method, system and apparatus for multi-channel reconciliation to avoid confusion of results |
| CN116401312A (en)* | 2023-03-30 | 2023-07-07 | 中国建设银行股份有限公司 | Method, system, terminal device, storage medium and product for distributed parallel historical data archiving |
| CN119762256A (en)* | 2024-12-27 | 2025-04-04 | 中国工商银行股份有限公司 | Account reconciliation method, device, computer-readable storage medium and electronic device |
| CN114298003B (en)* | 2021-12-21 | 2025-10-10 | 上海品唯信息技术有限公司 | A standardized file output method and device |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103971197A (en)* | 2014-03-24 | 2014-08-06 | 世纪禾光科技发展（北京）有限公司 | Cross-border e-commerce reconciliation method and cross-border e-commerce reconciliation |
| CN105243528A (en)* | 2015-09-15 | 2016-01-13 | 普元信息技术股份有限公司 | Financial IT system graphical centralized reconciliation system and method under big data environment |
| CN106447475A (en)* | 2016-08-30 | 2017-02-22 | 重庆好乐视网络科技有限公司 | Automatic batch checking method and system |
| CN107274279A (en)* | 2017-05-27 | 2017-10-20 | 上海非码网络科技有限公司 | A kind of account checking method and system, electronic equipment based on multiple mobile payment platforms |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103971197A (en)* | 2014-03-24 | 2014-08-06 | 世纪禾光科技发展（北京）有限公司 | Cross-border e-commerce reconciliation method and cross-border e-commerce reconciliation |
| CN105243528A (en)* | 2015-09-15 | 2016-01-13 | 普元信息技术股份有限公司 | Financial IT system graphical centralized reconciliation system and method under big data environment |
| CN106447475A (en)* | 2016-08-30 | 2017-02-22 | 重庆好乐视网络科技有限公司 | Automatic batch checking method and system |
| CN107274279A (en)* | 2017-05-27 | 2017-10-20 | 上海非码网络科技有限公司 | A kind of account checking method and system, electronic equipment based on multiple mobile payment platforms |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472688A (en)* | 2018-10-22 | 2019-03-15 | 平安科技（深圳）有限公司 | A kind of fund clearing method and apparatus |
| CN110188136A (en)* | 2019-06-10 | 2019-08-30 | 四川长虹电器股份有限公司 | A kind of modularization reconciliation system and its account checking method based on bank-corporate express |
| CN110378778A (en)* | 2019-07-10 | 2019-10-25 | 中信百信银行股份有限公司 | Multi-data source account checking method, system, electronic equipment and storage medium |
| CN110751550A (en)* | 2019-10-12 | 2020-02-04 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Account checking method and device, computer equipment and storage medium |
| CN111143469B (en)* | 2019-12-27 | 2023-10-20 | 杭州数梦工场科技有限公司 | Data reconciliation method, device, electronic equipment and storage medium |
| CN111143469A (en)* | 2019-12-27 | 2020-05-12 | 杭州数梦工场科技有限公司 | Data reconciliation method and device, electronic equipment and storage medium |
| CN113095832A (en)* | 2020-01-09 | 2021-07-09 | 中移智行网络科技有限公司 | Multi-party account checking method, device, storage medium and computer equipment |
| CN111598683A (en)* | 2020-05-18 | 2020-08-28 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN111598683B (en)* | 2020-05-18 | 2023-10-27 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN112037022A (en)* | 2020-09-01 | 2020-12-04 | 中国银行股份有限公司 | Automatic account checking method and device |
| CN113591446A (en)* | 2021-06-29 | 2021-11-02 | 四川新网银行股份有限公司 | Configuration reconciliation file generation device |
| CN113591446B (en)* | 2021-06-29 | 2023-11-03 | 四川新网银行股份有限公司 | Configurational account checking file generating device |
| CN114298003A (en)* | 2021-12-21 | 2022-04-08 | 上海品顺信息科技有限公司 | Method and device for outputting standardized files |
| CN114298003B (en)* | 2021-12-21 | 2025-10-10 | 上海品唯信息技术有限公司 | A standardized file output method and device |
| CN115082178A (en)* | 2022-06-28 | 2022-09-20 | 平安银行股份有限公司 | Reconciliation and settlement method, system, electronic device and storage medium |
| CN115239444A (en)* | 2022-07-19 | 2022-10-25 | 深圳市雁联计算系统有限公司 | A method, system and apparatus for multi-channel reconciliation to avoid confusion of results |
| CN116401312A (en)* | 2023-03-30 | 2023-07-07 | 中国建设银行股份有限公司 | Method, system, terminal device, storage medium and product for distributed parallel historical data archiving |
| CN119762256A (en)* | 2024-12-27 | 2025-04-04 | 中国工商银行股份有限公司 | Account reconciliation method, device, computer-readable storage medium and electronic device |
| Publication number | Publication date |
|---|---|
| CN108509392B (en) | 2022-03-25 |
| Publication | Publication Date | Title |
|---|---|---|
| CN108509392A (en) | Multimachine structure account checking method, system, computer equipment and storage medium | |
| CN108536761B (en) | Report data query method and server | |
| WO2022063284A1 (en) | Data synchronization method and apparatus, device, and computer-readable medium | |
| CN107463409A (en) | A kind of interface conversion method, interface convertor, storage medium and electric terminal | |
| CN110233741B (en) | Service charging method, device, equipment and storage medium | |
| WO2020000720A1 (en) | Server, packet processing method, program, and computer-readable storage medium | |
| CN110413672A (en) | Data automatically imported method, device and computer readable storage medium | |
| CN111625535A (en) | Method, device and storage medium for realizing business data association | |
| CN111782653A (en) | Data query method, device, electronic device and storage medium | |
| CN116993523A (en) | Configurable reconciliation methods, devices, equipment and storage media | |
| CN110765148B (en) | Service data processing method and device | |
| CN103729455B (en) | A Primary Data Storage Method Based on Primary Copy Storage Model | |
| CN119226399A (en) | Multi-data source data synchronization method, system, device and medium | |
| CN111652580B (en) | Method and device for processing data of nodes | |
| CN116306508A (en) | A date data conversion method and device | |
| CN116126819A (en) | System log processing method, device and medium | |
| CN116028479A (en) | Data reconciliation system, method, equipment and storage medium | |
| CN111506644B (en) | Application data processing method and device and electronic equipment | |
| CN114186958A (en) | Method, computing device and storage medium for exporting list data to spreadsheet | |
| CN115994192A (en) | Method, device and system for implementing Elasticsearch retrieval in relational database retrieval system | |
| CN110309176B (en) | Data processing method and data transfer station | |
| HK1257404A1 (en) | Multi-institution balancing method, system, computer equipment and storage medium | |
| HK1257404B (en) | Multi-institution balancing method, system, computer equipment and storage medium | |
| CN119847618B (en) | System intercommunication method, device, equipment and computer readable storage medium | |
| CN104468725B (en) | A kind of method, apparatus and system for realizing high-availability cluster software maintenance |
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code | Ref country code:HK Ref legal event code:DE Ref document number:1257404 Country of ref document:HK | |
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee | Granted publication date:20220325 |