CN103679373A - Full chain budget data processing system and method for production infrastructure standard cost system - Google Patents

Abstract

The invention discloses a full chain budget data processing system and method for a production infrastructure standard cost system. The budget data processing system comprises an application layer, a budget layer and a control layer, the application layer comprises a system management module, the system management module comprises a user management unit, an authority management unit, a system setting unit, an interface management unit, a reminding management unit and a personalization setting unit. The budget layer comprises a price library of goods and supplies, a production standard cost unit, an infrastructure standard cost unit, a budget preparatioin unit and a country company budget unit. The price library of the goods and materials receives data of the system management module and transmits the data to the production standard cost unit and the infrastructure standard cost unit, and the production standard cost unit and the infrastructure standard cost unit transmit the data to the budget preparation unit and the country company budget unit. Finance business information which is rapid, accurate and comprehensive can be provided, a perfect and effective analyzing means can be provided, and the full chain budget data processing system can form a networked financial management information system in combination with an existing ERP system in a high integration mode.

Description

Full chain budgetary data processing system and the method for production capital construction standard cost system

Technical field

The present invention relates to a kind of full chain budgetary data processing system and method for producing capital construction standard cost system.

Background technology

At present, ripe package software and financial managing and control system substantially meet State Grid Corporation of China to budget formulate and submit, the needs of the financial base conditioning such as process control, but the reality in conjunction with company, aspect budget process of refinement, also exist some links to need further to strengthen: pay attention to budget and process sequencing, but the newest fruits that budget is processed application to be not enough; Inner canned program is more, responds not prompt enoughly, is difficult to realize quickly user's processing demands; Project information is too disperseed, be difficult to the complete reflection project implementation process, implement dynamic etc.

Existing ripe package software and financial managing and control system are not all considered the real-time control of tracking control of full process and the project data of project data substantially.

Prior art does not travel through all schemes under electric pressure, does not consider the coupling that realizes parameter by weight, and existing matching scheme is redundancy too.

How prior art prevent in the modification of the budget data that maloperation causes and the processing of data interlock/release, perfect not, has to be strengthened.

Prior art was not yet mentioned merging and the duplicate removal of project data, and according to bullets, (definition number) do not merge into a complete project data by the interface data of SAP system and financial management and control module.

Prior art does not have the configuration of project threshold value of warning, cannot avoid analyzing data and occur the problems such as abnormal.

Therefore, State Grid Corporation of China a set ofly can provide fast, accurate and comprehensive financial affair work information and perfect, effective analysis means in the urgent need to setting up, and with existing ERP system can be highly integrated budgetary data processing system.

Summary of the invention

Object of the present invention is exactly in order to address the above problem, a kind of full chain budgetary data processing system and method for producing capital construction standard cost system is provided, it has financial affair work information and perfect, the effective analysis means that can provide fast, accurate and comprehensive, and with existing ERP system can be highly integrated the advantage of networking financial management information system.

To achieve these goals, the present invention adopts following technical scheme:

The full chain budgetary data processing system of production capital construction standard cost system, comprises application layer, budget layer and key-course,

Described application layer comprises system management module, and described system management module comprises service management unit, rights management unit, system setting unit, interface management unit, prompting administrative unit and personal settings unit;

Described system management module, for the infrastructure service of system operation is provided, meets from different aspects such as application, safety, data interactions the requirement that system is used.Major function comprises user management, system setting, personal settings and data-interface four major parts, and user management provides the functions such as newly-increased, change to system user, right assignment; System setting comprises the management of the Back ground Informations such as unit, department, user role, systemic-function menu; Personal settings provide functions such as revising personal information, password replacement, system interface personalization; Data-interface mainly provides statistics and the monitoring of each data-interface transmission situation of system.

Described service management unit is for the maintenance of system user account number, personal information and account authority.User management provides to be carried out additions and deletions to System Operation User and changes the management service of looking into fundamental operation function, maintenance system user's name, unit, user name, sex, the various essential informations of post, set user's operating right, the system access situation that can also check each user simultaneously.

Described rights management unit, for taking the open strategy of difference in functionality to dividing the work different users, makes user according to own demand, use system very easily, and the while also filters not belonging to the function of working range.So not only improve the security of system, also can prevent the situation of data corruption between different departments.

Described system setting unit is for representing the setting to user's difference in functionality interface according to different demands, and the information of service companies subordinate unit, creates user's the infrastructure services such as use role.

Described interface management unit is for monitoring and data statistics situation to ERP and two systems of financial management and control and native system data interaction every day, and system can view the synchronous daily record of data, and system also can provide warning function extremely to undesired data interaction.After having abnormal problem, data may be again mutual, sometimes can affect the renewal not in time of data, and for solving problems, system provides manual triggering timed task to solve the problem that data gather.

Described prompting administrative unit is for data and the index effect that do not reach or surpass the expectation, and system can provide eye-catching sign to data exhibiting according to judgement, is convenient to eye-catching the pinpointing the problems and processing in time of user.

Described personal settings unit is used for changing entire system style and pattern, and user can arrange according to individual hobby the style of system.

Described budget layer comprises price of material storehouse, production standard cost-element, capital construction standard cost unit, budget compilation unit and county company budget unit, the data of described price of material storehouse receiving system administration module, and transferring data to production standard cost-element and capital construction standard cost unit, described production standard cost-element and capital construction standard cost unit transfer data to budget compilation unit and county company budget unit;

Described price of material storehouse, for by the analysis to purchase of goods and materials price, the amount of money, quantity and frequency four dimensions, provides emphasis material screen choosing method.By the real-time monitoring to purchase of goods and materials, set up the monitoring of price of material alteration trend, for changing and carry out operational decision making, level of organization cost budgeting, analysis cost provide support.

Described production standard cost-element is for studying the structure and characteristic of production standard cost, according to equipment, job class, activity, in conjunction with artificial, vehicle machine-team, Master Cost etc., the production standard that power transformation, circuit, marketing, management, dispatching communication five large administrative units are set up in research becomes body series.And according to standard cost achievement in research, by the hook coefficient of self-defined measure formula and various parameters, set up budgeting model, budgetary technique and the means of scientific, robotization, flexibility are provided.

Described capital construction standard cost unit is used for based on State Grid Corporation of China's capital construction standard cost achievement in research, by analysis project parameter, form, optimize, simplify the input parameter of engineering cost measuring and calculating, effectively reduce capital construction standard cost measuring and calculating complexity, improve measuring and calculating efficiency, and include results of measuring in construction project budget compilation.

Described budget compilation unit, for the organic linking of Criterion cost and budget compilation, provides systematization, robotization, intelligentized budgetary technique, carries out the standard cost measuring and calculating of cost-effectivenes expenditure and capital expenditure.

Described county company budget unit is for the budget management requirement according in State Grid Corporation of China twice two, and standard is also set up the unified budget management system that covers 97Jia county company; Realize the many version managements of yearly budget, the ladder of management such as budget compilation, batch index in batches substitute, examination revision in batches, key index monitoring and early warning are provided, improved the science of county company budget compilation and worked out efficiency.

Described key-course comprises project tracking control of full process module and output module;

Described project tracking control of full process module is obtained the project real-time information of each operation system and is set up corresponding whole process supervision system, described whole process supervision system comprise cover approve and initiate a project, can grind, give an written reply, establishment, procurement request, bid, purchase order, invoice verification, warehouse-in, outbound be to completion, clearing and final accounts.

Described output module is for carrying out integration exhibition to the project information of each operation system, can realize according to dimensions such as Project Unit, professional type, orders of magnitude, annual tens thousand of the project implementation states of the company of grasp in real time and implementation progress, and by responsible party's division, take targetedly supervision and examination measure.

The management-control method of the full chain budgetary data processing system of described production capital construction standard cost system, is mainly divided into following steps:

Step (1): system management module initialization: comprise user management, rights management, system setting, interface management, prompting management and personal settings;

