CN114265842A

CN114265842A - Audit data processing method, device, equipment and storage medium based on ERP system

Info

Publication number: CN114265842A
Application number: CN202111552865.5A
Authority: CN
Inventors: 黄可欣
Original assignee: Guangdong Baiyun University
Current assignee: Guangdong Baiyun University
Priority date: 2021-12-17
Filing date: 2021-12-17
Publication date: 2022-04-01

Abstract

The application relates to an ERP system-based audit data processing method, an ERP system-based audit data processing device, computer equipment, a storage medium and a computer program product. The method and the system can extract various required data from the ERP system, and arrange the data rapidly for an auditor to use, thereby saving the auditing time and improving the auditing efficiency. The method comprises the following steps: creating a dedicated database in a storage space in response to a database creation instruction; responding to a data import instruction, extracting data to be audited from a preset database in the ERP system, and storing the data to be audited in a special database; and responding to the data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule.

Description

Audit data processing method, device, equipment and storage medium based on ERP system

Technical Field

The present application relates to the field of database technologies, and in particular, to an audit data processing method and apparatus, a computer device, a storage medium, and a computer program product based on an ERP system.

Background

Audit is an economic supervision activity which is authorized by the state or entrusted by the state, and special methods are applied to audit and supervise the authenticity and compliance of the finance, financial income and expenditure, operation and management activities and relevant data of an audited unit according to relevant regulations, audit criteria and accounting theory so as to maintain financial rules and improve economic benefits.

With the wide application of ERP (Enterprise Resource Planning) in the business management process of an Enterprise, auditors face the difficult problems of reduced auditing efficiency and increased auditing cost due to more and more complicated audit data obtained from the ERP system. At present, three ways of extracting audit data are provided, one is to extract data by using some special audit software, the other is to extract data by using foreground query and report, and the third is to directly collect data from a background database. The three methods need support of other professional software or directly acquire the original database from the background database, are complex in technology and need a certain technical basis for auditors, increase the time of the auditors and reduce the working efficiency.

Disclosure of Invention

In view of the above, it is necessary to provide an ERP system-based audit data processing method, apparatus, computer device, computer readable storage medium and computer program product.

In a first aspect, the application provides an audit data processing method based on an ERP system. The method comprises the following steps:

creating a dedicated database in a storage space in response to a database creation instruction;

responding to a data import instruction, extracting data to be audited from a preset database in the ERP system, and storing the data to be audited in the special database;

and responding to a data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule.

In one embodiment, the data processing instructions comprise data filtering instructions; responding to a data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule, wherein the method comprises the following steps:

screening element contents of a plurality of associated elements associated with a target field from the special database in response to the data screening instruction for the target field;

and arranging the element contents of the key elements according to a time sequence and displaying the element contents on the preset interface.

In one embodiment, the data processing instruction includes a data pivot table creating instruction, and the step of, in response to the data processing instruction, screening target data corresponding to the data processing instruction from the dedicated database, and displaying the target data on a preset interface according to a specified rule includes:

responding to the pivot table creating instruction, screening and counting the special database to obtain statistical data corresponding to the target field; the target field is contained in the data time-casting creation instruction;

and displaying the statistical data on the preset interface according to a table form.

In one embodiment, the data processing instruction includes a data matching instruction, and the step of screening, in response to the data processing instruction, target data corresponding to the data processing instruction from the dedicated database, and displaying the target data on a preset interface according to a specified rule includes:

in response to the data matching instruction, searching target data corresponding to a target field from the special database; the data matching instruction comprises the target field;

and displaying the target data and the target field in a correlated manner on the preset interface.

In one embodiment, the data processing instruction includes any one of SQL, Python, and Tableau.

In one embodiment, the private database contains a plurality of data tables.

In a second aspect, the application further provides an audit data processing device based on the ERP system. The device comprises:

the special database creating module is used for responding to a database creating instruction and creating a special database in the storage space;

the audit data import module is used for responding to a data import instruction, extracting audit data from a preset database in the ERP system and storing the audit data in the special database;

and the target data processing module is used for responding to a data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule.

