CN112100264A - Power project contract monitoring system and method - Google Patents

Power project contract monitoring system and method Download PDF

Info

Publication number
CN112100264A
CN112100264A CN202010975718.8A CN202010975718A CN112100264A CN 112100264 A CN112100264 A CN 112100264A CN 202010975718 A CN202010975718 A CN 202010975718A CN 112100264 A CN112100264 A CN 112100264A
Authority
CN
China
Prior art keywords
payment
contract
project
amount
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010975718.8A
Other languages
Chinese (zh)
Inventor
李伟
胡博
李钊
王丽霞
王大维
雷振江
田小蕾
杨超
李耀宗
蔡明玖
刘中彦
商艳丰
白添元
吴胜竹
邢聪辉
林翰
曹国强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
Electric Power Research Institute of State Grid Liaoning Electric Power Co Ltd
Nari Information and Communication Technology Co
Great Power Science and Technology Co of State Grid Information and Telecommunication Co Ltd
Original Assignee
State Grid Corp of China SGCC
Electric Power Research Institute of State Grid Liaoning Electric Power Co Ltd
Nari Information and Communication Technology Co
Great Power Science and Technology Co of State Grid Information and Telecommunication Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, Electric Power Research Institute of State Grid Liaoning Electric Power Co Ltd, Nari Information and Communication Technology Co, Great Power Science and Technology Co of State Grid Information and Telecommunication Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN202010975718.8A priority Critical patent/CN112100264A/en
Publication of CN112100264A publication Critical patent/CN112100264A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/103—Workflow collaboration or project management
    • 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
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G06Q30/0601—Electronic shopping [e-shopping]
    • G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
    • G06Q30/0635—Processing of requisition or of purchase orders
    • 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
    • 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/10—Services
    • G06Q50/18—Legal services
    • 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
    • Y04S50/00—Market activities related to the operation of systems integrating technologies related to power network operation or related to communication or information technologies
    • Y04S50/10—Energy trading, including energy flowing from end-user application to grid

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • General Physics & Mathematics (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • Health & Medical Sciences (AREA)
  • Finance (AREA)
  • Primary Health Care (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Accounting & Taxation (AREA)
  • General Health & Medical Sciences (AREA)
  • Public Health (AREA)
  • Water Supply & Treatment (AREA)
  • Quality & Reliability (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Operations Research (AREA)
  • General Engineering & Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a power project contract monitoring system and method, and belongs to the field of intelligent power grid informatization. The invention provides a power project contract monitoring system and a power project contract monitoring method aiming at the problems that the conventional power project contract monitoring method is lack of a management system which can effectively monitor, analyze and effectively manage the whole project life cycle from bidding to execution. After configuration setting, the power system contract is independently and accurately tracked and analyzed without manual interference; the bottleneck that contract tracking, monitoring, analyzing and checking are carried out manually at present, workload is large, accuracy is low is solved, and rationality and accuracy of power grid project management are improved.

Description

Power project contract monitoring system and method
Technical Field
The invention belongs to the field of intelligent power grid informatization, and particularly relates to a power project contract monitoring system and method.
Background
The electric power enterprise has the advantages of various contract types, miscellaneous classification, complex contract management and more monitoring information. Due to the characteristics of equipment asset management of power enterprises, the conventional power project contract monitoring method mainly comprises a manual checking mode, project mileage node monitoring and the like.
However, these power project contract monitoring methods lack efficient monitoring, analysis, and management from bidding to performing the entire project lifecycle. In addition, because of huge power enterprise systems, different management methods and systems used by different branches, asset management information data of each system are inconsistent, and the interior of the enterprise lacks a uniform analysis and solution scheme for complex asset data of a power grid, the monitoring information of contract payment conditions of various projects of a national power grid company is not timely, the problems of 'over-payment and under-payment', 'payment in advance, delayed payment', 'payment without payment' and the like exist, and because the problems existing in the contract payment link are found to be not timely, the contract monitoring is only performed by a project management department from experience or reported data, so that the cost is increased, the waste is serious, and the contract risk cannot be effectively controlled.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide a power project contract monitoring system and a method, after configuration and setting, the power project contract is independently and accurately tracked and analyzed without manual interference; the bottleneck that contract tracking, monitoring, analyzing and checking are carried out manually at present, workload is large, accuracy is low is solved, and rationality and accuracy of power grid project management are improved.
The technical scheme adopted by the invention for solving the technical problems is as follows:
the system comprises a data source module, a data integration module, a data storage module, a data analysis module and a project early warning module, wherein the data source module is connected with the data integration, storage, analysis and early warning module.
The data source module: the module is a data source for analyzing and early warning contracts, and the module acquires contract information related to an electric power project from a data source end (ERP system) through an ETL data extraction technology, wherein the contract information comprises contract payment summary information, order payment detail information, material detail information and the like. The main functions include data source configuration and source data extraction control.
The data integration module: and utilizing a data integration tool to perform a control process of integrating the contract payment summary information, the order payment detail information and the material detail table through the purchase order number. The integration method comprises the following steps: based on the contract payment summary table, the relevant information is obtained by collecting the association of the order number and the order payment detail table and the material detail table.
The data storage module: the source terminal detail data integration function module is a function module for performing data storage on source terminal detail data, integrated process data and result data. The storage method comprises the following steps: and storing data by using common database storage software.
The data analysis module: the method is a process for analyzing and mining the execution condition of the project contract and provides data support for the root cause analysis of business departments. The analysis content comprises the following steps: the method comprises the following steps of unit execution condition analysis, project type execution condition analysis, link execution condition analysis, time-sharing execution condition analysis, late payment analysis, early payment analysis, multi-payment analysis, low payment analysis and the like.
The item early warning module: and (4) finding the problem types in the contract management and control process, and processing the problems. According to the monitoring rule, the problem of 'multi-payment/low-payment' and the problem of 'early payment/late payment' in the four payment links of the contract are found. And after the problems are found, feeding back the contract information of the project to a financial department and a business department related to the project according to the project type of the project in the contract, and continuously tracking the contract payment information of the project.
The invention has the following beneficial effects and advantages:
according to the invention, manual interference is not required, and the contract of the power system is independently and accurately tracked and analyzed; the bottleneck that contract tracking, monitoring, analyzing and checking are carried out manually at present, workload is large, accuracy is low is solved, and rationality and accuracy of power grid project management are improved.
Drawings
Fig. 1 is a flowchart of a power project contract monitoring system provided in the present invention.
Fig. 2 is a flowchart of a power project contract monitoring method provided by the present invention.
Fig. 3 is a flowchart of a method for monitoring and analyzing contract execution of an electric power project according to the present invention.
Detailed Description
The present invention will be described in further detail with reference to examples.
The invention discloses a power project contract monitoring system which comprises a data source module, a data integration module, a data storage module, a data analysis module and a project early warning module, wherein the data source module is connected with the data integration, storage, analysis and early warning module.
The data source module: the module is a data source for analyzing and early warning contracts, and the module acquires contract information related to an electric power project from a data source end (ERP system) through an ETL data extraction technology, wherein the contract information comprises contract payment summary information, order payment detail information, material detail information and the like. The main functions include data source configuration and source data extraction control.
The data integration module: and utilizing a data integration tool to perform a control process of integrating the contract payment summary information, the order payment detail information and the material detail table through the purchase order number. The integration method comprises the following steps: based on the contract payment summary table, the relevant information is obtained by collecting the association of the order number and the order payment detail table and the material detail table.
The data storage module: the source terminal detail data integration function module is a function module for performing data storage on source terminal detail data, integrated process data and result data. The storage method comprises the following steps: and storing data by using common database storage software.
The data analysis module: the method is a process for analyzing and mining the execution condition of the project contract and provides data support for the root cause analysis of business departments. The analysis content comprises the following steps: the method comprises the following steps of unit execution condition analysis, project type execution condition analysis, link execution condition analysis, time-sharing execution condition analysis, late payment analysis, early payment analysis, multi-payment analysis, low payment analysis and the like.
The item early warning module: and (4) finding the problem types in the contract management and control process, and processing the problems. According to the monitoring rule, the problem of 'multi-payment/low-payment' and the problem of 'early payment/late payment' in the four payment links of the contract are found. And after the problems are found, feeding back the contract information of the project to a financial department and a business department related to the project according to the project type of the project in the contract, and continuously tracking the contract payment information of the project.
In order to achieve the above object, another aspect of the present invention provides an electric power project contract monitoring system, including:
step 1: and storing contract basic information and contract execution information through an ERP system in a business circulation mode, a data input mode and the like. Wherein, the basic information of the contract is as follows: province company name, province company code, prefecture company name, project code, project name, project type, project category, purchase order number, supplier name, payment condition, contract amount, contract payment proportion, commissioning date, contract validation date, WBS code, WBS description, etc.;
contract payment information: provincial company name, provincial company code, item name, year of accounting, accounting document number, accounting document line item, debit/credit identification, purchase order number, payment type, payment amount, payment date, WBS code, WBS description, line item, arrival date, arrival amount, material code, material name, quantity received, etc.
Step 2: and extracting a contract payment summary table, an order payment detail table and a material detail table in the ERP system into a contract execution monitoring database through a data extraction tool KETTLE.
And step 3: and performing broad-sheet integration on the contract payment summary sheet, the order payment detail sheet and the material detail sheet in the contract execution monitoring database according to a broad-sheet integration rule through the data extraction tool KETTLE to form a contract payment summary broad sheet, an order payment detail sheet and a material detail broad sheet. And performing database table association through the KETTLE software to perform data query and combination.
Based on the contract payment summary broad table, the related information is obtained by collecting the association of the order number and the order payment detailed table and the material detailed table. And associating the material detail table with the material code table through material codes to form a material detail width table.
And 4, step 4: and storing the integrated broad form data in an oracle database.
And 5: and based on the contract payment summary width table, the order payment detail width table and the material detail width table, carrying out data monitoring and analysis work by using a tableau tool. The method comprises the steps of monitoring the conditions of contract non-compliance (multi-payment/low-payment and early payment/late payment), finding that the contract has problems on payment at present, and informing a business department of paying attention and correcting in time.
The analysis method comprises the following steps: the method comprises the following steps of performing analysis on unit-by-unit execution conditions, project-by-project type execution conditions, link-by-link execution conditions, time-sharing execution conditions, late payment analysis, early payment analysis, multi-payment analysis, low payment analysis and the like, wherein the obtained contract of a project is focused, the corresponding link of the project is focused, and the project unit is focused.
The monitored data includes: contract amount, contract payment proportion (prepaid payment proportion, payment proportion of arrived money, payment proportion of delivery money, payment proportion of warranty money), prepaid real payment amount, payment amount of arrived money, payment amount of delivery money, receiving amount, contract effective time and payment date;
when the payment type is 'prepayment', the payment amount is not equal to the contract amount and the prepayment proportion is abnormal 'multi-payment/low payment';
when the payment type is 'payment due' and the payment amount is not equal to the contract amount and the payment proportion of the payment due, the 'payment more/payment less' is abnormal;
when the payment type is 'transfer money', the payment amount is not equal to the payment proportion of the transfer money of the contract amount, and the 'multi-payment/low-payment' is abnormal;
when the payment type is 'warranty', the payment amount is not equal to the contract amount and the payment proportion of the warranty, and the 'over payment/under payment' is abnormal;
the item contract with materials is judged to be 'more payment/less payment' abnormal when the receiving quantity is null and the payment amount is more than the contract amount (the pre-payment proportion + the payment proportion of the arrived payment);
when the delivery date is empty, the payment amount is greater than the contract amount (the pre-payment proportion + the payment proportion of the arrived payment), and the 'pay more/pay less' is abnormal;
when the delivery date and the last payment time are in the same year and the payment amount is greater than the contract amount (the pre-payment proportion, the payment proportion of the arrived payment and the payment proportion of the arrived payment), the payment is 'more payment/less payment' abnormity;
when the pre-payment time is earlier than the contract effective time, the pre-payment is early paid;
the payment time of the payment of the arrived money is earlier than the arrival time of the goods and materials, and the payment is early;
when the payment time of the shipping money is earlier than the project shipping time, early payment is carried out;
when the payment time of the warranty payment is earlier than the warranty period, the payment is early.
Step 6: and transmitting alarm information generated by monitoring to a monitoring alarm display screen in a data interface mode, issuing an alarm instruction, and transmitting contract execution non-compliance conditions to each business department by an operator on duty according to the alarm prompt information.
As shown in fig. 1, the present invention provides a power project contract monitoring system and method, the system includes a data source module, a data integration module, a data storage module, a data analysis module, and a project early warning module, wherein the data source module is connected to the data integration, storage, analysis, and early warning module.
The data source module: the module is a data source for analyzing and early warning contracts, and the module acquires contract information related to an electric power project from a data source end (ERP system) through an ETL data extraction technology, wherein the contract information comprises contract payment summary information, order payment detail information, material detail information and the like. The main functions include data source configuration and source data extraction control.
The data integration module: the data integration module: and utilizing a data integration tool to perform a control process of integrating the contract payment summary information, the order payment detail information and the material detail table through the purchase order number. The integration method comprises the following steps: based on the contract payment summary table, the relevant information is obtained by collecting the association of the order number and the order payment detail table and the material detail table.
The data storage module: the source terminal detail data integration function module is a function module for performing data storage on source terminal detail data, integrated process data and result data. The storage method comprises the following steps: and storing data by using common database storage software.
The data analysis module: the method is a process for analyzing and mining the execution condition of the project contract and provides data support for the root cause analysis of business departments. The analysis content comprises the following steps: the method comprises the following steps of unit execution condition analysis, project type execution condition analysis, link execution condition analysis, time-sharing execution condition analysis, late payment analysis, early payment analysis, multi-payment analysis, low payment analysis and the like.
The item early warning module: and (4) finding the problem types in the contract management and control process, and processing the problems. According to the monitoring rule, the problem of 'multi-payment/low-payment' and the problem of 'early payment/late payment' in the four payment links of each contract are found. And after the problems are found, feeding back the contract information of the project to a financial department and a business department related to the project according to the project type of the project in the contract, and continuously tracking the contract payment information of the project.
Another aspect of the present invention as shown in fig. 2 provides a power project contract monitoring method, comprising the steps of:
step 1: and storing contract basic information and contract execution information through an ERP system in a business circulation mode, a data input mode and the like. Wherein, the basic information of the contract is as follows: province company name, province company code, prefecture company name, project code, project name, project type, project category, purchase order number, supplier name, payment condition, contract amount, contract payment proportion, commissioning date, contract validation date, WBS code, WBS description, etc.; contract payment information:
provincial company name, provincial company code, item name, year of accounting, accounting document number, accounting document line item, debit/credit identification, purchase order number, payment type, payment amount, payment date, WBS code, WBS description, line item, arrival date, arrival amount, material code, material name, quantity received, etc.
Step 2: and extracting a contract payment summary table, an order payment detail table and a material detail table in the ERP system into a contract execution monitoring database through a data extraction tool KETTLE.
And step 3: and performing broad-sheet integration on the contract payment summary sheet, the order payment detail sheet and the material detail sheet in the contract execution monitoring database according to a broad-sheet integration rule through the data extraction tool KETTLE to form a contract payment summary broad sheet, an order payment detail sheet and a material detail broad sheet. And performing database table association through the KETTLE software to perform data query and combination.
Based on the contract payment summary table, the relevant information is obtained by collecting the association of the order number and the order payment detail table and the material detail table.
TABLE 1 contract payment summary broad sheet
Figure BDA0002685725140000031
Figure BDA0002685725140000041
Figure BDA0002685725140000051
2. Order payment detail table
And directly corresponding.
Table 2 order payment details table
Figure BDA0002685725140000052
Figure BDA0002685725140000061
3. Material detail and width table
And associating the material detail table with the material code table through material codes to form a material detail width table.
TABLE 3 materials detail and width table
Figure BDA0002685725140000062
And 4, step 4: and storing the integrated broad form data in an oracle database.
And 5: and based on the contract payment summary width table, the order payment detail width table and the material detail width table, carrying out data monitoring and analysis work by using a tableau tool.
The method comprises the steps of monitoring the conditions of contract non-compliance (multi-payment/low-payment and early payment/late payment), finding that the contracts have problems in payment at present, and informing a business department of paying attention and correcting in time.
And (3) analysis: the method comprises the following steps of performing condition analysis in units, performing condition analysis in item types, performing condition analysis in links, performing condition analysis in time, performing condition analysis in late payment, early payment analysis, multi-payment analysis, low payment analysis and the like, and obtaining the conditions that contracts of the items should pay attention, links should pay attention and units should pay attention.
The monitored data includes: contract amount, contract payment proportion (prepaid payment proportion, payment proportion of arrived money, payment proportion of delivery money, payment proportion of warranty money), prepaid real payment amount, payment amount of arrived money, payment amount of delivery money, receiving amount, contract effective time and payment date;
when the payment type is 'prepayment', the payment amount is not equal to the contract amount and the prepayment proportion is abnormal 'multi-payment/low payment';
when the payment type is 'payment due' and the payment amount is not equal to the contract amount and the payment proportion of the payment due, the 'payment more/payment less' is abnormal;
when the payment type is 'transfer money', the payment amount is not equal to the payment proportion of the transfer money of the contract amount, and the 'multi-payment/low-payment' is abnormal;
when the payment type is 'warranty', the payment amount is not equal to the contract amount and the payment proportion of the warranty, and the 'over payment/under payment' is abnormal;
the item contract with materials is judged to be 'more payment/less payment' abnormal when the receiving quantity is null and the payment amount is more than the contract amount (the pre-payment proportion + the payment proportion of the arrived payment);
when the delivery date is empty, the payment amount is greater than the contract amount (the pre-payment proportion + the payment proportion of the arrived payment), and the 'pay more/pay less' is abnormal;
when the delivery date and the last payment time are in the same year and the payment amount is greater than the contract amount (the pre-payment proportion, the payment proportion of the arrived payment and the payment proportion of the arrived payment), the payment is 'more payment/less payment' abnormity;
when the pre-payment time is earlier than the contract effective time, the pre-payment is early paid;
the payment time of the payment of the arrived money is earlier than the arrival time of the goods and materials, and the payment is early;
early payment when the payment time of the shipping money is earlier than the project shipping time;
if the warranty payment time is earlier than the warranty period, the payment is early.
Step 6: and transmitting alarm information generated by monitoring to a monitoring alarm display screen in a data interface mode, issuing an alarm instruction, and transmitting contract execution non-compliance conditions to each business department by an operator on duty according to the alarm prompt information.

Claims (7)

1. A method for contract monitoring of an electrical power project, the method comprising the steps of:
the data source module is used for acquiring contract basic information and contract payment information;
the data integration module is used for extracting the contract payment summary table, the order payment detail table and the material detail table into the contract execution monitoring database through a data extraction tool, and performing broad table integration on the contract payment summary table, the order payment detail table and the material detail table in the contract execution monitoring database to form a contract payment summary broad table, an order payment detail broad table and a material detail broad table, and performing database table association;
a data storage module: storing the integrated wide table data in a database;
the data analysis module is used for monitoring and analyzing data based on the contract payment sum broad table, the order payment detail broad table and the material detail broad table;
and the project early warning module is used for informing other departments of the monitored contract execution non-compliance condition.
2. The power project contract monitoring method of claim 1, wherein the contract basic information includes: province company name, province company code, prefecture company name, project code, project name, project type, project category, purchase order number, supplier name, payment condition, contract amount, contract payment proportion, commissioning date, contract validation date, WBS code and WBS description;
contract payment information: provincial company name, provincial company code, item name, year of accounting, accounting document number, accounting document line item, debit/credit identification, purchase order number, payment type, payment amount, payment date, WBS code, WBS description, line item, arrival date, arrival amount, material code, material name, quantity of received goods.
3. The power project contract monitoring method of claim 1,
the contract payment summary broad table comprises a broad table, a contract payment summary table, an order payment detail table, a material detail table and a payment proportion description; the wide table comprises company information, project information, payment type, receiving quantity, payment amount, delivery date, pre-payment time, arrival payment time, delivery payment time and current warranty payment time;
the order payment detail width table comprises a width table and an order payment detail table; wherein, each attribute in the order payment list corresponds to each attribute in the broad list in the contract payment summary broad list;
the material detail and width table comprises a width table, a material detail table and a material coding table; and associating the material detail table with the material code table through material codes to form a material detail width table.
4. The power project contract monitoring method of claim 1, wherein the data analysis module performs the steps of:
when the payment type is 'prepayment', the payment amount is not equal to (contract amount and prepayment proportion), and the 'prepayment/micropayment' is abnormal;
when the payment type is ' payment due ', the payment amount is not equal to (contract amount is the payment proportion of the payment due '), and the ' payment more/payment less ' is abnormal;
when the payment type is 'transfer money', the payment amount is not equal to (contract amount and transfer money payment proportion), and the 'multi-payment/low-payment' is abnormal;
when the payment type is 'warranty', the payment amount is not equal to (contract amount and warranty payment proportion), and the 'more payment/less payment' is abnormal;
when the receiving quantity is empty, the payment amount is larger than { contract amount (pre-payment proportion + payment proportion of the arrived money) }, and the condition of 'more payment/less payment' is abnormal;
when the delivery date is empty, if the payment amount is larger than { contract amount (pre-payment proportion + payment proportion of arrival amount) }, the 'multi-payment/low payment' is abnormal;
when the delivery date and the last payment time are in the same year, and the payment amount is greater than { contract amount (a pre-payment proportion + a payment proportion of the arrived money) }, the payment is abnormal of 'more payment/less payment';
when the pre-payment time is earlier than the contract effective time, the pre-payment is early paid;
the payment time of the payment of the arrived money is earlier than the arrival time of the goods and materials, and the payment is early;
when the payment time of the shipping money is earlier than the project shipping time, early payment is carried out;
when the payment time of the warranty payment is earlier than the warranty period, the payment is early.
5. The method of claim 1, wherein the contract execution non-compliance condition of step 5 of the method comprises: more, less, early and late.
6. An electric power project contract monitoring system, comprising:
a data source module: acquiring contract information related to the electric power project from a data source end;
the data integration module: acquiring a contract payment summary broad table, an order payment detailed table and a material detailed table by acquiring the association of an order number and the order payment detailed table and the material detailed table on the basis of the contract payment summary table;
a data storage module: performing data storage on contract information acquired by the data source end, integration process data and result data of the data integration module;
a data analysis module: analyzing the execution condition of the project contract and providing data support for the root cause analysis of the business department;
a project early warning module: and after the problems in the contract payment link are found, feeding back the contract information of the project to other departments according to the project type of the project of the contract.
7. The system for contract monitoring of electric power projects according to claim 6, wherein the contract information includes contract payment summary information, order payment detail information, material detail information.
CN202010975718.8A 2020-09-16 2020-09-16 Power project contract monitoring system and method Pending CN112100264A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010975718.8A CN112100264A (en) 2020-09-16 2020-09-16 Power project contract monitoring system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010975718.8A CN112100264A (en) 2020-09-16 2020-09-16 Power project contract monitoring system and method

Publications (1)

Publication Number Publication Date
CN112100264A true CN112100264A (en) 2020-12-18

Family

ID=73759295

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010975718.8A Pending CN112100264A (en) 2020-09-16 2020-09-16 Power project contract monitoring system and method

Country Status (1)

Country Link
CN (1) CN112100264A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113052675A (en) * 2021-03-18 2021-06-29 北京房江湖科技有限公司 Data display method and device
CN113254546A (en) * 2021-05-24 2021-08-13 北京无线电测量研究所 Supply chain management and control system and method and electronic equipment
CN114358734A (en) * 2021-12-29 2022-04-15 深圳供电局有限公司 Project capital budget estimate management and control method and system
CN114819780A (en) * 2022-07-01 2022-07-29 得分数字科技(珠海)有限公司 Process data monitoring method and device, storage medium and computer equipment
CN116739530A (en) * 2023-08-08 2023-09-12 国网浙江省电力有限公司宁波供电公司 Intelligent settlement method and settlement device for power grid materials

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103824148A (en) * 2013-08-29 2014-05-28 国家电网公司 Power marketing risk pre-warning method and system
CN106846135A (en) * 2016-11-15 2017-06-13 天津博瑞凯科技有限公司 A kind of method for carrying out financial accounting automatically to contract
CN107491563A (en) * 2017-09-28 2017-12-19 深圳市爱贝信息技术有限公司 Towards the data processing method and system of settlement for account
CN110489459A (en) * 2019-08-07 2019-11-22 国网安徽省电力有限公司 A kind of enterprise-level industry number fused data analysis system based on big data platform
CN110597899A (en) * 2019-09-18 2019-12-20 云南电网有限责任公司电力科学研究院 Project expense management method and system
CN111275264A (en) * 2020-02-24 2020-06-12 国网冀北电力有限公司 Electric power market main body risk early warning monitoring system and early warning method thereof
CN111459923A (en) * 2020-03-16 2020-07-28 上海维信荟智金融科技有限公司 Mobile BI business intelligence solution method and system

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103824148A (en) * 2013-08-29 2014-05-28 国家电网公司 Power marketing risk pre-warning method and system
CN106846135A (en) * 2016-11-15 2017-06-13 天津博瑞凯科技有限公司 A kind of method for carrying out financial accounting automatically to contract
CN107491563A (en) * 2017-09-28 2017-12-19 深圳市爱贝信息技术有限公司 Towards the data processing method and system of settlement for account
CN110489459A (en) * 2019-08-07 2019-11-22 国网安徽省电力有限公司 A kind of enterprise-level industry number fused data analysis system based on big data platform
CN110597899A (en) * 2019-09-18 2019-12-20 云南电网有限责任公司电力科学研究院 Project expense management method and system
CN111275264A (en) * 2020-02-24 2020-06-12 国网冀北电力有限公司 Electric power market main body risk early warning monitoring system and early warning method thereof
CN111459923A (en) * 2020-03-16 2020-07-28 上海维信荟智金融科技有限公司 Mobile BI business intelligence solution method and system

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113052675A (en) * 2021-03-18 2021-06-29 北京房江湖科技有限公司 Data display method and device
CN113052675B (en) * 2021-03-18 2024-04-19 贝壳找房(北京)科技有限公司 Data display method and device
CN113254546A (en) * 2021-05-24 2021-08-13 北京无线电测量研究所 Supply chain management and control system and method and electronic equipment
CN114358734A (en) * 2021-12-29 2022-04-15 深圳供电局有限公司 Project capital budget estimate management and control method and system
CN114819780A (en) * 2022-07-01 2022-07-29 得分数字科技(珠海)有限公司 Process data monitoring method and device, storage medium and computer equipment
CN116739530A (en) * 2023-08-08 2023-09-12 国网浙江省电力有限公司宁波供电公司 Intelligent settlement method and settlement device for power grid materials
CN116739530B (en) * 2023-08-08 2023-12-29 国网浙江省电力有限公司宁波供电公司 Intelligent settlement method and settlement device for power grid materials

Similar Documents

Publication Publication Date Title
CN112100264A (en) Power project contract monitoring system and method
CN113780990A (en) Cloud intelligence manufacturing platform based on artificial intelligence production management mode and processing method
CN110766528A (en) Client credit self-evaluation factory real-time intelligent analysis management system
CN110334950B (en) Iron tower intelligent production and group management and control system
CN111210108B (en) Performance management and control model of electric power material supply chain
CN114118883B (en) Financial cost mining and analyzing system and method based on big data
CN104636973A (en) Method of monitoring enterprise false invoice through commodity composition and system thereof
CN112990829B (en) Asset management system based on block chain
CN115170090A (en) Project management method and device, electronic equipment and readable storage medium
CN113590607A (en) Electric power marketing report realization method and system based on report factor
CN110781235A (en) Big data based purchase data processing method and device, terminal and storage medium
CN101059852A (en) System and method for managing enterprise environmental impacts
CN110992019A (en) Automatic settlement system and method for electricity purchase fee
CN115293734A (en) Real-time cost accounting method and system based on manufacturing process
CN115860635A (en) Laboratory hazardous chemicals management system based on electronic tags
CN115330404A (en) System and method for electric power marketing inspection
CN114819710A (en) Management method and device of electric energy metering device, computer equipment and storage medium
CN114663033A (en) Dynamic inventory method, system and storage medium for article recovery
CN115660567A (en) GIS-based intelligent engineering management system and method
CN113592611A (en) Integrated management system for centralized acquisition and supervision of garbage incineration enterprises
El-Wafi Siemens: process mining for operational efficiency in Purchase2Pay
CN112053217A (en) Financial valuation statement generation method and device
KR101450273B1 (en) Selling statistics system and method for operating thereof
CN114819223A (en) Processing method of solid waste byproduct information management system of iron and steel enterprise
CN117291402B (en) Production navigation visual display method and system in semiconductor industry

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