Differences

This shows you the differences between two versions of the page.

--- tables_fields:main_tables:aggregator [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:aggregator to tables_fields:main_tables:aggregator lou
+++ tables_fields:main_tables:aggregator [2025/12/17 02:19] (current) – Added columns in the table [Available dataElement values] Mai Inamoto
@@ Line 14: / Line 14: @@
 ====Available dataElement values====
-^ Value ^ Comment ^
+This table holds aggregated values with different dimensions. For example, some values are aggregated per store, others per store and item, and others per store, item, and yearmonth.
-^ monthlyConsumption |Sums consumption for each month there is consumption    Consumption in this case = (transaction.type = 'ci' and transaction.status in ('cn', 'fn')) |
-^AMC | Sums all consumption (using dataElement = 'monthlyConsumption') and divides by number of months with consumption |
+^ Value ^ StoreID ^ ItemID ^ datetime ^ Comment ^
-^ stockConsumption | For every day there is a customer invoice, aggregate consumption|
+^ monthlyConsumption | ✓ | ✓ | yearmonth | Sums consumption for each month there is consumption    Consumption in this case = (transaction.type = 'ci' and transaction.status in ('cn', 'fn')) |
-^ stockMovement | For every day there is stock movement, sums up supply and subtracts sum of consumption |
+^AMC | ✓ | ✓ | - | Sums all consumption (using dataElement = 'monthlyConsumption') and divides by number of months with consumption |
-^ stockHistory | Reverse ledger (using dataElement = 'stockMovement'), records stock level at the end of each day where stock movement existed |
+^ stockConsumption | ✓ | ✓ | fulldate |For every day there is a customer invoice, aggregate consumption|
-^ monthlyDOS| Calculate number of day per month where stock was 0 |
+^ stockMovement | ✓ | ✓ | fulldate |For every day there is stock movement, sums up supply and subtracts sum of consumption |
-^ realAMC | Formula for realAMC = Consumption Sum / (Number of Months With Consumption - (totalDOS/30.5)) |
+^ stockHistory | ✓ | ✓ | fulldate | Reverse ledger (using dataElement = 'stockMovement'), records stock level at the end of each day where stock movement existed |
+^ monthlyDOS| ✓ | ✓ | yearmonth | Calculate number of day per month where stock was 0 |
+^ <del>realAMC</del> | | | |<del>Formula for realAMC = Consumption Sum / (Number of Months With Consumption - (totalDOS/30.5))</del> |
 ---- struct data ----
+pagestatus.status    :
 ----