In a third aspect, the present application also provides a computer device. The computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps in the embodiment of the auditing data processing method based on the ERP system when executing the computer program.

In a fourth aspect, the present application further provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps in the above-described ERP system-based audit data processing method embodiments.

In a fifth aspect, the present application further provides a computer program product. The computer program product includes a computer program that, when executed by a processor, performs the steps in the above-described ERP-system-based audit data processing method embodiment.

According to the auditing data processing method and device based on the ERP system, the computer equipment, the storage medium and the computer program product, the special database is created in the storage space by responding to the database creation instruction; responding to a data import instruction, extracting data to be audited from a preset database in the ERP system, and storing the data to be audited in a special database; and responding to the data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule. The method and the system can extract various required data from the ERP system, and arrange the data rapidly for an auditor to use, thereby saving the auditing time and improving the auditing efficiency.

Drawings

FIG. 1 is a diagram of an application environment of an ERP system-based audit data processing method in an embodiment;

FIG. 2 is a schematic flow diagram of an audit data processing method based on an ERP system in one embodiment;

FIG. 3 is a block diagram of an embodiment of an audit data processing apparatus based on an ERP system;

FIG. 4 is a diagram illustrating an internal structure of a computer device according to an embodiment;

fig. 5 is an internal structural view of a computer device in another embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The auditing data processing method based on the ERP system provided by the embodiment of the application can be applied to the application environment shown in figure 1. Wherein the terminal 101 communicates with the server 102 via a network. The data storage system may store data that the server 102 needs to process. The data storage system may be integrated on the server 102, or may be located on the cloud or other network server. The terminal 101 may be but not limited to various personal computers, notebook computers, smart phones, tablet computers, internet of things devices and portable wearable devices, and the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart car-mounted devices, and the like. The portable wearable device can be a smart watch, a smart bracelet, a head-mounted device, and the like. The server 102 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.

In one embodiment, as shown in fig. 2, an audit data processing method based on an ERP system is provided, which is described by taking the method as an example applied to the terminal 101 in fig. 1, and includes the following steps:

step S201, responding to a database creating instruction, and creating a special database in a storage space;

the database creating instruction is an instruction which is input on a preset interface and used for creating a new database, and the instruction comprises information such as the name and the data storage address of the new database. The dedicated database is a small database which is different from an ERP system database and is used by professional users, and as the ERP system in an organization (an enterprise or an organization) integrates a large number of different types of data, the ERP system data can be divided into 5 types from the auditing view: control data, main data, service data, peripheral data and accounting voucher. The control data is generally divided into control data for describing basic parameters including an accounting period, a number of subjects and digits, an accounting system used, operator's authority, and the like, and control data for defining business rules. The control data used for defining the business rule comprises a cost accounting method, a depreciation method, a report form access method, a method for calculating employee benefit fee and the like. The related regulations of the accounting policy are merged into an ERP system, and the system automatically carries out cost accounting, depreciation accounting, employee compensation and welfare accounting and the like. Improve financial staff work efficiency and reduce the mistake. The control data is typically performed in the system function settings and viewed in the associated function settings interface. The control data is generally stored in an ERP background database and can also be checked through a data query method. Master data refers to data shared among subsystems throughout an enterprise, including customers, suppliers, accounts, materials, organizational structures, employees, partners, location information, and the like. Primary data is high-value data that can be reused across businesses within an organization, and is the fundamental data that must be used during enterprise operations. Typically determined at installation or initialization of the ERP system. The main data is stored in the database for a long time, and can be directly inquired in the foreground generally through the main data management function of the ERP, and can also be directly extracted from the background database. The business data is used for recording transaction information generated in daily operation and management activities of enterprises. Business data is data that is generally subject to a business process relative to primary data. The ERP system usually records business data in forms of documents, accounts and the like, including purchasing agreements, purchasing contracts, purchasing orders, sales contracts, sales production orders, financial data and the like in purchasing management. Generally, the data is directly inquired on a corresponding inquiry interface of the ERP or by using a corresponding report output function, and can also be directly collected from a background database. Peripheral data refers to a large amount of peripheral system data outside of the ERP system. Because ERP cannot meet all of the management needs of an enterprise, the enterprise also uses a large number of other information systems. And the data of each system are linked for use by setting an interface. The background database of the peripheral system can be directly collected generally. The acquisition may also be performed through an interface. The account table setting of the accounting voucher ERP is different from that of traditional financial management software, and the general SAP adopts two levels of general accounts. The financial certificates generated by enterprises implementing ERP are generally subdivided into each minimum service point, and the data volume is very large. The number of the data fields of a common enterprise (the enterprise does not contain customized customization, and the enterprise has super much business volume) is more than twenty thousand by only background data tables. Most data tables and field names are also difficult to understand for untouched people. Especially, the financial reimbursement automatic scanning is realized to generate the unit of the bookkeeping entry, the generated bookkeeping voucher is often hundreds of pieces, a large amount of business data and data are directly stored in the background, and the paper voucher is not attached. Opening an account detail account provided by the enterprise can lead the computer to be stopped and rotated for a long time. Therefore, the dedicated database is used for screening out data required by professionals from a large amount of data in the ERP system so as to establish a new database, for example, financial staff only need to screen out financial data from the ERP system so as to establish the dedicated database.

