CN112036999A - Method and device for inquiring balance information of accounting subject - Google Patents
Method and device for inquiring balance information of accounting subject Download PDFInfo
- Publication number
- CN112036999A CN112036999A CN202010908603.7A CN202010908603A CN112036999A CN 112036999 A CN112036999 A CN 112036999A CN 202010908603 A CN202010908603 A CN 202010908603A CN 112036999 A CN112036999 A CN 112036999A
- Authority
- CN
- China
- Prior art keywords
- accounting
- balance
- accounting subject
- subject
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000012216 screening Methods 0.000 claims abstract description 15
- 238000004590 computer program Methods 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 13
- 238000012545 processing Methods 0.000 description 8
- 238000012423 maintenance Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 238000009825 accumulation Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a method and a device for inquiring balance information of accounting subjects, wherein the method comprises the following steps: acquiring an accounting balance inquiry request of a target service; inquiring a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set according to an accounting subject balance inquiry request of a target service; analyzing the inquired accounting subject element rules to generate an inquiry program executable by the account accounting system; and screening the balance of the accounting subject based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request. The invention constructs an accounting subject element rule set comprising a plurality of accounting subject element rules aiming at different business scene requirements, and can flexibly configure an accounting subject inquiry interface so as to realize the purpose of inquiring the balance of the accounting subject in different business scenes.
Description
Technical Field
The invention relates to the field of software systems, in particular to a method and a device for inquiring balance information of accounting subjects.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
An accounting subject balance inquiry interface is a bottom layer public interface which is called most frequently in an accounting system, and most of business processing depends on the accounting subject balance, such as daily calculation increase, information, company actions and the like, and such as a position holding subject balance, an estimated increase subject balance, a interest account balance and the like which are required to be acquired for sale transaction or due expiration of a single bond.
Because the balance of accounting subjects required by different business scenes is different, some need to hold stocks, some need to pay interest for bonds, and even some need to hold the stocks in full quantity, the rules for screening the accounting subjects required by different business scenes are different; and the subject systems under different accounting criteria are different.
In the prior art, for products classified according to the same accounting criterion, a separate accounting subject balance query program needs to be developed for each service scene, and the way of repeatedly developing the subject balance query interface has the technical problems of high code redundancy, time and labor waste in development and testing and large maintenance workload.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides an accounting subject balance information query method, which is used for solving the technical problem that the code maintenance amount and redundancy are high due to the fact that different accounting subject balance query interfaces are required to be repeatedly developed aiming at different business scenes when an existing account accounting system queries accounting subject queries, and the method comprises the following steps: acquiring an accounting balance inquiry request of a target service; inquiring a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set according to an accounting subject balance inquiry request of a target service; analyzing the inquired accounting subject element rules to generate an inquiry program executable by the account accounting system; and screening the balance of the accounting subject based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
The embodiment of the invention also provides an accounting subject balance information inquiry device, which is used for solving the technical problem that the code maintenance amount and redundancy are high because the existing account accounting system needs to repeatedly develop different accounting subject balance inquiry interfaces aiming at different business scenes when inquiring accounting subject, and the device comprises: the query request module is used for acquiring an accounting balance query request of a target service; the accounting subject element rule query module is used for querying a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set according to an accounting subject balance query request of a target service; the accounting subject element rule analysis module is used for analyzing the inquired accounting subject element rules and generating an inquiry program executable by the account accounting system; and the accounting subject element rule screening module is used for screening the balance of the accounting subject based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
The embodiment of the invention also provides computer equipment for solving the technical problem that the code maintenance amount and redundancy are high due to the fact that different accounting balance inquiry interfaces need to be repeatedly developed aiming at different business scenes when the existing account accounting system inquires the accounting balance.
The embodiment of the invention also provides a computer readable storage medium, which is used for solving the technical problem that the code maintenance amount and the redundancy are high due to the fact that different accounting balance inquiry interfaces are required to be repeatedly developed aiming at different business scenes when the existing account accounting system inquires the accounting balance information.
In the embodiment of the invention, after an accounting balance inquiry request of a target service is obtained, according to the accounting balance inquiry request of the target service, a corresponding accounting element rule is inquired from a pre-constructed accounting element rule set, the inquired accounting element rule is analyzed, an inquiry program executable by an account accounting system is generated, then based on the generated inquiry program, the accounting balance is screened to obtain the accounting balance inquired by the accounting balance inquiry request, compared with the technical scheme of repeatedly developing different accounting balance inquiry interfaces for different service scenes in the prior art, the embodiment of the invention constructs an accounting element rule set comprising a plurality of accounting element rules aiming at different service scene requirements, and can flexibly configure the accounting inquiry interface, the purpose of inquiring the balance of the accounting subject under different business scenes is achieved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a flowchart of a method for querying balance information of accounting subjects provided in an embodiment of the present invention;
fig. 2 is a flowchart illustrating a specific implementation of an alternative method for querying balance information of an accounting subject according to an embodiment of the present invention;
fig. 3 is a schematic diagram of an apparatus for inquiring balance information of accounting subjects according to an embodiment of the present invention;
fig. 4 is a schematic diagram of an alternative device for inquiring balance information of accounting subjects provided in the embodiment of the present invention;
fig. 5 is a schematic diagram of a computer device provided in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
The embodiment of the invention provides an accounting subject balance information query method, and fig. 1 is a flow chart of the accounting subject balance information query method provided in the embodiment of the invention, as shown in fig. 1, the method comprises the following steps:
s101, acquiring an accounting balance inquiry request of the target business.
It should be noted that, the target service in the embodiment of the present invention refers to any service that performs service processing depending on the balance of accounting subject, and may be, but is not limited to: accrual services, interest-bearing services, transaction services for single bonds, etc. The balance inquiry request of the accounting subject acquired in S101 may be automatically initiated by the service system, or triggered after a certain operation is manually performed.
Since the accounting system criteria of different products and the accounting factors of each product under different accounting system criteria are different, the acquired accounting balance query request in S101 at least includes: classification code and accounting system classification. Optionally, the accounting balance query request may further include: investment product variety, financial asset classification, etc. Selecting rules according to input investment varieties and financial asset classification to support each batch processing requirement of the accounting financial system; the business rules of ticket acquisition but ticket inquiry can be matched with the business rules of incoming tickets, so that the inquiry requirement of ticket trading is supported.
S102, according to the accounting balance inquiry request of the target business, inquiring the corresponding accounting element rule from the pre-constructed accounting element rule set.
It should be noted that, in the embodiment of the present invention, the accounting element rule set may be an accounting rule summarized by continuously accumulating experiences in the construction process of the accounting system, and the accounting rule set is a general rule and can cover query requests of most services of the system; however, for a full-product accounting system, the requirement of personalized inquiry is inevitable, and some self-defined configured accounting subject rules can be added on the basis of an accounting subject rule set by an interface calling party.
Typically, accounting element rules consist of multiple phrases: the [ accounting element ] is equal to the [ value ], [ accounting element ] is not equal to the [ value ], the [ accounting element ] is not contained, the [ accounting element ] can be in various values [ value 1] [ value 2] [ value 3], and the like, and a plurality of phrases are in a parallel relationship. In the embodiment of the invention, by combing managed accounting service scenes, the rule set of the element factors of the accounting subjects, such as position-taking subjects, estimation and increase subjects, price-overflowing subjects and the like, is sorted out aiming at different scenes; under each classification code, performing finer-grained division according to product types, security varieties, financial asset classifications and the like; the more detailed the classification here, the more scenes can be supported by permutation and combination, and the smaller the data redundancy.
Before executing the above S102, the method for querying balance information of accounting subjects provided in the embodiment of the present invention may further include the following steps: configuring a plurality of accounting element rules; and generating an accounting subject element rule set according to the configured plurality of accounting element rules. The number of accounting element rules contained in the accounting subject element rule set determines the flexibility of accounting subject balance inquiry.
Optionally, after configuring the accounting element rules, the business classification code, the accounting system classification, the investment variety and the financial asset classification corresponding to each accounting element rule may be further configured, so as to query each accounting element rule in the accounting subject element rule set based on the business classification code, the accounting system classification, the investment variety and the financial asset classification. In the embodiment of the invention, the accounting subject element rules are designed from multiple dimensions, so that batch and single-coupon transaction can be supported, and the user-defined configuration of the accounting subject element rules is supported, thereby greatly improving the wide applicability of accounting subject inquiry and supporting the personalized requirements of an interface calling party.
S103, analyzing the inquired accounting subject element rule to generate an inquiry program executable by the account accounting system.
In an embodiment, the request for inquiring balance of accounting department may further include: if the user defines the configured accounting item element rule by self, the method for inquiring the balance information of the accounting item provided by the embodiment of the invention may further include the following steps: acquiring accounting subject element rules configured by a user in a self-defined manner; and analyzing the accounting subject element rules configured by the user definition to generate an inquiry program executable by the account accounting system.
It should be noted that the queried accounting key element rule and the user-defined configured accounting key element rule have the same syntax, so that the above-mentioned S103 may parse the queried accounting key element rule into the query program executable by the account accounting system, or may parse the user-defined configured accounting key element rule into the query program executable by the account accounting system.
Optionally, in the embodiment of the present invention, the query program executable by the account accounting system is an SQL query statement.
And S104, screening the balance of the accounting subject based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
The balance inquiry is the bottommost layer, the most basic and the most extensive requirements of the accounting system, and the processing of each service needs to be driven by the account balance inquiry result.
As can be seen from the above, the embodiment of the present invention provides an accounting subject balance information query method, after acquiring an accounting subject balance query request of a target service, according to the accounting subject balance query request of the target service, querying a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set, analyzing the queried accounting subject element rule, generating a query program executable by an account accounting system, and then screening the accounting subject balance based on the generated query program to obtain the accounting subject balance requested to be queried by the accounting subject balance query request.
By the method for inquiring the balance information of the accounting subjects, provided by the embodiment of the invention, aiming at different business scene requirements, an accounting subject element rule set comprising a plurality of accounting subject element rules is constructed, and an accounting subject inquiry interface can be flexibly configured, so that the purpose of inquiring the balance of the accounting subjects in different business scenes is realized.
Fig. 2 is a flowchart illustrating a specific implementation of an optional method for querying balance information of an accounting subject provided in an embodiment of the present invention, as shown in fig. 2, the method specifically includes the following steps:
the accounting element rule is composed of a plurality of phrases: the [ accounting element ] is equal to the [ value ], [ accounting element ] is not equal to the [ value ], the [ accounting element ] is not contained, the [ accounting element ] can be in various values [ value 1] [ value 2] [ value 3] and the like, and multiple phrases are in a parallel relationship; the user-defined rules (i.e. the accounting element rules configured by the user in a user-defined way) adopt the same grammar with the inquired accounting element rules in the accounting element rule set, so that the parser can parse the received accounting element rules and the user-defined rules;
a business rule set is a set of accounting element rules. Firstly, the business rule set is classified by classification codes, and the classification codes include: position holding, estimation and increase, interest collection, price overflow, price equity accumulation and the like; because accounting criteria of different products and accounting factors of various investment varieties under different criteria are different, the business rule set is configured from various dimensions such as accounting system classification, investment varieties, financial asset classification and the like besides classification codes;
the inquiry request must have information that can discern definite classification code and accounting system classification, conditions such as investment variety, financial asset classification are optional items in the request, if not, return to the complete set; the inquiry request also supports the input of a single security and the automatic acquisition of investment varieties, so that the interface can simultaneously meet the requirements of batch and single transaction; if the query request is a specific scene, allowing a user to input a custom rule of the specific scene, for example, when the user needs to acquire a new stock for warehouse splitting in the market circulation, the custom rule should be transmitted to an accounting element rule representing the new stock;
fourthly, after receiving the query request, the rule selector collectively screens out one or more accounting element rules meeting the requirements from the business rules according to the conditions of classification codes, accounting system classification, investment varieties, financial asset classification and the like in the query request;
the rule parser receives the rules of the accounting elements screened by the rule selector, and parses the rules into executable query programs for screening accounting subjects, such as executable SQL query statements and the like, together with the user-defined rules in the query request;
sixthly, the filter screens the balance of the accounting subject by using the query program to finally obtain the balance record of the accounting subject requested to be queried by the query request.
The above-mentioned processes related to the business rule set, if the accounting element rule in the business rule set is not used, only the accounting element rule configured by user-defined can be selected, and analyzed and inquired.
As can be seen from the above, the method for querying balance information of accounting subjects provided in the embodiments of the present invention provides a concept of an accounting subject rule set, places the variables of the accounting subject rules in a configuration table, and designs a matching query device and a matching parser, so that corresponding accounting subject rules can be flexibly selected and analyzed to filter out the balance of the accounting subjects for different scenes and different products, thereby satisfying query requirements of batch and single voucher, acquiring requirements of position holding, accretion, information, and the like, and simultaneously supporting requirements of product types of different accounting criteria, which provides great convenience for the whole-product accounting of the accounting system.
Based on the same inventive concept, the embodiment of the present invention further provides an accounting balance information query device, as described in the following embodiments. Because the principle of the device for solving the problems is similar to the method for inquiring the account balance information, the implementation of the device can refer to the implementation of the method for inquiring the account balance information, and repeated parts are not described again.
Fig. 3 is a schematic diagram of an apparatus for inquiring balance information of accounting subjects according to an embodiment of the present invention, as shown in fig. 3, the apparatus may include: a query request module 31, an accounting item element rule query module 32, an accounting item element rule parsing module 33 and an accounting item element rule screening module 34.
The query request module 31 is configured to obtain an accounting balance query request of a target service; an accounting subject element rule query module 32, configured to query, according to an accounting subject balance query request of a target service, a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set; an accounting subject element rule analysis module 33, configured to analyze the queried accounting subject element rule to generate a query program executable by the account accounting system; and an accounting subject element rule screening module 34, configured to screen the balance of the accounting subject based on the generated query program, so as to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
As can be seen from the above, the accounting balance information query device provided in the embodiment of the present invention obtains the accounting balance query request of the target service through the query request module 31; inquiring a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set through an accounting subject element rule inquiry module 32 according to an accounting subject balance inquiry request of a target service; analyzing the inquired accounting subject element rule through an accounting subject element rule analysis module 33 to generate an inquiry program executable by an account accounting system; the balance of the accounting subject is screened by the accounting subject element rule screening module 34 based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
According to the accounting subject balance information inquiry device provided by the embodiment of the invention, aiming at different business scene requirements, an accounting subject element rule set comprising a plurality of accounting subject element rules is constructed, and an accounting subject inquiry interface can be flexibly configured, so that the purpose of inquiring the balance of the accounting subject in different business scenes is realized.
In an embodiment, as shown in fig. 4, the accounting balance information query device provided in the embodiment of the present invention may further include: the user-defined accounting subject element rule configuration module 35 is used for acquiring the user-defined configured accounting subject element rule; the accounting item element rule parsing module 33 is further configured to parse the accounting item element rule configured by the user in a customized manner, and generate a query program executable by the account accounting system.
In an embodiment, as shown in fig. 4, the accounting balance information query device provided in the embodiment of the present invention may further include: an accounting item element rule set generating module 36 is configured to configure a plurality of accounting element rules, and generate an accounting item element rule set according to the configured plurality of accounting element rules.
In an embodiment, as shown in fig. 4, the accounting balance information query device provided in the embodiment of the present invention may further include: and an accounting element rule attribute information configuration module 37, configured to configure a business classification code, an accounting system classification, an investment variety, and a financial asset classification corresponding to each accounting element rule.
In an embodiment, as shown in fig. 4, in the accounting balance information query apparatus provided in the embodiment of the present invention, the query program generated by the accounting key rule parsing module 33 may be an SQL query statement.
Based on the same inventive concept, the embodiment of the present invention further provides a computer device, so as to solve the technical problem that when an existing account accounting system queries accounting subjects, different accounting subject balance query interfaces need to be repeatedly developed for different business scenarios, so that both the code maintenance amount and the redundancy are high, fig. 5 is a schematic diagram of a computer device provided in the embodiment of the present invention, as shown in fig. 5, the computer device 50 includes a memory 501, a processor 502, and a computer program stored on the memory 501 and operable on the processor 502, and the accounting subject balance information query method is implemented when the processor 502 executes the computer program.
Based on the same invention concept, the embodiment of the invention also provides a computer readable storage medium, which is used for solving the technical problem that the code maintenance amount and the redundancy are high due to the fact that different accounting subject balance inquiry interfaces need to be repeatedly developed aiming at different business scenes when the existing account accounting system inquires the accounting subject.
To sum up, the embodiments of the present invention provide an accounting balance information query method, apparatus, computer device and computer readable storage medium, after acquiring an accounting balance query request of a target service, according to the accounting balance query request of the target service, querying a corresponding accounting element rule from a pre-constructed accounting element rule set, parsing the queried accounting element rule, generating a query program executable by an account accounting system, and further screening the accounting balance based on the generated query program to obtain the accounting balance requested to be queried by the accounting balance query request, compared with the technical solution of repeatedly developing different accounting balance query interfaces for different service scenarios in the prior art, the embodiments of the present invention are directed to different service scenario requirements, an accounting subject element rule set containing a plurality of accounting subject element rules is constructed, and an accounting subject inquiry interface can be flexibly configured so as to achieve the purpose of inquiring balance of accounting subjects in different business scenes.
The accounting subject balance information query scheme provided by the embodiment of the invention can support batch and single-coupon transaction, and simultaneously support user-defined rules, thereby greatly improving the wide applicability of accounting subject balance information query and supporting the personalized query requirement of an interface calling party.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (12)
1. An accounting subject balance information query method is characterized by comprising the following steps:
acquiring an accounting balance inquiry request of a target service;
inquiring a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set according to the accounting subject balance inquiry request of the target business;
analyzing the inquired accounting subject element rules to generate an inquiry program executable by the account accounting system;
and screening the balance of the accounting subject based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
2. The method of claim 1, wherein the method further comprises:
acquiring accounting subject element rules configured by a user in a self-defined manner;
and analyzing the accounting subject element rules configured by the user definition to generate an inquiry program executable by the account accounting system.
3. The method of claim 1, wherein the method further comprises:
configuring a plurality of accounting element rules;
and generating the accounting subject element rule set according to the configured plurality of accounting element rules.
4. The method of claim 3, wherein the method further comprises:
and configuring a business classification code, an accounting system classification, an investment variety and a financial asset classification corresponding to each accounting element rule.
5. The method of any of claims 1 to 4, wherein the query program is an SQL query statement.
6. An accounting subject balance information inquiry device, comprising:
the query request module is used for acquiring an accounting balance query request of a target service;
an accounting subject element rule query module, configured to query, according to an accounting subject balance query request of the target service, a corresponding accounting subject element rule from a pre-constructed accounting subject element rule set;
the accounting subject element rule analysis module is used for analyzing the inquired accounting subject element rules and generating an inquiry program executable by the account accounting system;
and the accounting subject element rule screening module is used for screening the balance of the accounting subject based on the generated query program to obtain the balance of the accounting subject requested to be queried by the accounting subject balance query request.
7. The apparatus of claim 6, wherein the apparatus further comprises:
the user-defined accounting subject element rule configuration module is used for acquiring the accounting subject element rule configured by the user in a user-defined manner;
the accounting subject element rule analysis module is also used for analyzing the accounting subject element rules configured by the user in a user-defined mode and generating an inquiry program executable by the account accounting system.
8. The apparatus of claim 6, wherein the apparatus further comprises:
the accounting subject element rule set generating module is used for configuring a plurality of accounting element rules and generating the accounting subject element rule set according to the configured accounting element rules.
9. The apparatus of claim 8, wherein the apparatus further comprises:
and the accounting element rule attribute information configuration module is used for configuring a business classification code, an accounting system classification, an investment variety and a financial asset classification corresponding to each accounting element rule.
10. The apparatus of any of claims 6 to 9, wherein the query program is an SQL query statement.
11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of querying account balance information according to any one of claims 1 to 5 when executing the computer program.
12. A computer-readable storage medium storing a computer program for executing the method for inquiring balance information of accounting subjects of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010908603.7A CN112036999B (en) | 2020-09-02 | 2020-09-02 | Accounting subject balance information query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010908603.7A CN112036999B (en) | 2020-09-02 | 2020-09-02 | Accounting subject balance information query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112036999A true CN112036999A (en) | 2020-12-04 |
| CN112036999B CN112036999B (en) | 2024-02-27 |
Family
ID=73591095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010908603.7A Active CN112036999B (en) | 2020-09-02 | 2020-09-02 | Accounting subject balance information query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112036999B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112988661A (en) * | 2021-02-19 | 2021-06-18 | 金蝶软件（中国）有限公司 | Balance table updating method and related equipment thereof |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109254968A (en) * | 2018-08-30 | 2019-01-22 | 中国建设银行股份有限公司 | A kind of accounting item management method and system |
| CN109447769A (en) * | 2018-09-07 | 2019-03-08 | 杭州小番网络科技有限公司 | A kind for the treatment of method and apparatus of financial data |
| CN110716951A (en) * | 2019-09-23 | 2020-01-21 | 北京明略软件系统有限公司 | Label configuration method, device and equipment convenient to configure and storage medium |
-
2020
- 2020-09-02 CN CN202010908603.7A patent/CN112036999B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109254968A (en) * | 2018-08-30 | 2019-01-22 | 中国建设银行股份有限公司 | A kind of accounting item management method and system |
| CN109447769A (en) * | 2018-09-07 | 2019-03-08 | 杭州小番网络科技有限公司 | A kind for the treatment of method and apparatus of financial data |
| CN110716951A (en) * | 2019-09-23 | 2020-01-21 | 北京明略软件系统有限公司 | Label configuration method, device and equipment convenient to configure and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112988661A (en) * | 2021-02-19 | 2021-06-18 | 金蝶软件（中国）有限公司 | Balance table updating method and related equipment thereof |
| CN112988661B (en) * | 2021-02-19 | 2024-03-19 | 金蝶软件（中国）有限公司 | Balance table updating method and related equipment thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112036999B (en) | 2024-02-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109597974B (en) | Report generation method and device | |
| US7289974B2 (en) | System and method for data reconciliation | |
| KR101874862B1 (en) | Intelligent Searching System for Billing data of Internet service and Method thereof | |
| CN105653647B (en) | The information collecting method and system of SQL statement | |
| CN112882699A (en) | Business processing method, device, equipment and medium based on process configuration engine | |
| CN106844320B (en) | Financial statement integration method and equipment | |
| CN110046287A (en) | A kind of the data query method, apparatus and storage medium unrelated with type of database | |
| CN113268500A (en) | Service processing method and device and electronic equipment | |
| CN109767024B (en) | Method and device for predicting quantity of components, electronic equipment and storage medium | |
| CN116185397A (en) | Low-code engine based on declarative component | |
| US8051110B2 (en) | Identifying screen flows to support multiple entities and their diverse rules with a single application instance | |
| CN112036999A (en) | Method and device for inquiring balance information of accounting subject | |
| CN110781235A (en) | Big data based purchase data processing method and device, terminal and storage medium | |
| CN109359794A (en) | Business access method, device, electronic equipment and computer readable storage medium | |
| CN105701602A (en) | Resource distribution method and device | |
| CN109002355B (en) | Distribution method, device and equipment for processing requests | |
| CN116227454A (en) | Universal automatic report generation method and system | |
| CN113139835B (en) | Data processing method, device, nonvolatile storage medium and processor | |
| CN113625967B (en) | Data storage method, data query method and server | |
| CN106874327B (en) | Counting method and device for business data | |
| CN116976800A (en) | Data processing method and device, storage medium and electronic equipment | |
| JP2010224881A (en) | Transaction data processing method, system, and program | |
| US20120210307A1 (en) | Usage analysis of productive environment to establish new data source for process optimization and project planning | |
| CN114880387A (en) | Data integration script generation method and device, storage medium and electronic equipment | |
| US9098613B2 (en) | Logging of application messages |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |