Recurrent billing maintenance system

• US 7,035,872 B2
• Filed: 05/25/2001
• Issued: 04/25/2006
• Est. Priority Date: 05/25/2000
• Status: Expired due to Term

• Current Assignee: Liberty Peak Ventures, LLC (Dominion Harbor Enterprises, LLC)
• Original Assignee: American Express Travel Related Services Company, Inc. (American Express Company)
• Inventors: Holt, Donald H., Phillips, Susan, Griggs, Fred, Freeman, Tina, Zinky, Allan T., Milton, Charles, Cato, Lloyd G., Bailey, Maria S., Ganoe, Nancy S., Peters, Patricia K., Cruz, Alicia, Petersen, Paul M.
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US09/865,878
• Publication Number:
  US 20020004770A1
• Time in Patent Office: 1,796 Days
• Field of Search: 707/102, 707/2, 707/3, 707/200, 707/8, 707/203, 707/204, 707/104.1, 707/10, 705/14, 705/1, 705/21, 705/26, 705/34, 705/40, 235/380, 709/217, 709/218
• US Class Current: 1/1
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 20/14 specially adapted for billing systems
• CPC Class Codes: G06Q 20/202 Interconnection or interaction of plural electronic cash registers [ECR] or to host computer, e.g. network details, transfer of information from host to ECR or from ECR to ECR
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A system for updating a merchant customer account database is provided, wherein the system may be used to update a merchant'"'"'s customer database in response to changes made to a customer transaction account. The system provides a remote database location which stores a merchant'"'"'s customer transaction account information for customers using the transaction account for recurring billing purposes. A server is used to manage the remote database information to update the remote database in response to changes in transaction account information. The updated transaction account information is then periodically provided to the merchant for use in updating the merchant'"'"'s customer account database.

Claims

1. A computer implemented service for updating a merchant customer transaction account database over a network, comprising:

a first database of information having a plurality of merchant customer records;

a remote merchant customer database having a first plurality of customer transaction account records;

a process server for appending a provider processing instruction to at least one of said first plurality of customer transaction account records to produce a merchant processing request data file; and

a process server for receiving said merchant processing request data file, said process server configured to compare data consistency between said first database of information and said merchant processing request data file to produce a first comparison data file, said first comparison data file comprising a first record including a compilation of said merchant processing request data files accepted for processing by said process server, said first comparison data file further comprising a second record including a compilation of said merchant processing request data files rejected for processing by said process server, said process server further configured to at least one of update said first database of information in accordance with said provider processing instruction, wherein said provider processing instruction is appended to said merchant processing request data file and synchronize said first database with said merchant processing request data file.

2. A computer implemented service according to claim 1 wherein, said service further comprises a second database of information having a second plurality of customer transaction accounts records.

3. A computer implemented service according to claim 2 wherein, said process server is configured to receive said second database of information, said process server configured to compare said first database of information and said second database of information to produce a second comparison data file, said second comparison file comprising a plurality of updated customer transaction account records, said process server further configured to update said first database of information in accordance with said second database of information.

4. A computer implemented service according to claim 3, wherein, said process server is further configured to append a provider processing instruction to at least one of said plurality of updated customer transaction account records to produce a provider processing request data file.

5. A computer implemented service, according to claim 4, wherein said process server is configured to generate an update summary file, said update summary file comprising at least one of said first comparison data file and said provider processing request data file.

6. A computer implemented service according to claim 5, wherein said update summary file is provided to said process server daily.

7. A computer implemented service according to claim 5 wherein, said process server is configured to retrieve said update summary file.

8. A computer implemented service according to claim 7 wherein, said process server is further configured to update said remote merchant customer database in accordance with said update summary file.

9. A computer implemented service according to claim 1 wherein, said at least one of said first plurality of customer transaction account records is pre-authorized.

10. A computer implemented service according to claim 1 wherein, said at least one of said first plurality of customer transaction account records is provided said merchant processing request data file indicating that said at least one of said first plurality of customer transaction account records is to be removed from at feast one of said plurality of merchant customer records.

11. A computer implemented service according to claim 1, wherein said at least one of said first plurality of customer transaction account records is provided said merchant processing request data file indicating that said at least one of said first plurality of distinct customer transaction card records requires alteration by said process server.

12. A computer implemented service according to claim 1, wherein said remote merchant customer database is configured to be updated manually.

13. A computer implemented service according to claim 7, wherein said process server is configured to update said remote merchant customer database in accordance with said provider processing instruction.

14. A computer implemented service according to claim 1, wherein said merchant request data files rejected for processing are verified.

15. A computer implemented service according to claim 13, wherein said merchant process server appends said merchant request data files rejected for processing to said merchant process request data file.

16. A computer implemented service according to claim 13, wherein said merchant process request data file includes said merchant request data files rejected for processing.

17. A computer implemented service according to claim 1, wherein said process server is configured to tally a number of rejected merchant processing request data files.

18. A computer implemented service according to claim 17, wherein said process server comprises a predetermined rejection threshold.

19. A computer implemented service according to claim 18, wherein said process server compares said predetermined rejection threshold to said tally of the said number of rejected merchant process request data files, said process server further configured to reject said merchant process request data file when said predetermined rejection threshold is reached.

20. A computer implemented service according to claim 5, wherein said process server is configured to tally said merchant processing request data files accepted for processing, in accordance with a merchant process request grouping.

