CN102136093A - Cancel-after-verification realization method and system - Google Patents
Cancel-after-verification realization method and system Download PDFInfo
- Publication number
- CN102136093A CN102136093A CN2010101034558A CN201010103455A CN102136093A CN 102136093 A CN102136093 A CN 102136093A CN 2010101034558 A CN2010101034558 A CN 2010101034558A CN 201010103455 A CN201010103455 A CN 201010103455A CN 102136093 A CN102136093 A CN 102136093A
- Authority
- CN
- China
- Prior art keywords
- writing
- checking
- document
- type
- write
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a cancel-after-verification realization method, which comprises the following steps of: acquiring a cancel-after-verification type; acquiring a self-defined matching basis according to the cancel-after-verification type; filtering a primary cancel-after-verification bill and an auxiliary cancel-after-verification bill in a database according to the acquired self-defined matching basis and/or a preset matching basis corresponding to the cancel-after-verification type; and performing cancel-after-verification on the filtered primary and auxiliary cancel-after-verification bills according to the preset cancel-after-verification basis. The embodiment of the invention also provides a corresponding system. By the technical scheme provided by the invention, equipment can filter bills in the database according to the self-defined matching basis, thereby making more humanized the cancel-after-verification process and more conveniently serving a user.
Description
Technical field
The present invention relates to management domain, be specifically related to a kind of method and system of checking and writing off realized.
Background technology
Checking and writing off is the process of document and document opening relationships, and the result who checks and writes off is that produced nucleus is write off record, and the purpose of checking and writing off is for the relevant document of retrography, perhaps carries out data analysis.For example: according to checking and writing off the cost of retrography storage bill as a result; Receivable list is checked and write off with charge slip, can analyze the remaining receivable single amount of money and the aging do not checked and not write off.Therefore, check and write off and bringing into play extremely important effect in business administration, obtaining and checking and writing off record is the critical function of ERP (ERP, Enterprise Resource Planning) system.
Realize in the prior art that the method for checking and writing off mainly comprises:
Steps A 1: obtain and check and write off type;
Wherein, the above-mentioned type of checking and writing off is by checking and writing off main body decision, as: receivablely singly belong to a kind of type of checking and writing off with checking and writing off of charge slip; Single and receivable single the checking and writing off of sale outbound belongs to another and checks and writes off type.Check and write off type and also just can know the main and auxiliary side of the checking and writing off information of checking and writing off when obtaining, wherein, the main and auxiliary side of checking and writing off information specifically can be: the main and auxiliary side of checking and writing off bill name also can be the main and auxiliary side of checking and writing off a document numbering etc.
Steps A 2: check and write off type corresponding branch set condition with default with this according to the type of obtaining of checking and writing off, be divided into one group with satisfying the master side of the checking and writing off document that divides set condition in the database and assisting the side's of checking and writing off document;
Wherein, check and write off the corresponding branch set condition of type with this in the steps A 2, also can be called " coupling foundation ".For example: identical with " client " field in the auxilliary side of the checking and writing off document as the coupling foundation with the main side of checking and writing off document, the master side of checking and writing off document that then " client " field is identical and the auxilliary side of checking and writing off document are divided into one group.It will be appreciated that the main side of checking and writing off checks and writes off according to being the different title of getting in order to distinguish the reconciliation both sides with auxilliary, be not meant that based on reconciliation one side, with another part of reconciliation be auxilliary.For example: receivable list is checked and write off with charge slip, with the receivable Dan Weizhu side of checking and writing off document; With charge slip is the auxilliary side of checking and writing off document.
Steps A 3:, the master side of checking and writing off document after the grouping and the auxilliary side of checking and writing off document are checked and write off according to the foundation of checking and writing off that is provided with.
Wherein, in the steps A 3 according to checking and writing off foundation, to by coupling according to and a group of filtering out comprises that the main side of checking and writing off document and the auxilliary side of checking and writing off document check and write off.Wherein, said checking and writing off according to referring to the condition that document is checked and write off.For example: be divided into one group receivable monokaryon charge slip, this checks and writes off the amount of money must be identical, just checks and writes off; Though perhaps this to check and write off the amount of money unequal, in the range of tolerable variance that allows, just can check and write off, Here it is checks and writes off foundation.
In research and practice process to prior art, the present inventor finds, the coupling foundation that normally will divide into groups by hard coded in the prior art writes in the source code, promptly the coupling of grouping foundation is to pre-set in the equipment, change source code if change the coupling of grouping according to needs, the operation of being carried out is very loaded down with trivial details.Therefore, can only check and write off according to the coupling foundation of systemic presupposition in the prior art, cause that checking and writing off of document had limitation.
Summary of the invention
The embodiment of the invention provides a kind of method and system of checking and writing off realized, having overcome in the prior art usually can only be according to the coupling of systemic presupposition according to the shortcoming of checking and writing off.
The embodiment of the invention provides a kind of method of checking and writing off of realizing, comprising:
Obtain and check and write off type; According to the described type of checking and writing off, be obtained from definition coupling foundation;
According to the self-defined coupling foundation of obtaining, and/or the coupling foundation corresponding with checking and writing off type that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively;
According to the foundation of checking and writing off that presets, the master side of checking and writing off document after filtering and the auxilliary side of the checking and writing off document after the filtration are checked and write off.
The embodiment of the invention also provides a kind of system of checking and writing off of realizing, comprising: the unit is checked and write off in database and realization, it is characterized in that, described realization is checked and write off the unit and specifically comprised: first acquiring unit, second acquisition unit, filter element and check and write off the unit;
Described first acquiring unit is used to obtain and checks and writes off type;
Described second acquisition unit is used for according to the type of obtaining of checking and writing off, and is obtained from definition coupling foundation;
Described filter element is used for according to the self-defined coupling foundation of obtaining, and/or the coupling foundation corresponding with checking and writing off type that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively;
The described unit of checking and writing off is used for according to the foundation of checking and writing off that presets, and the auxilliary folk prescription document of checking and writing off after the master after filtering is checked and write off document and filters is checked and write off.
The embodiment of the invention is obtained self-defining coupling foundation according to checking and writing off type; According to self-defining coupling foundation of obtaining and the coupling foundation corresponding obtained with checking and writing off type, the master side of checking and writing off document in the filtered data base and the auxilliary side of checking and writing off document respectively; According to checking and writing off foundation, two class documents after filtering are checked and write off.The equipment that makes can be according to self-defining coupling foundation, the document in the filtered data base, thus making that the process of checking and writing off is more humane, the more convenient user of being serves.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is that the embodiment of the invention one provides a kind of general flow chart of realizing the method for checking and writing off;
Fig. 2 is that the embodiment of the invention two provides a kind of general flow chart of realizing the method for checking and writing off;
Fig. 3 is the user interface that has comprised the query interface of dealing with single query interface and storage bill in the embodiment of the invention two;
Fig. 4 deals with single interface in the embodiment of the invention two;
Fig. 5 is storage bill interface in the embodiment of the invention two;
A kind of logical schematic that realizes the system of checking and writing off that Fig. 6 is that the embodiment of the invention three provides.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
Embodiment one,
The embodiment of the invention provides a kind of method of checking and writing off of realizing, as shown in Figure 1, this method comprises:
Step 1: obtain and check and write off type;
Wherein, the above-mentioned type of checking and writing off is by checking and writing off main body decision, as: receivablely singly belong to a kind of type of checking and writing off with checking and writing off of charge slip; Single and receivable single the checking and writing off of sale outbound belongs to another and checks and writes off type.Obtaining and checking and writing off type specifically can be to obtain the main and auxiliary side of the checking and writing off information of checking and writing off, and wherein, the main and auxiliary side of checking and writing off information specifically can be: the main and auxiliary side of checking and writing off bill name, the perhaps main and auxiliary side of checking and writing off document numbering etc.
Step 2:, be obtained from definition coupling foundation according to the type of obtaining of checking and writing off;
Wherein, actuating equipment get access to check and write off type after, obtain the self-defined coupling foundation corresponding of storage with checking and writing off type.Wherein, the field in the self-defined coupling foundation comprises at least: the field that is added with business semantics on master corresponding with checking and writing off type and/or the auxilliary side of the checking and writing off document.
Step 3: according to the self-defined coupling foundation that is provided with, and/or the coupling foundation corresponding with checking and writing off type that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively;
Wherein, in step 3 equipment get access to check and write off type after, the master side of checking and writing off document in the database and the auxilliary side of checking and writing off document are filtered respectively, and equipment to the condition that document in the database filters is: according to self-defining coupling with according to the default coupling foundation corresponding with checking and writing off type.Can only be in the prior art thereby overcome with the default coupling corresponding according to filtering with checking and writing off type, equipment can not be according to the User Defined coupling according to the master side of checking and writing off document in the database and the auxilliary side of checking and writing off document are filtered.
It will be appreciated that also after the filtration, the master side of the checking and writing off document and the auxilliary side of the checking and writing off document that satisfy above-mentioned filtercondition can be divided in one group.Be divided in one group owing to satisfy the master side of the checking and writing off document and the auxilliary side of the checking and writing off document of above-mentioned filtercondition after filtering, make things convenient for checking and writing off in the subsequent step 4.
Step 4:, the master side of checking and writing off document after filtering and the auxilliary side of the checking and writing off document after the filtration are checked and write off according to the foundation of checking and writing off that presets.
Wherein, the master after the filtration checks and writes off the auxilliary folk prescription document of checking and writing off after document and the filtration, satisfies self-defined coupling foundation and the coupling foundation corresponding with checking and writing off type.
Wherein, checking and writing off in the step 4 according to being meant the condition that document is checked and write off.For example: be divided into one group receivable list and charge slip, this checks and writes off the amount of money must be identical, just checks and writes off; Though perhaps this to check and write off the amount of money unequal, in the range of tolerable variance that allows, just can check and write off, Here it is checks and writes off foundation.In the step 4 according to the foundation of checking and writing off that is provided with, to the master after filtering check and write off document and filter after the auxilliary folk prescription document of checking and writing off check and write off, similar to prior art.
By above-mentioned a kind of explanation that realizes the method for checking and writing off that the embodiment of the invention is provided, this method can be obtained self-defining coupling foundation according to checking and writing off type; According to self-defining coupling foundation of obtaining and the coupling foundation corresponding obtained with checking and writing off type, the master side of checking and writing off document in the filtered data base and the auxilliary side of checking and writing off document respectively; According to checking and writing off foundation, two class documents after filtering are checked and write off.The equipment that makes can be according to self-defining coupling foundation, the document in the filtered data base, thus making that the process of checking and writing off is more humane, the more convenient user of being serves.
Further, this method can also comprise before step 2: self-defined coupling foundation is set.
Increase execution self-defined coupling foundation is set, this actuating equipment can be realized according to user's needs self-defined coupling foundation being set.
Further, a kind of method of checking and writing off of realizing that above-mentioned steps 1 to step 4 has realized that inventive embodiments provides also needs to illustrate, this method in step 2, be obtained from the definition coupling according to before, this method can also comprise:
Step 1a: to checking and writing off the master side of the checking and writing off document in the type and/or assisting the field that is added with business semantics on the side's of checking and writing off document;
Wherein, the above-mentioned said field that business semantics is arranged can be meant to allow the field of filtering and showing on document tabulation when preface (perhaps book) interface.For example: " document coding " has business semantics to the user, and " document ID " then do not have business semantics, and be meaningful to actuating equipment because document ID is the unique number that is used for discerning document that system automatically generates, and be nonsensical to business.
Need to prove that the field that business semantics is arranged of interpolation may be displayed on the user interface, as a filtercondition of follow-up filter operation.
Be obtained from definition coupling foundation among the above-mentioned steps 1b, specifically can comprise:
If checking and writing off the field that is added with business semantics on the master side of checking and writing off document in the type and/or the auxilliary side of the checking and writing off document is text type-word section, then field on field on the master side of the checking and writing off document and the auxilliary side of the checking and writing off document is provided with corresponding identical, as self-defined coupling foundation.
For example: add field " summary " on the main side of the checking and writing off document, add field " reference information " on the auxilliary side of the checking and writing off document, it is identical that the user can be provided with these two fields, as self-defining coupling foundation.
If checking and writing off the master side of the checking and writing off document in the type and/or assisting the field that is added with business semantics on the side's of checking and writing off document is the numeric type field, then be provided with field on field on the master side of the checking and writing off document and the auxilliary side of the checking and writing off document identical, perhaps setting meets computational logic, as self-defined coupling foundation.
For example: add field A on the main side of the checking and writing off document, add field C on the auxilliary side of the checking and writing off document, it is identical that the user can be provided with these two numerical value type-word sections, that is: field A=field C; The user also can be provided with simple computational logic, as: field A+ field B=field C, wherein, field B can be the field that always exists on the main side of the checking and writing off document.The user can select to be provided with the relation between the field on the main and auxiliary side of the checking and writing off document according to actual conditions.
Make this method can realize being provided with self-defined coupling foundation by increasing above-mentioned steps 1a and step 1b, the self-defined coupling after being provided with is according to can be used as the follow-up middle use of checking and writing off.
Further, be obtained from definition coupling foundation in this method step 2, can be because execution in step 1a and step 1b are set in the equipment, also can be, before execution in step 2, execution is provided with self-defined coupling foundation, wherein, the self-defined coupling of setting according in can the main side of checking and writing off document and the existing field of the auxilliary side of checking and writing off document be provided with in the type according to checking and writing off.
Further, this method not only can realize above-mentioned checking and writing off, and the result who checks and writes off can also be shown to the user.Therefore, this method also comprises:
Step 5: show and check and write off the result, wherein, checking and writing off among the result of demonstration comprises at least: this checks and writes off quantity and/or this checks and writes off the amount of money.
Check and write off the result by demonstration, be convenient to the user checking and writing off the analysis of back data, significant to the management of enterprise.
Further, if in step 2, when equipment got access to self-defining coupling according to more than one, this method can also comprise before execution in step 3:,
Step 6: when the self-defined coupling of obtaining according to more than one the time, select a coupling foundation.
Wherein, a coupling of step 6 selection is according to a condition as filtration in the subsequent step 3.Equipment can be coupling foundation of selection at random or order, also can point out the user, selects a coupling foundation by the instruction of user's input.
By selecting a coupling foundation, make the speed of equipment when the method that this realization of execution is checked and write off improve greatly.
Embodiment two,
The embodiment of the invention provides a kind of method of checking and writing off of realizing, this method is similar to the method that the realization that embodiment one provides is checked and write off, and this method is based on the basis of embodiment one, specifies the method for checking and writing off of dealing with list and storage bill.Referring to shown in Figure 2, this method comprises:
Steps A 1: obtaining and checking and writing off type is to deal with checking and writing off of list and storage bill;
Steps A 2:, be obtained from definition coupling foundation according to checking and writing off type;
Need to prove, comprised the query interface of dealing with single query interface and storage bill as shown in Figure 3 in the user interface.The user can call as required and deal with single query interface, perhaps calls the query interface of storage bill.Wherein, in the query interface of dealing with list or storage bill, comprise: condition tab and self-defined tab.Condition tab or self-defined tab can be used for filtering.In the condition tab field that often is used as filtercondition, as: document date, encoder client etc.; Self-defined tab comprises all visible fields on the document display interface, can be used as filtercondition.The user can give equipment by the self-defining coupling foundation of interface input as shown in Figure 3, as self-defining coupling foundation.
Do not demonstrate the filtercondition that the user needs on list or the storage bill if deal with, this equipment can also be provided with according to the user, is added with the field of business semantics in the document tabulation.Shown in Fig. 4,5, equipment is according to user's input, can add " traffic identification sign indicating number " field on list and the storage bill dealing with respectively, and equipment is provided with self-defining coupling according to being: deal with " traffic identification sign indicating number " field value that single " traffic identification sign indicating number " field value equals storage bill.
Steps A 3: check and write off the corresponding coupling foundation of type according to the self-defining coupling foundation of obtaining in the steps A 2 with steps A 1 is obtained, deal with list and storage bill in the filtered data base respectively;
For the ease of the explanation of understanding be, with obtain with steps A 1 check and write off the corresponding coupling of type according to specifically being: deal with " supplier " field value of single " supplier " field value=storage bill, and deal with " material " field value of single " material " field value=storage bill.Check and write off the corresponding coupling of type according to can setting in advance with steps A 1 is obtained, just can know corresponding coupling foundation after checking and writing off type having known.
Among the above-mentioned steps A3, to dealing with in the condition that list and storage bill filter in the database: self-defining coupling according to the coupling corresponding with checking and writing off type according between be " with " relation, after all satisfying these two filterconditions, after the accessed filtration deal with single and filter after storage bill between checking and writing off in just can execution in step A4.Wherein, deal with deal with list/storage bill that storage bill list/filtration after be meant the coupling foundation that respectively satisfy above-mentioned self-defined coupling foundation and check and write off type correspondence after the said filtration here.
Do not satisfy above-mentioned two coupling foundations if deal with list or storage bill, then can not check and write off.For example:
Storage bill 001, supplier is A, material is a first; Quantity is 100, and the traffic identification sign indicating number is " the other side 777 ";
Deal with list 001, supplier is A, and material is a first; Quantity is 100, and the traffic identification sign indicating number is " other ";
Because different with the traffic identification sign indicating number of dealing with in single 001 in the storage bill 001, storage bill 001 001 can not be checked and write off with dealing with singly.
Steps A 4: according to the foundation of checking and writing off that is provided with, to dealing with after filtering single and filter after storage bill check and write off; Wherein, the master after the filtration checks and writes off the auxilliary folk prescription document of checking and writing off after document and the filtration, satisfies self-defined coupling foundation and the coupling foundation corresponding with checking and writing off type.
Wherein, checking and writing off according to being meant in the steps A 4 specifically can be the condition that document is checked and write off: this that deal with that single this check and write off that quantity equals storage bill checked and write off quantity (that is: this that deal with that single this check and write off quantity=storage bill checked and write off quantity).In the steps A 4 according to the foundation of checking and writing off that is provided with, to dealing with after filtering single and filter after storage bill check and write off, can be similar to prior art.
By above-mentioned a kind of explanation that realizes the method for checking and writing off that the embodiment of the invention is provided, this method can be obtained self-defining coupling foundation according to checking and writing off type; According to self-defining coupling foundation of obtaining and the coupling foundation that preset corresponding obtained with checking and writing off type, the master side of checking and writing off document in the filtered data base and the auxilliary side of checking and writing off document respectively; According to checking and writing off foundation, two class documents after filtering are checked and write off.The equipment that makes can be according to self-defining coupling foundation, the document in the filtered data base, thus making that the process of checking and writing off is more humane, the more convenient user of being serves.
Need to prove that also if the self-defined coupling of obtaining is according to comprising text type-word section, then after the steps A 2, before the steps A 3, this method also comprises:
Steps A 5: to going to the space before and after the text type-word section;
Then steps A 3, specifically comprise:
According to the self-defined coupling foundation of going the text type-word section behind the space before and after comprising, and/or the coupling foundation of checking and writing off the type correspondence that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively.
Wherein, equipment execution in step A5 can be the demand according to the user, selects the function to going to the space before and after the text type-word section.The user also can close this function, but steps A 5 is selection operations.
Make the concrete error correcting capability of actuating equipment by increasing above-mentioned steps A5, also can discern, improved the degree of intelligence of equipment wrong the text field of user's input.
Embodiment three,
Present embodiment provides a kind of system of checking and writing off of realizing, as shown in Figure 6, this system comprises: unit 30 is checked and write off in database 10 and realization, checks and writes off the unit and specifically can comprise: first acquiring unit 301, second acquisition unit 302, filter element 303 and check and write off unit 304.
Wherein, database 10 is same as the prior art, is technique known.
First acquiring unit 301 is used for checking and writing off type according to obtaining;
Wherein, the above-mentioned type of checking and writing off is by checking and writing off main body decision, as: receivablely singly belong to a kind of type of checking and writing off with checking and writing off of charge slip; Single and receivable single the checking and writing off of sale outbound belongs to another and checks and writes off type.Obtaining and checking and writing off type specifically can be to obtain the main and auxiliary side of the checking and writing off information of checking and writing off, and wherein, the main and auxiliary side of checking and writing off information specifically can be: the main and auxiliary side of checking and writing off bill name also can be the main and auxiliary side of checking and writing off a document numbering etc.
Wherein, the condition that document filters in 303 pairs of databases of filter element is: according to self-defining coupling with according to the default coupling foundation corresponding with checking and writing off type.Can only be in the prior art thereby overcome with the default coupling corresponding according to filtering with checking and writing off type, equipment can not be according to self-defined coupling according to the master side of checking and writing off document in the database and the auxilliary side of checking and writing off document are filtered.
It will be appreciated that also after the filtration, the master side of the checking and writing off document and the auxilliary side of the checking and writing off document that satisfy above-mentioned filtercondition can be divided in one group.Be divided in one group owing to satisfy the master side of the checking and writing off document and the auxilliary side of the checking and writing off document of above-mentioned filtercondition after filtering, make things convenient for checking and writing off in the subsequent step 4.
Check and write off unit 304, be used for according to the foundation of checking and writing off that presets, the auxilliary folk prescription document of checking and writing off after the master after filtering is checked and write off document and filters is checked and write off.
Wherein, the master after the filtration checks and writes off the auxilliary folk prescription document of checking and writing off after document and the filtration, satisfies self-defined coupling foundation and/or the coupling foundation corresponding with checking and writing off type.
Wherein, above-mentioned checking and writing off according to being meant the condition that document is checked and write off.For example: be divided into one group receivable list and charge slip, this checks and writes off the amount of money must be identical, just checks and writes off; Though perhaps this to check and write off the amount of money unequal, in the range of tolerable variance that allows, just can check and write off, Here it is checks and writes off foundation.Check and write off in the unit 304 according to the foundation of checking and writing off that is provided with, to the master after filtering check and write off document and filter after the auxilliary folk prescription document of checking and writing off check and write off, similar to prior art.
Also need to prove, database 10 is respectively at first acquiring unit of realizing checking and writing off in the unit 30 301, second acquisition unit 302, filter element 303 and is checked and write off unit 304 and is linked to each other respectively, wherein, first acquiring unit 301, second acquisition unit 302, filter element 303 and to check and write off unit 304 all be that the data in the database 10 are operated accordingly.
By above-mentioned a kind of explanation that realizes the system of checking and writing off that the embodiment of the invention is provided, second acquisition unit can obtain self-defining coupling foundation in this system; Self-defining coupling foundation that filter element 303 bases are obtained and the coupling foundation of obtaining corresponding, the master side of checking and writing off document in the filtered data base and the auxilliary side of checking and writing off document respectively with checking and writing off type; Check and write off unit 304 according to checking and writing off foundation, the document after filtering is checked and write off.The equipment that makes can be according to self-defining coupling foundation, the document in the filtered data base, thus making that the process of checking and writing off is more humane, the more convenient user of being serves.
Further, can also comprise in this system:
By increasing display unit 40, make this system to show and check and write off the result, be convenient to the user to checking and writing off the analysis of back data, significant to the management of enterprise.
Further, this system can comprise: adding device 50 and unit 60 is set;
Wherein, adding device 50 is used for being added with the field of business semantics on the master side of the checking and writing off document of checking and writing off type and/or the auxilliary side of the checking and writing off document;
Need to prove that the field that business semantics is arranged of interpolation may be displayed on the user interface, as a filtercondition of follow-up filter operation.
It will be appreciated that also the above-mentioned said field that business semantics is arranged can be meant to allow the field of filtering and showing on document tabulation when preface (perhaps book) interface.For example: " document coding " has business semantics to the user, and " document ID " then do not have business semantics, and be meaningful to actuating equipment because document ID is the unique number that is used for discerning document that system automatically generates, and be nonsensical to the user.
If being added with the field of business semantics on the main side's of checking and writing off document and/or the auxilliary side of the checking and writing off document is text type-word section, then be provided with the unit be used for field on field on the master side of the checking and writing off document and the auxilliary side of the checking and writing off document is provided with corresponding identical, as self-defined coupling foundation.
For example: add field " summary " on the main side of the checking and writing off document, add field " reference information " on the auxilliary side of the checking and writing off document, it is identical that the user can be provided with these two fields, as self-defining coupling foundation.
If being added with the field of business semantics on the main side's of checking and writing off document and/or the auxilliary side of the checking and writing off document is the numeric type field, the unit then is set to be used for being provided with field on field on the master side of the checking and writing off document and the auxilliary side of the checking and writing off document identical, perhaps setting meets computational logic, as self-defined coupling foundation.
For example: add field A on the main side of the checking and writing off document, add field C on the auxilliary side of the checking and writing off document, it is identical that the user can be provided with these two numerical value type-word sections, that is: field A=field C; The user also can be provided with simple computational logic, as: field A+ field B=field C, wherein, field B can be the field that always exists on the main side of the checking and writing off document.The user can select to be provided with the relation between the field on the main and auxiliary side of the checking and writing off document according to actual conditions.
By increasing above-mentioned adding device and the unit being set, make this system have the function that self-defined coupling foundation is set.
Further, the above-mentioned unit 60 that is provided with also can be used to be provided with self-defined coupling foundation, wherein, the self-defined coupling of setting according in can the main side of checking and writing off document and the existing field of the auxilliary side of checking and writing off document be provided with in the type according to checking and writing off.
Further, realize in this system that checking and writing off unit 30 can also comprise:
Wherein, selected cell 305 specifically can be coupling foundation of selection at random or order, also can be to select a coupling foundation according to the instruction of user's input.
By increasing selected cell 305, improve the speed of system when checking and writing off greatly.
One of ordinary skill in the art will appreciate that all or part of step in the whole bag of tricks of the foregoing description is to instruct relevant hardware to finish by program, this program can be stored in the computer-readable recording medium, and storage medium can comprise: ROM, RAM, disk or CD etc.
More than a kind of method and system of checking and writing off of realizing that the embodiment of the invention provided is described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (11)
1. the method that realization is checked and write off is characterized in that, comprising:
Obtain and check and write off type; According to the described type of checking and writing off, be obtained from definition coupling foundation;
According to the self-defined coupling foundation of obtaining, and/or the coupling foundation corresponding with checking and writing off type that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively;
According to the foundation of checking and writing off that presets, the master side of checking and writing off document after filtering and the auxilliary side of the checking and writing off document after the filtration are checked and write off.
2. method according to claim 1 is characterized in that, and is described according to the described type of checking and writing off, and is obtained from before the definition coupling foundation, and described method also comprises:
Self-defined coupling foundation is set.
3. method according to claim 2 is characterized in that, describedly self-defined coupling is set according to specifically comprising: check and write off the main side of checking and writing off document and the existing field of the auxilliary side of checking and writing off document in the type according to described, self-defined coupling foundation is set.
4. method according to claim 2 is characterized in that, the described setting before the self-defined coupling foundation, and described method also comprises:
To being added with the field of business semantics on the described master side's of checking and writing off document and/or the auxilliary side of the checking and writing off document;
Then describedly self-defined coupling is set according to specifically comprising:
If described to check and write off the field that is added with business semantics on the master side of checking and writing off document in the type and/or the auxilliary side of the checking and writing off document be text type-word section, then field on field on the described master side of the checking and writing off document and the described auxilliary side of the checking and writing off document is provided with corresponding identical, as self-defined coupling foundation;
If described to check and write off the field that is added with business semantics on the master side of checking and writing off document in the type and/or the auxilliary side of the checking and writing off document be the numeric type field, then be provided with field on field on the described master side of the checking and writing off document and the described auxilliary side of the checking and writing off document identical, perhaps setting meets computational logic, as self-defined coupling foundation.
5. method according to claim 1, it is characterized in that, the described self-defined coupling foundation of obtaining, comprise text type-word section, then described being obtained from after the definition coupling foundation, before the master side of checking and writing off document in the described filtered data base respectively and the auxilliary side of the checking and writing off document in the database, described method also comprises:
To going to the space before and after the text type-word section;
The self-defined coupling foundation that described basis is obtained, and/or the coupling foundation corresponding that presets with checking and writing off type, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively specifically comprise:
According to the self-defined coupling foundation of going the text type-word section behind the space before and after comprising, and/or the coupling foundation corresponding with checking and writing off type that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively.
6. method according to claim 1 is characterized in that, described auxilliary to the master side of the checking and writing off document after filtering and after filtering checked and write off after the folk prescription document checks and writes off, and described method also comprises:
Show and check and write off the result, comprise at least among the described result of checking and writing off: this checks and writes off quantity and/or this checks and writes off the amount of money.
7. method according to claim 1 is characterized in that, described when the self-defined coupling of obtaining according to more than one the time, described method also comprises:
Select a coupling foundation.
8. the system that realization is checked and write off is characterized in that, comprising: the unit is checked and write off in database and realization, it is characterized in that, described realization is checked and write off the unit and specifically comprised: first acquiring unit, second acquisition unit, filter element and check and write off the unit;
Described first acquiring unit is used to obtain and checks and writes off type;
Described second acquisition unit is used for according to the type of obtaining of checking and writing off, and is obtained from definition coupling foundation;
Described filter element is used for according to the self-defined coupling foundation of obtaining, and/or the coupling foundation corresponding with checking and writing off type that presets, the master side of checking and writing off document in the filtered data base and the auxilliary side of the checking and writing off document in the database respectively;
The described unit of checking and writing off is used for according to the foundation of checking and writing off that presets, and the auxilliary folk prescription document of checking and writing off after the master after filtering is checked and write off document and filters is checked and write off.
9. system according to claim 8 is characterized in that, described system also comprises: adding device and the unit is set;
Described adding device is used for checking and writing off the master side of the checking and writing off document of type and/or assisting the field that is added with business semantics on the side's of checking and writing off document described;
The described unit that is provided with, being used for describedly checking and writing off the master side of the checking and writing off document of type and/or assisting the field that is added with business semantics on the side's of checking and writing off document is text type-word section, then described be provided with the unit specifically be used for field on field on the described master side of the checking and writing off document and the described auxilliary side of the checking and writing off document is provided with corresponding identical, as self-defined coupling foundation;
To check and write off the field that is added with business semantics on the master side of checking and writing off document in the type and/or the auxilliary side of the checking and writing off document be the numeric type field when described, the then described unit that is provided with specifically is used for being provided with field on field on the described master side of the checking and writing off document and the described auxilliary side of the checking and writing off document identical, perhaps setting meets computational logic, as self-defined coupling foundation.
10. system according to claim 8 is characterized in that, described system also comprises: display unit is used for showing and checks and writes off the result that comprise at least among the described result of checking and writing off: this checks and writes off quantity and/or this checks and writes off the amount of money.
11. system according to claim 8 is characterized in that, described realization is checked and write off the unit and is also comprised: selected cell, be used for when the self-defined coupling of obtaining according to more than one the time, select a coupling foundation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101034558A CN102136093A (en) | 2010-01-26 | 2010-01-26 | Cancel-after-verification realization method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101034558A CN102136093A (en) | 2010-01-26 | 2010-01-26 | Cancel-after-verification realization method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102136093A true CN102136093A (en) | 2011-07-27 |
Family
ID=44295872
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010101034558A Pending CN102136093A (en) | 2010-01-26 | 2010-01-26 | Cancel-after-verification realization method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102136093A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103116815A (en) * | 2011-11-16 | 2013-05-22 | 航天信息软件技术有限公司 | Method and device for accounting materials consumed by subcontracting |
| CN104463665A (en) * | 2014-12-11 | 2015-03-25 | 江苏爱信诺航天信息科技有限公司 | Method for conducting storage analyzing on general invoice data |
| CN108961035A (en) * | 2018-05-29 | 2018-12-07 | 阿里巴巴集团控股有限公司 | A kind of aging analysis of accounts method and apparatus at business transition family |
| CN110033153A (en) * | 2018-12-05 | 2019-07-19 | 阿里巴巴集团控股有限公司 | A kind of pair of information recommendation carries out resource bonusing method, device and equipment |
| CN110246014A (en) * | 2019-05-06 | 2019-09-17 | 阿里巴巴集团控股有限公司 | Bill checks and writes off dispatching method, device and server |
| CN110503543A (en) * | 2019-09-02 | 2019-11-26 | 山东浪潮通软信息科技有限公司 | Automatically the realization method and system of bank settlement is checked and write off in Enterprise creditor's rights debt management |
| CN110750692A (en) * | 2019-10-15 | 2020-02-04 | 上海瀚之友信息技术服务有限公司 | Invoice automatic verification and sale computer processing method and device |
| CN111192584A (en) * | 2019-12-11 | 2020-05-22 | 秒针信息技术有限公司 | Document verification and cancellation method and system |
| WO2021072943A1 (en) * | 2019-10-14 | 2021-04-22 | 益萃网络科技（中国）有限公司 | Financial data management method and apparatus, computer device and storage medium |
| CN112750026A (en) * | 2020-12-30 | 2021-05-04 | 山东浪潮通软信息科技有限公司 | Dynamic expansion method, device and medium for service matching core-cancellation framework |
| CN113988773A (en) * | 2020-07-09 | 2022-01-28 | 顺丰科技有限公司 | Certificate verification method, device, server and storage medium |
| CN114493821A (en) * | 2022-04-18 | 2022-05-13 | 深圳高灯计算机科技有限公司 | Data verification and cancellation method and device, computer equipment and storage medium |
-
2010
- 2010-01-26 CN CN2010101034558A patent/CN102136093A/en active Pending
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103116815A (en) * | 2011-11-16 | 2013-05-22 | 航天信息软件技术有限公司 | Method and device for accounting materials consumed by subcontracting |
| CN104463665A (en) * | 2014-12-11 | 2015-03-25 | 江苏爱信诺航天信息科技有限公司 | Method for conducting storage analyzing on general invoice data |
| CN104463665B (en) * | 2014-12-11 | 2017-11-14 | 航天信息江苏有限公司 | A kind of method that common invoice data are carried out with storing and resolving |
| CN108961035A (en) * | 2018-05-29 | 2018-12-07 | 阿里巴巴集团控股有限公司 | A kind of aging analysis of accounts method and apparatus at business transition family |
| CN108961035B (en) * | 2018-05-29 | 2021-10-26 | 创新先进技术有限公司 | Account age analysis method and device for business transition account |
| CN110033153A (en) * | 2018-12-05 | 2019-07-19 | 阿里巴巴集团控股有限公司 | A kind of pair of information recommendation carries out resource bonusing method, device and equipment |
| CN110246014B (en) * | 2019-05-06 | 2023-04-07 | 创新先进技术有限公司 | Bill verification and cancellation scheduling method and device and server |
| CN110246014A (en) * | 2019-05-06 | 2019-09-17 | 阿里巴巴集团控股有限公司 | Bill checks and writes off dispatching method, device and server |
| CN110503543A (en) * | 2019-09-02 | 2019-11-26 | 山东浪潮通软信息科技有限公司 | Automatically the realization method and system of bank settlement is checked and write off in Enterprise creditor's rights debt management |
| WO2021072943A1 (en) * | 2019-10-14 | 2021-04-22 | 益萃网络科技（中国）有限公司 | Financial data management method and apparatus, computer device and storage medium |
| CN110750692A (en) * | 2019-10-15 | 2020-02-04 | 上海瀚之友信息技术服务有限公司 | Invoice automatic verification and sale computer processing method and device |
| CN110750692B (en) * | 2019-10-15 | 2023-06-27 | 上海瀚之友信息技术服务有限公司 | Automatic invoice verification computer processing method and device |
| CN111192584A (en) * | 2019-12-11 | 2020-05-22 | 秒针信息技术有限公司 | Document verification and cancellation method and system |
| CN113988773A (en) * | 2020-07-09 | 2022-01-28 | 顺丰科技有限公司 | Certificate verification method, device, server and storage medium |
| CN112750026B (en) * | 2020-12-30 | 2023-01-24 | 山东浪潮通软信息科技有限公司 | Dynamic extensible method, device and medium for service matching core-cancellation framework |
| CN112750026A (en) * | 2020-12-30 | 2021-05-04 | 山东浪潮通软信息科技有限公司 | Dynamic expansion method, device and medium for service matching core-cancellation framework |
| CN114493821A (en) * | 2022-04-18 | 2022-05-13 | 深圳高灯计算机科技有限公司 | Data verification and cancellation method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102136093A (en) | Cancel-after-verification realization method and system | |
| US20160004728A1 (en) | Method, system, and computer program product for managing business customer contacts | |
| US9075800B2 (en) | Context switching in a business application | |
| CN109472609B (en) | Wind control reason determining method and device | |
| US20100318926A1 (en) | User interface for entering account dimension combinations | |
| CN104866576A (en) | Method and apparatus for automatically constructing Data Vault-modeled data warehouse | |
| CN108256113A (en) | The method for digging and device of data genetic connection | |
| CN103294966A (en) | Security access control method and system of database | |
| CN101901262A (en) | Object-oriented model-based enterprise database construction and service data display method | |
| GB2509090A (en) | An extract-transform-load (ETL) processor controller indicates a degree of preferredness of a proposed placement of data | |
| CN103226610A (en) | Method and device for querying database table | |
| CN108038125B (en) | Method, device, equipment and storage medium for automatically comparing fund system test values | |
| CN104123104B (en) | Daily record control system and method | |
| CN103927181A (en) | Weather data displaying method and device | |
| CN104050206A (en) | Material bill rapid exporting method and system thereof | |
| CN101710347A (en) | Method and device for processing data in data table | |
| CN104536897A (en) | Automatic testing method and system based on keyword | |
| US20060218060A1 (en) | Accounting method and system | |
| CN106339503B (en) | Interactive display method based on elements and relations | |
| US20230014348A1 (en) | Data enrichment and matching | |
| CN102855288A (en) | Method and device for processing difference data | |
| US6581064B1 (en) | Software tool for creating databases | |
| Musat et al. | Factorizable maps and traces on the universal free product of matrix algebras | |
| CN104866487A (en) | Method and device for refreshing wide table | |
| CN111309749A (en) | Policy information processing method, policy information processing device, policy information processing equipment and policy information processing medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110727 |