Table ABITABAGG @ L.V. Expertise X3

Dictionary > Module Supervisor > Table Fact table (aggregates)

Table	Abbreviation	Title	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
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