CN101334794A - Method and device for creating invoice filtrating condition - Google Patents

Method and device for creating invoice filtrating condition Download PDF

Info

Publication number
CN101334794A
CN101334794A CNA2008101354703A CN200810135470A CN101334794A CN 101334794 A CN101334794 A CN 101334794A CN A2008101354703 A CNA2008101354703 A CN A2008101354703A CN 200810135470 A CN200810135470 A CN 200810135470A CN 101334794 A CN101334794 A CN 101334794A
Authority
CN
China
Prior art keywords
condition
field
filtrating
invoice
document
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CNA2008101354703A
Other languages
Chinese (zh)
Inventor
高玉宏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CNA2008101354703A priority Critical patent/CN101334794A/en
Publication of CN101334794A publication Critical patent/CN101334794A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a document filtering condition generation method including the following steps: field rows matching document fields needing to be involved in filtering are arranged according to required document filtering conditions; logic relations between the filed rows are selected and field values of the document fields are defined; the document filtering condition is generated according to the field values and the logic relations; furthermore, the documents to be filtered can be filtered according to the document filtering conditions. With the method of the invention, users can fill corresponding field value in the field row according to the filtering conditions after arranging the fields involved in filtering so as to reduce the redundancy of arranging the logic relation definitions between document fields involved in filtering and further to enhance the usability of arranging filtering conditions when the documents are filtered under a complex condition. The invention also provides an apparatus generating the document filtering conditions.

Description

