Table Abbreviation Description Module Activity code
VATHIS VAT Tax - history Fixed Assets  

Key Description Duplicates Activity code
VAT0 AASREF+DPRPLN+DATVATREG+TIMSTP No  
VAT1 AASREF+DPRPLN+VATREGTYP+DATVATREG+TIMSTP No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AASBUS Activity   VC9          
AASBUSO Activity   VC9          
AASREF Asset   VC9          
ACGETRNOT Receipt value ex-tax   MD1          
ADMCOE Admission coef.   RAT          
ADMCOEF Admission coef.   RAT          
ADMCOEFO Admission coef.   RAT          
ADMCOEO Admission coef.   RAT          
ADMCOER Admission coef.   RAT          
ADMCOERO Admission coef.   RAT          
ASJCOE Liability coef.   RAT          
ASJCOEF Liability coef.   RAT          
ASJCOEFO Liability coef.   RAT          
ASJCOEO Liability coef.   RAT          
ASJCOER Liability coef.   RAT          
ASJCOERO Liability coef.   RAT          
AUUID Single identifier   AUUID          
BASDEV Bal sheet val vari   MD1          
CPY Company   CPY     [CPY]CPY0=[VAT]CPY Delete  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[VAT]CREUSR Other  
DATVATREG Date   D4          
DEDCOE Deduction coef   RAT          
DEDCOEF Deduction coef   RAT          
DEDCOEFO Deduction coef   RAT          
DEDCOEO Deduction coef   RAT          
DEDCOER Deduction coef   RAT          
DEDCOERO Deduction coef   RAT          
DEDVATAMT VAT recovered   MD1          
DEDVATAMTO VAT recovered   MD1          
DEDVATFLG Forced rec VAT   M 4 1      
DPRBAS Basis after update   MD1          
DPRBASO Basis before adj.   MD1          
DPRPLN Depreciation plan   M 25 3101      
FCY Financial site   FCY     [FCY]FCY0=[VAT]FCY Block  
FORMULE Formula   A 50        
ISSVATAMT VAT due on disposal   MD1          
ISSVATFLG Forced disposal VAT   MZS 4        
IVCVATAMT VAT invoiced   MD1          
IVCVATAMTO VAT invoiced   MD1          
IVCVATFLG Invoiced VAT forced   MZS 4        
IVCVATRAT Invd VAT rate   RAT          
PYBVATTYP VAT repayment   M 15 3160      
TAXCOE Taxation coeff   RAT          
TAXCOEF Taxation coeff   RAT          
TAXCOEFLG Forced taxation coef   M 4 1      
TAXCOEFLGO Forced taxation coef   M 4 1      
TAXCOEFO Taxation coeff   RAT          
TAXCOEO Taxation coeff   RAT          
TAXCOER Taxation coeff   RAT          
TAXCOERO Taxation coeff   RAT          
THESLI Adujst period   DUR          
TIMSTP Time stamp   A 20        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[VAT]UPDUSR Other  
VATREGAMT VAT repay adj.   MD1          
VATREGCUM VAT adj total   MD1          
VATREGDATO Reference date   D4          
VATREGDED VAT ded adj.   MD1          
VATREGTYP Tax adjust type   M 25 3269      
VATRSD Residual duration   DUR          
VATYEAFLG Yearly adjust. index   M 4 1