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 PDFInfo
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
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.
Priority Applications (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 |
Applications Claiming Priority (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 |
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 (5)
| 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 |
| CN111951091A (en) * | 2020-08-13 | 2020-11-17 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN112308513A (en) * | 2020-10-30 | 2021-02-02 | 广州市汇聚支付电子科技有限公司 | Automatic account checking system and method based on big data |
Citations (9)
| 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)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2531966A1 (en) * | 2010-02-02 | 2012-12-12 | Traxpay Ag | Electronic clearing and payment system |
-
2018
- 2018-02-13 CN CN201810148432.5A patent/CN108280754B/en active Active
- 2018-04-13 WO PCT/CN2018/083064 patent/WO2019157777A1/en active Application Filing
Patent Citations (9)
| 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)
| Title |
|---|
| 杨绪森: "多渠道交易接入平台系统设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (6)
| 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 |
| CN111951091A (en) * | 2020-08-13 | 2020-11-17 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN111951091B (en) * | 2020-08-13 | 2023-12-29 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| 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 |
|---|---|---|
| CN108376363A (en) | A kind of reconciliation difference processing method and system | |
| CN108280754A (en) | A kind of routing sub-control account checking method and system | |
| CA2664941C (en) | Method and system for communicating vehicle repair information to a business-to-business rental vehicle reservation management computer system | |
| US8615400B2 (en) | Mapping portal applications in multi-tenant environment | |
| US9104451B2 (en) | Dynamic communication between script and execution layers | |
| US20070005536A1 (en) | Method, system and program product for managing a customer request | |
| US8630969B2 (en) | Systems and methods for implementing business rules designed with cloud computing | |
| US20060112122A1 (en) | Method, system, and storage medium for implementing business process modules | |
| CN101388904B (en) | GIS service aggregating method, device and system | |
| CN104756460A (en) | LDAP-based multi-customer in-cloud identity management system | |
| CN108573374A (en) | It is a kind of that the daily fee payment method turning to pay and system are redeemed based on fund share | |
| CN108805667A (en) | Order flow processing method and system | |
| US20110145326A1 (en) | WORKFLOW CUSTOMIZATION METHOD IN SaaS ENVIRONMENT | |
| CN108537528A (en) | Method and system is paid out in batch documents audit | |
| CN109544266A (en) | Product data method for pushing, device and computer readable storage medium | |
| CN106600082A (en) | Processing method and device of task in service system, and service system construction system | |
| CN108765083A (en) | The configuration of routingization order and processing method and system | |
| CN111798196A (en) | Agile development management system based on SpringBoot framework | |
| CN101281624B (en) | Method for implementing management software, hardware with pre-configured software and implementing method thereof | |
| CN105117898A (en) | Cloud attendance management method and system for supporting access of attendance terminals of multiple manufacturers | |
| CN111798338A (en) | Smart tourism GDS method, system and intermediate server | |
| CN114787836A (en) | System and method for remotely executing one or more arbitrarily defined workflows | |
| CN101211366B (en) | Method and system for providing information from a plurality of disparate data sources | |
| US20210342787A1 (en) | System and method for managing human resources on a decentralized resource network | |
| CN101685523A (en) | Service processing system for clients at mobile phone terminals |
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 |