Specifically, the flow of establishing the dedicated database is as follows: a database creation instruction is input on a preset page, the instruction content includes the name of a dedicated database and the size of the database, after receiving the database creation instruction, the terminal 101 can create a corresponding dedicated database in a storage space, the terminal 101 can send the instruction to the server 102, and the server 102 creates a corresponding dedicated database in a local space or a cloud.

Step S202, responding to a data import instruction, extracting data to be audited from a preset database in an ERP system, and storing the data to be audited in the special database;

the data import instruction is an instruction for selecting necessary data from an instruction data source and importing the data into a dedicated database.

Specifically, a data source and a target storage location on the dedicated database are selected, and the data source refers to the ERP system. The server extracts and stores the data to be reviewed from the data source to the target storage location on the private database. The dedicated database includes a plurality of data tables.

Alternatively, creating a private database may also use a data import wizard as auxiliary software that can select a particular work form in the data source, and can also specify a target data form in the private database.

Step S203, responding to a data processing instruction, screening target data corresponding to the data processing instruction from the special database, and displaying the target data on a preset interface according to a specified rule.

The data processing instruction comprises a data screening instruction, a data perspective table instruction and a data matching search instruction (the data matching search instruction can realize the function of the Vlookup function).

Specifically, a data processing instruction (including any one of a data screening instruction, a data pivot table instruction and a data matching search instruction) is input, the server responds to the instruction, can screen corresponding data from the special database, and displays the corresponding data on a preset interface according to a rule corresponding to the data processing instruction so as to enable a user to further process the data.

In the above embodiment, the dedicated database is created in the storage space by responding to the database creation instruction; responding to a data import instruction, extracting data to be audited from a preset database in the ERP system, and storing the data to be audited in a special database; and responding to the data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule. According to the embodiment, various required data can be extracted from the ERP system, and the data can be quickly arranged for an auditor to use, so that the auditing time is saved, and the auditing efficiency is further improved.

In an embodiment, the data processing instruction includes a data filtering instruction; the step S203 includes: screening element contents of a plurality of associated elements associated with a target field from the special database in response to the data screening instruction for the target field; and arranging the element contents of the key elements according to a time sequence and displaying the element contents on the preset interface.

Specifically, one specific example of the data filtering instruction is as follows:

Use xiaomi

Select*from ceshi2

where customer name of'

The meaning of the code is: use xiaomi means that the database xiaomi is used, use means that the database xiaomi is used, because multiple databases may be established in practical application, each database has a ceshi2 table, so ceshi2 below xiaomi is used, select from ceshi2 means that all elements are screened from the ceshi table 2, all elements are required, where the where customer name is three, is a condition, we screen rows whose customer name is three, and the three is a Chinese character and is included by quotation marks in a quotation state.

The meaning of the above three sections of codes is that a conditional statement is used to screen the rows meeting the conditions from the surface of a database subordinate to the database.

