CN114037304A - Data collection method, equipment and medium for cost data - Google Patents

Abstract

The embodiment of the specification discloses a data collection method, equipment and a medium of cost data, wherein the method comprises the following steps: when the data source of the cost data to be collected changes, determining a plurality of data tables corresponding to the cost data to be collected, wherein the data tables comprise a basic table and an association table; acquiring field information to be maintained in a basic table according to the type of the cost data to be collected; and updating the field information to be maintained in the basic table and updating the associated table information so as to realize data collection of the cost data. When the data source of the cost data to be collected changes, the data collection under the scene that the data source changes is realized by maintaining the specific fields of the basic tables and the associated table information in the data tables, the collection efficiency of the cost data is greatly improved, the condition that the cost data source changes can be responded more quickly, and the work of project site implementers is more efficient.

Description

Data collection method, equipment and medium for cost data

Technical Field

The present disclosure relates to the field of computer technologies, and in particular, to a method, an apparatus, and a medium for collecting cost data.

Background

Enterprise Resource Planning (ERP) is a management platform which is established on the basis of information technology and provides decision operation means for an Enterprise decision layer and employees by using a systematic management idea. The ERP system supports mixed manufacturing environments of discrete type, flow type and the like, the application range is expanded from the manufacturing industry to the public service departments of retail industry, service industry, banking industry, telecommunication industry, government and schools and the like, and enterprise resources are effectively integrated by fusing database technology, a graphical user interface, a fourth generation query language, a client server structure, a computer-aided development tool, a portable open system and the like.

In the process of applying the ERP cost management system, each time node such as the end of a term or the end of a year and the like needs to collect cost object data of the current term, the number of materials consumed by the cost object, various expenses and cost incentive data so as to carry out actual cost accounting. In an actual application scenario, a data source corresponding to data to be collected often changes, and when the data source changes, in the prior art, a developer needs to modify a code of a product function of a collection tool, but the developer needs time for code modification, and a user cannot normally use the collection tool in this time period.

Disclosure of Invention

One or more embodiments of the present specification provide a data aggregation method, apparatus, and medium for cost data, which are used to solve the following technical problems: in an actual application scenario, a data source corresponding to data to be aggregated often changes, so that a user cannot normally use an aggregation tool.

One or more embodiments of the present disclosure adopt the following technical solutions:

one or more embodiments of the present specification provide a method of data aggregation of cost data, the method comprising: when the data source of the cost data to be collected changes, determining a plurality of data tables corresponding to the cost data to be collected, wherein the data tables comprise a basic table and an association table; acquiring field information to be maintained in the basic table according to the type of the cost data to be collected; and updating the field information to be maintained in the basic table and updating the associated table information so as to realize data collection of the cost data.

Further, the types of the cost data to be collected include: a cost object type, a material consumption type, a cost element type, and a cost cause type; the determining, according to the type of the cost data to be collected, field information to be maintained in the base table specifically includes: when the type of the cost data to be collected is the cost object type, the maintenance field information of the cost data to be collected comprises any one or more of a cost center, a cost period, a business date, a cost object batch, a finished quantity, a production quantity, a waste quantity and quantity precision; when the type of the cost data to be collected is the material consumption type, the maintenance field information of the cost data to be collected comprises any one or more items of cost center, cost period, business date, cost object batch, expense item, material batch, material unit price, material quantity and quantity precision; when the type of the cost data to be collected is the type of the cost element, the maintenance field information of the cost data to be collected comprises any one or more of a cost center, a cost period, a business date, a cost object batch, a cost item, a cost quantity, a cost amount and quantity precision; when the type of the cost data to be collected is the cost cause type, the maintenance field information of the cost data to be collected comprises any one or more of a cost center, a cost period, a business date, a cost object batch, a cost cause, a finished consumption quantity, a manufacturing consumption quantity and quantity precision.

Further, the base table is used for representing a data source of the cost data to be collected, and the association table is used for representing an associated data table of the cost data to be collected.

