WO2019157777A1 - Routing sub-control reconciliation method and system - Google Patents

Routing sub-control reconciliation method and system Download PDF

Info

Publication number
WO2019157777A1
WO2019157777A1 PCT/CN2018/083064 CN2018083064W WO2019157777A1 WO 2019157777 A1 WO2019157777 A1 WO 2019157777A1 CN 2018083064 W CN2018083064 W CN 2018083064W WO 2019157777 A1 WO2019157777 A1 WO 2019157777A1
Authority
WO
WIPO (PCT)
Prior art keywords
reconciliation
merchant
task
file
information
Prior art date
Application number
PCT/CN2018/083064
Other languages
French (fr)
Chinese (zh)
Inventor
韦游领
刘潜
Original Assignee
平安科技(深圳)有限公司
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
Priority claimed from CN201810148432.5 external-priority
Application filed by 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2019157777A1 publication Critical patent/WO2019157777A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06QDATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTING PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTING PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll

Abstract

The present application relates to a routing sub-control reconciliation method and system, the method comprising the following steps: step 1: acquiring a task name, and querying a merchant routing information table to acquire merchant information; step 2: querying a merchant management information table to acquire merchant configuration information; step 3: determining whether the merchant configuration information satisfies a timed task start time determining rule and, if so, then executing step 4; and if not, then finishing the present method; step 4: on the basis of the merchant configuration information, acquiring merchant reconciliation file interaction information and acquiring a merchant accounting book file; step 5: determining whether a local reconciliation file is saved normally in a database and, if so, then acquiring the local reconciliation file from the database, and executing step 7; and if not, then executing step 6; step 6: after the system continues to wait for a specific time, executing step 5; and step 7: extracting reconciliation elements and implementing reconciliation on the basis of the reconciliation elements of the merchant, and generating a reconciliation result file.

Description

