CN109508331B - Power grid financial data processing method and system - Google Patents
Power grid financial data processing method and system Download PDFInfo
- Publication number
- CN109508331B CN109508331B CN201811122045.0A CN201811122045A CN109508331B CN 109508331 B CN109508331 B CN 109508331B CN 201811122045 A CN201811122045 A CN 201811122045A CN 109508331 B CN109508331 B CN 109508331B
- Authority
- CN
- China
- Prior art keywords
- summarization
- financial data
- subject
- number field
- record
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000003672 processing method Methods 0.000 title abstract description 4
- 238000000034 method Methods 0.000 claims abstract description 13
- 230000005611 electricity Effects 0.000 claims description 22
- 238000012795 verification Methods 0.000 claims description 4
- 238000011144 upstream manufacturing Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E40/00—Technologies for an efficient electrical power generation, transmission or distribution
- Y02E40/70—Smart grids as climate change mitigation technology in the energy generation sector
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P80/00—Climate change mitigation technologies for sector-wide applications
- Y02P80/10—Efficient use of energy, e.g. using compressed air or pressurized fluid as energy carrier
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Finance (AREA)
- Economics (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Primary Health Care (AREA)
- Tourism & Hospitality (AREA)
- General Health & Medical Sciences (AREA)
- Water Supply & Treatment (AREA)
- Public Health (AREA)
- Human Resources & Organizations (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a method and a system for processing electric network financial data, which relate to the technical field of information management of electric power enterprises, in particular to a method and a system for processing electric network financial data in an intranet safety environment, comprising the following steps: creating a file path to which a subject summary table for each accounting purpose for collation is derived from two or more information management systems; establishing a financial data summarization index file; reading details belonging to the summarization period under a field specified by a financial data summarization index file in a subject summarization table of each accounting subject under the file path; creating a summary check list; and selecting the first record and the second record to splice a check list according to the financial data summarization index file, and returning the check list to an information management system from which the data come. The invention provides a high-efficiency and reliable power grid financial data processing method and system for power enterprises, and indirectly realizes multi-machine data synchronization.
Description
Technical Field
The invention relates to the technical field of information management of power enterprises, in particular to a method and a system for processing electric network financial data in an intranet safety environment.
Background
The power enterprise is in a secret requirement, the application software of the power enterprise runs in an independent intranet which is physically isolated from an extranet, and most of general software cannot be directly used by downstream departments of the power enterprise except that management software for unified purchase can run on a server managed by the power enterprise. The architecture of existing multi-machine running software is typically a client-server mode, i.e. CS mode, and also a so-called browser-server mode, i.e. BS mode. The existing financial data processing software is not suitable for common downstream financial departments of power enterprises because the CS or BS system is adopted because the problem of multi-machine data synchronization needs to be solved.
Independent information management software is used in each department of the power enterprise, databases of the information management software among the departments cannot be directly accessed to each other, and when financial staff of the downstream financial department needs to uniformly check financial data of each upstream department on the department, a manual check mode is still generally adopted at present, relevant data of the information management software databases of the upstream departments are respectively called, and after the relevant data of the departments are combined for comparison, the relevant data of the departments are respectively reported upwards in a reclassification arrangement mode. Therefore, financial staff workload of a financial department downstream of the power system is large, and possibility of occurrence of financial data errors is high.
Disclosure of Invention
The invention provides a high-efficiency and reliable power grid financial data processing method and system for power enterprises, which indirectly realize multi-machine data synchronization and are suitable for downstream financial departments needing to be in butt joint with information management software databases of different upstream departments.
The invention provides the following technical scheme:
a method of processing grid financial data, comprising: creating a file path, and deriving a subject summary table of each accounting subject for verification from more than two information management systems to the file path, wherein the subject summary table at least comprises a tax payable table, a benefit fee expenditure table, a cost fee table, a backup check, other index tables, a power sales detail table, a power purchase table, a sales income table, a price to be paid table and a power purchase cost table;
establishing a financial data summarization index file, wherein the financial data summarization index file contains field information and summarization periods to be summarized in each subject summarization table;
reading details belonging to the summarization period under a field specified by a financial data summarization index file in a subject summarization table of each accounting subject under the file path;
creating a summary check list, wherein the summary check list comprises a report number field and a check number field, reading electricity price information from the local gate electricity price management system, storing the electricity price information into the report number field, summarizing the details, and storing the detail into the check number field of the summary check list; marking different records of the report form number field and the check number field in the summary check list as a first record, and marking the same record of the report form number field and the check number field in the summary check list as a second record;
and selecting the first record and the second record to splice a check list according to the financial data summarization index file, and returning the check list to an information management system from which the data come.
The method is further optimized in that the financial data summary index file is a first data table in the form of a single file, and the first data table comprises four fields including a record ID, a subject summary table name, a summary field name and a summary period.
The method is further optimized in that the financial data summary index file is a data set file in the form of a database, the data set file comprises a first data table and a second data table, the first data table comprises four fields of record ID, subject summary table name, summary field name and summary period, and the second data table comprises operator ID and subject summary table name.
A grid financial data processing system, comprising: the reading module is used for creating a file path, and deriving a subject summary table of each accounting subject for verification from more than two information management systems to the file path, wherein the subject summary table at least comprises a tax payable table, a benefit fee expenditure table, a cost fee table, a standby account, other index tables, an electric power sales detail table, an electricity purchasing table, a sales income table, a to-be-paid fund table and an electricity purchasing cost table;
the financial data summarization index file comprises field information and summarization periods to be summarized in each subject summarization table;
the checking module is used for reading details belonging to the summarization period under the field specified by the financial data summarization index file in the subject summarization table of each accounting subject under the file path; the system is also used for creating a summary check list, wherein the summary check list comprises a report number field and a check number field, the electricity price information is read from the gate price management system of the gate and stored in the report number field, and the detail is summarized and then stored in the check number field of the summary check list; the method comprises the steps of marking different records of the report form number field and the check number field in the summarized check list as a first record, and marking the same record of the report form number field and the check number field in the summarized check list as a second record;
and the feedback module is used for selecting the first record and the second record to splice the first record and the second record into a check list according to the financial data summarization index file, and returning the check list to the information management system from which the data of the check list is derived.
A further improvement of the above system is that it comprises a user login module for the user.
A further improvement of the system is that the reading module, the financial data summary index file, the collation module, and the return module are maintained in the same file path as the subject summary table.
According to a specific embodiment provided by the application, the application discloses the following technical effects:
by using a lightweight single-machine program processing architecture, a data table and an output table processing module are stored under a unique file path, so that after the single file path is entitled in computer security management, all files under the directory have readable and writable rights at the same time, and the system does not need to assign rights to the processing module and the data table for multiple times, thereby facilitating security management.
The specific accounting subjects of each information management system are summarized through the first data table stored in the financial data summarizing index file, cross comparison is carried out through the checking module, comparison results are returned to the source information management system of the specific accounting subjects through the returning module, checking efficiency is improved, error rate is reduced, and data synchronization of each information management system is achieved equivalently.
Drawings
FIG. 1 is a flow chart of a method according to an embodiment of the present invention;
FIG. 2 is a system frame diagram of one embodiment of the present invention.
Detailed Description
As shown in fig. 1, the first phase of the embodiment of the present application provides a method for processing financial data of a power grid, which may include the following steps:
s100: a file path is created to which a subject summary table for each accounting subject for collation is derived from two or more information management systems. The subject summary list at least comprises a tax payable list, a benefit fee expenditure list, a cost fee list, a backup account, other index list, an electric power selling list, an electricity purchasing list, a sales income list, a fund to be paid list and an electricity purchasing cost list.
When the method is implemented, firstly, a unique file path is created, wherein the unique file path is generally positioned in a hard disk partition of a first computer which is not connected with an external network and is a registration path of a file management system of the first computer; then accessing the first information management system through a second computer serving as a client of the first information management system, and deriving an accounting purpose information table contained in the first information management system from the first information management system to a local hard disk of the second computer to be stored as a specific accounting purpose summary table; accessing the second information management system through a third computer serving as a client of the second information management system, and deriving an accounting purpose information table contained in the second information management system from the second information management system to a local hard disk of the third computer to be stored as a specific accounting purpose summary table; accessing the N information management system through the N+1 computer serving as a client of the N information management system, and deriving an accounting purpose information table contained in the N information management system from the N information management system to a local hard disk of the N+1 computer to be stored as a specific accounting purpose summary table; finally, all the subject summary tables are transmitted to the file path appointed by the first computer through the data transmission between the second computer and the third computer … … and the first computer up to the (n+1) th computer. Each account summary table should contain details of the account occurrence time and amount of the subject account, e.g., the electricity purchasing table should contain the monthly payable electric charge and the account occurrence month. In another embodiment of the present invention, the first computer is a client of the first information management system to the nth information management system, and may directly store all the subject summary tables in the unique file path. This step may be accomplished manually or by a read module that is also stored under the unique file path.
S200: and establishing a financial data summarization index file. The financial data summarization index file contains field information and summarization periods which need to be summarized in each subject summarization table.
In specific implementation, under the file path created in S100, a financial data summary index file is created, where the financial data summary index file at least includes a first data table, and the first data table includes at least four fields including a record ID, a subject summary table name, a summary field name, and a summary period, for example, a monthly payable electric charge registration index for a purchase electric charge table in the subject summary table is expressed as a record in the first data table: "ID2456, electricity purchasing scale, pays electricity fee, 8 months in 2017 to 12 months in 2017). The financial data summarization index file of the embodiment is a data set file in a database form, and the data set file comprises a first data table and a second data table, wherein the first data table comprises four fields of a record ID, a subject summarization table name, a summarization field name and a summarization period, and the second data table comprises an operator ID and a subject summarization table name. In another embodiment of the present invention, the financial data summary index file is a first data table in the form of a single file, that is, the single file uniquely contains all information of the first data table and does not contain other cross tables, and preferably, the single file is an EXCEL file or may be a text file in CVS format. The financial data summary index file may be created and edited by a text editor (for text forms such as CVS), form editing class software (e.g., EXCEL, SPSS, etc.), or database manipulation software (e.g., ACCESS, mySQL, etc.).
S300: and reading details belonging to the summarization period under the field specified by the financial data summarization index file in a subject summarization table of each accounting subject under the file path.
In specific implementation, according to the record sequence in the financial data summarizing index file, counting the details of the specified fields of the specific subject summarizing table in the specified summarizing period, and outputting the summarizing result in a table form, wherein the summarizing result of the "electric charge payable" field of the electricity purchasing table in the steps S100 and S200 in the summarizing period of "2017 8 month to 2017 12 month" may be in the following record: "electricity purchasing scale, charge electric charge, month 8 in 2017 to month 12 in 2017", 24999.8 yuan "
S400: creating a summary check list, wherein the summary check list comprises a report number field and a check number field, reading electricity price information from the local gate electricity price management system, storing the electricity price information into the report number field, summarizing the details, and storing the detail into the check number field of the summary check list; marking different records of the report form number field and the check number field in the summary check list as a first record, and marking the same record of the report form number field and the check number field in the summary check list as a second record;
s500: and selecting the first record and the second record to splice a check list according to the financial data summarization index file, and returning the check list to an information management system from which the data come.
Corresponding to the method for processing the electric network financial data provided in the embodiment, the embodiment of the application also provides an electric network financial data processing system, as shown in fig. 2, the system may include: the reading module is used for creating a file path, and deriving a subject summary table of each accounting subject for verification from more than two information management systems to the file path, wherein the subject summary table at least comprises a tax payable table, a benefit fee expenditure table, a cost fee table, a standby account, other index tables, an electric power sales detail table, an electricity purchasing table, a sales income table, a to-be-paid fund table and an electricity purchasing cost table;
the financial data summarization index file comprises field information and summarization periods to be summarized in each subject summarization table;
the checking module is used for reading details belonging to the summarization period under the field specified by the financial data summarization index file in the subject summarization table of each accounting subject under the file path; the system is also used for creating a summary check list, wherein the summary check list comprises a report number field and a check number field, the electricity price information is read from the gate price management system of the gate and stored in the report number field, and the detail is summarized and then stored in the check number field of the summary check list; the method comprises the steps of marking different records of the report form number field and the check number field in the summarized check list as a first record, and marking the same record of the report form number field and the check number field in the summarized check list as a second record;
and the feedback module is used for selecting the first record and the second record to splice the first record and the second record into a check list according to the financial data summarization index file, and returning the check list to the information management system from which the data of the check list is derived.
Claims (2)
1. A grid financial data processing system, comprising:
the reading module is used for creating a file path, and deriving a subject summary table of each accounting subject for verification from more than two information management systems to the file path, wherein the subject summary table at least comprises a tax payable table, a benefit fee expenditure table, a cost fee table, a standby account, other index tables, an electric power sales detail table, an electricity purchasing table, a sales income table, a to-be-paid fund table and an electricity purchasing cost table;
the financial data summarization index file comprises field information and summarization periods to be summarized in each subject summarization table;
the checking module is used for reading details belonging to the summarization period under the field specified by the financial data summarization index file in the subject summarization table of each accounting subject under the file path; the system is also used for creating a summary check list, wherein the summary check list comprises a report number field and a check number field, the electricity price information is read from the gate price management system of the gate and stored in the report number field, and the detail is summarized and then stored in the check number field of the summary check list; the method comprises the steps of marking different records of the report form number field and the check number field in the summarized check list as a first record, and marking the same record of the report form number field and the check number field in the summarized check list as a second record;
the feedback module is used for selecting the first record and the second record to splice a check list according to the financial data summarizing index file, and returning the check list to the information management system of the data source;
the reading module, the financial data summarization index file, the checking module and the returning module are stored in the same file path with the subject summarization table.
2. The grid financial data processing system of claim 1, wherein: including a user login module for the user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811122045.0A CN109508331B (en) | 2018-09-26 | 2018-09-26 | Power grid financial data processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811122045.0A CN109508331B (en) | 2018-09-26 | 2018-09-26 | Power grid financial data processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109508331A CN109508331A (en) | 2019-03-22 |
| CN109508331B true CN109508331B (en) | 2023-06-27 |
Family
ID=65746164
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811122045.0A Active CN109508331B (en) | 2018-09-26 | 2018-09-26 | Power grid financial data processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109508331B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457362A (en) * | 2019-07-05 | 2019-11-15 | 中国平安人寿保险股份有限公司 | High-volume verification of data method, apparatus, computer equipment and storage medium |
| CN111814444A (en) * | 2020-07-21 | 2020-10-23 | 四川爱联科技有限公司 | Table data summarizing and analyzing method based on BS (browser/server) architecture |
| CN112651701A (en) * | 2020-10-20 | 2021-04-13 | 国网重庆市电力公司市北供电分公司 | Automatic processing method for D5000 system data |
| CN112634007B (en) * | 2020-12-31 | 2023-11-03 | 中国农业银行股份有限公司 | Information checking method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004070406A (en) * | 2002-08-01 | 2004-03-04 | Daido Life Insurance Co | Financial data management system and method, and computer |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN106452933A (en) * | 2015-08-05 | 2017-02-22 | 腾讯科技（北京）有限公司 | Service data statistical method, device and system |
| CN106815182A (en) * | 2015-11-27 | 2017-06-09 | 国家电网公司 | One kind is based on being directed to power network financial statement statistical system under excel |
| CN107239870A (en) * | 2017-04-11 | 2017-10-10 | 太仓鸿策创达广告策划有限公司 | Business finance aggregation process system |
-
2018
- 2018-09-26 CN CN201811122045.0A patent/CN109508331B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004070406A (en) * | 2002-08-01 | 2004-03-04 | Daido Life Insurance Co | Financial data management system and method, and computer |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN106452933A (en) * | 2015-08-05 | 2017-02-22 | 腾讯科技（北京）有限公司 | Service data statistical method, device and system |
| CN106815182A (en) * | 2015-11-27 | 2017-06-09 | 国家电网公司 | One kind is based on being directed to power network financial statement statistical system under excel |
| CN107239870A (en) * | 2017-04-11 | 2017-10-10 | 太仓鸿策创达广告策划有限公司 | Business finance aggregation process system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109508331A (en) | 2019-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109508331B (en) | Power grid financial data processing method and system | |
| Appelbaum et al. | Blockchain basics and hands-on guidance: taking the next step toward implementation and adoption | |
| Harrast | Robotic process automation in accounting systems | |
| Wilkinson | Accounting information systems: Essential concepts and applications | |
| US6904411B2 (en) | Multi-processing financial transaction processing system | |
| US20140067632A1 (en) | Automatic Generation of Transfer Pricing Documentation | |
| CN110032594B (en) | Customizable data extraction method and device for multi-source database and storage medium | |
| JP7085304B2 (en) | Cost calculator, cost calculation method and cost calculation program | |
| US20060253333A1 (en) | Centralized distributions | |
| JP2001222656A (en) | System, device, method for financial affair management, and recording medium | |
| CN112990740A (en) | Business processing method, device, equipment and storage medium based on multiple legal persons | |
| US10466979B1 (en) | Software requirements creating and tracking system and method | |
| CN116825300B (en) | Budget management system for hospital | |
| US20060195393A1 (en) | Creation of recurring transactions | |
| US20230267557A1 (en) | Generic configuration platform for generating electronic reports | |
| Wood | Factors influencing the use of technical standards in a Nationwide Library and Information Service Network | |
| Cheng et al. | Automating the audit of electronic invoices with a soft robot | |
| Missbach et al. | SAP in 24 Hours, Sams Teach Yourself | |
| Indriani et al. | An Agile Development Method of Employee Co-op Shop Web-Based Sales Information System | |
| Kallergis | Business Software Engineering Processes: An Analytics Case Study | |
| CN117994054A (en) | Tax declaration method and declaration device based on property and behavior tax of group enterprise | |
| Zainol et al. | Designing a Residential’s Database Management System: A Case Study of Applying Resource, Event and Agent (REA) Approach | |
| Ekblom | Accruals with RPA | |
| CN115271583A (en) | Full-process material management system and method based on authority division | |
| CN113781016A (en) | Method, system, equipment and storage medium for updating standing book information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |