Business data processing methods, apparatus, computer equipment and readable storage media

By converting the accounting adaptation model table and the business mapping table, the problem of processing non-standard interface data in the front-end business system was solved, enabling efficient and low-cost generation of accounting entry data and improving the system's flexibility and efficiency.

CN117390102BActive Publication Date: 2026-11-10CHINA CONSTRUCTION BANK +1
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202311337066.5
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-10-16
Publication Date
2026-11-10
Estimated Expiration
2043-10-16

AI Technical Summary

Technical Problem

In existing technologies, the non-standard interface data provided by the front-end business system needs to be modified, resulting in long development cycles and huge capital investment, making it difficult to efficiently handle transaction-driven business processes.

Method used

By acquiring business data files and accounting business detail tables, and utilizing accounting adaptation model tables and business mapping tables, the data can be converted into three-dimensional entity template tables, avoiding the need to modify the standard interface of the front-end business system and directly generating accounting entry data.

Benefits of technology

It reduces development costs and time, improves data processing efficiency, supports dynamic changes in data format without modifying code, and enhances system flexibility.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117390102B_ABST
    Figure CN117390102B_ABST
Patent Text Reader

Abstract

This application relates to a business data processing method, apparatus, computer equipment, computer-readable storage medium, and computer program product, applied in the field of big data processing technology. The method includes: acquiring a business data file and a corresponding accounting business detail table; obtaining a matching target business field and its corresponding value from the accounting business detail table based on the conversion type in the accounting adaptation model table; obtaining a target field value matching the target business field and its value from the mapping field values ​​corresponding to the mapping type in the business mapping table, based on the mapping relationship between the conversion type and the mapping type in the business mapping table; writing the target field value into a field matching the conversion type in a three-dimensional entity template table to obtain a target three-dimensional entity table; and processing the target three-dimensional entity table to obtain the accounting entry data corresponding to the business data file. This method can reduce system development costs.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the field of big data processing technology, and in particular to a business data processing method, apparatus, computer equipment, computer-readable storage medium, and computer program product. Background Technology

[0002] Currently, for transaction-driven business process processing, since the front-end business components have standardized interface designs, the front-end business system needs to push standard business data, and then the accounting engine system can obtain accounting entry data by processing the standard business data.

[0003] However, if the business data provided by the front-end business system is not standard interface data, the front-end business system needs to be modified to conform to the standard interface, which will result in a long development cycle and huge financial investment. Summary of the Invention

[0004] Therefore, it is necessary to provide a business data processing method, apparatus, computer equipment, computer-readable storage medium, and computer program product that can reduce development costs in response to the above-mentioned technical problems.

[0005] Firstly, this application provides a business data processing method. The method includes: acquiring a business data file and a corresponding accounting business detail table; obtaining a matching target business field and its corresponding value from the accounting business detail table based on a conversion type in an accounting adaptation model table; the conversion type characterizing the conversion object of the business detail field in the accounting business detail table in a three-dimensional entity template table, the three-dimensional entity template table being a pre-set standard interface data table; based on the mapping relationship between the conversion type and a mapping type in a business mapping table, obtaining a target field value matching the target business field and its value from the mapping field value corresponding to the mapping type in the business mapping table; writing the target field value into a field in the three-dimensional entity template table that matches the conversion type to obtain a target three-dimensional entity table; and processing the target three-dimensional entity table to obtain accounting entry data corresponding to the business data file.

[0006] In one embodiment, before obtaining the matching target business field and the corresponding target business field value from the accounting business detail table based on the conversion type in the accounting adaptation model table, the method further includes: determining the conversion type from the accounting adaptation model table based on the process type of the business data file; the process type is determined based on the file type of the business data file; obtaining the matching target business field and the corresponding target business field value from the accounting business detail table based on the conversion type in the accounting adaptation model table includes: determining the adaptation type from the accounting adaptation model table based on the conversion type; the adaptation type is used to determine the business detail field used in the accounting business detail table; and obtaining the matching target business field and the corresponding target business field value from the accounting business detail table based on the mapping relationship between the conversion type, the adaptation type and the business detail field, and the conversion type and the adaptation type.

[0007] In one embodiment, obtaining a target field value that matches the target business field and the target business field value from the mapping field values ​​corresponding to the mapping type in the business mapping table based on the mapping relationship between the conversion type and the mapping type in the business mapping table includes: obtaining each mapping condition that matches the mapping type from the business mapping table according to the conversion type in the mapping relationship; and determining the mapping condition that matches the target business field and the target business field value and the corresponding mapping field value in each mapping condition as the target field value.

[0008] In one embodiment, obtaining mapping conditions matching the mapping type from the business mapping table according to the conversion type in the mapping relationship includes: when the conversion type is a first type, determining the original values ​​in the business mapping table that match the mapping type as mapping conditions, wherein the first type is used to characterize the conversion of a single business detail field in the accounting business detail table into a field in the three-dimensional entity template table, and the original value is used to identify the field value of the business detail field in the accounting business detail table; when the conversion type is a second type, determining the expressions in the business mapping table that match the mapping type as mapping conditions, wherein the second type is used to characterize the conversion of at least two business detail fields in the accounting business detail table into fields in the three-dimensional entity template table.

[0009] In one embodiment, the method for obtaining the accounting business details table includes: obtaining a matching parsing rule result set from the accounting model details table according to the process type of the business data file; the process type is determined according to the file type of the business data file; and processing the business data file according to the parsing rule result set to obtain the accounting business details table.

[0010] In one embodiment, the method further includes: receiving the audit result of the audit terminal on the accounting entry data; and when the audit result is unsuccessful, re-acquiring the business data file.

[0011] Secondly, this application also provides a business data processing apparatus. The apparatus includes:

[0012] The first acquisition module is used to acquire a business data file and the corresponding accounting business detail table. The first matching module is used to obtain a matching target business field and its corresponding value from the accounting business detail table according to the conversion type in the accounting adaptation model table. The conversion type is used to characterize the conversion object of the business detail field in the accounting business detail table in the three-dimensional entity template table, and the three-dimensional entity template table is a pre-set standard interface data table. The second matching module is used to obtain a target field value that matches the target business field and its value from the mapping field value corresponding to the mapping type in the business mapping table based on the mapping relationship between the conversion type and the mapping type in the business mapping table. The second acquisition module is used to write the target field value into the field in the three-dimensional entity template table that matches the conversion type to obtain a target three-dimensional entity table. The processing module is used to process the target three-dimensional entity table to obtain the accounting entry data corresponding to the business data file.

