CN109918403A - Data verification method, device, computer equipment and storage medium - Google Patents

Data verification method, device, computer equipment and storage medium Download PDF

Info

Publication number
CN109918403A
CN109918403A CN201910107168.5A CN201910107168A CN109918403A CN 109918403 A CN109918403 A CN 109918403A CN 201910107168 A CN201910107168 A CN 201910107168A CN 109918403 A CN109918403 A CN 109918403A
Authority
CN
China
Prior art keywords
file
report
verification
background server
entries
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
Application number
CN201910107168.5A
Other languages
Chinese (zh)
Inventor
张宁宁
蒋先虎
王跃东
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN201910107168.5A priority Critical patent/CN109918403A/en
Publication of CN109918403A publication Critical patent/CN109918403A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

This application provides a kind of data verification method, device, computer equipment and storage mediums, wherein this method comprises: end equipment sends file destination to background server forward, wherein file destination includes file entries to be adjusted;The file destination adjusted that background server receiving front-end equipment returns;Background server verifies the file entries in file destination adjusted according to preset verification rule;Corresponding file entries store in the file entries overlay file report that background server passes through verification, and will verify status modifier of the file entries passed through in file report is that can report and submit.Above-mentioned data verification method solves the technical issues of existing inefficiency verified to file report, higher cost, has reached effective technical effect for promoting verification efficiency, reducing verification cost.

Description

Data verification method, device, computer equipment and storage medium
Technical field
This application involves field of computer technology, in particular to a kind of data verification method, device, computer equipment and deposit Storage media.
Background technique
As economic development and capital are open, bank card off-shore transaction business is more and more, and regulatory agency includes country The Administration of Foreign Exchange reports and submits the timeliness requirement of (such as bank card off-shore transaction data are reported and submitted) higher and higher foreign exchange transaction data. Under normal circumstances, the transaction details that bank needs that the T days row bank cards was reported and submitted to withdraw deposit and consume overseas before 12:00 on T+1, Then the detail reported and submitted by the Administration of Foreign Exchange according to each bank, it is determined whether exist and withdraws deposit the user of amount beyond calendar year, if These users are then added to preset list list in the presence of beyond the withdraw deposit user of amount of calendar year, and in T+1 days 15:00 The list list is handed down to each bank and carries out transaction control, to suspend these users current year and next year domestic bank card in time Overseas withdraw deposit.
However when information is reported and submitted in processing supervision, there are the transaction details for not meeting Administration of Foreign Exchange's interface specification requirement (such as visitor Family information is not complete, transaction additional information is not congruent), if bank does not verify, it will receive the feedback error of the Administration of Foreign Exchange after reporting and submitting Information needs to report and submit again after modifying, so that the interaction between bank and the Administration of Foreign Exchange becomes cumbersome, the correctness of data And the timeliness reported and submitted cannot ensure.Traditional solution is to increase verification, but after verifying, how to guarantee business people There is no check errors after member's modification, how to allow business personnel to log in front of T+1 12:00 and successfully modified in time, and feed back modification As a result, being a problem to be solved.
In view of the above-mentioned problems, current effective solution scheme set forth above.
Summary of the invention
The embodiment of the present application provides a kind of data verification method, device, computer equipment and storage medium, existing to solve There is the problem of correctness of the data in technology and the timeliness reported and submitted cannot ensure.
The embodiment of the present application provides a kind of data verification method, comprising: end equipment sends target to background server forward File, wherein file destination includes file entries to be adjusted;The target adjusted that background server receiving front-end equipment returns File;Background server verifies the file entries in file destination adjusted according to preset verification rule;From the background Corresponding file entries store in the file entries overlay file report that server passes through verification, and the file that verification is passed through Status modifier of the entry in file report is that can report and submit.
In one embodiment, regular to the text in file destination adjusted according to preset verification in background server After part entry is verified, this method further include: background server will verify unsanctioned file entries and verification is not led to It crosses reason and is sent to headend equipment.
In one embodiment, the status modifier in the file entries for passing through verification in file report is that can report and submit it Afterwards, this method further include: background server determines whether the state of All Files entry is all that can report and submit in file report;True The state for determining All Files entry is all in the case where can reporting and submitting, and background server sends file report.
In one embodiment, before end equipment sends file destination to background server forward, this method further include: after Platform server obtains original document from data warehouse;Background server pre-processes original document, to generate file report; Background server verifies the file entries in file report according to preset verification rule one by one, and will be in file report The state for verifying the file entries passed through is set to and can report and submit, and the state that unsanctioned file entries are verified in file report is set to It is to be adjusted;Unsanctioned file entries will be verified as file destination.
It in one embodiment, should after the file destination adjusted that background server receiving front-end equipment returns Method further include: file destination adjusted is stored in the interim table of background data base by background server.
In one embodiment, preset verification rule includes field verification rule and interfield verification rule.
The embodiment of the present application also provides a kind of data calibration devices, are located in background server, which includes: file Sending module sends file destination for end equipment forward, wherein file destination includes file entries to be adjusted;File reception Module, the file destination adjusted returned for receiving front-end equipment;File verification module, for being advised according to preset verification Then the file entries in file destination adjusted are verified;Document processing module, for the file item passed through will to be verified Corresponding file entries storage in mesh overlay file report, and status maintenance of the file entries that verification is passed through in file report It is changed to report and submit.
In one embodiment, which further includes report sending module, and report sending module is specifically used for: determining file Whether the state of All Files entry is all that can report and submit in report;It is all the feelings that can be reported and submitted in the state for determining All Files entry Under condition, file report is sent.
The embodiment of the present invention also provides a kind of computer equipment, including processor and refers to for storage processor to be executable The memory of order, the processor realize the step of data verification method described in above-mentioned any embodiment when executing described instruction Suddenly.
The embodiment of the present invention also provides a kind of computer readable storage medium, is stored thereon with computer instruction, the finger Order is performed the step of realizing data verification method described in above-mentioned any embodiment.
The embodiment of the present application provides a kind of data verification method, before reporting and submitting file report, in file report File entries are verified, and just can be that can report and submit by the status modifier of corresponding file entries after in verification, to protect The accuracy of data in file report is demonstrate,proved, further, because verification is carried out by background server, headend equipment is not Need built-in verification rule, therefore, can be regular only with a set of verification, can with effectively save system development and maintenance cost, And business personnel is verified without toggling between front and back, so as to reduce the workload of business personnel, It ensure that the timeliness of verification.Solve the existing inefficiency verified to file report, cost through the above scheme Higher technical problem has reached effective technical effect for promoting verification efficiency, reducing verification cost.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present application, constitutes part of this application, not Constitute the restriction to the application.In the accompanying drawings:
Fig. 1 is the flow chart according to data verification method provided by the embodiments of the present application;
Fig. 2A is the schematic diagram according to the file report provided by the embodiments of the present application without business personnel's adjustment;
Fig. 2 B is according to the schematic diagram provided by the embodiments of the present application through the primary file report adjusted of business personnel;
Fig. 2 C is according to the schematic diagram provided by the embodiments of the present application through the multiple file report adjusted of business personnel;
Fig. 3 is the precedence diagram according to data verification method provided by the embodiments of the present application;
Fig. 4 is the flow chart according to data verification method provided by the embodiments of the present application;
Fig. 5 is the structural schematic diagram according to data calibration device provided by the embodiments of the present application;
Fig. 6 is the structural schematic diagram of the computer equipment provided according to embodiments of the present invention.
Specific embodiment
The principle and spirit of the application are described below with reference to several illustrative embodiments.It should be appreciated that providing this A little embodiments are used for the purpose of making those skilled in the art can better understand that realizing the application in turn, and be not with any Mode limits scope of the present application.On the contrary, it is more thorough and complete to these embodiments are provided so that the application discloses, and And the scope of the present disclosure can be completely communicated to those skilled in the art.
It will be apparent to one skilled in the art that presently filed embodiment can be implemented as a kind of system, appliance arrangement, method Or computer program product.Therefore, disclose can be with specific implementation is as follows by the application, it may be assumed that complete hardware, complete soft The form that part (including firmware, resident software, microcode etc.) or hardware and software combine.
In view of the existing method maintenance cost for checkout transaction information is high and is not able to satisfy asking for timeliness requirement Topic, so that off-shore transaction information cannot be reported and submitted timely and accurately, and expends a large amount of human costs.For this problem, it is contemplated that mesh Preceding method of calibration is using separately independent front-back ground checkout, front and back technology disunity, that is, front and back respectively develops a set of file Correction verification module simultaneously calls respective verification rule.If in this regard, in view of can establish a set of unified front-back ground checkout rule, Headend equipment calls the correction verification module in background server to verify modified Transaction Information, returns and protects after being verified It is saved as function or back-checking does not pass through reason, the development and maintenance cost of developer can be saved in this way, while making industry Business personnel toggle between being not necessarily to front and back in verification and verify and can receive immediately check results (without waiting for rear Platform batch verifies again), and be further processed according to check results, so as to reduce business personnel workload and Verification efficiency and accuracy are improved, and then meets the timeliness requirement of off-shore transaction information checking.
Based on problem above, embodiment of the present invention provides a kind of data verification method, as shown in Figure 1, may include Following steps:
Step S102, end equipment sends file destination to background server forward, wherein file destination includes file to be adjusted Entry.
Wherein, above-mentioned background server can be single server, be also possible to server cluster or cloud service Device etc. is ok, and specific group is shaped to the application and is not construed as limiting.Above-mentioned headend equipment can be desktop computer, notebook, hand Machine terminal, PDA etc., as long as all can may be used to the equipment that user or business personnel carry out content displaying and receive operational order To be formed for the presentation of headend equipment, the application is also not construed as limiting.
Specifically, when headend equipment starts, end equipment sends file destination to background server forward.File destination can be with Including bank card off-shore transaction information, wherein bank card off-shore transaction information can include but is not limited to credit card off-shore transaction Information and debit card off-shore transaction information.File entries to be adjusted can be carried in above-mentioned file destination, wherein text to be adjusted Part entry refers to the transaction details information for not meeting Administration of Foreign Exchange's interface specification requirement (for example, customer information is not complete, the additional letter of transaction It ceases not congruent).
Step S104, the file destination adjusted that background server receiving front-end equipment returns.
Specifically, headend equipment receives the backward business personnel displaying of the file destination of background server transmission, business Personnel are adjusted file destination by headend equipment, that is, according to Administration of Foreign Exchange's interface specification to text to be adjusted in file destination Part entry is adjusted.Later, when saving when the user clicks, file destination adjusted is sent background service by headend equipment Device, the file destination adjusted that background server receiving front-end equipment returns.
Step S106, background server according to preset verification rule to the file entries in file destination adjusted into Row verification.
Specifically, the specification that developer can provide according to business personnel establishes verification regulation parameter table, by bank border The verification rule of outer Transaction Information all configures, and encloses the description of every verification rule.Background server is receiving tune After file destination after whole, verification function is called, verification function reads configured verification rule, thus according to preset school Rule is tested to verify the file entries in file destination adjusted.
Step S108, background server will verify corresponding file entries in the file entries overlay file report passed through and deposit Storage, and will verify status modifier of the file entries passed through in file report is that can report and submit.
Specifically, for the file entries that pass through of verification, background server is by corresponding file in its overlay file report Entry storage, and be that can report and submit by the corresponding status modifier of this document entry in file report.Wherein, file report is stored in Off-shore transaction information report in background server may include the file entries that can be reported and submitted and file entries to be adjusted.Please A and Fig. 2 B referring to fig. 2, Fig. 2A schematically illustrate the file report without business personnel's adjustment, wherein the shape of file entries State is that can report and submit or to be adjusted;Fig. 2 B is schematically illustrated through the primary file report adjusted of business personnel, wherein second The state of file entries is modified to report and submit.
Above-mentioned data verification method verifies the file entries of file destination, before reporting and submitting file report in school It tests by can just save later and be that can report and submit by the status modifier of file entries corresponding in file report, to guarantee file The accuracy of data in report, further, because verification is carried out by background server, headend equipment does not need interior Verification rule is set, therefore, can be only with a set of verification rule, can be with effectively save system development and maintenance cost, and make It obtains business personnel to verify without toggling between front and back, so as to reduce the workload of business personnel, ensure that The timeliness of verification;Meanwhile more accurate stringent verification can be carried out in background server, and then improve the accurate of verification Property.
Further, regular to the file entries in file destination adjusted according to preset verification in background server After being verified, if verification does not pass through, it is necessary to which business personnel further adjusts, in order to keep business personnel faster more acurrate File entries to be adjusted are adjusted on ground, can will verify unsanctioned file entries and verification is not sent to front end by reason Equipment.In this way, business personnel to verify when unsanctioned file entries are adjusted can according to verification by reason into Row adjustment, so that adjusting file entries, more efficiently targetedly more so as to improve the efficiency of data check.
When above-mentioned data verification method being applied to bank card off-shore transaction information reporting and submitting, in order to allow bank and the Administration of Foreign Exchange Between interaction become it is succinct efficiently, avoid receiving error information after reporting and submitting the Administration of Foreign Exchange, institute can be ensured before reporting and submitting The state for having the All Files entry in file report is that can report and submit.Therefore, in some embodiments of the present application, in step After S108, above-mentioned data verification method can also include: background server determine in file report whether All Files entry State be all that can report and submit;In the case where determining the state of All Files entry is all that can report and submit, background server is by file Report is sent.
Specifically, background server will verify the file entries passed through before file report is reported and submitted the Administration of Foreign Exchange Status modifier in file report is that can determine whether own in All Files report by background server after can reporting and submitting The state of file entries is all that can report and submit, in the case where determining the state of All Files entry is all that can report and submit, background service Device sends file report.In this way, ensuring the All Files entry in All Files report after the completion of each verification State be that in the case where can reporting and submitting, file report is sent, can report an error to avoid being received after reporting and submitting the Administration of Foreign Exchange Information allows the interaction between bank and the Administration of Foreign Exchange to become succinct efficient, guarantees the accuracy of the timeliness reported and submitted and data.
It is illustrated by taking a file report as an example below, refers to Fig. 2A to Fig. 2 C.Fig. 2A is without business personnel's tune Whole file report.Fig. 2 B is the file report once adjusted through business personnel.Fig. 2 C is the text repeatedly adjusted through business personnel Part report.In fig. 2b, after business personnel once adjusts, the state of the file entries of Article 2 is set to report and submit.? Background server judges whether that the state of All Files entry is in the case of in Fig. 2 B, to be unsatisfactory for reporting and submitting when can report and submit Condition, without reporting and submitting.In fig. 2 c, after business personnel repeatedly adjusts, All Files entry in file report State is that can report and submit, and satisfaction reports and submits condition, then background server can send file report.
It is understood that background server can be straight after determining that the state of All Files entry is that can report and submit It connects the file report that will be adjusted and is sent to Administration of Foreign Exchange's management system, background server can also send out the file report adjusted Headend equipment is given, headend equipment sends it to Administration of Foreign Exchange's management system again, and the application is not construed as limiting this.
Further, if background server determine the file entries in file report state be not be that can report and submit, Then background server return step S102, and repeat the above steps, until the state of the All Files entry in file report is equal For that can report and submit.
Fig. 3 is referred to, the precedence diagram according to data verification method provided by the embodiments of the present application is shown.In Fig. 3, after End equipment sends file destination to platform server forward, and headend equipment shows file destination to business personnel, and business personnel is to target File entries to be adjusted in file are adjusted, and are clicked and are saved after having adjusted, and are initiated data and are saved request, ask in response to this It asks, headend equipment sends file destination adjusted to background server, and background server is exchanged according to preset verification rule File destination after whole is verified, and corresponding file entries save in the file entries overlay file report that verification is passed through, It and is that can report and submit the status modifier of the entry, and record and verify the verifications of unsanctioned file entries and do not pass through reason, school After the completion of testing forward end equipment back-checking as a result, headend equipment saves successfully or school according to check results to business personnel's display It tests and does not pass through reason.Successfully illustrate that the state of the entry of the All Files in this document report is that can report and submit if saving, if returning Verification is returned not by reason, then needs business personnel further to adjust, until the state of All Files entry is that can report and submit.
As previously mentioned, the state of the file entries in file report is that can report and submit or can adjust, in file destination File entries update respective file entry and its state in file report after being verified.It, can be true before being verified Determine the state of All Files entry in file report and generates file destination.Therefore, in some embodiments of the present application, such as scheme Shown in 4, before step S102, the data verification method can with the following steps are included:
Step 401, background server obtains original document from data warehouse.
Specifically, background server can obtain original document from Data Warehouse In Bank, and original document refers to data warehouse The source data of the bank card off-shore transaction information of middle storage.In the present embodiment, bank card off-shore transaction information includes but is not limited to Credit card off-shore transaction information and debit card off-shore transaction information in proxima luce (prox. luc) 24 hours.
Step 402, background server pre-processes original document, to generate file report.
Bank card off-shore transaction information is reported and submitted in order to subsequent, can to the source data in the original document of acquisition into Row pretreatment, to generate file report.Specifically, rule is processed according to the screening that business personnel provides, it will be in original document File entries are screened and are processed according to Administration of Foreign Exchange's statement form one by one, are determined data area and are processed every Transaction Information institute Data item is needed, generates file report, and the file report of generation is stored in background data base.For example, Administration of Foreign Exchange's requirement will Transaction amount is more than that 1000 yuan of transaction is reported and submitted, thus can be pre-processed to source data.
Step 403, background server carries out school to the file entries in file report according to preset verification rule one by one It tests, and the state for verifying the file entries passed through in file report is set to and can be reported and submitted, it is unsanctioned by being verified in file report The state of file entries is set to be adjusted.
Specifically, background server can carry out the All Files entry in file report according to preset verification rule It verifies one by one, the state that the file entries passed through are verified in file report, which is set to, to report and submit, and do not led to verifying in file report The state for the file entries crossed is set to be adjusted.And further, for verifying unsanctioned file entries in file report, Specifically verification is not carried out accordingly by reason so that business personnel is subsequent according to verification background server record not by reason Adjustment or modification.
Step 404, unsanctioned file entries will be verified as file destination.
Specifically, in order to improve transmission rate, unsanctioned file entries can will be verified in file report as target File, and headend equipment is sent to subsequently through background server.Thus it is possible, on the one hand, being not necessarily to entire file report in front and back It is transmitted back and forth between platform;On the other hand, headend equipment to business personnel show file destination in file entries, business personnel without File entries to be adjusted need to be filtered out, directly the All Files entry in file destination is adjusted, and by mesh adjusted Mark file returns to background server.It is understood that in the case where not considering transmission rate, background server can also be with Using the All Files entry in file report as file destination.
Further, in above-mentioned data verification method, the target adjusted of background server receiving front-end equipment return File, in order to improve verification speed and save memory space, in some embodiments of the present application, after step s 104, Data verification method can also include: the interim table that file destination adjusted is stored in background data base by background server In.
Specifically, it after background server receives the file destination adjusted that headend equipment returns, stores it in In the interim table of background data base, then background server is according to preset verification rule to the target text being stored in interim table The file entries of part are verified, and corresponding in the file report in the file entries covering background data base that verification is passed through File entries are stored.In the present embodiment, the interim table of database plays the role of an interim storing data, ties in verification After beam, interim table is released, and can save memory space, and the service speed of interim table is very fast, and data school can be improved Test speed.In addition, file entries adjusted are stored in file report the unified progress of simultaneously timing in compared with the prior art Batch verifies, and the present embodiment can be and right by the way that business personnel's file entries adjusted are temporarily stored in interim table The file entries being stored in interim table are verified immediately, and instant back-checking is protected as a result, verification speed can be greatly speeded up The timeliness that card data are reported and submitted.
In above-mentioned data verification method, background server is according to preset verification rule to all texts in file report File entries in part entry and file destination adjusted are verified.In general, same file destination or file report There is association between different field in table in same file entry, in addition, also depositing between certain file destinations or file report It is being associated with, thus is corresponding between the different field of same transaction that there is also associations in different target file or file report.In order into One step improves the accuracy of verification, and in some embodiments of the present application, preset verification rule may include field verification rule Then rule is verified with interfield.Further, interfield verification rule may include in same file destination or file report Interfield verification rule and the interfield between different target file or file report verify rule.
Specifically, developer can use Database verification regulation parameter table, and bank card off-shore transaction is reported and submitted The verification rule of each field or interfield all configures, and encloses the description of every verification rule.When being verified, adjust With verification function, verification function reads configured verification rule and is verified, if meeting verification rule, its state is set to It can report and submit, otherwise be reported and submitted state to be set to be adjusted, and record verification and do not pass through reason.By setting field verify rule and Interfield verification rule, can in same file report field and interfield verify, but also may be implemented more Between a file report across across the field verification of table, be enable to carry out more accurate and stringent verification.For across table Across field verification may be relevant between each report due to being stored with multiple reports in background data base, in background server When being verified, using preset verification rule and associated report, realize with can be convenient across across the field verification of table.
For example, background server obtains the original document of bank card off-shore transaction information from data warehouse and carries out pre- 36 file reports are generated after processing, in this 36 file reports between certain file reports there are incidence relation, When being verified to the Transaction Information in a file report, it can call across rule is verified between literary name section, to realize across table Interfield verification.For example, when business personnel adjusts D05_2 table, when the (" pass of other side and mechanism D0504=1 of D05-2 table System " selection " the overseas investment person that other side is mechanism ") when, Z03 table must make a report on corresponding shareholder's information, if without Z03 Without corresponding information in table, when verification will back-checking do not pass through reason, reminding business personnel make a report on correspondence in Z03 table Shareholder's information.By using across verifying between literary name section, business personnel can be allowed efficiently accurately to adjust file to be adjusted Entry, to improve the efficiency and accuracy of verification.
The above method is illustrated below with reference to a specific embodiment, it should be noted, however, that the specific implementation Example does not constitute an undue limitation on the present application merely to the application is better described.
In the present embodiment, a kind of side for reporting and submitting in bank card off-shore transaction information and carrying out data check in system is provided Method may comprise steps of:
Step 1: background server obtains the bank card off-shore transaction in proxima luce (prox. luc) 24 hours from Chinese Data Warehouse In Bank The original document of information, and loaded.
Step 2: background server pre-processes the source data in original document according to service logic, i.e., according to business The screening processing rule that personnel provide pre-processes, and determines data area and processes every required data item of trading, generates text Part report.
Step 3: background server runs correction verification module, calls verification function, reads the verification in verification regulation parameter table Rule verifies every information in file report, and the state for the Transaction Information that verification passes through is set to and can be reported and submitted, high-ranking officers The state for testing unsanctioned Transaction Information is set to the specific verification of to be adjusted and record and does not pass through reason.
Step 4: before the Transaction Information and check bit to be adjusted in report is sent to by background server by reason End equipment.Headend equipment login system is opened when business personnel goes to work, and inquires data to be adjusted, and reason is not passed through according to verification Data to be modified one by one, clicks and saves after modification, modified data are sent background server by headend equipment, and to Background server send the data to transaction business ginseng number and session Session_ID.
Step 5: background server runs correction verification module, calls verification function, reads the verification in verification regulation parameter table Rule verifies every data of return, corresponding text in the file report in data cover database that verification is passed through Part entry is saved, and is that can report and submit by the status modifier of the data, and for verifying unsanctioned data, then record is specific Verification is not by reason, so that business personnel is further adjusted.Pass through if All Files entry verifies, forward end Equipment feedback saves successfully, and otherwise, back-checking does not pass through reason and the unsanctioned file entries of verification.
Step 6: background server determines whether that the state of all data in all reports is that can report and submit, if then will Report sends and terminates process, no to then follow the steps 7.
Step 7: repeating step 4 to step 6.
The method verified in above-described embodiment to bank card off-shore transaction information, first background server are from China silver Row data warehouse obtains the source data of bank card off-shore transaction information, after being pre-processed, generates file report, and by file report File entries to be adjusted in table are sent to headend equipment as file destination and back-checking does not pass through reason, for business people Member is not adjusted by reason according to verification, to improve processing speed and verification efficiency;Then, headend equipment will be adjusted File destination return background server verified, can by the way that file destination to be stored in the interim table of background data base To save memory space, operating efficiency is improved;After the completion of verification, for the file entries that verification passes through, by its overlay file Corresponding entry in report save and is updated to report and submit by its state, for verifying unsanctioned file entries, record Verification is not by reason, so that business personnel is further adjusted, until the All Files entry in All Files report State be that can report and submit.Further, since verification is carried out by background server, headend equipment does not need built-in Verification rule therefore can be only with a set of verification rule, can be with effectively save system development and maintenance cost, and makes Business personnel verifies without toggling between front and back, so as to reduce the workload of business personnel, ensure that school The timeliness tested.Simultaneously as being verified in background server, can carry out across across the field verification of table, so as to carry out Tightened up verification further improves the accuracy of verification.
Based on the same inventive concept, a kind of data calibration device is additionally provided in the embodiment of the present application, is located at backstage and is taken It is engaged in device, as described in the following examples.Since the principle that data calibration device solves the problems, such as is similar to data verification method, because The implementation of this data calibration device may refer to the implementation of data verification method, and overlaps will not be repeated.It is used below, The combination of the software and/or hardware of predetermined function may be implemented in term " unit " or " module ".Although following embodiment is retouched The device stated preferably realized with software, but the combined realization of hardware or software and hardware be also may and by structure Think.Fig. 5 is a kind of structural block diagram of the data calibration device being located in background server of the embodiment of the present application, such as Fig. 5 institute Show, may include: file sending module 502, file reception module 504, file verification module 506 and document processing module 508, The structure is illustrated below.
File sending module 502 sends file destination for end equipment forward, wherein file destination includes text to be adjusted Part entry.
Wherein, above-mentioned background server can be single server, be also possible to server cluster or cloud service Device etc. is ok, and specific group is shaped to the application and is not construed as limiting.Above-mentioned headend equipment can be desktop computer, notebook, hand Machine terminal, PDA etc., as long as all can may be used to the equipment that user or business personnel carry out content displaying and receive operational order To be formed for the presentation of headend equipment, the application is also not construed as limiting.
Specifically, when headend equipment starts, end equipment sends file destination to file sending module 502 forward.Target text Part may include bank card off-shore transaction information, wherein bank card off-shore transaction information can include but is not limited to credit card border Outer Transaction Information and debit card off-shore transaction information.File entries to be adjusted can be carried in above-mentioned file destination, wherein to Adjustment file entries refer to the transaction details information for not meeting Administration of Foreign Exchange's interface specification requirement (for example, customer information is not complete, transaction Additional information is not congruent).
File reception module 504, the file destination adjusted returned for receiving front-end equipment.
Specifically, headend equipment receives the backward business personnel displaying of the file destination of the transmission of file sending module 502, Business personnel is adjusted file destination by headend equipment, that is, according to Administration of Foreign Exchange's interface specification in file destination wait adjust Whole file entries are adjusted.Later, when saving when the user clicks, file destination adjusted is sent backstage by headend equipment Server, the file destination adjusted that 504 receiving front-end equipment of file reception module returns.
File verification module 506, for regular to the file entries in file destination adjusted according to preset verification It is verified.
Specifically, the specification that developer can provide according to business personnel establishes verification regulation parameter table, by bank border The verification rule of outer Transaction Information all configures, and encloses the description of every verification rule.Background server is receiving tune After file destination after whole, file verification module 506 calls verification function, and verification function reads configured verification rule, To be verified according to preset verification rule to the file entries in file destination adjusted.
Document processing module 508, for corresponding file entries in the file entries overlay file report passed through will to be verified Storage, and will verify status modifier of the file entries passed through in file report is that can report and submit.
Specifically, for verifying the file entries passed through, the document processing module 508 in background server is covered text Corresponding file entries storage in part report, and be that can report and submit by the corresponding status modifier of this document entry in file report.Its In, file report is stored in the off-shore transaction information report in background server, may include the file entries that can report and submit and File entries to be adjusted.
Above-mentioned data calibration device verifies the file entries of file destination, before reporting and submitting file report in school It tests by can just save later and be that can report and submit by the status modifier of file entries corresponding in file report, to guarantee file The accuracy of data in report, further, because verification is carried out by background server, headend equipment does not need interior Verification rule is set, therefore, can be only with a set of verification rule, can be with effectively save system development and maintenance cost, and make It obtains business personnel to verify without toggling between front and back, so as to reduce the workload of business personnel, ensure that The timeliness of verification;Meanwhile more accurate stringent verification can be carried out in background server, and then improve the accurate of verification Property.
Further, document processing module 508 is also used to verify unsanctioned file entries and verification does not pass through original Because being sent to headend equipment.In this way, business personnel can be according to verification when being adjusted to the unsanctioned file entries of verification It is not adjusted by reason, so that adjusting file entries, more efficiently targetedly more so as to improve data check Efficiency.
When reporting and submitting above-mentioned data calibration device applied to bank card off-shore transaction information, in order to avoid reporting and submitting outer tube Error information is received after office, allows the interaction between bank and the Administration of Foreign Exchange to become succinct efficient, institute can be ensured before reporting and submitting The state for having the All Files entry in file report is that can report and submit.Therefore, in some embodiments of the present application, above-mentioned number It can also include report sending module according to method of calibration, report sending module is specifically used for: determining in file report whether own The state of file entries is all that can report and submit;It, will be literary and in the case where determining the state of All Files entry is all that can report and submit Part report is sent.
Specifically, background server will verify the file entries passed through before file report is reported and submitted the Administration of Foreign Exchange Status modifier in file report is that after can reporting and submitting, institute in All Files report can be determined whether by report sending module The state for having file entries is all that can report and submit, in the case where determining the state of All Files entry is all that can report and submit, report hair Module is sent to send file report.In this way, ensuring the All Files in All Files report after the completion of each verification The state of entry is that in the case where can reporting and submitting, file report is sent, and can be received to avoid after reporting and submitting the Administration of Foreign Exchange Error information allows the interaction between bank and the Administration of Foreign Exchange to become succinct efficient, guarantees the accuracy of the timeliness reported and submitted and data.
It is understood that after determining that the state of All Files entry is that can report and submit, report sending module can be with Directly Administration of Foreign Exchange's management system, the file report that report sending module can also will be adjusted are sent by the file report adjusted Table is sent to headend equipment, and headend equipment sends it to Administration of Foreign Exchange's management system again, and the application is not construed as limiting this.
As previously mentioned, the state of the file entries in file report is that can report and submit or can adjust, in file destination File entries update respective file entry and its state in file report after being verified.It, can be true before being verified Determine the state of All Files entry in file report and generates file destination.In some embodiments of the present application, data check Device can also include file generating module, and file generating module is specifically used for: obtain original document from data warehouse;To original File is pre-processed, to generate file report;According to preset verification rule to the file entries in file report one by one into Row verification, and the state that the file entries passed through are verified in file report is set to and can be reported and submitted, do not lead to being verified in file report The state for the file entries crossed is set to be adjusted;And unsanctioned file entries will be verified as file destination.
Specifically, file generating module can obtain original document from Data Warehouse In Bank, and original document refers to data bins The source data of the bank card off-shore transaction information stored in library.In the present embodiment, bank card off-shore transaction information may include but The credit card off-shore transaction information and debit card off-shore transaction information being not limited in proxima luce (prox. luc) 24 hours.In order to subsequent by bank card Off-shore transaction information is reported and submitted, and file generating module can pre-process the source data in the original document of acquisition, with Generate file report.Specifically, rule is processed according to the screening that business personnel provides, one by one by the file entries in original document It is screened and is processed according to Administration of Foreign Exchange's statement form, data item needed for determining data area and processing every Transaction Information is raw It is stored in background data base at file report, and by the file report of generation.For example, transaction amount is more than by Administration of Foreign Exchange's requirement 1000 yuan of transaction is reported and submitted, thus can be pre-processed to source data.After verification, file generating module can root The All Files entry in file report is verified one by one according to preset verification rule, verification in file report is passed through The state of file entries, which is set to, to report and submit, and the state that unsanctioned file entries are verified in file report is set to be adjusted.And And further, for verifying unsanctioned file entries in file report, specific verification is recorded not by reason, for industry Business personnel are subsequent not to be adjusted correspondingly or is modified by reason according to verification.Specifically, in order to improve transmission rate, file Generation module can will verify unsanctioned file entries as file destination, so as to subsequently through background service in file report Device will be sent to headend equipment.Thus it is possible, on the one hand, it is not necessary that entire file report is transmitted back and forth between front and back;Another party Face, headend equipment show the file entries in file destination to business personnel, and business personnel is not necessarily to screen file entries to be adjusted, Directly the All Files entry in file destination is adjusted.It is understood that in the case where not considering transmission rate, File generating module can also be using the All Files entry in file report as file destination.
Further, in above-mentioned data verification method, the target adjusted of background server receiving front-end equipment return File, in order to improve verification speed and save memory space, in some embodiments of the present application, data calibration device may be used also To include file storage module, file storage module is specifically used for: file destination adjusted is stored in background data base In interim table.
Specifically, after the file destination adjusted that background server receives headend equipment return, file storage File destination adjusted is stored in the interim table of background data base by module.In the present embodiment, the interim table of database rises To the effect of an interim storing data, after verification terminates, interim table is released, and can save memory space, Er Qielin When table service speed than very fast, data check speed can be improved.
In some embodiments of the present application, preset verification rule may include field verification rule and interfield verification Rule.Further, interfield verification rule may include the interfield verification rule in same file destination or file report Interfield between different target file or file report verifies rule.
Specifically, developer can use Database verification regulation parameter table, and bank card off-shore transaction is reported and submitted The verification rule of each field or interfield all configures, and encloses the description of every verification rule.When being verified, adjust With verification function, verification function reads configured verification rule and is verified, if meeting verification rule, its state is set to It can report and submit, otherwise be reported and submitted state to be set to be adjusted, and record verification and do not pass through reason.By setting field verify rule and Interfield verification rule, can in same file report field and interfield verify, but also may be implemented more Between a file report across across the field verification of table, be enable to carry out more accurate and stringent verification.For across table Across field verification may be relevant between each report due to being stored with multiple reports in database, carries out in background server When verification, using preset verification rule and associated report, realize with can be convenient across across the field verification of table.
Under normal circumstances, background server obtains original document and the progress of bank card off-shore transaction information from data warehouse 36 file reports are generated after pretreatment, it is relevant between certain file reports, to the Transaction Information in a file report When being verified, it can call across rule is verified between literary name section, to realize across being verified between literary name section.For example, business personnel's tune When whole D05_2 table, when (" other side is the throwing overseas of mechanism to the D0504=1 of D05-2 table for " relationship of other side and mechanism " selection Money person ") when, Z03 table must make a report on corresponding shareholder's information, if that without corresponding information, when verification will not in Z03 table Back-checking does not pass through reason, and reminding business personnel make a report on corresponding shareholder's information in Z03 table.By using across between literary name section Verification, can allow business personnel efficiently accurately to adjust file entries to be adjusted, to improve the efficiency of verification and accurate Property.
It can be seen from the above description that the embodiment of the present application realizes following technical effect: reporting and submitting file report Before, the file entries of file destination are verified, can be just saved and will be corresponding in file report after in verification The status modifier of file entries is that can report and submit, to guarantee the accuracy of data in file report, further, because verification is all It is to be carried out by background server, headend equipment does not need built-in verification rule, therefore, can advise only with a set of verification Then, can be with effectively save system development and maintenance cost, and make business personnel without toggling progress between front and back Verification, so as to reduce the workload of business personnel, ensure that the timeliness of verification;Meanwhile background server can be into The more accurate stringent verification of row, and then improve the accuracy of verification.
Embodiment further provides a kind of computer equipments by the application, specifically can be based on the application refering to shown in fig. 6 The computer equipment composed structure schematic diagram for the data verification method that embodiment provides, the computer equipment can specifically include Input equipment 61, processor 62, memory 63.63 storage processor executable instruction of memory, processor 62 execute it is above-mentioned can The step of method described in above-mentioned any embodiment is realized when executing instruction.Wherein, the input equipment 61 specifically can be used for The description of input validation parameter of regularity and every verification rule.The processor 62 specifically can be used for according to preset verification Rule verifies the file entries in file destination adjusted, in the file entries overlay file report that verification is passed through Corresponding file entries storage, and will verify status modifier of the file entries passed through in file report is that can report and submit.It is described Memory 63 specifically can be also used for the data such as storage file report and verification regulation parameter table.
In the present embodiment, the input equipment, which specifically can be, carries out information exchange between user and computer system One of main device.The input equipment may include keyboard, mouse, camera, scanner, light pen, writing input board, language Sound input unit etc.;Input equipment is used to initial data be input in computer with the programs for handling these numbers.The input Equipment, which can also obtain, receives the data that other modules, unit, equipment transmit.The processor can be by any appropriate Mode is realized.For example, processor can take such as microprocessor or processor and storage that can be executed by (micro-) processor Computer readable program code (such as software or firmware) computer-readable medium, logic gate, switch, specific integrated circuit (Application Specific Integrated Circuit, ASIC), programmable logic controller (PLC) and insertion microcontroller Form etc..The storage implement body can be in modern information technologies for protecting stored memory device.The storage Device may include many levels, in digital display circuit, as long as can save binary data can be memory;In integrated electricity The circuit with store function of Lu Zhong, a not no physical form are also memory, such as RAM, FIFO;In systems, have There is the storage equipment of physical form to be also memory, such as memory bar, TF card.
In the present embodiment, the function and effect of computer equipment specific implementation, can be with other embodiment pair According to explanation, details are not described herein.
A kind of computer storage medium based on data verification method, the calculating are additionally provided in the application embodiment Machine storage medium is stored with computer program instructions, is performed in the computer program instructions and realizes above-mentioned any embodiment Described in data verification method the step of.
In the present embodiment, above-mentioned storage medium includes but is not limited to random access memory (Random Access Memory, RAM), read-only memory (Read-Only Memory, ROM), caching (Cache), hard disk (Hard Disk Drive, HDD) or storage card (Memory Card).The memory can be used for storing computer program instructions.Network is logical Letter unit can be according to standard setting as defined in communication protocol, for carrying out the interface of network connection communication.
In the present embodiment, the function and effect of the program instruction specific implementation of computer storage medium storage, can To compare explanation with other embodiment, details are not described herein.
Obviously, those skilled in the art should be understood that each module of above-mentioned the embodiment of the present application or each step can be with It is realized with general computing device, they can be concentrated on a single computing device, or be distributed in multiple computing devices On composed network, optionally, they can be realized with the program code that computing device can perform, it is thus possible to by it Store and be performed by computing device in the storage device, and in some cases, can be held with the sequence for being different from herein The shown or described step of row, perhaps they are fabricated to each integrated circuit modules or will be multiple in them Module or step are fabricated to single integrated circuit module to realize.In this way, the embodiment of the present application be not limited to it is any specific hard Part and software combine.
It should be understood that above description is to illustrate rather than to be limited.By reading above-mentioned retouch It states, many embodiments and many applications except provided example all will be aobvious and easy for a person skilled in the art See.Therefore, scope of the present application should not be determined referring to foregoing description, but should referring to preceding claims and this The full scope of the equivalent that a little claims are possessed determines.
The foregoing is merely preferred embodiment of the present application, are not intended to limit this application, for the skill of this field For art personnel, the embodiment of the present application can have various modifications and variations.Within the spirit and principles of this application, made Any modification, equivalent substitution, improvement and etc. should be included within the scope of protection of this application.