Step (2): the data of price of material storehouse receiving system administration module, and transferring data to production standard cost-element and capital construction standard cost unit, described production standard cost-element and capital construction standard cost unit transfer data to budget compilation unit and county company budget unit; Price of material arrangement is carried out in price of material storehouse, production standard cost-element carries out the production of standard cost, capital construction standard cost unit carries out the measuring and calculating of substation project standard cost, the measuring and calculating of power transmission engineering standard cost and the measuring and calculating of power transmission and transformation standard cost, budget compilation unit is for the organic linking of Criterion cost and budget compilation, and county company budget unit carries out budget;

Step (3): budget compilation unit and county company budget unit by data upload to project tracking control of full process module and output module; Project tracking control of full process module is carried out project tracking, annual tens thousand of the project implementation states of the company that grasps in real time and implementation progress.

Comprising of the middle capital construction standard cost unit of described step (2): the measuring and calculating of power transformation engineering standard, the measuring and calculating of power transmission engineering standard and three parts of power transmission and transformation standard cost measuring and calculating.

In described step (2), the summary job step of capital construction standard cost unit is:

Step (2A-1): input infrastructural project core parameter; Described infrastructural project comprises power transmission engineering, power transformation engineering and project of transmitting and converting electricity;

Step (2A-2): according to electric pressure coupling respective standard storehouse; Described java standard library is according to the historical experience of transformer station of Ge Wangsheng company, transmission line construction, according to electric pressure, power distribution equipment, capacity Engineering Project Construction parameter, engineering construction is divided into different schemes, for instructing, calculate the Standard Rate of the engineering construction of each company;

Step (2A-3): according to core parameter matching scheme;

Step (2A-4): carry out submodule increase and decrease according to core parameter;

Step (2A-5): draw engineering measuring and calculating cost result.

The power transformation engineering standard cost measuring and calculating of described step (2) is mainly divided into following steps:

Step (2A-1-1): input transformer substation construction engineering core parameter; Described transformer substation construction engineering core parameter comprises electric pressure, power distribution equipment, capacitance, current period main transformer quantity, main transformer quantity at a specified future date;

Step (2A-1-2): judgement electric pressure, according to different electric pressures, select different power transformation java standard libraries, described power transformation java standard library comprises 500kv, 220kv, tri-electric pressures of 110kv;

Step (2A-1-3): travel through all schemes under corresponding electric pressure, for each scheme, mate one by one substation project core parameter, by the coupling of different weights to substation project core parameter, the coupling mark that gathers each scheme, find out the scheme that score is the highest, search the standard cost numerical value of this scheme, according to substation project core parameter and scheme basic module number, compare, described scheme comprises power transformation engineering and the power transmission engineering typical scenario of setting up based on State Grid Corporation of China's capital construction standard cost achievement in research.

Step (2A-1-4): judge that whether participation scheme basic module is consistent, if just calculate the cost of increase and decrease according to the increase and decrease of subscheme basic module quantity, enter step (2A-1-5); If not, just use scheme standard cost as the measuring and calculating cost of this project;

Step (2A-1-5): deduct submodule increase and decrease cost after adding by scheme standard cost; Obtain the measuring and calculating cost of this project.

The power transmission engineering standard cost measuring and calculating of described step (2) is mainly divided into following steps:

Step (2A-2-1): input power transmission engineering core parameter, described power transmission engineering core parameter comprises that electric pressure, circuit are in the length of each landform, judgement electric pressure, according to electric pressure, select different transmission of electricity java standard libraries, described electric pressure comprises 500kv, 220kv, 110kv, and described power transmission engineering refers to the construction project for the circuit of transferring electric power;

Step (2A-2-2): travel through all landform schemes under this electric pressure, in judgement landform scheme, be the landform such as level land, hills or mountain region, thereby determine optimal typical scenario, then carry out cost increase and decrease according to engineering consumption, draw the measuring and calculating cost of this landform;

Step (2A-2-3): the cost of cycle calculations engineering under each landform, above-mentioned various places shape cost result is added up, gather measuring and calculating cost, add other fees and communication cost, obtain the measuring and calculating cost result of this project.

The power transmission and transformation standard cost measuring and calculating of described step (2) is mainly divided into following steps:

Step (2A-3-1): the core parameter of the comprehensive construction engineering that input power transformation and transmission of electricity are built, system decomposition is power transmission engineering and power transformation engineering;

Step (2A-3-2): according to transmission of electricity core parameter, the standard cost of measuring and calculating this project transmission of electricity part; Meanwhile, according to power transformation core parameter, the standard cost of measuring and calculating this project power transformation part;

Step (2A-3-3): gather and obtain project of transmitting and converting electricity cost accounting result.

The specific works step of the production standard cost-element of described step (2) is:

Step (2B-1): revise production standard storehouse; Described production standard storehouse is the core of production standard cost-element, by activity in production standardization, and the concept of introducing the operation frequency is average to annual by the activity in production of burst, unconventionalization (as ad hoc inspection and repair etc.), to quantize more accurately a year operating cost;

Step (2B-2): typical case's measuring and calculating: take standard operation storehouse as foundation, set up typical data model, user can add and delete exemplary apparatus quantity, type according to actual conditions;

Step (2B-3): upload cities and counties' corporate assets data; Described asset data, for showing group company and each city-level and corporate assets information state statistical form at county level, comprises transformer station, circuit, management and the relevant company's situation information of marketing four large class;

Step (2B-4): self-defining formula, hook coefficient; Described self-defining formula organically combines the production standard storehouse in assets storehouse, production standard cost, typical results of measuring for the form by formula; Described hook coefficient is adjusted according to actual knowhow the result of budget compilation;

Step (2B-5): produce budget compilation: take production standard cost as basis, grass-roots unit reports asset data, can automatically complete the budget compilation of power transformation, circuit, marketing and the handling cost four module of each company by self-defined budget formula, hook coefficient;

Step (2B-6): adjust budget data.

The specific works step in the modification production standard storehouse of described step (2B-1) is:

Step (2B-1-1): start; Whether judgement homework type, have concrete operation, if just select administrative unit from the power transformation in production standard storehouse, circuit, marketing, dispatching communication module, carry out plant maintenance, and enter step (2B-1-2), if not, with regard to handling cost standard, revise cities and counties company quota, save data; Finish; Described production standard storehouse is divided into power transformation, circuit, marketing, management, dispatching communication 5 modules, wherein power transformation, circuit, marketing, management, the every part of dispatching communication are further subdivided into each administrative unit, each administrative unit comprises a plurality of electric pressures, and it is detailed that each electric pressure comprises a plurality of individual event operations; Administrative unit, make sparetime university's class, individual event operation detail all allows additions and deletions to change; Administration module is according to personnel, assets, marketing scale, behavior, policy reason classification setting cities and counties company quota;

Step (2B-1-2): judge whether to distinguish electric pressure, safeguard if just start electric pressure, then start to do sparetime university's class and safeguard, safeguard with regard to directly making sparetime university's class if not;

Step (2B-1-3): operation is detailed to be safeguarded.

The specific works step of typical case's measuring and calculating of described step (2B-2) is:

Step (2B-2-1): selection need to be carried out the administrative unit of typical case's measuring and calculating; Judge whether to safeguard exemplary apparatus, and enter step (2B-2-2), if just carry out plant maintenance, just finish if not;

Step (2B-2-2): user selects as required newly added equipment, revises device parameter or sweep equipment; Finish.

The specific works step of uploading cities and counties' corporate assets data of described step (2B-3) is:

Step (2B-3-1): budget year is set;

Step (2B-3-2): selection company;

Step (2B-3-3): select assets information file;

Step (2B-3-4): upload assets information.

The flow process of the self-defining formula of described step (2B-4) is:

Step (2B-4-1): the self-defining formula project of selecting to need change;

Step (2B-4-2): revise formula: direct editing formula content or selection formula Data Source, described formula Data Source comprises the assets information that result, hook coefficient or the cities and counties company of typical case's measuring and calculating upload;

Step (2B-4-3): after having revised, whether test formula is correct;

Step (2B-4-4): preserve self-defining formula.

The job step of the budget compilation of described step (2B-5) is:

Step (2B-5-1): start;

Step (2B-5-2): judge whether it is marketing, if just calculate marketing year workload, then carry out standard cost measuring and calculating, just directly carry out standard cost measuring and calculating if not.

The specific works step of the county company budget unit of described step (2) is:

