CN110175165A - Transaction account checking method, device, computer equipment and storage medium - Google Patents
Transaction account checking method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110175165A CN110175165A CN201910301878.1A CN201910301878A CN110175165A CN 110175165 A CN110175165 A CN 110175165A CN 201910301878 A CN201910301878 A CN 201910301878A CN 110175165 A CN110175165 A CN 110175165A
- Authority
- CN
- China
- Prior art keywords
- data
- transaction
- format
- reconciliation
- channel
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000012545 processing Methods 0.000 claims abstract description 77
- 238000006243 chemical reaction Methods 0.000 claims abstract description 16
- 238000004140 cleaning Methods 0.000 claims description 28
- 238000012552 review Methods 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 9
- 230000001960 triggered effect Effects 0.000 claims 1
- 238000003032 molecular docking Methods 0.000 abstract description 5
- 230000000007 visual effect Effects 0.000 abstract description 2
- 230000006870 function Effects 0.000 description 4
- 230000002159 abnormal effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 235000009499 Vanilla fragrans Nutrition 0.000 description 1
- 244000263375 Vanilla tahitensis Species 0.000 description 1
- 235000012036 Vanilla tahitensis Nutrition 0.000 description 1
- 235000021167 banquet Nutrition 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000002787 reinforcement Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Quality & Reliability (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The present invention provides a kind of transaction account checking method, device, computer equipment and storage medium, timing cycle acquires external transaction data in T-1 days first, and reference format conversion is carried out to the inside and outside data for not meeting reference format, then to the correspondence channel inside and outside data after unified format, after carrying out reconciliation processing according to default reconciliation rule, summarize the exception record progress automatic processing judgement for not meeting reconciliation rule, the transaction for meeting automatic processing is automatically processed, for not meeting the transaction of automatic processing, judged by manpower intervention, pass through transaction reconciliation standard process, it can effectively solve the problems, such as the unified reconciliation of different channel transaction, can also be achieved docking new channel simultaneously can realize close to zero exploitation, visual configuration is used completely, when the external channel of new access can support reconciliation by easy configuration, access It is shorten to a few days from several weeks, greatlys save business manpower and time cost.
Description
Technical field
The present invention relates to task management technical field more particularly to a kind of task management methods that call center attends a banquet, dress
It sets, computer equipment and storage medium.
Background technique
With the development of development of Mobile Internet technology, many traditional industries start for business under line to be gradually extended on line, line
Upper payment demand is also increasing.Payment function has Alipay, wechat, each bank, an every kind of channel of disbursement on Support Line at present
Docking mode is different, and the requirement for reconciliation of trading also is not quite similar, and vanilla transaction reconciliation is customized out according to specific business
Hair, system seriously couples with business, more particularly, to cross-system transaction when, it is desirable that the respective transaction total amount of system must with detail
Must be consistent, still, in actual use, network, think operation etc. due to, can have the occurrence of " unilateral account ", i.e.,
One transaction, which only exists in individual system, successfully to be recorded, or the record of repeat business is stored in some system, meanwhile, every access
New transaction channel, code will be developed again, and access period is long.
Summary of the invention
The object of the present invention is to provide a kind of transaction account checking method, device, computer equipment and storage mediums, for solving
Problem of the existing technology.
To achieve the above object, the invention discloses a kind of transaction account checking methods, comprising the following steps:
Step S10, timing cycle obtain the internal data and external data of transaction, judge the internal data and described outer
Whether portion's data are that preset standard format if preset standard format thens follow the steps S30, if not preset standard format, then
Execute step S20, wherein the internal data includes place channel mark with the external data；
Step S20 matches according to the default cleaning format corresponding to the lookup of the respective channel mark of external data of internal data
It sets: if finding the cleaning format configuration, data being formatted according to configuration, after conversion, notification data conversion
It finishes；If not finding the cleaning format configuration, warning note；
Step 30, timing cycle checks whether there is the internal data of corresponding channel and external data is in ready state,
If nothing, terminate this lookup；If judgement has the internal data of corresponding channel and external data to be in ready state, according to
Default channel reconciliation rule executes reconciliation, and setting reconciliation is as a result, summarizing exception record simultaneously and going to step S40 processing；
Step S40, timing cycle judge whether exception record to be treated: if nothing, terminating this lookup；If so, then
Judge whether to need to be implemented manual examination and verification program, if calling core to hand over according to established rule without executing artificial review procedure
Easy system automation processing, and operation system is sent to after processing result is summarized；If artificial review procedure need to be executed, trigger
Manual examination and verification program and the auditing result for receiving the manual examination and verification program meet processing to judgement according to the auditing result
Logic calls the processing of core transaction system automation according to established rule, is to the operation that continues to report for not meeting processing logic
System.
Preferably, the step S10, the internal data and external data are the data of transaction yesterday.
Preferably, step S10, timing cycle obtain the internal data of transaction yesterday, and whether judge the internal data
For preset standard format, if so, setting internal data is ready, and terminate the acquisition of this internal data；If it is not, being transferred to step
S20 is cleaned, until setting internal data is ready, then terminates the acquisition of this internal data, the internal data includes place
Channel mark；
Meanwhile timing cycle obtains the external data of each channel transaction, and judges whether the external data of the channel is pre-
It is marked with quasiconfiguaration, if so, the external data that transaction channel yesterday is arranged is ready, and terminates the acquisition of this external data；If no
It is to be transferred to step S20 to be cleaned, until the external data that channel yesterday transaction is arranged is ready, then terminates this external number
According to acquisition.
Preferably, the judgement of the preset standard format includes that the judgement of general format field and special format field judge,
The general format field judges for field type, length, whether allows sentencing as one or more combinations such as sky, value ranges
Disconnected, the special format field judgement is used for the judgement of special format.
Further, the general format field judgement is carried out first, if total data passes through, judges the data fit
Preset standard；If partial data passes through, continue the special format field judgement, until all passing through, then judgement should
Data fit preset standard.
Preferably, in the step S10, timing cycle obtains external data the following steps are included: timing cycle inspection is
It is no to have external channel data, if so, the external data for then calling external system to obtain the channel according to channel configuration is preset, if
Nothing then terminates the acquisition of this external data.
Further, the default channel of different channels configures different settings, and the preset configuration includes interface type, service
One or more combinations such as device address, port, calling interface time, the configuration of data cleansing rule.
Preferably, in the step 30, automatic processing is arranged to the exception record that can be automated processing and is identified.
Preferably, the step 30 presets channel reconciliation rule if not meeting and having, judges that it belongs to exception record；
Preferably, if the exception record belongs to regular problem, it is added into default reconciliation rule.
To achieve the above object, also a kind of transaction account checking apparatus of the present invention, comprising:
Internal data obtain module, for timing acquisition transaction internal data, and judge the internal data whether be
Preset standard format is then transferred to transaction reconciliation module if preset standard format, if not preset standard format, then amount brought forward
According to cleaning module；
External data obtain module, for timing acquisition transaction external data, and judge the external data whether be
Preset standard format is then transferred to transaction reconciliation module if preset standard format, if not preset standard format, then amount brought forward
According to cleaning module；
Data cleansing module, for according to the corresponding to the lookup of the respective channel mark of external data default clear of internal data
It washes format configuration: if finding the cleaning format configuration, data being formatted according to configuration, after conversion, notice
Data conversion finishes；If not finding the cleaning format configuration, warning note；
Transaction reconciliation module, checks whether there is the internal data of corresponding channel for timing cycle and external data is in
Ready state terminates this lookup if nothing；If judgement has the internal data of corresponding channel and external data to be in ready shape
State then executes reconciliation according to default channel reconciliation rule, and reconciliation is arranged as a result, summarizing exception record simultaneously and going at automation
Manage resume module；
Automatic processing module judges whether exception record to be treated for timing cycle: if nothing, terminating this and looks into
It looks for；If so, then judging whether to need to be implemented manual examination and verification program, if without executing artificial review procedure, according to established rule
The processing of core transaction system automation is called, and is sent to operation system after processing result is summarized；If manual examination and verification need to be executed
Program then triggers manual examination and verification program and receives the auditing result of the manual examination and verification program, according to the auditing result, to sentencing
Surely meet processing logic calls the processing of core transaction system automation according to established rule, reports to processing logic is not met
Operation system.
Preferably, the internal data obtains module and the external data obtains in module, the internal data and outer
Portion's data are the data of transaction yesterday.
Preferably, the internal data obtains in module, and timing cycle obtains the internal data of transaction yesterday, and judges institute
State whether internal data is preset standard format, if so, setting internal data is ready, and terminates the acquisition of this internal data；If
It is not to be transferred to data cleansing module to be cleaned, until setting internal data is ready, then terminates the acquisition of this internal data, institute
Stating internal data includes place channel mark；
Preferably, the external data obtains timing cycle in module and obtains the external data of each channel transaction, and judges
Whether the external data of the channel is preset standard format, if so, the external data that transaction channel yesterday is arranged is ready, and is tied
Shu Benci external data obtains；It is cleaned if it is not, being transferred to data cleansing module, until the outer of channel yesterday transaction is arranged
Portion's data ready then terminates the acquisition of this external data.
Preferably, the judgement of the preset standard format includes that the judgement of general format field and special format field judge,
The general format field judges for field type, length, whether allows sentencing as one or more combinations such as sky, value ranges
Disconnected, the special format field judgement is used for the judgement of special format.
Further, the general format field judgement is carried out first, if total data passes through, judges the data fit
Preset standard；If partial data passes through, continue the special format field judgement, until all passing through, then judgement should
Data fit preset standard.
Preferably, the external data obtains in module, and timing cycle obtains external data the following steps are included: timing follows
Ring checks whether there is external channel data, if so, the outside for then calling external system to obtain the channel according to channel configuration is preset
Data terminate the acquisition of this external data if nothing.
Further, the default channel of different channels configures different settings, and the preset configuration includes interface type, service
One or more combinations such as device address, port, calling interface time, the configuration of data cleansing rule.
Preferably, in the automatic processing module, the exception record that can be automated processing is arranged at automation
Reason mark.
Preferably, in the automatic processing module, channel reconciliation rule is preset if not meeting and having, judges that it belongs to
Exception record；
Preferably, if the exception record belongs to regular problem, it is added into default reconciliation rule.
To achieve the above object, it the present invention also provides a kind of computer equipment, including memory, processor and is stored in
On memory and the computer program that can run on a processor, the processor are realized above-mentioned when executing the computer program
The step of method.
To achieve the above object, the present invention also provides computer readable storage mediums, are stored thereon with computer program, institute
State the step of above method is realized when computer program is executed by processor.
Transaction account checking method, device, computer equipment and storage medium provided by the invention, first timing cycle acquire T-
External transaction data in 1 day, and reference format conversion is carried out to the inside and outside data for not meeting reference format, then to unified lattice
Correspondence channel inside and outside data after formula after carrying out reconciliation processing according to default reconciliation rule, summarize and do not meet reconciliation rule
Exception record carries out automatic processing judgement, automatically processes to the transaction for meeting automatic processing, for not meeting at automation
The transaction of reason, is judged by manpower intervention, i.e., is following several by reconciliation standard process by transaction reconciliation standard process
Step: acquisition inside and outside data, data cleansing, inside and outside comparing, the subsequent automated processing of inconsistent data can effectively solution be never
With the unified reconciliation problem of channel transaction, while it can also be achieved docking new channel and can realize close to zero exploitation, completely using visual
Change configuration, when the external channel of new access can support reconciliation, access to shorten to a few days from several weeks, greatly save by easy configuration
Business manpower and time cost.
Detailed description of the invention
Fig. 1 is the flow chart of present invention transaction account checking method embodiment one；
Fig. 2 is the program module schematic diagram of present invention transaction account checking apparatus embodiment one；
Fig. 3 is the hardware structural diagram of present invention transaction account checking apparatus embodiment one.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that described herein, specific examples are only used to explain the present invention, not
For limiting the present invention.Based on the embodiments of the present invention, those of ordinary skill in the art are not before making creative work
Every other embodiment obtained is put, shall fall within the protection scope of the present invention.
Transaction account checking method, device, computer equipment and storage medium provided by the invention,
Embodiment one
Referring to Fig. 1, a kind of transaction account checking method of the present embodiment, comprising the following steps:
Step S10, timing cycle obtain the internal data and external data of transaction, judge the internal data and described outer
Whether portion's data are that preset standard format if preset standard format thens follow the steps S30, if not preset standard format, then
Execute step S20, wherein the internal data includes place channel mark with the external data.
In step S10, timing cycle obtains the internal data of transaction yesterday, and judges whether the internal data is default
Reference format if so, setting internal data is ready, and terminates the acquisition of this internal data；If it is not, being transferred to step S20 progress
Cleaning then terminates the acquisition of this internal data, the internal data includes place channel mark until setting internal data is ready
Know；Internal data is collected, usual one day of the data of each channel are only primary with obtaining, unless not receiving channel yesterday
Transaction data.If the internal data received is different from preset standard format, judge to be cleaned.In general, internal
Data do not need cleaning, but are not excluded for part abnormal conditions data and reference format is inconsistent, at this time according to establishing rules in advance
Then cleaned.
As a preferred embodiment, the judgement of preset standard format includes that the judgement of general format field and special format field are sentenced
Disconnected, general format field judges for field type, length, whether allows sentencing as one or more combinations such as sky, value ranges
It is disconnected, judgement of the special format field judgement for special format such as mailbox etc..In the present embodiment, carry out cleaning judge when, head
The judgement of general format field is first carried out, if total data is judged by this, then it is assumed that this group of data fit preset standard is not necessarily to
Carry out data cleansing；If the judgement of general format field continues spy after passing through if in the data of inside and outside including special format
Different format judgement detects whether to meet the requirement of special format field using regular expression, pass through up to all, then judgement should
Otherwise data fit preset standard judges that internal data is cleaned, is transferred in step S20 without carrying out data cleansing
Processing.
Meanwhile timing cycle obtains the external data of each channel transaction, and judges whether the external data of the channel is pre-
It is marked with quasiconfiguaration, if so, the external data that transaction channel yesterday is arranged is ready, and terminates the acquisition of this external data；If no
It is to be transferred to step S20 to be cleaned, until the external data that channel yesterday transaction is arranged is ready, then terminates this external number
According to acquisition.
In step S10, timing cycle obtains the external data of each channel the following steps are included: timing cycle checks whether there is
External channel data such as may be configured as interval and check within 10 minutes once, if external data is judged in this inspection, according to default
Channel configuration calling external system obtains the external data of the channel.It is configured about default channel, due to being related to multiple systems, therefore
The channel of each system has oneself a set of default channel for configuring i.e. different channels to configure different settings, and there certainly exist differences
Channel configures identical possibility, above-mentioned default channel configuration include interface type, server address, port, the calling interface time,
One or more combinations such as data cleansing rule configuration.If nothing, terminate this external data acquisition, interval after ten minutes into
Row checks next time.
Meanwhile the external data judgement that whether needs to clean judge to internal data it is similar, if the external data received with
Preset standard format is different, then judges to be cleaned.In general, external data format is unless follow professional standard, it is no
Then it is difficult unanimously, to generally require to be cleaned according to pre-defined rule, as a preferred embodiment, the judgement of preset standard format is also wrapped
The judgement of general format field and the judgement of special format field are included, the judgement of general format field is used for field type, length, whether permits
It perhaps is one or more combined judgements such as empty, value range, special format field judgement sentencing for special format such as mailbox etc.
It is disconnected.
In the present embodiment, when carrying out cleaning and judge, a progress general format field judgement first, if total data passes through
Secondary judgement, then it is assumed that this group of data fit preset standard, without carrying out data cleansing；If if in the data of inside and outside including special lattice
Formula, then the judgement of general format field continues to carry out special format judgement after passing through, and detects whether using regular expression
Meet the requirement of special format field and the data fit preset standard is then judged, without carrying out data cleansing until all passing through.
Otherwise judgement is cleaned.
Step S20 matches according to the default cleaning format corresponding to the lookup of the respective channel mark of external data of internal data
It sets: if finding the cleaning format configuration, data being formatted according to configuration, after conversion, notification data conversion
It finishes；If not finding the cleaning format configuration, warning note；
In step S20, the data format of different channels transmitted be it is unified, make a concrete analysis of the channel data format its
With the difference of standard data format, conversion method is developed to specific aim is distinguished at difference, it is former if the amount of money retains 2 effective digitals
Beginning data be 1664.9964, then be converted to 1665.00, and conversion method is prestored according to channel mark into cleaning template,
The channel data are converted to unified standard data format according to default cleaning format.
Step S30, timing cycle checks whether there is the internal data of corresponding channel and external data is in ready state,
If nothing, terminate this lookup；If judgement has the internal data of corresponding channel and external data to be in ready state, according to
Default channel reconciliation rule executes reconciliation, and setting reconciliation is as a result, summarizing exception record simultaneously and going to step S40 processing；
In the present embodiment, it can be determined whether by internal data and external data existence anduniquess mark for same channel number
According to；Simultaneously as need to compare after internal data and external data are ready together, but the internal-external data ready time
It is difficult unanimously, above-mentioned steps can be spaced operation in ten minutes once, and whether correspond to channel data under checking all ready.In addition, may be used also
The ready record of an inside and outside data is generated daily, timing cycle checks the ready record state of the same day each configuration channel,
Start reconciliation if both ready.
If the correspondence channel inside and outside data in ready state are inquired, then terminate this lookup；
If judgement has corresponding channel inside and outside data to be in ready state,
S321 executes reconciliation according to default channel reconciliation rule；In this step, due to the inside and outside data through over cleaning
It is standardized data, same transaction is determined by internal-external system unique identifier, directly whether is comparison aiming field data
Reconciliation can unanimously be carried out.
S322 setting reconciliation is as a result, and be arranged automatic processing mark to the exception record that can be automated processing；This
In step, if when reconciliation, not meeting to have and presetting channel reconciliation rule, then judge that it belongs to exception record；Meanwhile according to reconciliation
Rule, for can automatic processing exception record, such as repeat gathering, the conventional abnormal problem of automatic reimbursement, also set up automatic
Change processing mark, for example repeat the record of payment, internal data is one, order, and channel is two, then reconciliation rule is just
It can be identified to the other reinforcement reimbursement of channel.
S323 summarizes exception record, is sent to operation system, and goes to step S40 processing；In this step, operation personnel's warp
Exception record is received by operation system, after manual analysis exception record, if judgement belongs to regular problem, may be selected to be added into
Default reconciliation rule.
Step S40, timing cycle judge whether exception record to be treated: if nothing, terminating this lookup；If so, then
Judge whether to need to be implemented manual examination and verification program, if calling core to hand over according to established rule without executing artificial review procedure
Easy system automation processing, and operation system is sent to after processing result is summarized；If artificial review procedure need to be executed, trigger
Manual examination and verification program and the auditing result for receiving the manual examination and verification program meet processing to judgement according to the auditing result
Logic calls the processing of core transaction system automation according to established rule, reports operation system to processing logic is not met.
Timing cycle judges whether exception record to be treated: whether timing inquiry receives the exception record of S30 transmission,
If nothing, terminate this lookup；If so, it is first determined whether need to be implemented manual examination and verification program, it can be according to the exception record summarized
In whether automatic processing mark judgement is set, if needing to be implemented manual examination and verification program, such as i.e. exception record contains oneself
Dynamicization processing mark, then call the processing of core transaction system automation according to established rule, and send after processing result is summarized
To operation system；If desired artificial review procedure is executed, such as all or part of exception record is identified not comprising automatic processing
When, judge whether to meet processing logic, to processing logic is met, then also calls core transaction system automatic according to established rule
Change processing processing；To processing logic is not met, operation department is reported.
Reconciliation standard process is following by reconciliation standard process of trading by transaction account checking method provided by the invention
Several steps: acquisition inside and outside data, data cleansing, inside and outside comparing, the subsequent automated processing of inconsistent data can be solved effectively
The unified reconciliation problem of different channels transaction, while can also be achieved docking new channel and can realize close to zero exploitation, completely using can
It is configured depending on changing, when the external channel of new access can support reconciliation, access to shorten to a few days, save significantly from several weeks by easy configuration
Save business manpower and time cost.
Embodiment 2
Please continue to refer to Fig. 2, a kind of transaction account checking apparatus is shown, in the present embodiment, transaction account checking apparatus 10 can be with
Including or be divided into one or more program modules, one or more program module is stored in storage medium, and by
Performed by one or more processors, to complete the present invention, and above-mentioned transaction account checking method can be realized.The so-called program of the present invention
Module is the series of computation machine program instruction section for referring to complete specific function, than program itself more suitable for description transaction pair
Implementation procedure of the account device 10 in storage medium.The function of each program module of the present embodiment will specifically be introduced by being described below:
A kind of transaction account checking apparatus 10 of the invention, including
Internal data obtains module 11, for the internal data of timing acquisition transaction, and whether judges the internal data
It is then transferred to transaction reconciliation module, if not preset standard format, then be transferred to if preset standard format for preset standard format
Data cleansing module；
External data obtains module 12, for the external data of timing acquisition transaction, and whether judges the external data
It is then transferred to transaction reconciliation module, if not preset standard format, then be transferred to if preset standard format for preset standard format
Data cleansing module；
Data cleansing module 13, for searching corresponding default cleaning format configuration according to the channel mark for receiving data: if
Cleaning format configuration is found, data are formatted according to configuration, after conversion, notification data conversion is finished；If not
Find cleaning format, warning note；
Transaction reconciliation module 14, the internal data for checking whether there is corresponding channel for timing cycle are located with external data
In ready state, if nothing, terminate this lookup；If it is ready that judgement has the internal data of corresponding channel to be in external data
State then executes reconciliation according to default channel reconciliation rule, and reconciliation is arranged as a result, summarizing exception record simultaneously and going to automation
Processing module processing；
Automatic processing module 15 judges whether exception record to be treated for timing cycle: if nothing, terminating this
It searches；If so, then judge whether to need to be implemented manual examination and verification program, if without executing artificial review procedure, according to both establishing rules
It then calls core transaction system automation to handle, and is sent to operation system after processing result is summarized；If artificial examine need to be executed
Core program then triggers manual examination and verification program and receives the auditing result of the manual examination and verification program, right according to the auditing result
Determine to meet handling according to established rule calling core transaction system automation for processing logic, handles the upper of logic to not meeting
Report operation system.
Preferably, the internal data obtains module 11 and the external data obtains in module 12, the internal data
It is the data of transaction yesterday with external data.
Preferably, the internal data obtains in module 11, and timing cycle obtains the internal data of transaction yesterday, and judges
Whether the internal data is preset standard format, if so, setting internal data is ready, and terminates the acquisition of this internal data；
It is cleaned if it is not, being transferred to data cleansing module, until setting internal data is ready, then terminates the acquisition of this internal data,
The internal data includes place channel mark；
Preferably, the external data obtains timing cycle in module 12 and obtains the external data of each channel transaction, and sentences
Whether the external data of the channel of breaking is preset standard format, if so, the external data that transaction channel yesterday is arranged is ready, and
Terminate the acquisition of this external data；It is cleaned if it is not, being transferred to data cleansing module 13, is traded until the channel yesterday is arranged
External data it is ready, then terminate this external data acquisition.
Preferably, the judgement of the preset standard format includes that the judgement of general format field and special format field judge,
The general format field judges for field type, length, whether allows sentencing as one or more combinations such as sky, value ranges
Disconnected, the special format field judgement is used for the judgement of special format.
Further, the general format field judgement is carried out first, if total data passes through, judges the data fit
Preset standard；If partial data passes through, continue the special format field judgement, until all passing through, then judgement should
Data fit preset standard.
Preferably, the external data obtains 12 in module, and timing cycle obtains external data the following steps are included: timing
Whether circular test has external channel data, if so, then calling external system to obtain the outer of the channel according to default channel configuration
Portion's data terminate the acquisition of this external data if nothing.
Further, the default channel of different channels configures different settings, and the preset configuration includes interface type, service
One or more combinations such as device address, port, calling interface time, the configuration of data cleansing rule.
Preferably, in the automatic processing module 15, automation is arranged to the exception record that can be automated processing
Processing mark.
Preferably, in the automatic processing module 15, channel reconciliation rule is preset if not meeting and having, judges its category
In exception record；
Preferably, if the exception record belongs to regular problem, it is added into default reconciliation rule.
Reconciliation standard process is following by reconciliation standard process of trading by transaction account checking apparatus provided by the invention
Several steps: acquisition inside and outside data, data cleansing, inside and outside comparing, the subsequent automated processing of inconsistent data can be solved effectively
The unified reconciliation problem of different channels transaction, while can also be achieved docking new channel and can realize close to zero exploitation, completely using can
It is configured depending on changing, when the external channel of new access can support reconciliation, access to shorten to a few days, save significantly from several weeks by easy configuration
Save business manpower and time cost.
Embodiment 3
The present embodiment also provides a kind of computer equipment, can such as execute the smart phone, tablet computer, notebook of program
Computer, desktop computer, rack-mount server, blade server, tower server or Cabinet-type server are (including independent
Server cluster composed by server or multiple servers) etc..The computer equipment 20 of the present embodiment includes at least but not
It is limited to: memory 21, the processor 22 of connection can be in communication with each other by system bus, as shown in Figure 3.It is pointed out that Fig. 3
The computer equipment 20 with component 21-22 is illustrated only, it should be understood that being not required for implementing all groups shown
Part, the implementation that can be substituted is more or less component.
In the present embodiment, memory 21 (i.e. readable storage medium storing program for executing) includes flash memory, hard disk, multimedia card, card-type memory
(for example, SD or DX memory etc.), random access storage device (RAM), static random-access memory (SRAM), read-only memory
(ROM), electrically erasable programmable read-only memory (EEPROM), programmable read only memory (PROM), magnetic storage, magnetic
Disk, CD etc..In some embodiments, memory 21 can be the internal storage unit of computer equipment 20, such as the calculating
The hard disk or memory of machine equipment 20.In further embodiments, memory 21 is also possible to the external storage of computer equipment 20
The plug-in type hard disk being equipped in equipment, such as the computer equipment 20, intelligent memory card (Smart Media Card, SMC), peace
Digital (Secure Digital, SD) card, flash card (Flash Card) etc..Certainly, memory 21 can also both include meter
The internal storage unit for calculating machine equipment 20 also includes its External memory equipment.In the present embodiment, memory 21 is commonly used in storage
Be installed on the operating system and types of applications software of computer equipment 20, for example, embodiment one transaction account checking apparatus 10 program
Code etc..In addition, memory 21 can be also used for temporarily storing the Various types of data that has exported or will export.
Processor 22 can be in some embodiments central processing unit (Central Processing Unit, CPU),
Controller, microcontroller, microprocessor or other data processing chips.The processor 22 is commonly used in control computer equipment
20 overall operation.In the present embodiment, program code or processing data of the processor 22 for being stored in run memory 21,
Such as operation transaction account checking apparatus 10, to realize the transaction account checking method of embodiment one.
Embodiment 4
The present embodiment also provides a kind of computer readable storage medium, such as flash memory, hard disk, multimedia card, card-type memory
(for example, SD or DX memory etc.), random access storage device (RAM), static random-access memory (SRAM), read-only memory
(ROM), electrically erasable programmable read-only memory (EEPROM), programmable read only memory (PROM), magnetic storage, magnetic
Disk, CD, server, App are stored thereon with computer program, phase are realized when program is executed by processor using store etc.
Answer function.The computer readable storage medium of the present embodiment is used for store transaction account checking apparatus 10, realization when being executed by processor
The transaction account checking method of embodiment one.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of transaction account checking method, which comprises the following steps:
Step S10, timing cycle obtain the internal data and external data of transaction, judge the internal data and the external number
According to whether being that preset standard format if preset standard format thens follow the steps S30, if not preset standard format, then execute
Step S20, wherein the internal data includes place channel mark with the external data；
Step S20, according to the default cleaning format configuration corresponding to the lookup of the respective channel mark of external data of internal data: if
The cleaning format configuration is found, data are formatted according to configuration, after conversion, notification data conversion is finished；
If not finding the cleaning format configuration, warning note；
Step 30, timing cycle checks whether there is the internal data of corresponding channel and external data is in ready state, if nothing,
Then terminate this lookup；If judgement has the internal data of corresponding channel and external data to be in ready state, according to default
Channel reconciliation rule executes reconciliation, and setting reconciliation is as a result, summarizing exception record simultaneously and going to step S40 processing；
Step S40, timing cycle judge whether exception record to be treated: if nothing, terminating this lookup；If so, then judging
Whether manual examination and verification program is needed to be implemented, if calling core transaction system according to established rule without executing artificial review procedure
System automatic processing, and operation system is reported after processing result is summarized；If artificial review procedure need to be executed, artificial examine is triggered
Core program and the auditing result for receiving the manual examination and verification program meet processing logic to judgement according to the auditing result
The processing of core transaction system automation is called according to established rule, the operation that reports again for not meeting processing logic to judgement is
System.
2. transaction account checking method according to claim 1, which is characterized in that the step S10, the internal data and outer
Portion's data are the data of transaction yesterday.
3. transaction account checking method according to claim 1, which is characterized in that the judgement of the preset standard format includes one
As format fields judgement and the judgement of special format field, general format field judgement for field type, length, whether permit
It perhaps is one or more combined judgements such as empty, value range, the special format field judgement is used for the judgement of special format.
4. transaction account checking method according to claim 3, which is characterized in that carry out the general format field first and sentence
It is disconnected, if total data passes through, judge the data fit preset standard；If partial data passes through, it is described special to continue
Format fields judgement then judges the data fit preset standard until all passing through.
5. transaction account checking method according to claim 1, which is characterized in that in the step S10, timing cycle obtains outer
Portion's data are the following steps are included: timing cycle checks whether there is external channel data, if so, then being called according to default channel configuration
External system obtains the external data of the channel, if nothing, terminates the acquisition of this external data.
6. transaction account checking method according to claim 5, which is characterized in that the default channel configuration difference of different channels is set
It sets, the preset configuration includes interface type, server address, port, calling interface time, configuration of data cleansing rule etc. one
Kind or a variety of combinations.
7. transaction account checking method according to claim 1, which is characterized in that in the step 30, to can be automated
The exception record setting automatic processing of processing identifies.
8. a kind of transaction account checking apparatus, characterized in that it comprises:
Internal data obtain module, for timing cycle obtain transaction internal data, and judge the internal data whether be
Preset standard format is then transferred to transaction reconciliation module if preset standard format, if not preset standard format, then amount brought forward
According to cleaning module；
External data obtains module, for the external data of timing acquisition transaction, and judges whether the external data is default
Reference format is then transferred to transaction reconciliation module, if not preset standard format, then it is clear to be transferred to data if preset standard format
Mold cleaning block；
Data cleansing module, for the default cleaning lattice corresponding to the lookup of the respective channel mark of external data according to internal data
Formula configuration: if finding the cleaning format configuration, formatting data according to configuration, after conversion, notification data
Conversion finishes；If not finding the cleaning format configuration, warning note；
Trade reconciliation module, check whether there is the internal data of corresponding channel for timing cycle and external data be in it is ready
State terminates this lookup if nothing；If judgement has the internal data of corresponding channel and external data to be in ready state,
Then reconciliation, setting reconciliation are executed as a result, summarizing exception record simultaneously and going to automatic processing according to default channel reconciliation rule
Resume module；
Automatic processing module judges whether exception record to be treated for timing cycle: if nothing, terminating this lookup；
If so, then judging whether to need to be implemented manual examination and verification program, if calling without executing artificial review procedure according to established rule
The processing of core transaction system automation, and operation system is sent to after processing result is summarized；If artificial review procedure need to be executed,
If artificial review procedure need to be executed, triggers manual examination and verification program and receive the auditing result of the manual examination and verification program, according to
The auditing result calls the processing of core transaction system automation according to established rule to what judgement met processing logic, to sentencing
Surely do not meet processing logic reports operation system.
9. a kind of computer equipment, can run on a memory and on a processor including memory, processor and storage
Computer program, which is characterized in that the processor realizes any one of claim 1 to 7 institute when executing the computer program
The step of stating method.
10. a kind of computer readable storage medium, is stored thereon with computer program, it is characterised in that: the computer program
The step of any one of claim 1 to 7 the method is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910301878.1A CN110175165A (en) | 2019-04-16 | 2019-04-16 | Transaction account checking method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910301878.1A CN110175165A (en) | 2019-04-16 | 2019-04-16 | Transaction account checking method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110175165A true CN110175165A (en) | 2019-08-27 |
Family
ID=67689469
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910301878.1A Pending CN110175165A (en) | 2019-04-16 | 2019-04-16 | Transaction account checking method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110175165A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110689419A (en) * | 2019-10-08 | 2020-01-14 | 四川云智造科技有限公司 | Method, device and equipment for checking multi-party data |
| CN111026763A (en) * | 2019-12-13 | 2020-04-17 | 中国建设银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN111598683A (en) * | 2020-05-18 | 2020-08-28 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN111831683A (en) * | 2020-07-24 | 2020-10-27 | 北京思特奇信息技术股份有限公司 | Automatic auditing method and system based on dynamic extended scene matching |
| CN112801767A (en) * | 2021-01-22 | 2021-05-14 | 中信银行股份有限公司 | Accounting data processing method and device for newly added channels |
| CN113486059A (en) * | 2021-07-23 | 2021-10-08 | 重庆富民银行股份有限公司 | Multi-thread-based account checking method and system |
| CN113689271A (en) * | 2020-05-18 | 2021-11-23 | 深圳兆日科技股份有限公司 | Method, device, equipment and storage medium for checking account between enterprise and bank |
| CN113837878A (en) * | 2021-09-07 | 2021-12-24 | 中国银联股份有限公司 | Data comparison method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN108876945A (en) * | 2018-04-27 | 2018-11-23 | 武汉光谷智能交通科技有限公司 | Transaction classifying method and device based on free flow non-parking charge payment system |
| CN109034993A (en) * | 2018-09-29 | 2018-12-18 | 深圳前海微众银行股份有限公司 | Account checking method, equipment, system and computer readable storage medium |
| CN109325028A (en) * | 2018-08-22 | 2019-02-12 | 平安普惠企业管理有限公司 | A kind of reconciliation file verification method and terminal device |
-
2019
- 2019-04-16 CN CN201910301878.1A patent/CN110175165A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN108876945A (en) * | 2018-04-27 | 2018-11-23 | 武汉光谷智能交通科技有限公司 | Transaction classifying method and device based on free flow non-parking charge payment system |
| CN109325028A (en) * | 2018-08-22 | 2019-02-12 | 平安普惠企业管理有限公司 | A kind of reconciliation file verification method and terminal device |
| CN109034993A (en) * | 2018-09-29 | 2018-12-18 | 深圳前海微众银行股份有限公司 | Account checking method, equipment, system and computer readable storage medium |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110689419A (en) * | 2019-10-08 | 2020-01-14 | 四川云智造科技有限公司 | Method, device and equipment for checking multi-party data |
| CN111026763A (en) * | 2019-12-13 | 2020-04-17 | 中国建设银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN111598683A (en) * | 2020-05-18 | 2020-08-28 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN113689271A (en) * | 2020-05-18 | 2021-11-23 | 深圳兆日科技股份有限公司 | Method, device, equipment and storage medium for checking account between enterprise and bank |
| CN111598683B (en) * | 2020-05-18 | 2023-10-27 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN111831683A (en) * | 2020-07-24 | 2020-10-27 | 北京思特奇信息技术股份有限公司 | Automatic auditing method and system based on dynamic extended scene matching |
| CN112801767A (en) * | 2021-01-22 | 2021-05-14 | 中信银行股份有限公司 | Accounting data processing method and device for newly added channels |
| CN113486059A (en) * | 2021-07-23 | 2021-10-08 | 重庆富民银行股份有限公司 | Multi-thread-based account checking method and system |
| CN113837878A (en) * | 2021-09-07 | 2021-12-24 | 中国银联股份有限公司 | Data comparison method, device, equipment and storage medium |
| CN113837878B (en) * | 2021-09-07 | 2024-05-03 | 中国银联股份有限公司 | Data comparison method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110175165A (en) | Transaction account checking method, device, computer equipment and storage medium | |
| CN110704231A (en) | Fault processing method and device | |
| CN109582301A (en) | Method for processing business, device, equipment and the medium of task based access control scheduling system | |
| CN111400011B (en) | Real-time task scheduling method, system, equipment and readable storage medium | |
| CN105677465B (en) | The data processing method and device of batch processing are run applied to bank | |
| CN109345200A (en) | Automatic auditing method and device, computer readable storage medium based on high-volume report | |
| CN110138688A (en) | Dynamic adjusts method, apparatus, equipment and the readable storage medium storing program for executing of business interface | |
| CN109298882A (en) | Management method, computer readable storage medium and the terminal device of interface | |
| WO2019192092A1 (en) | Data processing method and apparatus, terminal device, and storage medium | |
| CN110633977A (en) | Payment exception processing method and device and terminal equipment | |
| CN112162980A (en) | Data quality control method and system, storage medium and electronic equipment | |
| CN109190776A (en) | Reinspection method, apparatus, terminal device and the storage medium of vehicle failure | |
| CN111399828A (en) | Model-driven logic device modeling method and terminal | |
| CN108376110A (en) | A kind of automatic testing method, system and terminal device | |
| CN114116801A (en) | Data list checking method and device | |
| CN107133090A (en) | A kind of method for processing business and device | |
| CN111241112A (en) | Micro-service call supervision system and method for guaranteeing idempotent | |
| CN116302652A (en) | System alarm information processing method and device and electronic equipment | |
| CN112419052B (en) | Transaction testing method, device, electronic equipment and readable storage medium | |
| CN111680974B (en) | Method and device for positioning problems of electronic underwriting process | |
| CN111767299A (en) | Database operation method, device and system, storage medium and electronic equipment | |
| CN111309370A (en) | Version number directed graph sorting audit method and system for multi-project and multi-system environment | |
| CN112860780B (en) | Data export method and device and terminal equipment | |
| CN117973825A (en) | Multi-bank channel task flow differentiation processing method and device | |
| CN116433197B (en) | Information reporting method, device, reporting end and storage medium |
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 | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20240528 |
|
| AD01 | Patent right deemed abandoned |