Table Abbreviation Description Module Activity code
TXSM TXM Amounts Financials TDB

Key Description Duplicates Activity code
TXM0 TXSNAM+VERSION+LIG+COL+IND No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC Account/nature   GAC     [GAC]GAC0=COA;ACC Block  
ACCINF Information   A 30        
AMTCDT Credit   A 25        
AMTDEB Debit   A 25        
AMTVAL Value   A 50        
AUUID Single identifier   AUUID          
BPR BP   BPR     [BPR]BPR0=[TXM]BPR Delete  
BPRINF Information   A 30        
CCE1 Analytical dimension 1   CCE     [CCE]CCE0=DIE1;CCE1 Delete  
CCE2 Analytical dimension 2   CCE     [CCE]CCE0=DIE2;CCE2 Delete  
CCE3 Analytical dimension 3   CCE     [CCE]CCE0=DIE3;CCE3 Delete  
CCE4 Analytical dimension 4   CCE     [CCE]CCE0=DIE4;CCE4 Delete  
CCE5 Analytical dimension 5   CCE     [CCE]CCE0=DIE5;CCE5 Delete  
CCE6 Analytical dimension 6   CCE     [CCE]CCE0=DIE6;CCE6 Delete  
CCE7 Analytical dimension 7   CCE     [CCE]CCE0=DIE7;CCE7 Delete  
CCE8 Analytical dimension 8   CCE     [CCE]CCE0=DIE8;CCE8 Delete  
CCE9 Analytical dimension 9   CCE     [CCE]CCE0=DIE9;CCE9 Delete  
CCEINF Information   A 30        
COA Chart code   COA     [COA]COA0=[TXM]COA Block  
COL Column   C 2        
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[TXM]CREUSR Other  
DIE1 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE1 Block  
DIE2 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE2 Block  
DIE3 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE3 Block  
DIE4 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE4 Block  
DIE5 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE5 Block  
DIE6 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE6 Block  
DIE7 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE7 Block  
DIE8 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE8 Block  
DIE9 Dimension type code   DIE     [DIE]DIE0=[TXM]DIE9 Block  
FCY Site   FCY     [FCY]FCY0=[TXM]FCY Delete  
FCYINF Information   A 30        
IND Index   L 8        
LIG Line number   C 3        
TXSNAM Extraction code name   TXS     [TXS]TXS1=[TXM]TXSNAM Delete  
TYPAMT Amount type   C 4        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[TXM]UPDUSR Other  
UPDVAL User value   A 30        
VERSION Version   A 15