[0013] In one embodiment, the apparatus further includes a determining module; the determining module is configured to determine the conversion type from the accounting adaptation model table based on the process type of the business data file; the process type is determined based on the file type of the business data file; the first matching module is further configured to: determine an adaptation type from the accounting adaptation model table based on the conversion type; the adaptation type is used to determine the business detail field used in the accounting business detail table; and obtain the matching target business field and the corresponding target business field value from the accounting business detail table based on the mapping relationship between the conversion type, the adaptation type and the business detail field, and the conversion type and the adaptation type.

[0014] In one embodiment, the second matching module is further configured to: obtain each mapping condition matching the mapping type from the business mapping table according to the conversion type in the mapping relationship; and determine the mapping condition matching the target business field and the target business field value, and the corresponding mapping field value, in each of the mapping conditions as the target field value.

[0015] In one embodiment, the second matching module is further configured to: when the conversion type is a first type, determine each original value in the business mapping table that matches the mapping type as a mapping condition, wherein the first type is used to characterize the conversion of a single business detail field in the accounting business detail table into a field in the three-dimensional entity template table, and the original value is used to identify the field value of the business detail field in the accounting business detail table; and when the conversion type is a second type, determine each expression in the business mapping table that matches the mapping type as a mapping condition, wherein the second type is used to characterize the conversion of at least two business detail fields in the accounting business detail table into fields in the three-dimensional entity template table.

[0016] In one embodiment, the first acquisition module is further configured to: obtain a matching parsing rule result set from the accounting model detail table according to the process type of the business data file; the process type is determined according to the file type of the business data file; and process the business data file according to the parsing rule result set to obtain the accounting business detail table.

[0017] In one embodiment, the processing module is further configured to: receive the audit result of the audit terminal on the accounting entry data; and when the audit result is unsuccessful, re-acquire the business data file.

[0018] Thirdly, this application also provides a computer device. The computer device includes a memory and a processor. The memory stores a computer program, and the processor, when executing the computer program, performs the following steps: acquiring a business data file and a corresponding accounting business detail table; obtaining a matching target business field and its corresponding value from the accounting business detail table based on a conversion type in an accounting adaptation model table; the conversion type characterizes the conversion object of the business detail field in the accounting business detail table in a three-dimensional entity template table, where the three-dimensional entity template table is a pre-set standard interface data table; based on the mapping relationship between the conversion type and the mapping type in the business mapping table, obtaining a target field value matching the target business field and its value from the mapping field value corresponding to the mapping type in the business mapping table; writing the target field value into a field in the three-dimensional entity template table that matches the conversion type to obtain a target three-dimensional entity table; and processing the target three-dimensional entity table to obtain accounting entry data corresponding to the business data file.

[0019] Fourthly, this application also provides a computer-readable storage medium. The computer-readable storage medium stores a computer program thereon, which, when executed by a processor, performs the following steps: obtaining a business data file and a corresponding accounting business detail table; obtaining a matching target business field and its corresponding value from the accounting business detail table according to a conversion type in an accounting adaptation model table; the conversion type characterizes the conversion object of the business detail field in the accounting business detail table in a three-dimensional entity template table, the three-dimensional entity template table being a pre-set standard interface data table; based on the mapping relationship between the conversion type and the mapping type in the business mapping table, obtaining a target field value matching the target business field and its value from the mapping field value corresponding to the mapping type in the business mapping table; writing the target field value into a field in the three-dimensional entity template table that matches the conversion type to obtain a target three-dimensional entity table; and processing the target three-dimensional entity table to obtain accounting entry data corresponding to the business data file.

[0020] Fifthly, this application also provides a computer program product. The computer program product includes a computer program that, when executed by a processor, performs the following steps: acquiring a business data file and a corresponding accounting business detail table; obtaining a matching target business field and its corresponding value from the accounting business detail table based on a conversion type in an accounting adaptation model table; the conversion type characterizing the conversion object of the business detail field in the accounting business detail table in a three-dimensional entity template table, the three-dimensional entity template table being a pre-set standard interface data table; based on the mapping relationship between the conversion type and the mapping type in the business mapping table, obtaining a target field value matching the target business field and its value from the mapping field value corresponding to the mapping type in the business mapping table; writing the target field value into a field in the three-dimensional entity template table that matches the conversion type to obtain a target three-dimensional entity table; and processing the target three-dimensional entity table to obtain accounting entry data corresponding to the business data file.

[0021] The aforementioned business data processing methods, devices, computer equipment, storage media, and computer program products, after obtaining the accounting business details table based on the business data file, can write the data in the accounting business details table into the three-dimensional entity template table by combining the accounting adaptation model table and the business mapping table, even if the business data file is not a standard interface format data file. Since the three-dimensional entity template table is a pre-set standard interface data table, when writing the data from the business data file into the three-dimensional entity template table, it is not necessary to modify the front-end business system according to the standard interface, thereby reducing capital investment costs. Attached Figure Description

[0022] Figure 1 This is an application environment diagram of a business data processing method in one embodiment;

[0023] Figure 2 This is a flowchart illustrating a business data processing method in one embodiment;

[0024] Figure 3 This is a flowchart illustrating the process of obtaining the matching target business field and the corresponding target business field value from the accounting business details table based on the conversion type in the accounting adaptation model table in one embodiment.

[0025] Figure 4 This is a flowchart illustrating the process of obtaining a target field value that matches the target business field and the target business field value from the mapping field values ​​corresponding to the mapping types in the business mapping table, based on the mapping relationship between the conversion type and the mapping type in the business mapping table in one embodiment.

[0026] Figure 5 This is a flowchart illustrating the process of obtaining mapping conditions matching the mapping type from the business mapping table based on the conversion type in the mapping relationship in one embodiment.

[0027] Figure 6 This is a flowchart illustrating the method for obtaining the accounting business details table in one embodiment;

[0028] Figure 7 This is a flowchart illustrating a business data processing method in another embodiment;

[0029] Figure 8 This is a flowchart illustrating a business data processing method in another embodiment;

[0030] Figure 9 This is a structural block diagram of a business data processing device in one embodiment;

[0031] Figure 10 This is an internal structural diagram of a computer device in one embodiment. Detailed Implementation

[0032] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0033] Currently, the new generation of accounting architecture in financial institutions has achieved the separation of transaction and accounting. Specifically, because the front-end business components (such as the funds platform system) have standardized interface designs, the front-end business system needs to transmit data according to the standardized interface of the accounting engine's three-dimensional table, or transmit standard business data to the accounting engine. The accounting engine then converts the business data into three-dimensional data. Subsequently, it calls the accounting engine to convert the three-dimensional table data into accounting entries based on accounting parameters.

[0034] If the business data provided by the front-end business system is not the standard interface data of the accounting engine, such as in the insurance industry, where multiple business components are involved in asset management systems for valuation / impairment, new reserves, old reserves, reinsurance, etc., and the output business data formats are all different and do not meet the standard interface format of the accounting engine, then the front-end business system needs to be modified.

[0035] However, if the front-end business system is modified according to standard interfaces, it involves scenario design, system development, and testing, resulting in a long development cycle and huge financial investment. For example, if the data format or scenario of the front-end business system changes, it may be necessary to develop and modify the parameters of both the front-end business system and the accounting engine simultaneously, and complete testing and verification are also required, resulting in insufficient system flexibility.

[0036] In view of this, this application provides a business data processing method. The business data processing method provided in the embodiments of this application can be applied to, for example, Figure 1 The application environment shown. Among them, the business data processing system 100 includes a front-end business system 102, an accounting engine 104, an accounting engine 106, and a processor 108.

[0037] The processor 108 is used to: call the front-end business system 102 to obtain the business data file, and control the front-end business system 102 to send the business data file to the accounting engine 104. The processor 108 is also used to: call the accounting engine 104 to generate the accounting business detail table corresponding to the business data file. Specifically, the accounting engine 104 calls the data file parsing task service to parse the business data file based on the data file parsing task service and save it in the accounting business template detail table, thereby obtaining the accounting business detail table.

[0038] Furthermore, the processor 108 is also used to: call the accounting engine 104 to obtain the matching target business field and the corresponding target business field value from the accounting business details table according to the conversion type in the accounting adaptation model table, and obtain the target field value that matches the target business field and the target business field value from the mapping field value corresponding to the mapping type in the business mapping table based on the mapping relationship between the conversion type and the mapping type in the business mapping table, so as to write the target field value into the field that matches the conversion type in the three-dimensional entity template table to obtain the target three-dimensional entity table.

[0039] Specifically, the accounting engine 104 calls the data conversion to 3D task service to perform data conversion. Specifically, it converts the business detail field values ​​in the accounting business detail table into standard chart of accounts (COA) segment values, thereby assembling them into a standard 3D table data format. Specifically, it writes the business detail field values ​​in the accounting business detail table into the 3D entity template table (i.e., the pre-set standard interface data table) to obtain the target 3D entity table.

[0040] The COA segment values ​​include, but are not limited to: company segment, department segment, channel segment, product segment, object segment, and fund account segment. In addition to the above COA segment values, the three-dimensional table data format also includes accounting type, atomic action, and amount type. The above segment values ​​can be configured in the business mapping table and accounting adaptation model table. The three-dimensional table also includes fields that do not need to be converted, such as amount, lending direction, and system source number.

[0041] Furthermore, the processor 108 is also used to: invoke the accounting engine 106 to process the target three-dimensional entity table pushed by the accounting engine, and obtain the accounting entry data corresponding to the business data file. Specifically, the processor invokes the batch processing service of the accounting engine by invoking the entry generation service, so as to convert the target three-dimensional entity table into accounting entries based on the batch processing service of the accounting engine.

[0042] In one embodiment, such as Figure 2 As shown, a business data processing method is provided, which is applied to... Figure 1 Taking processor 108 as an example, the explanation includes the following steps:

[0043] S202, Obtain the business data file and the corresponding accounting business detail table.

[0044] In this embodiment, the business data file is a data file generated during the transaction process. For example, the business data file includes, but is not limited to, data files such as reserve business data and reinsurance business data. The content of the file includes, but is not limited to, accounting elements such as: institution, accounting period, posting date, product number, amount, etc.

[0045] In this embodiment, the accounting business details table is a file processed from the business data file. Various methods can be used to obtain the accounting business details table from the business data file, as long as all the data content from the business data file is recorded in the accounting business details table.

[0046] In some embodiments, the field mapping relationship between the business data file and the accounting business template detail table can be obtained. Based on the field mapping relationship, the matching field values ​​in the business data file are written into the corresponding fields in the accounting business template detail table to obtain the accounting business detail table.

[0047] S204. Based on the conversion type in the accounting adaptation model table, obtain the matching target business field and the corresponding target business field value from the accounting business details table.

[0048] In this embodiment, the accounting adaptation model table is a pre-set model table. Based on the accounting adaptation model table, accounting entry data corresponding to the business data file can still be obtained without modifying the standard interface of the front-end business system. The conversion type is used to characterize the conversion object of the business detail fields in the accounting business detail table in the three-dimensional entity template table. For example, if the business detail field in the accounting business detail table is a product number, the product number needs to be converted into a product segment in the three-dimensional entity template table. The three-dimensional entity template table is a pre-set standard interface data table; in other words, the three-dimensional entity template table is a data table that matches the standard interface of the accounting engine.

[0049] In some embodiments, the field corresponding to the conversion type can be determined as the target business field, and then the corresponding field value can be matched from the accounting business details table based on the target business field to obtain the target business field value.

[0050] S206, based on the mapping relationship between the conversion type and the mapping type in the business mapping table, obtain the target field value that matches the target business field and the target business field value from the mapping field value corresponding to the mapping type in the business mapping table.

[0051] In this embodiment, the conversion type in the accounting adaptation model table has a mapping relationship with the mapping type in the business mapping table. For example, if the conversion type in the accounting adaptation model table is represented as "PRODUCT", then the mapping type in the business mapping table is also represented as "PRODUCT". That is, the conversion type in the accounting adaptation model table is the same as the mapping type in the business mapping table. Here, "PRODUCT" indicates that a single business detail field in the accounting business detail table is converted into a matching field in the three-dimensional entity template table. Specifically, if the single business detail field in the accounting business detail table is a product number, it is converted into a product segment in the three-dimensional entity template table.

[0052] In this embodiment, the business mapping table is a pre-set model table. Based on the business mapping table, standard accounting entry data corresponding to the business data file can still be obtained without modifying the standard interface of the front-end business system. The business mapping table includes mapping field values ​​corresponding to the mapping type. The mapping field values ​​are used to represent the transformation object values ​​corresponding to the transformation objects of the business detail fields in the accounting business detail table in the three-dimensional entity template table. The mapping field values ​​include target field values. For example, in the business mapping table, when the mapping type is represented as "PRODUCT", the corresponding mapping field values ​​are "P0001", "P0002" or other field values, etc.

[0053] This can be achieved in various ways. Based on the mapping relationship between the conversion type and the mapping type in the business mapping table, the target field value that matches the target business field and the target business field value is obtained from the mapping field value corresponding to the mapping type in the business mapping table.

[0054] In some embodiments, multiple candidate field values ​​can be obtained from the business mapping table according to the mapping type in the mapping relationship, and the field value that matches the target business field among the multiple candidate field values ​​can be determined as the target field value.

[0055] S208: Write the target field value into the field that matches the conversion type in the 3D entity template table to obtain the target 3D entity table.

[0056] In this embodiment, the conversion type is used to characterize the conversion object of the business detail field in the accounting business detail table in the three-dimensional entity template table. Therefore, when determining the conversion object in the three-dimensional entity template table based on the conversion type, the business data file can be assembled into a standard three-dimensional table data format by writing the target field value into the matching field. The accounting model, abstracted from the standardized business scenario, is generally determined by three elements: accounting type, atomic action, and amount type. The three-dimensional table refers to the public information table, the atomic action table, and the amount information table. Their hierarchical relationship is that one public information contains multiple atomic actions, and one atomic action contains multiple amount information. For ease of description, this application collectively refers to the above three tables as three-dimensional table data.

[0057] S210 processes the target three-dimensional entity table to obtain the accounting entries corresponding to the business data file.

[0058] In this embodiment, combined with Figure 1 The processor can call the journal entry generation service, specifically the batch processing service of the accounting engine, to convert the target three-dimensional entity table into accounting entries based on the batch processing service of the accounting engine, and save them in the accounting entry log table, thereby obtaining accounting entry data.

[0059] In summary, based on Figure 2 The method shown allows for the creation of a detailed accounting business table based on a business data file. Even if the business data file is not in a standard interface format, the data can be written into a 3D entity template table by combining the accounting adaptation model table and the business mapping table. Since the 3D entity template table is a pre-set standard interface data table, writing data from the business data file into the 3D entity template table does not require modifying the front-end business system to conform to the standard interface, thus reducing investment costs. Furthermore, the accounting adaptation model table and the business mapping table support dynamic changes in data format without code modification. Additionally, if the table structure of the 3D entity template table changes, the accounting adaptation model table and the business mapping table can be modified accordingly, thereby reducing development time and improving development efficiency.

[0060] In one embodiment, such as Figure 3 The diagram illustrates a process for obtaining matching target business fields and their corresponding values ​​from an accounting business detail table based on the conversion type in the accounting adaptation model table. This method is then applied to… Figure 1 Taking the processor 108 as an example, the steps include:

[0061] S302, determine the conversion type from the accounting adaptation model table based on the process type of the business data file.

[0062] In this embodiment, the process type is used to characterize the current processing flow of the business data processing system. For example, the process type is an identifier for a type of processing flow, which refers to the overall process of processing business data files to obtain accounting entry data. The process type is determined based on the file type of the business data file, which refers to the format of the data in the business data file. Specifically, the processor confirms the process type based on the file type of the business data file and calls the workflow engine service to generate a corresponding process.

[0063] In some embodiments, the accounting adaptation model table includes conversion types corresponding to different process types, so that, based on the process type of the business data file, the conversion type matching the business data file can be obtained from the accounting adaptation model table.

[0064] S304. Determine the adaptation type from the accounting adaptation model table based on the conversion type.

[0065] In this embodiment, the adaptation type is used to determine the business detail fields in the accounting business detail table. Different conversion types correspond to different adaptation types, which are identified by enumeration values. For example, if the business data file is a reserve business data file, in the accounting adaptation model table, when the conversion type is "PRODUCT", the corresponding adaptation type enumeration value is "0". Based on the enumeration value of "0", it can be determined that a single business detail field in the accounting business detail table is used to map a product segment. Combined with the configured business field details in the accounting adaptation model table, it can be seen that a product segment can be mapped based on the product number. For example, when the conversion type is "ORI_TYPE", the corresponding adaptation type enumeration value is "1". Based on the enumeration value of "1", it can be determined that multiple business detail fields in the accounting business detail table are used to map atomic types. Combined with the expression in the business mapping table, it can be seen that the business detail fields "resType" (response type) and "amt" (amount) from the business detail table are required.

[0066] S306. Based on the mapping relationship between the conversion type, adaptation type and business detail fields, as well as the conversion type and adaptation type, obtain the matching target business field and the corresponding target business field value from the accounting business detail table.

[0067] In this embodiment, based on the mapping relationship between conversion type, adaptation type, and business detail fields, the target business detail field matching the conversion type and adaptation type can be determined from the accounting business detail table, and the field value corresponding to the target business detail field can be determined as the target business field value. For example, if the business data file is a reserve business data file, and the conversion type is represented as "PRODUCT" and the enumeration value of the adaptation type is "0", the target business detail field matched in the accounting business detail table is the product number, then the field value "GULN" corresponding to the product number is the target business field value. When the conversion type is represented as "ORI_TYPE" and the enumeration value of the adaptation type is "1", the target business detail fields matched in the accounting business detail table include the reserve type "resType" and the amount "amt", then the field value "O / W Res_C" corresponding to the reserve type and the field value "1000" (i.e., the specific amount) corresponding to the amount are the target business field values.

[0068] In summary, based on Figure 3 The method shown can quickly obtain the matching target business field value from the accounting business detail table by pre-setting the mapping relationship between the conversion type, the adaptation type and the business detail field, thereby improving the processing efficiency of business data.

[0069] The processor can be implemented in various ways. Based on the mapping relationship between the conversion type and the mapping type in the business mapping table, the target field value that matches the target business field and the target business field value is obtained from the mapping field value corresponding to the mapping type in the business mapping table. As long as the target field value is written into the field that matches the conversion type in the three-dimensional entity template table, the data in the target three-dimensional entity table can accurately represent the business data file when the target three-dimensional entity table is obtained.

[0070] like Figure 4 The diagram illustrates a process for obtaining a target field value that matches the target business field and its value from the mapping field values ​​corresponding to the mapping types in the business mapping table, based on the mapping relationship between the conversion type and the mapping type in the business mapping table. This method is then applied to... Figure 1 Taking the processor 108 as an example, the steps include:

[0071] S402, Based on the transformation type in the mapping relationship, obtain each mapping condition that matches the mapping type from the business mapping table.

[0072] In this embodiment, the business mapping table includes mapping conditions corresponding to different mapping types. When the mapping types are different, the corresponding mapping conditions are represented in different ways.

[0073] For example, if the business data file is a reserve business data file, and the mapping type is "PRODUCT", then "PRODUCT" indicates that a single business detail field (such as product number) in the accounting business detail table is converted into a matching field (such as product segment) in the three-dimensional entity template table. The corresponding mapping conditions are represented by the field values ​​corresponding to the single business detail field (such as the field values ​​"GULN" or "JKLN" corresponding to the product number). For example, the mapping conditions corresponding to the mapping type "PRODUCT" can include "GULN" and "JKLN", etc.

[0074] For example, if the business data file is a reserve business data file, and the mapping type is represented as "ORI_TYPE", then "ORI_TYPE" indicates that at least two business detail fields (such as reserve type "resType" and amount "amt") in the accounting business detail table will be converted into matching fields (such as atomic actions) in the three-dimensional entity template table. The mapping conditions corresponding to "ORI_TYPE" are represented by at least two business detail fields (such as reserve type "resType" and amount "amt"). For example, the mapping conditions when the mapping type is "ORI_TYPE" can include "resType=='O / W Res_C'&&'amt<0'" and "resType=='O / W Res_C'&&'amt>=0'", etc.

[0075] S404: Determine the mapping conditions that match the target business field and the target business field value in each mapping condition as the target field value.

[0076] In this embodiment, the business mapping table also includes mapping field values ​​corresponding to each mapping condition. If the mapping condition that matches the target business field and the target business field value is determined from each mapping condition, then the mapping field value corresponding to the single mapping condition is also a single field value.

[0077] In conjunction with S402, for example, if the business data file is a reserve business data file, and the mapping type is represented as "PRODUCT", if the mapping condition is "GULN", the corresponding mapping field value is represented as "P0001", and if the mapping condition is "JKLN", the corresponding mapping field value is represented as "P0002". "GULN" and "JKLN" match the target business field, which is the product number. If the target business field value is "GULN", then the matching mapping condition can be determined to be "GULN", and its corresponding "P0001" is the target field value. Furthermore, "P0001" can be written into the field matching the product segment in the 3D entity template table.

[0078] For example, if the business data file is a reserve business data file, and the mapping type is represented as "ORI_TYPE", the corresponding mapping field value is "D300" when the mapping condition is "resType=='O / W Res_C'&&'amt<0'", and the corresponding mapping field value is "D283" when the mapping condition is "resType=='O / W Res_C'&&'amt>=0'". Then, when the target business field value is "O / W Res_C" and "1000", because the amount is greater than 0, the matching mapping condition is "resType=='O / W Res_C'&&'amt>=0'", and the corresponding mapping field value "D283" is the target field value. Furthermore, "D283" can be written into the field matching the atomic action in the 3D entity template table.

[0079] In summary, based on Figure 4 The method shown improves the efficiency of obtaining field values ​​by pre-setting mapping conditions for different mapping types in the business mapping table. This is achieved by quickly obtaining target field values ​​that match the target business field values ​​from the business mapping table based on the mapping conditions.

[0080] The processor can be implemented in various ways. Based on the transformation type in the mapping relationship, it can obtain each mapping condition that matches the mapping type from the business mapping table, as long as the target field value can be accurately obtained based on the obtained mapping conditions.

[0081] In one embodiment, such as Figure 5 The diagram illustrates a process for obtaining mapping conditions matching the mapping type from a business mapping table based on the transformation type in the mapping relationship. This method is then applied to... Figure 1 Taking the processor 108 as an example, the steps include:

[0082] S502, when the conversion type is the first type, the original values ​​in the business mapping table that match the mapping type are determined as the mapping conditions.

[0083] In this embodiment, the first type is used to represent the conversion of a single business detail field in the accounting business detail table into a field in the three-dimensional entity template table, and the original value is used to identify the field value of the business detail field in the accounting business detail table. For example, based on the above, the first type can be represented as "PRODUCT". Based on the first type being "PRODUCT", the corresponding business detail field can be determined from the accounting adaptation model table as the product number "pdld". Furthermore, the original values ​​"GULN" and "JKLN" in the business mapping table that match the first type "PRODUCT" are determined as mapping conditions, and the original values ​​are used to identify the field value of the product number in the accounting business detail table. Further, the field value of the product number in the accounting business detail table is compared with the mapping conditions of the first type "PRODUCT" in the business mapping table. If they are equal, the match is successful, and the mapping field value corresponding to the satisfied mapping condition is determined as the target field value. For example, if the target business field is the product number "pdld" and its corresponding target business field value is "GULN", then the mapping condition for matching based on the target business field and the target business field value is "GULN", and the mapping field value corresponding to "GULN" is determined as the target field value.

[0084] S504, when the conversion type is the second type, the expressions in the business mapping table that match the mapping type are determined as the mapping conditions.

[0085] In this embodiment, the second type is different from the first type. The second type is used to represent the conversion of at least two business detail fields in the accounting business detail table into fields in the three-dimensional entity template table. For example, based on the above, the second type can be represented as "ORI_TYPE", and the expression in the business mapping table that matches the second type "ORI_TYPE" can be determined as the mapping condition. For example, in the business mapping table, the two expressions corresponding to the mapping type "ORI_TYPE" are respectively represented as: "resType=='O / W Res_C'&&'amt<0'" and "resType=='O / W Res_C'&&'amt>=0'".

[0086] Furthermore, the expression engine Aviator can be invoked to determine the mapping conditions satisfied by the target business field and its value, and then the mapping field value corresponding to the satisfied mapping conditions can be determined as the target field value. For example, the target business fields are the reserve type "resType" and the amount "amt", and their corresponding target business field values ​​are "O / WRes_C" and "1000.00". Therefore, based on the target business field and its value satisfying the mapping condition "resType=='O / W Res_C'&&'amt>=0'", the mapping field value corresponding to the mapping condition "resType=='O / W Res_C'&&'amt>=0'" can be determined as the target field value.

[0087] In summary, based on Figure 5 The method shown can determine the corresponding mapping conditions in different ways according to different conversion types, thereby ensuring the flexibility of business data processing.

[0088] Combination Figures 3-5 The content shown, taking the reserve business data file as an example, includes a schematic diagram of an accounting business detail table (Table 1), an schematic diagram of an accounting adaptation model detail table (Table 2), and an schematic diagram of a business mapping table (Table 3). The contents of Tables 1 to 3 are as follows:

[0089] Table 1

[0090]

[0091] Table 2

[0092] Process type Conversion type Business Field Details Adaptation type ... ACC PRODUCT pdld 0 ... ACC ORI_TYPE 1 ... ... ... ... ... ...

[0093] Table 3

[0094]

[0095] Combining the information shown in Tables 2 and 3, the two rows of data in Table 1 can be processed as follows:

[0096] For the first row of data in Table 1, the corresponding process type "ACC" can be determined based on the file type "new_type". Then, based on the process type "ACC", the conversion types "ORI_TYPE" and "PRODUCT" can be obtained from Table 2.

