To help with queries and quick data retrieval, alpha360 supports the use of SUM tables.

These tables are updated as soon as Inventory or Account transactions are added or deleted.


Here is a list of the SUM tables:

  1. tInventoryF_sum has information for each Product per Fiscal Year - updated when an Inventory transaction is added or deleted.
  2. tInventoryFW_sum has information for each Product per Fiscal Year per Warehouse - updated when an Inventory transaction is added or deleted.
  3. aAccountingFW_sum has information for each Account per Fiscal Year - updated when an Account transaction is added or deleted.
  4. aAccountingRP_sum has information for each Account per Reporting Period - updated when an Account transaction is added or deleted.