Dictionary >  Module Supervisor >  Table Fact table (aggregates)  

Display all Hide all

Table Abbreviation Description Module Activity code
ABITABAGG ABE Fact table (aggregates) Supervisor ABI

Key Description Duplicates Activity code
ABE0 CODABF+NUMAGG+CODAGG No  
ABE1 CODABF+CODAGG No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACTAGG Activity code   ACV     [ACV]CODACT=[ABE]ACTAGG Block  
AUUID Single identifier   AUUID          
CODABF Fact tables   ABF     [ABF]ABF0=[ABE]CODABF Delete  
CODAGG Name   A 7        
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[ABE]CREUSR Other  
DIMAGG Dimension 16 ABI     [ABI]ABI0=[ABE]DIMAGG Block  
FLDAGG Name of field 16 AVA          
INDAGG Index 8 A 80        
LNKAGG Fields 16 A 80        
NBRAGD No. dimensions   C 2        
NBRAGI Index number   C 2        
NIVAGG Aggregation level 16 M 15 7825      
NUMAGG Aggregate   C 4        
TYPAGG Dim view type 16 M 15 7826      
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[ABE]UPDUSR Other