[0097] Taking the product number as a single business detail field as an example, based on the conversion type "PRODUCT" and the enumeration value "0" of the corresponding adaptation type, the target business field to be matched is determined from Table 1 as the product number "pdld" and the target business field value "GULN" corresponding to the product number "pdld". Simultaneously, based on the conversion type "PRODUCT", two original values ​​"GULN" and "JKLN" representing the product number are obtained from Table 2, with the mapping type being "PRODUCT". "GULN" and "JKLN" are the mapping conditions when the mapping type is "PRODUCT". Since the target business field is "pdld" and the target business field value corresponding to the target business field is "GULN", the target value (i.e., the mapping field value) "P0001" corresponding to the original value "GULN" is determined as the target field value, and "P0001" is written into the field of the product segment in the 3D entity template table.

[0098] In actual business data processing, data from the accounting business detail table can be converted into a Map object, denoted as adpVoucherDtlMap. For example, the product number key is "pdld", and the value corresponding to the key is "GULN". Therefore, since the business detail field "pdld" corresponding to "PRODUCT" is the same as "pdld" in the accounting business detail table, the required "GULN" can be read from the adpVoucherDtlMap object using the key, and then the target value "P0001" corresponding to "GULN" in the business mapping table can be determined as the target field value.

[0099] Similarly, taking at least two business detail fields as reserve type "resType" and amount "amt" as an example, based on the enumeration value "1" of the matching type corresponding to the conversion type "ORI_TYPE", the target business fields to be matched are determined from Table 1 as reserve type "resType" and amount "amt", with corresponding target business field values ​​of "O / W Res_C" and "-1500.00" respectively. At the same time, based on the conversion type "ORI_TYPE", the expressions corresponding to the mapping type "ORI_TYPE" are obtained from the business mapping table. The specific expressions are: "resType=='O / W Res_C'&&'amt<0'" and "resType=='O / W Res_C'&&'amt>=0'". Since the specific value of the amount is less than 0, the target value (i.e. the mapping field value) "D300" corresponding to the expression "resType=='O / W Res_C'&&'amt<0'" is determined as the target field value, and then "D300" is written into the field of atomic action in the three-dimensional entity template table.

[0100] It's understandable that Tables 2 and 3 can be dynamically configured via the page and updated in real time. If business data changes (i.e., business scenarios change), rapid deployment can be achieved without modifying the code, improving development efficiency. For example, if expressions need to be dynamically modified due to changes in conversion and mapping types, no development is required; it can be achieved simply through page configuration. This allows for adaptation to various file types of business data and parameter changes, reducing system development time and improving system development efficiency.

[0101] Similarly, the same processing method used for the first row of data in Table 1 is applied to the second row of data in Table 1, and will not be repeated here. Through the corresponding processing of the first and second rows of data in Table 1, the target 3D entity table shown in Table 4 can be obtained. The contents of Table 4 are as follows:

[0102] Table 4

[0103] Action number Atomic Actions Product segment ... 1 D300 P0001 .. 2 D283 P0002 .. ... ... ... ...

[0104] The processor can be implemented in various ways to obtain the detailed accounting table based on the business data file. In one embodiment, such as... Figure 6 The diagram illustrates a process for obtaining a detailed accounting business report, and how this method is applied to... Figure 1 Taking the processor 108 as an example, the steps include:

[0105] S602, based on the process type of the business data file, obtain the matching parsing rule result set from the accounting model detail table.

[0106] In this embodiment, the process type is used to characterize the current processing flow of the business data processing system. It is an identifier for a type of processing flow, which refers to the process of processing business data files. The process type is determined based on the file type of the business data file, which refers to the format of the data in the business data file. Specifically, the processor determines the corresponding process type based on the file type of the business data file and calls the workflow engine service to generate a corresponding process.

[0107] S604: Based on the result set of the parsing rules, process the business data file to obtain the accounting business details table.

[0108] In this embodiment, the parsing rule result set includes the mapping relationship between the model header fields and the file header fields in the accounting business detail template file. In some embodiments, based on the mapping relationship between the model header fields and the file header fields in the accounting business detail template file, the field values ​​of the file header fields of the business data file are written into the fields of the accounting business detail template file that match the business detail fields corresponding to the model header fields, thereby obtaining the accounting business detail table.

[0109] Specifically, after the header fields of the business data file successfully match the header fields of the model table in the accounting business detail template file, Java reflection technology can be used to save the values ​​of the header fields of the business data file into the fields of the accounting business detail template file that match the corresponding business detail fields of the model header fields. This allows the accounting business detail table to be obtained. The accounting business detail table can then be stored in a database. When accounting entries need to be generated based on the accounting business detail table, it can be retrieved from the database.

[0110] As shown in Table 5, a business data file is provided. The header fields in the business data file include file type, reserve type, product number, and amount. Table 6 provides a schematic diagram of an accounting model detail table. In Table 6, the model header fields corresponding to the process type "ACC" include file type, reserve type, product number, and amount. The corresponding business detail fields are "pdld", "fileType", "resType", and "amt", respectively. Specifically, the contents of Tables 5 and 6 are as follows:

[0111] Table 5

[0112] File type Types of reserves Product Number Amount ... spare fields new_type O / W Res_C GULN -1500.00 ... ... new_type O / W Res_C JKLN 1000.00 ... ... ... ... ... ... ... ...

[0113] Table 6

[0114] Process type Model header fields Business details fields ... ACC Product Number pdld ... ACC File type fileType ... ACC Types of reserves resType ... ACC Amount amt ... ... ... ... ...

[0115] For the two rows of data in Table 5, based on the mapping relationship between the file header fields in Table 5 and the model header fields in Table 6, the field values ​​of the file header fields of the business data file can be written into the fields of the business detail template file that match the business detail fields corresponding to the model header fields. For example, if the field value of the product number in the file header field is “GULN”, “GULN” can be written into the business detail field “pdld”. Thus, the business detail table as shown in Table 1 above can be obtained.

[0116] It should be understood that, based on different business data, the accounting model details table can be dynamically configured directly on the page, thereby enabling the processing of business data files based on the accounting model details table, which improves the flexibility of data processing.

[0117] Combination Figure 1 The business data processing system 100 also includes an audit terminal, specifically, such as... Figure 7 As shown, a business data processing method is provided, which is applied to... Figure 1 Taking the processor 108 as an example, the steps include:

[0118] S702 receives the audit results of the audit terminal for accounting entry data.

[0119] In this embodiment, after the processor obtains the accounting entry data based on the accounting engine, it updates the process status to process callback based on the workflow engine. The process callback is when the accounting engine completes the conversion of the accounting entry and sends a signal to the workflow engine to call the callback, driving it to the next task status. The next task status refers to the status of the financial personnel reviewing the accounting entry data.

