Table processing method and device, equipment and medium

Abstract

The invention relates to the field of data processing, in particular to a table processing method and device, equipment and a medium, which are used for realizing automatic processing of an estimation table without manual intervention and improving the processing efficiency of the estimation table. The method comprises the following steps: acquiring a target mail of any account and attachment information in the target mail; if the attachment information represents that the attachment of the target mail contains a specified type of table, acquiring a first table from the attachment of the target mail; the first table is a table of a specified type, and the first table is used for representing resource information of any account; based on the content data corresponding to each first header in the first table, determining a mapping relationship between each first header and each second header in the first table; and converting the first table into a second table based on a mapping relationship between each first table header and each second table header in the first table, the second table being used for representing a resource distribution condition of any account.

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a table processing method, device, equipment and medium. Background Art

[0002] According to the requirements of the financial management company, it is necessary to generate real-time valuation table information of internal products of the system based on the outsourced valuation table information of the financial products, including net value, position and other information.

[0003] At present, the outsourced valuation form information is mainly sent to the valuation business personnel through offline emails. The valuation business personnel prepare the valuation form offline according to the outsourced valuation form information, and parse the valuation form to obtain the parsed data.

[0004] However, this valuation table processing method usually requires a large amount of long-term and continuous manual intervention. Manual processing is time-consuming and labor-intensive, not conducive to the requirements of automated management, and is prone to errors, resulting in low processing efficiency of the entire valuation table and low accuracy of the final analytical data obtained. Summary of the invention

[0005] The embodiments of the present application provide a table processing method, apparatus, device and medium for realizing automatic processing of valuation tables without manual intervention, thereby improving the efficiency of valuation table processing.

[0006] In a first aspect, the present application provides a table processing method, the method comprising:

[0007] Obtaining a target email of any account and attachment information in the target email; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email;

[0008] If the attachment information indicates that the attachment of the target email contains a table of a specified type, obtaining a first table from the attachment of the target email; the first table is a table of the specified type, and the first table is used to represent resource information of any one of the accounts;

[0009] Determine, based on the content data corresponding to each first header in the first table, a mapping relationship between each first header and each second header in the first table;

[0010] Based on the mapping relationship between each first table header and each second table header in the first table, the first table is converted into a second table, wherein the second table is used to represent the resource distribution of any one of the accounts.

[0011] In an embodiment of the present application, a target email of any account and attachment information in the target email are obtained. If the attachment information indicates that the attachment of the target email contains a table of a specified type, that is, the attachment information indicates that the attachment of the target email contains a valuation table, then the first table is obtained from the attachment of the target email. In addition, the present application determines the mapping relationship between each first header and each second header in the first table based on the content data corresponding to each first header in the first table, and converts the first table into the second table based on the mapping relationship between each first header and each second header in the first table, thereby realizing automatic processing of the valuation table without manual intervention, improving the efficiency of the valuation table processing, and improving the accuracy of the obtained second table.

[0012] In a possible embodiment, each of the first headers includes a first target header, and determining a mapping relationship between each of the first headers and each of the second headers in the first table based on content data corresponding to each of the first headers in the first table includes:

[0013] Matching the first content data corresponding to the first target header with the set entry information to determine the target entry information matching the first content data;

[0014] Based on the entry type to which the target entry information belongs, a mapping relationship between the first header and the second header is determined.

[0015] In an embodiment of the present application, since different entry types correspond to different mapping relationships between the first header and the second header, the first content data corresponding to the first target header is matched with the set entry information to determine the target entry information that matches the first content data, and based on the entry type to which the target entry information belongs, the mapping relationship between the first header and the second header is determined without manual intervention, thereby improving the efficiency of determining the mapping relationship.

[0016] In a possible embodiment, converting the first table into the second table based on the mapping relationship between each first table header and each second table header in the first table includes:

[0017] Based on the mapping relationship between each first table header and each second table header in the first table, determining the content data corresponding to each second table header from the first table;

[0018] The second table is obtained based on the second table headers and the content data corresponding to the second table headers.

[0019] In an embodiment of the present application, based on the mapping relationship between each first header and each second header in the first table, the content data corresponding to each second header is determined from the first table, and based on each second header and the content data corresponding to each second header, the second table is obtained, thereby realizing automatic processing of the valuation table without human intervention, improving the efficiency of the valuation table processing, and improving the accuracy of the obtained second table.

[0020] In a possible embodiment, before obtaining the second table, the method further includes:

[0021] Matching the first content data with set item attribute information to determine target item attribute information matching the first content data;

[0022] Determining resource type information based on the entry attribute type corresponding to the target entry attribute information;

[0023] Based on the second table headers and the content data corresponding to the second table headers, the second table is obtained, including:

[0024] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, and the resource type information.

[0025] In an embodiment of the present application, the first content data is matched with the set entry attribute information to determine the target entry attribute information that matches the first content data, and the resource type information is determined based on the entry attribute type corresponding to the target entry attribute information, thereby improving the accuracy of the determined resource type information, and based on each second table header, the content data and resource type information corresponding to each second table header, a second table is obtained to realize automatic processing of the valuation table without manual intervention, thereby improving the efficiency of the valuation table processing and improving the accuracy and richness of the obtained second table.

[0026] In a possible embodiment, before obtaining the second table, the method further includes:

[0027] Matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data;

[0028] Based on the second table headers, the content data corresponding to the second table headers and the asset type information, the second table is obtained, including:

[0029] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, the resource type information and the target transaction venue information.

[0030] In an embodiment of the present application, the first content data is matched with the set transaction venue information to determine the target transaction venue information that matches the first content data, thereby improving the accuracy of the determined target transaction venue information, and based on each second table header, the content data corresponding to each second table header, the resource type information and the target transaction venue information, a second table is obtained to realize automatic processing of the valuation table without manual intervention, thereby improving the efficiency of the valuation table processing and improving the accuracy and richness of the obtained second table.

[0031] In a possible embodiment, each of the first headers includes a first target header and a second target header, and after obtaining the first table from the attachment of the target email, the method further includes:

[0032] Matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data;

[0033] Determine the content data corresponding to each target total item information based on the first content data corresponding to the first target header;

[0034] Based on the target total item information and the content data corresponding to the target total item information, a third table is obtained, wherein the third table is used to represent the remaining resource status of any one of the accounts.

[0035] In an embodiment of the present application, the second content data corresponding to the second target header is matched with the set total item information to determine the target total item information matching the second content data, and the content data corresponding to each target total item information is determined based on the first content data corresponding to the first target header, so as to obtain a third table for characterizing the remaining resource status of any account based on each target total item information and the content data corresponding to each target total item information, thereby realizing automatic processing of the valuation table without manual intervention, improving the efficiency of the valuation table processing, and improving the accuracy of the obtained third table.

[0036] In a second aspect, the present application provides a table processing device, the device comprising:

[0037] A first acquisition module is used to acquire a target email of any account and attachment information in the target email; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email;

[0038] a second acquisition module, configured to acquire a first table from the attachment of the target email if the attachment information indicates that the attachment of the target email contains a table of a specified type; the first table is a table of the specified type, and the first table is used to represent resource information of any one of the accounts;

[0039] a determination module, configured to determine a mapping relationship between each first header and each second header in the first table based on content data corresponding to each first header in the first table;

[0040] A conversion module is used to convert the first table into a second table based on a mapping relationship between each first table header and each second table header in the first table, wherein the second table is used to represent the resource distribution of any one of the accounts.

[0041] In a possible embodiment, each of the first headers includes a first target header, and the determining module is used to:

[0042] Matching the first content data corresponding to the first target header with the set entry information to determine the target entry information matching the first content data;

[0043] Based on the entry type to which the target entry information belongs, a mapping relationship between the first header and the second header is determined.

[0044] In a possible embodiment, the conversion module is used to:

[0045] Based on the mapping relationship between each first table header and each second table header in the first table, determining the content data corresponding to each second table header from the first table;

[0046] The second table is obtained based on the second table headers and the content data corresponding to the second table headers.

[0047] In a possible embodiment, before obtaining the second table, the conversion module is further configured to:

[0048] Matching the first content data with set item attribute information to determine target item attribute information matching the first content data;

[0049] Determining resource type information based on the entry attribute type corresponding to the target entry attribute information;

[0050] Based on the second table headers and the content data corresponding to the second table headers, the second table is obtained, including:

[0051] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, and the resource type information.

[0052] In a possible embodiment, before obtaining the second table, the conversion device is further used for:

[0053] Matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data;

[0054] Based on the second table headers, the content data corresponding to the second table headers and the asset type information, the second table is obtained, including:

[0055] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, the resource type information and the target transaction venue information.

[0056] In a possible embodiment, each of the first headers includes a first target header and a second target header, and after obtaining the first table from the attachment of the target email, the second obtaining module is further configured to:

[0057] Matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data;

[0058] Determine the content data corresponding to each target total item information based on the first content data corresponding to the first target header;

[0059] Based on the target total item information and the content data corresponding to the target total item information, a third table is obtained, wherein the third table is used to represent the remaining resource status of any one of the accounts.

[0060] In a third aspect, the present application provides an electronic device, including:

[0061] A memory for storing program instructions;

[0062] The processor is used to call the program instructions stored in the memory, and execute the steps included in any one of the methods in the first aspect according to the obtained program instructions.

[0063] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and when the program instructions are executed by a computer, the computer executes any one of the methods described in the first aspect.

[0064] In a fifth aspect, the present application provides a computer program product, comprising: a computer program code, when the computer program code is run on a computer, the computer executes any one of the methods described in the first aspect. BRIEF DESCRIPTION OF THE DRAWINGS

[0065] Figure 1 A schematic diagram of an application scenario provided for an embodiment of the present application;

[0066] Figure 2 A flowchart of a table processing method provided in an embodiment of the present application;

[0067] Figure 3 A detailed flow chart of a table processing method provided in an embodiment of the present application;

[0068] Figure 4 A structural diagram of a table processing system provided in an embodiment of the present application;

[0069] Figure 5 A schematic diagram of information contained in an email provided in an embodiment of the present application;

[0070] Figure 6 A flowchart of a method for determining a mapping relationship between a first header and a second header provided in an embodiment of the present application;

[0071] Figure 7 A schematic diagram of an entry information management interface provided in an embodiment of the present application;

[0072] Figure 8 A schematic diagram of a first table provided in an embodiment of the present application;

[0073] Fig. 9 A schematic diagram of a second first table provided in an embodiment of the present application;

[0074] Fig.10 A flowchart of a method for converting a first table into a second table provided in an embodiment of the present application;

[0075] Fig.11 A schematic diagram of an asset portfolio asset table provided in an embodiment of the present application;

[0076] Fig.12 A schematic diagram of an asset portfolio holding table provided in an embodiment of the present application;

[0077] Fig.13 A schematic diagram of a currency information management interface provided in an embodiment of the present application;

[0078] Fig.14 A flowchart of a method for obtaining a second table provided in an embodiment of the present application;

[0079] Fig.15 A schematic diagram of an entry attribute information management interface provided in an embodiment of the present application;

[0080] Fig.16 A flowchart of another method for obtaining a second table provided in an embodiment of the present application;

[0081] Fig.17 A schematic diagram of a trading venue information management interface provided in an embodiment of the present application;

[0082] Fig.18 A flowchart of a method for obtaining a third table provided in an embodiment of the present application;

[0083] Fig.19 A schematic diagram of a total item information management interface provided in an embodiment of the present application;

[0084] Fig. 20 A schematic diagram of a third first table provided in an embodiment of the present application;

[0085] Fig.21 A schematic diagram of an asset portfolio net worth table provided in an embodiment of the present application;

[0086] Fig. 22 A structural diagram of a table processing device provided in an embodiment of the present application;

[0087] Fig.23 A structural diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0088] In order to make the purpose, technical scheme and advantages of the present application clearer, the technical scheme in the embodiment of the present application will be clearly and completely described below in conjunction with the drawings in the embodiment of the present application. Obviously, the described embodiment is only a part of the embodiment of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. In the absence of conflict, the embodiments in the present application and the features in the embodiments can be arbitrarily combined with each other. In addition, although the logical order is shown in the flow chart, in some cases, the steps shown or described can be performed in an order different from that here.

[0089] The terms "first" and "second" in the specification and claims of the present application and the above-mentioned drawings are used to distinguish different objects, rather than to describe a specific order. In addition, the term "comprising" and any of their variations are intended to cover non-exclusive protection. For example, a process, method, system, product or device comprising a series of steps or units is not limited to the listed steps or units, but optionally also includes steps or units that are not listed, or optionally also includes other steps or units inherent to these processes, methods, products or devices. "Multiple" in the present application can mean at least two, for example, two, three or more, and the embodiments of the present application are not limited.

[0090] The following is a description of exemplary embodiments of the present application in conjunction with the accompanying drawings, including various details of the embodiments of the present application to facilitate understanding, which should be considered as merely exemplary. Therefore, those of ordinary skill in the art should recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope of the present application. Similarly, for the sake of clarity and conciseness, the description of well-known functions and structures is omitted in the following description. It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, which should be considered as exemplary, and their purpose is only to illustrate the feasibility of the implementation of the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0091] In the technical solution of this application, the acquisition, transmission, storage, and use of data are in compliance with the requirements of relevant national laws and regulations.

[0092] Before introducing the table processing method provided in the embodiment of the present application, in order to facilitate understanding, the technical background of the embodiment of the present application is first introduced in detail below.

[0093] According to the requirements of the financial management company, it is necessary to generate real-time valuation table information of internal products of the system based on the outsourced valuation table information of the financial products, including net value, position and other information.

[0094] At present, the outsourced valuation form information is mainly sent to the valuation business personnel through offline emails. The valuation business personnel prepare the valuation form offline according to the outsourced valuation form information, and parse the valuation form to obtain the parsed data.

[0095] However, this valuation table processing method usually requires a large amount of long-term and continuous manual intervention. Manual processing is time-consuming and labor-intensive, not conducive to the requirements of automated management, and is prone to errors, resulting in low processing efficiency of the entire valuation table and low accuracy of the final analytical data obtained.

[0096] In order to solve the above problems, the present application proposes a table processing method, device, equipment and medium to realize automatic processing of valuation tables without manual intervention, thereby improving the efficiency of valuation table processing.

[0097] First reference Figure 1, which is a schematic diagram of an application scenario of an embodiment of the present application, including a collector 11 and a server 12. Among them, the collector 11 and the server 12 are connected to each other through a network, and the network can be a local area network, a wide area network, etc. The collector 11 can be a convenient device (for example: a mobile phone, a tablet, a laptop, etc.), or a personal computer (Personal Computer, PC). The server 12 can be an independent physical server, or a server cluster or a distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, and big data and artificial intelligence platforms. The collector 11 is used to collect target emails and send them to the server 12; the server 12 is used to process the first table in the attachment of the target email sent by the collector 11 to obtain a second table.

[0098] In an embodiment of the present application, the server 12 obtains the target email of any account and the attachment information in the target email collected by the collector 11; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email; if the attachment information represents that the attachment of the target email contains a table of a specified type, then a first table is obtained from the attachment of the target email; the first table is a table of a specified type, and the first table is used to characterize the resource information of any account; based on the content data corresponding to each first header in the first table, the mapping relationship between each first header and each second header in the first table is determined; based on the mapping relationship between each first header and each second header in the first table, the first table is converted into a second table, wherein the second table is used to characterize the resource distribution of any account.

[0099] Reference below Figure 2 A flowchart of a table processing method is shown to illustrate the technical solution provided by the embodiment of the present application:

[0100] Step 201, obtaining a target email and attachment information in the target email of any account;

[0101] The attachment information is used to characterize the attribute characteristics of the attachment of the target email, and includes the attachment name, attachment format, asset management plan code, asset management plan name, designated product code, designated product name and other information.

[0102] Step 202, if the attachment information indicates that the attachment of the target email contains a table of a specified type, then obtain a first table from the attachment of the target email;

[0103] Among them, the first table is a table of a specified type, and the first table is used to represent the resource information of any account. In the embodiment of the present application, the first table is a valuation table. The valuation table is a related table generated in the outsourcing business, in which the outsourcing agency penetrates the assets to the bottom layer, takes the product as the dimension, and values ​​the asset management plan, trust plan, and insurance plan every day. The outsourcing business in this embodiment, also known as the entrusted investment business, refers to the investment business model in which the entrusting party entrusts the funds to the external institution manager, and the external institution manager actively manages the funds according to the agreed scope. The entrusting party in the outsourcing business, that is, the fund provider, can be a financial institution such as a commercial bank, an insurance company, a financial company, or a corporate legal person. At present, the fund providers of outsourcing business are mainly the wealth management and proprietary funds of commercial banks. The outsourcing agency in the outsourcing business, that is, the manager and the actual investment operator of the funds, is generally a securities company, an insurance company, a fund company and a sunshine private equity. Some commercial banks also act as outsourcing investment managers at this stage. The entrusting party obtains the income of investment management in accordance with the agreement, and the manager generally charges management fees in the form of "fixed management fee rate plus excess performance sharing".

[0104] Optionally, after obtaining the target email of any account and the attachment information in the target email, the method further includes:

[0105] If the attachment information indicates that the attachment of the target email does not contain a table of the specified type, processing of the attachment of the target email is prohibited.

[0106] Step 203, determining a mapping relationship between each first header and each second header in the first table based on the content data corresponding to each first header in the first table;

[0107] Among them, each first table header in the first table includes headers such as account name, account code, currency code, exchange rate, quantity, unit cost, original currency cost, cost, and proportion of cost to net market value.

[0108] Step 204: based on the mapping relationship between each first table header and each second table header in the first table, convert the first table into the second table.

[0109] Among them, the second table is used to characterize the resource distribution of any account. In the embodiment of the present application, the second table can be an asset portfolio position table or an asset portfolio asset table. The asset portfolio position table includes the product positions listed in the product valuation table. Positions refer to the number of financial assets held by investors at a specific point in time. Financial assets can include stocks, bonds, futures, foreign exchange, gold and other forms.