Claims (10)

1. a kind of data verification method, which is characterized in that the described method includes:
End equipment sends file destination to background server forward, wherein the file destination includes file entries to be adjusted;
The background server receives the file destination adjusted that the headend equipment returns;
The background server carries out school to the file entries in the file destination adjusted according to preset verification rule It tests;
Corresponding file entries store in the file entries overlay file report that the background server passes through verification, and high-ranking officers Test by status modifier of the file entries in the file report be that can report and submit.
2. the method according to claim 1, wherein right according to preset verification rule in the background server After file entries in the file destination adjusted are verified, further includes:
The background server will verify unsanctioned file entries and verification is not sent to the headend equipment by reason.
3. the method according to claim 1, wherein the file entries passed through will be verified in the file report In status modifier be can report and submit after, the method also includes:
The background server determines whether the state of All Files entry is all that can report and submit in the file report;
In the case where determining the state of All Files entry is all that can report and submit, the background server sends out the file report It sees off.
4. the method according to claim 1, wherein in the background server, end equipment sends target text forward Before part, the method also includes:
The background server obtains original document from data warehouse;
The background server pre-processes the original document, to generate file report;
The background server verifies the file entries in file report according to the preset verification rule one by one, and The state that the file entries passed through are verified in file report, which is set to, to report and submit, and unsanctioned file item will be verified in file report Purpose state is set to be adjusted;
Unsanctioned file entries will be verified as the file destination.
5. being returned the method according to claim 1, wherein receiving the headend equipment in the background server File destination adjusted after, the method also includes:
The file destination adjusted is stored in the interim table of background data base by the background server.
6. the method according to any one of claims 1 to 5, which is characterized in that the preset verification rule includes word Section verification rule and interfield verification rule.
7. a kind of data calibration device, which is characterized in that be located in background server, comprising:
File sending module sends file destination for end equipment forward, wherein the file destination includes file item to be adjusted Mesh;
File reception module, the file destination adjusted returned for receiving the headend equipment;
File verification module, for being carried out according to preset verification rule to the file entries in the file destination adjusted Verification;
Document processing module, for corresponding file entries storage in the file entries overlay file report passed through will to be verified, and It is that can report and submit that status modifier of the file entries passed through in the file report, which will be verified,.
8. device according to claim 7, which is characterized in that described device further includes report sending module, the report Sending module is specifically used for:
Determine whether the state of All Files entry is all that can report and submit in the file report;
In the case where determining the state of All Files entry is all that can report and submit, the file report is sent.
9. a kind of computer equipment, including processor and for the memory of storage processor executable instruction, the processing The step of device realizes any one of claims 1 to 6 the method when executing described instruction.
10. a kind of computer readable storage medium is stored thereon with computer instruction, described instruction, which is performed, realizes that right is wanted The step of seeking any one of 1 to 6 the method.
CN201910107168.5A 2019-02-02 2019-02-02 Data verification method, device, computer equipment and storage medium Pending CN109918403A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910107168.5A CN109918403A (en) 2019-02-02 2019-02-02 Data verification method, device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910107168.5A CN109918403A (en) 2019-02-02 2019-02-02 Data verification method, device, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
CN109918403A true CN109918403A (en) 2019-06-21

