| 摘要 |
The present invention discloses a method and system for use in reconciling a first record, which may be selected from a plurality of first records, with a matching record included in a plurality of second records. The first records may comprise a first database and the second records may comprise a second database, or the first records and second records may comprise separate tables within the same database. A search of the second records for records possibly matching the first record is performed. The search may be performed by comparing data within progressively smaller sets of query fields comprised of data fields of the first record to data within corresponding progressively smaller sets of search fields comprised of data fields of the second records. For each pair of query and search field sets, the search generates a set of suggested matching records, which may be empty. The first record and the sets of suggested matching records are then displayed together on a first interface. With the first record and suggested matching records thus displayed, the suggested matching records may be easily reviewed and compared with the first record to determine if any of the suggested records match the first record. If so, data from a predetermined field of the matching record may be copied into a predetermined field of the first record to complete reconciliation of the records.
|