[0110] In an embodiment of the present application, a target email of any account and attachment information in the target email are obtained. If the attachment information indicates that the attachment of the target email contains a table of a specified type, that is, the attachment information indicates that the attachment of the target email contains a valuation table, then the first table is obtained from the attachment of the target email. In addition, the present application determines the mapping relationship between each first header and each second header in the first table based on the content data corresponding to each first header in the first table, and converts the first table into the second table based on the mapping relationship between each first header and each second header in the first table, thereby realizing automatic processing of the valuation table without manual intervention, improving the efficiency of the valuation table processing, and improving the accuracy of the obtained second table.

[0111] The specific steps of the table processing method provided above are described in detail below. Figure 3 As shown:

[0112] Step 301, obtaining a target email of any account and attachment information in the target email.

[0113] Figure 4 A schematic diagram of a table processing system provided in an embodiment of the present application is shown in FIG. Figure 4 As shown, the table processing system includes a classification system and a real-time evaluation system. The classification system is used to classify the email based on the attachment information in the email and the set classification rules, and save the first table in the attachment that meets the set classification rules to a specified directory. The real-time evaluation system is used to obtain the first table from the specified directory and process it. If the classification fails or the saving fails, it supports scheduled reclassification or resaving.

[0114] In an embodiment of the present application, different account organization information is pre-configured, and all emails of all configured account organizations are obtained, wherein the account organization information includes an account mailbox and an account organization. Each email contains information such as the email number, account mailbox, account organization, email subject, email receiving time, attachment type, attachment name, trading venue, asset management plan information, product information, valuation date, classification status, notification status, etc. The attachment type is the format of the file in the attachment, including EXCLE (table), WORD (document), PDF (Portable Document Format, portable document format) and other types. The valuation date is the date the email is received. The classification status is the classification status of the attachment in the email, including three states, namely null value, successful classification and failed classification. The notification status is whether the real-time valuation system is notified after the attachment in the email is successfully classified, including three states, namely null value, successful notification and failed notification. The present application obtains the attachment information in the email from the information contained in the email, and the attachment information is used to characterize the attribute characteristics of the attachment of the target email.

[0115] For example, Figure 5A schematic diagram of information contained in an email provided in an embodiment of the present application, such as Figure 5 As shown, the email number in the email is "10000029", the account mailbox is "aaa@bbb.com.cn", the account organization is "10000019-Shanghai A Company", the email subject is "0W8021-2024-6-3-A Company Asset Management Plan Asset Valuation Table", the email receiving time is "2024-6-3 12:00:00", the attachment type is "EXCLE", the attachment name is "0W8021-2024-6-3-A Company Asset Management Plan Asset Valuation Table.xlsx", the trading venue is "OTC-Over-the-Counter", the asset management plan is "DFHJY1H001-A Company Asset Management Plan", the valuation date is "2024-6-3", and the classification status and notification status are empty.

[0116] Step 302 , determining whether the attachment information indicates that the attachment of the target email contains a table of a specified type, if so, executing step 303 , otherwise executing step 306 .

[0117] In the embodiment of the present application, the following method is used to determine whether the attachment information indicates that the attachment of the target email contains a table of a specified type:

[0118] If the attachment information satisfies the set classification rules, it is determined that the attachment information indicates that the attachment of the target email contains a table of the specified type; if the attachment information does not satisfy the set classification rules, it is determined that the attachment information indicates that the attachment of the target email does not contain a table of the specified type.

[0119] The above-mentioned classification rules can be set according to actual conditions. For example, the classification rules can be set to determine whether the attachment format is a set format, whether the attachment information contains the code / name of the asset management plan, whether the attachment information contains the code / name of the specified product, etc. The set format can be EXCLE.

[0120] Step 303: Obtain a first table from the attachment of the target email.

[0121] Step 304: Determine a mapping relationship between each first header and each second header in the first table based on the content data corresponding to each first header in the first table.

[0122] Among them, each first header includes a first target header, and the first target header can be a subject name.

[0123] Figure 6 A flowchart of a method for determining a mapping relationship between a first header and a second header provided in an embodiment of the present application, such as Figure 6 As shown, the above step 304 at least includes the following steps 601-602:

[0124] Step 601, matching first content data corresponding to a first target header with set entry information to determine target entry information matching the first content data;

[0125] The set entry information includes at least one entry information, each entry information includes at least a field value corresponding to the entry matching character, in addition, each entry information may also include field values ​​corresponding to other entry fields, and other entry fields may be entry code, entry name and other fields.

[0126] In the embodiment of the present application, the first content data corresponding to the first target header is matched with the entry matching characters in the set entry information to determine the target entry information matching the first content data.

[0127] Among them, the set entry information can be set according to actual conditions. This application can manage the entry information, that is, it can generate new entry information, and can also modify, delete, and query the generated entry information. Figure 7 A schematic diagram of an entry information management interface provided in an embodiment of the present application, such as Figure 7 As shown in the figure, this is a schematic diagram of the entry information management interface, which displays 10 entry information. Users can generate new entry information by clicking the "Add" button in the interface. Users can modify the generated entry information by clicking the "Reset" button on the interface. Users can delete each entry information by clicking the "Delete" button corresponding to the entry information on the interface. In addition, users can query the corresponding entry information based on part or all of the entry code, entry name and entry matching characters.

[0128] Step 602: Determine a mapping relationship between the first header and the second header based on the entry type to which the target entry information belongs.

[0129] Among them, the entry type includes a holding type and an asset type. In the embodiment of the present application, if the entry type to which the target entry information belongs is different, the mapping relationship between the first header and the second header is different. Specifically, if the entry type to which the target entry information belongs is an asset type, the mapping relationship between the first header and the second header of the first type is determined; if the entry type to which the target entry information belongs is a holding type, the mapping relationship between the first header and the second header of the second type is determined.

[0130] For example, Figure 8 A schematic diagram of the first table provided in the embodiment of the present application, such as Figure 8 As shown, the first content data corresponding to the subject name in the first table is Figure 7The entry information in the first content data is matched to determine whether the "bank deposit, current deposit account" in the first content data is Figure 7 The item matching characters of the 7th item information in the , "bank deposit@current account@custodial account" match, and the "overseas fund account" in the first content data matches Figure 7 The entry matching character "overseas funds account" of the third entry information is matched, and it is determined that the entry names in the two target entry information matching the first content data are both "current deposit account". Based on the fact that the entry type of the target entry information is an asset type, the mapping relationship between the first header and the second header of the first type is determined.

[0131] For example, Fig. 9 A schematic diagram of the second first table provided in the embodiment of the present application, such as Fig. 9 As shown, the first content data corresponding to the subject name in the first table header is matched with the set entry information, and the entry name in the target entry information matching the first content data is determined to be "Financial Assets". Based on the fact that the entry type of the target entry information is a position type, the mapping relationship between the first header and the second header of the second type is determined.

[0132] Step 305: based on the mapping relationship between each first table header and each second table header in the first table, convert the first table into the second table.

[0133] The second table is used to represent the resource distribution of any account.

[0134] Step 306: prohibit processing of the attachment of the target email.

[0135] In the embodiment of the present application, the first table is converted into the second table based on the mapping relationship between each first table header and each second table header in the first table. Fig.10 A flowchart of a method for converting a first table into a second table is provided in an embodiment of the present application, such as Fig.10 As shown, the above step 305 at least includes the following steps 101-102:

[0136] Step 101, based on the mapping relationship between each first table header and each second table header in the first table, determine the content data corresponding to each second table header from the first table;

[0137] Step 102: Obtain a second table based on each second table header and the content data corresponding to each second table header.

[0138] Since the types of mapping relationships between the first table header and the second table header are different, the second table converted from the first table based on the mapping relationship between the first table header and the second table header is also different. Therefore, if the type of mapping relationship between the first table header and the second table header is the first type, the first table is converted into the second table based on the mapping relationship between each first table header and each second table header in the first table, and the second table is the asset portfolio asset table. Fig.11 A schematic diagram of an asset portfolio asset table provided in an embodiment of the present application, such as Fig.11 As shown, the asset portfolio asset table includes 3 asset information, each asset information includes content information corresponding to different second headers, and the second header of the asset portfolio asset table includes headers such as business date, asset portfolio, currency, and exchange rate.

[0139] If the type of the mapping relationship between the first table header and the second table header is the second type, based on the mapping relationship between each first table header and each second table header in the first table, the first table is converted into a second table, and the second table is an asset portfolio position table. Fig.12 A schematic diagram of an asset portfolio holding table provided in an embodiment of the present application, such as Fig.12 As shown, the asset portfolio holding table includes 3 holding information, each holding information includes content information corresponding to different second headers, and the second header of the asset portfolio holding table includes headers such as business date, asset portfolio, asset type, trading venue, currency, and securities category.

[0140] In the embodiment of the present application, the second header can be determined as content data corresponding to the currency by the following two methods. The first method is to determine that the second header is content data corresponding to the currency based on the mapping relationship between the first header and the second header. The second method is to match the first content data corresponding to the first target header with the set currency information, determine the currency information matching the first content data, and determine that the second header is content data corresponding to the currency based on the matching currency information.

[0141] The set currency information includes at least one entry information, each of which includes at least a field value corresponding to a currency matching character. In addition, each of which may also include field values ​​corresponding to other currency fields, which may be currency names, priority fields, etc. Currency names include RMB, USD, EUR, etc.

[0142] In the embodiment of the present application, the first content data corresponding to the first target header is matched with the currency matching character in the set currency information to determine the currency information matching the first content data.

[0143] The currency information set in the second method can be set according to the actual situation. This application can manage the currency information, that is, it can generate new currency information, and can also modify, delete, and query the generated currency information. Fig.13 A schematic diagram of a currency information management interface provided in an embodiment of the present application, such as Fig.13 As shown in the figure, this is a schematic diagram of the currency information interface, which displays 6 currency information. Users can generate new currency information by clicking the "Add" button in the interface. Users can modify the generated currency information by clicking the "Reset" button on the interface. Users can delete each currency information by clicking the "Delete" button corresponding to the currency information on the interface. In addition, users can query the corresponding currency information based on part or all of the currency name and currency matching characters.

[0144] In an embodiment of the present application, if the second table is an asset portfolio holding table, before obtaining the second table, the resource type information is determined based on the first content data and the set entry attribute information, thereby obtaining the second table based on each second table header, the content data corresponding to each second table header, and the resource type information. Fig.14 A flowchart of a method for obtaining a second table provided in an embodiment of the present application is shown in FIG. Fig.14 As shown, at least the following steps 141-144 are included:

[0145] Step 141, based on the mapping relationship between each first table header and each second table header in the first table, determine the content data corresponding to each second table header from the first table;

[0146] Step 142, matching the first content data with the set item attribute information to determine target item attribute information matching the first content data;

[0147] The set item attribute information includes at least one item attribute information, each item attribute information includes at least a field value corresponding to the item attribute matching character, in addition, each item attribute information may also include field values ​​corresponding to other item attribute fields, and other item attribute fields may be item attribute code, item attribute type, item attribute type code, priority, primary and secondary direct identification mark and other fields. Item attribute types include stocks, bonds, funds, warrants, asset-backed securities and other types

[0148] In the embodiment of the present application, the first content data is matched with the attribute matching characters in the set item attribute information to determine the target item attribute information that matches the first content data.

[0149] Among them, the set entry attribute information can be set according to actual conditions. This application can manage the entry attribute information, that is, it can generate new entry attribute information, and can also modify, delete, and query the generated entry attribute information. Fig.15 A schematic diagram of an entry attribute information management interface provided in an embodiment of the present application, such as Fig.15 As shown, this is a schematic diagram of the entry attribute information management interface, on which 10 entry attribute information are displayed. Users can generate new entry attribute information by clicking the "Add" button in the interface. Users can modify the generated entry attribute information by clicking the "Reset" button on the interface. Users can delete each entry attribute information by clicking the "Delete" button corresponding to the entry attribute information on the interface. In addition, users can query the corresponding entry attribute information based on part or all of the entry attribute code, attribute name, attribute name code, attribute matching characters, and primary and secondary direct identification marks.

