# US 10,872,092 B2 · Using flat data input set for simultaneous application of multiple separate calculations rule sets to obtain multiple output results

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 10,872,092 B2
- Document ID: US10872092B2
- Status: Granted
- Kind: B2
- Application number: 15/980,989
- Filed: 2018-05-16
- Published: 2018-11-22
- Granted: 2020-12-22
- Earliest claimed: 2017-05-16
- Assignees: Utegration, LLC
- Applicants: Kai Bi; Michael Bargar
- Inventors: Kai Bi; Michael Bargar
- Web page: https://patentgrep.com/patent/US10872092B2

## CPC

- G06F 16/252: {between a Database Management System and a front-end application}
- G06Q 10/00: Administration; Management
- G06F 16/284: {Relational databases}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- 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

## Abstract

A method may include updating database posting logic to obtain an updated database posting logic that, during a posting process to a database, adds a data field to a new line item being posted via the posting process. The method may further include receiving information from a data provider. The method may further include posting, using the updated database posting logic, the information to the database as a line item including various fields including the data field. The method may further include receiving a request to generate a transactional report. The method may further include using the data field to identify the line item. The method may further include generating the transactional report using the line item.

## Claims

### Claim 1

A method, comprising:
updating database posting logic to obtain an updated database posting logic configured to, during a posting process to a database, add a first data field to a new line item being posted via the posting process, the first data field identifying a relationship of the new line item to a regulatory accounting type of a financial transactional report;
receiving information from a data provider;
before posting the information to the database as a line item comprising a plurality of fields:
adding the first data field to the plurality of fields;
making a determination to split the line item into a first sub-line item and a second sub-line item based on a granularity required for the regulatory accounting type of the financial transactional report;
splitting, based on the determination, the line item to create the first sub-line item and the second sub-line item, the first sub-line item comprising the first data field; and
adding a second data field to the second sub-line item,
wherein:
an aggregate total transaction amount represented by the first sub-line item and the second sub-line item match a total transaction amount of the line item, and
both the first sub-line item and the second sub-line item are used in generating the financial transactional report;
posting, using the updated database posting logic, the information to the database as the line item comprising the plurality of fields;
receiving a request to generate the financial transactional report;
identifying the line item by the first data field identifying the relationship of the line item to the regulatory accounting type of the financial transactional report; and
generating the financial transactional report using the line item.

### Claim 2 (depends on 1)

The method of claim 1, wherein the database is a relational database that provides a real time update to the financial transactional report using the updated database posting logic and the information from the data provider.

### Claim 3

A method comprising:
updating database posting logic to obtain an updated database posting logic configured to, during a posting process to a database, add a first data field to a new line item being posted via the posting process, the first data field identifying a relationship of the new line item to a regulatory accounting type of a financial transactional report;
receiving information from a data provider;
posting, using the updated database posting logic, the information to the database as a line item comprising a plurality of fields, wherein the posting comprises adding the first data field to the plurality of fields, and adding a second data field to the plurality of fields, the second data field added to relate the line item to an asset;
receiving a request to generate a transaction flow trace;
identifying the line item by the second data field identifying the asset, the asset being associated with a project, the project being associated with at least one object selected from a group consisting of a work order and invoice, the object being associated with a cost; and
generating the transaction flow trace using the line item.

### Claim 4 (depends on 1)

The method of claim 1, wherein the database is an in-memory database.

### Claim 5 (depends on 1)

The method of claim 1, wherein the database is managed by a column-oriented database management system.

### Claim 6

A non-transitory computer readable medium comprising instructions that, when executed by a computer processor, perform a method comprising:
updating database posting logic to obtain an updated database posting logic configured to, during a posting process to a database, add a first data field to a new line item being posted via the posting process, the first data field identifying a relationship of the new line item to a regulatory accounting type of a financial transactional report;
receiving information from a data provider;
before posting the information to the database as a line item comprising a plurality of fields:
adding the first data field to the plurality of fields;
making a determination to split the line item into a first sub-line item and a second sub-line item based on a granularity required for the regulatory accounting type of the financial transactional report;
splitting, based on the determination, the line item to create the first sub-line item and the second sub-line item, the first sub-line item comprising the first data field; and
adding a second data field to the second sub-line item,
wherein:
an aggregate total transaction amount represented by the first sub-line item and the second sub-line item match a total transaction amount of the line item, and
both the first sub-line item and the second sub-line item are used in generating the financial transactional report;
posting, using the updated database posting logic, the information to the database as the line item comprising the plurality of fields;
receiving a request to generate the financial transactional report;
identifying the line item by the first data field identifying the relationship of the line item to the regulatory accounting type of the financial transactional report; and
generating the financial transactional report using the line item.

### Claim 7 (depends on 6)

The non-transitory computer readable medium of claim 6, wherein the database is a relational database configured to provide a real time update to the financial transactional report using the updated database posting logic and the information from the data provider.

### Claim 8 (depends on 6)

The non-transitory computer readable medium of claim 6, wherein the posting further comprises adding a second data field to the plurality of fields, the second data field added to relate the line item to an asset, wherein the method further comprises:
receiving a request to generate a transaction flow trace;
identifying the line item by the second data field identifying the asset, the asset being associated with a project, the project being associated with at least one object selected from a group consisting of a work order and invoice, the object being associated with a cost; and
generating the transaction flow trace using the line item.

### Claim 9 (depends on 6)

The non-transitory computer readable medium of claim 6, wherein the database is an in-memory database.

### Claim 10 (depends on 6)

The non-transitory computer readable medium of claim 6, wherein the database is managed by a column-oriented database management system.

### Claim 11 (depends on 1)

The method of claim 1, wherein the financial transactional report is one selected from a group consisting of a regulatory accounting report and a financial accounting report.

### Claim 12 (depends on 6)

The non-transitory computer readable medium of claim 6, wherein the financial transactional report is one selected from a group consisting of a regulatory accounting report and a financial accounting report.

### Claim 13 (depends on 3)

The method of claim 3, further comprising
before posting the information to the database as the line item comprising the plurality of fields:
adding the first data field to the plurality of fields;
making a determination to split the line item into a first sub-line item and a second sub-line item based on a granularity required for the regulatory accounting type of the financial transactional report;
splitting, based on the determination, the line item to create the first sub-line item and the second sub-line item, the first sub-line item comprising the first data field; and
adding a second data field to the second sub-line item,
wherein:
an aggregate total transaction amount represented by the first sub-line item and the second sub-line item match a total transaction amount of the line item, and
both the first sub-line item and the second sub-line item are used in generating the financial transactional report.

### Claim 14 (depends on 3)

The method of claim 3, wherein the database is a relational database that provides a real time update to the financial transactional report using the updated database posting logic and the information from the data provider.

### Claim 15 (depends on 3)

The method of claim 3, wherein the database is an in-memory database.

### Claim 16 (depends on 3)

The method of claim 3, wherein the database is managed by a column-oriented database management system.