CN105741168A - Liquidation management system and method - Google Patents
Liquidation management system and method Download PDFInfo
- Publication number
- CN105741168A CN105741168A CN201410749241.6A CN201410749241A CN105741168A CN 105741168 A CN105741168 A CN 105741168A CN 201410749241 A CN201410749241 A CN 201410749241A CN 105741168 A CN105741168 A CN 105741168A
- Authority
- CN
- China
- Prior art keywords
- data
- clearance
- module
- access request
- management
- 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.)
- Pending
Links
Abstract
The invention discloses a liquidation management system and method, and the system comprises an application server which is used for providing a liquidation function interface; a processing server which is used for processing a data access request obtained from the application server and transmitting the data corresponding to the data access request to the application server; and a client which is used for sending the data access request to the processing server and receiving the data, which is transmitted by the processing server and is corresponding to the data access request, according to the liquidation function interface provided by the application server, and carrying out liquidation management at the liquidation function interface provided by the application server based on the received data. According to the scheme of the invention, an enterprise can change a mode of manually building a liquidation statement into a mode of intelligentization conveniently for completing related work, and improves the office efficiency of the enterprise and the management capability of the enterprise.
Description
Technical field
The present invention relates to electronic tax processing technology field, in particular it relates to a kind of Ying Gaizeng enterprise clearance management system and method.
Background technology
The Sales Tax of enterprise is to pay in this Local Tax Bureau, and after implementation battalion changes increasing, the Sales Tax that some enterprises pay originally is accomplished by paying value-added tax instead.
Specifying according to tax office, some enterprises to carry out the way that value-added tax advance payment reliquidates, and the clearance phase has monthly clearance, season to clear, year clears three kinds.Within the clearance phase, head office should according to branch by collecting the data of declaration form sum, and the tax liability of clearing operation occurs in Branch Computed mechanism, generates liquidation statement to competent tax authority.The tax liability that branch's year clears, more than the branch advance payment amount of tax to be paid, pays arrears warehouse-in when differential section is by branch's advance payment value-added tax in the lump.
It is to say, for enterprise of branch, it is necessary to according to the rules according to the different affiliated period such as monthly or season, to head office's reported data；Liquidation statement then the competent tax authority that reports for work is generated after the data clearance that branch is reported by head office.Each branch pays taxes in arrears according to liquidation statement.
Therefore, along with battalion changes the popularization of increasing, for there being the conglomerate of demand, it is necessary to set up a management system, complete the management to clearance.
Summary of the invention
It is an object of the invention to provide a kind of clearance management system and method, after battalion changes increasing, carry out the technical problem of clearance management for solving conglomerate.
To achieve these goals, the present invention provides a kind of clearance management system, including: application server, it is for providing the function interface of clearance；Processing server, it is for processing the data access request obtained from described application server, and transmits the data corresponding with this data access request to described application server；And client, the function interface of its clearance for providing according to described application server, propose data access request to described processing server and receive the data corresponding with this data access request of described processing server transmission, then the function interface of the clearance provided at described application server based on the data received carries out clearance and manages.
Preferably, described clearance management system also includes database server, and this database server is for storing the data relevant to carrying out clearance operation.
Preferably, described processing server obtains the data corresponding with described data access request from described database server.
Preferably, described processing server includes data modification module and data inquiry module；Described data modification module is used for resolving corresponding data access request, obtain each data item, and it is organized into INSERT, UPDATE, DELETE tri-class SQL statement according to request classification and the flow chart of data processing preset, data are preserved accordingly in database server, amendment and/or delete；Described data inquiry module is used for resolving corresponding data access request, obtain the keyword of request, and according to default flow chart of data processing, key organization is become SELECT class SQL query statement, submit to database server and do data query, then the Query Result that database server returns is finally returned that to client by application server.
Preferably, the function interface of described clearance includes collecting and declares module, transmission menu manager module, clearance management module, code management module and system setup module.
Preferably, collect described in and declare module and include consolidated statement management module, consolidated statement auditing module and consolidated statement reporting module；Described transmission menu manager module includes transmission single operation management module, the single auditing module of transmission and the single reporting module of transmission；Described clearance management module includes liquidation statement enquiry module, liquidation statement auditing module and head office's clearance module；Described code management module includes pin square tube reason module and organization management module；Described system setup module includes pin side's attribute module and user management module.
Present invention additionally comprises a kind of clearance management method, adopt above-mentioned clearance management system, including: the function interface of the clearance that client provides according to described application server, to described processing server, data access request is proposed；Processing server processes the data access request obtained from described application server, and transmits the data corresponding with this data access request to described application server；And client receives the data corresponding with this data access request of described processing server transmission, then the function interface of the clearance provided at described application server based on the data received carries out clearance management.
Preferably, also include: described processing server obtains the data corresponding with described data access request from database server.
Preferably, described clearance function interface provide function include collecting declare, transmit menu manager, clearance management, coding management and system arrange；Wherein, collect described in declare include consolidated statement management, consolidated statement examination & verification and consolidated statement report；Described transmission menu manager includes transmission single operation management, the single examination & verification of transmission and transmission and singly reports；Described clearance management includes liquidation statement inquiry, liquidation statement examination & verification and head office's clearance；Described coding management includes pin square tube reason and organization management；Described system arranges and includes pin side's attribute and user's management.
Preferably, described data access request includes submitting to amendment data and inquiry to obtain data, described processing server processes the data access request obtained from described application server, specifically include: when submitting amendment data to, described processing server utilizes built-in update routine to resolve corresponding data access request, obtain each data item, and it is organized into INSERT, UPDATE, DELETE tri-class SQL statement according to request classification and the flow chart of data processing preset, data are preserved accordingly in database server, amendment and/or delete；When inquiry obtains data, described processing server resolves corresponding data access request, obtain the keyword of request, and according to default flow chart of data processing, key organization is become SELECT class SQL query statement, submit to database server and do data query, then the Query Result that database server returns is finally returned that to client by application server.
By technique scheme, the invention has the beneficial effects as follows: the clearing operation that battalion of conglomerate is changed volume increase raw by the present invention provides solution, the business such as branch can complete the filling in of clearance data in system, report；Head office can complete clearance in system.Utilizing the clearance management system and method for the present invention, enterprise can bring up to the information-based means of utilization from hand weaving liquidation statement easily and complete related work, improves office efficiency and the operating capability of enterprise.
Other features and advantages of the present invention will be described in detail in detailed description of the invention part subsequently.
Accompanying drawing explanation
Accompanying drawing is used to provide a further understanding of the present invention, and constitutes the part of description, is used for explaining the present invention, but is not intended that limitation of the present invention together with detailed description below.In the accompanying drawings:
Fig. 1 is the system architecture diagram of clearance management system of the present invention；
Fig. 2 is the network topological diagram of clearance management system of the present invention；
Fig. 3 is the function composition diagram of clearance management system and method for the present invention.
Detailed description of the invention
Below in conjunction with accompanying drawing, the specific embodiment of the present invention is described in detail.It should be appreciated that detailed description of the invention described herein is merely to illustrate and explains the present invention, it is not limited to the present invention.
As it is shown in figure 1, the invention provides a kind of clearance management system, including: application server, it is for providing the function interface of clearance；Processing server, it is for processing the data access request obtained from described application server, and transmits the data corresponding with this data access request to described application server；And client, the function interface of its clearance for providing according to described application server, propose data access request to described processing server and receive the data corresponding with this data access request of described processing server transmission, then the function interface of the clearance provided at described application server based on the data received carries out clearance and manages.
With reference to Fig. 1, this clearance management system is B/S framework, also includes database server, and this database server is for storing the data relevant to carrying out clearance operation.
The network topological diagram of above-mentioned each client and server, as in figure 2 it is shown, client can have multiple, is distributed in the locations such as at county level, provincial, group company, and accesses application server by group's comprehensive network.User in client by accessing application server, it is thus achieved that operate each function interface of this clearance management system, it is achieved the filling in of clearance, audit, the management function such as report.Described processing server is responsible for processing the data access request that user submits to from client, and completes data manipulation alternately with database server.
Processing server is mainly the data access request of response application server, and request is done corresponding process.Data access request mainly has submission amendment data and inquiry to obtain data two class.When submitting amendment data to, the form data that client will fill in, or typing need data to be saved, or need amendment, the request of data deleted submits to processing server, the processing server service number according to request, the update routine giving correspondence processes.This update routine is corresponding to including the data modification module in described processing server, it is resolution data request first, obtain each data item, and it is organized into INSERT, UPDATE, DELETE tri-class SQL statement according to request classification and the flow chart of data processing preset, data are carried out in database server the preservation of correspondence, amendment and/or deletion action.When inquiry obtains data, request is sent out and is submitted to processing server by client, and the processing server service number according to request, the polling routine giving correspondence processes.This polling routine is corresponding to including the data inquiry module in described processing server, it is resolution data request first, obtain the keyword of request, and according to default flow chart of data processing, key organization is become SELECT class SQL query statement, submit to database server and do data query, then the Query Result that database server returns is finally returned that to client by application server.
The system architecture of the present embodiment is simple, and respective server is prone to configuration, for instance can adopt following allocation plan:
Application server and processing server configuration information: adopt winserver2003 operating system；The JDK of 1.6；Weblogic10.3.6 middleware.Database server configuration information: adopt winserver2003 operating system and ORACLE:11g data base.
The method adopting this clearance management system to carry out clearance management, mainly comprises the steps that the function interface of the clearance that client provides according to described application server, proposes data access request to described processing server；Processing server process processes the data access request obtained from described application server, and transmits the data corresponding with this data access request to described application server；And client receives the data corresponding with this data access request of described processing server transmission, then the function interface of the clearance provided at described application server based on the data received carries out clearance management.Wherein, described processing server obtains the data corresponding with described data access request from database server.
In the present embodiment, as it is shown on figure 3, the function interface of described clearance gives the functional module in every practical application, declare module, transmission menu manager module, clearance management module, code management module and system setup module including collecting.
Wherein, collect described in and declare module and include consolidated statement management module, consolidated statement auditing module and consolidated statement reporting module；Described transmission menu manager module includes transmission single operation management module, the single auditing module of transmission and the single reporting module of transmission.Described clearance management module includes liquidation statement enquiry module, liquidation statement auditing module and head office's clearance module.Described code management module includes pin square tube reason module and organization management module；Described system setup module includes pin side's attribute module and user management module.
In conjunction with Fig. 3, introduce the function of above-mentioned each functional module in detail below.
1) consolidated statement management
Main realize to collect declaration form increase, revise, delete, inquire about, printing function.Branch utilizes this function can complete filling report forms.
2) consolidated statement examination & verification
Main realization is audited and the data check of relation between Biao Neibiao being successfully generated the data message collecting declaration form, verification income and pin item data on the one hand, on the other hand by the form after auditing, filling report forms flow process will be terminated, enter into superior and upload the flow process of form.
3) consolidated statement is uploaded
Realize branch to report to head office and audit the declaration form passed through, and can carry out checking and rollback operation.Through the form uploaded, it can be checked and wait data manipulation by head office, and can provide the report data being correlated with when collecting operation.
4) transmission single operation management
Transmission is singly increased by main realization, and amendment is deleted, inquiry, printing function.Branch utilizes this function can complete filling report forms.
5) the single examination & verification of transmission
The single audit function of transmission is mainly used in realizing auditing and in table, whether the data check relation of relation correct and the operation that carries out being successfully generated the single data message of transmission.
6) transmission singly reports
For branch to audit by and by the transmission printed singly after corresponding Administration of State Bureau affixes one's seal, will transmission single electron information reporting to head office.
7) liquidation statement inquiry
After head office completes clearance, generating clearance result, this function provides head office and branch that the inquiry of liquidation statement, liquidation statement are checked the operations such as detail, printing, derivation.
8) liquidation statement examination & verification
The data message being successfully generated liquidation statement to be audited and in table, the data check relation of relation be correctly to carry out review operations after completing clearance by head office.Through the clearance result that examination & verification confirms, branch can be allowed to inquire about.
9) head office's clearance
Automatically clearance instruction is performed, by each branch by transmitting single and collecting the data that declaration form reports and carry out clearance process for head office；Also by manual operations, the clearance result of each branch inquired about, check, the operation such as typing, amendment, deletion and submission.
10) pin square tube reason
For in systems pin side's information of all total sub-agencies being safeguarded, operation content includes increase, amendment, deletes, inquires about pin side's information, and the Xiao Fang enterprise temporarily not used can be set to invalid flag, if reused, then Xiao Fang enterprise is set to effective marker.Pin side's company information is used for clearing Auto-writing relevant information in management.
11) organization management
For all mechanism informations in system are safeguarded, operation content includes inquiry, increase, amendment, deletion etc..Mechanism information refers to the whole units needing operation native system in conglomerate.Safeguarded by mechanism information, it is possible to after logging in system by user, control data permission and the flow process trend of system.
12) pin side's attribute
The attribute of declaring of enterprise of branch and enterprise of head office is arranged, and the attribute that period, head office's amortization ratio, branch's amortization ratio etc. belonging to the Chinese rose year include whether total sub-agencies, reporting are relevant is arranged.These attributes for the filling in of correlation table forms data, the Row control such as report and make a report on the verification calculating etc. of content.
13) user's management
The affiliated corresponding levels and subordinate departmental staff thereof are registered and distribute authority by system manager, enable related personnel to operate native system according to corresponding authority.And user can be carried out maintenance of information, operation content includes inquiring about, increases, revises, deletes, checks.
The preferred embodiment of the present invention is described in detail above in association with accompanying drawing; but; the present invention is not limited to the detail in above-mentioned embodiment; in the technology concept of the present invention; technical scheme can being carried out multiple simple variant, these simple variant belong to protection scope of the present invention.
It is further to note that each the concrete technical characteristic described in above-mentioned detailed description of the invention, in reconcilable situation, it is possible to be combined by any suitable mode.In order to avoid unnecessary repetition, various possible compound modes are no longer illustrated by the present invention separately.
Additionally, can also carry out combination in any between the various different embodiment of the present invention, as long as it is without prejudice to the thought of the present invention, it should be considered as content disclosed in this invention equally.
Claims (10)
1. a clearance management system, it is characterised in that including:
Application server, it is for providing the function interface of clearance；
Processing server, it is for processing the data access request obtained from described application server, and transmits the data corresponding with this data access request to described application server；And
Client, the function interface of its clearance for providing according to described application server, propose data access request to described processing server and receive the data corresponding with this data access request of described processing server transmission, then the function interface of the clearance provided at described application server based on the data received carries out clearance and manages.
2. clearance management system according to claim 1, it is characterised in that described clearance management system also includes database server, this database server is for storing the data relevant to carrying out clearance operation.
3. clearance management system according to claim 2, it is characterised in that described processing server obtains the data corresponding with described data access request from described database server.
4. clearance management system according to claim 1, it is characterised in that described processing server includes data modification module and data inquiry module；
Described data modification module is used for resolving corresponding data access request, obtain each data item, and it is organized into INSERT, UPDATE, DELETE tri-class SQL statement according to request classification and the flow chart of data processing preset, data are preserved accordingly in database server, amendment and/or delete；
Described data inquiry module is used for resolving corresponding data access request, obtain the keyword of request, and according to default flow chart of data processing, key organization is become SELECT class SQL query statement, submit to database server and do data query, then the Query Result that database server returns is finally returned that to client by application server.
5. clearance management system according to claim 1, it is characterised in that the function interface of described clearance includes collecting declares module, transmission menu manager module, clearance management module, code management module and system setup module.
6. clearance management system according to claim 4, it is characterised in that described in collect and declare module and include consolidated statement management module, consolidated statement auditing module and consolidated statement reporting module；Described transmission menu manager module includes transmission single operation management module, the single auditing module of transmission and the single reporting module of transmission；
Described clearance management module includes liquidation statement enquiry module, liquidation statement auditing module and head office's clearance module；
Described code management module includes pin square tube reason module and organization management module；Described system setup module includes pin side's attribute module and user management module.
7. a clearance management method, it is characterised in that adopt arbitrary described clearance management system in claim 1 to 6, including:
The function interface of the clearance that client provides according to described application server, proposes data access request to described processing server；
Processing server processes the data access request obtained from described application server, and transmits the data corresponding with this data access request to described application server；And
Client receives the data corresponding with this data access request of described processing server transmission, then the function interface of the clearance provided at described application server based on the data received carries out clearance management.
8. clearance management method according to claim 7, it is characterised in that also include: described processing server obtains the data corresponding with described data access request from database server.
9. clearance management method according to claim 7, it is characterised in that the function that the function interface of described clearance provides includes collecting declares, transmits menu manager, clearance management, coding management and system and arrange；
Wherein, collect described in declare include consolidated statement management, consolidated statement examination & verification and consolidated statement report；
Described transmission menu manager includes transmission single operation management, the single examination & verification of transmission and transmission and singly reports；
Described clearance management includes liquidation statement inquiry, liquidation statement examination & verification and head office's clearance；
Described coding management includes pin square tube reason and organization management；
Described system arranges and includes pin side's attribute and user's management.
10. clearance management method according to claim 7, it is characterised in that described data access request includes submitting to amendment data and inquiry to obtain data, and described processing server processes the data access request obtained from described application server, specifically includes:
When submitting amendment data to, described processing server utilizes built-in update routine to resolve corresponding data access request, obtain each data item, and it is organized into INSERT, UPDATE, DELETE tri-class SQL statement according to request classification and the flow chart of data processing preset, data are preserved accordingly in database server, amendment and/or delete；
When inquiry obtains data, described processing server resolves corresponding data access request, obtain the keyword of request, and according to default flow chart of data processing, key organization is become SELECT class SQL query statement, submit to database server and do data query, then the Query Result that database server returns is finally returned that to client by application server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410749241.6A CN105741168A (en) | 2014-12-09 | 2014-12-09 | Liquidation management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410749241.6A CN105741168A (en) | 2014-12-09 | 2014-12-09 | Liquidation management system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105741168A true CN105741168A (en) | 2016-07-06 |
Family
ID=56239612
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410749241.6A Pending CN105741168A (en) | 2014-12-09 | 2014-12-09 | Liquidation management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105741168A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296386A (en) * | 2016-08-29 | 2017-01-04 | 苏州倾爱娱乐传媒有限公司 | A kind of financial liquidation changing interface system |
| CN106339934A (en) * | 2016-08-29 | 2017-01-18 | 苏州倾爱娱乐传媒有限公司 | Management method of financial settlement system |
| CN107133868A (en) * | 2017-05-02 | 2017-09-05 | 深圳乐信软件技术有限公司 | Fund classifying method, device, terminal and storage medium |
| CN107220792A (en) * | 2017-05-27 | 2017-09-29 | 成都掌上风暴科技有限公司 | A kind of storage management method and system |
| CN112685484A (en) * | 2020-12-24 | 2021-04-20 | 航天信息软件技术有限公司 | Transaction account checking method and device, storage medium and electronic equipment |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101188012A (en) * | 2006-11-16 | 2008-05-28 | 中国银联股份有限公司 | A transaction data liquidation system and liquidation method |
-
2014
- 2014-12-09 CN CN201410749241.6A patent/CN105741168A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101188012A (en) * | 2006-11-16 | 2008-05-28 | 中国银联股份有限公司 | A transaction data liquidation system and liquidation method |
Non-Patent Citations (1)
| Title |
|---|
| 陆凯: "昌邑市地方税务局税收征管系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296386A (en) * | 2016-08-29 | 2017-01-04 | 苏州倾爱娱乐传媒有限公司 | A kind of financial liquidation changing interface system |
| CN106339934A (en) * | 2016-08-29 | 2017-01-18 | 苏州倾爱娱乐传媒有限公司 | Management method of financial settlement system |
| CN107133868A (en) * | 2017-05-02 | 2017-09-05 | 深圳乐信软件技术有限公司 | Fund classifying method, device, terminal and storage medium |
| CN107220792A (en) * | 2017-05-27 | 2017-09-29 | 成都掌上风暴科技有限公司 | A kind of storage management method and system |
| CN112685484A (en) * | 2020-12-24 | 2021-04-20 | 航天信息软件技术有限公司 | Transaction account checking method and device, storage medium and electronic equipment |
| CN112685484B (en) * | 2020-12-24 | 2023-08-29 | 航天信息软件技术有限公司 | Transaction checking method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105740998A (en) | Enterprise tax declaration management system and method | |
| CN110473078B (en) | Information processing method, device, gateway server and medium in invoice issuing | |
| CN105741168A (en) | Liquidation management system and method | |
| US8600929B2 (en) | Method and computer system for aggregating data from a plurality of operational databases | |
| CN103049684B (en) | A kind of data permission control method based on RBAC model extension and system | |
| CN105741167A (en) | Added-value tax output invoice management system and method | |
| CN105740996A (en) | Collective tax declaration management system and method | |
| CN103814374B (en) | information management system and method | |
| KR20090089225A (en) | Tax and account information sharing system using tax declaration format | |
| CN105205749A (en) | JSP-based house property sale system | |
| CN102388384A (en) | Method allowing validation of large volume of updates in a large production database of new entered data prior to their release | |
| US20180285394A1 (en) | System and Method for Data Integration | |
| CN104142930A (en) | Universal Delta data loading technology | |
| CN106251054A (en) | A kind of financial management system | |
| US20210089517A1 (en) | Communication device and communication system | |
| CN102194163A (en) | Enterprise resource planning management method, server and system | |
| CN204740627U (en) | System is ordered to film ticket | |
| CN105550911A (en) | Invoice management method, device and system | |
| CN103136619A (en) | On-line management method for engineering quality acceptance report form | |
| CN107194794A (en) | A kind of corporate tax declaration management system and method | |
| US20230328154A1 (en) | System and Method for Asset Management and Integration | |
| CN1753020A (en) | System for on internet electronic business integration and its method | |
| JP2013003871A (en) | Management system for tires kept in trust | |
| CN102456004A (en) | Query control method and system of page data | |
| CN108921628A (en) | A kind of implementation method for supporting to issue electronic invoice online |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160706 |