21. A computer implemented service according to claim 20, wherein said update summary file comprises said tally.

22. A computer implemented service according to claim 1, wherein at least one of said first plurality of customer transaction accounts is outdated, said process server being configured to add said outdated at least one of said first plurality of customer transaction account records to said first database of information, said outdated one of said first plurality of customer transaction account records remaining permanently fixed.

36. A computer implemented service according to claim 1, wherein said process server comprises a rejection threshold, said rejection threshold being set such that where said rejection threshold is reached, said registry file is rejected by said server, said rejection threshold being reached when a predetermined number of said third plurality of customer transaction account records is rejected by said process server.

39. A computer implemented service according to claim 36, wherein said process server provides a summary report to said merchant database processor, said summary report comprising information corresponding to at least one of the number of said third plurality of customer transaction account records processed by said process server and the number of said third plurality of customer transaction account records rejected by said process server.

23. A computer implemented service for updating a merchant customer transaction account database over a network, comprising:

a first database of information having a plurality of merchant customer records wherein each of said merchant customer records further comprises a first plurality of customer transaction account records;

a second database of information having a second plurality of customer transaction account records;

a first remote merchant customer database stored on a remote merchant computer having a merchant database processor, said first remote merchant customer database having a third plurality of customer transaction account records, said first remote merchant customer database configured to provide at least one of said third plurality of customer transaction account records in a registry file, said at least one of said third plurality of customer transaction account records being provided a provider processing instruction; and

a process server for receiving said registry file, comparing data consistency between said at least one of said third plurality of customer transaction account records in said registry file to at least one of said first plurality of customer transaction account records comprising said plurality of merchant customer records and providing a daily maintenance file, wherein said comparison is completed according to a predetermined order of steps corresponding to said provider processing instruction appended to said registry file, said daily maintenance file comprising a fourth plurality of customer transaction account records, at least one of said fourth plurality of customer transaction account records being provided a return transaction code, said daily maintenance file being provided to said merchant database processor, said merchant database processor at least one of synchronizing and updating at least one of said third plurality of customer transaction account records on said first remote merchant customer database, wherein said third plurality of customer transaction account records correspond to said customer transaction account record having said return transaction code.

24. A computer implemented service according to claim 23, wherein said at least one of said third plurality of customer transaction account records is pre-authorized prior to storing said at least one of said third plurality of customer transaction account records on said first remote merchant customer database.

25. A computer implemented service according to claim 24, wherein said at least one of said third plurality of customer transaction account records is provided a merchant transaction code indicating that said at least one of said third plurality of customer transaction account records is enrolled in said service for updating a merchant customer transaction account database over a network.

26. A computer implemented service according to claim 25, wherein said registry file includes a plurality of said enrolled ones of said third plurality of customer transaction account records.

27. A computer implemented service according to claim 26, wherein said registry file includes a plurality of customer transaction account records of customers paying recurring charges with at least one of said customer transaction account records, said registry file comprising an initial registry file.

28. A computer implemented service according to claim 27, wherein said first plurality of customer transaction accounts includes said initial registry file.

29. A computer implemented service according to claim 25, wherein said at least one of said third plurality of customer transaction account records is provided a provider processing instruction indicating that said at least one of said third plurality of customer transaction account records is removed from said service for updating a merchant customer transaction account database over a network.

30. A computer implemented service according to claim 25, wherein said at least one of said third plurality of customer transaction account records is provided a provider processing instruction indicating that said at least one of said third plurality of customer transaction account records requires alteration by said service for updating a merchant customer transaction account database over a network.

31. A computer implemented service according to claim 23, wherein said registry file is provided to said process server daily.

32. A computer implemented service according to claim 23, wherein said daily maintenance file is provided to said merchant database processor manually for updating at least one of said third plurality of customer transaction account records on said first remote merchant customer database.

33. A computer implemented service according to claim 23, wherein said updating of said at least on of said third plurality of customer transaction account records on said first remote merchant customer database according to a predetermined order of steps corresponding to said return transaction code.

34. A computer implemented service according to claim 23, wherein said daily maintenance file further comprises a rejected records file, said rejected records file comprising said third plurality of customer transaction account records rejected by said process server.

35. A computer implemented service according to claim 34, wherein said those of said third plurality of customer transaction account records rejected by said process server are verified and re-entered in said registry file, wherein said registry file comprising said rejected records file is resubmitted to said process server.

37. A computer implemented service according to claim 23 wherein said daily maintenance file is provided to said merchant database processor daily.

38. A computer implemented service according to claim 23 wherein said daily maintenance files are ordered such that each file may be processed in the ordered in which it was provided to the merchant database processor.

40. A computer implemented service according to claim 23 wherein said process server compares said second plurality of customer credit records to said first plurality of customer transaction account records to provide a server initiated maintenance file comprising a fifth plurality of customer transaction account records, said fifth plurality of customer transaction account records being provided said return transaction code, said daily maintenance file further comprising said fifth plurality of customer transaction account records.

41. A computer implemented service according to claim 26, wherein said at least one of said a plurality of said enrolled ones of said third plurality of customer transaction account records is outdated, said outdated enrolled one of said third plurality of customer transaction account records is provided to said first plurality of customer transaction account records, said outdated enrolled one of said third plurality of customer transaction account records remaining permanently fixed.