Further, the field information to be maintained includes a data source corresponding to the field; after the field information to be maintained in the basic table is obtained according to the type of the cost data to be collected, the method further includes: determining a data source corresponding to the field according to the data source of the cost data to be collected; and determining a data table corresponding to the field through a data source corresponding to the field, and acquiring the access field in the data table.

Further, the updating the field information to be maintained and the association table information in the base table specifically includes: recording a data acquisition field corresponding to field information to be maintained in the basic table; and defining the data table where the access field is located as an association table according to the access field, and recording the name, association condition and association mode of the association table.

Further, before the obtaining of the field information to be maintained in the base table according to the type of the cost data to be collected, the method further includes: presetting data characteristics corresponding to the types of the cost data, wherein the data characteristics corresponding to the types of the cost objects are first characteristics, the data characteristics corresponding to the types of the material consumption are second characteristics, the data characteristics corresponding to the types of the expense factors are third characteristics, and the data characteristics corresponding to the types of the cost factors are fourth characteristics; calculating data characteristics of specified data in the cost data to be collected, and performing characteristic matching with the first characteristic, the second characteristic, the third characteristic and the fourth characteristic; and determining the type of the cost data to which the specified data belongs according to the matching result.

Further, before determining the plurality of data tables corresponding to the cost data to be collected, the method further includes: storing initial data sources corresponding to the cost data to be collected in advance, defining paths of a plurality of data tables corresponding to the initial data sources as first access paths, and performing access operation through the first access paths; acquiring a real-time data source corresponding to the cost data to be collected, and determining a second access path according to the real-time data source; and when the first access path and the second access path are different, judging that the data source of the cost data to be collected changes.

Further, before determining the plurality of data tables corresponding to the cost data to be collected, the method further includes: and acquiring the cost data to be collected through the second access path.

One or more embodiments of the present specification provide a data aggregation apparatus for cost data, comprising:

at least one processor; and the number of the first and second groups,

a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the above-described method.

One or more embodiments of the present specification provide a non-transitory computer storage medium storing computer-executable instructions configured to: when the data source of the cost data to be collected changes, determining a plurality of data tables corresponding to the cost data to be collected, wherein the data tables comprise a basic table and an association table; acquiring field information to be maintained in the basic table according to the type of the cost data to be collected; and updating the field information to be maintained in the basic table and updating the associated table information so as to realize data collection of the cost data.

The embodiment of the specification adopts at least one technical scheme which can achieve the following beneficial effects:

when the data source of the cost data to be collected changes, the data collection under the scene that the data source changes is realized by maintaining the specific fields of the basic tables and the associated table information in the data tables, the collection efficiency of the cost data is greatly improved, the condition that the cost data source changes can be responded more quickly, and the work of project site implementers is more efficient.

Drawings

In order to more clearly illustrate the embodiments of the present specification or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments described in the present specification, and for those skilled in the art, other drawings can be obtained according to the drawings without any creative effort. In the drawings:

FIG. 1 is a flow chart illustrating a data aggregation method for cost data according to an embodiment of the present disclosure;

FIG. 2 is a flow chart illustrating another data aggregation method for cost data according to an embodiment of the present disclosure;

FIG. 3 is a schematic diagram of a data source interface of a data aggregation tool for cost data according to an embodiment of the present disclosure;

FIG. 4 is a schematic diagram of a fetch field maintenance interface for a cost object type according to an embodiment of the present disclosure;

FIG. 5 is a schematic diagram of an association table information maintenance interface for cost object types according to an embodiment of the present disclosure;

FIG. 6 is a schematic diagram of an aggregation result display interface for cost object types according to an embodiment of the present disclosure;

FIG. 7 is a diagram of an aggregated result presentation interface for material consumption types provided by an embodiment of the present disclosure;

FIG. 8 is a schematic diagram of an aggregation result display interface for cost element types according to an embodiment of the present disclosure;

FIG. 9 is a schematic diagram of an aggregation result display interface for cost incentive types according to an embodiment of the present disclosure;

fig. 10 is a schematic structural diagram of a data aggregation apparatus for cost data according to an embodiment of the present disclosure.

Detailed Description

In order to make those skilled in the art better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only a part of the embodiments of the present specification, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present specification without any creative effort shall fall within the protection scope of the present specification.

Enterprise Resource Planning (ERP) is a management platform which is established on the basis of information technology and provides decision operation means for an Enterprise decision layer and employees by using a systematic management idea. The ERP system supports mixed manufacturing environments of discrete type, flow type and the like, the application range is expanded from the manufacturing industry to the public service departments of retail industry, service industry, banking industry, telecommunication industry, government and schools and the like, and enterprise resources are effectively integrated by fusing database technology, a graphical user interface, a fourth generation query language, a client server structure, a computer-aided development tool, a portable open system and the like. With the higher and higher informatization degree of enterprises and the more and more complex business processed by the ERP system, the frequency of the change of the cost data source is higher and higher, so that the research and development cost of the project is higher and higher, and the field implementation of the project is more difficult.

In the process of applying the ERP cost management system, each time node such as the end of a term or the end of a year and the like needs to collect cost object data of the current term, the number of materials consumed by the cost object, various expenses and cost incentive data so as to carry out actual cost accounting. After the data source required to be collected at the end of an enterprise ERP cost management system is changed, great troubles are brought to project implementation personnel, product function modification needs to be carried out by developers so as to adapt to the latest cost data access data source of an enterprise, then project field product upgrading is carried out, and then the normal operation of the ERP cost management system can be ensured. That is to say, in an actual application scenario, a data source corresponding to data that needs to be collected often changes, which results in that a user cannot normally use a collection tool, and in the prior art, a developer needs to modify a code of a product function of the collection tool, but this method results in a reduction in efficiency of project site work of an implementer, which brings great trouble to the implementer.

An embodiment of the present specification provides a data aggregation method for cost data, and fig. 1 is a schematic flow chart of the data aggregation method for cost data provided by the embodiment of the present specification, and is applied to a cost data aggregation system and may also be applied to a cost data aggregation tool, as shown in fig. 1, the method mainly includes the following steps:

step S101, when the data source of the cost data to be collected changes, a plurality of data tables corresponding to the cost data to be collected are determined.

In an embodiment of the present specification, when a data source of cost data that needs to be subjected to data aggregation changes, a data source of cost data that needs to be subjected to data aggregation is determined, and it should be noted that the cost data that needs to be subjected to data aggregation may be referred to as cost data to be aggregated. The sources of the cost data often relate to a plurality of data tables, when the data source of the cost data to be collected is determined, the plurality of data tables are determined, and the plurality of data tables are the data source of the cost data required to be collected. For example, a new piece of data is added through a new adding operation in the interface, and basic information configured by the data source is entered. Including the type of affiliation, number, name, base table, notes, and constraints on the data search.

In one embodiment of the present description, the data table includes a base table and a plurality of association tables. It should be noted that the association table refers to a source of a certain item in the cost data to be collected, and an association relationship is established between the association table and the base table through any field. For example, the data to be collected is personal information, which needs to obtain account information from the civil administration and social security information from the social security bureau, and the account information and the social security information are associated with each other through the identity number.

In an embodiment of the present specification, as the degree of informatization of an enterprise is higher and the service processed by the ERP system is more and more complex, and the frequency of the change of the cost data source is higher and higher, it is necessary to determine in advance whether a plurality of data tables corresponding to the cost data to be aggregated are changed. The specific judgment method is as follows: firstly, storing an initial data source of the cost data to be collected, and defining a data source path as a first access path, wherein it should be noted that the first access path is used for accessing from the data source. Then, acquiring a real-time data source corresponding to the cost data to be collected, and determining a second access path according to the real-time data source; and when the first access path and the second access path are different, judging that the data source of the cost data to be collected changes.

In an embodiment of the present disclosure, the initial data source includes a base table and a plurality of association tables, the access path of the data source of the initial base table may be defined as a first access path, the access path of the data source of the real-time base table may be defined as a second access path, and if the first access path is different from the second access path, it is determined that the data source of the cost data to be aggregated changes, and the cost data to be aggregated is obtained through the second access path.

