CN108280754A - A kind of routing sub-control account checking method and system - Google Patents

A kind of routing sub-control account checking method and system Download PDF

Info

Publication number
CN108280754A
CN108280754A CN201810148432.5A CN201810148432A CN108280754A CN 108280754 A CN108280754 A CN 108280754A CN 201810148432 A CN201810148432 A CN 201810148432A CN 108280754 A CN108280754 A CN 108280754A
Authority
CN
China
Prior art keywords
reconciliation
trade company
file
task
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201810148432.5A
Other languages
Chinese (zh)
Other versions
CN108280754B (en
Inventor
韦游领
刘潜
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Priority to CN201810148432.5A priority Critical patent/CN108280754B/en
Publication of CN108280754A publication Critical patent/CN108280754A/en
Application granted granted Critical
Publication of CN108280754B publication Critical patent/CN108280754B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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 invention relates to a kind of routing sub-control account checking method and systems, the described method comprises the following steps:Step 1 obtains task names, and inquiry trade company route information table obtains merchant information;Step 2, inquiry trade company management information table, obtain trade company's configuration information;Step 3 judges whether trade company's configuration information meets timed task and start time judgment rule, if so, thening follow the steps 4;Otherwise, terminate this method;Step 4, according to trade company's configuration information, obtain trade company's reconciliation file interaction information, and obtain trade company's book of accounts file;Step 5 judges whether local reconciliation file is normally stored in database, if so, obtaining the local reconciliation file from the database, and executes step 7;Otherwise, step 6 is executed;Step 6, system continue waiting for after a certain period of time, executing step 5;Step 7, extraction reconciliation element, carry out reconciliation, and generate reconciliation destination file according to the reconciliation element of the trade company.

Description

A kind of routing sub-control account checking method and system
Technical field
The present invention relates to Computer Service technical field more particularly to a kind of routing sub-control account checking method and systems.
Background technology
Reconciliation, refer to it is previous clearance the period Transaction Information check, with confirm Transaction Information consistency and The process of correctness.Should periodically will the related number of accounting bookkeeping record, money-capital, marketable securities come and go unit or individual Deng progress cross reference, ensure that account card is consistent, account account is consistent, accounts and properties are consistent.
With the development of internet and computer, numerous business carry out switching to pass through via under originally traditionally online Network is into the operation on line and under line.And accounting reconciliation turns also by traditionally artificial reconciliation by passing through network and meter Calculation machine carries out automatic reconciliation.
Reconciliation system on the market at present, for different book of accounts access sides, the coupling interaction of data spends height, Also excessively complicated, so as to cause practical reconciliation solution and cannot be satisfied the checking requirements of different access sides.For example, different Access side's reconciliation data interactive mode difference, encrypted mode difference of endorsing, the difference of reconciliation element, reconciliation result data want The difference asked so that a reconciliation system will meet aforementioned different requirements, and the coupling interaction of data spends height.Coupling high in this way Reconciliation mode directly result in system business extension and Function Extension there are great limitation, cannot provide in time quickly And the docking concept stablized, severely impacts the business development of enterprise.In addition, the reconciliation mode of coupling high in this way, can also make At the workload much repeated, also it is unfavorable for operation management and the response of event.
Invention content
Based on this, it is necessary in view of the above technical problems, a kind of method of routing sub-control reconciliation is provided, it is more by establishing A routing iinformation parameter list is made between table and table existing or to be indirectly associated with, and is established between table and table using program Use relationship, by routingization reconciliation, flexible combination multiple routings realize that sub-control reconciliation is handled, at the same pass through establish it is related Route test information starts to obtain different trade companies in the different reconciliation periods merchandised under scenes, reconciliation data original format, reconciliation Date and reconciliation element etc. data, to according to aforementioned data and information, be operated to complete reconciliation.
According to an embodiment of the invention, a kind of routing sub-control account checking method is provided to be opened according to the reconciliation task start time Dynamic to execute reconciliation task, the reconciliation task includes the following steps:
Step 1, the task names obtained in the reconciliation task inquire the quotient in database according to the task names Family route information table obtains merchant information related with the reconciliation task;
Step 2, according to the merchant information, inquiry trade company management information table obtains trade company's configuration information;The trade company matches It include the reconciliation date of trade company number, trade company in confidence breath.
Step 3 judges whether trade company's configuration information meets reconciliation task start time judgment rule, if so, holding Row step 4;Otherwise, terminate this method;
Step 4, according to trade company's configuration information, inquire reconciliation file interaction route information table, obtain the trade company pair Account file interaction information, and according to trade company's reconciliation file interaction acquisition of information trade company book of accounts file;
Step 5, according to the task names of the reconciliation task according to trade company's configuration information, judgement has with the trade company Whether the local book of accounts file of pass is normally stored in database, if so, obtaining the local meeting accounting from the database Book file, and execute step 7;Otherwise, step 6 is executed;
Step 6, system continue waiting for after a certain period of time, returning to step 5;
Step 7, the reconciliation element that the trade company is extracted from trade company's configuration information, are wanted according to the reconciliation of the trade company Trade company's book of accounts file and local book of accounts file are carried out reconciliation, and generate reconciliation destination file by element.
According to an embodiment of the invention, a kind of routing sub-control reconciliation system is provided, including at data extraction module, data Module, file download module, reconciliation module and system general module are managed,
The data extraction module, for extracting and/or obtain the data in table and task, and according to being extracted Data are inquired in other tables, and extract corresponding information;
The data extraction module includes:
Enquiry module for inquiring data in the table;And
Extraction module for extracting and/or obtaining data and information in the table;
The data processing module, the mission bit stream for being extracted according to data extraction module judge local meeting Whether accounting book file is normally stored in database, meanwhile, for being parsed to book of accounts file;
The data processing module includes:
For judging whether local book of accounts file is stored in the judgment module of database;And
Parsing module for being parsed to book of accounts;
The file download module, the reconciliation file interaction information for being extracted according to the data extraction module, Book of accounts file is downloaded, including download component;
The reconciliation module, for the reconciliation element of the trade company acquired in the data extraction module, by trade company's meeting Accounting book file carries out reconciliation with local book of accounts file, and generates reconciliation destination file, meanwhile, it is used for the reconciliation knot Fruit file carries out postsearch screening processing;
The system general module, for dispatching all timed tasks, timing simultaneously judges whether to start reconciliation task, be used in combination All data of this method and book of accounts file are executed in storage system;
The system general module includes:
For dispatching all timed tasks, and judge and start the scheduler module of reconciliation task;And
Timer module for carrying out all timings, Clocked operation;And
The database of all data of this method and instruction is executed for storage system.
According to an embodiment of the invention, a kind of computer readable storage medium is provided, wherein described computer-readable to deposit The program for executing a kind of herein described routing sub-control account checking method is stored on storage media, described program is held by processor The step of the application above method is executed when row.
Beneficial effects of the present invention essentially consist in:Both the place that reconciliation operates under different transaction scenes of easy different access sides Reason and maintenance, realize different data interactive modes, avoid the high coupling of code, the compatibility to develop skill efficiently and safe Ground processing and storage reconciliation result data, and realize the unrelated migration of reconciliation code and database platform;Meanwhile also facilitating user The data maintenance of dependent routing information table is carried out, user experience is promoted.In addition, using the routing sub-control account checking method of the application, Cross-platform reconciliation may be implemented to support, realize that multi-mode mixing reconciliation fast and safely accesses.By to different trade company's different scenes Under reconciliation parametrization, routingization, realize trade company management after pipe configurableization, realization file information management parameter configurableization, Meanwhile realizing reconciliation file dimension and system parameter message configurableization.
Description of the drawings
Fig. 1 is the flow diagram according to a kind of routing sub-control account checking method of the embodiment of the present invention;
Fig. 2 is to start time judgement rule according to timed task in a kind of routing sub-control account checking method of the embodiment of the present invention Flow diagram then;
Fig. 3 is to be illustrated according to the detailed process of step S100 in a kind of routing sub-control account checking method of the embodiment of the present invention Figure;
Fig. 4 is to be illustrated according to the detailed process of step S101 in a kind of routing sub-control account checking method of the embodiment of the present invention Figure;
Fig. 5 is the configuration diagram according to a kind of routing sub-control reconciliation system of the embodiment of the present invention;
Fig. 6 is the schematic diagram according to the running environment of the system for being mounted with application program of the embodiment of the present invention.
Specific implementation mode
In the following, being described in further detail to the implementation of technical solution in conjunction with attached drawing.
It will be appreciated by those of skill in the art that although the following description is related to many of embodiment for the present invention Technical detail, but be only for not meaning that any restrictions for illustrating the example of the principle of the present invention.The present invention can be applicable in In different from the occasion except technical detail exemplified below, without departing from the principle and spirit of the invention.
It, may pair can be in description in the present specification in addition, tedious in order to avoid making the description of this specification be limited to The portion of techniques details obtained in prior art data has carried out the processing such as omission, simplification, accommodation, this technology for this field It will be understood by for personnel, and this does not interfere with the open adequacy of this specification.
Hereinafter, it will describe for carrying out the embodiment of the present invention.Note that by description is provided with following order:1, it sends out The summary of bright design;2, a kind of routing sub-control account checking method (Fig. 1-Fig. 4);3, a kind of routing sub-control reconciliation system (Fig. 5);4, root According to the system for being mounted with application program of the embodiment of the present invention and the computer-readable medium of the storage application program (Fig. 6).
1, the summary of inventive concept
High reconciliation mode is spent according to coupling interaction for book of accounts access number formularies different on the market, the application relies on The efficient readwrite performance of the text data store function of Mongodb, Oracle, the buffer lock of redis, MQ message-oriented middlewares it is excellent Gesture, combination technology frame PAFA5 sum up a set of effective reconciliation sub-control engine routing solution using routingization information Scheme.
Particularly, by establishing multiple routing iinformation parameter lists, make between table and table existing or indirectly to close Connection, and establishes the use relationship between table and table using program, and by routingization reconciliation, flexible combination is multiple to be route to realize point Reconciliation processing is controlled, while reconciliation week of the different trade companies under different transaction scenes is obtained by establishing related route test information Phase, reconciliation data original format, reconciliation start date and reconciliation element etc. data, to according to aforementioned data and information, come Complete reconciliation operation.
2, a kind of routing sub-control account checking method (Fig. 1-Fig. 4)
Height is spent in view of system data coupling interaction in the prior art, practical reconciliation solution is caused to cannot be satisfied difference The checking requirement of access side, the problem of having greater limitations, embodiments herein, which proposes, is effectively reduced data interaction The degree of coupling, and support a kind of routing sub-control reconciliation side of cross-platform reconciliation and multi-mode mixing reconciliation fast and safely access scheme Method.
As shown in Figure 1, a kind of routing sub-control account checking method starts according to the reconciliation task start time and executes reconciliation task, The reconciliation task includes the following steps:
Wherein, system judges reconciliation task start time, particularly, system total activation by total activation task to control Task was polled every 10 minutes, obtained the basic parameter of the timed task of all loads in total activation task, wherein all The basic parameter of timed task include task names, task execution mode, task reconciliation date, task start time, task most Evening executes time and file storage catalogue etc..System judges whether the timing reconciliation task in timed task starts by poll.
Total activation task judges the reconciliation task start time, specifically includes following process:
Total activation task start inquires timed task basic parameter table, institute is obtained from the timed task basic parameter table There is the basic parameter of trade company's reconciliation task, and according to the reconciliation task start time in reconciliation task basic parameter, to judge this Whether reconciliation task starts, if meeting time conditions, starts reconciliation task.Wherein, in the timed task basic parameter table Task names task start time including all timed tasks, task execute the time the latest;The reconciliation task basic parameter The time is executed the latest including all trade company's reconciliation task names, reconciliation task start time, reconciliation task.It should be noted that It is identical that the reconciliation task start time of the reconciliation task of all trade companies, reconciliation task execute the time the latest.
Wherein, which provides the basic parameter of all timed tasks.
S100, the task names obtained in the reconciliation task inquire the trade company in database according to the task names Route information table obtains merchant information related with the reconciliation task, executes S200;
It should be noted that trade company's route information table is made of different parameters, when creating new trade company, not to the trade company Same parameter is combined, and the correspondence parameters of the trade company is added in trade company's route information table, which is mainly used for recording Merchant information, and record the All Activity channel number (transaction id) that the trade company is related to, task names and corresponding settle accounts calculation Rule etc..System can inquire the merchant information corresponding to the task names by task names in trade company's route information table. Aforementioned trade company's route information table is stored in the form of form document in the database of system general module.
S200, according to the merchant information, inquiry trade company management information table obtains trade company's configuration information, executes S300;
Wherein, trade company's management information table refers to the table of all essential informations comprising all trade companies, including trade company Whether the reconciliation date trade company's description, the clearance period, carries out under order reconciliation, practical reconciliation pattern, file interaction mode, file The information such as load mode.And trade company's configuration information refers to then the reconciliation of recorded specific single trade company in trade company's management information table Executive mode, such as reconciliation date, trade company describe, whether carry out order reconciliation, the basic downloading mode of file, practical reconciliation pattern Information.Wherein, trade company's management information table is stored in the form of form document in the database of system general module.
System by by merchant information (comprising name of firm, trade company ID, channel number etc.) in trade company's management information table into Row matching, finds corresponding trade company, and obtain the configuration information of trade company from trade company's management information table.
S300, judge whether trade company's configuration information meets reconciliation task start time judgment rule, if so, executing S400;Otherwise, terminate this method;
Wherein, according to the reconciliation date in trade company's configuration information, which is extracted, according to preset reconciliation Task start time judgment rule, judges whether the reconciliation date meets entry condition, if meeting, executes S400, otherwise, if It does not meet, does not then start reconciliation, directly terminate this method, wait for next poll.
It should be noted that timed task, which starts time judgment rule, to be used by the pre-set judgment rule of system In judging whether system current date should execute the reconciliation task.As shown in Fig. 2, judging comprising the reconciliation task start time The step S300 of rule specifically includes following steps:
A, according to trade company's configuration information, judge whether the reconciliation date of the trade company is set as working day, if so, executing b;Otherwise, c is executed;
B, judge whether current date is working day, if so, executing S400;Otherwise, terminate this method;
C, judge whether current date is working day, if so, terminating this method;Otherwise, S400 is executed.
S400, according to trade company's configuration information, inquire reconciliation file interaction route information table, obtain trade company's reconciliation File interaction information, and according to trade company's reconciliation file interaction acquisition of information trade company book of accounts file;
Wherein, include in the reconciliation file interaction route information table all trade companies All Activity scene under reconciliation text The specific downloading mode of part, including trade company number, transaction id, IP address, user name, password, port numbers, destination server address, Filename etc.;And reconciliation file interaction information refers to specific reconciliation file download message of the single trade company under single scene, packet Include download address, port numbers, destination server address, the filename etc. of reconciliation file.Wherein, the reconciliation file interaction routing Information table is in table form, to be stored in the database of system general module.
Trade company number in system trade company configuration information and transaction id find correspondence in reconciliation file interaction route information table Specific reconciliation file download message (i.e. reconciliation file interaction information) of the trade company under the scene, and handed over according to the reconciliation file Mutual information downloads corresponding book of accounts file (i.e. reconciliation file).
S500, according to trade company's configuration information, judge whether local reconciliation file related with the trade company is normally deposited Enter database, if so, executing S700;Otherwise, S600 is executed;
It should be noted that step S500 can be immediately performed after the completion of step S400 is executed.
Preferably, step S500 and its subsequent step are concurrently executed with step S100 to S400, constantly right to this by system Account subtask is polled (every 5 minutes), if file deposit database is normal, continues to execute S700;Otherwise, by between system Every after a certain period of time, continue poll.
S600, system continue waiting for after a certain period of time, returning and executing S500;
It, can be with it should be noted that the certain time that system is waited for, can be any time set manually It is 5 seconds, can also be 5 minutes, the specific time according to the requirement of the demand of system reconciliation and day-to-day operation by manually carries out It pre-sets.Preferably, the certain time that system continues waiting for here is set as 5 minutes.Preferably, if local book of accounts text Part deposit database is abnormal, then system continues poll, if being polled to the reconciliation recorded in timed task parameter list Task executes the time the latest, and the reconciliation task is also not actuated, then records overtime daily record by system, which no longer executes the reconciliation Task.
S700, the local reconciliation file is obtained from the database, executes S800;
S800, the reconciliation element that the trade company is extracted from trade company's configuration information, are wanted according to the reconciliation of the trade company Trade company's book of accounts file and local reconciliation file are carried out reconciliation, and generate reconciliation destination file by element.
Wherein, the reconciliation element of trade company refers to being documented in trade company's management information table, which is directed under different scenes Different reconciliation modes, the element for the reconciliation of being carried out, such as name of firm, transaction amount, Bank Account Number etc..
It should be noted that the application passes through timed task basic parameter table, trade company's route information table, trade company's management information (aforementioned table file is stored in the database of system general module to a variety of tables such as table, reconciliation file interaction route information table In), to realize configurableization of information, parameter, join only by partial informations such as trade company ID, transaction ids between each table System, other element then carry out data storage according to the function of different tables.Therefore, in later maintenance, by reconciliation pattern, The flexible combination of the parameters such as scene of merchandising can configure multiple routings to realize that sub-control reconciliation is handled.
In the present embodiment, as shown in Figures 3 and 4, start in a kind of above-mentioned routing sub-control account checking method and execute reconciliation times Further include following steps before business:
S101, start total activation task;
Wherein it is preferred to which total activation task is by system, poll is primary at regular intervals, with subsequent step S1011- It is concurrently to execute between S1014.
Preferably, total activation task is primary every 10 minutes polls by system.
Wherein, system judges reconciliation task start time, particularly, system total activation by total activation task to control Task was polled every 10 minutes, obtained the basic parameter of the timed task of all loads in total activation task, and according to this Timed task in timed task basic parameter starts the time, to start corresponding timed task (such as file download task, right Account task, order are put in storage task dispatching).
It should be noted that above-mentioned total activation task is completed by the Universal Die scheduler module in the block of system.
S102, inquiry timed task basic parameter table, obtain reconciliation task basic parameter;
Wherein, the timed task basic parameter table include the task names of all timed tasks, task execution mode, Task reconciliation date, task start time, task execute time and file storage catalogue etc. the latest;The reconciliation task is joined substantially Number includes that reconciliation task names, reconciliation task execution mode, the reconciliation task start time, reconciliation task execute the time the latest With reconciliation file storage catalogue etc..
It should be noted that the timed task basic parameter table preserves the basic parameter of all timed tasks, wherein It include the basic parameter of the reconciliation task of all trade companies (reconciliation task is one kind of timed task).And the reconciliation of all trade companies Though task execution mode is different, in the reconciliation task basic parameter of all trade companies, the reconciliation task start time, and reconciliation It is identical that task executes the time the latest.
S103, according to the reconciliation task basic parameter, when judging whether the current time in system meets reconciliation task start Between, if so, executing S104;Otherwise, S105 is executed;
Described to judge whether the current time in system meets the reconciliation task start time and refer to, system is obtaining reconciliation task base After this parameter, reconciliation task start time parameter is extracted from the reconciliation task basic parameter, and by the current time in system and be somebody's turn to do The reconciliation task start time is compared, if current time meets the reconciliation task start time, executes S104;Otherwise, it executes S105。
S104, start execution reconciliation task;
S105, system continue waiting for, and separated in time, return and execute S101;
Preferably, the separated in time is 5 minutes.
Preferably, further include following steps as shown in figure 4, before above-mentioned steps S101:
S1011, start local book of accounts storage task, the local book of accounts storage duty cycle is polled;
Wherein, system was polled local book of accounts storage task every 5 minutes, that is, system started every 5 minutes And execute local book of accounts storage task.
It should be noted that the interval time of above-mentioned local book of accounts storage task can be 5 minutes, can also be 10 Minute can be any one by manually carrying out the preset time.For the present embodiment, 5 minutes are between system is preferred Every the time.
S1012, according to trade company's management information table, obtain trade company's configuration information;
S1013, according to trade company's configuration information, inquire local book of accounts file in database, transfer and the quotient The related data in family;
Wherein, according to the configuration information of the trade company, system is in the database to all friendships in local book of accounts file Easy pipelined data is screened, and the related transaction journal data in relation to trade company in this reconciliation task are extracted, and will The data are summarized, and database is stored in as the local reconciliation file that will carry out reconciliation with trade company's book of accounts file In.
S1014, the data summarization related with trade company by described in, and local reconciliation file is generated, it is stored in database.
Wherein, after the completion of local reconciliation file warehousing, system file storage result is recorded, so that follow-up system is looked into Ask whether file warehousing succeeds.Meanwhile system meeting separated in time continues poll, starts the local book of accounts of timing Storage task downloads the related local reconciliation file of the trade company.
In embodiment, further include following steps before step 1 in a kind of above-mentioned routing sub-control account checking method:
Newly-built merchant information manages table, the essential information of all trade companies of typing, configuration information.
In the present embodiment, step S400 described in a kind of above-mentioned routing sub-control account checking method further includes following steps:
S401, the destination server address that trade company's reconciliation file is extracted from the reconciliation file interaction information, under Trade company's book of accounts file is carried and obtained, S402 is executed;
S402, the trade company's book of accounts file downloaded is parsed and is stored in database.
Wherein, the parsing module in system data processing module is used to parse trade company's book of accounts text of above-mentioned download Part obtains the data such as filename, trade company's name, transaction id and the corresponding transaction journal of book of accounts file after parsing.
In the present embodiment, include the following steps before step 6 described in a kind of above-mentioned routing sub-control account checking method:
S601, according to the reconciliation task basic parameter, judge whether the current time in system alreadys exceed the reconciliation and appoint Business executes the time the latest, if so, executing S602;Otherwise, S600 is executed;The certain time is 5 minutes.
Wherein, system obtains holding the latest for the reconciliation task by inquiring the timed task basic parameter table in database The row time is used in combination current time to be compared with the execution time the latest, if current time has been over the timed task The execution time the latest, then the overtime daily record (i.e. S602) of system record, the date no longer execute the reconciliation task;If current time There are no the time is executed the latest more than timed task, then system can also continue to be polled (i.e. S603).
S602, by current reconciliation task record time-out daily record, while terminating this method;
Wherein, if the current time in system alreadys exceed the reconciliation task when executing the time the latest, illustrate it is local can accounting Book file can not normally be stored in always database, at this time, it may be necessary to system records the mistake, and abandons execution reconciliation task, and in After a certain period of time, restart new poll to operate with reconciliation.
In embodiment, further include following steps after step 7 described in a kind of above-mentioned routing sub-control account checking method:
S800, according to the configuration information of the trade company, trade company's reconciliation processing logical control information is obtained, according to described Reconciliation handles logical control information, is screened to the data in the reconciliation destination file, and generates the second reconciliation result text Part.
After system generates reconciliation destination file, since rear pipe personnel are when examining, different demands is potentially based on to right Account destination file needs to carry out data screening, for this purpose, system, which provides reconciliation, handles logic control table, not for pipe personnel after difference With demand, it is specified that different reconciliation handles logical control information, data are screened, with pipe personnel's post-processing number after facilitating According to.
It should be noted that in the present embodiment, the interaction of trade company's file is substantially through the MQ between system component Message transmission is carried out, and realizes specific file download in download component.Therefore, the timed task between system modules, If file download task, reconciliation task, file warehousing task and local file/bill generate task dispatching task, being all can be with It is concurrently executed, independently of each other, to realize the high efficiency of system, to enable a system to provide between the task of system Optimal most efficiently reconciliation solution.
3, a kind of routing sub-control reconciliation system (Fig. 5)
With reference to Fig. 5, according to an embodiment of the invention, a kind of routing sub-control reconciliation system is mainly including data extraction module 10, data processing module 20, file download module 30, reconciliation module 40 and system general module 50,
The data extraction module 10 includes:
Enquiry module 101 for inquiring data in the table;And
Extraction module 102 for extracting and/or obtaining data and information in the table;
The data processing module 20, the mission bit stream for being extracted according to data extraction module, judges local Whether book of accounts file is normally stored in database, meanwhile, for being parsed to book of accounts file;
The data processing module 20 includes:
For judging whether local book of accounts file is stored in the judgment module 201 of database;And
Parsing module 202 for being parsed to book of accounts;
The file download module 30, the reconciliation file interaction letter for being extracted according to the data extraction module Breath downloads book of accounts file, including download component 301;
The reconciliation module 40, for the reconciliation element of the trade company acquired in the data extraction module, by trade company Book of accounts file carries out reconciliation with local book of accounts file, and generates reconciliation destination file, meanwhile, it is used for the reconciliation Destination file carries out postsearch screening processing;
The system general module 50, for dispatching all timed tasks, timing simultaneously judges whether to start reconciliation task, and All data of this method and book of accounts file are executed for storage system;
The system general module 50 includes:
For dispatching all timed tasks, and judge and start the scheduler module 501 of reconciliation task;And
Timer module 502 for carrying out all timings, Clocked operation;And
The database 503 of all data of this method and book of accounts file is executed for storage system.
In addition, different embodiments of the invention by software module or can also be stored in one or more computer-readable The mode of computer-readable instruction on medium is realized, wherein the computer-readable instruction is when by processor or equipment group When part executes, different embodiment of the present invention is executed.Similarly, software module, computer-readable medium and Hardware Subdivision The arbitrary combination of part is all expected from the present invention.The software module can be stored in any type of computer-readable storage On medium, such as RAM, EPROM, EEPROM, flash memory, register, hard disk, CD-ROM, DVD etc..
4, the system according to an embodiment of the invention for being mounted with application program
With reference to Fig. 6, it illustrates the running environment of the system according to an embodiment of the invention for being mounted with application program.
In the present embodiment, the system of the installation application program is installed and is run in electronic device.The electronics Device can be the computing devices such as desktop PC, notebook, palm PC and server.The electronic device may include but not It is limited to memory, processor and display.Fig. 6 illustrates only the electronic device with said modules, it should be understood that simultaneously All components shown realistic are not applied, the implementation that can be substituted is more or less component.
The memory can be the internal storage unit of the electronic device, such as electronics dress in some embodiments The hard disk or memory set.The memory can also be the External memory equipment of the electronic device in further embodiments, Such as the plug-in type hard disk being equipped on the electronic device, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) blocks, flash card (Flash Card) etc..Further, the memory can also both include institute The internal storage unit for stating electronic device also includes External memory equipment.The memory is installed on the electronics dress for storing The application software and Various types of data set, for example, it is described installation application program system program code etc..The memory may be used also For temporarily storing the data that has exported or will export.
The processor can be in some embodiments central processing unit (Central Processing Unit, CPU), microprocessor or other data processing chips, for running the program code stored in the memory or processing data, Such as execute the system etc. of the installation application program.
The display can be in some embodiments light-emitting diode display, liquid crystal display, touch-control liquid crystal display with And OLED (Organic Light-Emitting Diode, Organic Light Emitting Diode) touches device etc..The display is for showing Show the information handled in the electronic device and for showing visual user interface, such as application menu interface, answers With icon interface etc..The component of the electronic device is in communication with each other by system bus.
Through the above description of the embodiments, those skilled in the art is it will be clearly understood that the above embodiment In method the mode of required general hardware platform can be added to realize by software, naturally it is also possible to realized by hardware, But the former is more preferably embodiment in many cases.Based on this understanding, the technical solution of the application of the present invention is substantially The part that contributes to existing technology can be expressed in the form of software products in other words, which deposits Storage is in a storage medium (such as ROM/RAM, magnetic disc, CD), including use (can be with so that a station terminal equipment for some instructions It is mobile phone, computer, server, air conditioner or the network equipment etc.) execute side described in each embodiment of the application of the present invention Method.
That is, according to an embodiment of the invention, additionally providing a kind of computer readable storage medium, the computer It is stored on readable storage medium storing program for executing for executing a kind of program of routing sub-control reconciliation, when described program is executed by processor, is held The step of row routing sub-control reconciliation according to an embodiment of the invention.
By upper, it will be appreciated that for illustrative purposes, specific embodiments of the present invention are described herein, still, can make Each modification, without departing from the scope of the present invention.It will be apparent to one skilled in the art that drawn in flow chart step or this In the operation that describes and routine can be varied in many ways.More specifically, the order of step can be rearranged, step can be executed parallel Suddenly, step can be omitted, it may include other steps can make the various combinations or omission of routine.Thus, the present invention is only by appended power Profit requires limitation.