Family

ID=66961432

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910107168.5A Pending CN109918403A (en) 2019-02-02 2019-02-02 Data verification method, device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN109918403A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110795441A (en) * 2019-09-18 2020-02-14 平安科技(深圳)有限公司 Report data processing method, device, equipment and storage medium
CN111782718A (en) * 2020-08-11 2020-10-16 支付宝(杭州)信息技术有限公司 Plug-in data reporting system and data reporting method
CN112183039A (en) * 2020-09-16 2021-01-05 支付宝(杭州)信息技术有限公司 Compliance verification method and device for business report
CN112632174A (en) * 2020-12-31 2021-04-09 江苏苏宁云计算有限公司 Data inspection method, device and system
CN112860773A (en) * 2019-11-28 2021-05-28 联易软件有限公司 Data transmission method and device

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100094748A1 (en) * 2008-10-14 2010-04-15 Granite Loan Management Of Delaware, Llc Adjustable risk mitigation system and process for managing a construction loan
CN102426549A (en) * 2011-09-08 2012-04-25 新一站保险代理有限公司 Efficient Web form validation method and framework thereof
CN104468648A (en) * 2013-09-13 2015-03-25 腾讯科技(深圳)有限公司 Data processing system and method
CN105824713A (en) * 2016-03-10 2016-08-03 中国银行股份有限公司 Data checking method and device
CN108809896A (en) * 2017-04-28 2018-11-13 阿里巴巴集团控股有限公司 A kind of information calibration method, device and electronic equipment

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100094748A1 (en) * 2008-10-14 2010-04-15 Granite Loan Management Of Delaware, Llc Adjustable risk mitigation system and process for managing a construction loan
CN102426549A (en) * 2011-09-08 2012-04-25 新一站保险代理有限公司 Efficient Web form validation method and framework thereof
CN104468648A (en) * 2013-09-13 2015-03-25 腾讯科技(深圳)有限公司 Data processing system and method
CN105824713A (en) * 2016-03-10 2016-08-03 中国银行股份有限公司 Data checking method and device
CN108809896A (en) * 2017-04-28 2018-11-13 阿里巴巴集团控股有限公司 A kind of information calibration method, device and electronic equipment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
陈永成等: "《分布式档案基础数据库建设理论与实践》", 31 May 2006 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110795441A (en) * 2019-09-18 2020-02-14 平安科技(深圳)有限公司 Report data processing method, device, equipment and storage medium
CN110795441B (en) * 2019-09-18 2023-06-16 平安科技(深圳)有限公司 Report data processing method, device, equipment and storage medium
CN112860773A (en) * 2019-11-28 2021-05-28 联易软件有限公司 Data transmission method and device
CN111782718A (en) * 2020-08-11 2020-10-16 支付宝(杭州)信息技术有限公司 Plug-in data reporting system and data reporting method
CN111782718B (en) * 2020-08-11 2023-12-29 支付宝(杭州)信息技术有限公司 Plug-in data reporting system and data reporting method
CN112183039A (en) * 2020-09-16 2021-01-05 支付宝(杭州)信息技术有限公司 Compliance verification method and device for business report
CN112183039B (en) * 2020-09-16 2024-04-19 支付宝(杭州)信息技术有限公司 Compliance verification method and device for business report
CN112632174A (en) * 2020-12-31 2021-04-09 江苏苏宁云计算有限公司 Data inspection method, device and system