In an embodiment of the present specification, if the first access path is the same as the real-time access path, the access path of the association table is further determined. Since the cost data to be collected may include a plurality of association tables, data sources of a plurality of initial association tables are respectively obtained as corresponding access paths, such as a path a, B, and C. And acquiring a plurality of association tables corresponding to the cost data to be collected, determining an access path of each association table, comparing the access paths with all initial paths respectively, and judging that the data source of the cost data to be collected changes if no path exists in the comparison result.

And step S102, acquiring field information to be maintained in the basic table according to the type of the cost data to be collected.

In one embodiment of the present description, the types of cost data to be aggregated include: a cost object type, a material consumption type, a cost element type, and a cost incentive type.

In one embodiment of the present description, it is desirable to determine the type of cost material to be aggregated. Firstly, data characteristics corresponding to types of all cost data are preset, wherein the data characteristics corresponding to the types of the cost objects are first characteristics, the data characteristics corresponding to the types of the material consumption are second characteristics, the data characteristics corresponding to the types of the expense factors are third characteristics, and the data characteristics corresponding to the types of the cost factors are fourth characteristics. It should be noted that the first feature may be a quantitative type expression, such as: the finished quantity, the production quantity and the waste quantity; the second characteristic may be a representation of the type of material, for example: materials, material lots, material unit prices, and material quantities; the third feature may be an expression of a fee type, such as: fee items, fee amounts, and fee amounts; the fourth feature may be a relevant expression for determining the cost, such as cost momentum, finishing consumption quantity, and in-process consumption quantity. And calculating the data characteristics of the designated data in the cost data to be collected, and performing characteristic matching with the first characteristic, the second characteristic, the third characteristic and the fourth characteristic. And finally, determining the type of the cost data to which the specified data belongs according to the matching result.

In one embodiment of the present description, the field information to be maintained in the base table is determined based on the type of cost data to be aggregated. It should be noted that the field information to be maintained includes a data source corresponding to the field.

In one embodiment of the present specification, when the type of the cost data to be collected is a cost object type, the maintenance field information of the cost data to be collected includes any one or more of a cost center, a cost period, a business date, a cost object lot, a finished quantity, a production quantity, a waste quantity, and a quantity accuracy.

In one embodiment of the present specification, when the type of the cost data to be collected is a material consumption type, the maintenance field information of the cost data to be collected includes any one or more of a cost center, a cost period, a business date, a cost object lot, a fee item, a material lot, a material unit price, a material quantity, and a quantity accuracy.

In one embodiment of the present specification, when the type of the cost data to be collected is a cost element type, the maintenance field information of the cost data to be collected includes any one or more of a cost center, a cost period, a business date, a cost object batch, a cost item, a cost amount, and a number precision.

In one embodiment of the present specification, when the type of the cost data to be collected is a cost incentive type, the maintenance field information of the cost data to be collected includes any one or more of a cost center, a cost period, a business date, a cost object lot, a cost incentive, a finished consumption quantity, a manufactured consumption quantity, and a quantity accuracy.

Step S103, updating the field information to be maintained in the basic table and updating the association table information so as to realize data collection of the cost data.

In one embodiment of the present description, a data source corresponding to a maintenance field is determined according to a data source of cost data to be collected; and determining a data table corresponding to the maintenance field through the data source corresponding to the maintenance field, and performing access operation of the field in the data table.

In an embodiment of the present specification, a field access operation is performed in a corresponding data table to obtain an access field. Then, recording a number-taking field corresponding to the field information to be maintained in the basic table; and defining the data table where the access field is located as an association table according to the access field, and recording the name, association conditions and association modes of the association table to maintain and update the information of the association table.

In an embodiment of the present specification, the corresponding access fields of the source table of cost data are maintained, it should be noted that different types of fields to be maintained are different, and the associated table information also needs to be maintained. The source of the cost data often involves a plurality of data tables, and other association tables besides the basic table need to be maintained, including the names, association conditions and association modes of the association tables. And realizing data collection of the cost data by maintaining and updating the field information to be maintained and the associated table information.

When the data source of the cost data to be collected changes, the data collection under the scene that the data source changes is realized by maintaining the specific fields of the basic tables and the associated table information in the data tables, the collection efficiency of the cost data is greatly improved, the condition that the cost data source changes can be responded more quickly, and the work of project site implementers is more efficient.

Fig. 2 is a schematic flow chart of another cost data collection method provided in the embodiment of the present disclosure, which provides a comprehensive cost data source configuration function, greatly improves the collection efficiency of the cost data, and can quickly cope with a change of the cost data source, so that the work of project site implementers is more efficient. As shown in fig. 2, the method comprises the following steps:

first, cost data is obtained, the cost data aggregation tool provided in this embodiment is a data source definition function in the ERP system, as shown in fig. 3, fig. 3 is a data source interface schematic diagram of the cost data aggregation tool provided in this embodiment, and supports defining data sources of four cost data types, including cost objects, material consumption, cost elements, and cost factors.

In one implementation manner of the present specification, data may be entered manually, or may be quickly imported using an Excel file, so as to obtain cost data. Deactivation may also be selected for cost data source configurations that are no longer needed.

The second is cost data set definition, that is, defining the data source of the cost data set data. Adding a piece of data through adding operation in the interface, and inputting basic information configured by the data source, wherein the basic information comprises the type, the number, the name, a basic table (namely where the data source needs to be collected), remarks and constraint conditions of data search; wherein the types include: cost objects, material consumption, cost factors, and cost drivers, and the base table is used to represent the data source of the data that needs to be aggregated.

And then, maintaining corresponding access fields of the cost data source table, wherein the fields required to be maintained in different types are different. The fields to be maintained by the cost object type data include a cost center, a cost period, a business date, a cost object batch, a finished quantity, a production quantity, a waste quantity, and a quantity precision, as shown in fig. 4, fig. 4 is a schematic diagram of a fetch field maintenance interface of a cost object type provided in an embodiment of the present specification.

The fields of the material consumption type data to be maintained comprise a cost center, a cost period, a business date, a cost object batch, a expense item, a material batch, a material unit price, a material quantity and a quantity precision; the fields of the expense element type data to be maintained comprise a cost center, a cost period, a service date, a cost object batch, an expense item, an expense quantity, an expense amount and quantity precision; the fields of the cost cause type data to be maintained comprise a cost center, a cost period, a service date, a cost object batch, a cost cause, a finished consumption quantity, a manufacturing consumption quantity and a quantity precision;

and finally, maintaining the association table information. The source of the cost data often involves multiple data tables, requiring the maintenance of other associative tables in addition to the base table. As shown in fig. 5, fig. 5 is a schematic view of an association table information maintenance interface of a cost object type provided in an embodiment of this specification, where the association table information includes a name, an association condition, and an association manner of an association table.

After the content maintenance is completed, the method can be called to quickly and conveniently collect the cost data in the related data collecting function of the ERP cost management system. Fig. 6, 7, 8 and 9 are schematic interface displays of aggregation results of cost data of the cost object type, the material consumption type, the cost element type and the cost factor type by using the embodiment, respectively.

The embodiment of the present specification further provides a data aggregation device for cost data, as shown in fig. 10, the device includes:

at least one processor; and the number of the first and second groups,

a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the above-described method.

Embodiments of the present specification also provide a non-volatile computer storage medium storing computer-executable instructions configured to: when the data source of the cost data to be collected changes, determining a plurality of data tables corresponding to the cost data to be collected, wherein the data tables comprise a basic table and an association table; acquiring field information to be maintained in a basic table according to the type of the cost data to be collected; and updating the field information to be maintained in the basic table and updating the associated table information so as to realize data collection of the cost data.

The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the embodiments of the apparatus, the device, and the nonvolatile computer storage medium, since they are substantially similar to the embodiments of the method, the description is simple, and for the relevant points, reference may be made to the partial description of the embodiments of the method.

The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.

The above description is merely one or more embodiments of the present disclosure and is not intended to limit the present disclosure. Various modifications and alterations to one or more embodiments of the present description will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement or the like made within the spirit and principle of one or more embodiments of the present specification should be included in the scope of the claims of the present specification.

Claims (10)

1. A method of data aggregation of cost material, the method comprising:

when the data source of the cost data to be collected changes, determining a plurality of data tables corresponding to the cost data to be collected, wherein the data tables comprise a basic table and an association table;

acquiring field information to be maintained in the basic table according to the type of the cost data to be collected;

and updating the field information to be maintained in the basic table and updating the associated table information so as to realize data collection of the cost data.

2. The method of claim 1, wherein the types of cost data to be collected include: a cost object type, a material consumption type, a cost element type, and a cost cause type;

the determining, according to the type of the cost data to be collected, field information to be maintained in the base table specifically includes:

when the type of the cost data to be collected is the cost object type, the maintenance field information of the cost data to be collected comprises any one or more of a cost center, a cost period, a business date, a cost object batch, a finished quantity, a production quantity, a waste quantity and quantity precision;

when the type of the cost data to be collected is the material consumption type, the maintenance field information of the cost data to be collected comprises any one or more items of cost center, cost period, business date, cost object batch, expense item, material batch, material unit price, material quantity and quantity precision;

when the type of the cost data to be collected is the type of the cost element, the maintenance field information of the cost data to be collected comprises any one or more of a cost center, a cost period, a business date, a cost object batch, a cost item, a cost quantity, a cost amount and quantity precision;

when the type of the cost data to be collected is the cost cause type, the maintenance field information of the cost data to be collected comprises any one or more of a cost center, a cost period, a business date, a cost object batch, a cost cause, a finished consumption quantity, a manufacturing consumption quantity and quantity precision.

3. The method according to claim 1, wherein the base table is used to represent a data source of the cost data to be collected, and the association table is used to represent an associated data table of the cost data to be collected.

4. The method according to claim 1, wherein the field information to be maintained includes a data source corresponding to the field;

after the field information to be maintained in the basic table is obtained according to the type of the cost data to be collected, the method further includes:

determining a data source corresponding to the field according to the data source of the cost data to be collected;

and determining a data table corresponding to the field through a data source corresponding to the field, and acquiring the access field in the data table.

5. The method according to claim 4, wherein the updating the field information and the association table information to be maintained in the base table specifically comprises:

recording a data acquisition field corresponding to field information to be maintained in the basic table;

and defining the data table where the access field is located as an association table according to the access field, and recording the name, association condition and association mode of the association table.

6. The method according to claim 1, wherein before the obtaining the field information to be maintained in the base table according to the type of the cost data to be aggregated, the method further comprises:

presetting data characteristics corresponding to the types of the cost data, wherein the data characteristics corresponding to the types of the cost objects are first characteristics, the data characteristics corresponding to the types of the material consumption are second characteristics, the data characteristics corresponding to the types of the expense factors are third characteristics, and the data characteristics corresponding to the types of the cost factors are fourth characteristics;

calculating data characteristics of specified data in the cost data to be collected, and performing characteristic matching with the first characteristic, the second characteristic, the third characteristic and the fourth characteristic;

and determining the type of the cost data to which the specified data belongs according to the matching result.

7. The method of claim 1, wherein before determining the plurality of data tables corresponding to the cost data to be collected, the method further comprises:

storing initial data sources corresponding to the cost data to be collected in advance, defining paths of a plurality of data tables corresponding to the initial data sources as first access paths, and performing access operation through the first access paths;

acquiring a real-time data source corresponding to the cost data to be collected, and determining a second access path according to the real-time data source;

and when the first access path and the second access path are different, judging that the data source of the cost data to be collected changes.

8. The method of claim 7, wherein before determining the plurality of data tables corresponding to the cost data to be collected, the method further comprises:

and acquiring the cost data to be collected through the second access path.

9. A data aggregation apparatus for cost material, the apparatus comprising:

at least one processor; and the number of the first and second groups,

a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,

the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-8.

10. A non-transitory computer storage medium having stored thereon computer-executable instructions configured to:

when the data source of the cost data to be collected changes, determining a plurality of data tables corresponding to the cost data to be collected, wherein the data tables comprise a basic table and an association table;

acquiring field information to be maintained in the basic table according to the type of the cost data to be collected;

and updating the field information to be maintained in the basic table and updating the associated table information so as to realize data collection of the cost data.

Images