CN104281667A - Expansible budget control device and method - Google Patents
Expansible budget control device and method Download PDFInfo
- Publication number
- CN104281667A CN104281667A CN201410505825.9A CN201410505825A CN104281667A CN 104281667 A CN104281667 A CN 104281667A CN 201410505825 A CN201410505825 A CN 201410505825A CN 104281667 A CN104281667 A CN 104281667A
- Authority
- CN
- China
- Prior art keywords
- control
- budget
- data source
- radix
- scheme
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Educational Administration (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides an expansible budget control device. The expansible budget control device comprises a data source receipt presetting unit, a control cardinal number scheme setting unit, a control cardinal number scheme selecting unit and a control cardinal number acquiring unit. The data source receipt presetting unit presets expansible data source receipt information and data source receipt field mapping, the control cardinal number scheme setting unit newly adds one or more control cardinal number schemes and sets data sources and control conditions of the corresponding control cardinal number schemes, the control cardinal number scheme selecting unit selects the control cardinal number schemes to be used in budget projects in controls rules of the various budget projects set by users, and the control cardinal number acquiring unit acquires field names of accounting book files on data source receipts and acquires control cardinal numbers according to the field names, the data sources and the control conditions. The invention further provides an expansible budget control method. According to the technical scheme, on the basis of existing budget control ways, budget control involving many data sources can be completed by sufficiently utilizing the data source control cardinal numbers, and a universal and uniform control concept of budget control with different control cardinal numbers is established.
Description
Technical field
The present invention relates to technical field of data processing, particularly, relate to a kind of extendible budget control device and the extendible budget control method of one.
Background technology
In the budget control of ERP system, budget balances=count in advance-actual number, wherein, counting in advance is in budgeting system, according to the numerical value of budget items establishment, is a relatively-stationary value; And actual number is the actual numerical value occurred in budget items, it is a constantly cumulative value.So budget balances constantly can change along with the change of actual number, if budget balances is negative, represent beyond budget, need to control according to budget control rule.
Need if counted in advance to change, namely need adjustment to count in advance, so need the manual adjustment that passes budgets in budgeting system, generate budget adjustment list and revise.If counted in advance, change is very frequent, and the way that so this adjustment counts in advance is with regard to underaction.
Often have such scene in practice: user pre-is decided by sales revenue at last, and namely sales revenue is many, so can budget just many.And sales revenue is the numerical value constantly changed, every day is even per hour all in change, if to make a budget number by sales revenue, count so in advance and will constantly adjust, this greatly can increase workload, or estimate that an about value used one period, this can cause again the out of true of budget control.
For solving the problem, need to propose based on controlling the budget control method of radix, and realize a kind of device to ask for control radix and carry out budget control.
Therefore, need a kind of new budget control technology, on existing budget control mode basis, can make full use of forms data source and control the budget control that radix completes multi-data source participation, general, the unification of setting up the difference control radix budget control that multi-data source participates in control thinking.
Summary of the invention
The present invention is just based on the problems referred to above, propose a kind of new budget control device expansion technique, can on existing budget control mode basis, make full use of forms data source and control the budget control that radix completes multi-data source participation, general, the unification of setting up the difference control radix budget control that multi-data source participates in control thinking.
In view of this, the present invention proposes a kind of extendible budget control device, comprising: data source document preset unit, map for preset extendible data source document information and data source receipt field; Control radix scheme setting unit, control radix scheme for newly-increased one or more, set data source and the controlled condition of corresponding control radix scheme; Control radix scheme selecting unit, in the control law of each budget items that arranges user, the control radix scheme that selection budget items will use; Controlling radix acquiring unit, adjusting the field name of accounts archives on data source document for obtaining, obtain according to field name, data source and controlled condition and control radix.In this technical scheme, can expand budget control, realize carrying out budget control according to different control radix schemes, be not limited to and can only control according to the estimated value established in advance, budget can be controlled flexibly.
In technique scheme, preferably, described data source document preset unit, specifically comprises: data source document information preset module, for preset extendible data source document information; Data source receipt field mapping block, maps for initialize data source receipt field.In this technical scheme, the selection of a data source document can be provided, include but not limited to general ledger voucher, sales order, invoice for sales, revenue shipment list, be used to provide the peek source controlling radix.
In technique scheme, preferably, described data source document information comprises general ledger voucher, sales order, invoice for sales and the revenue shipment list for providing the peek source controlling radix.
In technique scheme, preferably, described data source receipt field maps and comprises the field name of budget accounts archives on data source document.
In technique scheme, preferably, described control radix acquiring unit, specifically comprise: data source document and controlled condition acquisition module, when controlled document for adjusting budget accounts archives transmits, according to the budget items on controlled document, from control law, take out corresponding control radix scheme, from the control radix scheme of taking out, obtain data source document and controlled condition; Field name acquisition module, for according to the budget bore on controlled document, obtain corresponding accounting accounts archives by contrasting with budget accounts archives, then obtain adjusting the field name of accounts archives on data source document by the field mappings in corresponding control radix scheme; Control radix acquisition module, for this field name is generated data query statement together with data source and controlled condition, inquire about in accounting accounts database, obtain required control radix.In this technical scheme, can according to the budget items on controlled document, obtain the control radix scheme that budget items are selected in control law, and according to the bore on controlled document and archives contrast, obtain the archives corresponding to and adjust accounts, then according to the field mappings of archives in data source, and the condition controlled in radix scheme, generate the query sentence of database asked for and control radix, perform in a database, try to achieve and control radix value.
According to a further aspect of the invention, also proposed a kind of extendible budget control method, comprising: step 202: preset extendible data source document information and data source receipt field map; Step 204: newly-increased one or more controls radix scheme, sets data source and the controlled condition of corresponding control radix scheme; Step 206: in the control law of each budget items of user's setting, selects the control radix scheme that budget items will use; Step 208: obtain and adjust the field name of accounts archives on data source document, obtains according to field name, data source and controlled condition and controls radix.In this technical scheme, can expand budget control, realize carrying out budget control according to different control radix schemes, be not limited to and can only control according to the estimated value established in advance, budget can be controlled flexibly.
In technique scheme, preferably, described step 202, specifically comprises: step 302: preset extendible data source document information; Step 304: initialize data source receipt field maps.In this technical scheme, the selection of a data source document can be provided, include but not limited to general ledger voucher, sales order, invoice for sales, revenue shipment list, be used to provide the peek source controlling radix.
In technique scheme, preferably, described data source document information comprises general ledger voucher, sales order, invoice for sales and the revenue shipment list for providing the peek source controlling radix.
In technique scheme, preferably, described data source receipt field maps and comprises the field name of budget accounts archives on data source document.
In technique scheme, preferably, described step 208, specifically comprise: step 402: when the controlled document of accounting budget accounts archives transmits, according to the budget items on controlled document, from control law, take out corresponding control radix scheme, from the control radix scheme of taking out, obtain data source document and controlled condition; Step 404: according to the budget bore on controlled document, obtains corresponding accounting accounts archives by contrasting with budget accounts archives, then obtains adjusting the field name of accounts archives on data source document by the field mappings in corresponding control radix scheme; Step 406: this field name is generated data query statement together with data source and controlled condition, inquires about in accounting accounts database, obtains required control radix.In this technical scheme, can according to the budget items on controlled document, obtain the control radix scheme that budget items are selected in control law, and according to the bore on controlled document and archives contrast, obtain the archives corresponding to and adjust accounts, then according to the field mappings of archives in data source, and the condition controlled in radix scheme, generate the query sentence of database asked for and control radix, perform in a database, try to achieve and control radix value.
By above technical scheme, on existing budget control mode basis, can make full use of forms data source and control the budget control that radix completes multi-data source participation, general, the unification of setting up the difference control radix budget control that multi-data source participates in control thinking.
Accompanying drawing explanation
Fig. 1 shows the block diagram of extendible according to an embodiment of the invention budget control device;
Fig. 2 shows the process flow diagram of extendible according to an embodiment of the invention budget control method;
Fig. 3 shows the process flow diagram of data source document preset unit according to an embodiment of the invention;
Fig. 4 shows the process flow diagram controlling radix acquiring unit according to an embodiment of the invention;
Fig. 5 shows the principle schematic of mutual according to an embodiment of the invention use case analysis;
Fig. 6 shows inter-view 1 according to an embodiment of the invention;
Fig. 7 shows inter-view 2 according to an embodiment of the invention.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine mutually.
Set forth a lot of detail in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not by the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of extendible according to an embodiment of the invention budget control device.
As shown in Figure 1, extendible according to an embodiment of the invention budget control device 100, comprising: data source document preset unit 102, maps for preset extendible data source document information and data source receipt field; Control radix scheme setting unit 104, control radix scheme for newly-increased one or more, set data source and the controlled condition of corresponding control radix scheme; Control radix scheme selecting unit 106, in the control law of each budget items that arranges user, the control radix scheme that selection budget items will use; Controlling radix acquiring unit 108, adjusting the field name of accounts archives on data source document for obtaining, obtain according to field name, data source and controlled condition and control radix.In this technical scheme, can expand budget control, realize carrying out budget control according to different control radix schemes, be not limited to and can only control according to the estimated value established in advance, budget can be controlled flexibly.
In technique scheme, preferably, data source document preset unit 102, specifically comprises: data source document information preset module, for preset extendible data source document information; Data source receipt field mapping block, maps for initialize data source receipt field.In this technical scheme, the selection of a data source document can be provided, include but not limited to general ledger voucher, sales order, invoice for sales, revenue shipment list, be used to provide the peek source controlling radix.
In technique scheme, preferably, data source document information comprises general ledger voucher, sales order, invoice for sales and the revenue shipment list for providing the peek source controlling radix.
In technique scheme, preferably, data source receipt field maps and comprises the field name of budget accounts archives on data source document.
In technique scheme, preferably, control radix acquiring unit 108, specifically comprise: data source document and controlled condition acquisition module, when controlled document for adjusting budget accounts archives transmits, according to the budget items on controlled document, from control law, take out corresponding control radix scheme, from the control radix scheme of taking out, obtain data source document and controlled condition; Field name acquisition module, for according to the budget bore on controlled document, obtain corresponding accounting accounts archives by contrasting with budget accounts archives, then obtain adjusting the field name of accounts archives on data source document by the field mappings in corresponding control radix scheme; Control radix acquisition module, for this field name is generated data query statement together with data source and controlled condition, inquire about in accounting accounts database, obtain required control radix.In this technical scheme, can according to the budget items on controlled document, obtain the control radix scheme that budget items are selected in control law, and according to the bore on controlled document and archives contrast, obtain the archives corresponding to and adjust accounts, then according to the field mappings of archives in data source, and the condition controlled in radix scheme, generate the query sentence of database asked for and control radix, perform in a database, try to achieve and control radix value.
Fig. 2 shows the process flow diagram of extendible according to an embodiment of the invention budget control method.
As shown in Figure 2, extendible according to an embodiment of the invention budget control method, comprising: step 202: preset extendible data source document information and data source receipt field map; Step 204: newly-increased one or more controls radix scheme, sets data source and the controlled condition of corresponding control radix scheme; Step 206: in the control law of each budget items of user's setting, selects the control radix scheme that budget items will use; Step 208: obtain and adjust the field name of accounts archives on data source document, obtains according to field name, data source and controlled condition and controls radix.In this technical scheme, can expand budget control, realize carrying out budget control according to different control radix schemes, be not limited to and can only control according to the estimated value established in advance, budget can be controlled flexibly.
In technique scheme, preferably, step 202, specifically comprises: step 302: preset extendible data source document information; Step 304: initialize data source receipt field maps.In this technical scheme, the selection of a data source document can be provided, include but not limited to general ledger voucher, sales order, invoice for sales, revenue shipment list, be used to provide the peek source controlling radix.
In technique scheme, preferably, data source document information comprises general ledger voucher, sales order, invoice for sales and the revenue shipment list for providing the peek source controlling radix.
In technique scheme, preferably, data source receipt field maps and comprises the field name of budget accounts archives on data source document.
In technique scheme, preferably, step 208, specifically comprise: step 402: when the controlled document of accounting budget accounts archives transmits, according to the budget items on controlled document, from control law, take out corresponding control radix scheme, from the control radix scheme of taking out, obtain data source document and controlled condition; Step 404: according to the budget bore on controlled document, obtains corresponding accounting accounts archives by contrasting with budget accounts archives, then obtains adjusting the field name of accounts archives on data source document by the field mappings in corresponding control radix scheme; Step 406: this field name is generated data query statement together with data source and controlled condition, inquires about in accounting accounts database, obtains required control radix.In this technical scheme, can according to the budget items on controlled document, obtain the control radix scheme that budget items are selected in control law, and according to the bore on controlled document and archives contrast, obtain the archives corresponding to and adjust accounts, then according to the field mappings of archives in data source, and the condition controlled in radix scheme, generate the query sentence of database asked for and control radix, perform in a database, try to achieve and control radix value.
Technical scheme of the present invention, by arranging budget control radix scheme, can carry out budget control with the control radix in different pieces of information source, and the expansion in supported data source.
Technical scheme of the present invention, disclose a kind of extendible budget control method and apparatus, wherein the realization of method comprises:
(1) user arranges and controls radix scheme, comprises and controls source, controlled condition, Condition Matching mode;
(2) after receiving the computation requests controlling radix, according to control radix scheme, generated query statement;
(3) perform the query statement of generation, calculate control radix.
Above technical scheme, can expand the control method of budget control, can realize carrying out budget control according to different control radix schemes, is not limited to and can only controls according to the estimated value established in advance, can control budget flexibly.
The keyword that in technical solution of the present invention, device relates to comprises:
(1) control radix: the numerical value being used to carry out budget control, and it is similar to count in advance, but the value of a continuous change, such as: current or by the end of 5% of sales revenue so far;
(2) control radix scheme: in order to the scheme asking control radix to arrange, comprise Data Source, condition, field mappings etc., the final purpose of scheme tries to achieve control radix;
(3) budget items: budget is classified, such as communication expense, travel expenses.Different budget items can arrange different control laws;
(4) budget bore: the dimension of carrying out budget control, such as mechanism (department), cash flow projects etc., can control multiple bore simultaneously;
(5) control law: the rule arranged according to budget items, comprises and which selects control radix scheme, the processing mode etc. after excessing budget;
(6) budget accounts: the accounts at budgeting system place, budget accounts can carry out budget control to multiple accounting accounts;
(7) adjust accounts: general ledger, net report, buying, stock, deal with the accounts at system place, accounting accounts can only control by budget accounts;
(8) archives contrast: the contrast relationship of the archives of budget accounts and the archives of accounting accounts;
(9) controlled document: refer to the accounting accounts document by budget control, such as expense report.Document has budget items and budget bore information, when document is preserved or audit, controlled document is sent to budgeting system and carries out budget control.
In technical solution of the present invention device realize main points:
(1) this device can provide the increase controlling radix scheme, amendment, deletes, query function.Budget items and one must be controlled radix scheme and be associated (passing through control law).
(2) to each control radix scheme, this device can provide the selection of a data source document, includes but not limited to general ledger voucher, sales order, invoice for sales, revenue shipment list, is used to provide the peek source controlling radix.
(3) to each control radix scheme, this device can provide the selection of condition, provides the condition obtaining and control radix, the matching way of such as bore, and whether value contains tax, value accounting etc.For controlling radix source general ledger voucher, additionally providing subject and to select and whether value comprises the selection of non-bookkeeping voucher.
(4) this device can according to the budget items on controlled document, obtain the control radix scheme that budget items are selected in control law, and according to the bore on controlled document and archives contrast, obtain the archives corresponding to and adjust accounts, then according to the field mappings of archives in data source, and control the condition in radix scheme, generate the query sentence of database asked for and control radix, perform in a database, try to achieve and control radix value.
In technical solution of the present invention, the interactive controlling process of device is as follows:
(1), before this device starts, need initialize data source document information (current device is only prefixed general ledger voucher, sales order, invoice for sales and revenue shipment list four kinds of documents, but can expand);
(2), before this device starts, needing initialize data source receipt field to map, is exactly the field names of budget accounts archives on data source document;
(3) newly-increased one or more controls radix scheme, sets the data source of scheme, condition;
(4), in control law, select the control radix scheme that budget items will use;
(5), when the controlled document adjusting accounts transmits, this device, by according to the budget items on controlled document, takes out corresponding control radix scheme, obtains data source document, condition from scheme from control law; According to the budget bore on controlled document, corresponding accounting accounts archives are obtained by archives contrast, the field name of archives on data source document is obtained again by the field mappings in scheme, data query statement is generated together with data source, condition, inquire about in accounting accounts database, obtain controlling radix.
The mutual use case analysis of device in technical solution of the present invention: as shown in Figure 5.
(1) user arranges archives contrast at budget accounts, budget accounts archives and the contrast of accounting accounts archives is got up;
(2) user arranges one or more control radix scheme, during the plan of establishment, the Data Source document of selection scheme, condition, and archives field mappings be according to the difference of Data Source document in advance preset in systems in which;
(3) user arranges the control law of each budget items, the control radix scheme selecting these budget items to use in control law; (1), (2), (3) three steps are preliminary work;
(4) user fills and presents controlled document at each accounting accounts, document is selected budget items and bore, when document is preserved or audit (depending on Operation system setting), calls budget interface to reduce budget;
(5) budget interface obtains budget items on controlled document and budget bore, first finds control law according to budget items, then obtains the control radix scheme in control law;
(6), again according to budget bore, in archives contrast, find the map file adjusted in accounts;
(7) utilize the Data Source document, condition, the archives field mappings that control in radix scheme, adjust archives, the Sql statement asked for and control radix can be generated, in accounting accounts, perform this statement, obtain control radix;
(8) according to the comparison controlling cardinal sum actual number, and the excess budget control mode in control law, make excess budget conclusion, return caller.
The inter-view of device in technical solution of the present invention, as shown in Figure 6 and Figure 7.
The Advantageous Effects that technical solution of the present invention can obtain is: in the budget control of ERP system, and the remaining sum that passes budgets=count in advance-actual number controls, and counting in advance is the numerical value worked out according to budget items, is a relatively-stationary value; Count change in advance, is to be revised by the manual budget adjustment list that generates.And often have such scene in practice: user pre-is decided by sales revenue at last, and namely sales revenue is many, so can budget just many.And sales revenue is the numerical value of a continuous change, if to make a budget number by sales revenue, counts so in advance and will constantly adjust; In addition, if for different budget items, user wants to control with different Data Sources, and original controlling mechanism is also had no idea to this.
Technical scheme of the present invention, solve this two problems just, radix scheme is controlled by arranging, user can utilize the control radix dynamically obtained to replace counting in advance controlling, and by arranging different control radix schemes, different Data Sources and condition can be selected, carry out budget control more flexibly.
The realization of technical solution of the present invention, user is avoided adjust frequently to count or estimate fuzzy counting in advance in advance, alleviate the workload of user, improve the precision of budget control, and different schemes can be selected to control, improve the dirigibility of budget control.
Be in the patent (application) of 200910210510.0 in patent (application) number, disclose a kind of method and apparatus of budget control, specifically the budget of multiple budget items packing is controlled together; And technical scheme of the present invention, be pass budgets to control the control radix that radix scheme obtains with different data sources and control.
More than be described with reference to the accompanying drawings technical scheme of the present invention, considered in correlation technique there is no easy, the unified solution for multiple data source budget control.Existing budget control cannot complete the budget control process that multiple data source participates in.Therefore, the present invention proposes a kind of extendible budget control device and the extendible budget control method of one, can on existing budget control mode basis, make full use of forms data source and control the budget control that radix completes multi-data source participation, general, the unification of setting up the difference control radix budget control that multi-data source participates in control thinking.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. an extendible budget control device, is characterized in that, comprising:
Data source document preset unit, maps for preset extendible data source document information and data source receipt field;
Control radix scheme setting unit, control radix scheme for newly-increased one or more, set data source and the controlled condition of corresponding control radix scheme;
Control radix scheme selecting unit, in the control law of each budget items that arranges user, the control radix scheme that selection budget items will use;
Controlling radix acquiring unit, adjusting the field name of accounts archives on data source document for obtaining, obtain according to field name, data source and controlled condition and control radix.
2. extendible budget control device according to claim 1, is characterized in that, described data source document preset unit, specifically comprises:
Data source document information preset module, for preset extendible data source document information;
Data source receipt field mapping block, maps for initialize data source receipt field.
3. extendible budget control device according to claim 2, is characterized in that, described data source document information comprises general ledger voucher, sales order, invoice for sales and revenue shipment list for providing the peek source controlling radix.
4. extendible budget control device according to claim 2, is characterized in that, described data source receipt field maps and comprises the field name of budget accounts archives on data source document.
5. the extendible budget control device according to any one of claim 1-4, is characterized in that, described control radix acquiring unit, specifically comprises:
Data source document and controlled condition acquisition module, when controlled document for adjusting budget accounts archives transmits, according to the budget items on controlled document, from control law, take out corresponding control radix scheme, from the control radix scheme of taking out, obtain data source document and controlled condition;
Field name acquisition module, for according to the budget bore on controlled document, obtain corresponding accounting accounts archives by contrasting with budget accounts archives, then obtain adjusting the field name of accounts archives on data source document by the field mappings in corresponding control radix scheme;
Control radix acquisition module, for this field name is generated data query statement together with data source and controlled condition, inquire about in accounting accounts database, obtain required control radix.
6. an extendible budget control method, is characterized in that, comprising:
Step 202: preset extendible data source document information and data source receipt field map;
Step 204: newly-increased one or more controls radix scheme, sets data source and the controlled condition of corresponding control radix scheme;
Step 206: in the control law of each budget items of user's setting, selects the control radix scheme that budget items will use;
Step 208: obtain and adjust the field name of accounts archives on data source document, obtains according to field name, data source and controlled condition and controls radix.
7. extendible budget control method according to claim 6, it is characterized in that, described step 202, specifically comprises:
Step 302: preset extendible data source document information;
Step 304: initialize data source receipt field maps.
8. extendible budget control method according to claim 7, is characterized in that, described data source document information comprises general ledger voucher, sales order, invoice for sales and revenue shipment list for providing the peek source controlling radix.
9. extendible budget control method according to claim 7, is characterized in that, described data source receipt field maps and comprises the field name of budget accounts archives on data source document.
10. the extendible budget control method according to any one of claim 6-9, it is characterized in that, described step 208, specifically comprises:
Step 402: when the controlled document of accounting budget accounts archives transmits, according to the budget items on controlled document, take out corresponding control radix scheme from control law, obtain data source document and controlled condition from the control radix scheme of taking out;
Step 404: according to the budget bore on controlled document, obtains corresponding accounting accounts archives by contrasting with budget accounts archives, then obtains adjusting the field name of accounts archives on data source document by the field mappings in corresponding control radix scheme;
Step 406: this field name is generated data query statement together with data source and controlled condition, inquires about in accounting accounts database, obtains required control radix.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410505825.9A CN104281667A (en) | 2014-09-28 | 2014-09-28 | Expansible budget control device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410505825.9A CN104281667A (en) | 2014-09-28 | 2014-09-28 | Expansible budget control device and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104281667A true CN104281667A (en) | 2015-01-14 |
Family
ID=52256540
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410505825.9A Pending CN104281667A (en) | 2014-09-28 | 2014-09-28 | Expansible budget control device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104281667A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108776925A (en) * | 2018-06-27 | 2018-11-09 | 广东正来科技有限公司 | A kind of concrete order control method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5752233A (en) * | 1993-10-20 | 1998-05-12 | Hitachi, Ltd. | System and method for budget compilation under parallel/distributed processing |
| CN101145163A (en) * | 2007-10-30 | 2008-03-19 | 金蝶软件（中国）有限公司 | Method and system for obtaining data from a plurality of data pool |
| CN101694707A (en) * | 2009-11-09 | 2010-04-14 | 金蝶软件（中国）有限公司 | Method and device for budget control |
| CN101963970A (en) * | 2010-01-12 | 2011-02-02 | 浪潮(山东)电子信息有限公司 | Data statistics method with high efficiency and low maintenance |
| CN102043860A (en) * | 2010-12-27 | 2011-05-04 | 用友软件股份有限公司 | Method and device for controlling limit of document |
-
2014
- 2014-09-28 CN CN201410505825.9A patent/CN104281667A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5752233A (en) * | 1993-10-20 | 1998-05-12 | Hitachi, Ltd. | System and method for budget compilation under parallel/distributed processing |
| CN101145163A (en) * | 2007-10-30 | 2008-03-19 | 金蝶软件（中国）有限公司 | Method and system for obtaining data from a plurality of data pool |
| CN101694707A (en) * | 2009-11-09 | 2010-04-14 | 金蝶软件（中国）有限公司 | Method and device for budget control |
| CN101963970A (en) * | 2010-01-12 | 2011-02-02 | 浪潮(山东)电子信息有限公司 | Data statistics method with high efficiency and low maintenance |
| CN102043860A (en) * | 2010-12-27 | 2011-05-04 | 用友软件股份有限公司 | Method and device for controlling limit of document |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108776925A (en) * | 2018-06-27 | 2018-11-09 | 广东正来科技有限公司 | A kind of concrete order control method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10824758B2 (en) | System and method for managing enterprise data | |
| MY188126A (en) | System and method for information protection | |
| EP3070657A1 (en) | Method and system for water production and distribution control | |
| WO2015023983A3 (en) | Network-based marketplace service for facilitating purchases of bundled services and products | |
| CN103020750A (en) | Process report generation method and device | |
| WO2020060181A3 (en) | Human resource information utilization system and operation method of same | |
| CN105677751A (en) | Relation-type database scheduling method and system | |
| CN104462903A (en) | Operation system authority processing method and device | |
| CN102521713B (en) | Data processing equipment and data processing method | |
| CN105046419A (en) | Emolument data processing method and device | |
| CN102999475B (en) | Actual figure generating apparatus and by computer implemented actual figure generation method | |
| CN104281667A (en) | Expansible budget control device and method | |
| CN103984549A (en) | General paging query method and system based on SSH framework | |
| US20160196518A1 (en) | Intelligent Business Support System | |
| CN113469637A (en) | Subsidy issuing method and system | |
| CN105824637B (en) | Method for inquiring customization and system | |
| KR102547033B1 (en) | Method for providing information in the way user selected using keyword recognition function | |
| CN107861998A (en) | Introduction method, device and the computer equipment of business datum | |
| GB2452460A (en) | Methods, apparatuses and programs for using an sh interface for communications between a database client and a database server | |
| CN102855250A (en) | Method and system for display output of user information | |
| EP3759665A1 (en) | Multi-dimensional organization of data for efficient analysis | |
| CN103699384A (en) | Rapid development method for project process management and data content management | |
| CN108038733A (en) | One kind integration cut-in method and its system | |
| US20200311833A1 (en) | Gas recharge management method based on compound internet of things (iot) and iot system | |
| CN102129455A (en) | Patent retrieval method and system based on cloud storage |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150114 |
|
| RJ01 | Rejection of invention patent application after publication |