[0120] Specifically, after the processor obtains accounting entry data based on the accounting engine, it sends the data to the auditing terminal of the finance personnel. Once the finance personnel find the task requiring action, they can check the correctness of the generated entries and approve or disapprove the audit. The audit result includes either approval or disapproval. The task of manually auditing accounting entry data can be configured to specific personnel or job positions.

[0121] S704: When the audit result is unsuccessful, re-acquire the business data file.

[0122] In this embodiment, when the audit result is unsuccessful, it indicates that the accounting entry was not successfully entered into the books, and it also indicates that the obtained business data file is incorrect, resulting in incorrect accounting entries. Therefore, by re-obtaining the business data file and processing it according to the method provided in the above embodiment, the accounting entries can be obtained again, thereby ensuring the accuracy of the obtained accounting entries.

[0123] In some embodiments, when the audit result is passed, the processor pushes the accounting entry data to the downstream system so that the downstream system can perform corresponding processing based on the accounting entry data.

[0124] In summary, based on Figure 7 The method shown adds a manual verification node after the accounting entries are converted, enabling financial personnel to monitor the accounting process and improving the accuracy of the generated data.

[0125] In conjunction with the above, in one embodiment, such as Figure 8 As shown, a business data processing method is provided, which is applied to... Figure 1 Taking the processor 108 as an example, the steps include:

[0126] S802, retrieve business data file.

[0127] S804: Based on the process type of the business data file, obtain the matching parsing rule result set from the accounting model detail table; process the business data file according to the parsing rule result set to obtain the accounting business detail table.

[0128] S806: Based on the process type of the business data file, determine the conversion type from the accounting adaptation model table; based on the conversion type, determine the adaptation type from the accounting adaptation model table; based on the mapping relationship between the conversion type, adaptation type and business detail fields, as well as the conversion type and adaptation type, obtain the matching target business field and the corresponding target business field value from the accounting business detail table.

[0129] Depending on the type of conversion, different implementation methods can be used to determine the mapping conditions, specifically: S808 and / or S810.

[0130] S808: When the conversion type is the first type, the original values ​​in the business mapping table that match the mapping type are determined as the mapping conditions; when the conversion type is the second type, the expressions in the business mapping table that match the mapping type are determined as the mapping conditions.

[0131] S810: Determine the mapping conditions that match the target business field and the target business field value in each mapping condition as the target field value; write the target field value into the field that matches the conversion type in the 3D entity template table to obtain the target 3D entity table.

[0132] S812 processes the target three-dimensional entity table to obtain the accounting entry data corresponding to the business data file.

[0133] The specific content of S802-S812 can be found in the aforementioned description and will not be repeated here.

[0134] Based on the above, it can be understood that the method provided in this application can be used to achieve data adaptation. By configuring the parameters in the accounting adaptation model table and the business mapping table, it can flexibly and quickly respond to various business scenarios, quickly realize data access, improve system development efficiency, save development manpower and resources, achieve cost reduction and efficiency improvement, and reduce system construction costs. Moreover, the method provided in this application can support the rapid and diversified development of enterprise business when performing data adaptation.

[0135] It should be understood that although the steps in the flowcharts of the above embodiments are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the above embodiments may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0136] Based on the same inventive concept, this application also provides a business data processing apparatus for implementing the business data processing method described above. The solution provided by this apparatus is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more of the XXX apparatus embodiments provided below can be found in the limitations of the business data processing method described above, and will not be repeated here.

[0137] In one embodiment, such as Figure 9 As shown, a business data processing device is provided, comprising: a first acquisition module 902, a first matching module 904, a second matching module 906, a second acquisition module 908, and a processing module 910, wherein:

[0138] The first acquisition module is used to acquire the business data file and the corresponding accounting business detail table. The first matching module is used to obtain the matching target business field and the corresponding target business field value from the accounting business detail table according to the conversion type in the accounting adaptation model table. The conversion type is used to characterize the conversion object of the business detail field in the accounting business detail table in the three-dimensional entity template table. The three-dimensional entity template table is a pre-set standard interface data table. The second matching module is used to obtain the target field value that matches the target business field and the target business field value from the mapping field value corresponding to the mapping type in the business mapping table based on the mapping relationship between the conversion type and the mapping type in the business mapping table. The second acquisition module is used to write the target field value into the field that matches the conversion type in the three-dimensional entity template table to obtain the target three-dimensional entity table. The processing module is used to process the target three-dimensional entity table to obtain the accounting entry data corresponding to the business data file.

[0139] In one embodiment, the apparatus further includes a determining module; the determining module is configured to determine a conversion type from an accounting adaptation model table based on the process type of the business data file; the process type is determined based on the file type of the business data file; the first matching module is further configured to: determine an adaptation type from the accounting adaptation model table based on the conversion type; the adaptation type is used to determine the business detail field in the accounting business detail table used; and obtain the matching target business field and the corresponding target business field value from the accounting business detail table based on the conversion type and the adaptation type, and the mapping relationship between the conversion type, the adaptation type and the business detail field.

[0140] In one embodiment, the second matching module is further configured to: obtain each mapping condition matching the mapping type from the business mapping table according to the conversion type in the mapping relationship; and determine the mapping condition that matches the target business field and the target business field value and the corresponding mapping field value in each mapping condition as the target field value.

[0141] In one embodiment, the second matching module is further configured to: when the conversion type is the first type, determine each original value in the business mapping table that matches the mapping type as each mapping condition, wherein the first type is used to characterize the conversion of a single business detail field in the accounting business detail table into a field in the three-dimensional entity template table, and the original value is used to identify the field value of the business detail field in the accounting business detail table; when the conversion type is the second type, determine each expression in the business mapping table that matches the mapping type as each mapping condition, wherein the second type is used to characterize the conversion of at least two business detail fields in the accounting business detail table into fields in the three-dimensional entity template table.

[0142] In one embodiment, the first acquisition module is further configured to: obtain a set of matching parsing rules from the accounting model detail table according to the process type of the business data file; the process type is determined according to the file type of the business data file; and process the business data file according to the set of parsing rules to obtain the accounting business detail table.

[0143] In one embodiment, the processing module is further configured to: receive the audit result of the audit terminal on the accounting entry data; and when the audit result is unsuccessful, re-acquire the business data file.

[0144] Each module in the aforementioned business data processing device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the memory of a computer device as software, so that the processor can call and execute the operations corresponding to each module.