A kind of method and device that generates invoice filtrating condition
Technical field
The present invention relates to the database processing field, particularly relate to a kind of method and device that generates invoice filtrating condition.
Background technology
Enterprise resource planning (Enterprise Resource Planning, ERP), be meant and be based upon on the infotech basis, all resources (logistics, cash flow, information flow or human resources) to enterprise are integrated integrated management, adopt information-based means to realize enterprise's supply and marketing chain management, thereby reach the purpose that each link on the supply chain is realized scientific management.In ERP system, need to generate various types of documents as business voucher, can be by duplicating the single document that generates of order, invoice or outbound, for example invoice for sales can generate by duplicating sales order.The user needs different entry in many documents and the document is filtered sometimes, to carry out the business processing of different demands.For example, in the application of marketing system, can be that invoice filtrating condition filters with a plurality of sales orders numbering and name of material during filtration, filter out the document that meets filtercondition, unify shipment then and manage business etc.
In existing EPR system or the application of other software systems, in the process that document filters, generate invoice filtrating condition implementation procedure can for: at first can be being provided with on the interface that document filters, by row relevant comparison is set, and the logical relation of interfield, and on described interface, insert field and the field value that needs filtration, last according to the field contents generation invoice filtrating condition of being inserted.But, when filtercondition is set, if under the situation that filtercondition has much and data volume is bigger, for example, when the filtercondition more complicated, multirow and multi-column data need be set, with reference to figure 1, show in the filtercondition of complexity, filtercondition is provided with the interface synoptic diagram.As can be seen from Figure 1, under the bigger situation of the data volume of setting, " title " row need all be set in each row, be business paper field row, comprise filtrable all fields of business paper, and being provided with each time all needs to reselect, as the numbering of the document among Fig. 1, name of material etc.; Simultaneously, " logic " of every row relation also needs to re-define, for example, shown in Fig. 1 " and ", " perhaps ", further, the user also needs to define parenthesis matching and comparison etc.
1 as can be seen in conjunction with the accompanying drawings, in the process that document is filtered, if filtercondition more complicated, need the data volume set just bigger so, for example, the user need repeat setting " title ", need repeat input " document numbering " and fields such as " names of material " at title one row, the input that repeats makes the process redundance of user definition filtercondition higher, further, has also increased the degree of difficulty of user's operation.
In a word, need the urgent technical matters that solves of those skilled in the art to be exactly at present: how can propose a kind of method that generates invoice filtrating condition, the high problem of redundance when in the document filter process, generating complicated filtercondition in order to solve.
Summary of the invention
Technical matters to be solved by this invention provides a kind of method that generates invoice filtrating condition, the high problem of redundance when defining complicated filtercondition in the document filter process in order to solve, further, can also solve the problem of ease for use difference in user's operating process.
Another object of the present invention is that above-mentioned design is applied in the concrete applied environment, and a kind of device of document filtration is provided, thereby guarantees the realization and the application of this method.
For solving the problems of the technologies described above, the embodiment of the invention provides a kind of method that generates invoice filtrating condition, comprising:
According to required invoice filtrating condition, be provided with and the corresponding field row of receipt field that need to participate in filtration;
Select the logical relation between the described field row, and determine the field value of described receipt field;
Generate invoice filtrating condition according to described field value and logical relation.
Preferably, described field value of described foundation and logical relation generation invoice filtrating condition comprises:
Time conditions according to described field value, logical relation and document generates invoice filtrating condition.
Preferably, described field value of described foundation and logical relation generation invoice filtrating condition comprises:
Generate document according to described field value and logical relation and cross the filter condition;
With at least two documents cross the filter condition according to or relation, generate invoice filtrating condition.
Preferably, described setting comprises with the corresponding field row of receipt field that need to participate in filtering:
Participate in the receipt field of filtration as required, the number of field row is set;
Reference position at the respective field row is provided with the receipt field that needs participate in filtration.
Preferably, described method also comprises:
According to invoice filtrating condition, document to be filtered is filtered.
Preferably, described according to invoice filtrating condition, document to be filtered filtered comprise:
The invoice filtrating condition combination is generated peek Structured Query Language (SQL) SQL;
According to described peek SQL document to be filtered is filtered.
Preferably, it is characterized in that described method is applied in the ERP system.
The embodiment of the invention also provides a kind of device that generates invoice filtrating condition, comprising:
Module is set,, is provided with and the corresponding field row of receipt field that need to participate in filtration according to required invoice filtrating condition;
Select module, be used to select the logical relation between the described field row;
Determination module is used for determining the field value of described receipt field;
Generation module is used for generating invoice filtrating condition according to described field value and logical relation.
Preferably, described generation module comprises:
First generates submodule, is used for generating document according to described field value and logical relation and crosses the filter condition;
Second generates submodule, be used for at least two documents cross the filter condition according to or relation, generate invoice filtrating condition.
Preferably, the described module that is provided with comprises:
First is provided with submodule, is used for participating in as required the receipt field of filtering, and the number of field row is set;
Second is provided with submodule, is used in the reference position of respective field row the receipt field that needs participate in filtration being set.
Preferably, described device also comprises:
Filtering module is used for according to invoice filtrating condition, and document to be filtered is filtered.
Preferably, described filtering module comprises:
The 3rd generates submodule, is used for the invoice filtrating condition combination is generated peek SQL;
Filter submodule, be used for document to be filtered being filtered according to described peek SQL.Compared with prior art, the present invention has the following advantages:
The present invention at first is provided with the field that needs to participate in filtering and is listed as according to required invoice filtrating condition, receipt field to be filtered is added in the described field row again, and determines the field value of described field; Select the logical relation between the described field row then, and set the fixed relationship between the row of described field value; And according to described logical relation and fixed relationship generation invoice filtrating condition; Last according to described invoice filtrating condition and other conditions that needs, document to be filtered is filtered; Make that the user can be under the suitable complicated situation of filtercondition, by being set, the field that needs to participate in filtering is listed as, for the field in the described field row is determined field value, and select logical relation between the described field row, and the fixed relationship between the row of field value in the field row, thereby avoided repeating to be provided with the process of field and field value, avoided because the very redundant problem of process of the more feasible definition filtercondition of data volume, further, also promoted the ease for use of user's definition filtercondition when filtering document.
Description of drawings
Fig. 1 is provided with the interface synoptic diagram under the filtercondition complicated in the prior art;
Fig. 2 is a kind of process flow diagram that generates the method embodiment 1 of invoice filtrating condition of the present invention;
Fig. 3 is a kind of process flow diagram that generates the method embodiment 2 of invoice filtrating condition of the present invention;
Fig. 4 is the interface synoptic diagram that invoice filtrating condition is set in the object lesson of the present invention;
Fig. 5 is a kind of structured flowchart that generates the device preferred embodiment of invoice filtrating condition of the present invention;
Fig. 6 uses preferred embodiment shown in Figure 5 to generate invoice filtrating condition, and carries out the process flow diagram that document filters according to described invoice filtrating condition.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
The present invention can be used in numerous general or special purpose computingasystem environment or the configuration.For example: personal computer, server computer, handheld device or portable set, plate equipment, multicomputer system, comprise distributed computing environment of above any system or equipment or the like.
The present invention can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract, program, object, assembly, data structure or the like.Also can in distributed computing environment, put into practice the present invention, in these distributed computing environment, by by communication network connected teleprocessing equipment execute the task.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium that comprises memory device.
With reference to figure 2, show a kind of process flow diagram that generates the method embodiment 1 of invoice filtrating condition of the present invention, can may further comprise the steps:
Step 201:, be provided with and the corresponding field row of receipt field that need to participate in filtration according to required invoice filtrating condition;
Step 202: select the logical relation between the described field row, and determine the field value of described receipt field;
Step 203: generate invoice filtrating condition according to described field value and logical relation.
In the present embodiment, consider user's demand generally speaking, can described field row number be set to 3, wherein, described logical relation can comprise and logic, and perhaps or logic, described method can be applied in the ERP system, also can be applied in other operation systems, the present invention need not to make qualification to this.
As can be seen, present embodiment is specially the receipt field that participates in filtration at first as required by being provided with and the corresponding field row of the receipt field that need participate in filtering, and the number of field row is set; Reference position at the respective field row is provided with the receipt field that needs participate in filtration then, can required field can be added directly in the described field row when filtering document, and determine field value for described receipt field, the user is just once set can be reused, thereby reduced business paper and gathered the redundancy of the logical relation definition between the field of filtering, further, can also promote the ease for use that the set of complicated business document is filtered, reduce the complicacy of the filtercondition definition of different business logic in certain set of circumstances of same business paper.
With reference to figure 3, show a kind of process flow diagram that generates the method embodiment 2 of invoice filtrating condition of the present invention, can may further comprise the steps:
Step 301: according to required invoice filtrating condition, participate in the receipt field of filtration as required, the number of field row is set;
Step 302: the reference position at the respective field row is provided with the receipt field that needs participate in filtration;
Step 303: select the logical relation between the described field row, and determine the field value of described receipt field;
Step 304: generate document according to described field value and logical relation and cross the filter condition;
Step 305: will at least two documents cross the filter condition according to or relation, generate invoice filtrating condition;
Step 306:, document to be filtered is filtered according to invoice filtrating condition.
Preferably, described step 306 can comprise following substep:
Substep 3061: with the combination of described invoice filtrating condition and time conditions generate peek Structured Query Language (SQL) (Structured Query Language, SQL);
Substep 3062: document to be filtered is filtered according to described peek SQL.
Need to prove that SQL aims at database and the operation commands set set up, is senior deproceduring programming language, allow the user on the high level data structure, to work.It does not require that the user specifies the deposit method to data, do not need the user to understand concrete deposit data mode yet, can use identical sql like language as the interface of data input so have the disparate databases system of complete different fabrics with management, because sql like language belongs to the known technology of this area, is not described in detail in this.
In actual applications, described filtercondition can be understood as different document numberings, and these qualifications to the document filtering content are used in the set of perhaps different service logic (for example different names of material or other), can filter out the document that the user needs.
Need to prove, for aforesaid each method embodiment, for simple description, so it all is expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not subjected to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in the instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
For making those skilled in the art understand the present invention better, the present invention is further described below in conjunction with object lesson that the present invention uses in practice.
Steps A 1:, the number of field row is set according to required invoice filtrating condition;
In actual applications, consider user's demand, general 3 fields row can satisfy the needs of filtration; With reference to figure 4, show to be provided with and finish the interface synoptic diagram of invoice filtrating condition afterwards, in Fig. 4, defined the field row of 3 drop-down list types;
Steps A 2: the reference position at the respective field row is provided with the receipt field that needs participate in filtration;
And the field of described document is added in the described field row, for example, field in the present example is: " document numbering ", " name of material " etc.; Need to prove that what of field row number can be made amendment according to concrete service needed, from user's demand ERP service application, 3 fields row can satisfy daily service application demand; Wherein, described field row need only define once, not only make user's operation more efficient and convenient, prior, can reduce redundant the setting in the process of user definition filtercondition;
Receipt field to be filtered is added in the described field row, so that the user selects and defines when filtering; This step has defined the field that needs to participate in filtration, i.e. and " document numbering ", with field name " FBillNo " expression, " name of material " represented with " FMaterialName " during the actual participation data filter;
Steps A 3: select the logical relation between the described field row;
Between described field row, have two kinds of logical relations, first kind be AND (and); Second kind be OR (or); Need to prove that the logical relation between the described field row only needs once definition, can use in batches when generating filtercondition, greatly facilitate the user definition invoice filtrating condition;
In the present example, the definition of two groups of logical relations as shown in Figure 4 " and ", because the business paper of this example has 3 fields row,,, then need to define 3 groups of logical relations if the user is provided with 4 when field row number is set so need 2 groups of logical relations of definition; In this example, two groups of definition " and " logical relation, can reduce the redundance of logical relation definition; When the logical relation that is provided be " and " time, during data processing with " AND " expression, when the logical relation of setting be " or " time, represent with " OR " during data processing;
Steps A 4: the field value of determining described receipt field;
The user just can be in described field row the input word segment value, " P00RD00001 " in " document numbering " row as shown in Figure 4, and, " cotton fine cloth organdy 60 * 60 " in " name of material " row etc., simultaneously, in the present example, the field value that needs setting is not set in the 3rd the field row " nothing ", the user can independently select need or not to be provided with the field that participates in filtration as required, according to interface synoptic diagram shown in Figure 4 described logical relation and fixed relationship are set, the batch typing of filtered fields value can be realized, thereby the filtration of document can be realized fast and easily;
Steps A 4: generate document according to described field value and logical relation and cross the filter condition;
Determine after the field value, can reach the filtered fields value and generate the filter condition according to the logical relation between the field row, field row " nothing " in this example can generate one and be genuine condition forever, therefore, delegation's field value can generate a document and cross the filter condition, specific as follows shown in:
G=(document numbering=" POORD00001 " and name of material=" cotton fine cloth organdy 60 * 60 " and 1=1)
Steps A 5: will at least two documents cross the filter condition according to or relation, generate invoice filtrating condition;
In Fig. 4, as can be seen, have two the row field values, with two the row field values according to or relation, can generate invoice filtrating condition; In the present example, the logical relation between the 1st row and the 2nd row is " OR "; Need to prove that in Fig. 4, just be provided with two row field values, the user can be provided with multirow, when generating invoice filtrating condition, between each row all be or relation; In the present example, the invoice filtrating condition G of Fig. 4 example generation can be as follows:
G=(document numbering=" POORD00001 " and name of material=" cotton fine cloth organdy 60 * 60 " and 1=1) or
(document numbering=" POORD00002 " and name of material=" round-neck sweater " and 1=1);
Read described condition G, can obtain following data:
G=((FBillNo=' POORD00001 ' AND FMaterialName=' cotton fine cloth ' AND 1=1) OR
(FBillNo=' POORD0002 ' AND FMaterialName=' round-neck sweater ' AND 1=1));
Preferably, when generating invoice filtrating condition, also can generate invoice filtrating condition in the lump according to the time conditions of described field value, logical relation and document;
In the present example, if the document filter time is " the sale shipment business that realizes June ", then time conditions H is defined as:
H=(FDate>=‘2008-06-01’?AND?FDate<=‘2008-06-30’)
In sum, setting has comprised that the invoice filtrating condition of time conditions is I, then has: I=HAND G;
Therefore, obtaining final invoice filtrating condition is:
I=(FDate>=‘2008-06-01’AND?FDate<=‘2008-06-30’)AND
((FBillNo=' POORD00001 ' AND FMaterialName=' cotton fine cloth ' AND 1=1) OR
(FBillNo=' POORD0002 ' AND FMaterialName=' round-neck sweater ' AND 1=1));
Need to prove, in the present invention, described invoice filtrating condition not only can also comprise time conditions, can also comprise other, the needs that were not provided with in Fig. 4 participate in the condition of filtration, perhaps, also can will be provided with on the interface of time conditions in Fig. 4, these do not influence realization of the present invention, so the present invention need not this is made qualification;
Steps A 6: described invoice filtrating condition combination is generated peek SQL;
According to described invoice filtrating condition, combination generates peek SQL, that is: select*from tablewhere I;
Be in the ERP system service application, the peek SQL of the filtration of business paper set can abstractly be: (1) formula: select*from Table where H;
Then by the present invention, the peek SQL that the combination condition I of senior filtration unit definition generates is abstract to be: select*from Table where I, i.e. select*from Table where H AND G; With the expression formula substitution following formula of aforementioned H and G, can obtain realizing in this example the peek SQL that document filters respectively;
Steps A 7:, document to be filtered is filtered according to described peek SQL.
According to described peek SQL, can realize purpose that document to be filtered is filtered, thus the quick filtration of realization complicated business in ERP system is used.
In sum, the embodiment of the invention is by once being provided with the receipt field that needs to participate in filtration, the user just can be when generating invoice filtrating condition, according to described field to determine corresponding field value, thereby can reduce the logical relation between the field that participates in filtering is re-defined, and the redundancy that repeatedly repeats to import receipt field, further, can also be lifted at the ease for use that document filters under the complicated filtercondition, reduce same document defines filtercondition in certain set of circumstances complicacy.
With reference to figure 5, show the structured flowchart of the device preferred embodiment of a kind of document filtration of the present invention, can comprise with lower module:
Module 501 is set, is used for, be provided with and the corresponding field row of receipt field that need to participate in filtration according to required invoice filtrating condition;
Preferably, the described module that is provided with specifically can comprise:
First is provided with submodule 5011, is used for participating in as required the receipt field of filtering, and the number of field row is set;
Second is provided with submodule 5012, is used in the reference position of respective field row the receipt field that needs participate in filtration being set.
Select module 502, be used to select the logical relation between the described field row;
Determination module 503 is used for determining the field value of described field;
Generation module 504 is used for generating filtercondition according to described logical relation and fixed relationship;
Preferably, described generation module specifically can comprise:
First generates submodule 5041, is used for generating document according to described field value and logical relation and crosses the filter condition;
Second generates submodule 5042, be used for at least two documents cross the filter condition according to or relation, generate invoice filtrating condition.
Preferably, described device can also comprise:
Filtering module 505 is used for according to invoice filtrating condition, and document to be filtered is filtered.
Preferably, described filtering module specifically can comprise:
The 3rd generates submodule 5051, is used for the invoice filtrating condition combination is generated peek SQL;
Filter submodule 5052, be used for document to be filtered being filtered according to described peek SQL.
In the present embodiment, described device can be subdivided into four modules, and wherein the action mutual relationship all finished with other modules of the action finished of each module is finished the purpose that generates invoice filtrating condition jointly.Further, described device can also comprise filtering module, described filtering module can also comprise two submodules, and earlier filtercondition is generated peek SQL, the optimal way that document is filtered according to described peek SQL further can filter document, thereby can be lifted at the ease for use that generates invoice filtrating condition under the complex conditions then, further, can also be reduced in the redundancy of logical relation between the field that need define a large amount of participations filtrations when generating invoice filtrating condition.
With reference to figure 6, show and use preferred embodiment generation invoice filtrating condition shown in Figure 5, and carry out the process flow diagram that document filters according to described invoice filtrating condition, can may further comprise the steps:
Step 601: first is provided with submodule participates in the receipt field of filtering as required, and the number of field row is set;
Step 602: second is provided with submodule is provided with the receipt field that needs participate in filtration in the reference position of respective field row;
Step 603: the selection module is selected the logical relation between the described field row;
Step 604: determination module is determined the field value of described field;
Step 605: first generates submodule crosses the filter condition according to described field value and logical relation generation document;
Step 606: second generate submodule will at least two documents cross the filter condition according to or relation, generate invoice filtrating condition;
Step 607: the 3rd generates submodule generates peek SQL with the invoice filtrating condition combination;
Step 608: filter submodule and document to be filtered is filtered according to described peek SQL.
Need to prove that each embodiment in this instructions all adopts the mode of going forward one by one to describe, what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.For device class embodiment, because it is similar substantially to method embodiment, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
More than a kind of method that generates invoice filtrating condition provided by the present invention and the device that generates invoice filtrating condition are 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 (12)

