Table Abbreviation Description Module Activity code
DCLVATSPA DVS Tax working table (SPA) Financials KSP

Key Description Duplicates Activity code
DVS0 TAXTYP+TYP+NUM+VAT+REGTYP No  
DVS1 CRN Yes  
DVS2 EECNUM Yes  
DVS3 TAXTYP+DCLDAT Yes  
DVS4 INDLNK Yes  
DVS5 TAXTYP+CRN+TYP+NUM Yes  
DVS6 COD347+CRN Yes  
DVS7 ACCNUM Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCDAT Accounting date   D          
ACCNUM Internal number   L 8        
AMTATI Amount + tax   MD1          
AMTATIL Invoice amt. + tax (co)   MD1          
AMTNOT Amount - tax   MD1          
AMTNOTL Amount - tax (co)   MD1          
AMTTAX Tax amount   MD1          
AMTTAXL Tax amount (company)   MD1          
AUUID Single identifier   AUUID          
BIDNUM Bank account number   A 32        
BOOKFLG Include in book   M 4 1      
BPRDAT Source date   D          
BPRNAM Company name 2 NAM          
BPRNUM BP code   BPR     [BPR]BPR0=BPRNUM Block  
BPRVCR Source document   A 20        
BUILOC Location   M 12 3611      
CDRREF Cadastre   A 25        
CEEFLG EU invoice   M 4 1      
COD347 Code 347   A 3        
CODOPE Operation code   ADI     [ADI]CODE=393;CODOPE Block  
CPY Company   CPY     [CPY]CPY0=[DVS]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[DVS]CREUSR Other  
CRN Site tax ID no.   CRN          
CRY Country   CRY     [TCY]TCY0=[DVS]CRY Block  
CSHVAT Cash VAT tax rule   M 4 1      
CUR Currency   CUR     [TCU]TCU0=[DVS]CUR Block  
D347FLG Declaration 347   M 4 1      
D349FLG Declaration 349   M 4 1      
DCLDAT Declaration date   D          
DECCUR Declared tax   DCB 9.2        
DEDAMT Deductible amount   MD1          
DEDAMTL Deductible amt local   MD1          
DEDRAT Deductible %   DCB 3.6        
DOCTYP Document type   M 4 2004      
EECNUM EU identification   EEC          
ENFDAT Enforceability date   D          
EURSRV Services   M 4 1      
FCY Site   FCY     [FCY]FCY0=[DVS]FCY Block  
FIY Fiscal year   C 2        
IGICFLG IGIC   M 4 1      
IMPORT Import   M 4 1      
INDLNK Index link   A 50        
INR Interest   M 4 1      
INVFLG Invoice   M 4 1      
INVNUM Invoice number   VCR          
INVNUMDAT Source date   D          
INVTYP Invoice category   M 4 645      
INVUPDFLG Modif flag   M 4 1      
MOD347 Spanish form 347   A 13        
MOD349 349 form   A 13        
NRS Nonresident   M 4 1      
NUM Document no.   VCR          
ORIMOD Source module   M 4 14      
PAM Tax rule type   ADI     [ADI]CODE=990;PAM Block  
PAYCUR Paid amount   DCB 9.2        
PER Period   C 2        
POSCOD Postal code   POS          
PROFLG Processing flag   M 4 1      
QUARTER Quarter   C 2        
REGTYP Tax rule type   C 2        
REVSAL Sales reverse charge   M 4 1      
RNT Rental   M 4 1      
SCDREF SCD reference   A 40        
SNS Sign   C 2        
SPADERNUM DER code   A 60        
SPAMOSS MOSS operation   M 4 1      
TAG Purchase travel agency   M 4 1      
TAXTYP Tax type   A 4        
TCKEND End ticket   A 15        
TCKINI Initial ticket   A 15        
TCKNUM Number of tickets   L 8        
TOTALPAY Paid   M 4 1      
TYP Entry type   GTE     [GTE]GTE0=TYP;[V]GCURLEG Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[DVS]UPDUSR Other  
VAC Tax rule   TVB     [TVB]TVB0=VAC;[V]GSUPCLE Block  
VACAGR Agrarian tax rule   M 4 1      
VAT Tax   VAT     [TVT]TVT0=VAT;[V]GCURLEG Block  
VATRAT Rate   DCB 3.2        
VATTYP VAT type   M 4 232