Using flat data input set for simultaneous application of multiple separate calculations rule sets to obtain multiple output results
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.
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.
2. 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.
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.
4. The method of claim 1 , wherein the database is an in-memory database.
5. The method of claim 1 , wherein the database is managed by a column-oriented database management system.
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.
7. 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.
8. 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.
9. The non-transitory computer readable medium of claim 6 , wherein the database is an in-memory database.
10. The non-transitory computer readable medium of claim 6 , wherein the database is managed by a column-oriented database management system.
11. 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.
12. 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.
13. 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.
14. 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.
15. The method of claim 3 , wherein the database is an in-memory database.
16. The method of claim 3 , wherein the database is managed by a column-oriented database management system.