Intersystem data verification method and device

A technology of data and data tables, applied in the field of data checking between systems, can solve problems such as time-consuming, labor-intensive, low efficiency, and labor

Inactive Publication Date: 2014-11-19
STATE GRID CORP OF CHINA +2
View PDF0 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a method and device for inter-system data checking, to at least so

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Intersystem data verification method and device
  • Intersystem data verification method and device
  • Intersystem data verification method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0019] According to an embodiment of the present invention, a method for checking data between systems is provided, figure 1 It is a flowchart of a method for checking data between systems according to an embodiment of the present invention, such as figure 1 As shown, the method includes the following steps:

[0020] Step S10, obtain the financial account summary data of the enterprise management software, and generate the first data table, the field information of the first data table includes: company code, fiscal year, period, account number, account name, management object ID, management object name, Beginning balance, ending balance, beginning balance direction, ending balance direction, debit amount, credit amount.

[0021] Specifically, the enterprise management software provides an interface for querying summary data of financial subjects, and a data query request can be sent to the interface to obtain summary data of financial subjects. Wherein, after receiving the ...

Embodiment 2

[0047] According to an embodiment of the present invention, there is also provided an inter-system data checking device for implementing the above-mentioned inter-system data checking method, such as Figure 4 As shown, the device includes: a first acquisition module 40 , a second acquisition module 42 , a first processing module 44 , and a second processing module 46 .

[0048] Wherein the first acquisition module 40 is used to acquire the financial account summary data of the enterprise management software, and generate the first data table, the field information of the first data table includes: company code, fiscal year, period, account number, account name, management object ID, management object name, beginning balance, ending balance, beginning balance direction, ending balance direction, debit amount, and credit amount.

[0049] Specifically, the first acquisition module 40 provides a financial subject summary data query interface through the enterprise management soft...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses an intersystem data verification method and device. The method includes the steps that summarized data of accounts of finance of management software of an enterprise are obtained, and a first data table is generated; finance classification item data of a finance account system are obtained, and a second data table is generated; the corresponding field mapping relation between fields of the second data table and fields of the first data table is established according to field information of the first data table and field information of the second data table, and a main data mapping table is generated; the content of the corresponding fields of the second data table and the content of the corresponding fields of the first data table are compared according to the mapping relation of the main data mapping table, and a third data table used for displaying the comparing result is generated. The intersystem data verification method and device solve the technical problems that in the manual account checking process, time and labor are consumed, accuracy is lacking, and efficiency is low.

Description

technical field [0001] The invention relates to the field of power grid system data management, in particular to a method and device for checking data between systems. Background technique [0002] State Grid Qinghai Provincial Electric Power Company's mature enterprise management software and financial accounting system transmit accounting vouchers to each other through real-time synchronization. Under the mechanism of mutual transmission of vouchers, it is necessary to ensure that the packaged software and the financial control module have consistent accounting data, so that reports can be issued in financial control on time. In order to ensure the timeliness and accuracy of the monthly financial statements, financial personnel need to manually perform system reconciliation before the end of the month to check whether the account balances of the enterprise management software and the financial accounting system are consistent, and whether the accounting data is complete. ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06Q10/06G06Q50/06
Inventor 魏永瑜何松周群星刘世良苏蔚马惠萍丹乾李璇孙军芳黄福亮
Owner STATE GRID CORP OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products