Table Abbreviation Description Module Activity code
SPLIBREG SPLREG Bookkeeping Financials KSP

Key Description Duplicates Activity code
SPLREG0 CPY+RECTYP+REGTYP+INVNUM+VAT No  
SPLREG1 CPY+RECTYP+REGTYP+FIY+PER Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACTIAE IAE activity   A 6        
ACTSUBTYP Activity subtype   A 2        
ACTTYP Activity type   A 1        
AMTTAX Tax amount   DCB 12.2        
AMTTOT Invoice total   DCB 12.2        
AUUID Single identifier   AUUID          
BPNAME BP name   A 40        
BUILOC Location   A 1        
CDRREF Cadastre   A 20        
CPY Company   CPY     [CPY]CPY0=[SPLREG]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[SPLREG]CREUSR Other  
CRN BP identification   CRN          
CRY Country   CRY     [TCY]TCY0=[SPLREG]CRY Block  
CSHAMT Cash VAT amount   DCB 12.2        
CSHMET Cash VAT method   A 2        
CSHMETID Cash VAT method ID   A 32        
CSHVATDAT Cash VAT date   D          
DEDAMT Deductible amount   MD1          
DEDFIY Deduction fiscal year   C 4        
DEDLATPER Deductible in later period   A 1        
DEDPER Deduction period   A 2        
DEDRAT Deductible %   DCB 3.6        
DOCTYP Document type   M 15 2004      
EECNUM EU identification   EEC          
ENDDAT End date   D          
EXTREF External reference   A 40        
FCY Site   FCY     [FCY]FCY0=[SPLREG]FCY Delete  
FIY Fiscal year   C 2        
INIDAT Start date   D          
INVGOOD Investment goods   A 1        
INVNUM Invoice number   VCR          
INVNUMEND Final invoice number   A 20        
INVTYP Invoice type   M 4 645      
INVTYPSPA Invoice type   A 2        
MACTSUBTYP Main activity subtype   A 2        
MAINACTIAE Main activity   A 6        
MAINACTTYP Main activity type   A 1        
MAINREGAGR Main billing agreement   A 14        
NATTYP Operation nature   A 2        
OPEAMT Amount   DCB 12.2        
OPECONCEPT Operation subject   A 3        
OPEDAT Operation date   D          
OPEEXE Exempted operation   A 2        
OPEKEY Operation key   A 2        
PER Period   C 2        
PTHDAT Receipt date   D          
PTHNUM Receipt number   VCR          
PTHNUMEND Final receipt number   VCR          
RECTYP Record type   A 1        
REGAGR Registration agreement   A 15        
REGTYP Tax rule type   C 2        
REVCHG Reverse charge   A 1        
SDHDAT Issue date   D          
SERIE Series   A 20        
STA Status   M 4 1      
SUBTAX Subject to tax   DCB 12.2        
SURRAT Surcharge type   DCB 4.2        
SURTAXAMT Equivalence surcharge tax   DCB 12.2        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[SPLREG]UPDUSR Other  
VAT Tax   VAT     [TVT]TVT0=[SPLREG]VAT BSRA  
VATRAT Rate   DCB 3.2        
VCRLIN Entry line no.   L 8        
WTHAMT Withholding amount 10 DCB 12.2        
WTHRAT Withholding type 10 DCB 4.2