1, a kind of method that generates invoice filtrating condition is characterized in that, comprising:
According to required invoice filtrating condition, be provided with and the corresponding field row of receipt field that need to participate in filtration;
Select the logical relation between the described field row, and determine the field value of described receipt field;
Generate invoice filtrating condition according to described field value and logical relation.
2, the method for claim 1 is characterized in that, described field value of described foundation and logical relation generate invoice filtrating condition and comprise:
Time conditions according to described field value, logical relation and document generates invoice filtrating condition.
3, the method for claim 1 is characterized in that, described field value of described foundation and logical relation generate invoice filtrating condition and comprise:
Generate document according to described field value and logical relation and cross the filter condition;
With at least two documents cross the filter condition according to or relation, generate invoice filtrating condition.
4, the method for claim 1 is characterized in that, described setting comprises with the corresponding field row of receipt field that need to participate in filtering:
Participate in the receipt field of filtration as required, the number of field row is set;
Reference position at the respective field row is provided with the receipt field that needs participate in filtration.
5, the method for claim 1 is characterized in that, also comprises:
According to invoice filtrating condition, document to be filtered is filtered.
6, method as claimed in claim 5 is characterized in that, and is described according to invoice filtrating condition, document to be filtered filtered comprise:
The invoice filtrating condition combination is generated peek Structured Query Language (SQL) SQL;
According to described peek SQL document to be filtered is filtered.
7, as any described method of claim 1 to 6, it is characterized in that described method is applied in the ERP system.
8, a kind of device that generates invoice filtrating condition is characterized in that, comprising:
Module is set,, is provided with and the corresponding field row of receipt field that need to participate in filtration according to required invoice filtrating condition;
Select module, be used to select the logical relation between the described field row;
Determination module is used for determining the field value of described receipt field;
Generation module is used for generating invoice filtrating condition according to described field value and logical relation.
9, device as claimed in claim 8 is characterized in that, described generation module comprises:
First generates submodule, is used for generating document according to described field value and logical relation and crosses the filter condition;
Second generates submodule, be used for at least two documents cross the filter condition according to or relation, generate invoice filtrating condition.
10, device as claimed in claim 8 is characterized in that, the described module that is provided with comprises:
First is provided with submodule, is used for participating in as required the receipt field of filtering, and the number of field row is set;
Second is provided with submodule, is used in the reference position of respective field row the receipt field that needs participate in filtration being set.
11, device as claimed in claim 8 is characterized in that, also comprises:
Filtering module is used for according to invoice filtrating condition, and document to be filtered is filtered.
12, device as claimed in claim 11 is characterized in that, described filtering module comprises:
The 3rd generates submodule, is used for the invoice filtrating condition combination is generated peek SQL;
Filter submodule, be used for document to be filtered being filtered according to described peek SQL.
CNA2008101354703A 2008-08-07 2008-08-07 Method and device for creating invoice filtrating condition Pending CN101334794A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNA2008101354703A CN101334794A (en) 2008-08-07 2008-08-07 Method and device for creating invoice filtrating condition

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNA2008101354703A CN101334794A (en) 2008-08-07 2008-08-07 Method and device for creating invoice filtrating condition

