CN109918385A - Tripartite's account checking method, electronic device and readable storage medium storing program for executing - Google Patents
Tripartite's account checking method, electronic device and readable storage medium storing program for executing Download PDFInfo
- Publication number
- CN109918385A CN109918385A CN201910041305.XA CN201910041305A CN109918385A CN 109918385 A CN109918385 A CN 109918385A CN 201910041305 A CN201910041305 A CN 201910041305A CN 109918385 A CN109918385 A CN 109918385A
- Authority
- CN
- China
- Prior art keywords
- data table
- reconciliation
- data
- tables
- billing 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
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000012545 processing Methods 0.000 claims abstract description 39
- 238000005457 optimization Methods 0.000 abstract 1
- 230000002159 abnormal effect Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 238000001514 detection method Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to process optimization techniques, provide a kind of tripartite's account checking method, electronic device and readable storage medium storing program for executing, this method comprises: obtaining business side's billing data table, third-party platform billing data table and payment platform billing data table, and incoming presetting database；After receiving tripartite's reconciliation instruction, select business side's billing data table, third-party platform billing data table, any one in payment platform billing data table as reference data table, remaining is the first reconciliation tables of data and the second reconciliation tables of data；Reference data table is compared with the first reconciliation tables of data according to database batch processing, when data content is consistent, the state of reference data table is updated to default first identifier；Reference data table is compared with the second reconciliation tables of data, when data content is consistent, the state of reference data table is updated to default second identifier；When detecting default second identifier, tripartite's reconciliation successful information is exported.The present invention can efficiently and accurately carry out tripartite's reconciliation.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of tripartite's account checking methods, electronic device and readable storage
Medium.
Background technique
After business side has executed related payment transaction on third-party platform, business side itself can generate billing data, the
Billing data equally can be also generated on tripartite's platform and payment platform, need to carry out reconciliation to tripartite's data.It is existing to tripartite
The mode that data carry out reconciliation is usually that need to waste a large amount of manpowers, inefficiency, and artificial compare occurs by being manually compared
The probability of mistake is higher.
Summary of the invention
The purpose of the present invention is to provide a kind of tripartite's account checking method, electronic device and readable storage medium storing program for executing, it is intended to efficiently
And accurately carry out tripartite's reconciliation.
To achieve the above object, the present invention provides a kind of electronic device, and the electronic device includes memory, processor,
The tripartite's reconciliation system that can be run on the processor is stored on the memory, tripartite's reconciliation system is by the place
Reason device realizes following steps when executing:
Acquisition business side billing data table, third-party platform billing data table and payment platform billing data table；The industry
Business side's billing data table, third-party platform billing data table and payment platform billing data table are by business side's billing data, the
Tripartite's platform billing data and payment platform billing data are directed respectively into be generated in the table of preset format；
Business side's billing data table, third-party platform billing data table and payment platform billing data table is incoming pre-
If database；
After receiving for tripartite's reconciliation instruction of business side, third-party platform and payment platform, the business side is selected
Billing data table, third-party platform billing data table, any one in payment platform billing data table are as reference data table, separately
Outer two are used as the first reconciliation tables of data and the second reconciliation tables of data；
The reference data table is compared with the first reconciliation tables of data according to presetting database processing batch instruction,
When the reference data table is consistent with the data content of the first reconciliation tables of data, more by the state of the reference data table
New is default first identifier；The reference data table is compared with the second reconciliation tables of data, when the reference data
When table is consistent with the data content of the second reconciliation tables of data, the state of the reference data table is updated to default second mark
Know；
When the state for detecting the reference data table is default second identifier, tripartite's reconciliation successful information is exported.
Preferably, described according to presetting database processing batch instruction by the reference data table and the first reconciliation number
It is compared according to table, when the reference data table is consistent with the data content of the first reconciliation tables of data, by the benchmark
The state of tables of data is updated to default first identifier；The reference data table is compared with the second reconciliation tables of data,
When the reference data table is consistent with the data content of the second reconciliation tables of data, more by the state of the reference data table
After newly to preset second identifier the step of, further includes:
The reference data table and the first reconciliation tables of data, the state of the second reconciliation tables of data are updated to default third
Mark.
Preferably, the business side is insurance company, and the presetting database is insurance company database, described to receive
After tripartite's reconciliation instruction of business side, third-party platform and payment platform, business side's billing data table, third are selected
Any one in Fang Pingtai billing data table, payment platform billing data table is as reference data table, other two is as first
The step of reconciliation tables of data and the second reconciliation tables of data includes:
After receiving for tripartite's reconciliation instruction of insurance company, third-party platform and payment platform, insurance company is selected
Billing data table is as reference data table, using the third-party platform billing data table, payment platform billing data table as
One reconciliation tables of data, the second reconciliation tables of data.
Preferably, insurance company's billing data table, third-party platform billing data table, payment platform billing data table
Comprising corresponding number of policy, it is described according to presetting database processing batch instruction by the reference data table and described first pair
Account tables of data is compared, will be described when the reference data table is consistent with the data content of the first reconciliation tables of data
The state of reference data table is updated to default first identifier；The reference data table and the second reconciliation tables of data are compared
It is right, when the reference data table is consistent with the data content of the second reconciliation tables of data, by the shape of the reference data table
State is updated to the step of default second identifier and includes:
According to presetting database processing batch instruction by insurance company's billing data table and the third-party platform bill
Tables of data is compared, when the number of policy one of insurance company's billing data table and the third-party platform billing data table
It causes, and when data content is consistent, the state of insurance company's billing data table is updated to default first identifier；By the guarantor
Dangerous company's billing data table is compared with the payment platform billing data table, when insurance company's billing data table and institute
The number of policy for stating payment platform billing data table is consistent, and when data content is consistent, by insurance company's billing data table
State is updated to default second identifier.
In addition, to achieve the above object, the present invention also provides a kind of tripartite's account checking method, tripartite's account checking method packet
It includes:
Acquisition business side billing data table, third-party platform billing data table and payment platform billing data table；The industry
Business side's billing data table, third-party platform billing data table and payment platform billing data table are by business side's billing data, the
Tripartite's platform billing data and payment platform billing data are directed respectively into be generated in the table of preset format；
Business side's billing data table, third-party platform billing data table and payment platform billing data table is incoming pre-
If database；
After receiving for tripartite's reconciliation instruction of business side, third-party platform and payment platform, the business side is selected
Billing data table, third-party platform billing data table, any one in payment platform billing data table are as reference data table, separately
Outer two are used as the first reconciliation tables of data and the second reconciliation tables of data；
The reference data table is compared with the first reconciliation tables of data according to presetting database processing batch instruction,
When the reference data table is consistent with the data content of the first reconciliation tables of data, more by the state of the reference data table
New is default first identifier；The reference data table is compared with the second reconciliation tables of data, when the reference data
When table is consistent with the data content of the second reconciliation tables of data, the state of the reference data table is updated to default second mark
Know；
When the state for detecting the reference data table is default second identifier, tripartite's reconciliation successful information is exported.
Preferably, described according to presetting database processing batch instruction by the reference data table and the first reconciliation number
It is compared according to table, when the reference data table is consistent with the data content of the first reconciliation tables of data, by the benchmark
The state of tables of data is updated to default first identifier；The reference data table is compared with the second reconciliation tables of data,
When the reference data table is consistent with the data content of the second reconciliation tables of data, more by the state of the reference data table
After newly to preset second identifier the step of, further includes:
The reference data table and the first reconciliation tables of data, the state of the second reconciliation tables of data are updated to default third
Mark.
Preferably, the business side is insurance company, and the presetting database is insurance company database, described to receive
After tripartite's reconciliation instruction of business side, third-party platform and payment platform, business side's billing data table, third are selected
Any one in Fang Pingtai billing data table, payment platform billing data table is as reference data table, other two is as first
The step of reconciliation tables of data and the second reconciliation tables of data includes:
After receiving for tripartite's reconciliation instruction of insurance company, third-party platform and payment platform, insurance company is selected
Billing data table is as reference data table, using the third-party platform billing data table, payment platform billing data table as
One reconciliation tables of data, the second reconciliation tables of data.
Preferably, insurance company's billing data table, third-party platform billing data table, payment platform billing data table
Comprising corresponding number of policy, it is described according to presetting database processing batch instruction by the reference data table and described first pair
Account tables of data is compared, will be described when the reference data table is consistent with the data content of the first reconciliation tables of data
The state of reference data table is updated to default first identifier；The reference data table and the second reconciliation tables of data are compared
It is right, when the reference data table is consistent with the data content of the second reconciliation tables of data, by the shape of the reference data table
State is updated to the step of default second identifier and includes:
According to presetting database processing batch instruction by insurance company's billing data table and the third-party platform bill
Tables of data is compared, when the number of policy one of insurance company's billing data table and the third-party platform billing data table
It causes, and when data content is consistent, the state of insurance company's billing data table is updated to default first identifier；By the guarantor
Dangerous company's billing data table is compared with the payment platform billing data table, when insurance company's billing data table and institute
The number of policy for stating payment platform billing data table is consistent, and when data content is consistent, by insurance company's billing data table
State is updated to default second identifier.
Preferably, further includes:
When the data content of the reference data table and the first reconciliation tables of data is inconsistent or the reference data table
When inconsistent with the data content of the second reconciliation tables of data, reconciliation exception information is sent to default terminal.
Further, to achieve the above object, the present invention also provides a kind of computer readable storage medium, the computers
Readable storage medium storing program for executing is stored with tripartite's reconciliation system, and tripartite's reconciliation system can be executed by least one processor, so that institute
At least one processor is stated to execute such as the step of above-mentioned tripartite's account checking method.
Tripartite's account checking method, electronic device and readable storage medium storing program for executing proposed by the present invention, by by business side's billing data,
Third-party platform billing data and payment platform billing data, which are directed respectively into the table of preset format, generates corresponding tables of data, will
After the tables of data of generation is passed to presetting database, it need to only be can be completed by database batch processing and reconciliation is carried out to tripartite's data,
It is simple and fast, human cost is saved, and not easy to make mistakes, accuracy rate is high.
Detailed description of the invention
Fig. 1 is the running environment schematic diagram of 10 preferred embodiment of tripartite's reconciliation system of the present invention；
Fig. 2 is the flow diagram of one embodiment of tripartite's account checking method of the present invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that described herein, specific examples are only used to explain the present invention, not
For limiting the present invention.Based on the embodiments of the present invention, those of ordinary skill in the art are not before making creative work
Every other embodiment obtained is put, shall fall within the protection scope of the present invention.
It should be noted that the description for being related to " first ", " second " etc. in the present invention is used for description purposes only, and cannot
It is interpreted as its relative importance of indication or suggestion or implicitly indicates the quantity of indicated technical characteristic.Define as a result, " the
One ", the feature of " second " can explicitly or implicitly include at least one of the features.In addition, the skill between each embodiment
Art scheme can be combined with each other, but must be based on can be realized by those of ordinary skill in the art, when technical solution
Will be understood that the combination of this technical solution is not present in conjunction with there is conflicting or cannot achieve when, also not the present invention claims
Protection scope within.
The present invention provides a kind of tripartite's reconciliation system.Referring to Fig. 1, being 10 preferred embodiment of tripartite's reconciliation system of the present invention
Running environment schematic diagram.
In the present embodiment, tripartite's reconciliation system 10 is installed and is run in electronic device 1.The electronic device 1
It may include, but be not limited only to, memory 11, processor 12 and display 13.Fig. 1 illustrates only the electronics with component 11-13
Device 1, it should be understood that being not required for implementing all components shown, the implementation that can be substituted is more or less
Component.
The memory 11 is the readable computer storage medium of at least one type, and the memory 11 is in some implementations
It can be the internal storage unit of the electronic device 1, such as the hard disk or memory of the electronic device 1 in example.The memory
11 are also possible to the External memory equipment of the electronic device 1 in further embodiments, such as are equipped on the electronic device 1
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card,
Flash card (Flash Card) etc..Further, the memory 11 can also both include the storage inside of the electronic device 1
Unit also includes External memory equipment.The memory 11 for store the application software for being installed on the electronic device 1 and respectively
Class data, such as the program code etc. of tripartite's reconciliation system 10.The memory 11 can be also used for temporarily storing
Data through exporting or will export.
The processor 12 can be in some embodiments a central processing unit (Central Processing Unit,
CPU), microprocessor or other data processing chips, for running the program code stored in the memory 11 or processing number
According to, such as execute tripartite's reconciliation system 10 etc..
The display 13 can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display in some embodiments
And OLED (Organic Light-Emitting Diode, Organic Light Emitting Diode) touches device etc..The display 13 is used
In being shown in the information handled in the electronic device 1 and for showing visual user interface, such as the business side
Billing data table, the status indicator of third-party platform billing data table and payment platform billing data table, reconciliation successful information etc..
The component 11-13 of the electronic device 1 is in communication with each other by system bus.
Tripartite's reconciliation system 10 includes that at least one is stored in the computer-readable instruction in the memory 11, this is at least
One computer-readable instruction can be executed by the processor 12, to realize each embodiment of the application.
Wherein, following steps are realized when above-mentioned tripartite's reconciliation system 10 is executed by the processor 12:
Step S1 obtains business side's billing data table, third-party platform billing data table and payment platform billing data table；
Business side's billing data table, third-party platform billing data table and payment platform billing data table are by business side's bill number
It is directed respectively into according to, third-party platform billing data and payment platform billing data and to be generated in the table of preset format；
Step S2, by business side's billing data table, third-party platform billing data table and payment platform billing data
Table is passed to presetting database；
Step S3, after receiving for tripartite's reconciliation instruction of business side, third-party platform and payment platform, described in selection
Business side's billing data table, third-party platform billing data table, any one in payment platform billing data table are as base value
According to table, other two is as the first reconciliation tables of data and the second reconciliation tables of data；
Step S4, according to presetting database processing batch instruction by the reference data table and the first reconciliation tables of data into
Row compares, when the reference data table is consistent with the data content of the first reconciliation tables of data, by the reference data table
State be updated to default first identifier；The reference data table is compared with the second reconciliation tables of data, when described
When reference data table is consistent with the data content of the second reconciliation tables of data, the state of the reference data table is updated to pre-
If second identifier；
Step S5, when the state for detecting the reference data table is default second identifier, output tripartite's reconciliation success
Information.
In the present embodiment, (such as insurance company is in third party after business side has executed related service on third-party platform
After gondola sales insurance products), business side itself can generate billing data, equally can also produce on third-party platform and payment platform
Raw billing data.Firstly, the respective billing data of this tripartite of business side, third-party platform and payment platform is directed respectively into default
In three tables of format, business side's billing data table, third-party platform billing data table, payment platform billing data table are generated.
In a kind of optional embodiment, three tables of importing have unified identification information (such as Unified number, unified insurance policy
Number etc.).Business side's billing data table, third-party platform billing data table, payment platform billing data table is incoming simultaneously default
Database.In the tripartite's reconciliation instruction for receiving user's sending or detecting that tables of data is passed to presetting database automatic trigger tripartite
After reconciliation instruction, incoming business side's billing data table, third-party platform billing data table, payment platform billing data table are selected
In any one as reference data table, other two is the first reconciliation tables of data and the second reconciliation tables of data, then according to default
Reference data table is compared database processing batch instruction with the first reconciliation tables of data, when the first reconciliation tables of data and base value
When there is same identification information (such as identical number, number of policy) and also consistent data content information according to table, then illustrate reference data
Table is consistent with the data of the first reconciliation tables of data, and reconciliation result is flat account, then can be updated to the state of the reference data table pre-
If first identifier.Further, reference data table is compared with the second reconciliation tables of data, when the second reconciliation tables of data and base
When quasi- tables of data has same identification information (such as identical number, number of policy) and also consistent data content information, then illustrate benchmark
Tables of data is consistent with the data of the second reconciliation tables of data, and reconciliation result is flat account, then can be by the state of the reference data table by pre-
If first identifier is updated to default second identifier.When the state for detecting the reference data table is default second identifier, then say
The reconciliation result of the bright reference data table and the first reconciliation tables of data, the second reconciliation tables of data is flat account, by data transitivity
It is found that after the reference data table and the first reconciliation tables of data, the reference data table and the second reconciliation tables of data reconciliation success, first
Reconciliation tables of data and the second reconciliation tables of data also must can with reconciliation success, i.e., the reference data table and the first reconciliation tables of data,
Between second reconciliation tables of data this three must can be with reconciliation success, i.e., reconciliation result is flat account between three.Therefore, work as detection
When state to the reference data table is default second identifier, exportable tripartite's reconciliation successful information.
It further, can be by the reference data after the state for detecting the reference data table is default second identifier
The state of table and the first reconciliation tables of data, the second reconciliation tables of data is updated to default third mark (the flat account mark of such as tripartite),
To know that reconciliation is completed in the reference data table and the first reconciliation tables of data, the second reconciliation tables of data according to default third mark
Process, and tripartite's reconciliation success.
Since the billing data of tripartite need to only be imported to the tables of data of preset format and be passed to preset data in the present embodiment
In library, automatic reconciliation processing can be carried out to tripartite's billing data according to database batch processing, be compared without artificial, save people
Power improves efficiency, and avoids the artificial error probability for comparing and occurring, and especially has good implementation capacity to high-volume data.
In an optional embodiment, on the basis of the embodiment of above-mentioned Fig. 1, the business side is insurance company, institute
Stating presetting database is insurance company database, and tripartite's reconciliation system 10 is executed by the processor 12 and realizes the step
When S3, comprising:
After receiving for tripartite's reconciliation instruction of insurance company, third-party platform and payment platform, insurance company is selected
Billing data table is as reference data table, using the third-party platform billing data table, payment platform billing data table as
One reconciliation tables of data, the second reconciliation tables of data.
When tripartite's reconciliation system 10 executes the realization step S4 by the processor 12, comprising:
According to presetting database processing batch instruction by insurance company's billing data table and the third-party platform bill
Tables of data is compared, when the number of policy one of insurance company's billing data table and the third-party platform billing data table
It causes, and when data content is consistent, the state of insurance company's billing data table is updated to default first identifier；By the guarantor
Dangerous company's billing data table is compared with the payment platform billing data table, when insurance company's billing data table and institute
The number of policy for stating payment platform billing data table is consistent, and when data content is consistent, by insurance company's billing data table
State is updated to default second identifier.
In the present embodiment, business side is insurance company, and the presetting database is insurance company database.Insurance company exists
After third-party platform marketing insurance product, insurance company itself can generate billing data, same on third-party platform and payment platform
Sample can also generate billing data.Firstly, by the respective billing data of this tripartite of insurance company, third-party platform and payment platform point
Dao Ru not be in three tables of preset format, and there is three tables imported unified identification information such as to insure odd numbers, generate insurance
Company's billing data table, third-party platform billing data table, payment platform billing data table.By insurance company's billing data table,
Third-party platform billing data table, payment platform billing data table are passed to insurance company database simultaneously.It is issued receiving user
Tripartite's reconciliation instruction or detect tables of data be passed to the tripartite's reconciliation of insurance company database automatic trigger instruction after, will insure
Company's billing data table as reference data table, then according to presetting database processing batch instruction by insurance company's billing data table with
Third-party platform billing data table is compared, when third-party platform billing data table and insurance company's billing data table have phase
When with identification information, that is, identical number of policy and also consistent data content information, then illustrate insurance company's billing data table and third party
The data of platform billing data table are consistent, and reconciliation result is flat account, then can update the state of insurance company's billing data table
To preset first identifier.Further, insurance company's billing data table is compared with payment platform billing data table, works as branch
It pays platform billing data table and insurance company's billing data table has same identification information, that is, identical number of policy and data content is believed
When ceasing also consistent, then illustrate that insurance company's billing data table is consistent with the data of payment platform billing data table, reconciliation result is
The state of insurance company's billing data table then can be updated to default second identifier by default first identifier by flat account.Work as detection
When state to insurance company's billing data table is default second identifier, then illustrate insurance company's billing data table and third
Fang Pingtai billing data table, payment platform billing data table reconciliation result be flat account, by data transitivity it is found that the insurance
Company's billing data table and third-party platform billing data table, insurance company's billing data table and payment platform billing data table
After reconciliation succeeds, third-party platform billing data table and payment platform billing data table must can also be succeeded with reconciliation, i.e. the guarantor
It must can be right between dangerous company's billing data table and third-party platform billing data table, payment platform billing data table this three
Account success, i.e., reconciliation result is flat account between three.It can be by insurance company's billing data table and third-party platform billing data
Table, payment platform billing data table state be updated to default third mark (the flat account mark of such as tripartite), according to default the
Three marks know tripartite's reconciliation success.
For example, after the billing data of tripartite to be imported to three tables of database, having a system in a specific example
One odd numbers, by taking the number of policy of insurance sales as an example, insurance company itself billing data table is denoted as A, third party's billing data table
It is denoted as B, payer billing data table is denoted as C, and original state is 0, and database batch processing logic is as follows: 1, by A table on the basis of,
When B table has number of policy identical as A table and remaining also consistent information, updating A table status is default first identifier " 1 "；2, with A
On the basis of table, when C table has number of policy identical as A table and remaining also consistent information, updating A table status is default second identifier
"2"；3, the data that A table status is default second identifier " 2 " are updated to default third mark " 6 " (reconciliation success), simultaneously will
Other two table number of policy and A table is consistent is also updated to default third mark " 6 ", known to data transitivity when A and B, A with
After C reconciliation success, B and C also must can be with reconciliation success, then B and C is updated to default third mark " 6 ".According to A, B, C tripartite
Default third mark " 6 " you can learn that tripartite's reconciliation success.
In an optional embodiment, when tripartite's reconciliation system 10 is executed by the processor 12, also realize as follows
Step:
When the data content of the reference data table and the first reconciliation tables of data is inconsistent or the reference data table
When inconsistent with the data content of the second reconciliation tables of data, reconciliation exception information is sent to default terminal.
In the present embodiment, according to presetting database processing batch instruction by insurance company's billing data table and third-party platform
When billing data table or payment platform billing data table are compared, if being not present and insurance in third-party platform billing data table
Company's billing data table has the i.e. identical number of policy of same identification information and the consistent data of remainder data content information, then explanation pair
Account result is variant, then records during the reconciliation exception information for example generates both sides' identity information of reconciliation exception, reconciliation
Identical data part and different data part etc..And to default terminal such as supervision work personnel's mobile phone or generate abnormal pair of reconciliation
Side such as insurance company, third-party platform send reconciliation abnormal prompt information, manually check reconciliation abnormal conditions to remind.Wherein,
In the present embodiment flat account refer to account the amount of money and sundry item and the account amount of money and sundry item of its reconciliation it is mutual
Calculate equal, i.e. account account is consistent.If mutually calculating unequal, difference is calculated between account and account, then is difference account, i.e.,
Reconciliation is abnormal.
In an optional embodiment, different billing data tables are compared according to presetting database processing batch instruction
When, specifically may include following steps:
1, by the respective billing data of this tripartite of business side, third-party platform and payment platform (other lattice such as including word
Each column data of formula) it is copied in the table excel of importing preset format respectively.
2, CONCATENATE function is used in sql column unit frame, writes sql sentence, and set each value coordinate.
3, mouse is put to the first row unit frame lower right corner where sql, is dragged to last line down and is copied all sql languages
Sentence.
4, the sql sentence that will have been copied, executes in the database.
As shown in Fig. 2, Fig. 2 is the flow diagram of one embodiment of tripartite's account checking method of the present invention, tripartite's account checking method
The following steps are included:
Step S10 obtains business side's billing data table, third-party platform billing data table and payment platform billing data
Table；Business side's billing data table, third-party platform billing data table and payment platform billing data table are by business side's account
Forms data, third-party platform billing data and payment platform billing data are directed respectively into be generated in the table of preset format；
Step S20, by business side's billing data table, third-party platform billing data table and payment platform billing data
Table is passed to presetting database；
Step S30 selects institute after receiving for tripartite's reconciliation instruction of business side, third-party platform and payment platform
Business side's billing data table, third-party platform billing data table, any one in payment platform billing data table are stated as benchmark
Tables of data, other two is as the first reconciliation tables of data and the second reconciliation tables of data；
Step S40, according to presetting database processing batch instruction by the reference data table and the first reconciliation tables of data
It is compared, when the reference data table is consistent with the data content of the first reconciliation tables of data, by the reference data
The state of table is updated to default first identifier；The reference data table is compared with the second reconciliation tables of data, works as institute
State reference data table it is consistent with the data content of the second reconciliation tables of data when, the state of the reference data table is updated to
Default second identifier；
Step S50, when the state for detecting the reference data table is default second identifier, output tripartite's reconciliation success
Information.
In the present embodiment, (such as insurance company is in third party after business side has executed related service on third-party platform
After gondola sales insurance products), business side itself can generate billing data, equally can also produce on third-party platform and payment platform
Raw billing data.Firstly, the respective billing data of this tripartite of business side, third-party platform and payment platform is directed respectively into default
In three tables of format, business side's billing data table, third-party platform billing data table, payment platform billing data table are generated.
In a kind of optional embodiment, three tables of importing have unified identification information (such as Unified number, unified insurance policy
Number etc.).Business side's billing data table, third-party platform billing data table, payment platform billing data table is incoming simultaneously default
Database.In the tripartite's reconciliation instruction for receiving user's sending or detecting that tables of data is passed to presetting database automatic trigger tripartite
After reconciliation instruction, incoming business side's billing data table, third-party platform billing data table, payment platform billing data table are selected
In any one as reference data table, other two is the first reconciliation tables of data and the second reconciliation tables of data, then according to default
Reference data table is compared database processing batch instruction with the first reconciliation tables of data, when the first reconciliation tables of data and base value
When there is same identification information (such as identical number, number of policy) and also consistent data content information according to table, then illustrate reference data
Table is consistent with the data of the first reconciliation tables of data, and reconciliation result is flat account, then can be updated to the state of the reference data table pre-
If first identifier.Further, reference data table is compared with the second reconciliation tables of data, when the second reconciliation tables of data and base
When quasi- tables of data has same identification information (such as identical number, number of policy) and also consistent data content information, then illustrate benchmark
Tables of data is consistent with the data of the second reconciliation tables of data, and reconciliation result is flat account, then can be by the state of the reference data table by pre-
If first identifier is updated to default second identifier.When the state for detecting the reference data table is default second identifier, then say
The reconciliation result of the bright reference data table and the first reconciliation tables of data, the second reconciliation tables of data is flat account, by data transitivity
It is found that after the reference data table and the first reconciliation tables of data, the reference data table and the second reconciliation tables of data reconciliation success, first
Reconciliation tables of data and the second reconciliation tables of data also must can with reconciliation success, i.e., the reference data table and the first reconciliation tables of data,
Between second reconciliation tables of data this three must can be with reconciliation success, i.e., reconciliation result is flat account between three.Therefore, work as detection
When state to the reference data table is default second identifier, exportable tripartite's reconciliation successful information.
It further, can be by the reference data after the state for detecting the reference data table is default second identifier
The state of table and the first reconciliation tables of data, the second reconciliation tables of data is updated to default third mark (the flat account mark of such as tripartite),
To know that reconciliation is completed in the reference data table and the first reconciliation tables of data, the second reconciliation tables of data according to default third mark
Process, and tripartite's reconciliation success.
Since the billing data of tripartite need to only be imported to the tables of data of preset format and be passed to preset data in the present embodiment
In library, automatic reconciliation processing can be carried out to tripartite's billing data according to database batch processing, be compared without artificial, save people
Power improves efficiency, and avoids the artificial error probability for comparing and occurring, and especially has good implementation capacity to high-volume data.
In an optional embodiment, on the basis of the above embodiments, the business side is insurance company, described default
Database is insurance company database, and the step S30 includes:
After receiving for tripartite's reconciliation instruction of insurance company, third-party platform and payment platform, insurance company is selected
Billing data table is as reference data table, using the third-party platform billing data table, payment platform billing data table as
One reconciliation tables of data, the second reconciliation tables of data.
The step S40 includes:
According to presetting database processing batch instruction by insurance company's billing data table and the third-party platform bill
Tables of data is compared, when the number of policy one of insurance company's billing data table and the third-party platform billing data table
It causes, and when data content is consistent, the state of insurance company's billing data table is updated to default first identifier；By the guarantor
Dangerous company's billing data table is compared with the payment platform billing data table, when insurance company's billing data table and institute
The number of policy for stating payment platform billing data table is consistent, and when data content is consistent, by insurance company's billing data table
State is updated to default second identifier.
In the present embodiment, business side is insurance company, and the presetting database is insurance company database.Insurance company exists
After third-party platform marketing insurance product, insurance company itself can generate billing data, same on third-party platform and payment platform
Sample can also generate billing data.Firstly, by the respective billing data of this tripartite of insurance company, third-party platform and payment platform point
Dao Ru not be in three tables of preset format, and there is three tables imported unified identification information such as to insure odd numbers, generate insurance
Company's billing data table, third-party platform billing data table, payment platform billing data table.By insurance company's billing data table,
Third-party platform billing data table, payment platform billing data table are passed to insurance company database simultaneously.It is issued receiving user
Tripartite's reconciliation instruction or detect tables of data be passed to the tripartite's reconciliation of insurance company database automatic trigger instruction after, will insure
Company's billing data table as reference data table, then according to presetting database processing batch instruction by insurance company's billing data table with
Third-party platform billing data table is compared, when third-party platform billing data table and insurance company's billing data table have phase
When with identification information, that is, identical number of policy and also consistent data content information, then illustrate insurance company's billing data table and third party
The data of platform billing data table are consistent, and reconciliation result is flat account, then can update the state of insurance company's billing data table
To preset first identifier.Further, insurance company's billing data table is compared with payment platform billing data table, works as branch
It pays platform billing data table and insurance company's billing data table has same identification information, that is, identical number of policy and data content is believed
When ceasing also consistent, then illustrate that insurance company's billing data table is consistent with the data of payment platform billing data table, reconciliation result is
The state of insurance company's billing data table then can be updated to default second identifier by default first identifier by flat account.Work as detection
When state to insurance company's billing data table is default second identifier, then illustrate insurance company's billing data table and third
Fang Pingtai billing data table, payment platform billing data table reconciliation result be flat account, by data transitivity it is found that the insurance
Company's billing data table and third-party platform billing data table, insurance company's billing data table and payment platform billing data table
After reconciliation succeeds, third-party platform billing data table and payment platform billing data table must can also be succeeded with reconciliation, i.e. the guarantor
It must can be right between dangerous company's billing data table and third-party platform billing data table, payment platform billing data table this three
Account success, i.e., reconciliation result is flat account between three.It can be by insurance company's billing data table and third-party platform billing data
Table, payment platform billing data table state be updated to default third mark (the flat account mark of such as tripartite), according to default the
Three marks know tripartite's reconciliation success.
For example, after the billing data of tripartite to be imported to three tables of database, having a system in a specific example
One odd numbers, by taking the number of policy of insurance sales as an example, insurance company itself billing data table is denoted as A, third party's billing data table
It is denoted as B, payer billing data table is denoted as C, and original state is 0, and database batch processing logic is as follows: 1, by A table on the basis of,
When B table has number of policy identical as A table and remaining also consistent information, updating A table status is default first identifier " 1 "；2, with A
On the basis of table, when C table has number of policy identical as A table and remaining also consistent information, updating A table status is default second identifier
"2"；3, the data that A table status is default second identifier " 2 " are updated to default third mark " 6 " (reconciliation success), simultaneously will
Other two table number of policy and A table is consistent is also updated to default third mark " 6 ", known to data transitivity when A and B, A with
After C reconciliation success, B and C also must can be with reconciliation success, then B and C is updated to default third mark " 6 ".According to A, B, C tripartite
Default third mark " 6 " you can learn that tripartite's reconciliation success.
In an optional embodiment, this method further includes following steps:
When the data content of the reference data table and the first reconciliation tables of data is inconsistent or the reference data table
When inconsistent with the data content of the second reconciliation tables of data, reconciliation exception information is sent to default terminal.
In the present embodiment, according to presetting database processing batch instruction by insurance company's billing data table and third-party platform
When billing data table or payment platform billing data table are compared, if being not present and insurance in third-party platform billing data table
Company's billing data table has the i.e. identical number of policy of same identification information and the consistent data of remainder data content information, then explanation pair
Account result is variant, then records during the reconciliation exception information for example generates both sides' identity information of reconciliation exception, reconciliation
Identical data part and different data part etc..And to default terminal such as supervision work personnel's mobile phone or generate abnormal pair of reconciliation
Side such as insurance company, third-party platform send reconciliation abnormal prompt information, manually check reconciliation abnormal conditions to remind.Wherein,
In the present embodiment flat account refer to account the amount of money and sundry item and the account amount of money and sundry item of its reconciliation it is mutual
Calculate equal, i.e. account account is consistent.If mutually calculating unequal, difference is calculated between account and account, then is difference account, i.e.,
Reconciliation is abnormal.
In an optional embodiment, different billing data tables are compared according to presetting database processing batch instruction
When, specifically may include following steps:
1, by the respective billing data of this tripartite of business side, third-party platform and payment platform (other lattice such as including word
Each column data of formula) it is copied in the table excel of importing preset format respectively.
2, CONCATENATE function is used in sql column unit frame, writes sql sentence, and set each value coordinate.
3, mouse is put to the first row unit frame lower right corner where sql, is dragged to last line down and is copied all sql languages
Sentence.
4, the sql sentence that will have been copied, executes in the database.
In addition, the computer-readable recording medium storage has the present invention also provides a kind of computer readable storage medium
Tripartite's reconciliation system, tripartite's reconciliation system can be executed by least one processor, so that at least one described processor is held
For row such as the step of tripartite's account checking method in above-described embodiment, step S10, S20, S30 of tripartite's account checking method etc. are specific real
It is as described above to apply process, details are not described herein.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, method, article or the device that include a series of elements not only include those elements, and
And further include other elements that are not explicitly listed, or further include for this process, method, article or device institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to do
There is also other identical elements in the process, method of element, article or device.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to be realized by hardware, but very much
In the case of the former be more preferably embodiment.Based on this understanding, technical solution of the present invention is substantially in other words to existing
The part that technology contributes can be embodied in the form of software products, which is stored in a storage
In medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, calculate
Machine, server, air conditioner or network equipment etc.) execute method described in each embodiment of the present invention.
Preferred embodiments of the present invention have been described above with reference to the accompanying drawings, not thereby limiting the scope of the invention.On
It is for illustration only to state serial number of the embodiment of the present invention, does not represent the advantages or disadvantages of the embodiments.It is patrolled in addition, though showing in flow charts
Sequence is collected, but in some cases, it can be with the steps shown or described are performed in an order that is different from the one herein.
Without departing from the scope and spirit of the invention, there are many variations to implement the present invention by those skilled in the art,
It can be used for another embodiment for example as the feature of one embodiment and obtain another embodiment.It is all to use technology of the invention
Made any modifications, equivalent replacements, and improvements within design, should all be within interest field of the invention.
Claims (10)
1. a kind of electronic device, which is characterized in that the electronic device includes memory, processor, is stored on the memory
There is the tripartite's reconciliation system that can be run on the processor, is realized such as when tripartite's reconciliation system is executed by the processor
Lower step:
Acquisition business side billing data table, third-party platform billing data table and payment platform billing data table；The business side
Billing data table, third-party platform billing data table and payment platform billing data table are by business side's billing data, third party
Platform billing data and payment platform billing data are directed respectively into be generated in the table of preset format；
Business side's billing data table, third-party platform billing data table and payment platform billing data table are passed to present count
According to library；
After receiving for tripartite's reconciliation instruction of business side, third-party platform and payment platform, business side's bill is selected
Tables of data, third-party platform billing data table, any one in payment platform billing data table are as reference data table, and in addition two
It is a to be used as the first reconciliation tables of data and the second reconciliation tables of data；
The reference data table is compared with the first reconciliation tables of data according to presetting database processing batch instruction, works as institute
State reference data table it is consistent with the data content of the first reconciliation tables of data when, the state of the reference data table is updated to
Default first identifier；The reference data table is compared with the second reconciliation tables of data, when the reference data table with
When the data content of the second reconciliation tables of data is consistent, the state of the reference data table is updated to default second identifier；
When the state for detecting the reference data table is default second identifier, tripartite's reconciliation successful information is exported.
2. electronic device as described in claim 1, which is characterized in that it is described according to presetting database processing batch instruction by institute
It states reference data table to be compared with the first reconciliation tables of data, when the reference data table and the first reconciliation tables of data
Data content it is consistent when, the state of the reference data table is updated to default first identifier；By the reference data table with
The second reconciliation tables of data is compared, when the reference data table is consistent with the data content of the second reconciliation tables of data
When, the state of the reference data table was updated to after the step of presetting second identifier, further includes:
The reference data table and the first reconciliation tables of data, the state of the second reconciliation tables of data are updated to default third mark
Know.
3. electronic device as claimed in claim 1 or 2, which is characterized in that the business side is insurance company, the present count
It is insurance company database according to library, it is described to receive tripartite's reconciliation instruction for business side, third-party platform and payment platform
Afterwards, business side's billing data table, third-party platform billing data table, any one in payment platform billing data table are selected
As reference data table, other two includes: as the step of the first reconciliation tables of data and the second reconciliation tables of data
After receiving for tripartite's reconciliation instruction of insurance company, third-party platform and payment platform, insurance company's bill is selected
Tables of data is as reference data table, using the third-party platform billing data table, payment platform billing data table as first pair
Account tables of data, the second reconciliation tables of data.
4. electronic device as claimed in claim 3, which is characterized in that insurance company's billing data table, third-party platform
Billing data table, payment platform billing data table include corresponding number of policy, described to be referred to according to presetting database batch processing
The reference data table is compared with the first reconciliation tables of data for order, when the reference data table and first reconciliation
When the data content of tables of data is consistent, the state of the reference data table is updated to default first identifier；By the base value
It is compared according to table with the second reconciliation tables of data, when in the data of the reference data table and the second reconciliation tables of data
When holding consistent, the step of state of the reference data table is updated to default second identifier, includes:
According to presetting database processing batch instruction by insurance company's billing data table and the third-party platform billing data
Table is compared, when insurance company's billing data table is consistent with the number of policy of the third-party platform billing data table, and
When data content is consistent, the state of insurance company's billing data table is updated to default first identifier；The insurance is public
Department's billing data table is compared with the payment platform billing data table, when insurance company's billing data table and the branch
The number of policy for paying platform billing data table is consistent, and when data content is consistent, by the state of insurance company's billing data table
It is updated to default second identifier.
5. a kind of tripartite's account checking method, which is characterized in that tripartite's account checking method includes:
Acquisition business side billing data table, third-party platform billing data table and payment platform billing data table；The business side
Billing data table, third-party platform billing data table and payment platform billing data table are by business side's billing data, third party
Platform billing data and payment platform billing data are directed respectively into be generated in the table of preset format；
Business side's billing data table, third-party platform billing data table and payment platform billing data table are passed to present count
According to library；
After receiving for tripartite's reconciliation instruction of business side, third-party platform and payment platform, business side's bill is selected
Tables of data, third-party platform billing data table, any one in payment platform billing data table are as reference data table, and in addition two
It is a to be used as the first reconciliation tables of data and the second reconciliation tables of data；
The reference data table is compared with the first reconciliation tables of data according to presetting database processing batch instruction, works as institute
State reference data table it is consistent with the data content of the first reconciliation tables of data when, the state of the reference data table is updated to
Default first identifier；The reference data table is compared with the second reconciliation tables of data, when the reference data table with
When the data content of the second reconciliation tables of data is consistent, the state of the reference data table is updated to default second identifier；
When the state for detecting the reference data table is default second identifier, tripartite's reconciliation successful information is exported.
6. tripartite's account checking method as claimed in claim 5, which is characterized in that described according to presetting database processing batch instruction
The reference data table is compared with the first reconciliation tables of data, when the reference data table and the first reconciliation number
When consistent according to the data content of table, the state of the reference data table is updated to default first identifier；By the reference data
Table is compared with the second reconciliation tables of data, when the data content of the reference data table and the second reconciliation tables of data
When consistent, the state of the reference data table was updated to after the step of presetting second identifier, further includes:
The reference data table and the first reconciliation tables of data, the state of the second reconciliation tables of data are updated to default third mark
Know.
7. such as tripartite's account checking method described in claim 5 or 6, which is characterized in that the business side is insurance company, described pre-
It is described to receive tripartite's reconciliation for business side, third-party platform and payment platform if database is insurance company database
After instruction, business side's billing data table, third-party platform billing data table, any in payment platform billing data table are selected
One is used as reference data table, other two includes: as the step of the first reconciliation tables of data and the second reconciliation tables of data
After receiving for tripartite's reconciliation instruction of insurance company, third-party platform and payment platform, insurance company's bill is selected
Tables of data is as reference data table, using the third-party platform billing data table, payment platform billing data table as first pair
Account tables of data, the second reconciliation tables of data.
8. tripartite's account checking method as claimed in claim 7, which is characterized in that insurance company's billing data table, third party
Platform billing data table, payment platform billing data table include corresponding number of policy, described according at presetting database batch
The reference data table is compared with the first reconciliation tables of data for reason instruction, when the reference data table and described first
When the data content of reconciliation tables of data is consistent, the state of the reference data table is updated to default first identifier；By the base
Quasi- tables of data is compared with the second reconciliation tables of data, when the number of the reference data table and the second reconciliation tables of data
When consistent according to content, the step of state of the reference data table is updated to default second identifier, includes:
According to presetting database processing batch instruction by insurance company's billing data table and the third-party platform billing data
Table is compared, when insurance company's billing data table is consistent with the number of policy of the third-party platform billing data table, and
When data content is consistent, the state of insurance company's billing data table is updated to default first identifier；The insurance is public
Department's billing data table is compared with the payment platform billing data table, when insurance company's billing data table and the branch
The number of policy for paying platform billing data table is consistent, and when data content is consistent, by the state of insurance company's billing data table
It is updated to default second identifier.
9. such as tripartite's account checking method described in claim 5 or 6, which is characterized in that further include:
When the data content of the reference data table and the first reconciliation tables of data is inconsistent or the reference data table and institute
State the second reconciliation tables of data data content it is inconsistent when, to default terminal send reconciliation exception information.
10. a kind of computer readable storage medium, which is characterized in that be stored with tripartite couple on the computer readable storage medium
Account system realizes tripartite's reconciliation as described in any one of claim 5 to 9 when tripartite's reconciliation system is executed by processor
The step of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910041305.XA CN109918385A (en) | 2019-01-16 | 2019-01-16 | Tripartite's account checking method, electronic device and readable storage medium storing program for executing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910041305.XA CN109918385A (en) | 2019-01-16 | 2019-01-16 | Tripartite's account checking method, electronic device and readable storage medium storing program for executing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109918385A true CN109918385A (en) | 2019-06-21 |
Family
ID=66960377
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910041305.XA Pending CN109918385A (en) | 2019-01-16 | 2019-01-16 | Tripartite's account checking method, electronic device and readable storage medium storing program for executing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109918385A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457311A (en) * | 2019-07-05 | 2019-11-15 | 中国平安财产保险股份有限公司 | Automatically generate method, server and the storage medium of reconciliation file |
| CN111353902A (en) * | 2020-02-26 | 2020-06-30 | 中国人民财产保险股份有限公司广东省分公司 | Insurance policy processing method and system for insurance B2B cooperation service |
| CN111506633A (en) * | 2020-04-23 | 2020-08-07 | 深圳前海微众银行股份有限公司 | Expense allocation method, device, equipment, system and computer readable storage medium |
| CN113379967A (en) * | 2021-06-07 | 2021-09-10 | 广州通达汽车电气股份有限公司 | Account checking method and system based on charging pile, electronic equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020147685A1 (en) * | 2001-04-09 | 2002-10-10 | Kwan Khai Hee | Computer network method for conducting payment over a network by debiting and crediting utilities accounts |
| CN103310311A (en) * | 2013-06-29 | 2013-09-18 | 国家电网公司 | Electric charge finance management system and account checking method |
| CN105427031A (en) * | 2015-11-06 | 2016-03-23 | 中国南方电网有限责任公司 | Three-party data check method and system |
| CN106503420A (en) * | 2016-09-27 | 2017-03-15 | 中电科软件信息服务有限公司 | The multi-party reconciliation assessment of hospital and supervisory systems and method |
| CN107274279A (en) * | 2017-05-27 | 2017-10-20 | 上海非码网络科技有限公司 | A kind of account checking method and system, electronic equipment based on multiple mobile payment platforms |
| CN107909495A (en) * | 2017-12-22 | 2018-04-13 | 泰康保险集团股份有限公司 | A kind of account checking method, system, medium, electronic equipment |
| CN108416580A (en) * | 2018-03-09 | 2018-08-17 | 万帮充电设备有限公司 | Account checking method, account checking apparatus and electronic equipment |
| WO2019010502A1 (en) * | 2017-07-07 | 2019-01-10 | Enter, Inc. | Automated system and method for managing billing/invoicing and medical payments, including insurance payments and copays |
-
2019
- 2019-01-16 CN CN201910041305.XA patent/CN109918385A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020147685A1 (en) * | 2001-04-09 | 2002-10-10 | Kwan Khai Hee | Computer network method for conducting payment over a network by debiting and crediting utilities accounts |
| CN103310311A (en) * | 2013-06-29 | 2013-09-18 | 国家电网公司 | Electric charge finance management system and account checking method |
| CN105427031A (en) * | 2015-11-06 | 2016-03-23 | 中国南方电网有限责任公司 | Three-party data check method and system |
| CN106503420A (en) * | 2016-09-27 | 2017-03-15 | 中电科软件信息服务有限公司 | The multi-party reconciliation assessment of hospital and supervisory systems and method |
| CN107274279A (en) * | 2017-05-27 | 2017-10-20 | 上海非码网络科技有限公司 | A kind of account checking method and system, electronic equipment based on multiple mobile payment platforms |
| WO2019010502A1 (en) * | 2017-07-07 | 2019-01-10 | Enter, Inc. | Automated system and method for managing billing/invoicing and medical payments, including insurance payments and copays |
| CN107909495A (en) * | 2017-12-22 | 2018-04-13 | 泰康保险集团股份有限公司 | A kind of account checking method, system, medium, electronic equipment |
| CN108416580A (en) * | 2018-03-09 | 2018-08-17 | 万帮充电设备有限公司 | Account checking method, account checking apparatus and electronic equipment |
Non-Patent Citations (2)
| Title |
|---|
| 冀平;贾新茹;吴首蓉;: "基于多种支付模式的客票收入结算对账体系设计与实现", 铁路计算机应用, no. 06, 25 June 2016 (2016-06-25), pages 33 - 35 * |
| 张雅婷;: "多种支付方式下大型公立医院综合电子对账平台的构建", 中国民商, no. 03, 1 March 2018 (2018-03-01), pages 206 - 207 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457311A (en) * | 2019-07-05 | 2019-11-15 | 中国平安财产保险股份有限公司 | Automatically generate method, server and the storage medium of reconciliation file |
| CN110457311B (en) * | 2019-07-05 | 2023-11-10 | 中国平安财产保险股份有限公司 | Method, server and storage medium for automatically generating reconciliation document |
| CN111353902A (en) * | 2020-02-26 | 2020-06-30 | 中国人民财产保险股份有限公司广东省分公司 | Insurance policy processing method and system for insurance B2B cooperation service |
| CN111506633A (en) * | 2020-04-23 | 2020-08-07 | 深圳前海微众银行股份有限公司 | Expense allocation method, device, equipment, system and computer readable storage medium |
| CN113379967A (en) * | 2021-06-07 | 2021-09-10 | 广州通达汽车电气股份有限公司 | Account checking method and system based on charging pile, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109242261B (en) | Method for evaluating security risk based on big data and terminal equipment | |
| CN109918385A (en) | Tripartite's account checking method, electronic device and readable storage medium storing program for executing | |
| CN111951091B (en) | Transaction flow reconciliation method, system and related equipment | |
| CN110633977A (en) | Payment exception processing method and device and terminal equipment | |
| CN112528616B (en) | Service form generation method and device, electronic equipment and computer storage medium | |
| CN107133233B (en) | Processing method and device for configuration data query | |
| CN107133856A (en) | The control method and device of risk order | |
| WO2019136812A1 (en) | Electronic device, data calling log generation and query method, and storage medium | |
| CN108073707B (en) | Financial business data updating method and device and computer readable storage medium | |
| CN112949278A (en) | Data checking method and device, electronic equipment and readable storage medium | |
| CN110675249A (en) | Matching method, device, server and storage medium for network lending | |
| US20090106459A1 (en) | Configuration identification tool and methods | |
| US20150026770A1 (en) | Safety information transfer system, device and method based on extended parameter set | |
| WO2019056737A1 (en) | Monthly settlement management method, apparatus, terminal device, and medium | |
| CN110689333B (en) | Block chain automatic account checking method, device, system and storage medium | |
| CN109166042B (en) | Node device, real-time reconciliation method based on blockchain, and storage medium | |
| CN116484296A (en) | Financial fund collection risk analysis method, device, equipment and storage medium | |
| CN109377391A (en) | A kind of tracking of information method, storage medium and server | |
| CN110533497A (en) | Order generation method and system, electronic equipment and storage medium | |
| CN113469649A (en) | Project progress analysis method and device, electronic equipment and storage medium | |
| CN112686759A (en) | Account checking monitoring method, device, equipment and medium | |
| CN112749541A (en) | Data verification system, method, device, electronic equipment and computer readable medium | |
| CN111382159A (en) | Method for processing fee information, server and computer readable medium | |
| CN110309211A (en) | A kind of method and relevant device positioning ETL Process Problems | |
| WO2019056735A1 (en) | Accreditation method and device, terminal device and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20240920 |