Further, the screened target data table needs to be consistent with the name of the data table originally stored in the special database, and if the name is inconsistent, the server returns name error prompt information to the terminal. In addition, the worksheet names in the private database may be renamed, such as ceshi2, which may be modified to other names; moreover, when the method is executed, keywords used in the operation process, such as use and where colors are not the same, the method cannot be executed, and a computer cannot recognize the keywords.

According to the embodiment, the required data can be screened from the special database through the data screening instruction, so that the audit staff can further process the data, and the audit efficiency is improved.

In an embodiment, the data processing instruction includes a pivot table creation instruction, and the step S203 includes: responding to the pivot table creating instruction, screening and counting the special database to obtain statistical data corresponding to the target field; the target field is contained in the data time-casting creation instruction; and displaying the statistical data on the preset interface according to a table form.

Specifically, one example of a pivot table creation instruction is as follows:

use xiaomi

select customer name, customer code, CONVERT (varchar (10), DATEPART (mm, date)) AS month,

sum (income amount) AS income, sum (cost amount) AS cost

from ceshi2

group by customer name, CONVERT (varchar (10), DATEPART (mm, date)), customer code

order by customer name

Wherein use is used; the select indicates that I want to select the columns that I need, namely the elements that I need, the star symbol (star mark) mentioned in the last code indicates all the columns, and I only needs four columns and does not need other columns, so that the four elements or four columns of the customer name, the customer code, the income amount and the cost amount are directly selected; the term "convert () means to increase the length of a character, the term" 10 "being the inside, and datepart" being the date 2020-5-29 changed to the month, i.e., mm; sum (income amount) AS income, the code means i want to sum the income amount column, AS means renaming, sometimes long name we give a column name; the group by customer name is used for summarizing the income cost according to the customer name; the order by customer names are sorted by customer name.

According to the embodiment, the required data statistics can be realized and the data perspective table function can be realized through the data perspective table creating instruction, so that the audit staff can further process the data, and the data processing efficiency is improved.

In an embodiment, the data processing instruction includes a data matching instruction, and the step S203 includes: in response to the data matching instruction, searching target data corresponding to a target field from the special database; the data matching instruction comprises the target field; and displaying the target data and the target field in a correlated manner on the preset interface.

Specifically, an example of the data matching instruction is as follows:

use xiaomi

SELECT yue customer name, yue end balance,

zhangling. [ within 1 year ], zhangling. [1-2 years ], zhangling. [2-3 years ]

FROM yue LEFT JOIN zhangling

ON yue. customer name zhanggling. customer name

ORDER BY yue customer name;

meaning of the code: use xiaomi means you use xiaomi this database; use is used in the sense of usage; because you may build multiple databases, each with zhangling table, we need to use zhangling table under xiaomi; SELECT yue customer name, yue end balance; the meaning of the sentence zhangling [ within 1 year ], zhangling [ within 1-2 years ], zhangling [ within 2-3 years ] screens out the elements of two tables, for example, the customer name of a balance table, and then we use yue as the customer name, and the rest is the same; when the account age of the account age table is written, the account age table is required to be drawn with a parenthesis within zhangling.1 year, the account age table is required to be drawn with zhangling [ within 1 year ], and otherwise, the account age table is not correct; FROM which table the term means FROM, FROM the two tables, LEFT JOIN is the LEFT link, i.e. the balance table is taken as the standard; the term "zhangling" means a condition, and ON is an expression when the condition is satisfied, that is, when the client name in the balance table is the client name in the account table; ORDER BY yue customer name;

the meaning of the data matching instruction is to realize the function of the vlookup function in the SQL, namely matching + sorting.

According to the embodiment, the data matching instruction can be used for realizing the needed data statistics and the Vlookup function, so that auditors can further process the data, and the data processing efficiency is improved.

In one embodiment, the data processing instruction may support any one of a plurality of technical stack languages, including SQL, Python, and Tableau, and may have a wider application base.

It should be understood that, although the steps in the flowcharts related to the embodiments as described above are sequentially displayed as indicated by arrows, the steps are not necessarily performed sequentially as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the embodiments described above may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the execution order of the steps or stages is not necessarily sequential, but may be rotated or alternated with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the application also provides an audit data processing device based on the ERP system, which is used for realizing the above related audit data processing method based on the ERP system. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the method, so that specific limitations in one or more embodiments of the audit data processing device based on the ERP system provided below can refer to the limitations for the audit data processing method based on the ERP system in the above, and are not described herein again.