Claims (10)

1. a kind of routing sub-control account checking method, which is characterized in that according to the reconciliation task start time, starts and execute reconciliation task, The reconciliation task includes the following steps:
Step 1, the task names obtained in the reconciliation task inquire the trade company road in database according to the task names By information table, merchant information related with the reconciliation task is obtained;
Step 2, according to the merchant information, inquiry trade company management information table obtains trade company's configuration information;Confidence is matched by the trade company It include the reconciliation date of trade company number, trade company in breath.
Step 3 judges whether trade company's configuration information meets reconciliation task start time judgment rule, if so, executing step Rapid 4;Otherwise, terminate this method;
Step 4, according to trade company's configuration information, inquire reconciliation file interaction route information table, obtain trade company's reconciliation text Part interactive information, and according to trade company's reconciliation file interaction acquisition of information trade company book of accounts file;
Step 5, according to trade company's configuration information, judge whether local reconciliation file related with the trade company is normally stored in number According to library, if so, obtaining the local reconciliation file from the database, and step 7 is executed;Otherwise, step 6 is executed;
Step 6, system continue waiting for after a certain period of time, returning to step 5;
Step 7, the reconciliation element that the trade company is extracted from trade company's configuration information, according to the reconciliation element of the trade company, Trade company's book of accounts file and local reconciliation file are subjected to reconciliation, and generate reconciliation destination file.
2. a kind of routing sub-control account checking method according to claim 1, which is characterized in that start before executing reconciliation task Further include following steps:
Step 101, inquiry timed task basic parameter table, obtain timed task basic parameter;
Wherein, the timed task basic parameter includes that the task names of all trade companies, task start time, task execute the latest Time;
Step 103, according to the timed task basic parameter, judge whether the current time in system meets the task start time, if Meet, thens follow the steps 104;Otherwise, system continues waiting for, and 101 are returned to step after separated in time;
Step 104 starts execution reconciliation task.
3. a kind of routing sub-control account checking method according to claim 2, which is characterized in that before the step 101, also wrap Include following steps:
Step 1011 starts local book of accounts storage task, and the local book of accounts storage duty cycle is polled;
Step 1012, according to trade company's management information table, obtain trade company's configuration information;
Step 1013, according to trade company's configuration information, inquire local book of accounts file in database, transfer and the trade company Related data;
Step 1014, the data summarization related with trade company by described in, and local reconciliation file is generated, it is stored in database.
4. a kind of routing sub-control account checking method according to claim 2, which is characterized in that the step 3 includes following step Suddenly:
A, according to trade company's configuration information, judge whether the reconciliation date of the trade company is set to working day, if so, executing b; Otherwise, c is executed;
B, judge whether current date is working day, if so, executing step 4;Otherwise, terminate this method;
C, judge whether current date is working day, if so, terminating this method;Otherwise, step 4 is executed.
5. a kind of routing sub-control account checking method according to claim 1, which is characterized in that further include before step 1:Newly Construction company's family information management table, the essential information of all trade companies of typing, configuration information.
6. a kind of routing sub-control account checking method according to claim 1, which is characterized in that the step 4 further includes as follows Step:
The destination server address of trade company's reconciliation file is extracted from trade company's reconciliation file interaction information, downloads trade company Book of accounts file;
The trade company's book of accounts file downloaded is parsed and is stored in database.
7. a kind of routing sub-control account checking method according to claim 2, which is characterized in that include before the step 6 Following steps:
According to timed task basic parameter, judge whether the current time in system alreadys exceed the task of trade company's reconciliation and hold the latest The row time if so, current reconciliation task is charged to overtime daily record, while terminating this method, otherwise, executes step 6;
Wherein, the certain time is 5 minutes.
8. a kind of routing sub-control account checking method according to claim 1, which is characterized in that after the step 7, further include Following steps:
According to trade company's configuration information, trade company's reconciliation processing logical control information is obtained, is patrolled according to reconciliation processing Control information is collected, the data in the reconciliation destination file are screened, and generates the second reconciliation destination file.
9. a kind of routing sub-control reconciliation system, which is characterized in that the system comprises data extraction module, data processing module, File download module, reconciliation module and system general module,
Wherein, the data extraction module is used to extract and/or obtain data in table and task, and according to being extracted Data are inquired in other tables, and extract corresponding information;
The data extraction module includes:
Enquiry module for inquiring data in the table;And
Extraction module for extracting and/or obtaining data and information in the table;
Wherein, the mission bit stream that the data processing module is used to be extracted according to data extraction module, judges local meeting Whether accounting book file is normally stored in database, meanwhile, for being parsed to book of accounts file;
The data processing module includes:
For judging whether local book of accounts file is stored in the judgment module of database;And
Parsing module for being parsed to book of accounts;
Wherein, the reconciliation file interaction information that the file download module is used to be extracted according to the data extraction module, Book of accounts file is downloaded, including download component;
Wherein, reconciliation element of the reconciliation module for the trade company acquired in the data extraction module, by trade company's meeting Accounting book file carries out reconciliation with local book of accounts file, and generates reconciliation destination file, meanwhile, it is used for the reconciliation knot Fruit file carries out postsearch screening processing;
Wherein, the system general module simultaneously judges whether to start reconciliation task, be used in combination for dispatching all timed tasks, timing All data of this method and book of accounts file are executed in storage system;
The system general module includes:
For dispatching all timed tasks, and judge and start the scheduler module of reconciliation task;And
Timer module for carrying out all timings, Clocked operation;And
The database of data needed for this method and book of accounts file is executed for storage system.
10. a kind of computer readable storage medium, which is characterized in that be stored on the computer readable storage medium for holding A kind of program of routing sub-control account checking method of row, when described program is executed by processor, executes according in claim 1 to 8 The step of method described in one.
CN201810148432.5A 2018-02-13 2018-02-13 Routing sub-control account checking method and system Active CN108280754B (en)

