IP Library Granted Patent US 9,754,319
Granted Patent B2
US 9,754,319 · App. 13/666,817 · Granted Sep 5, 2017

Source document framework for accounting systems

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,754,319
App. No.
13/666,817
Granted
Sep 5, 2017
Kind
B2
Abstract

A source document framework for accounting systems is described. An apparatus may comprise an accounting application arranged for execution by the processor circuit, the ERP application comprising a source document framework component arranged to create a new source document type to add to heterogeneous source document types, and a source document process component arranged to process source documents of the heterogeneous source document types, with at least one of the heterogeneous source document types including a previous source document type arranged for use with process logic specific to the previous source document type, and process one or more source documents of the new source document type with the process logic specific to the previous source document type. Other embodiments are described and claimed.

Claims (34)

1. A computer-implemented method, comprising:

receiving an electronic communication comprising a source document having unknown processing requirements;

creating a new source document type to process the source document and preserve referential integrity in a database by:

utilizing a set of extension points in computer memory to create a source document header relation with source document header information and a source document line relation with source document line information for a previous source document type, the source document header information and the source document line information being operative to reference at least a portion of the source document for process logic that is specific for use with the previous source document type, and

defining the new source document type with a non-overlapping foreign key reference to the source document header relation; and

storing the source document in the database by using the source document header relation and the source document line relation to reference the source document in that database.

2. The computer-implemented method of claim 1 , wherein the source document header information including a source document header record identifier field and a source relation type field.

3. The computer-implemented method of claim 1 , wherein the source document line information including a source document line record identifier field, a source document header field, and a source relation type field.

4. The computer-implemented method of claim 1 , comprising receiving a request to create a source document of the new source document type.

5. The computer-implemented method of claim 1 , comprising storing a document header relation with document header information for a source document of the new source document type, the document header information including a source document header field of type source document header record identifier.

6. The computer-implemented method of claim 1 , comprising storing a document line relation with document line information for a source document of the new source document type, the document line information including a source document line field of type source document line record identifier.

7. The computer-implemented method of claim 1 , comprising providing a source document framework for referencing source documents of source document types in the database using non-overlapping foreign key constraints.

8. At least one computer-readable storage device comprising instructions that, when executed, cause a system to:

receive an electronic communication comprising a source document having unknown processing requirements;

create a new source document type to process the source document and preserve referential integrity in a database by utilizing a set of extension points in computer memory to create a source document header relation with source document header information and a source document line relation with source document line information for a previous source document type, the source document header information and the source document line information being operative to reference at least a portion of the source document for process logic that is specific for use with the previous source document type and defining the new source document type with a non-overlapping foreign key reference to the source document header relation; and

store the source document in the database by using the source document header relation and the source document line relation to reference the source document in that database.

9. The computer-readable storage device of claim 8 , wherein the source document header information including a source document header record identifier field and a source relation type field.

10. The computer-readable storage device of claim 8 , wherein the source document line information including a source document line record identifier field, a source document header field, and a source relation type field.

11. The computer-readable storage device of claim 8 , comprising instructions that when executed cause the system to receive a request to create a source document of the new source document type.

12. The computer-readable storage device of claim 8 , comprising instructions that when executed cause the system to store a document header relation with document header information for a source document of the new source document type, the document header information including a source document header field of type source document header record identifier.

13. The computer-readable storage device of claim 8 , comprising instructions that when executed cause the system to store a document line relation with document line information for a source document of the new source document type, the document line information including a source document line field of type source document line record identifier.

14. The computer-readable storage device of claim 8 , comprising instructions that when executed cause the system to provide a source document framework for referencing source documents of source document types in the database using non-overlapping foreign key constraints.

15. An apparatus, comprising:

a processor circuit; and

an application arranged for execution by the processor circuit, the application configured to provide services to a database, the application comprising:

a source document framework component arranged to:

receive an electronic communication comprising a source having unknown processing requirements,

create, for an enterprise resource planning (ERP) application, a new source document type from the unknown source document type to process the source document and preserve referential integrity in the database by utilizing a set of extension points in computer memory to create a source document header relation with source document header information and a source document line relation with source document line information for a previous source document type, the source document header information and the source document line information being operative to reference at least a portion of the source document for process logic that is specific for use with the previous source document type and defining the new source document type with a non-overlapping foreign key reference to the source document header relation, and

store the source document in the database by using the source document header relation and the source document line relation to reference the source document in that database.

16. The apparatus of claim 15 , wherein the source document header information including a source document header record identifier field and a source relation type field.

17. The apparatus of claim 15 , wherein the source document line information including a source document line record identifier field, a source document header field, and a source relation type field.

18. The apparatus of claim 15 , wherein source document framework component further operative to receive a request to create a source document of the new source document type.

19. The apparatus of claim 15 , wherein source document framework component further operative to store a document header relation with document header information for a source document of the new source document type, the document header information including a source document header field of type source document header record identifier.

20. The apparatus of claim 15 , wherein source document framework component further operative to provide a source document framework for referencing source documents of source document types in the database using non-overlapping foreign key constraints.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 9, 2014
From: MICROSOFT CORPORATION
To: MICROSOFT TECHNOLOGY LICENSING, LLC
Reel/Frame 034544/0541 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 3, 2013
From: GREEF, ARTHUR; HEALY, JOHN; REINHOLD, DAVID; GALL, MICHAEL; SWAMINATHAN, MANOJ; SCHULZ, RONALD
To: MICROSOFT CORPORATION
Reel/Frame 029564/0243 →