CN112100264A - Power project contract monitoring system and method - Google Patents
Power project contract monitoring system and method Download PDFInfo
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000012544 monitoring process Methods 0.000 title claims abstract description 49
- 239000000463 material Substances 0.000 claims description 55
- 238000004458 analytical method Methods 0.000 claims description 53
- 230000010354 integration Effects 0.000 claims description 28
- 230000002159 abnormal effect Effects 0.000 claims description 19
- 238000013500 data storage Methods 0.000 claims description 12
- 238000013075 data extraction Methods 0.000 claims description 11
- 238000007405 data analysis Methods 0.000 claims description 9
- 238000010200 validation analysis Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 11
- 238000005516 engineering process Methods 0.000 description 3
- 238000005065 mining Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
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
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
2. Order payment detail table
And directly corresponding.
Table 2 order payment details table
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
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.
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)
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)
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 |
-
2020
- 2020-09-16 CN CN202010975718.8A patent/CN112100264A/en active Pending
Patent Citations (7)
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)
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 |