Publications (1)

Publication Number Publication Date
CN101334794A true CN101334794A (en) 2008-12-31

Family

ID=40197392

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA2008101354703A Pending CN101334794A (en) 2008-08-07 2008-08-07 Method and device for creating invoice filtrating condition

Country Status (1)

Country Link
CN (1) CN101334794A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102567413A (en) * 2010-12-31 2012-07-11 中国银联股份有限公司 System and method for data filtering
CN103902563A (en) * 2012-12-26 2014-07-02 航天信息软件技术有限公司 Method for generating receipts through ERP system
CN107833133A (en) * 2017-11-15 2018-03-23 中国光大银行股份有限公司信用卡中心 A kind of data processing method and device
CN108133341A (en) * 2017-12-21 2018-06-08 郑州云海信息技术有限公司 A kind of generation method and system of the material alternative condition based on ERP system
CN112685611A (en) * 2020-12-31 2021-04-20 恒安嘉新(北京)科技股份公司 Data filtering method and device, storage medium and electronic equipment

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102567413A (en) * 2010-12-31 2012-07-11 中国银联股份有限公司 System and method for data filtering
CN103902563A (en) * 2012-12-26 2014-07-02 航天信息软件技术有限公司 Method for generating receipts through ERP system
CN107833133A (en) * 2017-11-15 2018-03-23 中国光大银行股份有限公司信用卡中心 A kind of data processing method and device
CN107833133B (en) * 2017-11-15 2022-01-25 中国光大银行股份有限公司信用卡中心 Data processing method and device
CN108133341A (en) * 2017-12-21 2018-06-08 郑州云海信息技术有限公司 A kind of generation method and system of the material alternative condition based on ERP system
CN112685611A (en) * 2020-12-31 2021-04-20 恒安嘉新(北京)科技股份公司 Data filtering method and device, storage medium and electronic equipment

Similar Documents

Publication Publication Date Title
US20220066772A1 (en) System and Method for Code and Data Versioning in Computerized Data Modeling and Analysis
Scheer Business process engineering: reference models for industrial enterprises
Wang et al. A framework for document-driven workflow systems
CN101308490B (en) Dynamic report generation method and platform
CN112668295B (en) Management system and method based on custom form and active workflow
EP1770620A2 (en) Method for modelling processing procedures
US20140095248A1 (en) Supply chain financial orchestration system with task communication using universal format
Hull et al. Data management perspectives on business process management: tutorial overview
CN101739452A (en) Data exchange interface and realizing method thereof
CN101334794A (en) Method and device for creating invoice filtrating condition
Wang et al. Supporting process design for e-business via an integrated process repository
WO2018236886A1 (en) System and method for code and data versioning in computerized data modeling and analysis
CN102298739A (en) Method for changing bill of materials (BOM) and apparatus thereof
CN107391611A (en) A kind of process model generation method of the General ETL Tool based on workflow
CN103164573A (en) Product data management (PDM) design system
US20060026558A1 (en) Hybrid contextual floor plans for object instances
CN101187929A (en) Formula definition assembly for flexible mathematical aiming at large data of database table
CN101719234A (en) Method and device for splitting workflow
CN101719243A (en) Method for processing production order, application server and group enterprise network system
Chen et al. Shifting bottleneck-driven TOCh for solving product mix problems
Glöckner et al. Towards a logistics service map: Support for logistics service engineering and management
CN107480186B (en) Business model data processing method and computer equipment
Dayal et al. Business Processes Meet Operational Business Intelligence.
CN101908038A (en) Periodic report generation system and method
CN114610803A (en) Data processing method and device, electronic equipment and storage 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

Open date: 20081231