Table Abbreviation Description Module Activity code
SPAMOD123 SPM123 Spanish form 123 Financials KSP

Key Description Duplicates Activity code
SPM123 CPY+FIY+PER+NUMDECL No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ADEDUCIR To deduct   DCB 11.2        
AUUID Single identifier   AUUID          
CNOMBRE First name start   A 4        
CODADM Agency   L 5        
CODELECT Digital code   A 16        
CODPOS Postal code   A 5        
COMPJUST Previous supporting document   A 13        
CONTACTO Person to contact   A 100        
CPY Company   CPY     [CPY]CPY0=[SPM123]CPY Delete  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[SPM123]CREUSR Other  
CUENING Bank account   A 10        
DIA Day   A 2        
DIGCOING Check digit   A 2        
ENTING Entity   A 4        
ESCALERA Staircase   A 2        
FIY Fiscal year   A 4        
FORMPAG Payment method   M 15 2111      
IBAN IBAN pref   A 4        
IMP11 Number of recipients   L 6        
IMP12 Amount   DCB 11.2        
IMP21 Retained amount   DCB 11.2        
IMP31 Previous FY amount   DCB 11.2        
IMP32 Adjustment   DCB 11.2        
LOCALIDA Locality   A 20        
MES Month   A 10        
MODELO Form   A 3        
NIF Company tax ID no.   A 9        
NOMBRE Name   A 15        
NOMBVIA Street   A 17        
NUMCASA Street number   L 2        
NUMDECL Declaration number   C 4        
OBSERVA Notes   A 250        
OBSERVA1 Notes 1   A 100        
PAGCOMP Add. declaration page indicator   M 4 1      
PAGINA Page   A 2        
PER Period   A 2        
PISO Floor   A 2        
PROVIN Province   A 15        
PUERTA Door   A 2        
RAZSOC Company name   A 30        
RESUL Result   DCB 11.2        
RESULDEC Amount to be deposited   DCB 11.2        
SUCURING Branch   A 4        
TELEFONO Telephone   A 9        
TIPDEC Declaration type   ADI     [ADI]CODE=1214;TYPDEC Block  
TIPOVIA Type   A 2        
TOTAL1 Total withholdings   DCB 11.2        
TYPDEC Complementary declaration   M 4 1      
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[SPM123]UPDUSR Other  
YEARDEC Declaration year   A 4