CN111241141A - Method for rapidly screening problem enterprises of vehicle purchase tax monitoring and management platform - Google Patents
Method for rapidly screening problem enterprises of vehicle purchase tax monitoring and management platform Download PDFInfo
- Publication number
- CN111241141A CN111241141A CN201911389937.1A CN201911389937A CN111241141A CN 111241141 A CN111241141 A CN 111241141A CN 201911389937 A CN201911389937 A CN 201911389937A CN 111241141 A CN111241141 A CN 111241141A
- Authority
- CN
- China
- Prior art keywords
- doubtful
- doubt
- query
- point
- taxpayer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000012544 monitoring process Methods 0.000 title claims abstract description 15
- 238000012216 screening Methods 0.000 title claims abstract description 14
- 238000007781 pre-processing Methods 0.000 claims abstract description 5
- 230000008520 organization Effects 0.000 claims abstract description 4
- 238000013461 design Methods 0.000 claims description 3
- 238000005553 drilling Methods 0.000 claims description 2
- 230000007547 defect Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000012545 processing 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Computational Linguistics (AREA)
- Finance (AREA)
- Probability & Statistics with Applications (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a method for rapidly screening problem enterprises of a vehicle purchase tax monitoring and management platform, which comprises the following steps: q1, establishing a suspicious node information base; q2, establishing a suspicious point list; q3, counting suspicious details; q4, establishing a taxpayer doubtful point number summary table, preprocessing the data and improving the query and display efficiency of the foreground of the system; and Q5, foreground display, namely, generating query sentences to query data from an Oracle database and displaying the data on a WEB browser according to the organization to which the current login user belongs by adopting a browser/server mode. The invention can enable the system user to watch doubtful points which the taxpayer has, how many doubtful points and how many important concerned doubtful points, does not need to enter each module for screening and counting, greatly reduces the time for the system user to screen doubtful point information, can adjust the scanning granularity in time according to the requirement, realizes accurate macroscopic doubtful point counting and displaying, and can effectively embody the efficiency of tax monitoring.
Description
Technical Field
The invention belongs to the technical field of finance and tax monitoring, and particularly relates to a method for rapidly screening enterprises with problems of a vehicle purchase tax monitoring and managing platform.
Background
The currently used vehicle purchase tax monitoring and management platform comprises thirty or more functional modules for invoice display, declaration type analysis and invoice type analysis, wherein each functional module analyzes an invoice or taxpayer through a respectively set screening caliber, and finally screens doubtful point taxpayers or invoices conforming to the caliber of the functional module, and then the functional modules in the prior art have the following defects: although the current functional modules of the vehicle purchase tax monitoring and management platform can analyze taxpayers and invoices from multiple angles and indexes and display doubtful point data, one functional module or index data sometimes cannot judge whether violation conditions exist, if the doubtful points exist in a taxpayer of a user, the functional modules need to be opened for inquiry, time and labor are consumed, and the independent inquiry of the functional modules is not easy to intuitively see which doubtful points the taxpayer has, how many doubtful points exist and whether the taxpayer needs to be checked and analyzed.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provide a method for rapidly screening the problem enterprises of the vehicle purchase tax monitoring and managing platform, which doubts of a taxpayer and how many doubts exist can be rapidly and macroscopically displayed comprehensively.
The purpose of the invention is realized by the following technical scheme:
the specific technical scheme of the invention is as follows:
a method for rapidly screening problem enterprises of a vehicle purchase tax monitoring and management platform comprises the following steps:
q1, establishing a doubtful point information base, making a doubtful point information table from indexes in a functional module of tax doubtful points of a design enterprise, and providing a basis for subsequent doubtful point scanning statistics and doubtful point drilling;
q2, establishing a doubt point list for displaying the doubt point information of the taxpayer, establishing associated taxpayer information in the doubt point list, and establishing association with a doubt point information base through a doubt point ID;
q3, counting doubt details, scanning each function module by taking the data ID in the doubt information base as the sequence and monthly as the query dimension through the doubt scanning process, wherein the scanning standard of each module is the key query condition used by the query interface of the function module, and inserting the result data queried by each function module into a doubt detail list;
q4, establishing a taxpayer doubtful point number summary table, preprocessing the data and improving the query and display efficiency of the foreground of the system;
and Q5, foreground display, namely, generating a query statement to query data from an Oracle database to display in a WEB browser by adopting a browser/server mode according to the organization mechanism to which the current login user belongs and the selection month as a query condition.
In the technical scheme, in the Q4, when data is preprocessed, the doubtful points of taxpayers are screened in a centralized manner, a threshold value is set, and taxpayers with the doubtful points more than or equal to the threshold value are selected for foreground display.
In the technical scheme, in the Q5, foreground display is divided into three levels, and the doubtful point number of the taxpayer is macroscopically displayed in the level one; level two, used for inquiring the doubt and showing the detail of the doubt in detail; and thirdly, inquiring a functional module corresponding to the suspicious node for checking according to the specific suspicious node information.
The invention can enable the system user to watch doubtful points which the taxpayer has, how many doubtful points and how many important concerned doubtful points, does not need to enter each module for screening and counting, greatly reduces the time for the system user to screen doubtful point information, can adjust the scanning granularity in time according to the requirement, realizes accurate macroscopic doubtful point counting and displaying, and can effectively embody the efficiency of tax monitoring.
Detailed Description
The technical solutions of the present invention are described below clearly and completely with reference to the following embodiments, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
A method for rapidly screening problem enterprises of a vehicle purchase tax monitoring and management platform comprises the following steps:
q1, establishing a doubtful point information base, making a doubtful point information table from indexes in a functional module of the doubtful point of the design enterprise, and providing basis for subsequent doubtful point scanning statistics and doubtful point drill-down, wherein the table structure of the doubtful point information table is doubtful point ID, module ID, doubtful point name or functional module name, and whether the indexes are important, the doubtful point ID is used as the subsequent scanning statistics, the module ID is used for the subsequent drill-down skip detailed page, the doubtful point name or the functional module name is used as a doubtful point display item, and whether the indexes are important is mainly used for distinguishing the importance degree of the check item.
Q2, establishing a doubt list for displaying doubt information of taxpayers and establishing associated taxpayer information in the doubt list, wherein the list structure of the doubt list comprises an affiliated period, taxpayer KEY and doubt ID, the affiliated period is the period of data (data are divided according to the month degree), the taxpayer KEY is used for associating taxpayer information with the taxpayer list, and the doubt ID is used for establishing association with a doubt information base.
Q3, making statistics of doubt details, scanning each function module by taking the data ID in the doubt information base as the sequence and monthly degrees as the query dimension through the doubt scanning process, wherein the scanning standard of each module is the key query condition used by the query interface of the function module, and inserting the result data queried by each function module into the doubt details table.
Q4, establishing a taxpayer doubtful point number summary table, preprocessing data, improving the query display efficiency of a system foreground, intensively screening doubtful point numbers of macroscopically displayed taxpayers when preprocessing the data, setting a threshold value, selecting taxpayers with doubtful point numbers larger than or equal to the threshold value, wherein the data processing mode is as follows: and the taxpayers and the months count the total number of the suspicious points and the number of the KEY suspicious points in each month for grouping conditions, and the table structure of the summary table comprises the period, the taxpayers KEY, the total number of the indexes and the number of the KEY indexes. The period of the data belongs to (the same as the period of the doubt list), the taxpayer KEY is used for associating with the taxpayer, the total number of the indexes is used for displaying how many doubt modules the taxpayer has in the current month, and the number of the KEY indexes is used for displaying how many indexes the taxpayer needs to pay KEY attention to in the current month indexes. And writing the query result into the doubtful point number summary table of the taxpayer, deleting the monthly data of the doubtful point number summary table before writing, preventing data repetition, and using the obtained result data for foreground display.
Q5, foreground display, adopting 'browser/server' mode, generating query sentences to query data from Oracle database to display in WEB browser according to the organization mechanism of the current login user and month selection as query conditions, wherein the foreground display is divided into three levels, and the number of taxpayer doubts is macroscopically displayed at level one; level two, used for inquiring the doubt and showing the detail of the doubt in detail; thirdly, inquiring a function module corresponding to the suspicious points for checking according to specific suspicious point information, wherein a table used in the first level is a taxpayer suspicious point number general table, and taxpayer information (taxpayer name and identification number) and suspicious point data (suspicious point number and KEY suspicious point number) information are extracted and displayed according to the taxpayer KEY and NSR _ KEY field in the taxpayer' table in the system in an associated manner; the second layer is that the number of the doubtful points in the first layer is clicked to skip, and the used table is a doubtful point detail table which is used for displaying doubtful point information (doubtful point name and doubtful point description) in a correlation mode according to doubtful point IDs and doubtful point IDs of a doubtful point information base; and the third layer is to jump to a specific functional module from the second layer and use the module ID of the 'suspect information base' to perform the jump operation, namely, the background program code searches a foreground display page according to the transmitted 'module ID' and then opens a corresponding page, and brings corresponding conditions according to the query conditions of each module to ensure the accuracy of the data.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered 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 (3)
1. A method for rapidly screening problem enterprises of a vehicle purchase tax monitoring and management platform is characterized by comprising the following steps: the method comprises the following steps:
q1, establishing a doubtful point information base, making a doubtful point information table from indexes in a functional module of tax doubtful points of a design enterprise, and providing a basis for subsequent doubtful point scanning statistics and doubtful point drilling;
q2, establishing a doubt point list for displaying the doubt point information of the taxpayer, establishing associated taxpayer information in the doubt point list, and establishing association with a doubt point information base through a doubt point ID;
q3, counting doubt details, scanning each function module by taking the data ID in the doubt information base as the sequence and monthly as the query dimension through the doubt scanning process, wherein the scanning standard of each module is the key query condition used by the query interface of the function module, and inserting the result data queried by each function module into a doubt detail list;
q4, establishing a taxpayer doubtful point number summary table, preprocessing the data and improving the query and display efficiency of the foreground of the system;
and Q5, foreground display, namely, generating a query statement to query data from an Oracle database to display in a WEB browser by adopting a browser/server mode according to the organization mechanism to which the current login user belongs and the selection month as a query condition.
2. The method for rapidly screening the vehicle purchase tax monitoring and management platform problem enterprises according to claim 1, wherein the method comprises the following steps: in the Q5, foreground display is divided into three levels, and the doubtful point number of the taxpayer is macroscopically displayed in the level one; level two, used for inquiring the doubt and showing the detail of the doubt in detail; and thirdly, inquiring a functional module corresponding to the suspicious node for checking according to the specific suspicious node information.
3. The method for rapidly screening the vehicle purchase tax monitoring and management platform problem enterprises according to claim 2, wherein the method comprises the following steps: in the Q4, when data are preprocessed, the doubtful points of taxpayers in macroscopic display are intensively screened, a threshold value is set, and taxpayers with the doubtful points more than or equal to the threshold value are selected for foreground display.
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 true CN111241141A (en) | 2020-06-05 |
| CN111241141B 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 |
|---|
| 陈双;: "税收监控预警***的设计与实现" * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111241141B (en) | 2023-11-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11580680B2 (en) | Systems and interactive user interfaces for dynamic retrieval, analysis, and triage of data items | |
| US10504047B2 (en) | Metadata-driven audit reporting system with dynamically created display names | |
| US10382524B2 (en) | Processing data received via a network from multiple client devices | |
| US8612479B2 (en) | Systems and methods for monitoring and detecting fraudulent uses of business applications | |
| US8626570B2 (en) | Method and system for data quality management | |
| US9047164B2 (en) | Calculating defect density by file and source module | |
| JP2011503681A (en) | Method and system for analysis of systems for matching data records | |
| WO2008018939A2 (en) | Systems and methods for monitoring and detecting fraudulent uses of business applications | |
| US9978031B2 (en) | Systems and methods for monitoring and detecting fraudulent uses of business applications | |
| CN112527774A (en) | Data center building method and system and storage medium | |
| AU2009200674B2 (en) | Data management system | |
| CN110728567B (en) | Electronic invoice reimbursement management system and method | |
| CN116738449A (en) | DSMM-based data security management and control and operation system | |
| Lin | [Retracted] Research on Enterprise Employee Performance Appraisal Management System Based on CS Architecture | |
| US20140108398A1 (en) | Method and System for Recording Responses in a CRM System | |
| US20140108091A1 (en) | Method and System for Attributing Metrics in a CRM System | |
| CN111241141A (en) | Method for rapidly screening problem enterprises of vehicle purchase tax monitoring and management platform | |
| CN115719281A (en) | Capital income and expenditure management system | |
| CN115187122A (en) | Enterprise policy deduction method, device, equipment and medium | |
| US11341166B2 (en) | Method and system for attributing metrics in a CRM system | |
| KR102011694B1 (en) | Public institutional income property linkage data verification system and its recording medium | |
| CN114155118A (en) | Highway engineering safety gridding management method and system | |
| KR20180071699A (en) | System for online monitoring individual information and method of online monitoring the same | |
| CN118174971B (en) | Multi-source heterogeneous data management method and system for network threat | |
| WO2008033939A2 (en) | Contextually analyzing data in tabular and graphical reports |
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 |