CN112131855B - Bank certificate template generation method and device - Google Patents
Bank certificate template generation method and device Download PDFInfo
- Publication number
- CN112131855B CN112131855B CN202011062818.8A CN202011062818A CN112131855B CN 112131855 B CN112131855 B CN 112131855B CN 202011062818 A CN202011062818 A CN 202011062818A CN 112131855 B CN112131855 B CN 112131855B
- Authority
- CN
- China
- Prior art keywords
- template
- voucher
- target
- information
- credential
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000000007 visual effect Effects 0.000 claims abstract description 43
- 238000004590 computer program Methods 0.000 claims description 16
- 238000012545 processing Methods 0.000 claims description 11
- 230000006870 function Effects 0.000 claims description 10
- 238000004806 packaging method and process Methods 0.000 claims 2
- 238000012800 visualization Methods 0.000 claims 1
- 238000010586 diagram Methods 0.000 description 16
- 230000008569 process Effects 0.000 description 8
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/101—Collaborative creation, e.g. joint development of products or services
-
- 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/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Artificial Intelligence (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and a device for generating a bank certificate template, wherein the method comprises the following steps: acquiring the business requirement of a target voucher template; selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template; according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template; analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call; and calling the data required by each information module in the bank background database table according to the SQL statement called by the data, and generating a target credential template. The bank voucher template can be obtained by selecting the information module from the visual interface and modularly assembling, the difficulty of generating the voucher template is reduced, and therefore the working efficiency of bank staff is improved.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for generating a bank certificate template.
Background
In the practical business context of a bank accounting system, a large number of vouchers are generated, if implementation of the design for each voucher is obviously not feasible. Therefore, the accounting system of the bank needs to establish a voucher template, and each template can generate a corresponding voucher according to the data on the transaction instruction by templating the voucher of the same transaction type.
Because the data tables required to be called for configuring the voucher templates are numerous, the developers are difficult to operate, the repeated work of daily development and maintenance is involved, the difficulty coefficient is high, and the working efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a method for generating a bank certificate template, which is used for reducing the generation difficulty and improving the working efficiency, and comprises the following steps:
Acquiring the business requirement of a target voucher template;
selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template;
according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template;
Analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call;
According to the SQL statement called by the data, calling the data required by each information module in the bank background database table to generate a target credential template;
The data structure of the credential template includes: the method comprises the steps of associating a master voucher template, a detail template, template detail elements and a voucher abstract by using a template ID, associating the detail template with the detail template elements by using a detail sequence number as an association, and mutually matching to complete a voucher generation rule of a transaction:
The master credential template is an entry to the credential template; the transaction type is from a transaction information carrier and is a unique identification of the transaction, and different credential generation conditions of the transaction are distinguished by special processing marks; the template ID is a unique mark of the credential generation rule and corresponds to a unique transaction type; the content in the voucher abstract is the abstract information finally displayed in the voucher; the data source is a query statement comprising transaction carrier information and provides data for the voucher entry;
the structure of the detail template contains all information required for generating the voucher entry except the subject code; the sequence of the detail sequence number marks the entry, which is a unique mark in the template ID; the sum, price and unit price fields in the entry are variables, and the values of the variables are obtained from a data source of the main template;
The template detail element provides a first-level subject code of each entry, which is an entry for traversing a subject tree and generating a complete subject code; the template detail elements are complements of the data source of the main evidence template, if the data source of the main evidence template is regarded as the value source of the global variable, the template detail element list is the value source of the local variable, and the accounting elements and the values thereof in the accounting subjects are uniquely determined by the template ID and the detail sequence number;
The function of the certificate abstract is to take the value of the variable contained in the abstract field in the master certificate template according to the configuration identification designating mode, and the master certificate template provides the data value;
After the target voucher template is generated, on the premise that a subject system is available, when the transaction information carrier triggers the accounting engine, the accounting engine selects the voucher template according to the transaction type.
The embodiment of the invention also provides a device for generating the bank certificate template, which is used for reducing the generation difficulty and improving the working efficiency, and comprises the following steps:
The demand acquisition module is used for acquiring the service demand of the target credential template;
The visual selection module is used for selecting an information module required by the target credential template from a preset visual interface according to the service requirement of the target credential template;
the logic connection module is used for splicing the information modules required by the selected target voucher template according to the service requirement of the target voucher template and the service logic to obtain a modularized bank voucher template;
the logic analysis module is used for analyzing the logic relation among the information modules in the modularized bank evidence template and generating a Structured Query Language (SQL) statement of the data call;
the voucher template generating module is used for calling the data required by each information module in the bank background database table according to the SQL statement called by the data to generate a target voucher template;
The data structure of the credential template includes: the method comprises the steps of associating a master voucher template, a detail template, template detail elements and a voucher abstract by using a template ID, associating the detail template with the detail template elements by using a detail sequence number as an association, and mutually matching to complete a voucher generation rule of a transaction:
The master credential template is an entry to the credential template; the transaction type is from a transaction information carrier and is a unique identification of the transaction, and different credential generation conditions of the transaction are distinguished by special processing marks; the template ID is a unique mark of the credential generation rule and corresponds to a unique transaction type; the content in the voucher abstract is the abstract information finally displayed in the voucher; the data source is a query statement comprising transaction carrier information and provides data for the voucher entry;
the structure of the detail template contains all information required for generating the voucher entry except the subject code; the sequence of the detail sequence number marks the entry, which is a unique mark in the template ID; the sum, price and unit price fields in the entry are variables, and the values of the variables are obtained from a data source of the main template;
The template detail element provides a first-level subject code of each entry, which is an entry for traversing a subject tree and generating a complete subject code; the template detail elements are complements of the data source of the main evidence template, if the data source of the main evidence template is regarded as the value source of the global variable, the template detail element list is the value source of the local variable, and the accounting elements and the values thereof in the accounting subjects are uniquely determined by the template ID and the detail sequence number;
The function of the certificate abstract is to take the value of the variable contained in the abstract field in the master certificate template according to the configuration identification designating mode, and the master certificate template provides the data value;
the document template generation module is also used for selecting the document template according to the transaction type when the transaction information carrier triggers the accounting engine on the premise that a subject system is available after the target document template is generated.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the bank credential template generation method when executing the computer program.
Embodiments of the present invention also provide a computer-readable storage medium storing a computer program for executing the above-described bank voucher template generation method.
In the embodiment of the invention, the service requirement of the target credential template is acquired; selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template; according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template; analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call; and calling the data required by each information module in the bank background database table according to the SQL statement called by the data, and generating a target credential template. The bank voucher template can be obtained by selecting the information module from the visual interface and modularly assembling, the difficulty of generating the voucher template is reduced, and therefore the working efficiency of bank staff is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic diagram of a method for generating a bank certificate template according to an embodiment of the present invention.
Fig. 2 is a schematic diagram showing a specific implementation of step 102 in an embodiment of the present invention.
Fig. 3 is a schematic diagram illustrating a process of presetting a visual interface according to an embodiment of the present invention.
FIG. 4 is a diagram illustrating a data structure of a credential template according to an embodiment of the present invention.
Fig. 5 is a schematic diagram of a bank certificate generation process according to an embodiment of the present invention.
FIG. 6 is a schematic diagram of a workflow for implementation of the present invention.
FIG. 7 is a schematic diagram of a bank certificate generation process in an embodiment of the present invention.
Fig. 8 is a schematic diagram of a bank certificate template generating apparatus according to an embodiment of the present invention.
Fig. 9 is a schematic diagram of a bank certificate template generating apparatus according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
For better understanding of the embodiments of the present invention, the following terms are explained in the following terms according to the embodiments of the present invention:
the credential template is an abstraction of the same class of business processes, and is a set of rules for credential generation.
The voucher consists of a voucher abstract and a voucher entry, the voucher abstract reflects the function of the voucher, and each tiao fu voucher entry records the change condition of an accounting subject. The document entry mainly comprises a subject code, a lending direction of the subject and a specific change amount, and the document entry complies with an accounting criterion of 'having a lending and having equal lending'.
According to the subject system, only accounting subjects and subject codes which meet the conditions can be found in the subject tree through a set of specified accounting elements and element values, and then required data is extracted from the transaction information carrier, so that a certificate can be completed. Therefore, under the action of a subject system, a set of value rules of subject codes and transaction data are needed for generating the certificates.
The embodiment of the invention provides a method for generating a bank certificate template, which is used for reducing the generation difficulty and improving the working efficiency, and as shown in figure 1, the method comprises the following steps:
Step 101: acquiring the business requirement of a target voucher template;
step 102: selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template;
Step 103: according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template;
Step 104: analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call;
Step 105: and calling the data required by each information module in the bank background database table according to the SQL statement called by the data, and generating a target credential template.
As can be seen from the flow shown in fig. 1, in the embodiment of the present invention, the service requirement of the target credential template is obtained; selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template; according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template; analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call; and calling the data required by each information module in the bank background database table according to the SQL statement called by the data, and generating a target credential template. The bank voucher template can be obtained by selecting the information module from the visual interface and modularly assembling, the difficulty of generating the voucher template is reduced, and therefore the working efficiency of bank staff is improved.
In the implementation, firstly, the business requirement of the target credential template is acquired, and in the specific embodiment, the business requirement mainly refers to the transaction type of the credential template to be generated, and the business requirement of the business of the transaction type, such as the data, the business flow, the business logic and the like.
After the business requirement of the target credential template is acquired, selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template. The specific implementation process, as shown in fig. 2, includes:
step 201: determining a template ID of the target credential template according to the business requirement of the target credential template;
step 202: and selecting an information module corresponding to the template ID from a preset visual interface.
The process of presetting the visual interface, as shown in fig. 3, includes:
step 301: collecting a plurality of credential templates, and analyzing the data structures of the credential templates to obtain at least one information element with commonality in the credential templates;
Step 302: at least one information element is respectively packaged into independent information modules by utilizing visual programming;
Step 303: and storing all the information modules into a module alternative library to construct a visual interface.
In specific implementation, the voucher template is a set of code and transaction data value rule. The data structure of the credential template consists of four parts, namely: master credential template (icrecmb), detail template (icrecmxmb), template detail element (icrecmxels), credential summary (icreczyxx), structure as shown in fig. 4.
The four data structures are related by template IDs, detail templates and detail template elements are related by detail serial numbers, and the four data structures are matched with each other to complete a certificate generation rule of a transaction:
(1) The master credential template is an entry for the credential template. The transaction type comes from a transaction information carrier, is a unique identifier of a transaction, can be associated with a plurality of sets of templates, and is distinguished into different credential generation conditions of the transaction by special processing marks; the template ID is a unique mark of a set of credential generation rules and corresponds to a unique transaction type; the content in the voucher abstract is abstract information finally displayed in the voucher, and the field possibly contains variables, and the associated voucher abstract table is required to be translated; the data source is a query statement covering most transaction carrier information, and provides data for the voucher entry.
(2) The structure of the detail template is closest to the voucher entry, and contains all information required for generating the voucher entry except the subject code. The sequence number marks the sequence of the entry, is a unique mark of the entry in the template ID, namely the unique mark of the template ID and the sequence number determines an entry content; the fields of the amount, price, unit price and the like in the entry are variables, and the values of the variables can be obtained from the data source of the main template.
(3) The template detail element provides a first-level subject code of each entry, which is an entry for traversing a subject tree and generating a complete subject code; in addition, the template detail elements are complements of the data source of the main evidence template, if the data source of the main evidence template is regarded as the value source of the global variable, the template detail element list is the value source of the local variable, and the accounting elements and the values thereof in one accounting subject are uniquely determined by the template ID and the detail sequence number.
(4) The function of the certificate digest is to perfect the digest field in the master certificate template, and the variables contained in the field are valued according to the appointed mode of the configuration identification (conversion/non-conversion), and the master certificate template provides the data for the valued.
Because there are a large number of reusable information elements, e.g., subject elements, entry values, etc., between the plurality of credential templates. Therefore, the information elements with high probability of being repeatedly utilized can be respectively packaged into independent information modules by utilizing visual programming; and storing all the information modules into a module alternative library, constructing a visual interface, and displaying the visual interface to a user.
After the information module required by the target voucher template is selected, the information module required by the selected target voucher template is spliced according to business logic according to business requirements of the target voucher template, and a modularized bank voucher template is obtained.
After the modularized bank voucher template is obtained, analyzing the logic relation among all information modules in the modularized bank voucher template to generate a Structured Query Language (SQL) statement of data call;
According to SQL statement of data call, call data needed by each information module in bank background database table, generate target credential template
In a specific embodiment, as shown in fig. 5, on the basis of fig. 1, the method further includes:
Step 501: determining the structure of the voucher entry of the target voucher according to the detail template in the target voucher template;
Step 502: traversing the subject tree to generate a document entry subject code of the target document according to the template detail elements in the target document template;
step 503: according to the structure of the voucher entry of the target voucher and the voucher entry subject code of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher entry information of the target voucher is determined;
Step 504: according to the voucher abstract of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher abstract information of the target voucher is determined;
step 505: and combining the voucher entry information of the target voucher and the voucher abstract information of the target voucher to obtain the target voucher.
A specific example is given below to illustrate how an embodiment of the present invention generates a bank voucher template.
As shown in fig. 6, a workflow diagram of this embodiment mainly includes:
Writing a credential template: and selecting required modules in the visual interface, and performing logic connection among the modules to complete writing of a credential template.
The bottom layer is realized: analyzing the relation among all modules in the written voucher template, rewriting the relation among all modules into executable SQL sentences, and finally inserting the written voucher template into a background table through executing the SQL sentences to obtain the target voucher template.
After the target voucher template is obtained, when the transaction information carrier triggers an accounting engine on the premise that a subject system is available, the accounting engine selects a proper voucher template according to the transaction type to obtain a template ID; acquiring a detail template through a template ID, organizing the structure of the voucher entry according to the template detail, combining the value of detail elements, traversing a subject tree to generate a subject code of the voucher entry, and filling the value in a main template data source into a corresponding accounting subject entry; the abstract information is obtained through the template ID, the value of the abstract information is filled in the main template data source, the flow is shown in figure 7, and a specific bank certificate is obtained according to the target certificate template.
Because the specific application is implemented, the programming capability of the business personnel is not high, even the business personnel providing the template requirement does not have the database programming capability, and the business personnel and the programming developer are required to cooperate to finish the template generation when the template generation is required, but the communication between the business personnel and the programming developer is inconvenient when the business processing is actually performed, and the working efficiency is reduced. In the specific example, the visual programming has low difficulty and strong intuitiveness, and by performing the visual programming, the business personnel can directly perform configuration or modification on the upper hand, and the business personnel can directly participate in the generation of the credential template, so that the working efficiency is improved. And each reusable part is modularized, so that a large number of repeated codes in the development process are reduced, and the possibility of errors is reduced.
The implementation of the above specific application is only an example, and the rest of the embodiments are not described in detail.
Based on the same inventive concept, the embodiment of the invention also provides a bank voucher template generating device, because the principle of the problem solved by the bank voucher template generating device is similar to that of the bank voucher template generating method, the implementation of the bank voucher template generating device can refer to the implementation of the bank voucher template generating method, and the specific structure is shown in fig. 8 and is not repeated:
A requirement acquisition module 801, configured to acquire a service requirement of a target credential template;
The visual selection module 802 is configured to select an information module required by the target credential template in a preset visual interface according to a service requirement of the target credential template;
The logic connection module 803 is configured to splice information modules required by the selected target credential template according to service requirements of the target credential template and service logic to obtain a modularized bank credential template;
The logic analysis module 804 is configured to analyze the logic relationship between each information module in the modularized bank credential template, and generate a structured query language SQL statement for data call;
the credential template generating module 805 is configured to invoke data required by each information module in the bank background database table according to the SQL statement of the data call, and generate a target credential template.
In a specific embodiment, the bank certificate template generating device as shown in fig. 9 further includes, on the basis of fig. 8:
the visual interface preset module 901 is configured to:
Collecting a plurality of credential templates, and analyzing the data structures of the credential templates to obtain at least one information element with commonality in the credential templates;
At least one information element is respectively packaged into independent information modules by utilizing visual programming;
and storing all the information modules into a module alternative library to construct a visual interface.
In particular, the visual selection module 802 is specifically configured to:
determining a template ID of the target credential template according to the business requirement of the target credential template;
and selecting an information module corresponding to the template ID from a preset visual interface.
In a specific embodiment, a device for generating a bank certificate template is further provided, and on the basis of fig. 8 or fig. 9, the device further includes:
the credential generation module is used for:
determining the structure of the voucher entry of the target voucher according to the detail template in the target voucher template;
traversing the subject tree to generate a document entry subject code of the target document according to the template detail elements in the target document template;
according to the structure of the voucher entry of the target voucher and the voucher entry subject code of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher entry information of the target voucher is determined;
according to the voucher abstract of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher abstract information of the target voucher is determined;
and combining the voucher entry information of the target voucher and the voucher abstract information of the target voucher to obtain the target voucher.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the bank credential template generation method when executing the computer program.
The embodiment of the invention also provides a computer readable storage medium which stores a computer program for executing the bank certificate template generation method.
In summary, the method and the device for generating the bank certificate template provided by the embodiment of the invention have the following advantages:
Acquiring the business requirement of a target voucher template; selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template; according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template; analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call; and calling the data required by each information module in the bank background database table according to the SQL statement called by the data, and generating a target credential template. The bank voucher template can be obtained by selecting the information module from the visual interface and modularly assembling, the difficulty of generating the voucher template is reduced, and therefore the working efficiency of bank staff is improved. It will be apparent to those skilled in the art that embodiments of the present invention may be provided as a method, apparatus, 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 and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 description is only of the preferred embodiments of the present invention and is not intended to limit the present invention, and various modifications and variations can be made to the embodiments of the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method for generating a bank voucher template, comprising:
Acquiring the business requirement of a target voucher template;
selecting an information module required by the target credential template from a preset visual interface according to the business requirement of the target credential template;
according to the business requirement of the target voucher template, the information modules required by the selected target voucher template are spliced according to business logic to obtain a modularized bank voucher template;
Analyzing the logic relation among the information modules in the modularized bank evidence template to generate a Structured Query Language (SQL) statement of the data call;
According to the SQL statement called by the data, calling the data required by each information module in the bank background database table to generate a target credential template;
The data structure of the credential template includes: the method comprises the steps of associating a master voucher template, a detail template, template detail elements and a voucher abstract by using a template ID, associating the detail template with the detail template elements by using a detail sequence number as an association, and mutually matching to complete a voucher generation rule of a transaction:
The master credential template is an entry to the credential template; the transaction type is from a transaction information carrier and is a unique identification of the transaction, and different credential generation conditions of the transaction are distinguished by special processing marks; the template ID is a unique mark of the credential generation rule and corresponds to a unique transaction type; the content in the voucher abstract is the abstract information finally displayed in the voucher; the data source is a query statement comprising transaction carrier information and provides data for the voucher entry;
the structure of the detail template contains all information required for generating the voucher entry except the subject code; the sequence of the detail sequence number marks the entry, which is a unique mark in the template ID; the sum, price and unit price fields in the entry are variables, and the values of the variables are obtained from a data source of the main template;
The template detail element provides a first-level subject code of each entry, which is an entry for traversing a subject tree and generating a complete subject code; the template detail elements are complements of the data source of the main evidence template, if the data source of the main evidence template is regarded as the value source of the global variable, the template detail element list is the value source of the local variable, and the accounting elements and the values thereof in the accounting subjects are uniquely determined by the template ID and the detail sequence number;
The function of the certificate abstract is to take the value of the variable contained in the abstract field in the master certificate template according to the configuration identification designating mode, and the master certificate template provides the data value;
After the target voucher template is generated, on the premise that a subject system is available, when the transaction information carrier triggers the accounting engine, the accounting engine selects the voucher template according to the transaction type.
2. The method of claim 1, further comprising presetting a visualization interface as follows:
Collecting a plurality of credential templates, and analyzing the data structures of the credential templates to obtain at least one information element with commonality in the credential templates;
packaging the at least one information element into separate information modules by utilizing visual programming;
and storing all the information modules into a module alternative library to construct a visual interface.
3. The method of claim 1, wherein selecting the information module required by the target credential template in the preset visual interface according to the business requirement of the target credential template comprises:
determining a template ID of the target credential template according to the business requirement of the target credential template;
and selecting an information module corresponding to the template ID from a preset visual interface.
4. A method according to any one of claims 1 to 3, wherein the method further comprises:
determining the structure of the voucher entry of the target voucher according to the detail template in the target voucher template;
traversing the subject tree to generate a document entry subject code of the target document according to the template detail elements in the target document template;
according to the structure of the voucher entry of the target voucher and the voucher entry subject code of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher entry information of the target voucher is determined;
according to the voucher abstract of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher abstract information of the target voucher is determined;
and combining the voucher entry information of the target voucher and the voucher abstract information of the target voucher to obtain the target voucher.
5. A bank voucher template generating apparatus, comprising:
The demand acquisition module is used for acquiring the service demand of the target credential template;
The visual selection module is used for selecting an information module required by the target credential template from a preset visual interface according to the service requirement of the target credential template;
the logic connection module is used for splicing the information modules required by the selected target voucher template according to the service requirement of the target voucher template and the service logic to obtain a modularized bank voucher template;
the logic analysis module is used for analyzing the logic relation among the information modules in the modularized bank evidence template and generating a Structured Query Language (SQL) statement of the data call;
the voucher template generating module is used for calling the data required by each information module in the bank background database table according to the SQL statement called by the data to generate a target voucher template;
The data structure of the credential template includes: the method comprises the steps of associating a master voucher template, a detail template, template detail elements and a voucher abstract by using a template ID, associating the detail template with the detail template elements by using a detail sequence number as an association, and mutually matching to complete a voucher generation rule of a transaction:
The master credential template is an entry to the credential template; the transaction type is from a transaction information carrier and is a unique identification of the transaction, and different credential generation conditions of the transaction are distinguished by special processing marks; the template ID is a unique mark of the credential generation rule and corresponds to a unique transaction type; the content in the voucher abstract is the abstract information finally displayed in the voucher; the data source is a query statement comprising transaction carrier information and provides data for the voucher entry;
the structure of the detail template contains all information required for generating the voucher entry except the subject code; the sequence of the detail sequence number marks the entry, which is a unique mark in the template ID; the sum, price and unit price fields in the entry are variables, and the values of the variables are obtained from a data source of the main template;
The template detail element provides a first-level subject code of each entry, which is an entry for traversing a subject tree and generating a complete subject code; the template detail elements are complements of the data source of the main evidence template, if the data source of the main evidence template is regarded as the value source of the global variable, the template detail element list is the value source of the local variable, and the accounting elements and the values thereof in the accounting subjects are uniquely determined by the template ID and the detail sequence number;
The function of the certificate abstract is to take the value of the variable contained in the abstract field in the master certificate template according to the configuration identification designating mode, and the master certificate template provides the data value;
the document template generation module is also used for selecting the document template according to the transaction type when the transaction information carrier triggers the accounting engine on the premise that a subject system is available after the target document template is generated.
6. The apparatus as recited in claim 5, further comprising:
The visual interface preset module is used for:
Collecting a plurality of credential templates, and analyzing the data structures of the credential templates to obtain at least one information element with commonality in the credential templates;
packaging the at least one information element into separate information modules by utilizing visual programming;
and storing all the information modules into a module alternative library to construct a visual interface.
7. The apparatus of claim 5, wherein the visual selection module is specifically configured to:
determining a template ID of the target credential template according to the business requirement of the target credential template;
and selecting an information module corresponding to the template ID from a preset visual interface.
8. The apparatus of any one of claims 5 to 7, further comprising:
the credential generation module is used for:
determining the structure of the voucher entry of the target voucher according to the detail template in the target voucher template;
traversing the subject tree to generate a document entry subject code of the target document according to the template detail elements in the target document template;
according to the structure of the voucher entry of the target voucher and the voucher entry subject code of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher entry information of the target voucher is determined;
according to the voucher abstract of the target voucher, the value is taken in the data source of the main voucher template in the target voucher template, and the voucher abstract information of the target voucher is determined;
and combining the voucher entry information of the target voucher and the voucher abstract information of the target voucher to obtain the target voucher.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 4 when executing the computer program.
10. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011062818.8A CN112131855B (en) | 2020-09-30 | 2020-09-30 | Bank certificate template generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011062818.8A CN112131855B (en) | 2020-09-30 | 2020-09-30 | Bank certificate template generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112131855A CN112131855A (en) | 2020-12-25 |
| CN112131855B true CN112131855B (en) | 2024-04-19 |
Family
ID=73843637
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011062818.8A Active CN112131855B (en) | 2020-09-30 | 2020-09-30 | Bank certificate template generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112131855B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112906364B (en) * | 2021-03-26 | 2024-11-08 | 中国建设银行股份有限公司 | Credential generation method and device, electronic equipment and storage medium |
| CN113139373B (en) * | 2021-04-23 | 2024-08-09 | 上海中通吉网络技术有限公司 | Method, system and equipment for generating financial evidence based on dynamic modeling |
| CN113986202A (en) * | 2021-11-26 | 2022-01-28 | 中国银行股份有限公司 | Method and device for generating development process design scheme of bank information system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN201974852U (en) * | 2011-01-27 | 2011-09-14 | 北京物美商业集团股份有限公司 | Financial voucher generating system |
| CN109785092A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Accounting voucher generates management method, device and computer equipment, storage medium |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN111680983A (en) * | 2020-06-15 | 2020-09-18 | 山东理工职业学院 | Automatic accounting document generating device for database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200410097A (en) * | 2002-12-06 | 2004-06-16 | Hon Hai Prec Ind Co Ltd | Ledger account management system |
-
2020
- 2020-09-30 CN CN202011062818.8A patent/CN112131855B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN201974852U (en) * | 2011-01-27 | 2011-09-14 | 北京物美商业集团股份有限公司 | Financial voucher generating system |
| CN109785092A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Accounting voucher generates management method, device and computer equipment, storage medium |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN111680983A (en) * | 2020-06-15 | 2020-09-18 | 山东理工职业学院 | Automatic accounting document generating device for database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112131855A (en) | 2020-12-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| La Rosa et al. | Managing process model complexity via abstract syntax modifications | |
| CN112131855B (en) | Bank certificate template generation method and device | |
| US8015051B2 (en) | System and method for business process integration | |
| US8577927B2 (en) | Producing a virtual database from data sources exhibiting heterogeneous schemas | |
| CN106445536B (en) | Automatic business design management system | |
| CN104866426A (en) | Software test integrated control method and system | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN107273117A (en) | A kind of quick Code automatic build system for programming friendly | |
| Barbosa et al. | Towards identifying microservice candidates from business rules implemented in stored procedures | |
| CN111813661A (en) | Global service data drive automatic test method, device, equipment and medium | |
| CN112308727A (en) | Insurance claim settlement service processing method and device | |
| CN107506190A (en) | XML file amending method and device based on Spring frameworks | |
| CN105843605B (en) | A kind of data mapping method and device | |
| CN105843788A (en) | Report generation method and device | |
| CN103473306A (en) | Method and system for adopting structured query language (SQL) mark substitution method to achieve data self-extraction | |
| CN111913962B (en) | Multi-dimensional annual detail fund planning system and method | |
| Angulo et al. | An approach for creating kdm2psm transformation engines in adm context: The rute-k2j case | |
| JPH06149555A (en) | Data flow chart preparing method | |
| JP3758282B2 (en) | Information retrieval device | |
| Hagen | Towards flexible software processes by using process patterns | |
| Meier et al. | Towards Metamodel Integration Using Reference Metamodels | |
| CN112667278A (en) | Hospital medical insurance interface configuration method and system | |
| JPH09292986A (en) | Part extraction method | |
| JP2015011685A (en) | Business rule management system and business rule management method | |
| Sánchez et al. | Extraction and reconstruction of enterprise models |
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 |