CN111241141B - Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises - Google Patents
Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises Download PDFInfo
- Publication number
- CN111241141B CN111241141B CN201911389937.1A CN201911389937A CN111241141B CN 111241141 B CN111241141 B CN 111241141B CN 201911389937 A CN201911389937 A CN 201911389937A CN 111241141 B CN111241141 B CN 111241141B
- Authority
- CN
- China
- Prior art keywords
- suspicious
- tax
- point
- query
- module
- 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
- 238000012544 monitoring process Methods 0.000 title claims abstract description 13
- 238000012216 screening Methods 0.000 title claims abstract description 13
- 238000000034 method Methods 0.000 title claims abstract description 12
- 238000007781 pre-processing Methods 0.000 claims abstract description 5
- 230000008520 organization Effects 0.000 claims abstract description 4
- 230000000875 corresponding effect Effects 0.000 claims description 7
- 230000002596 correlated effect Effects 0.000 claims description 2
- 230000009191 jumping Effects 0.000 claims description 2
- 238000005553 drilling Methods 0.000 claims 1
- 230000007547 defect Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- 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
- G06F16/2457—Query processing with adaptation to user needs
-
- 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
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/10—Tax strategies
Abstract
The invention provides a method for rapidly screening a vehicle acquisition tax monitoring management platform problem enterprise, which comprises the following steps: q1, establishing a suspicious point information base; q2, establishing a suspicious spot list; q3, counting the details of the suspicious points; q4, establishing a summary of the number of suspicious points of the tax payer, preprocessing data, and improving the query and display efficiency of a system foreground; q5, foreground display, wherein a browser/server mode is adopted, and query sentences are generated according to an organization to which a current login user belongs, so that query data from an Oracle database are displayed in a WEB browser. The invention can enable the system to macroscopically see which suspects, how many suspects are provided and how much the suspects are focused on by the tax payer, greatly shortens the time for the system to use the personnel to screen the suspects information without entering each module for screening and counting, can timely adjust the granularity of scanning according to the requirement, realizes precise macroscopically suspects counting and displaying, and can effectively embody the efficiency of tax monitoring.
Description
Technical Field
The invention belongs to the technical field of financial tax monitoring, and particularly relates to a method for rapidly screening a vehicle acquisition tax monitoring management platform problem enterprise.
Background
The currently used vehicle purchase tax monitoring management platform comprises thirty more functional modules in total including invoice display, declaration analysis and invoice analysis, wherein each functional module analyzes the invoice or tax payer through the respectively set screening caliber, finally screens out the suspicious point tax payer or invoice conforming to the caliber of the user, and then the functional module in the prior art has the following defects: the existing functional modules of the vehicle purchase tax monitoring and management platform can analyze tax payers and invoices from multiple angles and multiple indexes and display suspicious point data, but one functional module or index data sometimes cannot judge that a violation condition exists, if one user wants to check which suspicious points exist in the tax payers, each functional module needs to be opened for inquiring, time and effort are consumed, and independent inquiry of each functional module cannot easily and intuitively see which suspicious points exist in the tax payers, how many suspicious points exist in the tax payers and whether the tax payers need to be checked and analyzed.
Disclosure of Invention
The invention aims to overcome the defects of the prior art, and provides a quick screening method for enterprises with the problems of a vehicle purchase tax monitoring management platform, which can quickly and macroscopically and comprehensively show which and how many doubts a tax payer has.
The aim of the invention is achieved by the following technical scheme:
the specific technical scheme of the invention is as follows:
a method for rapidly screening a vehicle purchase tax monitoring management platform problem enterprise comprises the following steps:
q1, establishing an suspicious point information base, and making a suspicious point information table by indexes in a function module of a tax suspicious point of a design enterprise, so as to provide a basis for subsequent suspicious point scanning statistics and suspicious point drill-down;
q2, establishing a suspicious spot detail table for the suspicious spot information display of the tax payer, establishing the correlated tax payer information in the suspicious spot detail table, and establishing correlation with a suspicious spot information base through the suspicious spot ID;
q3, counting the details of the suspicious points, scanning each functional module by taking the data ID in the suspicious point information base as a sequence and taking month as a query dimension through a suspicious point scanning process, wherein the scanning standard of each module is a key query condition used by a query interface of the functional module, and inserting the result data queried by each functional module into a suspicious point detail table;
q4, establishing a summary of the number of suspicious points of the tax payer, preprocessing data, and improving the query and display efficiency of a system foreground;
q5, foreground display, namely, adopting a browser/server mode, generating query sentences to query data from an Oracle database according to an organization to which a current login user belongs and selecting months as query conditions, and displaying the query sentences in a WEB browser.
In the above technical scheme, in the Q4, when the data is preprocessed, the number of doubtful points of the macroscopic display tax payers is intensively screened, a threshold is set, and tax payers with the number of doubtful points being greater than or equal to the threshold are selected for foreground display.
In the technical scheme, in the Q5, the foreground display is divided into three layers, and the number of suspicious points of the tax payer is displayed in a macroscopic manner in the layer; the second level is used for inquiring the suspicious points and displaying the details of the suspicious points in detail; and thirdly, inquiring and checking the function module corresponding to the suspicious point according to the specific suspicious point information.
The invention can enable the system to macroscopically see which suspects, how many suspects are provided and how much the suspects are focused on by the tax payer, greatly shortens the time for the system to use the personnel to screen the suspects information without entering each module for screening and counting, can timely adjust the granularity of scanning according to the requirement, realizes precise macroscopically suspects counting and displaying, and can effectively embody the efficiency of tax monitoring.
Detailed Description
The technical solutions of the present invention will be clearly and completely described in connection with the embodiments, and it is obvious that the described embodiments are only some embodiments of the present invention, 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.
A method for rapidly screening a vehicle purchase tax monitoring management platform problem enterprise comprises the following steps:
q1, establishing a doubt point information base, making a doubt point information table by using indexes in a function module of a tax-paying doubt point of a design enterprise, providing basis for subsequent doubt point scanning statistics and doubt point drill-down, wherein the table structure of the doubt point information table is a doubt point ID, a module ID, a doubt point name or a function module name and a key index, wherein the doubt point ID is used as the subsequent scanning statistics, the module ID is used for subsequent drill-down skip detailed page use, the doubt point name or the function module name is used as a doubt point display item, and the key index is mainly used for distinguishing the secondary degree of an inspection item.
Q2, establishing a question point detail table for displaying the question point information of the tax payer, establishing the associated tax payer information in the question point detail table, wherein the table structure of the question point detail table is an belonging period, a tax payer KEY and a question point ID, the belonging period is a belonging period of data (the data is divided according to month), the tax payer KEY is used for associating tax payer information with the tax payer table, and the question point ID is used for establishing association with a question point information base.
Q3, counting the details of the suspicious points, scanning each functional module by taking the data ID in the suspicious point information base as a sequence and taking month as a query dimension through a suspicious point scanning process, wherein the scanning standard of each module is a key query condition used by a query interface of the functional module, and inserting the result data queried by each functional module into a suspicious point detail table.
Q4, establishing a summary of the number of suspicious points of the taxpayers, preprocessing data, improving the inquiry display efficiency of a system foreground, and when preprocessing the data, intensively screening the number of the suspicious points of the macroscopic display taxpayers, setting a threshold value, selecting the taxpayers with the number of the suspicious points being more than or equal to the threshold value, wherein the data processing mode is as follows: the tax payer and month count the total number of doubtful points and the number of KEY doubtful points in each month under the grouping condition, and the table structure of the table is the belonged period, the tax payer KEY, the total number of indexes and the number of KEY indexes. The belonging period is the belonging period of the data (the same as the belonging period of the suspicious spot list), the tax payer KEY is used for associating the tax payer with the index total number, the index total number is used for showing how many suspicious spot modules are in the current month of the tax payer, and the KEY index number is used for showing how many indexes needing to be focused in the current month index of the tax payer. Writing the query result into the summary table of the number of suspicious points of the tax payer, deleting the data of the summary table of the number of suspicious points in the month before writing, and preventing the data from repeating, wherein the obtained result data is used for foreground display.
Q5, displaying in a foreground, wherein the foreground display is divided into three layers, namely a layer one macroscopic display tax payer doubtful point number, according to an organization to which a current login user belongs and selecting month as a query condition, generating query sentences, and displaying query data from an Oracle database in a WEB browser; the second level is used for inquiring the suspicious points and displaying the details of the suspicious points in detail; a third layer, according to specific doubtful point information, inquiring a functional module corresponding to the doubtful point for checking, wherein a table used by the first layer is a 'total table of the number of the doubtful points of the tax payer', and the tax payer information (tax payer name and identification number) and the doubtful point data (the number of the doubtful points and the number of the important doubtful points) information are extracted according to the association of a tax payer KEY and an NSR_key field in a 'tax payer' table in the system for displaying; the second layer is to click the skip of the number of the erasures in the first layer, and the used table is a 'erasures detail table' for carrying out association display erasures information (erasures names, erasures description) according to the erasures ID and the erasures ID of the 'erasures information base'; the third level is to jump to a specific functional module from the second level, and the module ID of the 'suspicious spot information base' is used for jumping operation, namely, the background program code searches the foreground display page according to the transferred 'module ID', then opens the corresponding page, and brings the corresponding condition according to the query condition of each module to ensure the accuracy of the data.
The foregoing is merely illustrative of the present invention, and the present invention is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (1)
1. A method for rapidly screening a vehicle purchase tax monitoring management platform problem enterprise is characterized in that: the method comprises the following steps:
q1, establishing a suspicious spot information base, and making a suspicious spot information table by indexes in a functional module related to the suspicious spot of the enterprise tax, so as to provide a basis for subsequent suspicious spot scanning statistics and suspicious spot drill-down; the table structure of the doubt point information table is doubt point ID, module ID, doubt point name or function module name, whether to focus on the index, wherein the doubt point ID is used as the subsequent scanning statistics, the module ID is used for the subsequent down-drilling skip detailed page use, the doubt point name or function module name is used as the doubt point display item, whether to focus on the index and is used for distinguishing the secondary degree of the checking item;
q2, establishing a suspicious spot detail table for the suspicious spot information display of the tax payer, establishing the correlated tax payer information in the suspicious spot detail table, and establishing correlation with a suspicious spot information base through the suspicious spot ID;
q3, counting the details of the suspicious points, scanning each functional module by taking the data ID in the suspicious point information base as a sequence and taking month as a query dimension through a suspicious point scanning process, wherein the scanning standard of each module is a key query condition used by a query interface of the functional module, and inserting the result data queried by each functional module into a suspicious point detail table;
q4, establishing a summary table of the number of suspicious points of the tax payers, preprocessing data, intensively screening the number of the suspicious points of the macroscopic display tax payers, setting a threshold value, selecting the tax payers with the number of the suspicious points being more than or equal to the threshold value for foreground display, and improving the query display efficiency of a system foreground;
q5, foreground display, namely generating query sentences to query data from an Oracle database and displaying the query sentences in a WEB browser by adopting a browser/server mode according to an organization to which a current login user belongs and selecting months as query conditions;
in the Q5, the foreground display is divided into three layers, and the number of suspicious points of the tax payer is displayed in a macroscopic manner in the layers; the second level is used for inquiring the suspicious points and displaying the details of the suspicious points in detail; thirdly, inquiring a function module corresponding to the suspicious point for checking according to the specific suspicious point information;
the table used in the first layer is a summary table of the number of the suspicious points of the tax payer, and the tax payer information and the suspicious point data information are extracted according to the association of the tax payer KEY and the NSR_key field in the table of the tax payer in the system for displaying, wherein the tax payer information comprises the name and the identification number of the tax payer, and the suspicious point data comprises the number of the suspicious points and the number of the important suspicious points; the second layer is to click the skip of the number of the erasures in the first layer, the used table is a erasures list, and the erasures information is displayed by associating the erasures ID with the erasures ID of the erasures information base, and the erasures information comprises erasures names and erasures description; the third level is to jump to a specific functional module from the second level, and the module ID of the 'suspicious spot information base' is used for jumping operation, namely, the background program code searches the foreground display page according to the transferred 'module ID', then opens the corresponding page, and brings the corresponding condition according to the query condition of each module to ensure the accuracy of the data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911389937.1A CN111241141B (en) | 2019-12-30 | 2019-12-30 | Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911389937.1A CN111241141B (en) | 2019-12-30 | 2019-12-30 | Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111241141A CN111241141A (en) | 2020-06-05 |
| CN111241141B true CN111241141B (en) | 2023-11-14 |
Family
ID=70875859
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911389937.1A Active CN111241141B (en) | 2019-12-30 | 2019-12-30 | Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111241141B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246999A (en) * | 2013-01-29 | 2013-08-14 | 北京税恒科技有限公司 | Enterprise tax risk self-inspection platform |
| CN103955787A (en) * | 2014-04-04 | 2014-07-30 | 广州辰鹏信息科技有限公司 | Tax risk management and control system |
| CN104463663A (en) * | 2014-12-05 | 2015-03-25 | 税友软件集团股份有限公司 | Data sorting method, device and system |
| CN104700304A (en) * | 2013-12-05 | 2015-06-10 | 航天信息股份有限公司 | Method and system for supervising enterprise tax evasion through values of plain invoices of value-added tax |
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| CN105184642A (en) * | 2015-09-02 | 2015-12-23 | 浪潮软件集团有限公司 | Comprehensive tax administration platform |
| CN106447483A (en) * | 2016-09-26 | 2017-02-22 | 山东浪潮云服务信息科技有限公司 | Data analysis-based information-enabled tax control implementing structure |
| CN109325839A (en) * | 2018-09-20 | 2019-02-12 | 电子科技大学 | A kind of VAT invoice applied analysis system based on large data center |
| CN110490722A (en) * | 2019-08-16 | 2019-11-22 | 安徽航天信息有限公司 | A kind of tax risk monitoring method and system based on big data |
-
2019
- 2019-12-30 CN CN201911389937.1A patent/CN111241141B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246999A (en) * | 2013-01-29 | 2013-08-14 | 北京税恒科技有限公司 | Enterprise tax risk self-inspection platform |
| CN104700304A (en) * | 2013-12-05 | 2015-06-10 | 航天信息股份有限公司 | Method and system for supervising enterprise tax evasion through values of plain invoices of value-added tax |
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| CN103955787A (en) * | 2014-04-04 | 2014-07-30 | 广州辰鹏信息科技有限公司 | Tax risk management and control system |
| CN104463663A (en) * | 2014-12-05 | 2015-03-25 | 税友软件集团股份有限公司 | Data sorting method, device and system |
| CN105184642A (en) * | 2015-09-02 | 2015-12-23 | 浪潮软件集团有限公司 | Comprehensive tax administration platform |
| CN106447483A (en) * | 2016-09-26 | 2017-02-22 | 山东浪潮云服务信息科技有限公司 | Data analysis-based information-enabled tax control implementing structure |
| CN109325839A (en) * | 2018-09-20 | 2019-02-12 | 电子科技大学 | A kind of VAT invoice applied analysis system based on large data center |
| CN110490722A (en) * | 2019-08-16 | 2019-11-22 | 安徽航天信息有限公司 | A kind of tax risk monitoring method and system based on big data |
Non-Patent Citations (1)
| Title |
|---|
| 陈双 ; .税收监控预警系统的设计与实现.物联网技术.2016,(第04期),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111241141A (en) | 2020-06-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Vasarhelyi et al. | The continuous audit of online Systems1 | |
| Morrison et al. | Challenges with applying vulnerability prediction models | |
| US9026467B2 (en) | Systems and methods for monitoring and detecting fraudulent uses of business applications | |
| US8612479B2 (en) | Systems and methods for monitoring and detecting fraudulent uses of business applications | |
| US9558230B2 (en) | Data quality assessment | |
| US20090265209A1 (en) | System and Method for Governance, Risk, and Compliance Management | |
| US10504047B2 (en) | Metadata-driven audit reporting system with dynamically created display names | |
| US20050197952A1 (en) | Risk mitigation management | |
| US20100179951A1 (en) | Systems and methods for mapping enterprise data | |
| US9978031B2 (en) | Systems and methods for monitoring and detecting fraudulent uses of business applications | |
| Singh et al. | Sql injection detection and correction using machine learning techniques | |
| US20070276711A1 (en) | Method of monitoring procedural compliance of business processes | |
| Lal et al. | Comparison of seven bug report types: A case-study of google chrome browser project | |
| CN105893212A (en) | Audit data security control and display system | |
| US20160188676A1 (en) | Collaboration system for network management | |
| CN111241141B (en) | Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises | |
| CN112822210A (en) | Vulnerability management system based on network assets | |
| CN115719281A (en) | Capital income and expenditure management system | |
| WO2017038221A1 (en) | Device for outputting information for inspection and for analyzing system tendency through analysis and translation of computer operation log | |
| KR20180071699A (en) | System for online monitoring individual information and method of online monitoring the same | |
| CN114155118A (en) | Highway engineering safety gridding management method and system | |
| Inacio et al. | Analysis of the research on internal control in enterprise resource planning systems | |
| Jiu-jin et al. | Influence of XBRL on the accounting information quality | |
| US20020178140A1 (en) | Method for characterizing and storing data analyses in an analysis database | |
| KR102011694B1 (en) | Public institutional income property linkage data verification system and its recording medium |
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 |