CN108416580A - Account checking method, account checking apparatus and electronic equipment - Google Patents
Account checking method, account checking apparatus and electronic equipment Download PDFInfo
- Publication number
- CN108416580A CN108416580A CN201810197975.6A CN201810197975A CN108416580A CN 108416580 A CN108416580 A CN 108416580A CN 201810197975 A CN201810197975 A CN 201810197975A CN 108416580 A CN108416580 A CN 108416580A
- Authority
- CN
- China
- Prior art keywords
- bill
- party
- billing
- trade company
- data
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/085—Payment architectures involving remote charge determination or related payment systems
- G06Q20/0855—Payment architectures involving remote charge determination or related payment systems involving a third party
-
- 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/102—Bill distribution or payments
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of account checking method, account checking apparatus and electronic equipments, are related to technical field of data processing, which includes the billing files for obtaining Third-party payment;Billing files batch is imported third party's bill table by the data volume for verifying the billing files when the data volume is less than predetermined threshold value using jdbc batch systems;The trade company's bill coding for waiting for reconciliation is obtained from third party's bill table;According to the trade company, bill coding obtains all and trade company's bill and encodes relevant third party's billing data and system billing data;Above-mentioned third party's billing data and system billing data are matched, and matching result is updated to third party's bill table and own system bill table.The embodiment of the present invention is designed to provide a kind of account checking method, account checking apparatus and electronic equipment, can improve the speed of third party's billing files import system, and improves the efficiency that third party's bill carries out reconciliation with trade order in own system.
Description
Technical field
The present invention relates to technical field of data processing, more particularly, to a kind of account checking method, account checking apparatus and electronic equipment.
Background technology
With the arrival in electronic information epoch, the transaction completed by internet is growing day by day, present most of investment goods
Kind can merchandise on the internet.Network trading refer to and be happened in information network between enterprise (Business to Business,
Abbreviation B2B), between business and consumer between (Business to Consumer, abbreviation B2C) and personal and individual
(Consumer to Consumer, abbreviation C2C) is concluded by network communications approach to merchandise.It is usually used in network trading
The mode of Third-party payment is paid.Third-party payment refers to the independent agency for having certain strength and prestige guarantee, is used
The mode contracted with each big bank, the net for facilitating both parties to be traded by being docked with bank payment settlement system interface
Network payment mode.Common Third-party payment mode includes Alipay, wechat, buy gold, wealth pays logical, Unionpay's payment etc..
With the development of smart mobile phone, in app it is most be all integrated with the Third-party payments such as Alipay, wechat, Unionpay with into
Row network trading, user is more using the number that app is traded, and the trade order of generation is more, this will give is to backstage
Bill derived from the trade order generated and third party of uniting carries out reconciliation processing and brings prodigious pressure.Currently, because of network trading
The increase of amount, third party transaction billing files are often larger, and speed is slower when by billing files import system, carry out at reconciliation
The efficiency of reason is also therefore relatively low.
Invention content
In view of this, the purpose of the present invention is to provide a kind of account checking method, account checking apparatus and electronic equipment, to improve
The speed of tripartite's billing files import system improves the efficiency that third party's bill carries out reconciliation with trade order in own system.
In a first aspect, an embodiment of the present invention provides a kind of account checking methods, including:Obtain the bill text of Third-party payment
Part;The data volume for verifying the billing files, when the data volume is less than predetermined threshold value, using jdbc batch systems by the bill
Files in batch imports third party's bill table;The trade company's bill coding for waiting for reconciliation is obtained from third party's bill table;According to trade company's account
Single coding obtains all and trade company's bill from third party's bill table and encodes relevant third party's billing data, and according to the trade company
Bill coding obtains all and trade company's bill from own system bill table and encodes relevant system billing data;Match above-mentioned
Tripartite's billing data and system billing data, and matching result is updated to third party's bill table and own system bill table.
With reference to first aspect, an embodiment of the present invention provides the first possible embodiments of first aspect, wherein on
Stating account checking method further includes:When the data volume is more than predetermined threshold value, prompt to reacquire billing files.
With reference to first aspect, an embodiment of the present invention provides second of possible embodiments of first aspect, wherein on
It states and all and relevant system bill number of trade company's bill coding is obtained from own system bill table according to trade company's bill coding
According to the step of include:According to the trade company, bill coding paging query is had by oneself relevant with trade company's bill coding in system bill table
System billing data;It obtains all and trade company's bill and encodes relevant system billing data.
With reference to first aspect, an embodiment of the present invention provides the third possible embodiments of first aspect, wherein on
Matching third party's billing data and system billing data are stated, and matching result is updated to third party's bill table and own system account
The step of single table includes:It matches third party's billing data and the bill of system billing data encodes;When the bill codes match at
When work(, the billing amount under bill coding is matched;Matching result is updated by jdbc batch systems to above-mentioned third party
Bill table and above-mentioned own system bill table.
With reference to first aspect, an embodiment of the present invention provides the 4th kind of possible embodiments of first aspect, wherein on
It states to update matching result to third party's bill table and the step of own system bill table and includes:By third party's bill table and have by oneself
The bill code identification of successful match is successful match in system bill table.
With reference to first aspect, an embodiment of the present invention provides the 5th kind of possible embodiments of first aspect, wherein
Further include before the step of data volume of the above-mentioned verification billing files:The billing files are parsed, and obtain the billing files
Data volume.
With reference to first aspect, an embodiment of the present invention provides the 6th kind of possible embodiments of first aspect, wherein
Further include after above-mentioned the step of billing files batch is imported third party's bill table using jdbc batch systems:Create the
The index of tripartite's bill table, and generate the batch code of import operation;When inquiry is when the trade company bill of reconciliation coding, according to above-mentioned
Index and above-mentioned batch code inquire third party's bill table, and the trade company's bill coding for waiting for reconciliation is obtained from third party's bill table.
Second aspect, the embodiment of the present invention additionally provide a kind of account checking apparatus, including:Billing files acquisition module, is used for
Obtain the billing files of Third-party payment;Correction verification module, the data volume for verifying above-mentioned billing files, when the data volume is less than
When predetermined threshold value, billing files batch is imported into third party's bill table;Bill encodes acquisition module, is used for from third party's bill
Table obtains the trade company's bill coding for waiting for reconciliation;Billing data acquisition module, for being encoded from third party's bill according to trade company's bill
Table obtains all and trade company's bill and encodes relevant third party's billing data, and is encoded from own system according to trade company's bill
Bill table obtains all and trade company's bill and encodes relevant system billing data;Matching module, for matching above-mentioned third party
Billing data and above system billing data, and matching result is updated to third party's bill table and own system bill table.
The third aspect, the embodiment of the present invention additionally provide a kind of account checking apparatus, which includes processor, memory, always
Line and communication interface, processor, communication interface and memory are connected by bus;The memory is for storing program;The processing
Device executes above-mentioned first aspect and its possible embodiment party for calling the program being stored in the memory by the bus
The method that one of formula provides.
Fourth aspect, the embodiment of the present invention additionally provide a kind of electronic equipment, including memory, processor, the memory
In be stored with the computer program that can be run on the processor, which realizes above-mentioned first when executing the computer program
The step of method that one of aspect and its possible embodiment provide.
The embodiment of the present invention brings following advantageous effect:
Account checking method, account checking apparatus and electronic equipment provided in an embodiment of the present invention, the account checking method include obtaining third
The billing files of Fang Zhifu;The data volume for verifying the billing files, when the data volume is less than predetermined threshold value, at jdbc batches
Billing files batch is imported third party's bill table by reason technology;It is obtained from third party's bill table and waits for that trade company's bill of reconciliation is compiled
Code;All and trade company's bill is obtained from third party's bill table encode relevant third party's bill number according to trade company's bill coding
According to, and all and trade company's bill is obtained from own system bill table according to trade company's bill coding and encodes relevant system bill
Data;Third party's billing data and the system billing data are matched, and by matching result update to third party's bill table and certainly
There is system bill table;By the optimization handled reconciliation, and set jdbc batch techniques, improve the importing of third party's billing files
The speed of system improves the efficiency that third party's bill carries out reconciliation with trade order in own system.
Other feature and advantage of the disclosure will illustrate in the following description, alternatively, Partial Feature and advantage can be with
Deduce from specification or unambiguously determine, or by implement the disclosure above-mentioned technology it can be learnt that.
To enable the above objects, features, and advantages of the disclosure to be clearer and more comprehensible, preferred embodiment cited below particularly, and coordinate
Appended attached drawing, is described in detail below.
Description of the drawings
It, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical solution in the prior art
Embodiment or attached drawing needed to be used in the description of the prior art are briefly described, it should be apparent that, in being described below
Attached drawing is some embodiments of the present invention, for those of ordinary skill in the art, before not making the creative labor
It puts, other drawings may also be obtained based on these drawings.
Fig. 1 is a kind of flow chart of account checking method provided in an embodiment of the present invention;
Fig. 2 is the flow chart of another account checking method provided in an embodiment of the present invention;
Fig. 3 is a kind of structural schematic diagram of account checking apparatus provided in an embodiment of the present invention;
Fig. 4 is the structural schematic diagram of another account checking apparatus provided in an embodiment of the present invention.
Icon:
31- billing files acquisition modules;32- correction verification modules;33- bills encode acquisition module;34- billing datas obtain mould
Block;35- matching modules;40- processors;41- memories;42- buses;43- communication interfaces.
Specific implementation mode
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with attached drawing to the present invention
Technical solution be clearly and completely described, it is clear that described embodiments are some of the embodiments of the present invention, rather than
Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise
Lower obtained every other embodiment, shall fall within the protection scope of the present invention.
Currently, increasing sharply due to network trading amount, third party transaction billing files are often larger, and trade company is by third
Speed is slower when square payment bill file import system, and the efficiency for carrying out reconciliation processing is relatively low.Based on this, the embodiment of the present invention
A kind of account checking method, account checking apparatus and the electronic equipment provided, can improve the speed of third party's billing files import system, and
Improve the efficiency that third party's bill carries out reconciliation with trade order in own system.
For ease of understanding the present embodiment, a kind of account checking method disclosed in the embodiment of the present invention is carried out first detailed
It is thin to introduce.
Embodiment one
As shown in Figure 1, being a kind of flow chart of account checking method provided in an embodiment of the present invention, as seen from Figure 1, the reconciliation side
The step of method includes:
Step S101:Obtain the billing files of Third-party payment.
Trade company can export the transaction bill within the scope of certain time from Third-party payment platform, such as:One week or one month
Transaction bill.In general, the transaction bill is the file of CSV (Comma-Separated Values, comma separated value) format.
CSV is a kind of general, relatively simple file format, by user, business and science extensive use, wherein widest application
It is to shift list data between programs, and these programs itself are operated on incompatible format.
By the billing files of the Third-party payment of acquisition by from systematic backstage upload to server, after being ready for use on
Continuous operation.
Step S102:The data volume for verifying the billing files, when the data volume is less than predetermined threshold value, at jdbc batches
Billing files batch is imported third party's bill table by reason technology.
Here, the billing files of Third-party payment are parsed by CSV tool-class first, and obtains the billing files
Data volume.In practical operation, file data amount cross conference cause in subsequent processing to database generate pressure, and therefore and
The performance for reducing database, causes treatment effeciency to reduce.In order to avoid such case, trade company can be according to the needs of actual conditions
Preset threshold value, such as 50000, before billing files are imported third party's bill table, first to the number of the billing files
It is verified according to amount, when the data volume of billing files is less than the predetermined threshold value, executes import operation.Otherwise, prompt user weight
It is new to obtain billing files, at this point, user can reduce the data volume by the time range of reduction transaction bill.
In wherein one or more possible embodiments, jdbc (Java Data Base may be used
Connectivity, java database connect) the progress batch importing of batch system reconciliation monofile.JDBC is a kind of for holding
The Java API of row SQL statement can provide unified access for a variety of relational databases, what it was write by one group with Java language
Class and interface composition.JDBC provides a kind of benchmark, can build more advanced tool and interface accordingly, make database development people
Member can write database application.
Step S103:The trade company's bill coding for waiting for reconciliation is obtained from above-mentioned third party's bill table.
If third party's bill table of this importing is directly used in reconciliation, then can directly be obtained from third party's bill table
Wait for trade company's bill coding of reconciliation.If needing to obtain trade company's bill coding in the third party's bill table having been introduced into before,
Then need to inquire third party's bill table of needs in the database.In at least one embodiment, third party's bill is literary
Part batch imports after third party's bill table, needs to carry out respective handling to importing batch and the bill table to facilitate subsequent query
Retrieval.As shown in Fig. 2, the step of providing the processing procedure, including:Step S201 creates the index of third party's bill table, and
Generate the batch code of import operation;Step S202, when inquiry is when the trade company bill of reconciliation coding, according to the index and the batch
Code inquiry third party's bill table, and the trade company's bill coding for waiting for reconciliation is obtained from third party's bill table.Index and batch code
It creates and is conducive to improve the subsequently search efficiency to having stored third party's bill table.
Step S104:All and trade company's bill is obtained according to trade company's bill coding from above-mentioned third party's bill table to encode
Relevant third party's billing data, and all and trade company's bill is obtained from own system bill table according to trade company's bill coding
Encode relevant system billing data.
It utilizes and corresponding third party's bill detailed data is obtained from third party's bill table with the trade company's bill coding obtained.This
In, because the case where encoding corresponding a plurality of transaction journal there are same trade company's bill, such as:Consumption+reimbursement, pre-authorization+pre-
Completion, pre-authorization+pre-authorization revocation etc. are authorized, primary complete transaction flow is constituted by more transaction flowing water.In addition, more friendships
Easy flowing water also not necessarily exists in third party's billing files of the same importing, and therefore, it is necessary to be obtained by trade company's bill coding
Take third party's billing data of all importings.Similarly, according to trade company's bill coding from the payment bill table that own system generates
Obtain all system billing datas.
Here, when data volume is bigger, in order to avoid data base querying time-out, system bill can be had by oneself with paging query
Relevant system billing data is encoded with trade company's bill in table, all and trade company's bill is then obtained again and encodes relevant system
System billing data.
Step S105:Third party's billing data and the system billing data are matched, and matching result is updated to above-mentioned
Third party's bill table and above-mentioned own system bill table.
First, matching third party's billing data and the bill of system billing data encode;Secondly, when bill codes match at
When work(, the billing amount under bill coding is matched;Then, after the completion of matching, matching result is passed through into jdbc batch processing skills
Art is updated to third party's bill table and own system bill table.In at least one possible embodiment, matching result is more
It is successful match that new paragon, which can be by the bill code identification of successful match in third party's bill table and own system bill table,.
Finally, trade company according to embodied in reconciliation result more accounts, short account, the amount of money is inconsistent situations such as be further processed.
Account checking method provided in an embodiment of the present invention, by the optimization handled reconciliation, and set jdbc batch techniques, it carries
The high speed of third party's billing files import system, improves third party's bill and carries out reconciliation with trade order in own system
Efficiency.
Embodiment two
The embodiment of the present invention additionally provides a kind of account checking apparatus, as shown in figure 3, right for one kind provided in an embodiment of the present invention
The structural schematic diagram of account device, as seen from Figure 3, the account checking apparatus include the billing files acquisition module 31 being sequentially connected, verification
Module 32, bill coding acquisition module 33, billing data acquisition module 34 and matching module 35, wherein the work(of modules
It can be as follows:
Billing files acquisition module 31, the billing files for obtaining Third-party payment.
Correction verification module 32, the data volume for verifying above-mentioned billing files, when the data volume is less than predetermined threshold value, by this
Billing files batch imports third party's bill table.
Bill encodes acquisition module 33, for obtaining the trade company's bill coding for waiting for reconciliation from third party's bill table.
Billing data acquisition module 34, for obtaining all and trade company from third party's bill table according to trade company's bill coding
Bill encodes relevant third party's billing data, and obtains all from own system bill table according to trade company's bill coding and be somebody's turn to do
Trade company's bill encodes relevant system billing data.
Matching module 35, for matching above-mentioned third party's billing data and above system billing data, and by matching result
Update third party's bill table and own system bill table.
The technique effect and preceding method embodiment phase of the device that the embodiment of the present invention is provided, realization principle and generation
Together, to briefly describe, device embodiment part does not refer to place, can refer to corresponding contents in preceding method embodiment.
Embodiment three
Referring to Fig. 4, the embodiment of the present invention also provides a kind of account checking apparatus, including:Processor 40, memory 41, bus 42
With communication interface 43, processor 40, communication interface 43 and memory 41 are connected by bus 42;Processor 40 is for executing storage
The executable module stored in device 41, such as computer program.
Wherein, memory 41 may include high-speed random access memory (RAM, Random Access Memory),
May further include nonvolatile memory (Non-volatile Memory), for example, at least a magnetic disk storage.By at least
One communication interface 43 (can be wired or wireless) realizes the communication between the system network element and at least one other network element
Connection can use internet, wide area network, local network, Metropolitan Area Network (MAN) etc..
Bus 42 can be isa bus, pci bus or eisa bus etc..It is total that bus can be divided into address bus, data
Line, controlling bus etc..For ease of indicating, only indicated with a four-headed arrow in Fig. 4, it is not intended that an only bus or one
The bus of type.
Wherein, memory 41 is for storing program, and processor 40 executes program after receiving and executing instruction, aforementioned
The method performed by device that the stream process that inventive embodiments any embodiment discloses defines can be applied in processor 40, or
Person is realized by processor 40.
Processor 40 may be a kind of IC chip, the processing capacity with signal.During realization, above-mentioned side
Each step of method can be completed by the integrated logic circuit of the hardware in processor 40 or the instruction of software form.Above-mentioned
Processor 40 can be general processor, including central processing unit (Central Processing Unit, abbreviation CPU), network
Processor (Network Processor, abbreviation NP) etc.;It can also be digital signal processor (Digital Signal
Processing, abbreviation DSP), application-specific integrated circuit (Application Specific Integrated Circuit, referred to as
ASIC), ready-made programmable gate array (Field-Programmable Gate Array, abbreviation FPGA) or other are programmable
Logical device, discrete gate or transistor logic, discrete hardware components.It may be implemented or execute in the embodiment of the present invention
Disclosed each method, step and logic diagram.General processor can be microprocessor or the processor can also be to appoint
What conventional processor etc..The step of method in conjunction with disclosed in the embodiment of the present invention, can be embodied directly in hardware decoding processing
Device executes completion, or in decoding processor hardware and software module combination execute completion.Software module can be located at
Machine memory, flash memory, read-only memory, programmable read only memory or electrically erasable programmable memory, register etc. are originally
In the storage medium of field maturation.The storage medium is located at memory 41, and processor 40 reads the information in memory 41, in conjunction with
Its hardware completes the step of above method.
Account checking apparatus provided in an embodiment of the present invention, the account checking method technology having the same provided with above-described embodiment one
Feature reaches identical technique effect so can also solve identical technical problem.
Example IV
The embodiment of the present invention additionally provides a kind of electronic equipment, including memory, processor, and being stored in the memory can
The computer program run on the processor, the processor realize above-described embodiment one and its can when executing the computer program
The step of method that one of embodiment of energy provides.
Unless specifically stated otherwise, the opposite step of the component and step that otherwise illustrate in these embodiments, digital table
It is not limit the scope of the invention up to formula and numerical value.
Flow chart and block diagram in attached drawing show the system, method and computer journey of multiple embodiments according to the present invention
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part for a part for one module, section or code of table, the module, section or code includes one or more uses
The executable instruction of the logic function as defined in realization.It should also be noted that in some implementations as replacements, being marked in box
The function of note can also occur in a different order than that indicated in the drawings.For example, two continuous boxes can essentially base
Originally it is performed in parallel, they can also be executed in the opposite order sometimes, this is depended on the functions involved.It is also noted that
It is the combination of each box in block diagram and or flow chart and the box in block diagram and or flow chart, can uses and execute rule
The dedicated hardware based system of fixed function or action is realized, or can use the group of specialized hardware and computer instruction
It closes to realize.
In addition, in the description of the embodiment of the present invention unless specifically defined or limited otherwise, term " installation ", " phase
Even ", " connection " shall be understood in a broad sense, for example, it may be being fixedly connected, may be a detachable connection, or be integrally connected;It can
Can also be electrical connection to be mechanical connection;It can be directly connected, can also indirectly connected through an intermediary, Ke Yishi
Connection inside two elements.For the ordinary skill in the art, above-mentioned term can be understood at this with concrete condition
Concrete meaning in invention.
In the description of the present invention, it should be noted that term "center", "upper", "lower", "left", "right", "vertical",
The orientation or positional relationship of the instructions such as "horizontal", "inner", "outside" be based on the orientation or positional relationship shown in the drawings, merely to
Convenient for the description present invention and simplify description, do not indicate or imply the indicated device or element must have a particular orientation,
With specific azimuth configuration and operation, therefore it is not considered as limiting the invention.In addition, term " first ", " second ",
" third " is used for description purposes only, and is not understood to indicate or imply relative importance.
Finally it should be noted that:Embodiment described above, only specific implementation mode of the invention, to illustrate the present invention
Technical solution, rather than its limitations, scope of protection of the present invention is not limited thereto, although with reference to the foregoing embodiments to this hair
It is bright to be described in detail, it will be understood by those of ordinary skill in the art that:Any one skilled in the art
In the technical scope disclosed by the present invention, it can still modify to the technical solution recorded in previous embodiment or can be light
It is readily conceivable that variation or equivalent replacement of some of the technical features;And these modifications, variation or replacement, do not make
The essence of corresponding technical solution is detached from the spirit and scope of technical solution of the embodiment of the present invention, should all cover the protection in the present invention
Within the scope of.Therefore, protection scope of the present invention should be based on the protection scope of the described claims.
Claims (10)
1. a kind of account checking method, which is characterized in that including:
Obtain the billing files of Third-party payment;
The data volume for verifying the billing files will using jdbc batch systems when the data volume is less than predetermined threshold value
The billing files batch imports third party's bill table;
The trade company's bill coding for waiting for reconciliation is obtained from third party's bill table;
According to trade company's bill coding all codings with trade company's bill relevant the are obtained from third party's bill table
Tripartite's billing data, and all and trade company's bill is obtained from own system bill table according to trade company's bill coding and is encoded
Relevant system billing data;
Third party's billing data and the system billing data are matched, and matching result is updated to third party's bill
Table and the own system bill table.
2. account checking method according to claim 1, which is characterized in that further include:
When the data volume is more than predetermined threshold value, prompt to reacquire the billing files.
3. account checking method according to claim 1, which is characterized in that described to be encoded from own system according to trade company's bill
System bill table obtains all includes the step of coding relevant system billing datas with trade company's bill:
It is encoded in the own system bill table of paging query according to trade company's bill and encodes relevant system with trade company's bill
Billing data;
It obtains all and trade company's bill and encodes relevant system billing data.
4. account checking method according to claim 1, which is characterized in that matching third party's billing data with it is described
System billing data, and matching result is updated to third party's bill table and the step of own system bill table and is wrapped
It includes:
The bill for matching third party's billing data and the system billing data encodes;
When bill codes match success, the billing amount under the bill coding is matched;
Matching result is updated by jdbc batch systems to third party's bill table and the own system bill table.
5. account checking method according to claim 1, which is characterized in that described by matching result update to third party's account
Single table includes with the step of own system bill table:
It is successful match by the bill code identification of successful match in third party's bill table and the own system bill table.
6. account checking method according to claim 1, which is characterized in that in the data volume for verifying the billing files
Further include before step:
The billing files are parsed, and obtain the data volume of the billing files.
7. account checking method according to claim 1, which is characterized in that use jdbc batch systems by the account described
Further include after the step of monofile batch imports third party's bill table:
The index of third party's bill table is created, and generates the batch code of import operation;
When inquiring when trade company's bill of reconciliation coding, third party's account is inquired according to the index and the batch code
Single table, and the trade company's bill coding for waiting for reconciliation is obtained from third party's bill table.
8. a kind of account checking apparatus, which is characterized in that including:
Billing files acquisition module, the billing files for obtaining Third-party payment;
Correction verification module, the data volume for verifying the billing files, when the data volume is less than predetermined threshold value, by the account
Monofile batch imports third party's bill table;
Bill encodes acquisition module, for obtaining the trade company's bill coding for waiting for reconciliation from third party's bill table;
Billing data acquisition module, for according to trade company's bill coding from third party's bill table obtain it is all with it is described
Trade company's bill encodes relevant third party's billing data, and obtains institute from own system bill table according to trade company's bill coding
Have and encodes relevant system billing data with trade company's bill;
Matching module is arrived for matching third party's billing data and the system billing data, and by matching result update
Third party's bill table and the own system bill table.
9. a kind of account checking apparatus, which is characterized in that described device includes processor, memory, bus and communication interface, the place
Reason device, communication interface are connected with memory by the bus;
The memory is for storing program;
The processor executes the claim for calling the program being stored in the memory by the bus
Any the methods of 1-7.
10. a kind of electronic equipment, including memory, processor, it is stored with and can runs on the processor in the memory
Computer program, which is characterized in that the processor realizes the claims 1 to 7 when executing the computer program
The step of method described in one.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810197975.6A CN108416580A (en) | 2018-03-09 | 2018-03-09 | Account checking method, account checking apparatus and electronic equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810197975.6A CN108416580A (en) | 2018-03-09 | 2018-03-09 | Account checking method, account checking apparatus and electronic equipment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108416580A true CN108416580A (en) | 2018-08-17 |
Family
ID=63130906
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810197975.6A Pending CN108416580A (en) | 2018-03-09 | 2018-03-09 | Account checking method, account checking apparatus and electronic equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108416580A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109711980A (en) * | 2018-12-27 | 2019-05-03 | 中国建设银行股份有限公司 | Reconciliation form processing method, device, storage medium and system |
CN109918385A (en) * | 2019-01-16 | 2019-06-21 | 深圳壹账通智能科技有限公司 | Tripartite's account checking method, electronic device and readable storage medium storing program for executing |
CN110544080A (en) * | 2019-07-03 | 2019-12-06 | 威富通科技有限公司 | payment reconciliation method and server |
CN110659965A (en) * | 2019-09-24 | 2020-01-07 | 北京腾赋网络科技有限公司 | Control method for automatically reflecting bill difference of takeout order |
CN112184463A (en) * | 2020-01-15 | 2021-01-05 | 广州海鹚网络科技有限公司 | Data processing method, device, equipment and storage medium for medical bills |
CN113076340A (en) * | 2021-03-22 | 2021-07-06 | 北京同邦卓益科技有限公司 | Accounting data processing method and device, electronic equipment and storage medium |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020082991A1 (en) * | 2000-12-27 | 2002-06-27 | Richard Friedman | Telecommunications cost management system |
CN101320458A (en) * | 2007-06-07 | 2008-12-10 | 阿里巴巴集团控股有限公司 | Method and system for completing bill checking of mass data |
CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
WO2013181838A1 (en) * | 2012-06-08 | 2013-12-12 | 成都三泰电子实业股份有限公司 | Bill imaging processing system |
CN104965873A (en) * | 2015-06-10 | 2015-10-07 | 努比亚技术有限公司 | Paging inquiring method and apparatus |
CN107169749A (en) * | 2017-04-01 | 2017-09-15 | 北京波若科技有限公司 | Network payment account checking method and system |
CN107368593A (en) * | 2017-07-25 | 2017-11-21 | 万帮充电设备有限公司 | Data lead-in method, device and server |
-
2018
- 2018-03-09 CN CN201810197975.6A patent/CN108416580A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020082991A1 (en) * | 2000-12-27 | 2002-06-27 | Richard Friedman | Telecommunications cost management system |
CN101320458A (en) * | 2007-06-07 | 2008-12-10 | 阿里巴巴集团控股有限公司 | Method and system for completing bill checking of mass data |
WO2013181838A1 (en) * | 2012-06-08 | 2013-12-12 | 成都三泰电子实业股份有限公司 | Bill imaging processing system |
CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
CN104965873A (en) * | 2015-06-10 | 2015-10-07 | 努比亚技术有限公司 | Paging inquiring method and apparatus |
CN107169749A (en) * | 2017-04-01 | 2017-09-15 | 北京波若科技有限公司 | Network payment account checking method and system |
CN107368593A (en) * | 2017-07-25 | 2017-11-21 | 万帮充电设备有限公司 | Data lead-in method, device and server |
Non-Patent Citations (1)
Title |
---|
李宁: "《Java Web编程实战宝典》", 31 December 2015 * |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109711980A (en) * | 2018-12-27 | 2019-05-03 | 中国建设银行股份有限公司 | Reconciliation form processing method, device, storage medium and system |
CN109918385A (en) * | 2019-01-16 | 2019-06-21 | 深圳壹账通智能科技有限公司 | Tripartite's account checking method, electronic device and readable storage medium storing program for executing |
CN110544080A (en) * | 2019-07-03 | 2019-12-06 | 威富通科技有限公司 | payment reconciliation method and server |
CN110659965A (en) * | 2019-09-24 | 2020-01-07 | 北京腾赋网络科技有限公司 | Control method for automatically reflecting bill difference of takeout order |
CN112184463A (en) * | 2020-01-15 | 2021-01-05 | 广州海鹚网络科技有限公司 | Data processing method, device, equipment and storage medium for medical bills |
CN113076340A (en) * | 2021-03-22 | 2021-07-06 | 北京同邦卓益科技有限公司 | Accounting data processing method and device, electronic equipment and storage medium |
CN113076340B (en) * | 2021-03-22 | 2024-01-16 | 北京同邦卓益科技有限公司 | Account data processing method and device, electronic equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108416580A (en) | Account checking method, account checking apparatus and electronic equipment | |
CN109615495B (en) | Data reconciliation method, device, equipment and system | |
CN103714625B (en) | A kind of charging intelligent card method and system | |
CN106327196A (en) | Payment threshold acquisition method and device | |
CN106201537A (en) | A kind of data processing method and device | |
CN110689417A (en) | Accounting system-based settlement method and system, storage medium and terminal | |
CN109598502A (en) | A kind of bus card settlement of transactions management system and its method | |
CN109544073B (en) | Method, device and equipment for managing customs clearance and storage medium | |
CN108615184A (en) | A kind of method and device of book keeping operation | |
CN103325032A (en) | Data processing method and device | |
CN109409933A (en) | Intelligent fee counting method, computer readable storage medium and terminal device | |
CN109241357A (en) | Chain structure model and its construction method, system and terminal device | |
CN107316245A (en) | Expense adjusts method and system | |
CN109472680A (en) | A kind of accounting processing method and system | |
CN109918385A (en) | Tripartite's account checking method, electronic device and readable storage medium storing program for executing | |
CN108681962A (en) | A kind of method, apparatus and equipment of business processing | |
KR20160053068A (en) | Trust account management method and server performing the same | |
CN107679889A (en) | The recognition methods of potential customers a kind of and terminal device | |
CN116860856A (en) | Financial data processing method and device, computer equipment and storage medium | |
CN112801616B (en) | Abnormal account book processing method and device | |
CN114881739A (en) | Order event processing method and device, electronic equipment and storage medium | |
CN114363179A (en) | Cost optimization method and device for cloud product | |
CN114511318A (en) | Account accounting method and device and electronic equipment | |
CN110413614A (en) | A kind of method and device that tables of data generates | |
CN113888310A (en) | Credit risk assessment method, credit risk assessment device 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 | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 213100 No. 39 Longhui Road, Wujin High-tech Zone, Changzhou City, Jiangsu Province Applicant after: Wanbang Charging Equipment Co., Ltd. Address before: 215000 No. 39 Longhui Road, Wujin High-tech Zone, Suzhou High-tech Zone, Jiangsu Province Applicant before: Wanbang Charging Equipment Co., Ltd. |
|
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180817 |