Priority Applications (1)

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

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810148432.5A CN108280754B (en) 2018-02-13 2018-02-13 Routing sub-control account checking method and system
PCT/CN2018/083064 WO2019157777A1 (en) 2018-02-13 2018-04-13 Routing sub-control reconciliation method and system

Publications (2)

Publication Number Publication Date
CN108280754A true CN108280754A (en) 2018-07-13
CN108280754B CN108280754B (en) 2021-08-06

Family

ID=62808394

Family Applications (1)

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

Country Status (2)

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

Cited By (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
CN110751550A (en) * 2019-10-12 2020-02-04 上海陆家嘴国际金融资产交易市场股份有限公司 Account checking method and device, computer equipment and storage medium
CN112308513A (en) * 2020-10-30 2021-02-02 广州市汇聚支付电子科技有限公司 Automatic account checking system and method based on big data

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050216396A1 (en) * 2004-03-25 2005-09-29 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
CN105094959A (en) * 2015-07-01 2015-11-25 北京京东尚科信息技术有限公司 Method and device for providing account checking document
CN105405007A (en) * 2015-11-19 2016-03-16 成都连银信息技术有限公司 Unified account processing system supporting multiple types of payment channels
CN105719182A (en) * 2016-01-18 2016-06-29 北京京东尚科信息技术有限公司 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
CN107301595A (en) * 2017-07-12 2017-10-27 百望电子发票数据服务有限公司 A kind of electronic invoice account checking method and system

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2011095521A1 (en) * 2010-02-02 2011-08-11 Traxpay Ag Electronic clearing and payment system

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050216396A1 (en) * 2004-03-25 2005-09-29 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
CN105094959A (en) * 2015-07-01 2015-11-25 北京京东尚科信息技术有限公司 Method and device for providing account checking document
CN105405007A (en) * 2015-11-19 2016-03-16 成都连银信息技术有限公司 Unified account processing system supporting multiple types of payment channels
CN105719182A (en) * 2016-01-18 2016-06-29 北京京东尚科信息技术有限公司 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
CN107301595A (en) * 2017-07-12 2017-10-27 百望电子发票数据服务有限公司 A kind of electronic invoice account checking method and system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
杨绪森: "多渠道交易接入平台系统设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Cited By (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
CN110751550A (en) * 2019-10-12 2020-02-04 上海陆家嘴国际金融资产交易市场股份有限公司 Account checking method and device, computer equipment and storage medium
CN112308513A (en) * 2020-10-30 2021-02-02 广州市汇聚支付电子科技有限公司 Automatic account checking system and method based on big data

Also Published As

Publication number Publication date
CN108280754B (en) 2021-08-06
WO2019157777A1 (en) 2019-08-22

Similar Documents

Publication Publication Date Title
CN108280754A (en) A kind of routing sub-control account checking method and system
US11216756B2 (en) Mapping portal applications in multi-tenant environment
CN108376363A (en) A kind of reconciliation difference processing method and system
US7945041B2 (en) Method, system and program product for managing a customer request
CN102214187B (en) Complex event processing method and device
CA2664941C (en) Method and system for communicating vehicle repair information to a business-to-business rental vehicle reservation management computer system
US8630969B2 (en) Systems and methods for implementing business rules designed with cloud computing
US20140149978A1 (en) Dynamic communication between script and execution layers
CN104756460A (en) LDAP-based multi-customer in-cloud identity management system
US7966207B2 (en) Method, system and program product for managing fulfillment of orders
US20110145326A1 (en) WORKFLOW CUSTOMIZATION METHOD IN SaaS ENVIRONMENT
CN108805667A (en) Order flow processing method and system
CN109597640B (en) Account management method, device, equipment and medium for application program
CN108537528A (en) Method and system is paid out in batch documents audit
CN109889381A (en) Automatic configuration management method and device based on fort machine
US20220067659A1 (en) Research and development system and method
CN101211366B (en) Method and system for providing information from a plurality of disparate data sources
CN101281624B (en) Method for implementing management software, hardware with pre-configured software and implementing method thereof
US8386292B2 (en) System and method for triggering a process on an enterprise system
CN101685523A (en) Service processing system for clients at mobile phone terminals
CN111798338A (en) Smart tourism GDS method, system and intermediate server
CN111161002A (en) Cloud platform billing method and device
CN108573374A (en) It is a kind of that the daily fee payment method turning to pay and system are redeemed based on fund share
CN108765083A (en) The configuration of routingization order and processing method and system
KR100383673B1 (en) Dynamic routing method for workflow system using routing map

Legal Events

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
GR01 Patent grant
GR01 Patent grant