Step (2C-1): data acquisition: financial management and control module manually or is regularly called native system interface service, pushes data into native system by the service of ESB bus, and native system receives after interface data through resolving, and extracts data and deposits middle table in; Enter respectively step (2C-3);

Step (2C-2): the beginning of the year budget compilation; Budget compilation in year; The year end, index was controlled; Finish; Described beginning of the year, budget compilation was that the budget that county company is reported is examined, calculates, substituted in batches and generate budget and assigns table according to budget compilation flow process in Guo Wang company twice two; In year, budget compilation is annual July, according to constituent parts business circumstance to flow process that the beginning of the year, budget was adjusted; Described year end, index was controlled as per end of the year, and according to the actual business circumstance of constituent parts, Ge county, the Dui Gai of You Ge city company city company profit and loss budget carries out balance, thus the total profit of generation constituent parts and controllable expenses appraise and decide number final year;

Step (2C-3): budget enforcement analysis, by the monthly actual number that occurs of integrated service system budget index, what analyze index assigns budget and the actual difference that a situation arises, finishes; Described budget enforcement analysis is that actual a situation arises analyzes to the budget target of the units moon, contrast the deviation ratio of monitoring constituent parts budget enforcement (yearly budget draws deviation ratio with of that month actual contrast after monthly decomposing) with the budget of assigning in year.

The concrete steps of described step (2C-1) are:

Step (2C-1-1): native system and financial management and control module have 2 about the interface of county company budget part: data-interface is made a report in the budget of Yi Shi county company, and the budget data that this interface synchronization county company makes a report in financial management and control module is to native system.This interface is that manual triggers is carried out, and when county company, in financial management and control module, makes a report on after budget, and group financial portion carries out preliminary audit survey, and audit is synchronized to native system by this interface of rear triggering by data; Er Shi county company budget wall bulletin interface, each county company of this interface synchronization is actual revenue and expenditure, the every expense situation relevant with budget occurring monthly, is convenient to native system and carries out budget enforcement analysis;

Step (2C-1-2): the interface data between system all will send to the service of the ESB of enterprise data bus, transmits by ESB data bus; The interface service that management and control instrument provides, calls and accepts for SAP system and financial management and control module the project data that ESB data bus pushes;

Step (2C-1-3): the data of project data interface are stored and transmitted in the mode of XML document flow, management and control instrument is resolved XML file after receiving XML document flow, extracts required project data; XML is XML (extensible Markup Language), can be used as data carrier and carries out interface data transmission, and can be resolved by different system;

Step (2C-1-4): data deposit database middle table in: first intact being saved in intermediate data table of external system interface data that management and control instrument receives, be convenient to subsequent project analysis and history and review;

Step (2C-1-5): data deposit traffic table in: interface data is saved in after intermediate database table, final updated is in Service Database table, for budget compilation, audit.

Described step (2C-2) the beginning of the year budget compilation and year in budget compilation concrete steps be:

Step (2C-2A-1): set budget year, set budget version, the budget that typing business department provides; Carry out respectively system automatic measurement & calculation partial budget index and manual retouch budget target in batches; Described budget year is for setting the budget data year of county company budget module, this setting year is all got in each relevant sub-module correlation function unifications such as the budget compilation at the beginning of the year of the rear county of setting company budget module, budget adjustment in year, index control at the year end, budget enforcement analysis, without setting one by one; Described budget version be the beginning of the year version of budget compilation be divided on one, assign in advance, formally assign, this function is the unified versions of data of setting budget compilation at the beginning of the year, sets unified this setting versions of all getting of each submodule such as budget compilation Xia county company budget at the beginning of the year after next, operating budget, budget auditing revision; The budget that described typing business department provides: partial budget index is provided by management through specialized department department, as data such as the electric weight of constituent parts, electricity price, line loss, wages, these budget targets budget compilation with assign in the system budget data that can automatic replacement becomes business department to provide; System automatic measurement & calculation partial budget index: partial budget index system is calculated again, as rural power grids repay to be returned income, controllable costs, three expenses etc., the index (can adjust again by hand) after these systems measuring and calculating can replace at budget compilation with while assigning the budget data that county company makes a report on; Described manual retouch budget target in batches: when budget audit is adjusted, partial budget index is as financial expense, social security expense, amortization charge etc., system provides the function of adjustment in batches, can in a page, adjust these expense indexs of Ge Jia county company, the index after adjustment can substitute at budget compilation with while assigning the budget data that county company makes a report on;

Step (2C-2A-2): system budget establishment: the budget data of the budget data that system provides according to business department and system measuring and calculating, manual setting, replace the associated budget data that county company makes a report on, all the other are got county company and make a report on data, finally generate the yearly budget table of each county company;

Step (2C-2A-3): locking edition data, system generates budget and assigns table: after budget compilation completes, in order to prevent maloperation modification budget data, can carry out edition data locking, the edition data after locking cannot be modified; System automatically generates the budget of each county company and assigns table, and budget is assigned to be divided into and assigned in advance and formally assign, and assigns in advance and comprises that table is assigned in performance assessment criteria budget, profit and loss budget assigns table and asset-liability budget is assigned table.Formally assign and mainly comprise following 6 budget tables: Main Management index budget summary, profit and loss budget are assigned table, asset-liability budget and assigned table, cost budget and assign that table, operating budget are assigned table, the Nong Weifei budget for revenues and expenditures is assigned table.

The specific works step that the year end of described step (2C-2), index was controlled is:

Step (2C-2B-1): typing city company is to county company profit and loss budget equilibrium number: the year end is according to the actual production business circumstance of each county company, the profit and loss budget index of the Hui Duidui of city company Ying County company is carried out overall equilbrium, and the index after balance completes examination standard as the year-end budget of county company;

Step (2C-2B-2): manual setting county company partial budget index: the rural power grids of each county company of the manual adjustment in batches of group financial repay returns, rural power grids interest, price modification influence index, for controllable expenses at the end of determining and total profit, finally appraise and decide number;

Step (2C-2B-3): system-computed county corporate profit total value and controllable expenses are are finally appraised and decided number: system is according to the controllable expenses of budget adjustment in year and total profit, in conjunction with the budget equalization number of city company, calculate each county company the year end controllable expenses and total profit finally appraise and decide number.

The concrete steps that the budget enforcement of described step (2C-3) is analyzed are as follows:

Step (2C-3-1): select budget analysis month: select budget analysis month corresponding to form, in form, the data of actual generation in this year are actual generation of this month number;

Step (2C-3-2): data query is assigned in budget: data are assigned in the up-to-date budget of system queries;

Step (2C-3-3): selected month wall bulletin data query: the actual generation data in selected month of system queries (from synchronous each month wall bulletin data of financial management and control module interface);

