Table Abbreviation Description Module Activity code
SPAMOD347D SPM347D Spanish form 347 Financials KSP

Key Description Duplicates Activity code
SPM347D CPY+FIY+NUMDECL+CONTADOR No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ARRENLOCAL Rental   M 4 1      
AUUID Single identifier   AUUID          
BLOQUE Block   A 3        
CALIFNUM Qualification code   A 3        
CLAOPE Operation key   ADI     [ADI]CODE=329;CLAOPE Block  
CODMUNIC Municipality code   A 4        
CODPOSTAL Postal code   A 5        
CODPROV Province code   A 2        
COMPLEMENTO Complementary field   A 40        
CONTADOR Sequence number   L 8        
CPY Company   CPY     [CPY]CPY0=[SPM347D]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[SPM347D]CREUSR Other  
CRNDECL Taxpayer TIN   CRN          
CRNDECL1 Taxpayer TIN   CRN          
CRNEUOPE EU VAT no.   A 17        
CRNREP Representative TIN   CRN          
CSHVAT Cash VAT   M 4 1      
EJERCPCONT Fiscal year cash payment   C 4        
ESCALERA Staircase   A 3        
FIY Fiscal year   A 4        
IMPOPERAC Annual total   DCB 12.2        
IMPORMETAL Cash amount   DCB 12.2        
IMPORT1 Q1 amount   DCB 12.2        
IMPORT2 Q2 amount   DCB 12.2        
IMPORT3 Q3 amount   DCB 12.2        
IMPORT4 Q4 amount   DCB 12.2        
IMPORTETRA Annual building transfer amount   DCB 12.2        
IMPTRAT1 Q1 transfer amount   DCB 12.2        
IMPTRAT2 Q2 transfer amount   DCB 12.2        
IMPTRAT3 Q3 transfer amount   DCB 12.2        
IMPTRAT4 Q4 transfer amount   DCB 12.2        
ISP ISP reverse charge   M 4 1      
LOCALIDAD Locality   A 30        
MUNICIPIO Municipality   A 30        
NOMBREVIA Street   A 50        
NUMCASA Street number   L 5        
NUMDECL Declaration number   C 4        
OPADUANAS Customs information   M 4 1      
OPESEGURO Insurance   M 4 1      
PAIS Country   A 2        
PISO Floor   A 3        
PORTAL Portal   A 3        
PROVINCIA Province   A 2        
PUERTA Door   A 3        
RAZSOCDEC BP name   A 40        
RAZSOCDEC1 BP name   A 40        
REFERENCIA Cadastre   A 25        
SITINMUEBL Location   M 12 3611      
TIPOHOJA Sheet   A 1        
TIPONUM Type of location   A 3        
TIPOVIA Type   A 5        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[SPM347D]UPDUSR Other