Similar Documents

Publication Publication Date Title
CN109918403A (en) Data verification method, device, computer equipment and storage medium
CN109614100B (en) Page display method, device, server, front end and storage medium
CN102426549B (en) Efficient Web form validation method and framework thereof
US20130159832A1 (en) Systems and methods for trading using an embedded spreadsheet engine and user interface
CN110851253B (en) Remote operation and maintenance method, system, storage medium and electronic equipment
CN103238150A (en) Realtime synchronized document editing by multiple users for blogging
CN110930157B (en) Delayed transaction processing method, device and storage medium
US11630821B2 (en) Blockchain-based data processing method and apparatus, device, and medium
CN104778616A (en) System and method for inputting invoice information quickly
CN109492985A (en) A kind of checking method, apparatus and system
CN113614699A (en) Aggregate analysis and remediation of data failures
CN110490559A (en) A kind of mobile law enforcement inspection method, device, system and server
CN113222724A (en) Bill processing method and device
CN108898468A (en) Information asynchronous processing method, device, computer equipment and storage medium
CN111127224B (en) Information processing method, information processing device, electronic equipment and storage medium
US20230385806A1 (en) Methods and systems for temporary voucher sharing
US20170134389A1 (en) Third Party Paywall Authentication System
CN107291906B (en) Data processing method and system for map interface
CN109522211B (en) Interface parameter transmission method and device, electronic equipment and storage medium
CN108376128B (en) A kind of processing method and system of communication message
WO2021073264A1 (en) Negotiable instrument information acquisition method and device, computer apparatus, and readable storage medium
CN112181817A (en) Test method and test device for SOA (service oriented architecture) platform
CN110322291A (en) Advertisement sending method and equipment
CN109657179A (en) A kind of method for processing business, system and storage medium
KR101905284B1 (en) Authentication processing system and authentication processing server

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20190621

RJ01 Rejection of invention patent application after publication