A method, device and medium for collecting data of cost information
By detecting changes in the cost data source to be collected in the ERP cost management system and updating the field information of multiple data tables, the problem that changes in the data source cause users to be unable to use the collection tool normally is solved, efficient data collection is achieved and the work efficiency of implementers is improved.
Patent Information
- Application Number
- CN202111354605.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-11-16
- Publication Date
- 2025-04-22
- Estimated Expiration
- 2041-11-16
AI Technical Summary
In the ERP cost management system, frequent changes in data sources make it impossible for users to use the collection tools normally. The existing technology requires developers to modify the code, resulting in reduced work efficiency of implementers.
By detecting changes in the cost data source to be collected, multiple data tables are determined, including basic tables and association tables, and obtaining the field information to be maintained according to the cost data type, and updating the basic table and association table information to achieve data collection.
It realizes efficient data collection in the data source change scenario, improves the efficiency of cost data collection, can respond to data source changes faster, and improves the work efficiency of project site implementation personnel.
Smart Images

Figure CN114037304B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a method, device and medium for collecting data of cost information. Background Art
[0002] Enterprise Resource Planning (ERP) refers to a management platform that is based on information technology and provides decision-making and operation means for enterprise decision-makers and employees with systematic management ideas. The ERP system supports mixed manufacturing environments such as discrete and process-based manufacturing environments. Its application range has expanded from manufacturing to retail, service, banking, telecommunications, government agencies, schools and other business sectors. It effectively integrates enterprise resources by integrating database technology, graphical user interface, fourth-generation query language, client-server structure, computer-aided development tools, and portable open systems.
[0003] When customers use the ERP cost management system, they need to collect the current cost object data, the number of materials consumed by the cost object, various expenses, and cost driver data at each time point such as the end of the period or the end of the year in order to perform actual cost accounting. In actual application scenarios, the data source corresponding to the data that needs to be collected often changes. When the data source changes, the existing technology requires developers to modify the code of the product function of the collection tool, but it takes time for developers to modify the code, which causes users to be unable to use the collection tool normally during this period. Summary of the invention
[0004] One or more embodiments of the present specification provide a method, device and medium for data collection of cost information, which are used to solve the following technical problems: In actual application scenarios, the data source corresponding to the data to be collected often changes, resulting in users being unable to use the collection tool normally.
[0005] One or more embodiments of this specification adopt the following technical solutions:
[0006] One or more embodiments of the present specification provide a method for data collection of cost data, the method comprising: when a data source of the cost data to be collected changes, determining multiple data tables corresponding to the cost data to be collected, wherein the data tables include a basic table and an associated table; according to the type of the cost data to be collected, obtaining field information to be maintained in the basic table; 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.
[0007] Furthermore, the types of cost data to be collected include: cost object type, material consumption type, expense element type and cost driver type; the field information to be maintained in the basic table is determined according to the type of cost data to be collected, specifically including: when the type of cost data to be collected is the cost object type, the maintenance field information of the cost data to be collected includes any one or more of cost center, cost period, business date, cost object, cost object batch, completed quantity, put into production quantity, scrap quantity and quantity accuracy; when the type of cost data to be collected is the material consumption type, the maintenance field information of the cost data to be collected includes any one or more of cost center, cost period, business date, cost object batch, completed quantity, put into production quantity, scrap quantity and quantity accuracy. any one or more of the following: object, cost object batch, expense item, material, material batch, material unit price, material quantity and quantity precision; when the type of the cost data to be collected is the expense element type, the maintenance field information of the cost data to be collected includes any one or more of the following: cost center, cost period, business date, cost object, cost object batch, expense item, expense quantity, expense amount and quantity precision; when the type of the cost data to be collected is the cost driver type, the maintenance field information of the cost data to be collected includes any one or more of the following: cost center, cost period, business date, cost object, cost object batch, cost driver, completed consumption quantity, work-in-progress consumption quantity and quantity precision.
[0008] Furthermore, the basic table is used to represent the data source of the cost data to be aggregated, and the associated table is used to represent the associated data table of the cost data to be aggregated.
[0009] Furthermore, the field information to be maintained includes the data source corresponding to the field; after obtaining the field information to be maintained in the basic table according to the type of the cost data to be collected, the method also includes: determining the data source corresponding to the field according to the data source of the cost data to be collected; determining the data table corresponding to the field through the data source corresponding to the field, and obtaining the access field in the data table.
[0010] Furthermore, updating the field information to be maintained and the associated table information in the basic table specifically includes: entering the retrieval field corresponding to the field information to be maintained in the basic table; defining the data table where the retrieval field is located as an associated table according to the retrieval field, and entering the associated table name, association condition and association method of the associated table.
[0011] Furthermore, before obtaining the field information to be maintained in the basic table according to the type of the cost data to be aggregated, the method also includes: presetting data features corresponding to the types of each cost data, wherein the data feature corresponding to the cost object type is the first feature, the data feature corresponding to the material consumption type is the second feature, the data feature corresponding to the expense element type is the third feature, and the data feature corresponding to the cost driver type is the fourth feature; calculating the data features of the specified data in the cost data to be aggregated, and performing feature matching with the first feature, the second feature, the third feature and the fourth feature; and determining the type of cost data to which the specified data belongs through the matching results.
[0012] Furthermore, before determining the multiple data tables corresponding to the cost data to be aggregated, the method also includes: pre-storing the initial data source corresponding to the cost data to be aggregated, defining the paths of the multiple data tables corresponding to the initial data source as a first data acquisition path, and performing data acquisition operations through the first data acquisition path; obtaining the real-time data source corresponding to the cost data to be aggregated, and determining a second data acquisition path based on the real-time data source; when the first data acquisition path and the second data acquisition path are different, determining that the data source of the cost data to be aggregated has changed.
[0013] Furthermore, before determining the multiple data tables corresponding to the cost data to be aggregated, the method further includes: acquiring the cost data to be aggregated through the second data acquisition path.
[0014] One or more embodiments of the present specification provide a cost data collection device, including:
[0015] at least one processor; and,
[0016] a memory communicatively connected to the at least one processor; wherein,
[0017] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the above method.
[0018] One or more embodiments of the present specification provide a non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to: when a data source of cost data to be aggregated changes, determine a plurality of data tables corresponding to the cost data to be aggregated, wherein the data tables include a basic table and an associated table; obtain field information to be maintained in the basic table according to the type of the cost data to be aggregated; update the field information to be maintained in the basic table, and update the associated table information, so as to realize data aggregation of the cost data.
[0019] At least one of the above technical solutions adopted in the embodiments of this specification can achieve the following beneficial effects:
[0020] When the data source of the cost information to be collected changes, data collection is achieved in scenarios where the data source changes by maintaining specific fields of the basic tables in multiple data tables and related table information. This greatly improves the efficiency of cost information collection and can respond more quickly to changes in the cost information source, making the work of project site implementation personnel more efficient. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] In order to more clearly illustrate the technical solutions in the embodiments of this specification or the prior art, the following briefly introduces the drawings required for use in the embodiments or the prior art description. Obviously, the drawings described below are only some embodiments recorded in this specification. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative labor. In the drawings:
[0022] Figure 1 A flowchart of a method for collecting cost data provided in an embodiment of this specification;
[0023] Figure 2 A flowchart of another method for collecting cost data provided in an embodiment of this specification;
[0024] Figure 3 A schematic diagram of a data source interface of a cost data collection tool provided in an embodiment of this specification;
[0025] Figure 4 A schematic diagram of a maintenance interface for obtaining a digital field of a cost object type provided in an embodiment of this specification;
[0026] Figure 5 A schematic diagram of an interface for maintaining association table information of a cost object type provided in an embodiment of this specification;
[0027] Figure 6 A schematic diagram of a cost object type aggregation result display interface provided in an embodiment of this specification;
[0028] Figure 7 A schematic diagram of a display interface for the collection results of a material consumption type provided in an embodiment of this specification;
[0029] Figure 8 A schematic diagram of a display interface for the aggregation results of a type of expense element provided in an embodiment of this specification;
[0030] Fig. 9A schematic diagram of a display interface for the aggregation results of a cost driver type provided in an embodiment of this specification;
[0031] Fig.10 A schematic diagram of the structure of a data collection device for cost information provided in an embodiment of this specification. DETAILED DESCRIPTION
[0032] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the drawings in the embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, not all of the embodiments. Based on the embodiments of this specification, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of this specification.
[0033] Enterprise Resource Planning (ERP) refers to a management platform that is based on information technology and uses systematic management ideas to provide decision-making and operation means for enterprise decision-makers and employees. The ERP system supports mixed manufacturing environments such as discrete and process-based manufacturing environments. Its application scope has expanded from manufacturing to retail, service, banking, telecommunications, government agencies, schools and other business sectors. It effectively integrates enterprise resources by integrating database technology, graphical user interface, fourth-generation query language, client-server structure, computer-aided development tools, and portable open systems. As the degree of enterprise informatization increases and the business handled by the ERP system becomes more and more complex, the frequency of changes in cost data sources increases, resulting in higher and higher project R&D costs and more difficult project on-site implementation.
[0034] When customers apply the ERP cost management system, they need to collect the current cost object data, the number of materials consumed by the cost objects, various expenses, and cost driver data at each time point such as the end of the period or the end of the year in order to perform actual cost accounting. When the data source that needs to be collected by the enterprise ERP cost management system changes at the end of the period, it will cause great trouble to the project implementation personnel. Developers need to modify the product functions to adapt to the company's latest cost data data source, and then upgrade the project site product to ensure the normal operation of the ERP cost management system. In other words, in actual application scenarios, the data source corresponding to the data that needs to be collected often changes, resulting in users being unable to use the collection tool normally. The existing technology requires developers to modify the code of the product function of the collection tool, but this method reduces the efficiency of the implementation personnel's project site work, which brings great trouble to the implementation personnel.
[0035] This specification embodiment provides a method for collecting cost data. Figure 1 The flowchart of a method for collecting cost data provided in the embodiment of the present specification is applied to a cost data collection system, and can also be applied to a cost data collection tool, such as Figure 1 As shown, it mainly includes the following steps:
[0036] Step S101, when the data source of the cost data to be aggregated changes, a plurality of data tables corresponding to the cost data to be aggregated are determined.
[0037] In one embodiment of the present specification, when the data source of the cost information that needs to be aggregated changes, the data source of the cost information that needs to be aggregated is determined. It should be noted that the cost information that needs to be aggregated can be referred to as the cost information to be aggregated. The source of the cost information data often involves multiple data tables. When determining the data source of the cost information to be aggregated, multiple data tables are determined. The multiple data tables are the data sources of the cost information that needs to be aggregated. For example, through the add operation in the interface, add a new piece of data and enter the basic information of the data source configuration. Including the type, number, name, basic table, remarks, and constraints for data search.
[0038] In one embodiment of the present specification, a data table includes a basic table and multiple associated tables. It should be noted that an associated table refers to the source of a certain item in the cost data to be collected, and an associated relationship is established between the associated table and the basic table through any field. For example, if the data to be collected is personal information, it is necessary to obtain household registration information from the civil affairs department and social security information from the social security bureau, and the household registration information and social security information are associated through the ID card number.
[0039] In one embodiment of the present specification, as the degree of informatization of enterprises becomes higher and higher and the business handled by the ERP system becomes more and more complex, the frequency of changes in the data source of cost information becomes higher and higher, and it is necessary to pre-judge whether the multiple data tables corresponding to the cost information to be collected have changed. The specific judgment method is as follows: First, the initial data source of the cost information to be collected is stored, and the data source path is defined as the first data acquisition path, where it should be noted that the first data acquisition path is used to obtain data from the data source. Afterwards, the real-time data source corresponding to the cost information to be collected is obtained, and the second data acquisition path is determined according to the real-time data source; when the first data acquisition path and the second data acquisition path are different, it is determined that the data source of the cost information to be collected has changed.
[0040] In one embodiment of the present specification, the initial data source includes a basic table and multiple related tables. The data retrieval path of the data source of the initial basic table can be defined as a first data retrieval path, and the data retrieval path of the data source of the real-time basic table can be defined as a second data retrieval path. If the first data retrieval path and the second data retrieval path are different, it is determined that the data source of the cost information to be collected has changed, and the cost information to be collected is obtained through the second data retrieval path.
[0041] In one embodiment of the present specification, if the first data acquisition path and the real-time data acquisition path are the same, the data acquisition path of the association table is further determined. Since the cost data to be collected may include multiple association tables, the data sources of multiple initial association tables are obtained as corresponding data acquisition paths, such as path A, path B, and path C. Multiple association tables corresponding to the cost data to be collected are obtained, the data acquisition path of each association table is determined, and compared with all the initial paths respectively. If there is no consistent path in the comparison result, it is determined that the data source of the cost data to be collected has changed.
[0042] Step S102, according to the type of cost data to be collected, obtain the field information to be maintained in the basic table.
[0043] In one embodiment of the present specification, the types of cost data to be collected include: cost object type, material consumption type, cost element type, and cost driver type.
[0044] In one embodiment of the present specification, it is necessary to determine the type of cost data to be collected. First, the data features corresponding to the types of various cost data are preset, wherein the data feature corresponding to the cost object type is the first feature, the data feature corresponding to the material consumption type is the second feature, the data feature corresponding to the cost element type is the third feature, and the data feature corresponding to the cost driver type is the fourth feature. It should be noted that the first feature can be a statement of the quantity type, such as: the completed quantity, the put into production quantity, and the scrap quantity; the second feature can be a statement of the material type, such as: material, material batch, material unit price, and material quantity; the third feature can be a statement of the cost type, such as: cost item, cost quantity, and cost amount; the fourth feature can be a related statement for determining the cost, such as cost driver, completed consumption quantity, and work-in-progress consumption quantity. Calculate the data features of the specified data in the cost data to be collected, and perform feature matching with the first feature, the second feature, the third feature, and the fourth feature. Finally, determine the type of cost data to which the specified data belongs through the matching results.
[0045] In one embodiment of the present specification, the field information to be maintained in the basic table is determined according to the type of cost data to be collected. It should be noted that the field information to be maintained includes the data source corresponding to the field.
[0046] In one embodiment of the present specification, when the type of 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 the cost center, cost period, business date, cost object, cost object batch, completed quantity, put into production quantity, scrap quantity and quantity accuracy.
[0047] In one embodiment of the present specification, when the type of 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 the cost center, cost period, business date, cost object, cost object batch, expense item, material, material batch, material unit price, material quantity and quantity accuracy.
[0048] In one embodiment of the present specification, when the type of cost data to be aggregated is a cost element type, the maintenance field information of the cost data to be aggregated includes any one or more of cost center, cost period, business date, cost object, cost object batch, cost item, cost quantity, cost amount and quantity accuracy.
[0049] In one embodiment of the present specification, when the type of cost data to be aggregated is a cost driver type, the maintenance field information of the cost data to be aggregated includes any one or more of the cost center, cost period, business date, cost object, cost object batch, cost driver, completed consumption quantity, work-in-progress consumption quantity, and quantity accuracy.
[0050] Step S103, updating the field information to be maintained in the basic table, and updating the associated table information, so as to realize the data collection of the cost information.
[0051] In one embodiment of the present specification, the data source corresponding to the maintenance field is determined according to the data source of the cost information to be collected; the data table corresponding to the maintenance field is determined by the data source corresponding to the maintenance field, and the field data acquisition operation is performed in the data table.
[0052] In one embodiment of the present specification, a field fetching operation is performed in a corresponding data table to obtain a fetching field. Afterwards, the fetching field corresponding to the field information to be maintained is entered in the basic table; based on the fetching field, the data table where the fetching field is located is defined as an associated table, and the associated table name, associated condition and associated method of the associated table are entered to maintain and update the associated table information.
[0053] In one embodiment of the present specification, the corresponding numerical fields of the cost data source table are maintained. It should be noted that different types of fields need to be maintained differently, and the associated table information also needs to be maintained. The source of cost data often involves multiple data tables, and other associated tables other than the basic table need to be maintained, including the name of the associated table, the associated condition, and the associated method. By maintaining and updating the field information to be maintained and the associated table information, the data collection of cost data is realized.
[0054] When the data source of the cost information to be collected changes, data collection is achieved in scenarios where the data source changes by maintaining specific fields of the basic tables in multiple data tables and related table information. This greatly improves the efficiency of cost information collection and can respond more quickly to changes in the cost information source, making the work of project site implementation personnel more efficient.
[0055] Figure 2 The flowchart of another method for collecting cost data provided in the embodiment of this specification provides a comprehensive cost data source configuration function, which greatly improves the efficiency of collecting cost data, can more quickly respond to changes in the cost data source, and makes the work of project site implementation personnel more efficient. Figure 2 As shown, the following methods are included:
[0056] First, obtain cost information data. The cost information data collection tool provided in this embodiment is a data source definition function in the ERP system, such as Figure 3 As shown, Figure 3 A schematic diagram of a data source interface of a cost data collection tool provided in an embodiment of this specification supports the definition of four types of cost data sources, including cost objects, material consumption, expense elements, and cost drivers.
[0057] In one implementation of the specification, the cost information data can be obtained by manually entering data or quickly importing data using Excel files. For cost information data source configurations that are no longer needed, you can also choose to deactivate them.
[0058] The second step is to define the cost data collection, that is, to define the data source of the cost data collection data. Through the "Add" operation in the interface, you can add a new data and enter the basic information of the data source configuration, including the type, number, name, basic table (that is, where the data to be collected comes from), remarks, and constraints for data search; among which, the types include: cost objects, material consumption, cost elements, and cost drivers, and the basic table is used to indicate the data source of the data to be collected.
[0059] After that, maintain the corresponding data source table of the cost data. Different types of data require different fields to be maintained. The fields that need to be maintained for cost object type data include cost center, cost period, business date, cost object, cost object batch, completed quantity, put into production quantity, scrap quantity, quantity accuracy, such as Figure 4 As shown, Figure 4 A schematic diagram of a maintenance interface for obtaining a number field of a cost object type provided in an embodiment of this specification.
[0060] The fields that need to be maintained for material consumption type data include cost center, cost period, business date, cost object, cost object batch, expense item, material, material batch, material unit price, material quantity, and quantity precision; the fields that need to be maintained for expense element type data include cost center, cost period, business date, cost object, cost object batch, expense item, expense quantity, expense amount, and quantity precision; the fields that need to be maintained for cost driver type data include cost center, cost period, business date, cost object, cost object batch, cost driver, completed consumption quantity, work-in-progress consumption quantity, and quantity precision;
[0061] Finally, maintain the related table information. The source of cost information data often involves multiple data tables, and it is necessary to maintain other related tables in addition to the basic table. Figure 5 As shown, Figure 5 This is a schematic diagram of an interface for maintaining association table information of a cost object type provided in an embodiment of this specification. The association table information includes the name of the association table, association conditions, and association methods.
[0062] After completing the above content maintenance, you can call this method in the relevant data collection function of the ERP cost management system to quickly and conveniently collect cost information data. Figure 6 , Figure 7 , Figure 8 and Fig. 9 They are schematic diagrams showing the interface of the results of aggregating cost data of cost object type, material consumption type, expense element type and cost driver type using this embodiment.
[0063] The embodiment of this specification also provides a data collection device for cost information, such as Fig.10 As shown, the device includes:
[0064] at least one processor; and,
[0065] a memory communicatively connected to the at least one processor; wherein,
[0066] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the above method.
[0067] The embodiments of the present specification also provide a non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to: when a data source of the cost data to be aggregated changes, determine a plurality of data tables corresponding to the cost data to be aggregated, wherein the data tables include a basic table and an associated table; obtain field information to be maintained in the basic table according to the type of the cost data to be aggregated; update the field information to be maintained in the basic table, and update the associated table information, so as to realize data aggregation of the cost data.
[0068] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment, and non-volatile computer storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0069] The above is a description of a specific embodiment of the specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0070] The above description is only one or more embodiments of this specification and is not intended to limit this specification. For those skilled in the art, one or more embodiments of this specification may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of one or more embodiments of this specification shall be included in the scope of the claims of this specification.
Claims
1. A method for collecting cost data, characterized in that: The method comprises: When the data source of the cost data to be collected changes, multiple data tables corresponding to the cost data to be collected are determined, wherein the data tables include basic tables and associated tables; According to the type of the cost data to be collected, obtaining the field information to be maintained in the basic table; Updating the field information to be maintained in the basic table and updating the associated table information to realize data collection of the cost information; The field information to be maintained includes the data source corresponding to the field; After obtaining the field information to be maintained in the basic table according to the type of the cost data to be collected, the following steps are also included: According to the data source of the cost data to be collected, determine the data source corresponding to the field; Determine the data table corresponding to the field through the data source corresponding to the field, and obtain the number field in the data table; The updating of the field information to be maintained and the associated table information in the basic table specifically includes: In the basic table, enter the number field corresponding to the field information to be maintained; According to the number field, the data table where the number field is located is defined as an association table, and the association table name, association condition and association method of the association table are entered.
2. A method for collecting cost data according to claim 1, characterized in that: The types of cost data to be collected include: cost object type, material consumption type, cost element type and cost driver type; Determining the field information to be maintained in the basic table according to the type of the cost data to be collected 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 includes any one or more of cost center, cost period, business date, cost object, cost object batch, completed quantity, put into production quantity, scrap quantity and quantity accuracy; 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 includes any one or more of cost center, cost period, business date, cost object, cost object batch, expense item, material, material batch, material unit price, material quantity and quantity accuracy; When the type of the cost data to be collected is the expense element type, the maintenance field information of the cost data to be collected includes any one or more of cost center, cost period, business date, cost object, cost object batch, expense item, expense quantity, expense amount and quantity precision; When the type of the cost data to be collected is the cost driver type, the maintenance field information of the cost data to be collected includes any one or more of the cost center, cost period, business date, cost object, cost object batch, cost driver, completed consumption quantity, work-in-progress consumption quantity and quantity accuracy.
3. The method for collecting cost data according to claim 1, characterized in that: The basic table is used to represent the data source of the cost data to be aggregated, and the associated table is used to represent the associated data table of the cost data to be aggregated.
4. The method for collecting cost data according to claim 1, characterized in that: Before obtaining the field information to be maintained in the basic table according to the type of the cost data to be collected, the method further includes: Preset the data features corresponding to the types of various cost data, among which the data feature corresponding to the cost object type is the first feature, the data feature corresponding to the material consumption type is the second feature, the data feature corresponding to the expense element type is the third feature, and the data feature corresponding to the cost driver type is the fourth feature; Calculating data features of designated data in the cost information to be collected, and performing feature matching with the first feature, the second feature, the third feature, and the fourth feature; The type of cost information to which the designated data belongs is determined through the matching result.
5. The method for collecting cost data according to claim 1, characterized in that: Before determining the multiple data tables corresponding to the cost data to be collected, the method further includes: Pre-storing the initial data source corresponding to the cost data to be collected, defining the paths of multiple data tables corresponding to the initial data source as a first data retrieval path, and performing data retrieval operations through the first data retrieval path; Acquire a real-time data source corresponding to the cost data to be collected, and determine a second data acquisition path according to the real-time data source; When the first data acquisition path and the second data acquisition path are different, it is determined that the data source of the cost information to be collected has changed.
6. A method for collecting cost data according to claim 5, characterized in that: Before determining the multiple data tables corresponding to the cost data to be collected, the method further includes: The cost data to be collected is obtained through the second data acquisition path.
7. A data collection device for cost information, characterized in that: The device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 6.
8. A non-volatile computer storage medium, characterized in that: A computer executable instruction is stored, wherein the computer executable instruction is configured to: When the data source of the cost data to be collected changes, multiple data tables corresponding to the cost data to be collected are determined, wherein the data tables include basic tables and associated tables; According to the type of the cost data to be collected, obtaining the field information to be maintained in the basic table; Updating the field information to be maintained in the basic table and updating the associated table information to realize data collection of the cost information; The field information to be maintained includes the data source corresponding to the field; After obtaining the field information to be maintained in the basic table according to the type of the cost data to be collected, the following steps are also included: According to the data source of the cost data to be collected, determine the data source corresponding to the field; Determine the data table corresponding to the field through the data source corresponding to the field, and obtain the number field in the data table; The updating of the field information to be maintained and the associated table information in the basic table specifically includes: In the basic table, enter the number field corresponding to the field information to be maintained; According to the number field, the data table where the number field is located is defined as an association table, and the association table name, association condition and association method of the association table are entered.
Citation Information
Patent Citations
Electronic device, data table data extraction method and storage medium
CN107870979A