(reality-budget/12) * month/(budget/12* month)) etc., actual generation and the index such as yearly budget difference step (2C-3-4): system-computed budget enforcement deviation ratio: system is according to yearly budget and monthly actual generation, calculates gradient on year-on-year basis (the actual gradient on year-on-year basis with reality last year in this year), budget enforcement deviation ratio (formula:; Whether step (2C-3-5): budget enforcement analytical statement is shown: budget enforcement analytical statement mainly comprises performance assessment criteria and important indicator Track Table, mainly monitor certain month actual generation and conform to (budget is monthly decomposed) with yearly budget; Budget enforcement analytical table, the budget targets such as the Main Analysis profit and loss, asset-liabilities, cost, capital revenue and expenditure actual completes the implementation deviation rate with yearly budget.

The workflow in the price of material storehouse of described step (2) is: SAP price purchase records; Data processing; Data display.

The specific works flow process in the price of material storehouse of described step (2) is:

Step (2D-1): emphasis material screening condition setting, described screening conditions comprise procurement price, purchase quantity, the buying frequency, procurement value;

Step (2D-2): emphasis material screening: the conditional filtering emphasis material according to arranging, is saved in emphasis material library;

Step (2D-3): set up various dimensions inquiry; If need statistical study to enter step (2D-4); If material inquiry enters step (2D-5);

Step (2D-4): statistical study, if material procurement statistics and Classification of materials statistics are just carried out in tabulate statistics; If material procurement analysis and upward price trend analysis are just carried out in trend analysis;

Step (2D-5): material inquiry, carry out respectively detail inquiry and minute group polling.

The specific works step of the project tracking control of full process of described step (3) is:

Step (3A-1): data acquisition: SAP system, financial management and control module are regularly called native system interface service, push data into native system by the service of ESB bus, native system receives after interface data through resolving, and extracts data and deposits middle table in;

Step (3A-2): data preparation and data integration, data processing: read the data that SAP system, financial management and control module are transmitted by interface in intermediate list, merge, be updated in project real-time table after duplicate removal, regularly carry out storing process every day and calculate year, month number occurring, and be updated in the year and monthly table of project of projects;

Step (3A-3): data display: according to the querying condition judgement of user's typing, if inquiry latest data carries out garbled data from project real-time table; If enquiry of historical data, the current year, historical data was carried out garbled data from the monthly table of project; Historical annual data carries out garbled data from project annual table.

Described project tracking control of full process is the anatomy to project implementation chain, studies the responsible party of each link, has drawn the full chain structure of the project implementation, can understand at any time project in the implementation status of links.

The concrete steps of described step (3A-1) data acquisition are:

Step (3A-1-1): SAP system is called native system interface service by ESB data bus, and feed back and call result, electric system management and control module is called native system interface service and is received feedback by ESB data bus and calls result; The project relevant interface of SAP system and native system is as follows, and interface data is regularly carried out morning every day, project data interface, project account data-interface, annual investment plan data-interface; The project relevant interface of SAP and native system is project payment application interface, and this interface is carried out regular morning; Interface data between system all will send to the service of the ESB of enterprise data bus, by ESB data bus, transmits;

Step (3A-1-2): management and control instrument receives the data that transmit by ESB data bus, and feedback result is fed back to SAP system or electric system management and control module by ESB data bus, the interface service that management and control instrument provides, calls and accepts for SAP system and financial management and control module the project data that ESB data bus pushes;

Step (3A-1-3): management and control instrument transfers data to XML Data Analysis: the data of project data interface are stored and transmitted in the mode of XML document flow, management and control instrument is resolved XML file after receiving XML document flow, extracts required project data;

Step (3A-1-4): data deposit database middle table in: first intact being saved in intermediate data table of external system interface data that management and control instrument receives, be convenient to subsequent project analysis and history and review.

The concrete steps of (3A-2) data preparation of described step and data integration and data processing are:

Step (3A-2-1): SAP middle table data are extracted: read project data the project interface data middle table receiving from SAP system; Electric system management and control middle table data are extracted: the project interface data middle table receiving from financial management and control module, read project data;

Step (3A-2-2): project data merges, duplicate removal: according to bullets (definition number) interface data of SAP system and financial management and control module is merged into a complete project data.As there being the project of a plurality of identical numberings in an interface transmission, get last received data, give up the repeating data receiving above;

Step (3A-2-3): Data Update is to project real-time table: the project data by duplicate removal, after merging is updated in project real-time table according to bullets, upgrades operation as project has existed to carry out in real-time table; As do not existed in real-time table, carry out newly-increased operation, according to project threshold value of warning allocation list discriminatory analysis data, whether have extremely, if just Data Update is arrived to project early warning table; Described project early warning threshold values allocation list is abnormal cost, the expense situation occurring for monitor project the term of execution, system made project early warning threshold values allocation list; By the analysis of configuration early warning threshold values, filter out cost, project that expense is abnormal, as monitor this day Project Cost amount than the low project of yesterday; Described Data Update is in storing process timing every day implementation to project early warning table, to project real time data analyze, monitor project cost, a situation arises for expense, if any the cost, the cost data that reach threshold values, by item record in project early warning table;

Step (3A-2-4): data are aggregated into project annual table or the monthly table of project by storing process: system made project annual table, is saved in project annual table by the actual every cost occurring, the difference of expense during project year.A situation arises for cost, the expense of the project annual table record entry in current year from the beginning of the year to current reality (being difference current and beginning of the year cost, expense).Storing process is regularly carried out once every day; The monthly table of system made project, by project each monthly during the actual every cost occurring, the difference of expense be saved in the monthly table of project.A situation arises for cost, the expense of the monthly table record project of project in current month from the current beginning of the month to current reality (being difference current and beginning of the month cost, expense).Storing process is regularly carried out once every day.

Described step (3A-3) data display process is as follows:

Step (3A-3-1): input filtercondition; The condition that querying condition region input in inquiry, the statistics page will be filtered, basic filtering condition and Geng Duo filtercondition are divided in filtercondition region, and basic filtering condition is shown the most frequently used filtercondition; More filterconditions region is defaulted as hiding, this district inclusion time conventional, more rich querying condition; User is Select input according to circumstances;

Step (3A-3-2): judge between advisory area whether the phase on duty for the day of condition is less than current date, if just enter step (3A-3-3); If not, just enter step (3A-3-4); Between inquiry/Statistical Area, the start time is defaulted as sky, is defaulted as current time closing time, if do not change this time system from project real-time table, filter, screening programme data; As selected, inquire about the start time or revise and inquire about closing time, there are data in (annual table or monthly table) screening historical stage from history of project table;

Step (3A-3-3): the data that read respectively project year and monthly generation; Enter step (3A-3-5);

Step (3A-3-4): read project real time data; Enter step (3A-3-5);

Step (3A-3-5): show according to project detail, time dimension, specialty, progress dimension, unit, project category: the detailed data record that displaying project is up-to-date, real-time, and to project from the approval stage to implementing, a situation arises by the form of traffic lights, intuitively shows for every cost, the expense in ending stage.Each stage and cost, fee item comprise bullets, affiliated company, project basic condition, project approval stage, project implementation phase, project conclusion stage.

Described project basic condition: comprise project assign year, classification, attribute, emphasis/autonomous, batch, title, authentication code, plan open completion date.

The described project approval stage: comprise project verification, can grind, give an written reply, just establish, Budget at Completion, pogo plan then.

Described project implementation phase: comprise project front-end fee with, procurement request, bid, purchase order, cash budget, invoice verification, go out cost, the Fee Amount data such as warehouse-in, cost payout, payment funding.

Described project conclusion stage: comprise project completion date of construction, project clearing, a situation arises for project final accounting.

Described by specialty show be by career field dimension show project a situation arises in real time, can follow the tracks of each career field in the implementation status of the full chain links of project, and the completed percentage of each cost, expense

The described unit of pressing shows (in real time): the unit's of pressing dimension displaying project a situation arises in real time, can monitor the progress situation of each unit here, and the completed percentage of each cost, expense.Be conducive to carry out the monthly cash budget control of constituent parts.

Described by time dimension statistics (in real time): the performance of adding up each moon (by current month) budget items by time dimension.

Described by progress dimension statistics (in real time): to add up in each stage implementation progress comparatively fast or slower unit and detailed programs, so that supervise progress, investigation project hysteresis reason.As, screen the unit that cost payout then surpasses pogo plan 50%.

Described by project category statistics (in real time): add up in of all categories, unit, year certain exhibition method by the accumulative total to the same day, history item master budget, project total quantity, project kickoff situation, completion situation during certain, situation does not go into operation.

Described early warning Project Exhibition: show the project that meets early warning threshold values, cost, fee item and the amount that can check specific coding, title and the warning of project, and the time of reporting to the police and occurring.

The explanation of nouns of table 1 capital construction data integration unit

The explanation of nouns that table 2 production data is integrated

The explanation of nouns of table 3 database

The explanation of nouns of table 4 data analysis and control

Beneficial effect of the present invention:

1, the present invention considers the real-time control of tracking control of full process and the project data of project data, and first intact being saved in intermediate data table of external system interface data that management and control instrument of the present invention receives, is convenient to subsequent project analysis and history and reviews; Described project tracking control of full process is the anatomy to project implementation chain, studies the responsible party of each link, has drawn the full chain structure of the project implementation, can understand at any time project in the implementation status of links.

2, the present invention travels through all schemes under corresponding electric pressure, for each scheme, mate one by one substation project core parameter, by the coupling of different weights to substation project core parameter, the coupling mark that gathers each scheme, find out the scheme that score is the highest, search the standard cost numerical value of this scheme, according to substation project core parameter and scheme basic module number, compare.

3, the present invention revises budget data in order to prevent maloperation, can carry out edition data locking, and the edition data after locking cannot be modified.

4, the present invention according to bullets (definition number) interface data of SAP system and financial management and control module is merged into a complete project data.

5, the project data after duplicate removal, merging is updated in project real-time table according to bullets, as project has existed to carry out in real-time table, upgrades operation; As do not existed in real-time table, carry out newly-increased operation, according to project threshold value of warning allocation list discriminatory analysis data, whether have extremely, if just Data Update is arrived to project early warning table; Described project early warning threshold values allocation list is abnormal cost, the expense situation occurring for monitor project the term of execution, system made project early warning threshold values allocation list; By the analysis of configuration early warning threshold values, filter out cost, project that expense is abnormal, as monitor this day Project Cost amount than the low project of yesterday; Described Data Update is in storing process timing every day implementation to project early warning table, to project real time data analyze, monitor project cost, a situation arises for expense, if any the cost, the cost data that reach threshold values, by item record to call user's attention in project early warning table.

6, the data of project data interface are stored and are transmitted in the mode of XML document flow, and management and control instrument is resolved XML file after receiving XML document flow, extracts required project data; XML is XML (extensible Markup Language), can be used as data carrier and carries out interface data transmission, and can be resolved by different system;

7, by building full chain budget management and control instrument, prune a budget and the workload of capital construction financial staff to daily management business, promote management and control efficiency.By innovation financial management means, reduce uncertainty and risk in decision-making, improve Decision Quality, for supporting next step financial strategy development and company's reform that Important Platform is provided.In view of this project has been listed in State Grid Corporation of China's scientific and technological development management project in 2012, expection, on the basis of practical, the ease-of-use of exploitation, high efficiency management tool, is made the innovation of Guo Wang company management and the brand engineering of providing quality goods or brilliant of trying to be the first.

Accompanying drawing explanation

Fig. 1 is overall flow figure of the present invention;

Fig. 2 is the process flow diagram of capital construction standard data element of the present invention work;

Fig. 2 .1 is substation project normal data measuring and calculating process flow diagram of the present invention;

Fig. 2 .2 is power transmission engineering normal data measuring and calculating process flow diagram of the present invention;

Fig. 2 .3 is power transmission and transformation normal data measuring and calculating process flow diagram of the present invention;

Fig. 3 is the process flow diagram of production standard data cell of the present invention work;

Fig. 3 .1 is the work schematic diagram of operation or work standard of the present invention storehouse flow process;

Fig. 3 .2 is the work schematic diagram of typical case's measuring and calculating flow process of the present invention;

Fig. 3 .3 is the asset data flow process of uploading of the present invention;

Fig. 3 .4 is self-defining formula process flow diagram of the present invention;

Fig. 3 .5 is budget compilation process flow diagram of the present invention;

Fig. 4 is the workflow diagram of project tracking control of full process of the present invention;

Fig. 4 .1 is the process flow diagram of the part of data acquisition of project tracking control of full process of the present invention;

Fig. 4 .2 is the data preparation of project tracking control of full process of the present invention, integrated and processing processing;

Fig. 4 .3 is the process flow diagram of the data display part of project tracking control of full process of the present invention;

Fig. 5 is the process flow diagram of county of the present invention company budget;

Fig. 5 .1 is the process flow diagram of the part of data acquisition of county of the present invention company budget;

Fig. 5 .2 is the budget compilation process flow diagram at the beginning of the year of county of the present invention company budget;

Fig. 5 .3 is the index control flow chart at the year end of county of the present invention company budget;

Fig. 5 .4 is the budget enforcement analysis process figure of county of the present invention company budget;

Fig. 6 is the process flow diagram in price of material of the present invention storehouse;

Fig. 6 .1 is the particular flow sheet in price of material of the present invention storehouse.

Embodiment

Below in conjunction with accompanying drawing and embodiment, the invention will be further described.

As shown in Figure 1, Figure 2, shown in Fig. 2 .1, Fig. 2 .2, Fig. 2 .3,

(1) power transformation normal data measuring and calculating

1) input substation project core parameter, as electric pressure, power distribution equipment, capacitance, current period main transformer quantity, main transformer quantity at a specified future date etc.2) system judgement electric pressure, and navigate to the standard scheme under the relevant voltage grade in java standard library.3) travel through each standard scheme.4) for each scheme, mate one by one each core parameter, analyze its matching degree.5), according to the coupling weight of each preset parameter, record the coupling score value of this parameter in scheme, and record total score value of this scheme.6) gather the final score that obtains each scheme.7) obtain the scheme that score is the highest.8) obtain the normal data numerical value of this scheme.9) basic module of engineering core parameter and scheme being carried out to quantity compares.10), if the quantity of core parameter and basic module does not have difference, directly adopt the normal data of scheme as the normal data measuring and calculating value of this project.11) if variant, number of computations difference and corresponding submodule data calculated difference data thereof.12) use scheme normal data, add or deduct variance data.13) obtain the normal data results of measuring of engineering.