一种路由分控对账方法和系统Method and system for routing sub-control reconciliation
本申请申明享有2018年2月13日递交的申请号为201810148432.5、名称为“一种路由分控对账方法和系统”的中国专利申请的优先权,该中国专利申请的整体内容以参考的方式结合在本申请中。The present application claims the priority of the Chinese patent application filed on February 13, 2018, with the application number of 201101148432.5, entitled "A Method and System for Reconciliation Control of Routes", the entire contents of which are incorporated by reference. Combined in this application.
技术领域Technical field
本申请涉及计算机服务技术领域,尤其涉及一种路由分控对账方法和系统。The present application relates to the field of computer service technologies, and in particular, to a route control and reconciliation method and system.
背景技术Background technique
对账,是指对前一个清算周期的交易信息进行核对,以确认交易信息的一致性和正确性的过程。应当定期将会计账簿记录的有关数字、货币资金、有价证券往来单位或个人等进行相互核对,保证账证相符、账账相符、账实相符。Reconciliation refers to the process of checking the transaction information of the previous liquidation cycle to confirm the consistency and correctness of the transaction information. The relevant figures, monetary funds, securities units or individuals of the accounting books should be checked against each other regularly to ensure that the accounts are consistent, the accounts are consistent, and the accounts are consistent.
随着互联网以及计算机的发展,众多业务已经由原先传统地在线下进行转为通过网络进行线上以及线下的操作。而会计对账,亦已由传统地人工对账,转由通过网络以及计算机,进行自动对账。With the development of the Internet and computers, many services have been traditionally converted from offline to online and offline operations through the network. The accounting reconciliation has also been automatically reconciled by traditional manual reconciliation and transferred to the network and computer.
目前市面上的对账系统,针对不同的会计账簿接入方,其数据的交互耦合度过高,也过于复杂,从而导致实际对账的解决方案并无法满足不同接入方的对账需求。比如,不同的接入方对账数据交互方式不同、加签加密的方式不同、对账要素的不同、对账结果数据要求的不同,使得一款对账系统要满足前述不同要求,其数据的交互耦合度过高。这样高耦合的对账方式直接导致系统业务扩展和功能扩展存在极大的局限性,其不能及时地提供快速并且稳定的对接方案,严重地影响企业的业务拓展。此外,这样高耦合的对账方式,亦会造成很多重复的工作量,亦不利于运营管理和事件的响应。At present, the reconciliation system on the market, for different accounting book accessors, the data interaction degree is too high and too complicated, which leads to the actual reconciliation solution can not meet the reconciliation requirements of different access parties. For example, different accessing parties have different ways of interacting with each other, different ways of adding encryption, different reconciliation elements, and different data requirements for reconciliation results, so that a reconciliation system must meet the above different requirements, and its data The degree of cross-coupling is too high. Such a highly coupled reconciliation method directly leads to great limitations of system service expansion and function expansion, and it cannot provide a fast and stable docking solution in time, which seriously affects the business expansion of the enterprise. In addition, such a highly coupled reconciliation method will also result in a lot of repetitive workload and is not conducive to operational management and event response.
发明内容Summary of the invention
基于此,有必要针对上述技术问题,提供一种路由分控对账的方法,其通过建立多个路由信息参数表,使表与表之间存在之间或者间接的关联,并利用程序建立表与表之间的使用关系,通过路由化对账,灵活组合多个路由来实现分控对账处理,同时通过建立相关路由控制信息来获取不同商户在不同交易场景下的对账周期、对账数据原格式、对账启动日期以及对账要素等等数据,从而依据前述数据与信息,来完成对账操作。Based on this, it is necessary to provide a method for routing and controlling reconciliation for the above technical problem, which establishes a plurality of routing information parameter tables, so that there is an indirect or indirect association between the tables and the tables, and the program is established by using the program. The relationship between the use and the table, through routing reconciliation, flexible combination of multiple routes to achieve sub-control reconciliation processing, and at the same time through the establishment of relevant routing control information to obtain the reconciliation period and reconciliation of different merchants in different transaction scenarios The data original format, the reconciliation start date, and the reconciliation elements and so on, so as to complete the reconciliation operation based on the aforementioned data and information.
根据本申请的实施例,提供了一种路由分控对账方法,根据对账任务启动时间,启动执行对账任务,所述对账任务包括以下步骤:According to an embodiment of the present application, a route sub-control reconciliation method is provided. The reconciliation task is started according to a reconciliation task startup time, and the reconciliation task includes the following steps:
步骤1、获取所述对账任务中的任务名称,根据所述任务名称,查询数据库中的商户路由信息表,获取与所述对账任务有关的商户信息;Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;
步骤2、根据所述商户信息,查询商户管理信息表,获取商户配置信息; 所述商户配置信息中包含有商户号、商户的对账日期。Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date.
步骤3、判断所述商户配置信息是否满足对账任务启动时间判断规则,若是,则执行步骤4;否则,结束本方法;Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;
步骤4、根据所述商户配置信息,查询对账文件交互路由信息表,获取所述商户对账文件交互信息,并根据所述商户对账文件交互信息获取商户会计账簿文件;Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;
步骤5、根据所述对账任务的任务名称根据所述商户配置信息,判断与所述商户有关的本地会计账簿文件是否正常存入数据库,若是,则从所述数据库获取所述本地会计账簿文件,并执行步骤7;否则,执行步骤6;Step 5: According to the merchant configuration information, determine, according to the merchant configuration information, whether a local accounting book file related to the merchant is normally stored in a database, and if yes, obtain the local accounting book file from the database. And perform step 7; otherwise, perform step 6;
步骤6、系统继续等待一定时间后,返回执行步骤5;Step 6, after the system continues to wait for a certain period of time, return to step 5;
步骤7、从所述商户配置信息中提取所述商户的对账要素,根据所述商户的对账要素,将所述商户会计账簿文件与本地会计账簿文件进行对账,并生成对账结果文件。Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant, and generate a reconciliation result file. .
根据本申请的实施例,提供了一种路由分控对账系统,包括数据提取模块、数据处理模块、文件下载模块、对账模块以及系统通用模块,According to an embodiment of the present application, a route distribution control reconciliation system is provided, including a data extraction module, a data processing module, a file downloading module, a reconciliation module, and a system general module.
所述数据提取模块,用于提取和/或获取表格以及任务中的数据,并根据所提取的数据,在其他表格中进行查询,并提取相应信息;The data extraction module is configured to extract and/or acquire data in a table and a task, and perform query in other tables according to the extracted data, and extract corresponding information;
所述数据提取模块包括:The data extraction module includes:
用于在表格中查询数据的查询模块;以及a query module for querying data in a table;
用于在表格中提取和/或获取数据以及信息的提取模块;An extraction module for extracting and/or obtaining data and information in a form;
所述数据处理模块,用于根据数据提取模块所提取出来的任务信息,判断本地会计账簿文件是否正常存入数据库,同时,用于对会计账簿文件进行解析;The data processing module is configured to determine, according to the task information extracted by the data extraction module, whether the local accounting book file is normally stored in the database, and is used for parsing the accounting book file;
所述数据处理模块包括:The data processing module includes:
用于判断本地会计账簿文件是否存入数据库的判断模块;以及a judging module for judging whether a local accounting book file is stored in a database;
用于对会计账簿进行解析的解析模块;a parsing module for parsing accounting books;
所述文件下载模块,用于根据所述数据提取模块提取出来的对账文件交互信息,下载会计账簿文件,包含下载组件;The file downloading module is configured to download an accounting book file according to the reconciliation file interaction information extracted by the data extraction module, and include a download component;
所述对账模块,用于根据所述数据提取模块所获取的商户的对账要素,将商户会计账簿文件与本地会计账簿文件进行对账,并生成对账结果文件,同时,用于将所述对账结果文件进行二次筛选处理;The reconciliation module is configured to reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant acquired by the data extraction module, and generate a reconciliation result file, and at the same time, Performing a secondary screening process on the reconciliation result file;
所述系统通用模块,用于调度所有定时任务,计时并判断是否启动对账任务,并用于存储系统执行本方法所有数据以及会计账簿文件;The system universal module is configured to schedule all timed tasks, time and determine whether to initiate a reconciliation task, and is used by the storage system to execute all data of the method and the accounting book file;
所述系统通用模块包括:The system universal module includes:
用于调度所有定时任务,并判断和启动对账任务的调度模块;以及a scheduling module for scheduling all scheduled tasks and determining and initiating reconciliation tasks;
用于进行所有定时、计时操作的定时器模块;以及a timer module for performing all timing and timing operations;
用于存储系统执行本方法所有数据以及指令的数据库。A database used by the storage system to execute all of the data and instructions of this method.
根据本申请的实施例,提供了一种计算机可读存储介质,其中,所述计 算机可读存储介质上存储有用于执行一种路由分控对账方法的程序,所述程序被处理器执行时,执行所述方法的步骤,包括:According to an embodiment of the present application, there is provided a computer readable storage medium, wherein the computer readable storage medium stores a program for executing a route sorting reconciliation method, the program being executed by a processor , performing the steps of the method, including:
步骤1、获取所述对账任务中的任务名称,根据所述任务名称,查询数据库中的商户路由信息表,获取与所述对账任务有关的商户信息;Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;
步骤2、根据所述商户信息,查询商户管理信息表,获取商户配置信息;所述商户配置信息中包含有商户号、商户的对账日期;Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date;
步骤3、判断所述商户配置信息是否满足对账任务启动时间判断规则,若是,则执行步骤4;否则,结束本方法;Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;
步骤4、根据所述商户配置信息,查询对账文件交互路由信息表,获取所述商户对账文件交互信息,并根据所述商户对账文件交互信息获取商户会计账簿文件;Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;
步骤5、根据所述商户配置信息,判断与所述商户有关的本地对账文件是否正常存入数据库,若是,则从所述数据库获取所述本地对账文件,并执行步骤7;否则,执行步骤6;Step 5: Determine, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, obtain the local reconciliation file from the database, and perform step 7; otherwise, execute Step 6;
步骤6、系统继续等待一定时间后,返回执行步骤5;Step 6, after the system continues to wait for a certain period of time, return to step 5;
步骤7、从所述商户配置信息中提取所述商户的对账要素,根据所述商户的对账要素,将所述商户会计账簿文件与本地对账文件进行对账,并生成对账结果文件。Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file. .
本申请的有益效果主要在于:既简便不同接入方在不同交易场景下对账操作的处理与维护,实现不同的数据交互方式,避免代码的高耦合,提高技术的兼容性,高效且安全地处理和存储对账结果数据,并实现对账代码及数据库平台的无关迁移;同时,亦方便用户进行相关路由信息表的数据维护,提升用户体验。此外,使用本申请的路由分控对账方法,可以实现跨平台对账支持,实现多模式混合对账快速安全接入。通过对不同商户不同场景下的对账参数化、路由化,实现商户管理后管可配置化,实现文件信息管理参数可配置化,同时,实现对账文件维度以及系统参数信息可配置化。The beneficial effects of the present application are mainly: simplifying the processing and maintenance of the reconciliation operations of different access parties in different transaction scenarios, realizing different data interaction modes, avoiding high coupling of codes, improving technical compatibility, and efficiently and safely. Process and store the reconciliation result data, and realize the irrelevant migration of the reconciliation code and the database platform; at the same time, it is convenient for the user to perform data maintenance of the related routing information table to improve the user experience. In addition, by using the route control reconciliation method of the present application, cross-platform reconciliation support can be realized, and multi-mode hybrid reconciliation fast and secure access can be realized. By parameterizing and routing the reconciliations in different scenarios of different merchants, the merchant management can be configured and configurable, and the file information management parameters can be configured. At the same time, the reconciliation file dimensions and system parameter information can be configured.
附图说明DRAWINGS
图1为根据本申请的实施例的一种路由分控对账方法的流程示意图;1 is a schematic flow chart of a method for routing and controlling reconciliation according to an embodiment of the present application;
图2为根据本申请的实施例的一种路由分控对账方法中定时任务启动时间判断规则的流程示意图;2 is a schematic flowchart of a timing task start time determination rule in a route control reconciliation reconciliation method according to an embodiment of the present application;
图3为根据本申请的实施例的一种路由分控对账方法中步骤S100的详细流程示意图;FIG. 3 is a schematic flowchart diagram of step S100 in a route control reconciliation reconciliation method according to an embodiment of the present application;
图4为根据本申请的实施例的一种路由分控对账方法中步骤S101的详细流程示意图;FIG. 4 is a schematic flowchart diagram of step S101 in a method for routing and controlling reconciliation according to an embodiment of the present application;
图5为根据本申请的实施例的一种路由分控对账系统的架构示意图;FIG. 5 is a schematic structural diagram of a route split control reconciliation system according to an embodiment of the present application; FIG.
图6为根据本申请的实施例的安装了应用程序的系统的运行环境的示意图。6 is a schematic diagram of an operating environment of a system in which an application is installed, in accordance with an embodiment of the present application.
具体实施方式Detailed ways
下面,结合附图对技术方案的实施作进一步的详细描述。The implementation of the technical solution will be further described in detail below with reference to the accompanying drawings.
本领域的技术人员能够理解,尽管以下的说明涉及到有关本申请的实施例的很多技术细节,但这仅为用来说明本申请的原理的示例、而不意味着任何限制。本申请能够适用于不同于以下例举的技术细节之外的场合,只要它们不背离本申请的原理和精神即可。It will be understood by those skilled in the art that the following description is to be construed as illustrative of the embodiments of the invention. The present application can be applied to other than the technical details exemplified below, as long as they do not depart from the principles and spirit of the present application.
另外,为了避免使本说明书的描述限于冗繁,在本说明书中的描述中,可能对可在现有技术资料中获得的部分技术细节进行了省略、简化、变通等处理,这对于本领域的技术人员来说是可以理解的,并且这不会影响本说明书的公开充分性。In addition, in order to avoid limitation of the description of the present specification to the simplifications, in the description in the specification, some technical details that can be obtained in the prior art materials may be omitted, simplified, modified, etc., which is a technique in the art. It is understandable to the person and this does not affect the disclosure adequacy of this specification.
下文中,将描述用于进行本申请的实施例。注意,将以下面的次序给出描述:1、发明构思的概要;2、一种路由分控对账方法(图1-图4);3、一种路由分控对账系统(图5);4、根据本申请的实施例的安装了应用程序的系统、以及存储所述应用程序的计算机可读介质(图6)。Hereinafter, embodiments for carrying out the present application will be described. Note that the description will be given in the following order: 1. Outline of the inventive concept; 2. A route sorting reconciliation method (Fig. 1 - Fig. 4); 3. A route sorting reconciliation reconciliation system (Fig. 5) 4. A system on which an application is installed, and a computer readable medium storing the application (FIG. 6) according to an embodiment of the present application.
1、发明构思的概要1. Summary of the inventive concept
针对市面上不同的会计账簿接入方数据交互耦合度过高的对账方式,本申请依赖Mongodb的文本数据存储功能、Oracle高效的读写性能、redis的缓存锁、MQ消息中间件的优势,结合技术框架PAFA5,总结出一套行之有效的利用路由化信息的对账分控引擎路由解决方案。The application relies on Mongodb's text data storage function, Oracle's efficient read and write performance, redis cache lock, and MQ message middleware for the reconciliation of different accounting book access data. Combined with the technical framework PAFA5, a set of effective reconciliation control engine routing solutions using routing information is summarized.
具体说来,通过建立多个路由信息参数表,使表与表之间存在之间或者间接的关联,并利用程序建立表与表之间的使用关系,通过路由化对账,灵活组合多个路由来实现分控对账处理,同时通过建立相关路由控制信息来获取不同商户在不同交易场景下的对账周期、对账数据原格式、对账启动日期以及对账要素等等数据,从而依据前述数据与信息,来完成对账操作。Specifically, by establishing a plurality of routing information parameter tables, there is an indirect or indirect association between the tables and the tables, and a program is used to establish a usage relationship between the tables and the tables, and the plurality of flexible combinations are performed through routing reconciliation. Routing to achieve sub-control reconciliation processing, and at the same time establish relevant routing control information to obtain the reconciliation period, reconciliation data original format, reconciliation start date and reconciliation elements of different merchants in different transaction scenarios, etc. The aforementioned data and information to complete the reconciliation operation.
2、一种路由分控对账方法(图1-图4)2. A routing control reconciliation method (Figure 1 - Figure 4)
鉴于现有技术中系统数据交互耦合度过高,导致实际对账解决方案无法满足不同接入方的对账需求,具有较大局限性的问题,本申请的实施例提出了有效地降低数据交互耦合度,且支持跨平台对账以及多模式混合对账快速安全接入方案的一种路由分控对账方法。In view of the problem that the system data interaction coupling degree in the prior art is too high, the actual reconciliation solution cannot meet the reconciliation requirements of different access parties, and the problem has a large limitation, the embodiment of the present application proposes to effectively reduce the data interaction. A routing and reconciliation method that supports coupling and supports cross-platform reconciliation and multi-mode hybrid reconciliation fast secure access scheme.
如图1所示,一种路由分控对账方法根据对账任务启动时间,启动执行对账任务,所述对账任务包括以下步骤:As shown in FIG. 1 , a routing control reconciliation method starts a reconciliation task according to a reconciliation task startup time, and the reconciliation task includes the following steps:
其中,系统通过总调度任务来控制判断对账任务启动时间,具体说来,系统总调度任务每隔10分钟进行轮询,获取总调度任务中所有加载的定时任务的基本参数,其中,所有定时任务的基本参数包括任务名称、任务执行方式、任务对账日期、任务启动时间、任务最晚执行时间和文件存储目录等。系统通过轮询,判断定时任务中的定时对账任务是否启动。The system controls the reconciliation task startup time through the total scheduling task. Specifically, the system total scheduling task performs polling every 10 minutes to obtain basic parameters of all loaded timing tasks in the total scheduling task, wherein all timings are The basic parameters of the task include the task name, task execution mode, task reconciliation date, task startup time, task execution time, and file storage directory. The system polls to determine whether the scheduled reconciliation task in the scheduled task is started.
总调度任务判断对账任务启动时间,具体包括如下过程:The total scheduling task determines the startup time of the reconciliation task, and specifically includes the following process:
总调度任务启动,查询定时任务基本参数表,从该定时任务基本参数表中获取所有商户对账任务的基本参数,并根据对账任务基本参数中的对账任务启动时间,来判断该对账任务是否启动,若符合时间条件,则启动对账任务。其中,所述定时任务基本参数表中包括所有定时任务的任务名称任务启动时间、任务最晚执行时间;所述对账任务基本参数包括所有商户对账任务名称、对账任务启动时间、对账任务最晚执行时间。需要说明的是,所有商户的对账任务的对账任务启动时间、对账任务最晚执行时间均是相同的。The total scheduling task is started, the basic parameter table of the timed task is queried, the basic parameters of all the merchant reconciliation tasks are obtained from the basic parameter table of the timed task, and the reconciliation is determined according to the resumption of the reconciliation task in the basic parameters of the reconciliation task. Whether the task is started or not, if the time condition is met, the reconciliation task is started. The basic task parameter table includes a task name task start time and a task latest execution time of all the timed tasks; the basic parameters of the reconciliation task include all the merchant reconciliation task names, the reconciliation task start time, and the reconciliation The latest execution time of the task. It should be noted that the reconciliation task start time of all the reconciliation tasks of the merchants and the latest execution time of the reconciliation tasks are the same.
其中,该定时任务基本参数表提供所有定时任务的基本参数。The basic task parameter table of the timing task provides basic parameters of all timing tasks.
S100、获取所述对账任务中的任务名称,根据所述任务名称,查询数据库中的商户路由信息表,获取与所述对账任务有关的商户信息,执行S200;S100, obtaining the task name in the reconciliation task, querying the merchant routing information table in the database according to the task name, acquiring the merchant information related to the reconciliation task, and executing S200;
需要说明的是,商户路由信息表由不同参数构成,在创建新商户时,对该商户的不同参数进行组合,将该商户的对应各项参数添加进商户路由信息表中,该表主要用于记录商户信息,并记录该商户涉及的所有交易渠道号(交易ID),任务名称以及所对应的清结算规则等。系统可以通过任务名称,在商户路由信息表中查询该任务名称所对应的商户信息。前述商户路由信息表是以表格文件的形式存储在系统通用模块的数据库中。It should be noted that the merchant routing information table is composed of different parameters. When a new merchant is created, different parameters of the merchant are combined, and corresponding parameters of the merchant are added into the merchant routing information table, and the table is mainly used for Record business information, and record all transaction channel numbers (transaction IDs), task names, and corresponding settlement rules for the merchant. The system can query the merchant information corresponding to the task name in the merchant routing information table by using the task name. The aforementioned merchant routing information table is stored in the form of a form file in a database of the system general module.
S200、根据所述商户信息,查询商户管理信息表,获取商户配置信息,执行S300;S200. Query the merchant management information table according to the merchant information, obtain the merchant configuration information, and execute S300.
其中,商户管理信息表指的是包含所有商户的所有基本信息的表格,包括商户的对账日期、商户描述、清算周期、是否进行订单对账、实际对账模式、文件交互方式、文件下载方式等信息。而商户配置信息则是指在商户管理信息表中所记载的具体单一商户的对账执行方式,如对账日期、商户描述、是否进行订单对账、文件基本下载方式、实际对账模式等信息。其中,所述商户管理信息表是以表格文件的形式存储在系统通用模块的数据库中。The merchant management information table refers to a table containing all basic information of all merchants, including the merchant's reconciliation date, merchant description, clearing cycle, whether to perform order reconciliation, actual reconciliation mode, file interaction mode, and file download mode. And other information. The merchant configuration information refers to the reconciliation execution mode of the specific single merchant recorded in the merchant management information table, such as reconciliation date, merchant description, whether to perform order reconciliation, basic file download mode, actual reconciliation mode, and the like. . The merchant management information table is stored in a database of a general module of the system in the form of a form file.
系统通过将商户信息(包含商户名称、商户ID、渠道号等)与商户管理信息表中进行匹配,从商户管理信息表中找到对应的商户,并获取商户的配置信息。The system matches the merchant information (including the merchant name, the merchant ID, the channel number, and the like) with the merchant management information table, finds the corresponding merchant from the merchant management information table, and obtains the configuration information of the merchant.
S300、判断所述商户配置信息是否满足对账任务启动时间判断规则,若是,则执行S400;否则,结束本方法;S300. Determine whether the merchant configuration information meets a reconciliation task startup time determination rule, and if yes, execute S400; otherwise, end the method;
其中,根据商户配置信息中的对账日期,将该对账日期提取出来,根据预设的对账任务启动时间判断规则,判断该对账日期是否符合启动条件,若符合,则执行S400,否则,若不符合,则不启动对账,直接结束本方法,等待下次轮询。According to the reconciliation date in the merchant configuration information, the reconciliation date is extracted, and according to the preset reconciliation task initiation time judging rule, it is determined whether the reconciliation date meets the startup condition, and if yes, S400 is executed, otherwise, S400 is performed; otherwise, If it does not match, the reconciliation will not be started, and the method will be terminated directly, waiting for the next poll.
需要说明的是,定时任务启动时间判断规则是由系统预先设定好的判断规则,用于判断系统当前日期是否应当执行该对账任务。如图2所示,包含该对账任务启动时间判断规则的步骤S300具体包括以下步骤:It should be noted that the timing task start time judgment rule is a judgment rule preset by the system, and is used to determine whether the current date of the system should execute the reconciliation task. As shown in FIG. 2, the step S300 including the reconciliation task start time judging rule specifically includes the following steps:
a、根据商户配置信息,判断所述商户的对账日期是否设定为工作日,若是,则执行b;否则,执行c;a, according to the merchant configuration information, determine whether the merchant's reconciliation date is set to a working day, and if so, execute b; otherwise, execute c;
b、判断当前日期是否为工作日,若是,执行S400;否则,结束本方法;b, determining whether the current date is a working day, and if so, executing S400; otherwise, ending the method;
c、判断当前日期是否为工作日,若是,结束本方法;否则,执行S400。c. Determine whether the current date is a working day, and if so, end the method; otherwise, execute S400.
S400、根据所述商户配置信息,查询对账文件交互路由信息表,获取所述商户对账文件交互信息,并根据所述商户对账文件交互信息获取商户会计账簿文件;S400. Query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;
其中,所述对账文件交互路由信息表中包含有所有商户的所有交易场景下对账文件的具体下载方式,包括商户号、交易ID、IP地址、用户名、密码、端口号、目标服务器地址、文件名等;而对账文件交互信息是指单一商户在单一场景下的具体对账文件下载信息,包括对账文件的下载地址、端口号、目标服务器地址、文件名等。其中,所述对账文件交互路由信息表是以表格的形式,存储在系统通用模块的数据库中。The reconciliation file interaction routing information table includes specific downloading manners of reconciliation files in all transaction scenarios of all merchants, including merchant number, transaction ID, IP address, user name, password, port number, and target server address. The file reconciliation information refers to the specific reconciliation file download information of a single merchant in a single scenario, including the download address, port number, target server address, and file name of the reconciliation file. The reconciliation file interaction routing information table is stored in a database of a general module of the system in the form of a table.
系统商户配置信息中的商户号和交易ID,在对账文件交互路由信息表中找到对应该商户在该场景下的具体对账文件下载信息(即对账文件交互信息),并依据该对账文件交互信息来下载对应的会计账簿文件(即对账文件)。The merchant number and the transaction ID in the system merchant configuration information, and the specific reconciliation file download information corresponding to the merchant in the scenario (ie, the reconciliation file interaction information) is found in the reconciliation file interaction routing information table, and according to the reconciliation The file interaction information is used to download the corresponding accounting book file (ie, the reconciliation file).
S500、根据所述商户配置信息,判断与所述商户有关的本地对账文件是否正常存入数据库,若是,则执行S700;否则,执行S600;S500, determining, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, executing S700; otherwise, executing S600;
需要说明的是,步骤S500可以在步骤S400执行完成后立即执行。It should be noted that step S500 can be performed immediately after the execution of step S400 is completed.
优选地,步骤S500及其后续步骤,与步骤S100至S400并发执行,由系统不断对该对账子任务进行轮询(每隔5分钟),若文件存入数据库正常,则继续执行S700;否则,由系统间隔一定时间后,继续进行轮询。Preferably, the step S500 and the subsequent steps are performed concurrently with the steps S100 to S400, and the system continuously polls the reconciliation task (every 5 minutes), and if the file is stored in the database, the S700 is continued; otherwise, After the system has been separated by a certain period of time, polling continues.
S600、系统继续等待一定时间后,返回执行S500;S600, the system continues to wait for a certain period of time, and returns to execute S500;
需要说明的是,系统所等待的所述一定时间,可以是任何由人工设定的时间,可以是5秒,也可以是5分钟,具体的时间由人工根据系统对账的需求以及日常运行的要求进行预先设置。优选地,这里系统继续等待的一定时间设置为5分钟。优选地,若本地会计账簿文件存入数据库不正常,则系统继续进行轮询,若轮询到定时任务参数表中所记载的该对账任务最晚执行时间,该对账任务还未启动,则由系统记录超时日志,该日期不再执行该对账任务。It should be noted that the certain time that the system waits may be any manually set time, which may be 5 seconds or 5 minutes, and the specific time is manually based on the needs of the system reconciliation and daily operation. Requires a preset. Preferably, the certain time during which the system continues to wait is set to 5 minutes. Preferably, if the local accounting book file is not stored in the database, the system continues to perform polling. If the latest execution time of the reconciliation task recorded in the timed task parameter table is polled, the reconciliation task has not been started yet. The timeout log is logged by the system, and the reconciliation task is no longer executed on that date.
S700、从所述数据库获取所述本地对账文件,执行S800;S700. Obtain the local reconciliation file from the database, and execute S800.
S800、从所述商户配置信息中提取所述商户的对账要素,根据所述商户的对账要素,将所述商户会计账簿文件与本地对账文件进行对账,并生成对账结果文件。S800. Extract the reconciliation element of the merchant from the merchant configuration information, perform reconciliation of the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file.
其中,商户的对账要素是指记载在商户管理信息表中,该商户针对不同场景下的不同对账方式,其所要进行对账的要素,如商户名称、交易金额,银行账号等。Among them, the reconciliation element of the merchant refers to the elements of the reconciliation, such as the name of the merchant, the transaction amount, and the bank account number, which are recorded in the merchant management information table for different reconciliation methods in different scenarios.
需要说明的是,本申请通过定时任务基本参数表、商户路由信息表、商户管理信息表、对账文件交互路由信息表等多种表格(前述表格文件均存储在系统通用模块的数据库中),来实现信息、参数的可配置化,各个表格之 间仅仅通过商户ID、交易ID等部分信息联系,其他要素则根据不同表格的功能进行数据存储。因此,在后期维护时,通过对对账模式、交易场景等参数的灵活组合,可以配置出多个路由来实现分控对账处理。It should be noted that the present application uses a plurality of forms such as a basic task parameter list, a merchant routing information table, a merchant management information table, and a reconciliation routing information table (the foregoing table files are stored in a database of the system common module). To realize the configurability of information and parameters, each form is only contacted by some information such as merchant ID and transaction ID, and other elements are stored according to the functions of different forms. Therefore, in the post-maintenance, through flexible combination of parameters such as reconciliation mode and transaction scenario, multiple routes can be configured to implement sub-control reconciliation processing.
在本实施例中,如图3及图4所示,上述一种路由分控对账方法中启动执行对账任务之前还包括如下步骤:In this embodiment, as shown in FIG. 3 and FIG. 4, before the execution of the reconciliation task in the routing control reconciliation method, the following steps are further included:
S101、启动总调度任务;S101. Start a general scheduling task.
其中,优选地,总调度任务由系统每隔一定时间轮询一次,与后续步骤S1011-S1014之间为并发执行。Preferably, the total scheduling task is polled by the system at regular intervals, and concurrent execution is performed between the subsequent steps S1011-S1014.
优选地,总调度任务由系统每隔10分钟轮询一次。Preferably, the total scheduled task is polled by the system every 10 minutes.
其中,系统通过总调度任务来控制判断对账任务启动时间,具体说来,系统总调度任务每隔10分钟进行轮询,获取总调度任务中所有加载的定时任务的基本参数,并根据该定时任务基本参数中的定时任务启动时间,来启动相对应的定时任务(如文件下载任务、对账任务、订单入库任务等)。The system controls the start time of the reconciliation task through the total scheduling task. Specifically, the system general scheduling task performs polling every 10 minutes to obtain basic parameters of all loaded timing tasks in the total scheduling task, and according to the timing The scheduled task start time in the basic parameters of the task is used to start the corresponding scheduled task (such as file download task, reconciliation task, order warehousing task, etc.).
需要说明的是,上述总调度任务由系统的通用模块中的调度模块来完成。It should be noted that the above-mentioned total scheduling task is completed by a scheduling module in a general module of the system.
S102、查询定时任务基本参数表,获取对账任务基本参数;S102. Query a basic parameter table of the scheduled task, and obtain basic parameters of the reconciliation task;
其中,所述定时任务基本参数表中包括所有定时任务的任务名称、任务执行方式、任务对账日期、任务启动时间、任务最晚执行时间和文件存储目录等;所述对账任务基本参数包括对账任务名称、对账任务执行方式、所述对账任务启动时间、对账任务最晚执行时间和对账文件存储目录等。The basic task parameter table includes the task name of all the timed tasks, the task execution mode, the task reconciliation date, the task startup time, the task execution time, and the file storage directory. The basic parameters of the reconciliation task include The reconciliation task name, the reconciliation task execution mode, the reconciliation task startup time, the reconciliation task latest execution time, and the reconciliation file storage directory.
需要说明的是,所述定时任务基本参数表保存有所有定时任务的基本参数,其中包含有所有商户的对账任务的基本参数(对账任务是定时任务的一种)。而所有商户的对账任务执行方式虽各不相同,但是所有商户的对账任务基本参数中,对账任务启动时间,对账任务最晚执行时间是相同的。It should be noted that the basic task parameter table of the timed task stores basic parameters of all the timed tasks, and includes basic parameters of the reconciliation tasks of all the merchants (the reconciliation task is one of the timing tasks). The reconciliation tasks of all merchants are different. However, in the basic parameters of the reconciliation tasks of all merchants, the reconciliation task startup time and the reconciliation task execution time are the same.
S103、根据所述对账任务基本参数,判断系统当前时间是否符合对账任务启动时间,若是,则执行S104;否则,执行S105;S103, according to the basic parameters of the reconciliation task, determine whether the current time of the system meets the reconciliation task startup time, and if so, execute S104; otherwise, execute S105;
所述判断系统当前时间是否符合对账任务启动时间是指,系统在获取对账任务基本参数后,从该对账任务基本参数中提取对账任务启动时间参数,并将系统当前时间与该对账任务启动时间进行比对,若当前时间符合对账任务启动时间,则执行S104;否则,执行S105。The determining whether the current time of the system meets the recurring task startup time means that after obtaining the basic parameters of the reconciliation task, the system extracts the recurring task startup time parameter from the basic parameters of the reconciliation task, and the current time of the system and the pair The account task startup time is compared. If the current time meets the reconciliation task startup time, then S104 is performed; otherwise, S105 is performed.
S104、启动执行对账任务;S104. Start performing a reconciliation task.
S105、系统继续等待,并间隔一定时间,返回执行S101;S105, the system continues to wait, and is separated by a certain time, and returns to execute S101;
优选地,所述间隔一定时间为5分钟。Preferably, the interval is a certain time of 5 minutes.
优选地,如图4所示,上述步骤S101之前,还包括如下步骤:Preferably, as shown in FIG. 4, before step S101, the method further includes the following steps:
S1011、启动本地会计账簿入库任务,所述本地会计账簿入库任务周期性被轮询;S1011: Start a local accounting book storage task, and the local accounting book storage task is periodically polled;
其中,系统每隔5分钟对本地会计账簿入库任务进行轮询,即,系统每隔5分钟启动并执行本地会计账簿入库任务。Among them, the system polls the local accounting book warehousing task every 5 minutes, that is, the system starts and executes the local accounting book warehousing task every 5 minutes.
需要说明的是,上述本地会计账簿入库任务的间隔时间可以是5分钟,也可以是10分钟,可以是任何一个由人工进行预设的时间。对于本实施例来说,5分钟为系统优选的间隔时间。It should be noted that the interval of the above-mentioned local accounting book storage task may be 5 minutes or 10 minutes, and may be any time preset by a manual. For the present embodiment, 5 minutes is the preferred interval of the system.
S1012、根据商户管理信息表,获取商户配置信息;S1012: Obtain merchant configuration information according to the merchant management information table.
S1013、根据所述商户配置信息,查询数据库中本地会计账簿文件,调取与所述商户有关数据;S1013. Query a local accounting book file in the database according to the merchant configuration information, and retrieve data related to the merchant;
其中,根据所述商户的配置信息,系统在数据库中对本地会计账簿文件中所有交易流水数据进行筛选,将于本次对账任务中有关商户的有关交易流水数据进行抽取,并将该数据进行汇总,作为将要与该商户会计账簿文件进行对账的本地对账文件存入数据库中。According to the configuration information of the merchant, the system filters all transaction flow data in the local accounting book file in the database, and extracts relevant transaction flow data of the relevant merchant in the reconciliation task, and performs the data. The summary is stored in the database as a local reconciliation file that will be reconciled with the merchant accounting book file.
S1014、将所述与商户有关的数据汇总,并生成本地对账文件,存入数据库。S1014. The data related to the merchant is summarized, and a local reconciliation file is generated and stored in the database.
其中,在本地对账文件入库完成后,系统文件入库结果进行记录,以便后续系统查询文件入库是否成功。同时,系统会间隔一定时间继续进行轮询,启动定时的本地会计账簿入库任务,下载所述商户有关的本地对账文件。After the local reconciliation file is completed, the system file storage result is recorded, so that the subsequent system queries whether the file is successfully stored. At the same time, the system will continue to poll at a certain time interval, start the scheduled local accounting book storage task, and download the local reconciliation file related to the merchant.
在实施例中,上述一种路由分控对账方法中,在步骤1之前还包括如下步骤:In an embodiment, in the foregoing method for routing and reconciliation reconciliation, before step 1, the following steps are further included:
新建商户信息管理表,录入所有商户的基本信息、配置信息。Create a new business information management table and enter basic information and configuration information of all merchants.
在本实施例中,上述一种路由分控对账方法中所述步骤S400还包括如下步骤:In the embodiment, the step S400 in the routing control reconciliation method further includes the following steps:
S401、从所述对账文件交互信息中提取所述商户对账文件的目标服务器地址,下载并获取商户会计账簿文件,执行S402;S401: Extract the target server address of the merchant reconciliation file from the reconciliation file interaction information, download and obtain the merchant accounting book file, and execute S402;
S402、将所下载的所述商户会计账簿文件进行解析并存入数据库。S402. Parse the downloaded merchant account book file and store the file in the database.
其中,系统数据处理模块中的解析模块用于解析上述下载的所述商户会计账簿文件,解析后得到会计账簿文件的文件名、商户名、交易ID以及相应的交易流水等数据。The parsing module in the system data processing module is configured to parse the downloaded merchant account book file, and obtain the file name, the merchant name, the transaction ID, and the corresponding transaction pipeline data of the accounting book file after parsing.
在本实施例中,上述一种路由分控对账方法中所述步骤6之前包括如下步骤:In this embodiment, before the step 6 in the routing control reconciliation method, the method includes the following steps:
S601、根据所述对账任务基本参数,判断系统当前时间是否已经超过所述对账任务最晚执行时间,若是,则执行S602;否则,执行S600;所述一定时间为5分钟。S601. Determine, according to the basic parameters of the reconciliation task, whether the current time of the system has exceeded the latest execution time of the reconciliation task. If yes, execute S602; otherwise, execute S600; the certain time is 5 minutes.
其中,系统通过查询数据库中的定时任务基本参数表,获取该对账任务的最晚执行时间,并用当前时间与所述最晚执行时间进行对比,若当前时间已经超过了该定时任务的最晚执行时间,则系统记录超时日志(即S602),该日期不再执行该对账任务;若当前时间还没有超过定时任务最晚执行时间,则系统还可以继续进行轮询(即S603)。The system obtains the latest execution time of the reconciliation task by querying the basic task parameter list in the database, and compares the current time with the latest execution time, if the current time has exceeded the latest of the scheduled task. Execution time, the system records the timeout log (ie, S602), and the reconciliation task is no longer executed on the date; if the current time has not exceeded the latest execution time of the scheduled task, the system may continue to perform polling (ie, S603).
S602、将当前对账任务记录超时日志,同时结束本方法;S602. Record a timeout log of the current reconciliation task, and end the method at the same time;
其中,若系统当前时间已经超过所述对账任务最晚执行时间时,说明本 地会计账簿文件一直无法正常存入数据库,此时,需要系统记录该错误,并放弃执行对账任务,并于一定时间后,重新开始新的轮询与对账操作。If the current time of the system has exceeded the latest execution time of the reconciliation task, it indicates that the local accounting book file has not been properly stored in the database. At this time, the system needs to record the error and abandon the reconciliation task. After the time, restart the new polling and reconciliation operations.
在实施例中,上述一种路由分控对账方法中所述步骤7之后,还包括如下步骤:In an embodiment, after step 7 in the routing control reconciliation method, the method further includes the following steps:
S800、根据所述商户的配置信息,获取所述商户对账处理逻辑控制信息,根据所述对账处理逻辑控制信息,对所述对账结果文件中的数据进行筛选,并生成第二对账结果文件。S800. Acquire, according to the configuration information of the merchant, the merchant reconciliation processing logic control information, filter the data in the reconciliation result file according to the reconciliation processing logic control information, and generate a second reconciliation Result file.
当系统生成对账结果文件后,由于后管人员在审查时,可能基于不同的需求对对账结果文件需要进行数据筛选,为此,系统提供对账处理逻辑控制表,为不同后管人员的不同需求,规定不同的对账处理逻辑控制信息,对数据进行筛选,以方便后管人员后期处理数据。After the system generates the reconciliation result file, the post-management personnel may need to perform data screening on the reconciliation result file based on different requirements. For this reason, the system provides a reconciliation processing logic control table for different post-management personnel. Different requirements, different reconciliation processing logic control information is specified, and the data is filtered to facilitate post-processing personnel to process data.
需要说明的是,在本实施例中,商户文件的交互基本都是通过系统组件之间的MQ进行消息传递,并在下载组件中实现具体的文件下载。因此,系统各个模块间的定时任务,如文件下载任务、对账任务、文件入库任务以及本地文件/账单生成任务等任务,都是可以进行并发执行,以便系统的任务之间相互独立,从而实现系统的高效率化,使系统能够提供最优最快捷的对账解决方案。It should be noted that, in this embodiment, the interaction of the merchant files is basically through the MQ between the system components for message delivery, and the specific file download is implemented in the download component. Therefore, the tasks between the various modules of the system, such as file download tasks, reconciliation tasks, file warehousing tasks, and local file/bill generation tasks, can be executed concurrently so that the tasks of the system are independent of each other. Achieve high efficiency of the system, enabling the system to provide the best and fastest reconciliation solution.
3、一种路由分控对账系统(图5)3. A routing control reconciliation system (Figure 5)
参照图5,根据本申请的实施例,一种路由分控对账系统主要包括数据提取模块10、数据处理模块20、文件下载模块30、对账模块40以及系统通用模块50,Referring to FIG. 5, according to an embodiment of the present application, a route control reconciliation reconciliation system mainly includes a data extraction module 10, a data processing module 20, a file downloading module 30, a reconciliation module 40, and a system general module 50.
所述数据提取模块10包括:The data extraction module 10 includes:
用于在表格中查询数据的查询模块101;以及a query module 101 for querying data in a table;
用于在表格中提取和/或获取数据以及信息的提取模块102;An extraction module 102 for extracting and/or obtaining data and information in a table;
所述数据处理模块20,用于根据数据提取模块所提取出来的任务信息,判断本地会计账簿文件是否正常存入数据库,同时,用于对会计账簿文件进行解析;The data processing module 20 is configured to determine, according to the task information extracted by the data extraction module, whether the local accounting book file is normally stored in the database, and is used for parsing the accounting book file;
所述数据处理模块20包括:The data processing module 20 includes:
用于判断本地会计账簿文件是否存入数据库的判断模块201;以及a judging module 201 for judging whether a local accounting book file is stored in a database;
用于对会计账簿进行解析的解析模块202;a parsing module 202 for parsing the accounting book;
所述文件下载模块30,用于根据所述数据提取模块提取出来的对账文件交互信息,下载会计账簿文件,包含下载组件301;The file downloading module 30 is configured to download the accounting book file according to the reconciliation file interaction information extracted by the data extraction module, and include a download component 301;
所述对账模块40,用于根据所述数据提取模块所获取的商户的对账要素,将商户会计账簿文件与本地会计账簿文件进行对账,并生成对账结果文件,同时,用于将所述对账结果文件进行二次筛选处理;The reconciliation module 40 is configured to reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant acquired by the data extraction module, and generate a reconciliation result file, and at the same time, Performing a secondary screening process on the reconciliation result file;
所述系统通用模块50,用于调度所有定时任务,计时并判断是否启动对账任务,并用于存储系统执行本方法所有数据以及会计账簿文件;The system general module 50 is configured to schedule all timed tasks, time and determine whether to initiate a reconciliation task, and is used by the storage system to execute all data of the method and the accounting book file;
所述系统通用模块50包括:The system universal module 50 includes:
用于调度所有定时任务,并判断和启动对账任务的调度模块501;以及a scheduling module 501 for scheduling all scheduled tasks and determining and initiating a reconciliation task;
用于进行所有定时、计时操作的定时器模块502;以及a timer module 502 for performing all timing and timing operations;
用于存储系统执行本方法所有数据以及会计账簿文件的数据库503。A database 503 for storing all data of the method and accounting book files for the storage system.
此外,本申请的不同实施例也可以通过软件模块或存储在一个或多个计算机可读介质上的计算机可读指令的方式实现,其中,所述计算机可读指令是当被处理器或设备组件执行时,执行本申请所述的不同的实施例。类似地,软件模块、计算机可读介质和硬件部件的任意组合都是本申请预期的。所述软件模块可以被存储在任意类型的计算机可读存储介质上,例如RAM、EPROM、EEPROM、闪存、寄存器、硬盘、CD-ROM、DVD等等。Furthermore, various embodiments of the present application can also be implemented by a software module or computer readable instructions stored on one or more computer readable medium, where the computer readable instructions are when When executed, the various embodiments described herein are performed. Similarly, any combination of software modules, computer readable media, and hardware components are contemplated by the present application. The software modules can be stored on any type of computer readable storage medium such as RAM, EPROM, EEPROM, flash memory, registers, hard disk, CD-ROM, DVD, and the like.
4、根据本申请的实施例的安装了应用程序的系统4. An application-installed system according to an embodiment of the present application
参照图6,其示出了根据本申请的实施例的安装了应用程序的系统的运行环境。Referring to Figure 6, there is shown an operating environment of a system in which an application is installed, in accordance with an embodiment of the present application.
在本实施例中,所述的安装应用程序的系统安装并运行于电子装置中。所述电子装置可以是桌上型计算机、笔记本、掌上电脑及服务器等计算设备。该电子装置可包括但不限于存储器、处理器及显示器。图6仅示出了具有上述组件的电子装置,但是应理解的是,并不要求实施所有示出的组件,可以替代的实施更多或者更少的组件。In this embodiment, the system for installing the application is installed and runs in the electronic device. The electronic device may be a computing device such as a desktop computer, a notebook, a palmtop computer, or a server. The electronic device can include, but is not limited to, a memory, a processor, and a display. Figure 6 shows only the electronic device having the above components, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.
所述存储器在一些实施例中可以是所述电子装置的内部存储单元,例如该电子装置的硬盘或内存。所述存储器在另一些实施例中也可以是所述电子装置的外部存储设备,例如所述电子装置上配备的插接式硬盘,智能存储卡(Smart Media Card,SMC),安全数字(Secure Digital,SD)卡,闪存卡(Flash Card)等。进一步地,所述存储器还可以既包括所述电子装置的内部存储单元也包括外部存储设备。所述存储器用于存储安装于所述电子装置的应用软件及各类数据,例如所述安装应用程序的系统的程序代码等。所述存储器还可以用于暂时地存储已经输出或者将要输出的数据。The memory may be an internal storage unit of the electronic device, such as a hard disk or memory of the electronic device, in some embodiments. The memory may also be an external storage device of the electronic device in other embodiments, such as a plug-in hard disk equipped on the electronic device, a smart memory card (SMC), and a secure digital (Secure Digital) , SD) card, flash card (Flash Card), etc. Further, the memory may also include both an internal storage unit of the electronic device and an external storage device. The memory is used to store application software installed on the electronic device and various types of data, such as program code of the system in which the application is installed. The memory can also be used to temporarily store data that has been output or is about to be output.
所述处理器在一些实施例中可以是中央处理单元(Central Processing Unit,CPU)、微处理器或其他数据处理芯片,用于运行所述存储器中存储的程序代码或处理数据,例如执行所述安装应用程序的系统等。The processor may, in some embodiments, be a central processing unit (CPU), a microprocessor, or other data processing chip for executing program code or processing data stored in the memory, such as performing the Install the application's system, etc.
所述显示器在一些实施例中可以是LED显示器、液晶显示器、触控式液晶显示器以及OLED(Organic Light-Emitting Diode,有机发光二极管)触摸器等。所述显示器用于显示在所述电子装置中处理的信息以及用于显示可视化的用户界面,例如应用菜单界面、应用图标界面等。所述电子装置的部件通过系统总线相互通信。The display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch sensor, or the like in some embodiments. The display is for displaying information processed in the electronic device and a user interface for displaying visualizations, such as an application menu interface, an application icon interface, and the like. The components of the electronic device communicate with one another via a system bus.
通过以上的实施方式的描述,本领域的技术人员可以清楚地了解,上述实施方式中的方法可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件来实现,但很多情况下前者是更佳的实施方式。基于这样的理 解,本申请本申请的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质(如ROM/RAM、磁碟、光盘)中,包括若干指令用以使得一台终端设备(可以是手机,计算机,服务器,空调器,或者网络设备等)执行本申请本申请各个实施例所述的方法。Through the description of the above embodiments, those skilled in the art can clearly understand that the method in the foregoing embodiment can be implemented by means of software plus a necessary general hardware platform, and can also be implemented by hardware, but in many cases. The former is a better implementation. Based on such understanding, the technical solution of the present application in essence or the contribution to the prior art can be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, magnetic The disc, the optical disc, includes a plurality of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method described in the various embodiments of the present application.
也就是说,根据本申请的实施例,还提供了一种计算机可读存储介质,所述计算机可读存储介质上存储有用于执行一种路由分控对账的程序,所述程序被处理器执行时,执行根据本申请的实施例的路由分控对账的步骤。That is, according to an embodiment of the present application, there is also provided a computer readable storage medium having stored thereon a program for performing a route sorting reconciliation, the program being processed by a processor When executed, the steps of routing control reconciliation according to an embodiment of the present application are performed.
由上,将理解,为了说明的目的,这里已描述了本申请的具体实施例,但是,可作出各个修改,而不会背离本申请的范围。本领域的技术人员将理解,流程图步骤中所绘出或这里描述的操作和例程可以多种方式变化。更具体地,可重新安排步骤的次序,可并行执行步骤,可省略步骤,可包括其它步骤,可作出例程的各种组合或省略。因而,本申请仅由所附权利要求限制。It will be understood that the specific embodiments of the present invention have been described herein for the purpose of illustration, but the various modifications may be made without departing from the scope of the application. Those skilled in the art will appreciate that the operations and routines depicted in the flowchart steps or described herein can be varied in many ways. More specifically, the order of the steps may be rearranged, the steps may be performed in parallel, the steps may be omitted, other steps may be included, various combinations or omissions of routines may be made. Accordingly, the application is limited only by the accompanying claims.

