Table Abbreviation Description Module Activity code
GACCENTRYD DAE Accounting entry lines Financials  

Key Description Duplicates Activity code
DAE0 TYP+NUM+LIN+LEDTYP No  
DAE1 CPY+FCYLIN+LEDTYP+ACC+BPR+ACCDAT+ACCNUM No  
DAE2 ACCNUM No  
DAE3 LEDTYP+ACC+BPR+CPY+ACCDAT+ACCNUM No  
DAE4 LEDTYP+BPR+CPY+ACCDAT+ACCNUM No  
DAE5 CPY+FCYLIN+LEDTYP+BPR+ACCDAT+ACCNUM No  
DAE6 LEDTYP+ACC+BPR+MTC+TYP+NUM+LIN+ACCNUM No  
DAE7 TYP+NUM+IDTLIN+LEDTYP+LIN No  
DAE8 PJTLIN Yes PJM

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 Unique number   UNQ          
ACCNUMDOE Counterpart number   C 4       KRU
ACCNUMORI Source number   UNQ          
AMTCUR Entry amount   MD1          
AMTFLG Forced amount   M 4 1      
AMTLED Ledger amount   MD1          
AMTLED1 Forced amount   MD1          
AMTVAT Declared amount   MD1          
AUUID Single identifier   AUUID          
BPR BP   BPR     [BPR]BPR0=[DAE]BPR Block  
BSITRS Bank statement   A 30       BSI
CAPFLOTYP Capital flow   ADI     [ADI]CODE=389;CAPFLOTYP Block KPO
CHK Reconciliation   A 5        
CHKDAT Reconciliation date   D          
CHRNUM Chronological number   VCR          
COA Chart code   COA     [COA]COA0=[DAE]COA Block  
CPY Company   CPY     [CPY]CPY0=[DAE]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[DAE]CREUSR Other  
CSLBPR Partner   BPR     [BPR]BPR0=[DAE]CSLBPR Block PRCSL
CSLCOD Partner   A 10       CSL
CSLFLO Flow   ADI     [ADI]CODE=324;CSLFLO Block CSL1
CUR Entry currency   CUR     [TCU]TCU0=[DAE]CUR Block  
CURLED Ledger currency   CUR     [TCU]TCU0=[DAE]CURLED Block  
DES Description   DES          
DSP Distribution   DSP     [DSP]DSP0=DSP;1 Block  
EXPNUM Export number   L 8        
FCYLIN Site   FCY     [FCY]FCY0=[DAE]FCYLIN Block  
FIY Fiscal year   C 2        
FLGMTC Flag   M 4 1      
FREREF Free reference   REF          
IDTLIN Identifier   A 5        
INDEDVAT Non-deductible tax   MD1         KIT
LED Ledger   LED     [LED]LED0=[DAE]LED Block  
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        
PCCCOD Cost type   PJCC     [PJCC]PCC0=[DAE]PCCCOD Block PJM
PER Period   C 2        
PJTLIN Project   PJT     [PIM]PIM0=[DAE]PJTLIN Block 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  
TAX3 Tax 3   VAT     [TVT]TVT0=TAX3;[V]GSUPCLE Block  
TYP Entry type   GTE     [GTE]GTE0=TYP;[V]GSUPCLE Block  
UOM Nonfinancial unit   UOM     [TUN]TUN0=[DAE]UOM Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[DAE]UPDUSR Other  
VATDEDRAT Deductib pro rata   DCB 3.6        
VATRAT Applied VAT rate   DCB 3.6