(2) transmission of electricity normal data

1) input power transmission engineering core parameter, if electric pressure, circuit are in the length of each landform etc.2) system judges electric pressure, navigates to the various standard schemes of this electric pressure from java standard library.3) travel through all landform schemes under this electric pressure.4) length and the scheme unit length normal data in this landform according to engineering, calculates this project in the data of this landform.5) data of cycle calculations engineering under each landform.6) above-mentioned each terrain data result is added up.7) add other fees and the communication engineering expense of this project.8) obtain the normal data results of measuring of this project.

(3) power transmission and transformation normal data

1) transmission of electricity part core parameter and the power transformation part core parameter of input project of transmitting and converting electricity.2) project data measuring and calculating is divided into transmission of electricity, two parts of power transformation.3) according to transmission of electricity core parameter, the normal data of measuring and calculating this project transmission of electricity part.4) according to power transformation core parameter, the normal data of measuring and calculating this project power transformation part.5) gather transmission of electricity, the two-part calculation of measured data of power transformation.6) obtain the measuring and calculating normal data result of this project.

As shown in Fig. 3, Fig. 3 .1, Fig. 3 .2, Fig. 3 .3, Fig. 3 .4, Fig. 3 .5,

(1) module whole flow process

Production standard data flow, from being modified to of production standard storehouse, typical electric system, circuit, the process of establishing of typical data model, the asset data reporting in conjunction with bottom server, by self-defining formula, hook coefficient, finally calculates all cities and counties company year budget data.

(2) production standard storehouse flow process

Production standard storehouse is divided into the 5 modules such as power transformation, circuit, marketing, management, dispatching communication, wherein power transformation, circuit, marketing, the every part of dispatching communication are further subdivided into each administrative unit, each administrative unit comprises a plurality of sparetime university's classes (electric pressure) of doing, and each is made sparetime university's class and comprises a plurality of individual event operations details.Administrative unit, make sparetime university's class, individual event operation detail can change in additions and deletions.Administration module is according to reason classification setting cities and counties company quotas such as personnel, assets, marketing scale, behavior, policies.

(3) typical case's measuring and calculating flow process

First select to carry out the administrative unit of typical measuring and calculating, then increase as required the parameter of deleting exemplary apparatus or change exemplary apparatus, then system meeting combined standard storehouse is to the typical model computational data of selecting, for later budget compilation provides data.(4) adjust self-defining formula, hook coefficient flow process

Self-defining formula:

The self-defining formula project that selection will be changed, can direct editing formula content or select formula Data Source, the assets information that Data Source can be uploaded for result, hook coefficient, the cities and counties company of typical case's measuring and calculating etc.After having edited, whether test formula is correct, then preserves self-defining formula content.

Hook coefficient: the hook coefficient that selection will be revised, after revising, preserve.

(5) budget compilation flow process

Power transformation, circuit, administration module can direct measurings, and marketing module need to first be calculated the year workload of cities and counties company, and then calculates.Use for the convenience of the user management, marketing module that one key measuring and calculating function is provided.

(6) budget compilation result is adjusted

The result of budget compilation can export as Excel form, if budget compilation result has deviation to adjust by revising the mode of self-defining formula, hook coefficient, or the Excel file data of direct editing derivation.

As shown in Fig. 4, Fig. 4 .1, Fig. 4 .2, Fig. 4 .3,

(1) module whole flow process is described

Data acquisition: SAP system, electric system management and control module are regularly called native system interface service, push data into native system by the service of ESB bus, native system receives after interface data through resolving, and extracts data and deposits middle table in.

Data preparation, integrated: read the data that SAP system, electric system management and control module are transmitted by interface in intermediate list, merge, be updated in project real-time table after duplicate removal.

Data processing: regularly carry out storing process every day and calculate year, month number occurring, and be updated in the year and monthly table of project of projects.

Data display: according to the querying condition judgement of user's typing, if inquiry latest data carries out garbled data from project real-time table; If enquiry of historical data, the current year, historical data was carried out garbled data from the monthly table of project; Historical annual data carries out garbled data from project annual table.

(2) part of data acquisition flow process is described

SAP system interface: the project relevant interface of SAP system and native system is as follows, and interface data is regularly carried out morning every day.

Electric system management and control module interface: the project relevant interface of SAP and native system is project payment application interface, this interface is carried out regular morning.

ESB data bus service: the interface data between system all will send to the service of the ESB of enterprise data bus, transmits by ESB data bus.

The service of management and control tool interface: the interface service that management and control instrument provides, for SAP system and electric system management and control module, call and accept the project data that ESB data bus pushes.

XML Data Analysis: the data of project data interface are stored and transmitted in the mode of XML document flow, management and control instrument is resolved XML file after receiving XML document flow, extracts required project data.

Data deposit intermediate database table in: first intact being saved in intermediate data table of external system interface data that management and control instrument receives, and be convenient to subsequent project analysis and history and review.

(3) data preparation, flow process integrated and processing processing section are described

SAP middle table data are extracted: the project interface data middle table receiving from SAP system, read project data.

Electric system management and control middle table data are extracted: the project interface data middle table receiving from electric system management and control module, read project data.

Project data duplicate removal, merging: according to bullets (definition number) interface data of SAP system and electric system management and control module is merged into a complete project data.As there being the project of a plurality of identical numberings in an interface transmission, get last received data, give up the repeating data receiving above.

Data Update is to project real-time table: the project data by duplicate removal, after merging is updated in project real-time table according to bullets, as project has existed to carry out in real-time table, upgrades operation; As do not existed in real-time table, carry out newly-increased operation.

By storing process, data are converged to project annual table: in order to improve the efficiency of history of project inquiry, system made project annual table, is saved in project annual table by the actual every data that occur, the difference of expense during project year.A situation arises for data, the expense of the project annual table record entry in current year from the beginning of the year to current reality (being difference current and beginning of the year data, expense).Storing process is regularly carried out once every day.

By storing process, data are converged to the monthly table of project: in order to improve the efficiency of history of project inquiry, the monthly table of system made project, by project each monthly during the actual every data that occur, the difference of expense be saved in the monthly table of project.A situation arises for data, the expense of the monthly table record project of project in current month from the current beginning of the month to current reality (being difference current and beginning of the month data, expense).Storing process is regularly carried out once every day.

Project early warning threshold values allocation list: the abnormal data, the expense situation that occur for monitor project term of execution the, system made project early warning threshold values allocation list.Can be by the analysis of configuration early warning threshold values, filter out data, project that expense is abnormal, as monitor this day Project Cost amount than the low project of yesterday.

Data Update is to project early warning table: every day storing process regularly in implementation, to project real time data analyze, monitor project data, a situation arises for expense, if any the data, the cost data that reach threshold values, by item record in project early warning table.

(4) data display part flow process is described

Input filtercondition: the condition that the querying condition region input in inquiry, the statistics page will be filtered, basic filtering condition and Geng Duo filtercondition are divided in filtercondition region, and basic filtering condition is shown the most frequently used filtercondition; More filterconditions region is defaulted as hiding, this district inclusion time commonly use, teach abundant querying condition.User is Select input according to circumstances.

Condition judgment between interrogation zone: between inquiry/Statistical Area, the start time is defaulted as sky, is defaulted as current time closing time, if do not change this time system from project real-time table, filter, screening programme data; As selected, inquire about the start time or revise and inquire about closing time, there are data in (annual table or monthly table) screening historical stage from history of project table.

Detailed show (in real time) of project: the detailed data record that displaying project is up-to-date, real-time, and to project every data, the expense from the approval stage to the stage of implementing, finish up a situation arises by the form of traffic lights, intuitively shows.Each stage and data, fee item comprise:

Bullets, affiliated company;

Project basic condition: comprise project assign year, classification, attribute, emphasis/autonomous, batch, title, authentication code, plan open completion date etc.

The project approval stage: comprise project verification, can grind, give an written reply, just establish, Budget at Completion, pogo plan etc. then.

Project implementation phase: comprise project front-end fee with, procurement request, bid, purchase order, cash budget, invoice verification, go out data, the Fee Amount data such as warehouse-in, data expenditure, payment funding.

Project conclusion stage: a situation arises to comprise project completion date of construction, project clearing, project final accounting etc.

By specialty, show (in real time): by career field dimension displaying project a situation arises in real time, can follow the tracks of each career field in the implementation status of the full chain links of project, and the completed percentage of each data, expense.

The unit of pressing shows (in real time): the unit's of pressing dimension displaying project a situation arises in real time, can monitor the progress situation of each unit here, and the completed percentage of each data, expense.Be conducive to carry out the monthly cash budget control of constituent parts.

By time dimension, add up (in real time): the performance of adding up each moon (by current month) budget items by time dimension.

By progress dimension statistics (in real time): add up in each stage implementation progress comparatively fast or slower unit and detailed programs, so that supervise progress, investigation project hysteresis reason.As, screening is when the unit of annual data expenditure over pogo plan 50%.

By project category statistics (in real time): add up in of all categories, unit, year certain exhibition method by the accumulative total to the same day, history item master budget, project total quantity, project kickoff situation, completion situation during certain, situation does not go into operation.

Early warning Project Exhibition: show the project that meets early warning threshold values, data, fee item and the amount that can check specific coding, title and the warning of project, and the time of reporting to the police and occurring.

As shown in Fig. 5, Fig. 5 .1, Fig. 5 .2, Fig. 5 .3, Fig. 5 .4,

Module whole flow process is described

Data acquisition: electric system management and control module manually or is regularly called native system interface service, pushes data into native system by the service of ESB bus, and native system receives after interface data through resolving, and extracts data and deposits middle table in.

The beginning of the year budget compilation: the budget that budget compilation module major function Wei Dui at the beginning of the year county company of county company budget reports is examined, is calculated, substitutes in batches and generate budget and assigns table.

Budget adjustment in year: after the beginning of the year, budget compilation completed, according to constituent parts reality actual business circumstance then, adjust the budget that the beginning of the year, establishment was assigned annual July.

The year end, index was controlled: at per end of the year, according to the actual business circumstance of constituent parts, Ge county, the Dui Gai of You Ge city company city company profit and loss budget carries out balance, thus the total profit of generation constituent parts and controllable expenses final year appraise and decide number.

Budget enforcement is analyzed: to the budget target of the units moon, actual a situation arises analyzes, contrast the deviation ratio of monitoring constituent parts budget enforcement (yearly budget draws deviation ratio with of that month actual contrast after monthly decomposing) with the budget of assigning in year.

(2) part of data acquisition flow process is described

Electric system management and control module interface: native system and electric system management and control module have 2 about the interface of county company budget part: data-interface is made a report in the budget of Yi Shi county company, and the budget data that this interface synchronization county company makes a report in electric system management and control module is to native system.This interface is that manual triggers is carried out, and when bottom server, in electric system management and control module, makes a report on after budget, and electric system portion of group carries out preliminary audit survey, and audit is synchronized to native system by this interface of rear triggering by data; Er Shi county company budget wall bulletin interface, each county company of this interface synchronization is actual revenue and expenditure, the every expense situation relevant with budget occurring monthly, is convenient to native system and carries out budget enforcement analysis.

ESB data bus service: the interface data between system all will send to the service of the ESB of enterprise data bus, transmits by ESB data bus.

The service of management and control tool interface: the interface service that management and control instrument provides, for SAP system and electric system management and control module, call and accept the project data that ESB data bus pushes.

XML Data Analysis: the data of project data interface are stored and transmitted in the mode of XML document flow, management and control instrument is resolved XML file after receiving XML document flow, extracts required project data.

Data deposit intermediate database table in: first intact being saved in intermediate data table of external system interface data that management and control instrument receives, and be convenient to subsequent project analysis and history and review.

Data deposit Service Database table in: interface data is saved in after intermediate database table, and final updated is in Service Database table, for budget compilation, audit.

(3) beginning of the year, budget compilation part flow process was described

Set budget year: the budget data year of setting county company budget module, this setting year is all got in each relevant sub-module correlation function unifications such as the budget compilation at the beginning of the year of the rear county of setting company budget module, budget adjustment in year, index control at the year end, budget enforcement analysis, without setting one by one.

Set budget version: the version of budget compilation was divided on one, assigns in advance, formally assigned the beginning of the year, this function is the unified versions of data of setting budget compilation at the beginning of the year, sets unified this setting versions of all getting of each submodule such as budget compilation Xia county company budget at the beginning of the year after next, operating budget, budget auditing revision.

The budget that typing business department provides: partial budget index is provided by management through specialized department department, as data such as the electric weight of constituent parts, electricity price, line loss, wages, these budget targets budget compilation with assign in the system budget data that can automatic replacement becomes business department to provide.

System automatic measurement & calculation partial budget index: partial budget index system is calculated again, as rural power grids repay to be returned income, controlled data, three expenses etc., the index (can adjust again by hand) after these systems measuring and calculating can be replaced the budget data that county company makes a report at budget compilation when assigning.

Manual retouch budget target in batches: when budget audit is adjusted, partial budget index is as electric system expense, social security expense, amortization charge etc., system provides the function of adjustment in batches, can in a page, adjust these expense indexs of Ge Jia county company, the index after adjustment can substitute at budget compilation with while assigning the budget data that county company makes a report on.

System budget establishment: the budget data of the budget data that system provides according to business department and system measuring and calculating, manual setting, replace the associated budget data that county company makes a report on, all the other are got county company and make a report on data, finally generate the yearly budget table of each county company.

Locking edition data: after budget compilation completes, in order to prevent maloperation modification budget data, can carry out edition data locking, the edition data after locking cannot be modified.

System generates budget and assigns table: system automatically generates the budget of each county company and assigns table, and budget is assigned and is divided into budget and assigns and formally assign, and assigns in advance and comprises that performance assessment criteria budget assigns table, profit and loss budget and assign and show and asset-liability budget is assigned table.Formally assign and mainly comprise following 6 budget tables: Main Management index budget summary, profit and loss budget are assigned table, asset-liability budget and assigned table, data expense budget and assign that table, operating budget are assigned table, the Nong Weifei budget for revenues and expenditures is assigned table.

(4) year end, index control section flow process was described

Typing city company is to county company profit and loss index equilibrium number: the year end is according to the actual production business circumstance of each county company, the profit and loss budget index of the Hui Duidui of city company Ying County company is carried out overall equilbrium, and the index after balance completes examination standard as the year-end budget of county company.

Manual setting bottom server section budget target: the rural power grids of each county company of the manual adjustment in batches of the electric system indexs such as returns, rural power grids interest, price modification impact of repaying, for controllable expenses at the end of definite and total profit, finally appraise and decide number.

System-computed county corporate profit total value and controllable expenses are are finally appraised and decided number: system is according to the controllable expenses of budget adjustment in year and total profit, in conjunction with the budget equalization number of city company, calculate each county company the year end controllable expenses and total profit finally appraise and decide number.

(5) budget enforcement analysis part flow process is described

Select budget analysis month: select budget analysis month corresponding to form, in form, the data of actual generation in this year are actual generation of this month number.

Data query is assigned in budget: data are assigned in the up-to-date budget of system queries

Selected month wall bulletin data query: the actual generation data in selected month of system queries (from synchronous each month wall bulletin data of electric system management and control module interface).

(reality-budget/12) * month/(budget/12* month)) etc., actual generation and the index such as yearly budget difference system-computed budget enforcement deviation ratio: system is according to yearly budget and monthly actual generation, calculates gradient on year-on-year basis (the actual gradient on year-on-year basis with reality last year in this year), budget enforcement deviation ratio (formula:.

Whether budget enforcement analytical statement is shown: budget enforcement analytical statement mainly comprises performance assessment criteria and important indicator Track Table, mainly monitor certain month actual generation and conform to (budget is monthly decomposed) with yearly budget; Budget enforcement analytical table, the budget targets such as the Main Analysis profit and loss, asset-liabilities, data expense, capital revenue and expenditure actual completes the implementation deviation rate with yearly budget.As shown in Fig. 6, Fig. 6 .1

(1) overall procedure

The purchase of goods and materials record that price of material library module sends SAP monthly gathers generation middle table; Provide various dimensions, the charts such as purchase of goods and materials analysis, upward price trend analysis, purchase of goods and materials statistics, Classification of materials statistics in conjunction with data display mode.

(2) idiographic flow

Emphasis material screening conditions are set, and are mainly to arrange: the conditions such as procurement price, purchase quantity, the buying frequency, procurement value; Conditional filtering emphasis material according to arranging, is saved in emphasis material library.All graphic analyses in price of material storehouse are all based on emphasis material library.

Although above-mentioned, by reference to the accompanying drawings the specific embodiment of the present invention is described; but be not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various modifications that creative work can make or distortion still in protection scope of the present invention.

Claims (10)

1. the full chain budgetary data processing system of production capital construction standard cost system, is characterized in that, comprises application layer, budget layer and key-course,

Described application layer comprises system management module, and described system management module comprises service management unit, rights management unit, system setting unit, interface management unit, prompting administrative unit and personal settings unit;

Described budget layer comprises price of material storehouse, production standard cost-element, capital construction standard cost unit, budget compilation unit and county company budget unit, the data of described price of material storehouse receiving system administration module, and transferring data to production standard cost-element and capital construction standard cost unit, described production standard cost-element and capital construction standard cost unit transfer data to budget compilation unit and county company budget unit;

Described key-course comprises project tracking control of full process module and output module;

Described project tracking control of full process module is obtained the project real-time information of each operation system and is set up corresponding whole process supervision system.

2. the full chain budgetary data processing system of production capital construction standard cost system as claimed in claim 1, is characterized in that,

Described system management module, for the infrastructure service of system operation is provided, meets from application, safety, data interaction different aspects the requirement that system is used; Described system management module comprises user management, system setting, personal settings and data-interface four major parts, and user management provides newly-increased, change, the right assignment function to system user; System setting comprises the management of unit, department, user role, systemic-function menu Back ground Information; Personal settings provide revises personal information, password replacement, system interface personalized function; Data-interface mainly provides statistics and the monitoring of each data-interface transmission situation of system;

Described service management unit is for the maintenance of system user account number, personal information and account authority; User management provides to be carried out additions and deletions to System Operation User and changes the management service of looking into fundamental operation function, maintenance system user's name, unit, user name, sex, the various essential informations of post, set user's operating right, the system access situation that can also check each user simultaneously;

Described rights management unit, for taking the open strategy of difference in functionality to dividing the work different users, makes user according to own demand, use system very easily, and the while also filters not belonging to the function of working range; So not only improve the security of system, also can prevent the situation of data corruption between different departments.

3. the full chain budgetary data processing system of production capital construction standard cost system as claimed in claim 1, is characterized in that,

Described system setting unit is for representing the setting to user's difference in functionality interface according to different demands, and the information of service companies subordinate unit, creates user's use role infrastructure service;

Described interface management unit is for monitoring and data statistics situation to ERP and two systems of financial management and control and native system data interaction every day, and system can view the synchronous daily record of data, and system also can provide warning function extremely to undesired data interaction;

Described prompting administrative unit is for data and the index effect that do not reach or surpass the expectation, and system can provide eye-catching sign to data exhibiting according to judgement, is convenient to eye-catching the pinpointing the problems and processing in time of user;

Described personal settings unit is used for changing entire system style and pattern, and user can arrange according to individual hobby the style of system.

4. the full chain budgetary data processing system of production capital construction standard cost system as claimed in claim 1, is characterized in that,

Described price of material storehouse, for by the analysis to purchase of goods and materials price, the amount of money, quantity and frequency four dimensions, provides emphasis material screen choosing method; By the real-time monitoring to purchase of goods and materials, set up the monitoring of price of material alteration trend, for changing and carry out operational decision making, level of organization cost budgeting, analysis cost provide support;

Described production standard cost-element is for studying the structure and characteristic of production standard cost, according to equipment, job class, activity, in conjunction with artificial, vehicle machine-team, Master Cost, the production standard that power transformation, circuit, marketing, management, dispatching communication five large administrative units are set up in research becomes body series; And according to standard cost achievement in research, by the hook coefficient of self-defined measure formula and various parameters, set up budgeting model, budgetary technique and the means of scientific, robotization, flexibility are provided;

Described capital construction standard cost unit is used for based on State Grid Corporation of China's capital construction standard cost achievement in research, by analysis project parameter, form, optimize, simplify the input parameter of engineering cost measuring and calculating, effectively reduce capital construction standard cost measuring and calculating complexity, improve measuring and calculating efficiency, and include results of measuring in construction project budget compilation;

Described budget compilation unit, for the organic linking of Criterion cost and budget compilation, provides systematization, robotization, intelligentized budgetary technique, carries out the standard cost measuring and calculating of cost-effectivenes expenditure and capital expenditure;

Described county company budget unit is used for according to the budget management requirement of State Grid Corporation of China, and standard is also set up the unified budget management system that covers county company; Realize the many version managements of yearly budget, provide budget compilation, batch index in batches to substitute, examine in batches revision, key index monitoring and early warning ladder of management, improved the science and establishment efficiency of county company budget compilation.

5. the management-control method that the full chain budgetary data processing system of the production capital construction standard cost system as described in above-mentioned arbitrary claim is adopted, is characterized in that, is mainly divided into following steps:

Step (1): system management module initialization: comprise user management, rights management, system setting, interface management, prompting management and personal settings;

Step (2): the data of price of material storehouse receiving system administration module, and transferring data to production standard cost-element and capital construction standard cost unit, described production standard cost-element and capital construction standard cost unit transfer data to budget compilation unit and county company budget unit; Price of material arrangement is carried out in price of material storehouse, production standard cost-element carries out the production of standard cost, capital construction standard cost unit carries out the measuring and calculating of substation project standard cost, the measuring and calculating of power transmission engineering standard cost and the measuring and calculating of power transmission and transformation standard cost, budget compilation unit is for the organic linking of Criterion cost and budget compilation, and county company budget unit carries out budget;

Step (3): budget compilation unit and county company budget unit by data upload to project tracking control of full process module and output module; Project tracking control of full process module is carried out project tracking, annual tens thousand of the project implementation states of the company that grasps in real time and implementation progress.

6. method as claimed in claim 5, is characterized in that, the comprising of capital construction standard cost unit in described step (2): the measuring and calculating of power transformation engineering standard, the measuring and calculating of power transmission engineering standard and three parts of power transmission and transformation standard cost measuring and calculating;

In described step (2), the summary job step of capital construction standard cost unit is:

Step (2A-1): input infrastructural project core parameter; Described infrastructural project comprises power transmission engineering, power transformation engineering and project of transmitting and converting electricity;

Step (2A-2): according to electric pressure coupling respective standard storehouse; Described java standard library is according to the historical experience of transformer station of Ge Wangsheng company, transmission line construction, according to electric pressure, power distribution equipment, capacity Engineering Project Construction parameter, engineering construction is divided into different schemes, for instructing, calculate the Standard Rate of the engineering construction of each company;

Step (2A-3): according to core parameter matching scheme;

Step (2A-4): carry out submodule increase and decrease according to core parameter;

Step (2A-5): draw engineering measuring and calculating cost result.

7. method as claimed in claim 5, is characterized in that, the specific works step of the production standard cost-element of described step (2) is:

Step (2B-1): revise production standard storehouse; Described production standard storehouse is the core of production standard cost-element, and by activity in production standardization, and the concept of introducing the operation frequency on average arrive the activity in production of burst, non-long-termization every year, so that the year operating cost of quantification more accurately;

Step (2B-2): typical case's measuring and calculating: take standard operation storehouse as foundation, set up typical data model, user can add and delete exemplary apparatus quantity, type according to actual conditions;

Step (2B-3): upload cities and counties' corporate assets data; Described asset data, for showing group company and each city-level and corporate assets information state statistical form at county level, comprises transformer station, circuit, management and the relevant company's situation information of marketing four large class;

Step (2B-4): self-defining formula, hook coefficient; Described self-defining formula organically combines the production standard storehouse in assets storehouse, production standard cost, typical results of measuring for the form by formula; Described hook coefficient is adjusted according to actual knowhow the result of budget compilation;

Step (2B-5): produce budget compilation: take production standard cost as basis, grass-roots unit reports asset data, automatically completes the budget compilation of power transformation, circuit, marketing and the handling cost four module of each company by self-defined budget formula, hook coefficient;

Step (2B-6): adjust budget data.

8. method as claimed in claim 5, is characterized in that, the specific works step of the county company budget unit of described step (2) is:

Step (2C-1): data acquisition: financial management and control module manually or is regularly called native system interface service, pushes data into native system by the service of ESB bus, and native system receives after interface data through resolving, and extracts data and deposits middle table in; Enter respectively step (2C-3);

Step (2C-2): the beginning of the year budget compilation; Budget compilation in year; The year end, index was controlled; Finish; Described beginning of the year, budget compilation was that the budget that county company is reported is examined, calculates, substituted in batches and generate budget and assigns table according to budget compilation flow process in Guo Wang company twice two; In year, budget compilation is annual July, according to constituent parts business circumstance to flow process that the beginning of the year, budget was adjusted; Described year end, index was controlled as per end of the year, and according to the actual business circumstance of constituent parts, Ge county, the Dui Gai of You Ge city company city company profit and loss budget carries out balance, thus the total profit of generation constituent parts and controllable expenses appraise and decide number final year;

Step (2C-3): budget enforcement analysis, by the monthly actual number that occurs of integrated service system budget index, what analyze index assigns budget and the actual difference that a situation arises; Finish; Described budget enforcement analysis is that actual a situation arises analyzes to the budget target of the units moon, contrasts the deviation ratio of monitoring constituent parts budget enforcement with the budget of assigning in year.

9. method as claimed in claim 5, is characterized in that, the workflow in the price of material storehouse of described step (2) is: SAP price purchase records; Data processing; Data display;

The specific works flow process in the price of material storehouse of described step (2) is:

Step (2D-1): emphasis material screening condition setting, described screening conditions comprise procurement price, purchase quantity, the buying frequency, procurement value;

Step (2D-2): emphasis material screening: the conditional filtering emphasis material according to arranging, is saved in emphasis material library;

Step (2D-3): set up various dimensions inquiry; If need statistical study to enter step (2D-4); If material inquiry enters step (2D-5);

Step (2D-4): statistical study, if material procurement statistics and Classification of materials statistics are just carried out in tabulate statistics; If material procurement analysis and upward price trend analysis are just carried out in trend analysis;

Step (2D-5): material inquiry, carry out respectively detail inquiry and minute group polling.

10. method as claimed in claim 5, is characterized in that, the specific works step of the project tracking control of full process of described step (3) is:

Step (3A-1): data acquisition: SAP system, financial management and control module are regularly called native system interface service, push data into native system by the service of ESB bus, native system receives after interface data through resolving, and extracts data and deposits middle table in;

Step (3A-2): data preparation and data integration, data processing: read the data that SAP system, financial management and control module are transmitted by interface in intermediate list, merge, be updated in project real-time table after duplicate removal, regularly carry out storing process every day and calculate year, month number occurring, and be updated in the year and monthly table of project of projects;

Step (3A-3): data display: according to the querying condition judgement of user's typing, if inquiry latest data carries out garbled data from project real-time table; If enquiry of historical data, the current year, historical data was carried out garbled data from the monthly table of project; Historical annual data carries out garbled data from project annual table.

Images