CN111190999A - Correlation query method and system for red and blue electronic invoices - Google Patents
Correlation query method and system for red and blue electronic invoices Download PDFInfo
- Publication number
- CN111190999A CN111190999A CN201911308536.9A CN201911308536A CN111190999A CN 111190999 A CN111190999 A CN 111190999A CN 201911308536 A CN201911308536 A CN 201911308536A CN 111190999 A CN111190999 A CN 111190999A
- Authority
- CN
- China
- Prior art keywords
- invoice
- blue
- code
- ticket
- red
- 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
- 238000000034 method Methods 0.000 title claims abstract description 31
- 230000000875 corresponding effect Effects 0.000 claims abstract description 55
- 238000011010 flushing procedure Methods 0.000 claims abstract description 24
- 230000002596 correlated effect Effects 0.000 claims abstract description 8
- 238000012797 qualification Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 14
- 238000004590 computer program Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
-
- 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/03—Credit; Loans; Processing thereof
Abstract
The invention discloses a method and a system for inquiring the association of a red and blue electronic invoice, wherein the method comprises the following steps: adding an original invoice code, an original invoice number and a special flushing mark field in an invoice database; calling data in the invoice detail table according to the input query condition to acquire the detailed information of the queried invoice and the invoice code and invoice number of the associated invoice; and performing correlation query according to the invoice code and the invoice number of the blue ticket to acquire detailed information of the correlated invoice. The method stores the invoice codes and the invoice numbers of the input blue invoices respectively when issuing the red invoices, can inquire and display one or more red invoices by associating the blue invoices, and can display the corresponding blue invoices by associating the red invoices; the association condition of the red and blue tickets can be accurately inquired. When the operating condition of an enterprise is examined in the financial industry, the bank and the like, the flushing condition and the flushing reason of the enterprise can be accurately reflected, and further the operating condition and the loan qualification of the enterprise are examined.
Description
Technical Field
The invention relates to the technical field of electronic invoices, in particular to a method and a system for association query of a red-blue electronic invoice.
Background
When the current electronic invoice platform inquires invoices, the inquiry is carried out according to inquiry conditions such as invoice types, purchase tax numbers and the like, various inquiry conditions are combined and then submitted to a background for invoice retrieval, and invoice data meeting the inquiry conditions are assembled and then returned to the foreground for display.
However, the current invoice query is optimized by basic query speed and query result display, and information of related invoices cannot be displayed from the query result. The association of red and blue tickets is a major concern for enterprises in certain industries, such as the financial industry. Therefore, a method for inquiring the association of the red and blue electronic invoices is needed to solve the problem of how to quickly and accurately perform the association of the red and blue invoices,
disclosure of Invention
The invention provides a method and a system for association query of a red and blue electronic invoice, which aim to solve the problem of how to quickly and accurately perform red and blue invoice association.
In order to solve the above problem, according to an aspect of the present invention, there is provided a method for querying an association of a red-blue electronic invoice, the method including:
adding an original invoice code, an original invoice number and a special flushing mark field in an invoice database;
calling data in the invoice detail table according to the input query condition to acquire the detailed information of the queried invoice and the invoice code and invoice number of the associated invoice;
and performing correlation query according to the invoice code and the invoice number of the blue ticket to acquire detailed information of the correlated invoice.
Preferably, wherein the method further comprises:
when a red ticket is issued, filling the special red mark according to preset characters to indicate that the red ticket has a corresponding blue ticket, and storing an input invoice code and an invoice number of the blue ticket into an original invoice code and original invoice number field.
Preferably, the performing the correlation query according to the invoice code and the invoice number of the blue ticket to obtain the detailed information of the correlated invoice comprises:
when the inquired invoice is a blue invoice, if one or more corresponding red invoices exist, respectively displaying an invoice code and an invoice number of the corresponding red invoice in the detailed information;
and when the inquired invoice is a red invoice, if a corresponding blue invoice exists, displaying the invoice code and the invoice number of the corresponding blue invoice in the detailed information.
Preferably, wherein the correlation query is performed according to the invoice code and the invoice number of the blue ticket to obtain the detailed information of the correlated invoice, the correlation query comprises:
acquiring the detailed information of any corresponding red ticket through the invoice code and the invoice number of the blue ticket in the following way;
the SELECT detailed information FROM invoice detail table WHERE original invoice code is 'the invoice code of the blue ticket' and the original invoice number is 'the invoice number of the blue ticket' and the special flushing mark is 'the preset character';
acquiring the detailed information of the corresponding blue ticket through the invoice code and the invoice number of the blue ticket by using the following modes:
the SELECT detailed information FROM invoice detail table WHERE invoice code is 'the invoice code of the blue ticket' and the invoice number is 'the invoice number of the blue ticket'.
Preferably, wherein the detailed information includes:
the system comprises a purchaser taxpayer name, a purchaser taxpayer identification number, a purchaser address phone, a purchaser bank account number, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a seller taxpayer name, a seller taxpayer identification number, a seller address phone, a seller bank account number, a remark, a drawer, a payee, a rechecker, and an invoice status.
According to another aspect of the present invention, there is provided a system for querying correlation of red and blue electronic invoices, the system comprising:
the field increasing unit is used for increasing an original invoice code, an original invoice number and a special flushing mark field in the invoice database;
the invoice inquiry unit is used for calling data in the invoice detail table according to the input inquiry condition so as to acquire the inquired invoice detailed information and the invoice code and the invoice number of the associated invoice;
and the correlation query unit is used for performing correlation query according to the invoice code and the invoice number of the blue ticket so as to acquire the detailed information of the correlation invoice.
Preferably, wherein the system further comprises:
and the data filling unit is used for filling the special red mark according to preset characters when a red ticket is issued so as to indicate that the red ticket invoice has a corresponding blue ticket, and storing the input invoice code and invoice number of the blue ticket into the original invoice code and original invoice number field.
Preferably, the invoice inquiry unit further includes:
when the inquired invoice is a blue invoice, if one or more corresponding red invoices exist, respectively displaying an invoice code and an invoice number of the corresponding red invoice in the detailed information;
and when the inquired invoice is a red invoice, if a corresponding blue invoice exists, displaying the invoice code and the invoice number of the corresponding blue invoice in the detailed information.
Preferably, the association query unit performs association query according to the invoice code and the invoice number of the blue ticket to obtain detailed information of an associated invoice, including:
acquiring the detailed information of any corresponding red ticket through the invoice code and the invoice number of the blue ticket in the following way;
the SELECT detailed information FROM invoice detail table WHERE original invoice code is 'the invoice code of the blue ticket' and the original invoice number is 'the invoice number of the blue ticket' and the special flushing mark is 'the preset character';
acquiring the detailed information of the corresponding blue ticket through the invoice code and the invoice number of the blue ticket by using the following modes:
the SELECT detailed information FROM invoice detail table WHERE invoice code is 'the invoice code of the blue ticket' and the invoice number is 'the invoice number of the blue ticket'.
Preferably, wherein the detailed information includes:
the system comprises a purchaser taxpayer name, a purchaser taxpayer identification number, a purchaser address phone, a purchaser bank account number, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a seller taxpayer name, a seller taxpayer identification number, a seller address phone, a seller bank account number, a remark, a drawer, a payee, a rechecker, and an invoice status.
The invention provides a method and a system for inquiring the association of a red and blue electronic invoice, which comprises the following steps: adding an original invoice code, an original invoice number and a special flushing mark field in an invoice database; calling data in the invoice detail table according to the input query condition to acquire the detailed information of the queried invoice and the invoice code and invoice number of the associated invoice; and performing correlation query according to the invoice code and the invoice number of the blue ticket to acquire detailed information of the correlated invoice. According to the method, the fields of the database are redesigned, the original invoice code, the original invoice number and the special red mark field are added, the invoice code and the invoice number of the input blue invoice are respectively stored when a red invoice is issued, one or more red invoices can be associated through the blue invoice to perform query display, and the corresponding blue invoice is displayed through red invoice association; the association condition of the red and blue tickets can be accurately inquired. When the operating condition of an enterprise is examined in the financial industry, the bank and the like, the flushing condition and the flushing reason of the enterprise can be accurately reflected, and further the operating condition and the loan qualification of the enterprise are examined.
Drawings
A more complete understanding of exemplary embodiments of the present invention may be had by reference to the following drawings in which:
fig. 1 is a flowchart of an association query method 100 for red and blue electronic invoices according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a red ticket associated with a blue ticket according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a blue ticket associated with a red ticket according to an embodiment of the present invention; and
fig. 4 is a schematic structural diagram of an association query system 400 for red and blue electronic invoices according to an embodiment of the present invention.
Detailed Description
The exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, however, the present invention may be embodied in many different forms and is not limited to the embodiments described herein, which are provided for complete and complete disclosure of the present invention and to fully convey the scope of the present invention to those skilled in the art. The terminology used in the exemplary embodiments illustrated in the accompanying drawings is not intended to be limiting of the invention. In the drawings, the same units/elements are denoted by the same reference numerals.
Unless otherwise defined, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Further, it will be understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense.
Fig. 1 is a flowchart of an association query method 100 for red and blue electronic invoices according to an embodiment of the present invention. As shown in fig. 1, in the method for querying the association of the red and blue electronic invoices provided by the embodiment of the present invention, by redesigning the fields of the database, the original invoice code, the original invoice number and the special flushing mark field are added, and the blue invoice can be associated with one or more red tickets for querying and displaying, and the red ticket is associated with and displays the corresponding blue ticket; the association condition of the red and blue tickets can be accurately inquired. When the operating condition of an enterprise is examined in the financial industry, the bank and the like, the flushing condition and the flushing reason of the enterprise can be accurately reflected, and further the operating condition and the loan qualification of the enterprise are examined. The method 100 for querying the association of the red and blue electronic invoices provided by the embodiment of the invention starts from step 101, and adds an original invoice code, an original invoice number and a special flushing mark field in an invoice database in step 101.
Preferably, wherein the method further comprises:
when a red ticket is issued, filling the special red mark according to preset characters to indicate that the red ticket has a corresponding blue ticket, and storing an input invoice code and an invoice number of the blue ticket into an original invoice code and original invoice number field.
The existing invoice codes and invoice numbers for extracting the red and blue tickets comprise: based on the existing database field, the invoice code and the invoice number of the red ticket are extracted from the remark, and then association of the red and blue tickets is carried out. Specifically, when a red-word electronic invoice is issued, the invoice code and the invoice number of the corresponding blue ticket are fixedly displayed in the remark, the remark allows modification, text or numerical information can be added before, during and after the fixed format, and the filling content is not limited. If the invoice code and the invoice number of the blue ticket are extracted from the remarks, the information extraction is difficult because the filling content and habits of taxpayers cannot be specified. If the invoice code and invoice number extraction is inaccurate, accuracy is seriously affected when enterprise qualification scrutiny and red ticket scrutiny are carried out for certain industries such as banking.
Therefore, in the embodiment of the invention, an index field is added in the database for recording the invoice code and the invoice number of the blue ticket corresponding to the red ticket. Three fields of original invoice codes, original invoice numbers and special flushing marks are added in the data. When the special flushing mark is '0' when a red ticket is issued, the red ticket is proved to have a corresponding blue ticket, the input invoice code and invoice number of the blue ticket are stored in the field of the original invoice code and original invoice number, and data assembly is directly carried out according to the original invoice code and original invoice number when correlation query is needed.
In step 102, the data in the invoice detail table is called according to the input query condition to obtain the detailed information of the queried invoice and the invoice code and invoice number of the associated invoice.
Preferably, wherein the detailed information includes: the system comprises a purchaser taxpayer name, a purchaser taxpayer identification number, a purchaser address phone, a purchaser bank account number, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a seller taxpayer name, a seller taxpayer identification number, a seller address phone, a seller bank account number, a remark, a drawer, a payee, a rechecker, and an invoice status.
Preferably, wherein the method further comprises:
when the inquired invoice is a blue invoice, if one or more corresponding red invoices exist, respectively displaying an invoice code and an invoice number of the corresponding red invoice in the detailed information;
and when the inquired invoice is a red invoice, if a corresponding blue invoice exists, displaying the invoice code and the invoice number of the corresponding blue invoice in the detailed information.
Fig. 2 is a schematic diagram of red ticket associated with blue ticket according to the embodiment of the present invention. As shown in fig. 2, when the query is a red ticket, the invoice code and the invoice number of the associated blue ticket will also appear simultaneously.
Fig. 3 is a schematic diagram of a blue ticket associated with a red ticket according to an embodiment of the invention. As shown in fig. 3, when the query is a blue ticket, the invoice code and the invoice number of the associated red ticket may also appear simultaneously, and the corresponding red ticket may be plural.
In step 103, a correlation query is performed according to the invoice code and the invoice number of the blue ticket to obtain detailed information of a correlation invoice.
Preferably, wherein the correlation query is performed according to the invoice code and the invoice number of the blue ticket to obtain the detailed information of the correlated invoice, the correlation query comprises:
acquiring the detailed information of any corresponding red ticket through the invoice code and the invoice number of the blue ticket in the following way;
the SELECT detailed information FROM invoice detail table WHERE original invoice code is 'the invoice code of the blue ticket' and the original invoice number is 'the invoice number of the blue ticket' and the special flushing mark is 'the preset character';
acquiring the detailed information of the corresponding blue ticket through the invoice code and the invoice number of the blue ticket by using the following modes:
the SELECT detailed information FROM invoice detail table WHERE invoice code is 'the invoice code of the blue ticket' and the invoice number is 'the invoice number of the blue ticket'.
In the embodiment of the invention, the original invoice code and the original invoice number field are added in the database, when a red ticket is issued, the invoice code and the invoice number of the corresponding blue ticket are directly stored, and a special red mark field is added in the database, when the special red mark is '0', the red ticket is indicated to have the corresponding blue ticket, and then, carrying out related inquiry on a corresponding blue ticket invoice code and an invoice number in a database through an SQL statement, assembling a field data source (cloud invoicing (web) App invoicing), an invoice type, the invoice code, the invoice number, an invoicing type (red/blue ticket), a purchaser name, a purchaser taxpayer tax number, a seller name, a seller taxpayer tax number, a total amount, a total tax amount, a price tax amount, an invoicing date, a purchaser mailbox, a ticket holder mobile phone number and a current state after inquiry, and displaying corresponding invoice detail information when an invoice detail page needs to be displayed in a skipping mode.
When the invoice inquiry shows the blue-ticket invoice details, if one or more red tickets exist, the invoice code and the invoice number of the red ticket are respectively displayed, page skip of the red-ticket invoice details can be realized, and if more red tickets exist, skip can be respectively realized.
When the invoice inquiry shows the details of the red invoice, only one corresponding blue invoice code and invoice number are displayed, and page skip can be realized.
The method specifically comprises the following steps:
1. according to the query condition input by the foreground. For example: the tax payer identification number and other information obtain invoice body data in an XXFP table. The contents displayed in list form in the foreground include: serial number, data source (cloud billing (web) App billing), invoice type, invoice code, invoice number, billing type (red/blue invoice), purchaser name, amount, billing date, purchaser mailbox, handset number of ticket holder, current status.
2. Clicking a detail button of an invoice list operation item to acquire detailed invoice information from an invoice detail table for interface display; comprises the following contents: the invoice code and invoice number associated with the purchaser taxpayer name, purchaser taxpayer identification number, purchaser address phone, purchaser bank account number, commodity name, specification model number, metering unit, quantity, unit price, amount, tax rate, tax amount, aggregate amount, tax price aggregate, seller taxpayer name, seller taxpayer identification number, seller address phone, seller bank account number, remark, drawer, payee, reviewer, and red and blue ticket, and invoice status.
When the red ticket is associated through the blue ticket, the corresponding SQL query statement is: the method comprises the following steps of selecting a name of a taxpayer of a buyer, a taxpayer identification number of the buyer, a telephone of an address of the buyer, a bank account number of the buyer, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a name of a taxpayer of the seller, a taxpayer identification number of the seller, a telephone of an address of the seller, a bank account number of the seller, a remark, a drawer, a payee, a rechecker, an invoice status FROM sales invoice detail table WHERE original invoice code and original invoice code are ' invoice code of blue ticket ' and original invoice number ' and special flushing mark of blue ticket ' 0 '.
SQL query statement for red ticket associated blue ticket:
the SELECT buyer tax payer name, the buyer tax payer identification number, the buyer address phone, the buyer bank account number, the commodity name, the specification model, the metering unit, the quantity, the unit price, the amount, the tax rate, the tax amount, the total amount, the tax price total, the seller tax payer name, the seller tax payer identification number, the seller address phone, the seller bank account number, the remark, the drawer, the payee, the rechecker, the invoice status FROM sales invoice statement WHERE invoice code is the invoice code ' of the blue invoice and the invoice number is the invoice number ' of the blue invoice '.
Fig. 4 is a schematic structural diagram of an association query system 400 for red and blue electronic invoices according to an embodiment of the present invention. As shown in fig. 4, the system 400 for querying the association between the red and blue electronic invoices provided by the embodiment of the present invention includes: a field adding unit 401, an invoice querying unit 402 and an association querying unit 403.
Preferably, the field adding unit 401 is configured to add a primary invoice code, a primary invoice number, and a special flushing mark field in an invoice database.
Preferably, wherein the system further comprises: and the data filling unit is used for filling the special red mark according to preset characters when a red ticket is issued so as to indicate that the red ticket invoice has a corresponding blue ticket, and storing the input invoice code and invoice number of the blue ticket into the original invoice code and original invoice number field.
Preferably, the invoice query unit 402 is configured to invoke data in the invoice detail table according to the input query condition to obtain the queried invoice detail information and the invoice code and invoice number of the associated invoice.
Preferably, the invoice query unit 402 further includes:
when the inquired invoice is a blue invoice, if one or more corresponding red invoices exist, respectively displaying an invoice code and an invoice number of the corresponding red invoice in the detailed information;
and when the inquired invoice is a red invoice, if a corresponding blue invoice exists, displaying the invoice code and the invoice number of the corresponding blue invoice in the detailed information.
Preferably, the association query unit 403 is configured to perform association query according to the invoice code and the invoice number of the blue ticket to obtain detailed information of the associated invoice.
Preferably, the association query unit 403 performs association query according to the invoice code and the invoice number of the blue ticket to obtain detailed information of an associated invoice, including:
acquiring the detailed information of any corresponding red ticket through the invoice code and the invoice number of the blue ticket in the following way;
the SELECT detailed information FROM invoice detail table WHERE original invoice code is 'the invoice code of the blue ticket' and the original invoice number is 'the invoice number of the blue ticket' and the special flushing mark is 'the preset character';
acquiring the detailed information of the corresponding blue ticket through the invoice code and the invoice number of the blue ticket by using the following modes:
the SELECT detailed information FROM invoice detail table WHERE invoice code is 'the invoice code of the blue ticket' and the invoice number is 'the invoice number of the blue ticket'.
Preferably, wherein the detailed information includes: the system comprises a purchaser taxpayer name, a purchaser taxpayer identification number, a purchaser address phone, a purchaser bank account number, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a seller taxpayer name, a seller taxpayer identification number, a seller address phone, a seller bank account number, a remark, a drawer, a payee, a rechecker, and an invoice status.
The system 200 for determining the operation quality of the power enterprise communication network according to the embodiment of the present invention corresponds to the method 100 for determining the operation quality of the power enterprise communication network according to another embodiment of the present invention, and is not described herein again.
The invention has been described with reference to a few embodiments. However, other embodiments of the invention than the one disclosed above are equally possible within the scope of the invention, as would be apparent to a person skilled in the art from the appended patent claims.
Generally, all terms used in the claims are to be interpreted according to their ordinary meaning in the technical field, unless explicitly defined otherwise herein. All references to "a/an/the [ device, component, etc ]" are to be interpreted openly as referring to at least one instance of said device, component, etc., unless explicitly stated otherwise. The steps of any method disclosed herein do not have to be performed in the exact order disclosed, unless explicitly stated.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application 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 application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting the same, and although the present invention is described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications and equivalents may be made to the embodiments of the invention without departing from the spirit and scope of the invention, which is to be covered by the claims.
Claims (10)
1. A method for querying association of red and blue electronic invoices is characterized by comprising the following steps:
adding an original invoice code, an original invoice number and a special flushing mark field in an invoice database;
calling data in the invoice detail table according to the input query condition to acquire the detailed information of the queried invoice and the invoice code and invoice number of the associated invoice;
and performing correlation query according to the invoice code and the invoice number of the blue ticket to acquire detailed information of the correlated invoice.
2. The method of claim 1, further comprising:
when a red ticket is issued, filling the special red mark according to preset characters to indicate that the red ticket has a corresponding blue ticket, and storing an input invoice code and an invoice number of the blue ticket into an original invoice code and original invoice number field.
3. The method according to claim 1, characterized in that it comprises:
when the inquired invoice is a blue invoice, if one or more corresponding red invoices exist, respectively displaying an invoice code and an invoice number of the corresponding red invoice in the detailed information;
and when the inquired invoice is a red invoice, if a corresponding blue invoice exists, displaying the invoice code and the invoice number of the corresponding blue invoice in the detailed information.
4. The method according to claim 1, wherein the performing of the correlation query according to the invoice code and the invoice number of the blue ticket to obtain the detailed information of the correlated invoice comprises:
acquiring the detailed information of any corresponding red ticket through the invoice code and the invoice number of the blue ticket in the following way;
the SELECT detailed information FROM invoice detail table WHERE original invoice code is 'the invoice code of the blue ticket' and the original invoice number is 'the invoice number of the blue ticket' and the special flushing mark is 'the preset character';
acquiring the detailed information of the corresponding blue ticket through the invoice code and the invoice number of the blue ticket by using the following modes:
the SELECT detailed information FROM invoice detail table WHERE invoice code is 'the invoice code of the blue ticket' and the invoice number is 'the invoice number of the blue ticket'.
5. The method of claim 1, wherein the detailed information comprises:
the system comprises a purchaser taxpayer name, a purchaser taxpayer identification number, a purchaser address phone, a purchaser bank account number, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a seller taxpayer name, a seller taxpayer identification number, a seller address phone, a seller bank account number, a remark, a drawer, a payee, a rechecker, and an invoice status.
6. An association query system for red and blue electronic invoices, which is characterized by comprising:
the field increasing unit is used for increasing an original invoice code, an original invoice number and a special flushing mark field in the invoice database;
the invoice inquiry unit is used for calling data in the invoice detail table according to the input inquiry condition so as to acquire the inquired invoice detailed information and the invoice code and the invoice number of the associated invoice;
and the correlation query unit is used for performing correlation query according to the invoice code and the invoice number of the blue ticket so as to acquire the detailed information of the correlation invoice.
7. The system of claim 6, further comprising:
and the data filling unit is used for filling the special red mark according to preset characters when a red ticket is issued so as to indicate that the red ticket invoice has a corresponding blue ticket, and storing the input invoice code and invoice number of the blue ticket into the original invoice code and original invoice number field.
8. The system of claim 6, wherein the invoice presentment unit further comprises:
when the inquired invoice is a blue invoice, if one or more corresponding red invoices exist, respectively displaying an invoice code and an invoice number of the corresponding red invoice in the detailed information;
and when the inquired invoice is a red invoice, if a corresponding blue invoice exists, displaying the invoice code and the invoice number of the corresponding blue invoice in the detailed information.
9. The system according to claim 6, wherein the association query unit performs association query according to the invoice code and the invoice number of the blue ticket to obtain detailed information of the associated invoice, and comprises:
acquiring the detailed information of any corresponding red ticket through the invoice code and the invoice number of the blue ticket in the following way;
the SELECT detailed information FROM invoice detail table WHERE original invoice code is 'the invoice code of the blue ticket' and the original invoice number is 'the invoice number of the blue ticket' and the special flushing mark is 'the preset character';
acquiring the detailed information of the corresponding blue ticket through the invoice code and the invoice number of the blue ticket by using the following modes:
the SELECT detailed information FROM invoice detail table WHERE invoice code is 'the invoice code of the blue ticket' and the invoice number is 'the invoice number of the blue ticket'.
10. The system of claim 6, wherein the detailed information comprises:
the system comprises a purchaser taxpayer name, a purchaser taxpayer identification number, a purchaser address phone, a purchaser bank account number, a commodity name, a specification model, a metering unit, a quantity, a unit price, an amount, a tax rate, a tax amount, a total amount, a tax price total, a seller taxpayer name, a seller taxpayer identification number, a seller address phone, a seller bank account number, a remark, a drawer, a payee, a rechecker, and an invoice status.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911308536.9A CN111190999A (en) | 2019-12-18 | 2019-12-18 | Correlation query method and system for red and blue electronic invoices |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911308536.9A CN111190999A (en) | 2019-12-18 | 2019-12-18 | Correlation query method and system for red and blue electronic invoices |
Publications (1)
Publication Number | Publication Date |
---|---|
CN111190999A true CN111190999A (en) | 2020-05-22 |
Family
ID=70709968
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911308536.9A Pending CN111190999A (en) | 2019-12-18 | 2019-12-18 | Correlation query method and system for red and blue electronic invoices |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111190999A (en) |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU2004101029A4 (en) * | 2003-12-05 | 2005-09-15 | Small Business Creative Solutions Pty Ltd | Invoicing method and system |
US20090067013A1 (en) * | 2007-09-10 | 2009-03-12 | Graeme Neville Dixon | Systems and methods to associate invoice data with a corresponding original invoice copy in a stack of invoices |
US20140052641A1 (en) * | 2012-08-20 | 2014-02-20 | Tsinghua University | Electronic Invoice Issuing System For Electronic Commerce Website |
CN104268779A (en) * | 2014-09-30 | 2015-01-07 | 税友软件集团股份有限公司 | Method and system for generating red mark electronic invoice |
CN106408358A (en) * | 2016-12-08 | 2017-02-15 | 用友网络科技股份有限公司 | Invoice management method and invoice management apparatus |
CN106933879A (en) * | 2015-12-30 | 2017-07-07 | 航天信息股份有限公司 | Invoice data tracking and system |
CN109949113A (en) * | 2019-03-21 | 2019-06-28 | 南京金信通信息服务有限公司 | A kind of VAT invoice online management system |
-
2019
- 2019-12-18 CN CN201911308536.9A patent/CN111190999A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU2004101029A4 (en) * | 2003-12-05 | 2005-09-15 | Small Business Creative Solutions Pty Ltd | Invoicing method and system |
US20090067013A1 (en) * | 2007-09-10 | 2009-03-12 | Graeme Neville Dixon | Systems and methods to associate invoice data with a corresponding original invoice copy in a stack of invoices |
US20140052641A1 (en) * | 2012-08-20 | 2014-02-20 | Tsinghua University | Electronic Invoice Issuing System For Electronic Commerce Website |
CN104268779A (en) * | 2014-09-30 | 2015-01-07 | 税友软件集团股份有限公司 | Method and system for generating red mark electronic invoice |
CN106933879A (en) * | 2015-12-30 | 2017-07-07 | 航天信息股份有限公司 | Invoice data tracking and system |
CN106408358A (en) * | 2016-12-08 | 2017-02-15 | 用友网络科技股份有限公司 | Invoice management method and invoice management apparatus |
CN109949113A (en) * | 2019-03-21 | 2019-06-28 | 南京金信通信息服务有限公司 | A kind of VAT invoice online management system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110286974B (en) | Application configuration method, device, equipment and storage medium based on H5 page | |
US20050203791A1 (en) | Method and system for anticipating, identifying, analyzing and meeting consumer needs | |
CN110716951A (en) | Label configuration method, device and equipment convenient to configure and storage medium | |
WO2004066170A1 (en) | Performance monitoring system, method and apparatus | |
CN110852545A (en) | Unified service management method and platform | |
TWI501617B (en) | System and method for issuing electronic invoice by mobile phone | |
CN111815378A (en) | Management system and method for generating invoice based on bill collection | |
US11657218B2 (en) | Custom template generation using universal code | |
CN116400913A (en) | Business process generation method and device | |
CN111190999A (en) | Correlation query method and system for red and blue electronic invoices | |
CN104205134A (en) | Mobile terminal management server, and mobile terminal management program | |
EP3819848A1 (en) | Wallet system and non-transitory storage medium | |
US9721306B2 (en) | Data linkage support system and data linkage support method | |
JP2023032983A (en) | Program, system, and method | |
CN112862033A (en) | Bar code scanning and bar code associated information sending method, device, equipment and medium | |
CN105404671A (en) | Implementation method and apparatus for mobile terminal electronic billing | |
CN112529625A (en) | Method and device for generating enterprise tax portrait, storage medium and electronic equipment | |
CN101742022A (en) | Prepayment system and method | |
CN111210329A (en) | Accounting document generation method and device, storage medium and electronic equipment | |
KR101270492B1 (en) | System and method for managing sales and uncollected amount | |
Jones | Spotlight on midlevel ERP software | |
KR20200102708A (en) | Method for standardizing documents of electronic transaction | |
CN103226770A (en) | POS (Point-of-Sale) terminal charging method | |
KR102476029B1 (en) | System for managing business opportunity | |
KR102236835B1 (en) | System and method that automatically generates quotations through calculating material cost and labor cost estimates based on web-based standard of estimate |
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 |