Table Abbreviation Description Module Activity code
DCLVATITA DVI Italian VAT detail declaration Financials KIT

Key Description Duplicates Activity code
DVI0 CPY+FCY+VATTYP+ACCDAT+NUM+VATRAT+VAT+DEDRAT No  
DVI1 FIY+PER+VAT+VATRAT+DEDRAT Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC General accounts   GAC     [GAC]GAC0="";ACC Other  
ACCDAT Accounting date   D          
AMTCUR Amount in currency   MD1          
AMTDUT Postable amount   MD1          
AMTDUTCUR Postable currency amt   MD1          
AMTDUTEUR Postable euro amount   MD1          
AMTEUR EURO VAT amount   MD1          
AMTVAT Tax amount   MD1          
AUUID Single identifier   AUUID          
BPRNAM Company name 2 NAM          
BPRNUM BP   BPR     [BPR]BPR0=[DVI]BPRNUM Block  
BPRTYP BP type   M 15 644      
CALMONTH Calendar month   C 2        
CALYEAR Civil year   C 4        
CPY Company   CPY     [CPY]CPY0=[DVI]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[DVI]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[DVI]CUR Block  
DEDDUT Deductible base   MD1          
DEDRAT Deductible %   DCB 3.6        
DEDVAT Input VAT   MD1          
DESVCR Description   DES          
EECNUM EU identification   A 20        
EURCUR EURO currency code   CUR     [TCU]TCU0=[DVI]EURCUR Block  
FCY Site   FCY     [FCY]FCY0=[DVI]FCY Block  
FCYNUM Site document code   FCY     [FCY]FCY0=[DVI]FCYNUM Block  
FIY Fiscal year   C 2        
INVDAT Invoice date   D          
INVNUM Invoice number   VCR          
JOU Journal   JOU     [JOU]JOU0=JOU;[V]GSUPCLE Block  
NUM Document no.   VCR          
PER Period   C 2        
REGTYP Registry type   A 1        
SIM Simulation   M 4 1      
SNS Sign   C 2        
TYP Entry type   GTE     [GTE]GTE0=TYP;[V]GSUPCLE Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[DVI]UPDUSR Other  
VAT Tax   VAT     [TVT]TVT0=VAT;[V]GSUPCLE Block  
VATNUM IVA partita   A 15        
VATPAY Tax/collection flag   M 15 204      
VATRAT Rate   DCB 3.6        
VATREG VAT registry   ANM     [ANM]ANM0=[DVI]VATREG Block  
VATTYP VAT type   A 4