Table SPAMOD123 @ L.V. Expertise X3

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	Type	Length	Menu	Link expression	Cancellation
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