Claims (20)

  1. 一种路由分控对账方法,其特征在于,根据对账任务启动时间,启动执行对账任务,所述对账任务包括以下步骤:A routing control reconciliation method is characterized in that, according to a reconciliation task startup time, a reconciliation task is started, and the reconciliation task comprises the following steps:
    步骤1、获取所述对账任务中的任务名称,根据所述任务名称,查询数据库中的商户路由信息表,获取与所述对账任务有关的商户信息;Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;
    步骤2、根据所述商户信息,查询商户管理信息表,获取商户配置信息;所述商户配置信息中包含有商户号、商户的对账日期;Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date;
    步骤3、判断所述商户配置信息是否满足对账任务启动时间判断规则,若是,则执行步骤4;否则,结束本方法;Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;
    步骤4、根据所述商户配置信息,查询对账文件交互路由信息表,获取所述商户对账文件交互信息,并根据所述商户对账文件交互信息获取商户会计账簿文件;Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;
    步骤5、根据所述商户配置信息,判断与所述商户有关的本地对账文件是否正常存入数据库,若是,则从所述数据库获取所述本地对账文件,并执行步骤7;否则,执行步骤6;Step 5: Determine, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, obtain the local reconciliation file from the database, and perform step 7; otherwise, execute Step 6;
    步骤6、系统继续等待一定时间后,返回执行步骤5;Step 6, after the system continues to wait for a certain period of time, return to step 5;
    步骤7、从所述商户配置信息中提取所述商户的对账要素,根据所述商户的对账要素,将所述商户会计账簿文件与本地对账文件进行对账,并生成对账结果文件。Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file. .
  2. 根据权利要求1所述的一种路由分控对账方法,其特征在于,启动执行对账任务之前还包括如下步骤:The method for routing and reconciliation reconciliation according to claim 1, wherein the step of performing the reconciliation task further comprises the following steps:
    步骤101、查询定时任务基本参数表,获取定时任务基本参数;Step 101: Query a basic parameter table of the timed task, and obtain basic parameters of the timed task;
    其中,所述定时任务基本参数包括所有商户的任务名称、任务启动时间、任务最晚执行时间;The basic parameters of the timed task include the task name of all merchants, the task startup time, and the latest execution time of the task;
    步骤103、根据所述定时任务基本参数,判断系统当前时间是否符合任务启动时间,若符合,则执行步骤104;否则,系统继续等待,并间隔一定时间后返回执行步骤101;Step 103, according to the basic parameters of the timed task, determine whether the current time of the system meets the task start time, if yes, proceed to step 104; otherwise, the system continues to wait, and after a certain time interval, returns to step 101;
    步骤104、启动执行对账任务。Step 104: Start performing a reconciliation task.
  3. 根据权利要求2所述的一种路由分控对账方法,其特征在于,所述步骤101之前,还包括如下步骤:The method of reconciliation and reconciliation of a route according to claim 2, wherein before the step 101, the method further comprises the following steps:
    步骤1011、启动本地会计账簿入库任务,所述本地会计账簿入库任务周期性被轮询;Step 1011: Start a local accounting book storage task, and the local accounting book storage task is periodically polled;
    步骤1012、根据商户管理信息表,获取商户配置信息;Step 1012: Obtain merchant configuration information according to the merchant management information table.
    步骤1013、根据所述商户配置信息,查询数据库中本地会计账簿文件,调取与所述商户有关的数据;Step 1013: Query a local accounting book file in the database according to the merchant configuration information, and retrieve data related to the merchant;
    步骤1014、将所述与商户有关的数据汇总,并生成本地对账文件,存入数据库。Step 1014, summarizing the data related to the merchant, and generating a local reconciliation file, and storing the data in the database.
  4. 根据权利要求2所述的一种路由分控对账方法,其特征在于,所述步骤3包括如下步骤:The route control reconciliation method according to claim 2, wherein the step 3 comprises the following steps:
    a、根据商户配置信息,判断所述商户的对账日期是否被设定为工作日,若是,则执行b;否则,执行c;a, according to the merchant configuration information, determine whether the merchant's reconciliation date is set as the working day, and if so, execute b; otherwise, execute c;
    b、判断当前日期是否为工作日,若是,执行步骤4;否则,结束本方法;b. Determine whether the current date is a working day, and if yes, perform step 4; otherwise, end the method;
    c、判断当前日期是否为工作日,若是,结束本方法;否则,执行步骤4。c. Determine whether the current date is a working day. If yes, end the method; otherwise, perform step 4.
  5. 根据权利要求1所述的一种路由分控对账方法,其特征在于,在步骤1之前还包括:新建商户信息管理表,录入所有商户的基本信息、配置信息。The method for reconciliation of a route control according to claim 1, further comprising: creating a new merchant information management table, and inputting basic information and configuration information of all the merchants.
  6. 根据权利要求1所述的一种路由分控对账方法,其特征在于,所述步骤4还包括如下步骤:The method of routing control reconciliation according to claim 1, wherein the step 4 further comprises the following steps:
    从所述商户对账文件交互信息中提取所述商户对账文件的目标服务器地址,下载商户会计账簿文件;Extracting a target server address of the merchant reconciliation file from the merchant reconciliation file interaction information, and downloading a merchant accounting book file;
    将所下载的所述商户会计账簿文件进行解析并存入数据库。The downloaded merchant account book file is parsed and stored in the database.
  7. 根据权利要求2所述的一种路由分控对账方法,其特征在于,在所述步骤6之前包括如下步骤:The route sorting reconciliation method according to claim 2, characterized in that before the step 6, the following steps are included:
    根据定时任务基本参数,判断系统当前时间是否已经超过所述商户对账的任务最晚执行时间,若是,将当前对账任务记入超时日志,同时结束本方法,否则,执行步骤6。According to the basic parameters of the timed task, it is determined whether the current time of the system has exceeded the latest execution time of the task of the merchant reconciliation. If yes, the current reconciliation task is recorded in the timeout log, and the method is terminated. Otherwise, step 6 is performed.
  8. 根据权利要求2所述的一种路由分控对账方法,其特征在于,所述一定时间为5分钟。The route control reconciliation method according to claim 2, wherein the certain time is 5 minutes.
  9. 根据权利要求1所述的一种路由分控对账方法,其特征在于,所述步骤7之后,还包括如下步骤:The method of reconciliation and reconciliation of a route according to claim 1, wherein after the step 7, the method further comprises the following steps:
    根据所述商户配置信息,获取所述商户对账处理逻辑控制信息。Obtaining the merchant reconciliation processing logic control information according to the merchant configuration information.
  10. 根据权利要求9所述的一种路由分控对账方法,其特征在于,所述步骤7之后,还包括如下步骤:The routing control reconciliation method according to claim 9, wherein after the step 7, the method further comprises the following steps:
    根据所述对账处理逻辑控制信息,对所述对账结果文件中的数据进行筛选,并生成第二对账结果文件。And filtering the data in the reconciliation result file according to the reconciliation processing logic control information, and generating a second reconciliation result file.
  11. 一种路由分控对账系统,其特征在于,所述系统包括数据提取模块、数据处理模块、文件下载模块、对账模块以及系统通用模块,A route sub-control reconciliation system, characterized in that the system comprises a data extraction module, a data processing module, a file downloading module, a reconciliation module and a system general module.
    其中,所述数据提取模块用于提取和/或获取表格以及任务中的数据,并根据所提取的数据,在其他表格中进行查询,并提取相应信息;The data extraction module is configured to extract and/or acquire data in a table and a task, and perform query in other tables according to the extracted data, and extract corresponding information;
    所述数据提取模块包括:The data extraction module includes:
    用于在表格中查询数据的查询模块;以及a query module for querying data in a table;
    用于在表格中提取和/或获取数据以及信息的提取模块;An extraction module for extracting and/or obtaining data and information in a form;
    其中,所述数据处理模块用于根据数据提取模块所提取出来的任务信息,判断本地会计账簿文件是否正常存入数据库,同时,用于对会计账簿文件进行解析;The data processing module is configured to determine, according to the task information extracted by the data extraction module, whether the local accounting book file is normally stored in the database, and is used for parsing the accounting book file;
    所述数据处理模块包括:The data processing module includes:
    用于判断本地会计账簿文件是否存入数据库的判断模块;以及a judging module for judging whether a local accounting book file is stored in a database;
    用于对会计账簿进行解析的解析模块;a parsing module for parsing accounting books;
    其中,所述文件下载模块用于根据所述数据提取模块提取出来的对账文件交互信息,下载会计账簿文件,包含下载组件;The file downloading module is configured to download an accounting book file according to the reconciliation file interaction information extracted by the data extraction module, and include a download component;
    其中,所述对账模块用于根据所述数据提取模块所获取的商户的对账要素,将商户会计账簿文件与本地会计账簿文件进行对账,并生成对账结果文件,同时,用于将所述对账结果文件进行二次筛选处理;The reconciliation module is configured to reconcile the merchant accounting book file with the local accounting book file according to the reconciliation element of the merchant acquired by the data extraction module, and generate a reconciliation result file, and at the same time, Performing a secondary screening process on the reconciliation result file;
    其中,所述系统通用模块用于调度所有定时任务,计时并判断是否启动对账任务,并用于存储系统执行本方法所有数据以及会计账簿文件;The system universal module is configured to schedule all timed tasks, time and determine whether to initiate a reconciliation task, and is used by the storage system to execute all data of the method and accounting book files;
    所述系统通用模块包括:The system universal module includes:
    用于调度所有定时任务,并判断和启动对账任务的调度模块;以及a scheduling module for scheduling all scheduled tasks and determining and initiating reconciliation tasks;
    用于进行所有定时、计时操作的定时器模块;以及a timer module for performing all timing and timing operations;
    用于存储系统执行本方法所需数据以及会计账簿文件的数据库。A database used to store the data required by the system to perform this method, as well as accounting book files.
  12. 一种计算机可读存储介质,其特征在于,所述计算机可读存储介质上存储有用于执行一种路由分控对账方法的程序,所述程序被处理器执行时,执行所述方法的步骤,包括:A computer readable storage medium, wherein the computer readable storage medium stores a program for executing a route sorting and reconciliation method, and when the program is executed by the processor, performing the steps of the method ,include:
    步骤1、获取所述对账任务中的任务名称,根据所述任务名称,查询数据库中的商户路由信息表,获取与所述对账任务有关的商户信息;Step 1: Obtain a task name in the reconciliation task, query a merchant routing information table in the database according to the task name, and obtain business information related to the reconciliation task;
    步骤2、根据所述商户信息,查询商户管理信息表,获取商户配置信息;所述商户配置信息中包含有商户号、商户的对账日期;Step 2: Query the merchant management information table according to the merchant information, and obtain the merchant configuration information; the merchant configuration information includes the merchant account number and the merchant's reconciliation date;
    步骤3、判断所述商户配置信息是否满足对账任务启动时间判断规则,若是,则执行步骤4;否则,结束本方法;Step 3: Determine whether the merchant configuration information satisfies the reconciliation task startup time determination rule, and if yes, perform step 4; otherwise, end the method;
    步骤4、根据所述商户配置信息,查询对账文件交互路由信息表,获取所述商户对账文件交互信息,并根据所述商户对账文件交互信息获取商户会计账簿文件;Step 4: query the reconciliation routing information table of the reconciliation file according to the merchant configuration information, obtain the interaction information of the merchant reconciliation file, and obtain the merchant accounting book file according to the merchant reconciliation file interaction information;
    步骤5、根据所述商户配置信息,判断与所述商户有关的本地对账文件是否正常存入数据库,若是,则从所述数据库获取所述本地对账文件,并执行步骤7;否则,执行步骤6;Step 5: Determine, according to the merchant configuration information, whether the local reconciliation file related to the merchant is normally stored in the database, and if yes, obtain the local reconciliation file from the database, and perform step 7; otherwise, execute Step 6;
    步骤6、系统继续等待一定时间后,返回执行步骤5;Step 6, after the system continues to wait for a certain period of time, return to step 5;
    步骤7、从所述商户配置信息中提取所述商户的对账要素,根据所述商户的对账要素,将所述商户会计账簿文件与本地对账文件进行对账,并生成对账结果文件。Step 7. Extract the reconciliation element of the merchant from the merchant configuration information, reconcile the merchant accounting book file with the local reconciliation file according to the reconciliation element of the merchant, and generate a reconciliation result file. .
  13. 根据权利要求12所述的计算机可读存储介质,其特征在于,启动执行对账任务之前还包括如下步骤:The computer readable storage medium of claim 12, further comprising the steps of: before initiating the reconciliation task:
    步骤101、查询定时任务基本参数表,获取定时任务基本参数;Step 101: Query a basic parameter table of the timed task, and obtain basic parameters of the timed task;
    其中,所述定时任务基本参数包括所有商户的任务名称、任务启动时间、任务最晚执行时间;The basic parameters of the timed task include the task name of all merchants, the task startup time, and the latest execution time of the task;
    步骤103、根据所述定时任务基本参数,判断系统当前时间是否符合任务启动时间,若符合,则执行步骤104;否则,系统继续等待,并间隔一定时间后返回执行步骤101;Step 103, according to the basic parameters of the timed task, determine whether the current time of the system meets the task start time, if yes, proceed to step 104; otherwise, the system continues to wait, and after a certain time interval, returns to step 101;
    步骤104、启动执行对账任务。Step 104: Start performing a reconciliation task.
  14. 根据权利要求13所述的计算机可读存储介质,其特征在于,所述步骤101之前,还包括如下步骤:The computer readable storage medium according to claim 13, wherein before the step 101, the method further comprises the following steps:
    步骤1011、启动本地会计账簿入库任务,所述本地会计账簿入库任务周期性被轮询;Step 1011: Start a local accounting book storage task, and the local accounting book storage task is periodically polled;
    步骤1012、根据商户管理信息表,获取商户配置信息;Step 1012: Obtain merchant configuration information according to the merchant management information table.
    步骤1013、根据所述商户配置信息,查询数据库中本地会计账簿文件,调取与所述商户有关的数据;Step 1013: Query a local accounting book file in the database according to the merchant configuration information, and retrieve data related to the merchant;
    步骤1014、将所述与商户有关的数据汇总,并生成本地对账文件,存入数据库。Step 1014, summarizing the data related to the merchant, and generating a local reconciliation file, and storing the data in the database.
  15. 根据权利要求13所述的计算机可读存储介质,其特征在于,所述步骤3包括如下步骤:The computer readable storage medium of claim 13, wherein the step 3 comprises the steps of:
    a、根据商户配置信息,判断所述商户的对账日期是否被设定为工作日,若是,则执行b;否则,执行c;a, according to the merchant configuration information, determine whether the merchant's reconciliation date is set as the working day, and if so, execute b; otherwise, execute c;
    b、判断当前日期是否为工作日,若是,执行步骤4;否则,结束本方法;b. Determine whether the current date is a working day, and if yes, perform step 4; otherwise, end the method;
    c、判断当前日期是否为工作日,若是,结束本方法;否则,执行步骤4。c. Determine whether the current date is a working day. If yes, end the method; otherwise, perform step 4.
  16. 根据权利要求12所述的计算机可读存储介质,其特征在于,在步骤1之前还包括:新建商户信息管理表,录入所有商户的基本信息、配置信息。The computer readable storage medium according to claim 12, further comprising: before the step 1, the new merchant information management table is configured to input basic information and configuration information of all the merchants.
  17. 根据权利要求12所述的计算机可读存储介质,其特征在于,所述步骤4还包括如下步骤:The computer readable storage medium of claim 12, wherein the step 4 further comprises the steps of:
    从所述商户对账文件交互信息中提取所述商户对账文件的目标服务器地址,下载商户会计账簿文件;Extracting a target server address of the merchant reconciliation file from the merchant reconciliation file interaction information, and downloading a merchant accounting book file;
    将所下载的所述商户会计账簿文件进行解析并存入数据库。The downloaded merchant account book file is parsed and stored in the database.
  18. 根据权利要求13所述的计算机可读存储介质,其特征在于,在所述步骤6之前包括如下步骤:The computer readable storage medium according to claim 13, wherein before said step 6, the following steps are included:
    根据定时任务基本参数,判断系统当前时间是否已经超过所述商户对账的任务最晚执行时间,若是,将当前对账任务记入超时日志,同时结束本方法,否则,执行步骤6。According to the basic parameters of the timed task, it is determined whether the current time of the system has exceeded the latest execution time of the task of the merchant reconciliation. If yes, the current reconciliation task is recorded in the timeout log, and the method is terminated. Otherwise, step 6 is performed.
  19. 根据权利要求13所述的计算机可读存储介质,其特征在于,所述一定时间为5分钟。The computer readable storage medium of claim 13, wherein the certain time is 5 minutes.
  20. 根据权利要求12所述的计算机可读存储介质,其特征在于,所述步骤7之后,还包括如下步骤:The computer readable storage medium according to claim 12, wherein after the step 7, the method further comprises the steps of:
    根据所述商户配置信息,获取所述商户对账处理逻辑控制信息,Obtaining, according to the merchant configuration information, the logic control information of the merchant reconciliation processing,
    根据所述对账处理逻辑控制信息,对所述对账结果文件中的数据进行筛 选,并生成第二对账结果文件。Based on the reconciliation processing logic control information, the data in the reconciliation result file is filtered and a second reconciliation result file is generated.
