Data verification system and technique
First Claim
Patent Images
1. A method comprising:
- querying a first database associated with a sales order entry program for first entries associated with a transaction;
querying a second database associated with an accounting program for second entries associated with the transaction; and
in response to the querying the first and second databases, generating a file indicating a comparison between the first and second entries.
7 Assignments
0 Petitions
Accused Products
Abstract
A technique includes querying a first database that is associated with a sales order entry program for first entries that are associated with a transaction. A second database that is associated with an accounting program is queried for second entries that are associated with the transaction. In response to the querying the first and second databases, a file is generated that indicates a comparison between the first and second entries.
30 Citations
33 Claims
-
1. A method comprising:
-
querying a first database associated with a sales order entry program for first entries associated with a transaction;
querying a second database associated with an accounting program for second entries associated with the transaction; and
in response to the querying the first and second databases, generating a file indicating a comparison between the first and second entries. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
furnishing a structured query language query to the first database.
-
-
4. The method of claim 1, wherein the querying the first databases comprises:
furnishing a structured query language query to the second database.
-
5. The method of claim 1, wherein the entries are associated with at least one of an amount, a charge class and an account.
-
6. The method of claim 1, wherein the file indicates whether predefined relationships exist between the first and second entries.
-
7. The method of claim 1, wherein the first entries comprise rows of entries, each row associated with a line item of the transaction.
-
8. The method of claim 1, wherein the second entries comprise rows of entries, each row associated with a line item of the transaction.
-
9. The method of claim 1, wherein the generating comprises:
generating a spreadsheet input file to cause cells displayed by a spreadsheet program to display the first entries.
-
10. The method of claim 1, wherein the generating comprises:
generating a spreadsheet input file to cause cells displayed by a spreadsheet program to display the second entries.
-
11. The method of claim 1, wherein the generating comprises:
generating a spreadsheet input file to cause cells displayed by a spreadsheet program to display a comparison between the first and second entries.
-
12. An article comprising a computer readable storage medium storing instructions to cause a processor to:
-
query a first database associated with a sales order entry program for first entries associated with a transaction;
query a second database associated with an accounting program for second entries associated with the transaction; and
in response to the queries of the first and second databases, generate a file indicating a comparison between the first and second entries. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A computer system comprising:
-
a processor;
mass storage storing a first database associated with a sales order entry program and a second database associated with an accounting program, the first database having first entries associated with a transaction and the second database having second entries associated with the transaction; and
a memory storing instructions to cause the processor to;
query the first database for the first entries, query the second database for the second entries, and in response to the queries of the first and second databases, generate a file indicating a comparison between the first and second entries. - View Dependent Claims (24, 25, 26, 27, 28, 29, 30, 31, 32, 33)
-
Specification