Bank account query method, device, medium, product and system
By obtaining and converting business transaction type encoding, combining configurable compression cycles and compressing business types, the existing solution is solved inefficiently querying bank accounts, and efficient query and single-table access to multi-account vouchers.
Patent Information
- Application Number
- CN202411792275.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-06
- Publication Date
- 2025-04-11
AI Technical Summary
Due to the large accumulation of business volume, existing solutions are less efficient in querying bank accounts.
By obtaining the business transaction type encoding, the target business type and target transaction category are converted, and the amount is displayed according to the configurable compression cycle and compressed business type, so as to achieve single-table access to multi-account vouchers.
It improves the efficiency of bank account inquiry, enhances business flexibility, reduces data storage costs, and realizes efficient printing of multi-account vouchers.
Smart Images
Figure CN119807255A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of bank data processing technology, and in particular to a bank account query method, device, medium, product and system. Background Art
[0002] The characteristics of bank account details are massive data, stable content (final state when generated, and will not be changed except for special circumstances such as errors and corrections), and single function (almost only used for query and display). As the business volume accumulates, the access efficiency of bank account details will gradually decrease, and it is necessary to improve access efficiency. However, the distributed architecture and database and table sharding technology are all data diversion for the entire system, and cannot achieve "local" efficiency improvement only for bank account detail data.
[0003] That is, due to the large accumulation of business volume, the efficiency of existing solutions for querying bank accounts is low. Summary of the invention
[0004] The main purpose of the present application is to provide a bank account query method, device, medium, product and system to at least solve the problem of low efficiency of bank account query in existing solutions due to large accumulation of business volume.
[0005] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a bank account query method is provided, the method comprising: obtaining a business transaction type code, the business transaction type code consisting of a business type code and a transaction category code; converting the business type code to obtain a target business type, converting the transaction category code to obtain a target transaction category, the target transaction category being income or expenditure; and displaying the amount of the target transaction category of the target business type.
[0006] Optionally, the business type code is converted to obtain a target business type, including: obtaining a business type mapping relationship stored in a database, the business type mapping relationship representing a mapping relationship between a business type and the business type code: determining the target business type based on the business type mapping relationship and the business type code.
[0007] Optionally, after obtaining the business transaction type code, the method further comprises: obtaining a compression cycle code, wherein the compression cycle code represents a unique identifier of the query cycle;
[0008] Displaying the amount of the target transaction category of the target business type includes: determining a compression period according to the compression period code; and displaying the amount of the target transaction category of the target business type within the compression period.
[0009] Optionally, before obtaining the business transaction type code, the method also includes: determining the compression upper limit amount of each transaction category in all business types; when the current compression amount of the transaction category in the business type is less than or equal to the compression upper limit amount, generating a compression period code, and establishing a mapping relationship between the compression period code, the corresponding compressed business type code and the corresponding compressed transaction category code; when the transaction category in the business type is greater than the compression upper limit amount, generating multiple compression period codes, and establishing a mapping relationship between each compression period code and the corresponding compressed business type code and the corresponding compressed transaction category code.
[0010] Optionally, when the target transaction category is expenditure, the method further includes: determining the amount of the target transaction category of the target business type; when the amount of the target transaction category of the target business type is greater than a preset amount, generating a prompt message to prompt that the expenditure exceeds the limit; when the amount of the target transaction category of the target business type is less than or equal to the preset amount, determining not to generate the prompt message.
[0011] Optionally, displaying the amount of the target transaction category of the target business type includes: retrieving the amount of the target transaction category of the target business type from a database; and displaying the amount of the target transaction category of the target business type on a display device.
[0012] According to another aspect of the present application, a bank account query device is provided, the device comprising:
[0013] A first acquisition unit is used to acquire a business transaction type code, where the business transaction type code consists of a business type code and a transaction category code;
[0014] A first processing unit, configured to convert the business type code to obtain a target business type, and convert the transaction category code to obtain a target transaction category, wherein the target transaction category is income or expenditure;
[0015] The second processing unit is used to display the amount of the target transaction category of the target business type.
[0016] According to another aspect of the present application, a computer-readable storage medium is provided, wherein the computer-readable storage medium includes a stored program, wherein when the program is executed, the device where the computer-readable storage medium is located is controlled to execute any one of the methods described.
[0017] According to another aspect of the present application, a computer program product is provided, comprising a computer program, wherein when the computer program is executed by a processor, the steps of any one of the methods described are implemented.
[0018] According to another aspect of the present application, a bank account query system is provided, the system comprising: one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by the one or more processors, and the one or more programs include methods for executing any one of the methods described.
[0019] By applying the technical solution of the present application, a business transaction type code, i.e., a business type code and a transaction category code, is obtained, the business type code is converted to obtain a target business type, the transaction category code is converted to obtain a target transaction category, i.e., income or expenditure, the amount of the target transaction category of the target business type is displayed, and the business type mapping relationship stored in the database is obtained, and the target business type is determined according to the business type mapping relationship and the business type code. Compared with the existing solution, which adopts a table structure and multi-dimensional, configurable compression cycle and compressed business type, it is more in line with the characteristics of vouchers, ensures that the fields are streamlined and efficient, realizes single-table access for printing multi-account vouchers, enhances business flexibility, and thus solves the problem of low efficiency of bank account query in the existing solution due to the large accumulation of business volume. BRIEF DESCRIPTION OF THE DRAWINGS
[0020] The drawings constituting part of the present application are used to provide a further understanding of the present application. The illustrative embodiments and descriptions of the present application are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:
[0021] Figure 1 A schematic diagram showing a flow chart of a bank account query method provided according to an embodiment of the present application;
[0022] Figure 2 A schematic diagram showing a flow chart of another bank account query method provided according to an embodiment of the present application;
[0023] Figure 3 A structural block diagram of a bank account query device provided according to an embodiment of the present application is shown. DETAILED DESCRIPTION
[0024] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.
[0025] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.
[0026] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present application described here. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0027] For the convenience of description, some nouns or terms involved in the embodiments of the present application are explained below:
[0028] Account details: information on fund changes during transactions in an account opened by an individual or corporate customer at a bank, including deposits, withdrawals, fees, interest, etc.
[0029] Multi-account voucher: A bank voucher that can be used to open multiple accounts.
[0030] Compression: The bank current account details that have not been printed for a certain period of time are summarized into a data that only records the first and last detailed fund information within the time period. The compressed original detailed data is usually moved from the production database to the historical database for future reference.
[0031] As introduced in the background technology, the distributed architecture and sub-library and sub-table technologies in the prior art are all data diversion for the entire system, and cannot achieve "local" efficiency improvement only for bank account detail data. In order to solve the problem of low efficiency of existing solutions for querying bank accounts due to the large accumulation of business volume, the embodiments of the present application provide a bank account query method, device, medium, product and system.
[0032] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the accompanying drawings in the embodiments of the present invention.
[0033] In this embodiment, a method for querying a bank account is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.
[0034] Figure 1 FIG. 1 is a flow chart of a bank account query method provided according to an embodiment of the present application. Figure 1 As shown, the method comprises the following steps:
[0035] Step S101, obtaining a business transaction type code, the business transaction type code consisting of a business type code and a transaction category code;
[0036] Specifically, in the process of obtaining the business transaction type code, the business transaction type code may be obtained by the user inputting the business transaction type code. The business transaction type code is obtained by the user inputting the business transaction type code on the interactive screen.
[0037] After obtaining the business transaction type code in step S101, the method further includes: obtaining a compression cycle code, the compression cycle code representing a unique identifier of a query cycle;
[0038] Displaying the amount of the above-mentioned target transaction category of the above-mentioned target business type includes: determining the compression period according to the above-mentioned compression period code; and displaying the amount of the above-mentioned target transaction category of the above-mentioned target business type within the above-mentioned compression period.
[0039] Specifically, first, the compression cycle is implemented by means of parameter configuration. You can configure global unified parameters, or you can add dimensions and configure different parameters to achieve flexible compression and sub-task compression schemes. Then, you get the compression cycle code, determine the compression cycle, and use the method of summarizing the amount within a certain time range to remove unnecessary detailed information and retain the amount information that customers are most concerned about, thereby reducing the amount of data and reducing data storage costs.
[0040] In one embodiment of the present application, before obtaining the business transaction type code, the method further includes:
[0041] Determine the compression ceiling amount for each transaction category in all business types;
[0042] The relationship between the current compressed amount and the compressed upper limit amount of the transaction category in the business type can be compared through the mapping relationship between the compressed upper limit amount and the transaction category pre-stored in the database.
[0043] When the current compressed amount of the transaction category in the business type is less than or equal to the compressed upper limit amount, a compression period code is generated, and a mapping relationship is established between the compression period code, the corresponding compressed business type code and the corresponding compressed transaction category code;
[0044] When the amount of the transaction category in the business type is greater than the compression upper limit amount, multiple compression period codes are generated, and a mapping relationship is established between each of the compression period codes and the corresponding compression business type code and the corresponding compression transaction category code.
[0045] Specifically, when the current compressed amount of the above-mentioned transaction category in the above-mentioned business type is less than or equal to the above-mentioned compression upper limit amount, it is determined that multiple compressions are not required, and only one compression cycle code needs to be generated, and a mapping relationship is established between the above-mentioned compression cycle code, the corresponding compressed business type code and the corresponding compressed transaction category code, and the mapping relationship is stored in the database; when the above-mentioned transaction category in the above-mentioned business type is greater than the above-mentioned compression upper limit amount, it is determined that multiple compressions are required, that is, multiple compression cycle codes need to be generated, and a mapping relationship is established between each of the above-mentioned compression cycle codes and the corresponding compressed business type code and the corresponding compressed transaction category code, and the mapping relationship is stored in the database.
[0046] By setting the upper limit amount for compression and building a mapping relationship, the number and length of compression cycles can be reasonably controlled, further optimizing the data structure and query performance.
[0047] Step S102, converting the business type code to obtain a target business type, converting the transaction category code to obtain a target transaction category, where the target transaction category is income or expenditure;
[0048] In one embodiment of the present application, the step S102 of converting the service type code to obtain the target service type includes:
[0049] Obtaining a business type mapping relationship stored in a database, wherein the business type mapping relationship represents a mapping relationship between a business type and the business type code;
[0050] By pre-storing the mapping relationship between the business type and the business type code in the database, it is convenient to find the business type corresponding to the business type code from the mapping relationship between the business type and the business type code, and use the business type as the target business type.
[0051] The target service type is determined according to the service type mapping relationship and the service type code.
[0052] Specifically, first, access the account details database with a single table, and obtain the business transaction type code according to the database query logic. By establishing database tables according to the voucher type for the account details, the query process of the business transaction type is simplified, which provides convenience for subsequent processing. The transaction category code is converted to obtain the target transaction category, that is, income or expenditure. It is clear that the nature of the transaction is income or expenditure, which helps users to understand the changes in funds in the account more clearly. The business type code is converted to obtain the target business type, and then the business type mapping relationship stored in the database is obtained. The relationship represents the mapping relationship between the business type and the business type code. Finally, according to the above business type mapping relationship and the above business type code, the above target business type is determined. Through the mapping relationship, the specific type of business transaction can be quickly and accurately identified, which provides a basis for subsequent transaction category conversion and amount display.
[0053] Similarly, the conversion of the above-mentioned transaction category code to obtain the target transaction category in step S102 is also through the mapping relationship between the transaction category code and the transaction category pre-stored in the database, so as to facilitate the subsequent finding of the target transaction category corresponding to the transaction category code from the mapping relationship between the transaction category code and the transaction category.
[0054] Step S103, displaying the amount of the target transaction category of the target business type.
[0055] In the above steps, the business transaction type code, that is, the business type code and the transaction category code, is obtained, the business type code is converted to obtain the target business type, the transaction category code is converted to obtain the target transaction category, that is, income or expenditure, the amount of the target transaction category of the target business type is displayed, and the business type mapping relationship stored in the database is obtained. The target business type is determined according to the business type mapping relationship and the business type code. Compared with the existing solution, the table structure and multi-dimensional, configurable compression cycle and compressed business type are adopted, which is more in line with the characteristics of the voucher, ensures the simplicity and efficiency of the fields, realizes single-table access for printing multi-account vouchers, enhances business flexibility, and thus solves the problem of low efficiency of querying bank accounts in the existing solution due to the large accumulation of business volume.
[0056] The compressed periodic table is shown in Table 1.
[0057] Table 1
[0058]
[0059]
[0060] Currently, the compression period of the 11000013 agency and its subordinate agencies is configured to be 3 days. When performing the end-of-day tasks, the provincial agency will compress the details of the past 3 days.
[0061] In multi-dimensional configuration, if a single dimension is selected, such as by province, the system will configure each province to have a different compression cycle, and the end-of-day compression task will be divided into multiple subtasks according to the province (the same applies to multi-dimensional configuration, such as by institution and voucher type, the system will divide the subtasks accordingly). The execution process of each subtask is as follows:
[0062] 1) Get the compression cycle of the current province;
[0063] 2) Filter out the account details data opened in the current province that exceed the compression period, summarize the fund information according to the deposit and access direction, compress it into one piece of data and store it in the account details table, and mark it with a compression mark;
[0064] 3) Migrate the compressed original account details to the historical database for future reference.
[0065] The compressed service type table is shown in Table 2.
[0066] Table 2
[0067] Compression service type code busType001 busType002 busType003 Compression service type 1-Salary and Compensation 2- Consumption and shopping 3-Payment Compressed transaction categories income expenditure expenditure Compression upper limit amount 1000 500 200 Reduce the lower limit amount 0 0 0 Compressed cycle encoding cyc001 cyc002 cyc003
[0068] In one embodiment of the present application, when the target transaction category is expenditure, the method further includes:
[0069] Determine the amount of the above target transaction category for the above target business type;
[0070] When the amount of the above target transaction category of the above target business type is greater than the preset amount, a prompt message is generated to prompt that the expenditure exceeds the limit;
[0071] When the amount of the target transaction category of the target business type is less than or equal to the preset amount, it is determined not to generate the prompt information.
[0072] Specifically, the overspending reminder function can help users discover and control account spending in a timely manner to avoid excessive consumption or capital loss.
[0073] The preset amount can be stored in the data for each transaction category, so that prompts can be given based on actual consumption later to prevent users from spending beyond their budget.
[0074] In one embodiment of the present application, the amount of the target transaction category of the target business type is displayed, including:
[0075] Retrieving the amount of the above target transaction category of the above target business type from the database;
[0076] The amount of the target transaction category of the target business type is displayed on the display device.
[0077] Specifically, through the function of retrieving and displaying the amount from the database, the changes in funds in the account can be reflected in real time and accurately, providing users with convenient query services.
[0078] It is precisely because the amount of each transaction category is pre-stored in the data that the purpose of retrieving the amount of the above-mentioned target transaction category of the above-mentioned target business type from the database can be achieved. After finding the amount, the amount of the above-mentioned target transaction category of the target business type can be displayed on the display screen for the user to know.
[0079] In order to enable those skilled in the art to more clearly understand the technical solution of the present application, the implementation process of the bank account query method of the present application will be described in detail below in conjunction with specific embodiments.
[0080] This embodiment relates to a specific bank account query method, such as Figure 2 As shown, the following steps are included:
[0081] Get the business transaction type code, which consists of the business type code and the transaction category code;
[0082] After obtaining the business transaction type code, obtain the compression cycle code, which represents the unique identifier of the query cycle;
[0083] The business type code is converted to obtain the target business type, and the transaction category code is converted to obtain the target transaction category, where the target transaction category is income or expenditure;
[0084] Specifically, a business type mapping relationship stored in a database is obtained, where the business type mapping relationship represents a mapping relationship between a business type and a business type code;
[0085] Determine the target service type based on the service type mapping relationship and service type code.
[0086] Displays the amount of the target transaction category of the target business type;
[0087] Before obtaining the business transaction type code, determine the compression upper limit amount of each transaction category in all business types;
[0088] When the current compressed amount of the transaction category in the business type is less than or equal to the compressed upper limit amount, a compression period code is generated, and a mapping relationship is established between the compression period code, the corresponding compressed business type code and the corresponding compressed transaction category code;
[0089] When the transaction category in the business type is greater than the compression upper limit amount, multiple compression period codes are generated, and a mapping relationship is established between each compression period code and the corresponding compression business type code and the corresponding compression transaction category code.
[0090] It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and that, although a logical order is shown in the flowcharts, in some cases, the steps shown or described can be executed in an order different from that shown here.
[0091] The embodiment of the present application also provides a bank account query device. It should be noted that the bank account query device of the embodiment of the present application can be used to execute the query method for bank accounts provided by the embodiment of the present application. The device is used to implement the above-mentioned embodiments and preferred implementation modes, and the descriptions thereof will not be repeated. As used below, the term "module" can implement a combination of software and / or hardware of a predetermined function. Although the device described in the following embodiments is preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceived.
[0092] The following is an introduction to the bank account query device provided in the embodiment of the present application.
[0093] Figure 3 1 is a structural block diagram of a bank account query device provided according to an embodiment of the present application. Figure 3 As shown, the device comprises:
[0094] A first acquisition unit 31 is used to acquire a business transaction type code, where the business transaction type code consists of a business type code and a transaction category code;
[0095] The first processing unit 32 is used to convert the business type code to obtain a target business type, and convert the transaction category code to obtain a target transaction category, where the target transaction category is income or expenditure;
[0096] The second processing unit 33 is used to display the amount of the target transaction category of the target business type.
[0097] In the above-mentioned device, a business transaction type code, i.e., a business type code and a transaction category code, is obtained, the business type code is converted to obtain a target business type, the transaction category code is converted to obtain a target transaction category, i.e., income or expenditure, the amount of the target transaction category of the target business type is displayed, and the business type mapping relationship stored in the database is obtained, and the target business type is determined according to the business type mapping relationship and the business type code. Compared with the existing solution, which adopts a table structure and multi-dimensional, configurable compression cycle and compressed business type, it is more in line with the characteristics of the voucher, ensures that the fields are streamlined and efficient, realizes single-table access for printing multi-account vouchers, enhances business flexibility, and thus solves the problem of low efficiency of querying bank accounts in the existing solution due to the large accumulation of business volume.
[0098] In one embodiment of the present application, the first processing unit includes an acquisition module and a first determination module.
[0099] The acquisition module is used to acquire the business type mapping relationship stored in the database, where the business type mapping relationship represents the mapping relationship between the business type and the business type code;
[0100] The first determination module is used to determine the target service type according to the service type mapping relationship and the service type code.
[0101] In one embodiment of the present application, the apparatus further includes a second acquisition unit, which is used to acquire a compression period code after acquiring the business transaction type code, wherein the compression period code represents a unique identifier of the query period;
[0102] The second processing unit includes a second determining module and a display module. The second determining module is used to determine the compression period according to the compression period code; the display module is used to display the amount of the target transaction category of the target business type within the compression period.
[0103] In one embodiment of the present application, the apparatus further includes a first determining unit, a first generating unit, and a second generating unit, wherein the first determining unit is used to determine the compression upper limit amount of each transaction category in all business types before obtaining the business transaction type code;
[0104] The first generating unit is used for generating a compression period code when the current compression amount of the transaction category in the business type is less than or equal to the compression upper limit amount, and establishing a mapping relationship between the compression period code, the corresponding compression business type code and the corresponding compression transaction category code;
[0105] The second generating unit is used to generate multiple compression period codes when the above transaction category in the above business type is greater than the above compression upper limit amount, and to establish a mapping relationship between each of the above compression period codes and the corresponding compression business type code and the corresponding compression transaction category code.
[0106] In one embodiment of the present application, the above-mentioned device further includes a second determining unit, a third generating unit and a third determining unit.
[0107] The second determining unit is used to determine the amount of the target transaction category of the target business type when the target transaction category is expenditure;
[0108] The third generating unit is used for generating a prompt message to prompt that the expenditure exceeds the limit when the amount of the target transaction category of the target business type is greater than the preset amount;
[0109] The third determining unit is used to determine not to generate the prompt information when the amount of the target transaction category of the target business type is less than or equal to the preset amount.
[0110] In one embodiment of the present application, the second processing unit includes a calling module and a processing module;
[0111] The retrieval module is used to retrieve the amount of the above target transaction category of the above target business type from the database;
[0112] The processing module is used to display the amount of the above target transaction category of the above target business type on the display device.
[0113] The bank account query device includes a processor and a memory. The first acquisition unit, the first processing unit, the second processing unit, etc. are all stored in the memory as program units, and the processor executes the program units stored in the memory to implement corresponding functions. The modules are all located in the same processor; or, the modules are located in different processors in any combination.
[0114] The processor includes a kernel, which retrieves the corresponding program unit from the memory. One or more kernels can be set, and the kernel parameters can be adjusted to solve the problem of low efficiency of bank account query in existing solutions due to large accumulation of business volume.
[0115] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM, and the memory includes at least one memory chip.
[0116] An embodiment of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium includes a stored program, wherein when the program is executed, the device where the computer-readable storage medium is located is controlled to execute the bank account query method.
[0117] An embodiment of the present invention provides a computer program product, including a computer program, which implements the steps of any one of the above-mentioned bank account query methods when executed by a processor.
[0118] The embodiment of the present invention provides a bank account query system, which includes: one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the one or more programs include a query method for executing any of the above bank accounts. Obtain a business transaction type code, that is, a business type code and a transaction category code, convert the business type code to obtain a target business type, convert the transaction category code to obtain a target transaction category, that is, income or expenditure, display the amount of the target transaction category of the target business type, and obtain the business type mapping relationship stored in the database, determine the target business type according to the business type mapping relationship and the business type code, and use a table structure and multi-dimensional, configurable compression cycle and compressed business type compared to the existing solution, so as to better fit the voucher characteristics, ensure the field is streamlined and efficient, realize single-table access for printing multi-account vouchers, enhance business flexibility, and thus solve the problem of low efficiency of bank account query in the existing solution due to the large accumulation of business volume.
[0119] Obviously, those skilled in the art should understand that the above modules or steps of the present invention can be implemented by a general computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, they can be implemented by a program code executable by a computing device, so that they can be stored in a storage device and executed by the computing device, and in some cases, the steps shown or described can be executed in a different order than here, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. Thus, the present invention is not limited to any specific combination of hardware and software.
[0120] 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.
[0121] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate 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.
[0122] 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.
[0123] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing 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.
[0124] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0125] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.
[0126] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.
[0127] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.
[0128] From the above description, it can be seen that the above embodiments of the present application achieve the following technical effects:
[0129] 1) The bank account query method of the present application obtains the business transaction type code, that is, the business type code and the transaction category code, converts the business type code to obtain the target business type, converts the transaction category code to obtain the target transaction category, that is, income or expenditure, displays the amount of the target transaction category of the target business type, and obtains the business type mapping relationship stored in the database, determines the target business type according to the business type mapping relationship and the business type code, and is more in line with the characteristics of the voucher than the existing solution which adopts a table structure and multi-dimensional, configurable compression cycle and compressed business type, thereby ensuring that the fields are streamlined and efficient, realizing single-table access for printing multi-account vouchers, enhancing business flexibility, and thereby solving the problem of low efficiency of bank account query in the existing solution due to the large accumulation of business volume.
[0130] 2) The bank account query device of the present application obtains the business transaction type code, that is, the business type code and the transaction category code, converts the business type code to obtain the target business type, converts the transaction category code to obtain the target transaction category, that is, income or expenditure, displays the amount of the target transaction category of the target business type, and obtains the business type mapping relationship stored in the database, determines the target business type according to the business type mapping relationship and the business type code, and compared with the existing solution using table structure and multi-dimensional, configurable compression cycle and compressed business type, it is more in line with the characteristics of vouchers, ensures that the fields are streamlined and efficient, realizes single-table access for printing multi-account vouchers, enhances business flexibility, and thus solves the problem of low efficiency of bank account query in the existing solution due to the large accumulation of business volume.
[0131] The above description is only the preferred embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims
1. A bank account query method, characterized in that: include: Obtaining a business transaction type code, wherein the business transaction type code is composed of a business type code and a transaction category code; The business type code is converted to obtain a target business type, and the transaction category code is converted to obtain a target transaction category, where the target transaction category is income or expenditure; Displays the amount of the target transaction category of the target business type.
2. The method according to claim 1, characterized in that Converting the service type code to obtain a target service type includes: Acquire a service type mapping relationship stored in a database, wherein the service type mapping relationship represents a mapping relationship between a service type and the service type code; The target service type is determined according to the service type mapping relationship and the service type code.
3. The method according to claim 1, characterized in that After obtaining the business transaction type code, the method further includes: obtaining a compression cycle code, wherein the compression cycle code represents a unique identifier of the query cycle; Displaying the amount of the target transaction category of the target business type includes: determining a compression period according to the compression period code; and displaying the amount of the target transaction category of the target business type within the compression period.
4. The method according to claim 1, characterized in that: Before obtaining the business transaction type code, the method further includes: Determine the compression ceiling amount for each transaction category in all business types; When the current compressed amount of the transaction category in the business type is less than or equal to the compressed upper limit amount, a compression period code is generated, and a mapping relationship is established between the compression period code, the corresponding compressed business type code and the corresponding compressed transaction category code; When the transaction category in the business type is greater than the compression upper limit amount, a plurality of compression period codes are generated, and a mapping relationship is established between each compression period code and a corresponding compression business type code and a corresponding compression transaction category code.
5. The method according to claim 1, characterized in that In the case where the target transaction category is expenditure, the method further includes: determining the amount of the target transaction category of the target business type; When the amount of the target transaction category of the target business type is greater than a preset amount, a prompt message is generated to prompt that the expenditure exceeds the limit; When the amount of the target transaction category of the target business type is less than or equal to the preset amount, it is determined not to generate the prompt information.
6. The method according to claim 1, characterized in that Display the amount of the target transaction category of the target business type, including: Retrieving the amount of the target transaction category of the target business type from a database; The amount of the target transaction category of the target business type is displayed on a display device.
7. A bank account query device, characterized in that: include: A first acquisition unit is used to acquire a business transaction type code, where the business transaction type code consists of a business type code and a transaction category code; A first processing unit, configured to convert the business type code to obtain a target business type, and convert the transaction category code to obtain a target transaction category, wherein the target transaction category is income or expenditure; The second processing unit is used to display the amount of the target transaction category of the target business type.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored program, wherein when the program is executed, the device where the computer-readable storage medium is located is controlled to execute the method according to any one of claims 1 to 6.
9. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.
10. A bank account inquiry system, characterized in that: include: One or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by the one or more processors, and the one or more programs include methods for executing any one of claims 1 to 6.