In one embodiment, as shown in FIG. 3, there is provided an ERP system-based audit data processing apparatus 300 comprising: a dedicated database creating module 301, an audit data importing module 302 and a target data processing module 303, wherein:

a dedicated database creating module 301, configured to create a dedicated database in a storage space in response to a database creating instruction;

a to-be-audited data import module 302, configured to, in response to a data import instruction, extract data to be audited from a preset database in the ERP system, and store the to-be-audited data in the dedicated database;

and the target data processing module 303 is configured to respond to a data processing instruction, screen the special database to obtain target data corresponding to the data processing instruction, and display the target data on a preset interface according to a specified rule.

In an embodiment, the data processing instructions comprise data filtering instructions; the target data processing module 303 is further configured to: screening element contents of a plurality of associated elements associated with a target field from the special database in response to the data screening instruction for the target field; and arranging the element contents of the key elements according to a time sequence and displaying the element contents on the preset interface.

In an embodiment, the data processing instruction includes a pivot table creating instruction, and the target data processing module 303 is further configured to: responding to the pivot table creating instruction, screening and counting the special database to obtain statistical data corresponding to the target field; the target field is contained in the data time-casting creation instruction; and displaying the statistical data on the preset interface according to a table form.

In an embodiment, the data processing instruction includes a data matching instruction, and the target data processing module 303 is further configured to:

in response to the data matching instruction, searching target data corresponding to a target field from the special database; the data matching instruction comprises the target field; and displaying the target data and the target field in a correlated manner on the preset interface.

In an embodiment, the data processing instruction includes any one of SQL, Python, and Tableau.

In one embodiment, the private database includes a plurality of data tables.

All or part of each module in the auditing data processing device based on the ERP system can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing enterprise audit data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to realize an ERP system-based audit data processing method.

In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 5. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to realize an ERP system-based audit data processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

It will be appreciated by those skilled in the art that the configurations shown in fig. 4 to 5 are only block diagrams of some configurations relevant to the present application, and do not constitute a limitation on the computer apparatus to which the present application is applied, and a particular computer apparatus may include more or less components than those shown in the drawings, or may combine some components, or have a different arrangement of components.

In one embodiment, a computer device is provided, which includes a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the above-mentioned embodiment of the ERP system-based audit data processing method when executing the computer program.

In one embodiment, a computer-readable storage medium is provided, having stored thereon a computer program that, when executed by a processor, implements the steps in the above-described ERP-system-based audit data processing method embodiments.

In one embodiment, a computer program product is provided that includes a computer program that, when executed by a processor, performs the steps in the above-described ERP-system-based audit data processing method embodiments.

It should be noted that, the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. An audit data processing method based on an ERP system is characterized by comprising the following steps:

2. The method of claim 1, wherein the data processing instructions comprise data filtering instructions; responding to a data processing instruction, screening the special database to obtain target data corresponding to the data processing instruction, and displaying the target data on a preset interface according to a specified rule, wherein the method comprises the following steps:

3. The method of claim 1, wherein the data processing instructions include a pivot table creation instruction, and wherein the responsive to the data processing instructions, the selecting target data corresponding to the data processing instructions from the dedicated database, and displaying the target data on a preset interface according to a specified rule, includes:

4. The method of claim 1, wherein the data processing instruction comprises a data matching instruction, and the step of screening target data corresponding to the data processing instruction from the dedicated database in response to the data processing instruction and displaying the target data on a preset interface according to a specified rule comprises:

5. The method according to any one of claims 1 to 4, wherein the data processing instruction comprises any one of SQL, Python and Tableau.

6. The method according to any of claims 1 to 4, wherein the dedicated database comprises a plurality of data tables.

7. An audit data processing device based on an ERP system, which is characterized by comprising:

8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 6.

9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that the computer program realizes the steps of the method of any one of claims 1 to 6 when executed by a processor.