[0150] Step 143, determining resource type information based on the entry attribute type corresponding to the target entry attribute information;

[0151] Among them, resource type information includes stocks, bonds, funds, warrants, asset-backed securities and other types.

[0152] For example, if the first content data contains "corporate bonds" and Fig.15 If the entry attribute matching character "corporate bonds" matches in the entry attribute information, then the entry attribute information is used as the target entry attribute information, and the entry attribute type corresponding to the target entry attribute information is determined to be "bonds", therefore, the resource type information is "bonds".

[0153] Step 144: Obtain a second table based on each second header, the content data corresponding to each second header, and the resource type information.

[0154] In an embodiment of the present application, if the second table is an asset portfolio holding table, before obtaining the second table, the resource type information is determined based on the first content data and the set entry attribute information, and the target trading venue information is determined based on the first content data and the set trading venue information, thereby obtaining the second table based on each second table header, the content data corresponding to each second table header, the resource type information and the target trading venue information. Fig.16 A flowchart of another method for obtaining a second table provided in an embodiment of the present application, such as Fig.16 As shown, at least the following steps 161-165 are included:

[0155] Step 161, based on the mapping relationship between each first table header and each second table header in the first table, determine the content data corresponding to each second table header from the first table;

[0156] Step 162, matching the first content data with the set item attribute information to determine target item attribute information matching the first content data;

[0157] Step 163, determining resource type information based on the entry attribute type corresponding to the target entry attribute information;

[0158] Step 164, matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data;

[0159] The set trading venue information includes at least one piece of trading venue information, each piece of trading venue information includes at least a field value corresponding to a trading venue matching character, and in addition, each piece of trading venue information may also include field values ​​corresponding to other trading venue fields, and other trading venue fields may be fields such as trading venue name and priority. The trading venue names include Shanghai Stock Exchange, Shenzhen Stock Exchange, over-the-counter, inter-bank and other trading venues.

[0160] In the embodiment of the present application, the first content data is matched with the transaction venue matching characters in the set transaction venue information to determine the target transaction venue information that matches the first content data.

[0161] Among them, the set trading venue information can be set according to actual conditions. This application can manage the trading venue information, that is, it can generate new trading venue information, and can also modify, delete, and query the generated trading venue information. Fig.17 A schematic diagram of a trading venue information management interface provided in an embodiment of the present application, such as Fig.17 As shown in the figure, this is a schematic diagram of the trading venue information management interface, which displays 10 trading venue information. Users can generate new trading venue information by clicking the "Add" button in the interface. Users can modify the generated trading venue information by clicking the "Reset" button on the interface. Users can delete each trading venue information by clicking the "Delete" button corresponding to the trading venue information on the interface. In addition, users can query the corresponding trading venue information based on the trading venue name and part or all of the trading venue matching characters.

[0162] Step 165, obtaining a second table based on each second table header, content data corresponding to each second table header, resource type information and target transaction venue information.

[0163] In the embodiment of the present application, after the first table is obtained from the attachment of the target email, a third table for representing the remaining resource status of any account is obtained based on the first table and the set total item information. Fig.18 A flowchart of a method for obtaining a third table provided in an embodiment of the present application is shown in FIG. Fig.18 As shown, at least the following steps 181-183 are included:

[0164] Step 181, matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data;

[0165] Each first header includes a first target header and a second target header. The first target header may be a subject name, and the second target header may be a subject code. The set total item information includes at least one total item information, and each total item information includes at least a field value corresponding to a total item matching character. In addition, each total item information may also include field values ​​corresponding to other total item fields, and other total item fields may be fields such as a total item name and a total item type.

[0166] In the embodiment of the present application, the second content data corresponding to the second target header is matched with the total item matching character in the set total item information to determine the target total item information matching the second content data.

[0167] Among them, the set total item information can be set according to actual conditions. This application can manage the total item information, that is, it can generate new total item information, and can also modify, delete, and query the generated total item information. Fig.19 A schematic diagram of a total item information management interface provided in an embodiment of the present application, such as Fig.19 As shown, this is a schematic diagram of the total item information management interface, on which 10 total item information are displayed. Users can generate new total item information by clicking the "Add" button in the interface. Users can modify the generated total item information by clicking the "Reset" button on the interface. Users can delete each total item information by clicking the "Delete" button corresponding to the total item information on the interface. In addition, users can query the corresponding total item information based on the total item name, total item type and part or all of the total item matching characters.

[0168] Fig. 20 A schematic diagram of the third first table provided in the embodiment of the present application, such as Fig. 20 As shown, the first table header in the first table is the second content data corresponding to the subject code, and Fig.19 The target total item information matching the second content data is determined by matching the total item information in the second content data. Taking the "beginning unit net value" and "today's unit net value" in the second content data as an example, the "beginning unit net value" in the second content data is matched with Fig.19 The "beginning unit net value" of the fourth total item information in the second content data matches the "today's unit net value" Fig.19The "Today's Unit Net Value" of the 6th total item information matches, therefore, the 4th total item information and the 6th total item information are the target total item information.

[0169] Step 182, based on the first content data corresponding to the first target header, determine the content data corresponding to each target total item information;

[0170] Specifically, based on the first content data corresponding to the subject name in the first table header in the first table, the content data corresponding to each target total item information is determined.

[0171] For example, Fig. 20 As shown, the content data corresponding to the target total item information "beginning unit net value" is "1.01", and the content data corresponding to the target total item information "today's unit net value" is "1.02".

[0172] Step 183, obtaining a third table based on each target total item information and the content data corresponding to each target total item information.

[0173] In the embodiment of the present application, the third table is used to represent the remaining resource status of any account, and the third table may be an asset portfolio net value information table. Fig.21 A schematic diagram of an asset portfolio net worth table provided in an embodiment of the present application, such as Fig.21 As shown, the asset portfolio net worth table includes 3 net worth information, each net worth information includes content information corresponding to different headers, and the headers of the asset portfolio net worth table include business date, asset portfolio, asset portfolio number, currency, asset unit net worth, previous day unit net worth, cumulative unit net worth and other headers.

[0174] Among them, net value, also known as residual value, refers to the balance after deducting the accumulated depreciation from the original value or full replacement value of the fixed asset. The net value reflects the current value of the fixed asset after wear and tear, and the actual amount of funds occupied.

[0175] In the embodiment of the present application, the method for determining that the header in the third table is the content data corresponding to the currency is the same as the method for determining that the second header in the second table is the content data corresponding to the currency, and will not be repeated here.

[0176] Based on the same inventive concept, the present application embodiment provides a table processing device, please refer to Fig. 22 , the device comprises:

[0177] The first acquisition module 221 is used to acquire a target email of any account and attachment information in the target email; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email;

[0178] A second acquisition module 222 is configured to acquire a first table from the attachment of the target email if the attachment information indicates that the attachment of the target email contains a table of a specified type; the first table is a table of the specified type, and the first table is used to represent resource information of any one of the accounts;

[0179] A determination module 223, configured to determine a mapping relationship between each first header and each second header in the first table based on content data corresponding to each first header in the first table;

[0180] The conversion module 224 is used to convert the first table into a second table based on the mapping relationship between each first table header and each second table header in the first table, wherein the second table is used to represent the resource distribution of any one of the accounts.

[0181] As an optional implementation manner, each of the first headers includes a first target header, and the determining module 223 is used to:

[0182] Matching the first content data corresponding to the first target header with the set entry information to determine the target entry information matching the first content data;

[0183] Based on the entry type to which the target entry information belongs, a mapping relationship between the first header and the second header is determined.

[0184] As an optional implementation, the conversion module 224 is used to:

[0185] Based on the mapping relationship between each first table header and each second table header in the first table, determining the content data corresponding to each second table header from the first table;

[0186] The second table is obtained based on the second table headers and the content data corresponding to the second table headers.

[0187] As an optional implementation, before obtaining the second table, the conversion module 224 is further configured to:

[0188] Matching the first content data with set item attribute information to determine target item attribute information matching the first content data;

[0189] Determining resource type information based on the entry attribute type corresponding to the target entry attribute information;

[0190] Based on the second table headers and the content data corresponding to the second table headers, the second table is obtained, including:

[0191] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, and the resource type information.

[0192] As an optional implementation manner, before obtaining the second table, the conversion device 224 is further used for:

[0193] Matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data;

[0194] Based on the second table headers, the content data corresponding to the second table headers and the asset type information, the second table is obtained, including:

[0195] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, the resource type information and the target transaction venue information.

[0196] As an optional implementation manner, each of the first headers includes a first target header and a second target header. After obtaining the first table from the attachment of the target email, the second obtaining module 222 is further used to:

[0197] Matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data;

[0198] Determine the content data corresponding to each target total item information based on the first content data corresponding to the first target header;

[0199] Based on the target total item information and the content data corresponding to the target total item information, a third table is obtained, wherein the third table is used to represent the remaining resource status of any one of the accounts.

[0200] Based on the same inventive concept, the present application embodiment provides an electronic device, which can realize the functions of the table processing device discussed above. Please refer to Fig.23 , the device includes a processor 231 and a memory 232, wherein the memory 232 is used to store program instructions;

[0201] The processor 231 calls the program instructions stored in the memory and executes the program instructions to implement the following steps:

[0202] Obtaining a target email of any account and attachment information in the target email; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email;

[0203] If the attachment information indicates that the attachment of the target email contains a table of a specified type, obtaining a first table from the attachment of the target email; the first table is a table of the specified type, and the first table is used to represent resource information of any one of the accounts;

[0204] Determine, based on the content data corresponding to each first header in the first table, a mapping relationship between each first header and each second header in the first table;

[0205] Based on the mapping relationship between each first table header and each second table header in the first table, the first table is converted into a second table, wherein the second table is used to represent the resource distribution of any one of the accounts.

[0206] As an optional implementation manner, each of the first headers includes a first target header, and determining a mapping relationship between each of the first headers and each of the second headers in the first table based on content data corresponding to each of the first headers in the first table includes:

[0207] Matching the first content data corresponding to the first target header with the set entry information to determine the target entry information matching the first content data;

[0208] Based on the entry type to which the target entry information belongs, a mapping relationship between the first header and the second header is determined.

[0209] As an optional implementation manner, converting the first table into the second table based on the mapping relationship between each first table header and each second table header in the first table includes:

[0210] Based on the mapping relationship between each first table header and each second table header in the first table, determining the content data corresponding to each second table header from the first table;

[0211] The second table is obtained based on the second table headers and the content data corresponding to the second table headers.

[0212] As an optional implementation manner, before obtaining the second table, the processor 231 is further configured to execute:

[0213] Matching the first content data with set item attribute information to determine target item attribute information matching the first content data;

[0214] Determining resource type information based on the entry attribute type corresponding to the target entry attribute information;

[0215] Based on the second table headers and the content data corresponding to the second table headers, the second table is obtained, including:

[0216] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, and the resource type information.

[0217] As an optional implementation manner, before obtaining the second table, the processor 231 is further configured to execute:

[0218] Matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data;

[0219] Based on the second table headers, the content data corresponding to the second table headers and the asset type information, the second table is obtained, including:

[0220] The second table is obtained based on the second table headers, the content data corresponding to the second table headers, the resource type information and the target transaction venue information.

[0221] As an optional implementation manner, each of the first headers includes a first target header and a second target header. After obtaining the first table from the attachment of the target email, the processor 231 is further configured to execute:

[0222] Matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data;

[0223] Determine the content data corresponding to each target total item information based on the first content data corresponding to the first target header;

[0224] Based on the target total item information and the content data corresponding to the target total item information, a third table is obtained, wherein the third table is used to represent the remaining resource status of any one of the accounts.

[0225] Based on the same inventive concept, the embodiment of the present application provides a computer-readable storage medium, and the computer program product includes: computer program code, when the computer program code is executed on a computer, the computer executes any table processing method discussed above. Since the principle of solving the problem by the above-mentioned computer-readable storage medium is similar to that of the table processing method, the implementation of the above-mentioned computer-readable storage medium can refer to the implementation of the method, and the repeated parts will not be repeated.

[0226] Based on the same inventive concept, the embodiment of the present application further provides a computer program product, which includes: computer program code, when the computer program code is run on a computer, the computer executes any table processing method discussed above. Since the principle of solving the problem by the above computer program product is similar to that of the table processing method, the implementation of the above computer program product can refer to the implementation of the method, and the repeated parts will not be repeated.

[0227] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may 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 may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0228] 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 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 processes in the flowchart and / or block diagram. 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.

[0229] These computer program instructions may also be stored in a computer readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0230] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of user-operated steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for executing on the computer or other programmable device to implement the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0231] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A table processing method, characterized in that: The method includes: Obtaining a target email of any account and attachment information in the target email; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email; If the attachment information indicates that the attachment of the target email contains a table of a specified type, obtaining a first table from the attachment of the target email; the first table is a table of the specified type, and the first table is used to represent resource information of any one of the accounts; Determine, based on the content data corresponding to each first header in the first table, a mapping relationship between each first header and each second header in the first table; Based on the mapping relationship between each first table header and each second table header in the first table, the first table is converted into a second table, wherein the second table is used to represent the resource distribution of any one of the accounts.

2. The method according to claim 1, characterized in that Each first header includes a first target header, and determining a mapping relationship between each first header and each second header in the first table based on content data corresponding to each first header in the first table includes: Matching the first content data corresponding to the first target header with the set entry information to determine the target entry information matching the first content data; Based on the entry type to which the target entry information belongs, a mapping relationship between the first header and the second header is determined.

3. The method according to any one of claims 1 to 2, characterized in that: The converting the first table into the second table based on the mapping relationship between each first table header and each second table header in the first table includes: Based on the mapping relationship between each first table header and each second table header in the first table, determining the content data corresponding to each second table header from the first table; The second table is obtained based on the second table headers and the content data corresponding to the second table headers.

4. The method according to claim 3, characterized in that Before obtaining the second table, the method further includes: Matching the first content data with set item attribute information to determine target item attribute information matching the first content data; Determining resource type information based on the entry attribute type corresponding to the target entry attribute information; Based on the second table headers and the content data corresponding to the second table headers, the second table is obtained, including: The second table is obtained based on the second table headers, the content data corresponding to the second table headers, and the resource type information.

5. The method according to claim 4, characterized in that Before obtaining the second table, the method further includes: Matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data; Based on the second table headers, the content data corresponding to the second table headers and the asset type information, the second table is obtained, including: The second table is obtained based on the second table headers, the content data corresponding to the second table headers, the resource type information and the target transaction venue information.

6. The method according to claim 1, characterized in that Each first header includes a first target header and a second target header. After obtaining the first table from the attachment of the target email, the method further includes: Matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data; Determine the content data corresponding to each target total item information based on the first content data corresponding to the first target header; Based on the target total item information and the content data corresponding to the target total item information, a third table is obtained, wherein the third table is used to represent the remaining resource status of any one of the accounts.

7. A table processing device, characterized in that: The device includes: A first acquisition module is used to acquire a target email of any account and attachment information in the target email; wherein the attachment information is used to characterize the attribute characteristics of the attachment of the target email; a second acquisition module, configured to acquire a first table from the attachment of the target email if the attachment information indicates that the attachment of the target email contains a table of a specified type; the first table is a table of the specified type, and the first table is used to represent resource information of any one of the accounts; a determination module, configured to determine a mapping relationship between each first header and each second header in the first table based on content data corresponding to each first header in the first table; A conversion module is used to convert the first table into a second table based on a mapping relationship between each first table header and each second table header in the first table, wherein the second table is used to represent the resource distribution of any one of the accounts.

8. The device according to claim 7, characterized in that Each of the first headers includes a first target header, and the determining module is used for: Matching the first content data corresponding to the first target header with the set entry information to determine the target entry information matching the first content data; Based on the entry type to which the target entry information belongs, a mapping relationship between the first header and the second header is determined.

9. The device according to any one of claims 7 to 8, characterized in that: The conversion module is used for: Based on the mapping relationship between each first table header and each second table header in the first table, determining the content data corresponding to each second table header from the first table; The second table is obtained based on the second table headers and the content data corresponding to the second table headers.

10. The device according to claim 9, characterized in that Before obtaining the second table, the conversion module is further used for: Matching the first content data with set item attribute information to determine target item attribute information matching the first content data; Determining resource type information based on the entry attribute type corresponding to the target entry attribute information; Based on the second table headers and the content data corresponding to the second table headers, the second table is obtained, including: The second table is obtained based on the second table headers, the content data corresponding to the second table headers, and the resource type information.

11. The device according to claim 10, characterized in that Before obtaining the second table, the conversion device is further used for: Matching the first content data with the set transaction venue information to determine the target transaction venue information matching the first content data; Based on the second table headers, the content data corresponding to the second table headers and the asset type information, the second table is obtained, including: The second table is obtained based on the second table headers, the content data corresponding to the second table headers, the resource type information and the target transaction venue information.

12. The device according to claim 7, characterized in that Each first header includes a first target header and a second target header. After obtaining the first table from the attachment of the target email, the second obtaining module is further used to: Matching the second content data corresponding to the second target header with the set total item information to determine the target total item information matching the second content data; Determine the content data corresponding to each target total item information based on the first content data corresponding to the first target header; Based on the target total item information and the content data corresponding to the target total item information, a third table is obtained, wherein the third table is used to represent the remaining resource status of any one of the accounts.

13. An electronic device, characterized in that: include: A memory for storing program instructions; A processor is used to call the program instructions stored in the memory, and execute the steps included in any one of claims 1-6 according to the obtained program instructions.

14. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and when the program instructions are executed by a computer, the computer executes the method according to any one of claims 1 to 6.

15. A computer program product, characterized in that The computer program product comprises: a computer program code, and when the computer program code is run on a computer, the computer is enabled to execute the method according to any one of claims 1 to 6.

Images