[0145] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 10 As shown, this computer device includes a processor, memory, input / output interfaces (I / O), and a communication interface. The processor, memory, and I / O interfaces are connected via a system bus, and the communication interface is also connected to the system bus via the I / O interfaces. The processor provides computational and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides the environment for the operating system and computer programs stored in the non-volatile storage media. The database stores business data files, accounting adaptation model tables, business mapping tables, and detailed accounting model tables. The I / O interfaces are used for exchanging information between the processor and external devices. The communication interface is used for communication with external terminals via a network connection. When the computer program is executed by the processor, it implements a business data processing method.

[0146] Those skilled in the art will understand that Figure 10 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0147] In one embodiment, a computer device is also provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps in the above method embodiments.

[0148] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon that, when executed by a processor, implements the steps in the above method embodiments.

[0149] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps in the above method embodiments.

[0150] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of the relevant data must comply with relevant regulations.

[0151] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0152] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0153] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A business data processing method, characterized in that, The method includes: Obtain the business data file and the corresponding accounting business detail table; Based on the conversion type in the accounting adaptation model table, the matching target business field and the corresponding target business field value are obtained from the accounting business detail table; the conversion type is used to characterize the conversion object of the business detail field in the accounting business detail table in the three-dimensional entity template table, and the three-dimensional entity template table is a pre-set standard interface data table; Based on the mapping relationship between the conversion type and the mapping type in the business mapping table, the target field value that matches the target business field and the target business field value is obtained from the mapping field value corresponding to the mapping type in the business mapping table; Write the target field value into the field that matches the conversion type in the 3D entity template table to obtain the target 3D entity table; Process the target three-dimensional entity table to obtain the accounting entries corresponding to the business data file; The business mapping table includes mapping conditions corresponding to different mapping types and mapping field values ​​corresponding to each mapping condition. The step of obtaining a target field value matching the target business field and its value from the mapping field values ​​corresponding to the mapping types in the business mapping table, based on the mapping relationship between the conversion type and the mapping types in the business mapping table, includes: When the conversion type is the first type, the original values ​​in the business mapping table that match the mapping type are determined as the mapping conditions. The first type is used to characterize the conversion of a single business detail field in the accounting business detail table into a field in the three-dimensional entity template table. The original value is used to identify the field value of the business detail field in the accounting business detail table. When the conversion type is the second type, each expression in the business mapping table that matches the mapping type is determined as a mapping condition. The second type is used to characterize the conversion of at least two business detail fields in the accounting business detail table into fields in the three-dimensional entity template table. The mapping conditions that match the target business field and the target business field value, and the corresponding mapping field values, are determined as the target field values.

2. The method according to claim 1, characterized in that, Before obtaining the matching target business field and its corresponding value from the accounting business details table based on the conversion type in the accounting adaptation model table, the process further includes: Based on the process type of the business data file, the conversion type is determined from the accounting adaptation model table; the process type is determined based on the file type of the business data file. The step of obtaining the matching target business field and its corresponding value from the accounting business details table based on the conversion type in the accounting adaptation model table includes: Based on the conversion type, the adaptation type is determined from the accounting adaptation model table; the adaptation type is used to determine the business detail field in the accounting business detail table to be used. Based on the mapping relationship between the conversion type, the adaptation type and the business detail fields, and the conversion type and the adaptation type, the matching target business field and the corresponding target business field value are obtained from the accounting business detail table.

3. The method according to claim 1, characterized in that, The methods for obtaining the detailed accounting business statement include: Based on the process type of the business data file, a set of matching parsing rules is obtained from the accounting model details table; the process type is determined according to the file type of the business data file. Based on the result set of the parsing rules, the business data file is processed to obtain the accounting business details table.

4. The method according to any one of claims 1-3, characterized in that, The method further includes: Receive the audit results from the audit terminal regarding the accounting entry data; If the audit result is unsuccessful, the business data file will be retrieved again.

5. A business data processing device, characterized in that, The device includes: The first acquisition module is used to acquire the business data file and the accounting business detail table corresponding to the business data file; The first matching module is used to obtain the matching target business field and the corresponding target business field value from the accounting business detail table according to the conversion type in the accounting adaptation model table; the conversion type is used to characterize the conversion object of the business detail field in the accounting business detail table in the three-dimensional entity template table, and the three-dimensional entity template table is a pre-set standard interface data table; The second matching module is used to obtain a target field value that matches the target business field and the target business field value from the mapping field values ​​corresponding to the mapping types in the business mapping table, based on the mapping relationship between the conversion type and the mapping type in the business mapping table. The second acquisition module is used to write the target field value into the field of the three-dimensional entity template table that matches the conversion type, thereby obtaining the target three-dimensional entity table; The processing module is used to process the target three-dimensional entity table and obtain the accounting entry data corresponding to the business data file; The business mapping table includes mapping conditions corresponding to different mapping types, and mapping field values ​​corresponding to each mapping condition; the second matching module is further used for: When the conversion type is the first type, the original values ​​in the business mapping table that match the mapping type are determined as the mapping conditions. The first type is used to characterize the conversion of a single business detail field in the accounting business detail table into a field in the three-dimensional entity template table. The original value is used to identify the field value of the business detail field in the accounting business detail table. When the conversion type is the second type, each expression in the business mapping table that matches the mapping type is determined as a mapping condition. The second type is used to characterize the conversion of at least two business detail fields in the accounting business detail table into fields in the three-dimensional entity template table. The mapping conditions that match the target business field and the target business field value, and the corresponding mapping field values, are determined as the target field values.

6. The apparatus according to claim 5, characterized in that, The device further includes a determining module, the determining module being configured to: Based on the process type of the business data file, the conversion type is determined from the accounting adaptation model table; the process type is determined based on the file type of the business data file. The first matching module is further configured to: Based on the conversion type, the adaptation type is determined from the accounting adaptation model table; the adaptation type is used to determine the business detail field in the accounting business detail table to be used. Based on the mapping relationship between the conversion type, the adaptation type and the business detail fields, and the conversion type and the adaptation type, the matching target business field and the corresponding target business field value are obtained from the accounting business detail table.

7. The apparatus according to claim 5, characterized in that, The first acquisition module is further configured to: Based on the process type of the business data file, a set of matching parsing rules is obtained from the accounting model details table; the process type is determined according to the file type of the business data file. Based on the result set of the parsing rules, the business data file is processed to obtain the accounting business details table.

8. The apparatus according to any one of claims 5-7, characterized in that, The processing module is further configured to: Receive the audit results from the audit terminal regarding the accounting entry data; If the audit result is unsuccessful, the business data file will be retrieved again.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 4.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 4.

11. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 4.

Citation Information

Patent Citations

  • Data import method and device

    CN111367988A

  • Interface calling method and device

    CN113626223A

  • Accounting entry generation method and device, equipment and medium

    CN116485569A

  • Business data processing method and device, computer equipment and storage medium

    CN116737753A