Method for conducting storage analyzing on general invoice data

A common invoice, storage and analysis technology, applied in the field of storage and analysis of common invoice data, can solve the problems of multi-table backup, unfavorable integrity preservation, easy to form deadlocks, etc., to ensure integrity and consistency, and meet fast The effect of inspection requirements and good template extensibility

Active Publication Date: 2015-03-25
JIANGSU AISINO TECH
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The problems existing in the above existing technologies are: ⑴The method of adding multiple sub-tables to one main table: a) The main key of the sub-table is a mandatory external key of the main table to maintain consistency, which puts a great pressure on the performance of the database; b) Since there are multiple rows in the subtable, it is very easy to delete one row, which is not conducive to maintaining integrity; c) Since there are many tables and maintenance is difficult, when backing up invoice data, multiple table backups are required, and deadlocks are easily formed, and It is not conducive to the use of partition table tech

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for conducting storage analyzing on general invoice data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0018] This embodiment is a method for storing and analyzing ordinary invoice data, such as figure 1 As shown, firstly, ordinary invoice storage is divided into three parts: main pole information, detailed main information and microstructure. Main post information refers to the common fields of various invoices, including: invoice code, invoice number, invoice security code, taxpayer identification number of issuer, name of issuer, taxpayer identification number of issuer, taxpayer of issuer Name, invoicing amount, invoicing time, invoicing status, and invoice data source type, etc., which are mainly used to deal with general invoice inquiries; the detailed main information refers to the item with the largest amount among the detailed items in the invoice. If there are multiple items with the largest amount, Then take the first one, including the item name, quantity, unit price and amount in this detailed information, which can be used to check the authenticity of the invoice;...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for conducting storage analyzing on common general invoice data. Database table single recording, invoice fast checking, a microstructure and JAVA reflection kind secondary analyzing are used; trunk and detail main information is automatically identified through an invoice template base class; a corresponding specific invoice template class is found from an automatic template management class through a template code analyzed in the template base class; a specific invoice template class is generated through a reflection technology, and nodes in the microstructure are completely analyzed; finally, the specific invoice template class is sent back. The completeness and the consistency of invoice data can be ensured, secondary analyzing does not need to be conducted, fast inquiry can be directly conducted, secondary analyzing work can be automatically conducted on the microstructure, the microstructure is easily packaged, and the access of invoices is simplified.

Description

technical field [0001] The invention relates to a technology for storing and analyzing invoice information in a network invoice issuing system, in particular to a method for storing and analyzing common invoice data. Background technique [0002] At present, the storage and analysis methods for ordinary invoices with many samples are purely based on the database, and at most they are stored in conjunction with the code table. When storing, there are usually the following two methods: one main table plus multiple sub-tables or one Each template invoice corresponds to a table. [0003] For the way of adding multiple sub-tables to one main table, it is to store the invoices in common in one main table, and store the invoice details of different templates in different sub-tables according to the template type, and check the main table first when querying. Then look up the subtable according to the template type, so that a complete invoice can be parsed out. For a template invo...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06Q40/00G06F17/30
Inventor 徐烨
Owner JIANGSU AISINO TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap