Querying Accounting Data
Overview
In order to analyze accounting data, one must be able to filter and aggregate the data. The structure of accounting
data is usually fairly simple. It is generally organized as a table.
In Javascript, a table is econded as an
array
of
objects.
(see
Javasript Tutorial)
Information on querying and transforming data can be found at :
Querying and Transforming Data
Most accounting systems will maintain a chart of accounts. Such a chart is usually structured as a tree.
When analyzing accounting data, it is often required to group accounts or transactions using the chart of accounts.
This requires being able to use and query a tree structure.
(see
tree map library
for information on the tree-mpa api)
Examples