Accounting data conversion method, device and electronic equipment
By establishing tree structure mapping rules between different financial systems, the automatic conversion of accounting data is solved, and efficient data conversion is achieved.
Patent Information
- Application Number
- CN202111493559.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-08
- Publication Date
- 2025-08-15
- Estimated Expiration
- 2041-12-08
AI Technical Summary
In the prior art, accounting data conversion is inefficient, requires a large amount of human resources and is inefficient.
By extracting the attribute information of accounting data in the first system, establishing a tree structure, and mapping the leaf node data into the tree structure of the second system according to the mapping rules, automatic conversion of accounting data is realized.
It improves the efficiency of accounting data conversion, reduces manual operation steps, and improves the degree of automation of data conversion.
Smart Images

Figure CN114140232B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing, and in particular to an accounting data conversion method, device and electronic equipment. Background Art
[0002] Currently, due to differing system standards, banks require data conversion before performing financial operations such as reconciliation between two systems. Typically, this conversion requires manual effort for each accounting item. This massive amount of financial data requires significant human resources to implement, and conversion efficiency is low.
[0003] Therefore, the existing technology has the problem of low efficiency in accounting data conversion. Summary of the Invention
[0004] The present application provides an accounting data conversion method, device and electronic equipment to solve the problem of low accounting data conversion efficiency in the prior art.
[0005] An accounting data conversion method, the method comprising:
[0006] Extracting first accounting data in the first system and determining attribute information of the first accounting data; wherein the attribute information indicates the subject name corresponding to the first accounting data and the hierarchical structure relationship of the subject name;
[0007] According to the attribute information, a first tree structure is set for the first accounting data; wherein, in the first tree structure, leaf node data corresponds to data of the bottom-level account; and the account corresponding to the root node data includes at least one level of subordinate accounts;
[0008] According to a mapping rule, any leaf node data in the first tree structure is saved to a corresponding node in a second tree structure formed based on a hierarchical structure relationship in the second system; wherein the mapping rule indicates a correspondence between attribute information of at least one first node included in a path from any leaf node data to root node data in the first tree structure and attribute information of a second node; the attribute information of the second node is attribute information of at least one accounting data included in a path from any leaf node data to root node data in the second tree structure; the first system and the second system are two independent financial systems;
[0009] Based on the second tree structure, second accounting data is determined.
[0010] The method provided in the above-mentioned embodiment of the present application maps all leaf node data in the first tree structure to corresponding nodes in the second tree structure through mapping rules, and determines all second accounting data based on the attribute information of the second accounting data and the second tree structure, thereby achieving the purpose of improving the efficiency of accounting data conversion.
[0011] In one possible implementation, before setting the first tree structure for the first accounting data according to the attribute information, the method includes:
[0012] dividing the first accounting data according to business types;
[0013] Then, setting a first tree structure for the first accounting data according to the attribute information includes:
[0014] According to the business type, at least one first tree structure is set for the first accounting data; wherein the at least one first tree structure corresponds to the business type one by one.
[0015] By respectively setting the first accounting data of different business types into the first tree structure, the conversion efficiency of the accounting data can be further improved.
[0016] In a possible implementation manner, the subject name corresponding to the first accounting data includes a main entry and a sub-entry; wherein the main entry indicates that the accounting data is a first-level subject name; and the sub-entry indicates the name of the accounting data corresponding to each subject under the first-level subject.
[0017] In one possible implementation, the step of storing any leaf node data in the first tree structure before the corresponding node in the second tree structure formed based on the hierarchical structure relationship in the second system according to the mapping rule includes:
[0018] Extracting at least one first node included in a path from any leaf node data to root node data in the first tree structure, and determining attribute information of the at least one first node;
[0019] Determining a corresponding position of the at least one first node in the second tree structure according to a second system standard, and determining attribute information of a second node corresponding to the accounting data at the corresponding position;
[0020] The corresponding relationship between the attribute information of the first node and the attribute information of the second node is recorded to generate the mapping rule.
[0021] In one possible implementation, the second accounting data includes the second accounting data value and the second accounting subject name corresponding to the second accounting data value; then determining the second accounting data based on the second tree structure includes:
[0022] In the second tree structure, the data of all nodes in the next level below each node are added together to obtain the second accounting data value corresponding to any node;
[0023] Based on the second tree structure, the second accounting subject name corresponding to the second accounting data value is determined.
[0024] In one possible implementation, the mapping rules include the correspondence between the account number in the second system corresponding to any accounting data and the account number in the first system, and the correspondence between the account name in the second system and the account name in the first system; wherein the account number indicates the hierarchical structure relationship of the account name.
[0025] In a second aspect, the present application provides an accounting data conversion device, the device comprising:
[0026] Extraction unit: used to extract first accounting data from the first system and determine attribute information of the first accounting data; wherein the attribute information indicates the subject name corresponding to the first accounting data and the hierarchical structure relationship of the subject name;
[0027] A setting unit is configured to set a first tree structure for the first accounting data according to the attribute information; wherein, in the first tree structure, leaf node data corresponds to data of the bottom-level account; and the account corresponding to the root node data includes at least one level of subordinate accounts;
[0028] A mapping unit: configured to save, according to a mapping rule, any leaf node data in the first tree structure to a corresponding node in a second tree structure formed based on a hierarchical structure relationship in the second system; wherein the mapping rule indicates a correspondence between attribute information of at least one first node included in a path from any leaf node data to root node data in the first tree structure and attribute information of a second node; the attribute information of the second node is attribute information of at least one accounting data included in a path from any leaf node data to root node data in the second tree structure; the first system and the second system are two independent financial systems;
[0029] Determining unit: used for determining the second accounting data based on the second tree structure.
[0030] In one possible implementation, the device further includes a division unit, specifically used to divide the first accounting data according to business type; the setting unit is specifically used to set at least one first tree structure for the first accounting data according to the business type; wherein the at least one first tree structure corresponds one-to-one to the business type.
[0031] In a possible implementation manner, the subject name corresponding to the first accounting data includes a main entry and a sub-entry; wherein the main entry indicates that the accounting data is a first-level subject name; and the sub-entry indicates the name of the accounting data corresponding to each subject under the first-level subject.
[0032] In one possible implementation, the device further includes a generation unit, which is specifically used to extract at least one first node included in the path from any leaf node data to the root node data in the first tree structure, and determine the attribute information of the at least one first node; determine the corresponding position of the at least one first node in the second tree structure according to the second system standard, and determine the attribute information of the second node corresponding to the accounting data at the corresponding position; record the correspondence between the attribute information of the first node and the attribute information of the second node, and generate the mapping rule.
[0033] In one possible implementation, the determination unit is specifically used to add up all node data of the next level of each node in the second tree structure to obtain the second accounting data value corresponding to any node; and based on the second tree structure, determine the second accounting subject name corresponding to the second accounting data value.
[0034] In one possible implementation, the mapping rules include the correspondence between the account number in the second system corresponding to any accounting data and the account number in the first system, and the correspondence between the account name in the second system and the account name in the first system; wherein the account number indicates the hierarchical structure relationship of the account name.
[0035] In a third aspect, the present application provides an electronic device, comprising:
[0036] Memory for storing computer programs;
[0037] The processor is configured to execute the computer program stored in the memory to implement the method steps described in the first aspect and any possible implementation manner.
[0038] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method described in the first aspect and any possible implementation manner is implemented.
[0039] In a fifth aspect, the present application provides a computer program product, which, when executed on a computer, enables the computer to execute the method described in the first aspect and any possible implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1A flowchart of an accounting data conversion method provided for this application;
[0041] Figure 2 A schematic diagram of a first tree structure provided in this application;
[0042] Figure 3 A schematic diagram of the structure of an accounting data conversion device provided in this application;
[0043] Figure 4 The following is a structural diagram of an accounting data conversion electronic device provided by me. DETAILED DESCRIPTION
[0044] To address the aforementioned low efficiency of accounting data conversion, this application proposes an accounting data conversion method: based on the hierarchical structure of accounting data, the accounting data and its attribute information are represented by a tree structure. Based on the mapping rules of the tree data structures in the two different systems, the conversion of leaf node data in either system is completed, and the conversion of other node data is completed based on the leaf node data, thereby avoiding the manual conversion steps required one by one, thereby achieving the purpose of improving accounting data conversion efficiency. In this application, tree data structures are collectively referred to as tree structures.
[0045] It should be noted that the acquisition, storage, use, and processing of data in the technical solution of this application comply with the relevant provisions of national laws and regulations.
[0046] In order to better understand the above technical solution, the technical solution of the present application is described in detail below through the accompanying drawings and specific embodiments. It should be understood that the embodiments of the present application and the specific features in the embodiments are detailed descriptions of the technical solution of the present application, rather than limitations on the technical solution of the present application. In the absence of conflict, the embodiments of the present application and the technical features in the embodiments can be combined with each other.
[0047] Please refer to Figure 1 The present invention provides a method for converting accounting data to improve the efficiency of accounting data conversion. The method specifically includes the following implementation steps:
[0048] Step 101: extracting first accounting data in a first system and determining attribute information of the first accounting data.
[0049] The attribute information indicates the subject name corresponding to the first accounting data and the hierarchical structure relationship of the subject name.
[0050] Specifically, the account names corresponding to the first accounting data include primary entries and secondary entries. The primary entry indicates that the accounting data is a first-level account name; the secondary entry indicates the name of the accounting data corresponding to each account under the first-level account. For example, the accounting account is Financial Assets - Investment Product Classification - Listing and Circulation Status - Accounting Classification, where Financial Assets is the primary entry; Investment Product Classification, Listing and Circulation Status, and Accounting Classification are secondary entries. The corresponding hierarchical structure relationship is: Financial Assets is the top level, and the sub-levels are Investment Product Classification, Investment Product Classification, Listing and Circulation Status, and Accounting Classification.
[0051] Step 102: According to the attribute information, a first tree structure is set for the first accounting data.
[0052] Among them, in the first tree structure, the leaf node data corresponds to the data of the lowest level subject; the subject corresponding to the root node data includes at least one level of subordinate subjects.
[0053] Specifically, before setting the first tree structure, the first accounting data may be pre-processed by dividing the first accounting data according to business types. Then, the first tree structure may be set according to the business types, with one business type corresponding to one tree structure.
[0054] The following is an example of setting up the first tree structure. Table 1 is the first accounting data of a certain business type.
[0055] Table 1
[0056]
[0057]
[0058] Now set up a first tree structure for the first accounting data in Table 1, such as Figure 2 shown.
[0059] like Figure 2 As shown, the node where the manufacturing cost is located is the root node of the first tree structure, and the production staff wages, production staff benefits, equipment repair costs, fuel consumption, repair costs and insurance premiums are the leaf nodes of the first tree structure. Figure 2 The first tree structure in the diagram omits the accounting data values corresponding to each node. Note that the accounting data value of each parent node is the sum of the accounting data values of all its child nodes. For example, if the child nodes for vehicle #30768's transportation fee are fuel consumption, repair costs, and insurance costs, the accounting data value corresponding to vehicle #30768's transportation fee, i.e., transportation costs, is the sum of fuel consumption, repair costs, and insurance costs.
[0060] Step 103: According to the mapping rule, data of any leaf node in the first tree structure is saved to a corresponding node in the second tree structure formed based on the hierarchical structure relationship in the second system.
[0061] In which, the mapping rule indicates the correspondence between the attribute information of at least one first node included in the path from any leaf node data to the root node data in the first tree structure and the attribute information of the second node; the attribute information of the second node is the attribute information of at least one accounting data included in the path from any leaf node data to the root node data in the second tree structure; the first system and the second system are two independent financial systems.
[0062] Specifically, an embodiment of the present application provides a method for generating mapping rules: first, extract at least one first node included in the path from any leaf node data to the root node data in the first tree structure, and determine the attribute information of the at least one first node. Then, according to the second system standard, determine the corresponding position of the at least one first node in the second tree structure, and determine the attribute information of the second node corresponding to the accounting data at the corresponding position. Finally, record the correspondence between the attribute information of the first node and the attribute information of the second node to generate the mapping rule. The mapping rule includes the correspondence between the account number in the second system corresponding to any accounting data and the account number in the first system, and the correspondence between the account name in the second system and the account name in the first system; wherein, the account number indicates the hierarchical structure relationship of the account name.
[0063] After the mapping rules are generated, the leaf nodes of the first tree structure can be mapped to corresponding positions in the second tree structure, and the attribute information at the corresponding positions can be determined based on the second tree structure.
[0064] Step 104: Determine second accounting data based on the second tree structure.
[0065] Specifically, in a tree structure, the root node data value is the sum of all leaf node data values. In this embodiment, the second accounting data includes the second accounting data value and the second accounting subject name corresponding to the second accounting data value. The second accounting data value can be obtained by summing the data of all nodes below each node in the second tree structure. Furthermore, based on the second tree structure, the second accounting subject name corresponding to the second accounting data value can be determined. For example, an accounting data report or a balance sheet can be used.
[0066] Based on the same inventive concept, an accounting data conversion device is provided in the embodiment of the present application. Figure 1The accounting data conversion method shown in FIG. 1 corresponds to the method for converting accounting data. The specific implementation of the device can be found in the description of the aforementioned method embodiment. The repeated parts will not be repeated here. Figure 3 , the device comprises:
[0067] Extraction unit 301: used to extract first accounting data in the first system and determine attribute information of the first accounting data.
[0068] The attribute information indicates the subject name corresponding to the first accounting data and the hierarchical structure relationship of the subject name.
[0069] Specifically, the subject name corresponding to the first accounting data includes a main entry and a sub-entry; wherein the main entry indicates that the accounting data is a first-level subject name; and the sub-entry indicates the name of the accounting data corresponding to each subject under the first-level subject.
[0070] Setting unit 302: configured to set a first tree structure for the first accounting data according to the attribute information.
[0071] Wherein, in the first tree structure, the leaf node data corresponds to the data of the lowest level subject; the subject corresponding to the root node data includes at least one level of subordinate subjects;
[0072] The accounting data conversion device also includes a division unit, which is specifically used to divide the first accounting data according to business type; the setting unit 302 is specifically used to set at least one first tree structure for the first accounting data according to the business type; wherein, the at least one first tree structure corresponds one-to-one to the business type.
[0073] Mapping unit 303: used for saving any leaf node data in the first tree structure to a corresponding node in the second tree structure formed based on the hierarchical structure relationship in the second system according to a mapping rule.
[0074] In which, the mapping rule indicates the correspondence between the attribute information of at least one first node included in the path from any leaf node data to the root node data in the first tree structure and the attribute information of the second node; the attribute information of the second node is the attribute information of at least one accounting data included in the path from any leaf node data to the root node data in the second tree structure; the first system and the second system are two independent financial systems.
[0075] Determining unit 304: configured to determine second accounting data based on the second tree structure.
[0076] Specifically, in the second tree structure, all node data of the next level of each node are added together to obtain the second accounting data value corresponding to any node; based on the second tree structure, the second accounting subject name corresponding to the second accounting data value is determined.
[0077] The accounting data conversion device also includes a generation unit, which is specifically used to extract at least one first node included in the path from any leaf node data to the root node data in the first tree structure, and determine the attribute information of the at least one first node; determine the corresponding position of the at least one first node in the second tree structure according to the second system standard, and determine the attribute information of the second node corresponding to the accounting data at the corresponding position; record the correspondence between the attribute information of the first node and the attribute information of the second node, and generate the mapping rule.
[0078] Specifically, the mapping rules include the correspondence between the account number in the second system corresponding to any accounting data and the account number in the first system, and the correspondence between the account name in the second system and the account name in the first system; wherein, the account number indicates the hierarchical structure relationship of the account name.
[0079] Based on the same inventive concept as the above accounting data conversion method, an electronic device is also provided in the embodiment of the present application. The electronic device can realize the functions of the above accounting data conversion method. Figure 4 , the electronic device includes:
[0080] At least one processor 401, and a memory 402 connected to the at least one processor 401. The specific connection medium between the processor 401 and the memory 402 is not limited in the embodiment of the present application. Figure 4 In the example, the processor 401 and the memory 402 are connected via a bus 400. Figure 4 The bus 400 can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 4 The diagram is represented by only one thick line, but this does not mean that there is only one bus or one type of bus. Alternatively, the processor 401 may also be referred to as a controller, without limitation to the name.
[0081] In the embodiment of the present application, the memory 402 stores instructions that can be executed by at least one processor 401. The at least one processor 401 can execute the accounting data conversion method discussed above by executing the instructions stored in the memory 402. The processor 401 can implement Figure 3 The functions of each module in the device shown.
[0082] Among them, the processor 401 is the control center of the device, which can use various interfaces and lines to connect the various parts of the entire control device, and monitor the device as a whole by running or executing instructions stored in the memory 402 and calling data stored in the memory 402, the various functions of the device and processing data.
[0083] In one possible design, processor 401 may include one or more processing units. Processor 401 may integrate an application processor and a modem processor. The application processor primarily processes the operating system, user interface, and application programs, while the modem processor primarily handles wireless communications. It is understood that the modem processor may not be integrated into processor 401. In some embodiments, processor 401 and memory 402 may be implemented on the same chip. In some embodiments, they may also be implemented on separate chips.
[0084] The processor 401 can be a general-purpose processor, such as a central processing unit (CPU), a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, or a discrete hardware component, and can implement or execute the various methods, steps, and logic block diagrams disclosed in the embodiments of the present application. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the accounting data conversion method disclosed in the embodiments of the present application can be directly embodied as being executed by a hardware processor, or can be executed by a combination of hardware and software modules in the processor.
[0085] The memory 402 is a non-volatile computer-readable storage medium that can be used to store non-volatile software programs, non-volatile computer executable programs and modules. The memory 402 may include at least one type of storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory, a random access memory (Random Access Memory, RAM), a static random access memory (Static Random Access Memory, SRAM), a programmable read-only memory (Programmable Read Only Memory, PROM), a read-only memory (Read Only Memory, ROM), an electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), a magnetic memory, a disk, an optical disk, etc. The memory 402 is any other medium that can be used to carry or store a desired program code in the form of an instruction or data structure and can be accessed by a computer, but is not limited thereto. The memory 402 in the embodiment of the present application can also be a circuit or any other device that can realize a storage function, for storing program instructions and / or data.
[0086] By designing and programming the processor 401, the code corresponding to the accounting data conversion method described in the above embodiment can be fixed into the chip, so that the chip can execute the accounting data conversion method when it is running. Figure 1 The steps of the accounting data conversion method of the embodiment shown are as follows: How to design and program the processor 401 is a technique well known to those skilled in the art and will not be described in detail here.
[0087] Based on the same inventive concept, an embodiment of the present application also provides a storage medium, which stores computer instructions. When the computer instructions are executed on a computer, the computer executes the accounting data conversion method discussed above.
[0088] In some possible implementations, various aspects of the accounting data conversion method provided in the present application can also be implemented in the form of a program product, which includes program code. When the program product is run on an apparatus, the program code is used to enable the control device to execute the steps of the accounting data conversion method according to various exemplary embodiments of the present application described above in this specification.
[0089] The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium may be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or component, or any combination thereof. More specific examples of readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0090] The program product of the accounting data conversion method provided in embodiments of the present invention may be a portable compact disc read-only memory (CD-ROM) and include program code, and may be run on a computing device. However, the program product of the present invention is not limited thereto. In this document, a readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
[0091] A readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, which carries readable program code. Such propagated data signals may take a variety of forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination thereof. A readable signal medium may also be any readable medium other than a readable storage medium that can transmit, propagate, or transfer a program for use by or in conjunction with an instruction execution system, apparatus, or device.
[0092] Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
[0093] The program code for performing the operations of the present invention may be written in any combination of one or more programming languages, including object-oriented programming languages such as Java, C++, and the like, as well as conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user computing device, partially on the user device, as a stand-alone software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server. In cases involving a remote computing device, the remote computing device may be connected to the user computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (e.g., via the Internet using an Internet service provider).
[0094] It should be noted that although several units or subunits of the device are mentioned in the above detailed description, this division is merely exemplary and not mandatory. In fact, according to embodiments of the present invention, the features and functions of two or more units described above may be embodied in a single unit. Conversely, the features and functions of a single unit described above may be further divided and embodied by multiple units.
[0095] Furthermore, although the operations of the method of the present invention are described in a particular order in the accompanying drawings, this does not require or imply that these operations must be performed in this particular order, or that all illustrated operations must be performed to achieve the desired results. Additionally or alternatively, some steps may be omitted, multiple steps may be combined into one step, and / or one step may be decomposed into multiple steps.
[0096] Those skilled in the art will appreciate that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.
[0097] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the steps in the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0098] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.
[0099] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.
[0100] Obviously, those skilled in the art may make various changes and modifications to this application without departing from the spirit and scope of this application. Thus, if these modifications and variations of this application fall within the scope of the claims of this application and their equivalents, this application is intended to include these modifications and variations.
Claims
1. An accounting data conversion method, characterized in that: The method comprises: Extracting first accounting data in the first system and determining attribute information of the first accounting data; wherein the attribute information indicates the subject name corresponding to the first accounting data and the hierarchical structure relationship of the subject name; According to the attribute information, a first tree structure is set for the first accounting data; wherein, in the first tree structure, leaf node data corresponds to data of the bottom-level account; and the account corresponding to the root node data includes at least one level of subordinate accounts; Extracting at least one first node included in a path from any leaf node data to root node data in the first tree structure, and determining attribute information of the at least one first node; Determining, based on the second system standard, a corresponding position of the at least one first node in a second tree structure formed based on a hierarchical structure relationship in the second system, and determining attribute information of a second node corresponding to the accounting data at the corresponding position; wherein the attribute information of the second node is attribute information of at least one accounting data included in a path from any leaf node data to root node data in the second tree structure; the first system and the second system are two independent financial systems; Recording the correspondence between the attribute information of the first node and the attribute information of the second node, and generating a mapping rule; wherein the mapping rule includes the correspondence between the account number in the second system corresponding to any accounting data and the account number in the first system, and the correspondence between the account name in the second system and the account name in the first system; the account number indicates the hierarchical structure relationship of the account name; According to the mapping rule, saving any leaf node data in the first tree structure to a corresponding node in the second tree structure; In the second tree structure, all node data of the next level below each node are added together to obtain the second accounting data value corresponding to any node; Based on the second tree structure, a second accounting subject name corresponding to the second accounting data value is determined.
2. The method according to claim 1, wherein Before setting the first tree structure for the first accounting data according to the attribute information, the method includes: dividing the first accounting data according to business types; Then, setting a first tree structure for the first accounting data according to the attribute information includes: According to the business type, at least one first tree structure is set for the first accounting data; wherein the at least one first tree structure corresponds to the business type one by one.
3. The method according to claim 2, wherein The subject name corresponding to the first accounting data includes a main entry and a sub-entry; wherein the main entry indicates that the accounting data is a first-level subject name; and the sub-entry indicates the name of the accounting data corresponding to each subject under the first-level subject.
4. An accounting data conversion device, characterized in that: The device comprises: Extraction unit: used to extract first accounting data from the first system and determine attribute information of the first accounting data; wherein the attribute information indicates the subject name corresponding to the first accounting data and the hierarchical structure relationship of the subject name; A setting unit is configured to set a first tree structure for the first accounting data according to the attribute information; wherein, in the first tree structure, leaf node data corresponds to data of the bottom-level account; and the account corresponding to the root node data includes at least one level of subordinate accounts; A generation unit: configured to extract at least one first node included in a path from any leaf node data to root node data in the first tree structure, and determine attribute information of the at least one first node; determine, according to a second system standard, a corresponding position of the at least one first node in a second tree structure formed based on a hierarchical structure relationship in the second system, and determine attribute information of a second node corresponding to the accounting data at the corresponding position; record the correspondence between the attribute information of the first node and the attribute information of the second node, and generate a mapping rule; wherein the attribute information of the second node is attribute information of at least one accounting data included in a path from any leaf node data to root node data in the second tree structure; the first system and the second system are two independent financial systems; the mapping rule includes the correspondence between the account number in the second system corresponding to any accounting data and the account number in the first system, and the correspondence between the account name in the second system and the account name in the first system; the account number indicates the hierarchical structure relationship of the account name; A mapping unit: configured to save the data of any leaf node in the first tree structure to a corresponding node in the second tree structure according to the mapping rule; Determination unit: used to add all node data of the next level of each node in the second tree structure to obtain the second accounting data value corresponding to any node; based on the second tree structure, determine the second accounting subject name corresponding to the second accounting data value.
5. The device according to claim 4, characterized in that The device also includes a division unit, which is specifically used to divide the first accounting data according to business type; the setting unit is specifically used to set at least one first tree structure for the first accounting data according to the business type; wherein the at least one first tree structure corresponds one-to-one to the business type.
6. The device according to claim 5, characterized in that The subject name corresponding to the first accounting data includes a main entry and a sub-entry; wherein the main entry indicates that the accounting data is a first-level subject name; and the sub-entry indicates the name of the accounting data corresponding to each subject under the first-level subject.
7. An electronic device, characterized in that: include: Memory for storing computer programs; A processor, configured to implement the method according to any one of claims 1 to 3 when executing the computer program stored in the memory.
8. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 3 is implemented.
9. A computer program product, characterized in that When the computer program product is run on a computer, the computer is caused to execute the method according to any one of claims 1 to 3.
Citation Information
Patent Citations
Accounting entry information determining method and device and account data recording method and device
CN109993646A
Scalable transformation and tree based query language node - set selection
US20070005624A1