Table Abbreviation Description Module Activity code
GACCTMPD DAT Accounting entry lines Common Data  

Key Description Duplicates Activity code
DAT0 TYP+NUM+LIN+LEDTYP No  
DAT1 ACCNUM No  
DAT2 CODAUTACE+LEDTYP+CRIMTC+ACCNUM No  
DAT3 TYP+NUM+IDTLIN+LEDTYP+LIN No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC General accounts   GAC     [GAC]GAC0=COA;ACC Block  
ACCDAT Accounting date   D          
ACCNUM Internal number   L 8        
ACCNUMDOE Counterpart number   C 4       KRU
ACCNUMORI Source number   L 8        
AMTCUR Entry amount   MD1          
AMTFLG Forced amount   M 4 1      
AMTLED Ledger amount   MD1          
AMTLED1 Forced amount   MD1          
AMTVAT Declared tax   MD1          
AUUID Single identifier   AUUID          
BPR BP   BPR     [BPR]BPR0=[DAT]BPR Block  
BSITRS Bank statement   A 30       BSI
CHK Reconciliation   A 5        
CHKDAT Reconciliation date   D          
CHRNUM Chronological number   VCR          
COA Chart code   COA     [COA]COA0=[DAT]COA Delete  
CODAUTACE Auto journal code   A 10        
CPY Company   CPY     [CPY]CPY0=[DAT]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[DAT]CREUSR Other  
CRIMTC Matching criteria   A 80        
CSLBPR Partner   BPR     [BPR]BPR0=[DAT]CSLBPR Block PRCSL
CSLCOD Partner   A 10       CSL
CSLFLO Flow   ADI     [ADI]CODE=324;CSLFLO Block CSL1
CUR Currency   CUR     [TCU]TCU0=[DAT]CUR Block  
CURLED Ledger currency   CUR     [TCU]TCU0=[DAT]CURLED Block  
DES Description   DES          
DSP Distribution   DSP     [DSP]DSP0=DSP;1 Block  
FCYLIN Site   FCY     [FCY]FCY0=[DAT]FCYLIN Block  
FIY Fiscal year   C 2        
FLGMTC Flag   C 1        
FREREF Free reference   REF          
IDTLIN Identifier   A 5        
INDEDVAT Non-deductible tax   MD1         KIT
LED Ledger   LED     [LED]LED0=[DAT]LED Delete  
LEDTYP Ledger type   M   2644      
LIN Line number   C 3        
MRK Marking   A 20        
MTC Matching   A 5        
MTCDAT Matching date   D          
MTCDATMAX Maximum group date   D          
MTCDATMIN Minimum group date   D          
NUM Document no.   VCR          
OFFACC Offset   A 15        
OLDLIG Line number   C 3        
PCCCOD Cost type   PJCC     [PJCC]PCC0=[DAT]PCCCOD Block PJM
PER Period   C 2        
PJTLIN Project   PJT     [PIM]PIM0=[DAT]PJTLIN BSRA PJM
QTY Quantity   QTY          
REFINTLIN Internal reference   A 25        
SAC Control   SAC          
SNS Sign   C 2        
STT1 Statistics   ADI     [ADI]CODE=351;STT1 Block  
STT2 Statistics   ADI     [ADI]CODE=352;STT2 Block  
STT3 Statistics   ADI     [ADI]CODE=353;STT3 Block  
TAX Tax   VAT     [TVT]TVT0=TAX;[V]GSUPCLE Block  
TAX2 Tax 2   VAT     [TVT]TVT0=TAX2;[V]GSUPCLE Block KDE
TAX3 Tax 3   VAT     [TVT]TVT0=TAX3;[V]GSUPCLE Block KDE
TRCLIG Line number   C 4        
TYP Entry type   GTE     [GTE]GTE0=TYP;[V]GSUPCLE Block  
UOM Nonfinancial unit   UOM     [TUN]TUN0=[DAT]UOM Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[DAT]UPDUSR Other  
VATDEDRAT Deductib pro rata   DCB 3.6        
VATRAT Applied VAT rate   DCB 3.6