PCT/CN2018/083064 2018-02-13 2018-04-13 Routing sub-control reconciliation method and system WO2019157777A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810148432.5 2018-02-13
CN201810148432.5A CN108280754B (en) 2018-02-13 2018-02-13 Routing sub-control account checking method and system

Publications (1)

Publication Number Publication Date
WO2019157777A1 true WO2019157777A1 (en) 2019-08-22

Family

ID=62808394

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/083064 WO2019157777A1 (en) 2018-02-13 2018-04-13 Routing sub-control reconciliation method and system

Country Status (2)

Country Link
CN (1) CN108280754B (en)
WO (1) WO2019157777A1 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109872785A (en) * 2019-01-29 2019-06-11 浪潮金融信息技术有限公司 A kind of method that timing downloading barcode scanning pays statement
CN110738477A (en) * 2019-08-22 2020-01-31 威富通科技有限公司 reconciliation method, device, computer equipment and storage medium
CN110751550B (en) * 2019-10-12 2022-09-13 未鲲(上海)科技服务有限公司 Account checking method and device, computer equipment and storage medium
CN112308513B (en) * 2020-10-30 2021-08-03 广州市汇聚支付电子科技有限公司 Automatic account checking system and method based on big data

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130046682A1 (en) * 2010-02-02 2013-02-21 Traxpay Ag Electronic clearing and payment system
CN107301595A (en) * 2017-07-12 2017-10-27 百望电子发票数据服务有限公司 A kind of electronic invoice account checking method and system

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7603314B2 (en) * 2004-03-25 2009-10-13 International Business Machines Corporation Automatic billing event submission reconciliation for on demand systems
CN103177368A (en) * 2013-04-19 2013-06-26 中国建设银行股份有限公司 Reconciliation method and system for electronic commerce system
CN105094959B (en) * 2015-07-01 2018-12-28 北京京东尚科信息技术有限公司 It is a kind of that the method and apparatus of reconciliation file are provided
CN105405007A (en) * 2015-11-19 2016-03-16 成都连银信息技术有限公司 Unified account processing system supporting multiple types of payment channels
CN105719182B (en) * 2016-01-18 2020-03-03 北京京东尚科信息技术有限公司 Automatic account checking method and automatic account checking system
CN105761139A (en) * 2016-02-04 2016-07-13 上海携程商务有限公司 Account checking system and method
CN106408410A (en) * 2016-11-29 2017-02-15 用友网络科技股份有限公司 Automatic account checking method and device
CN107122434A (en) * 2017-04-18 2017-09-01 北京思特奇信息技术股份有限公司 A kind of method and system that reconciliation file is imported to database

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130046682A1 (en) * 2010-02-02 2013-02-21 Traxpay Ag Electronic clearing and payment system
CN107301595A (en) * 2017-07-12 2017-10-27 百望电子发票数据服务有限公司 A kind of electronic invoice account checking method and system

Also Published As

Publication number Publication date
CN108280754A (en) 2018-07-13
CN108280754B (en) 2021-08-06

Similar Documents

Publication Publication Date Title
WO2019157777A1 (en) Routing sub-control reconciliation method and system
JP6940662B2 (en) Methods and systems for the protection and verification of identities and certificates via the blockchain
WO2019157776A1 (en) Processing method and system for reconciling discrepancies
US8387038B2 (en) Method and system for automatic computer and user migration
US8375063B2 (en) Method and program product for migrating data from a legacy system
WO2019196242A1 (en) Batch file auditing and entrustment payment method and system
US8630969B2 (en) Systems and methods for implementing business rules designed with cloud computing
WO2013132377A1 (en) Managing tenant-specific data sets in a multi-tenant environment
US9515948B2 (en) Techniques for generically accessing data
US10949413B2 (en) Method and system for supporting data consistency on an active standby database after DML redirection to a primary database
CN103810272A (en) Data processing method and system
CN103425468A (en) Method and device for integrating plug-in type software
WO2012152110A1 (en) Splitting rule generation method and device for clearing and settlement subsystem
CN102118436A (en) Method and system for achieving a remot control help session on a computing device
US10762147B2 (en) Inventory data access layer
WO2019227634A1 (en) Batch file partial return processing method and system
JP2004295303A (en) Log collection management system, log collection management method and computer program
US20070239720A1 (en) Virtual universal naming convention name space over local file system
KR20030047962A (en) A method of managing personal digital assistant through internet and a system thereof
JP2014041501A (en) Fast reading method for batch processing target data and batch management system
KR101254419B1 (en) System and method for providing service uninterruptedly in java enterprise editions environment
JP3577494B2 (en) Business software service system via the Internet
US20120253864A1 (en) Methods for recording and tracking projects and devices thereof
WO2012103458A1 (en) Inventory data access layer
CN111290749A (en) Data processing method, intelligent terminal and storage medium

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18906034

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205 DATED 16/11/2020)

122 Ep: pct application non-entry in european phase

Ref document number: 18906034

Country of ref document: EP

Kind code of ref document: A1