Table SPAMOD369 @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
SPAMOD369	SPM369	Spanish form 369	Financials	KSP

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

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation
ACTIVITYEXT	No activity		M	1	1
ACTIVITYIMP	No activity		M	1	1
ACTIVITYUN	No activity		M	1	1
ADEVOLVERES	To return	12	DCB	15.2
AINGSPARES	Deposit in Spain	12	DCB	15.2
AUUID	Single identifier		AUUID
BASEEXT	Amount	28	DCB	15.2
BASESDH	Amount	28	DCB	15.2
BASEUN	Amount	28	DCB	15.2
BASEXTCOR	Corrected amount	28	DCB	15.2
CATEXT	Category		A	1
CATIMP	Category		A	1
CATUN	Category		A	1
COREXTRES	Result	12	DCB	15.2
CORNEGEXTRES	Negative variances	12	DCB	15.2
CORPOSEXTRES	Positive variances	12	DCB	15.2
COUTAEXTCOR	Corrected VAT	28	DCB	15.2
CPY	Company		CPY			[CPY]CPY0=[SPM369]CPY	Block
CPYNAMEXT	Company name		A	125
CPYNAMIMP	Company name		A	125
CPYNAMUN	Company name		A	125
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[SPM369]CREUSR	Other
CRNDECEXT	Company tax ID no.		A	15
CRNDECIMP	Company tax ID no.		A	15
CRNDECUN	Company tax ID no.		A	15
CRYDECEXT	Country of origin		A	2
CRYDECIMP	Country of origin		A	2
CRYDECUN	Country of origin		A	2
CRYEMEXT	Country code/MS of consumption	28	A	2
CRYEXT	Country		CRY			[TCY]TCY0=[SPM369]CRYEXT	Block
CRYEXTCOR	Country code/MS of consumption	28	A	2
CRYEXTRES	Country	12	A	2
CRYSDH	Country code/MS of consumption	28	A	2
CRYUN	Country code/MS of consumption	28	A	2
CUOTAEXT	Tax amount	28	DCB	15.2
CUOTASDH	Tax amount	28	DCB	15.2
CUOTAUN	Tax amount	28	DCB	15.2
FIY	Fiscal year		A	4
FIYEXTCOR	Correction fiscal year	28	A	4
INDPAG	Complementary page		A	1
MODEL	Form		A	3
NEUOSS	ID number		A	15
NRCEXT	NRC code		A	50
NRCIMP	NRC code		A	50
NRCUN	NRC code		A	50
NUMDECL	Declaration number		C	4
PAGAMTEXT	Payment amount		DCB	15.2
PAGAMTIMP	Payment amount		DCB	15.2
PAGAMTUN	Payment amount		DCB	15.2
PAGINA	Page		A	2
PAGTYPEXT	Payment type		ADI			[ADI]CODE=331;PAGTYPEXT	Block
PAGTYPIMP	Payment type		ADI			[ADI]CODE=331;PAGTYPIMP	Block
PAGTYPUN	Payment type		ADI			[ADI]CODE=331;PAGTYPUN	Block
PER	Period		A	2
PEREXTCOR	Correction period	28	A	2
REGEXT	Rule type		A	5
REGIMP	Rule type		A	5
REGUN	Rule type		A	5
SEREXTRES	Services	12	DCB	15.2
TOTEXTRES	Total		DCB	15.2
TYPPEREXT	Period type		A	1
TYPPEREXTCOR	Period type	28	A	1
TYPPERIMP	Period type		A	1
TYPPERUN	Period type		A	1
UNIENDDAT	End date		D
UNIINIDAT	Start date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[SPM369]UPDUSR	Other
VATRATEXT	Rate	28	DCB	3.2
VATRATSDH	Rate	28	DCB	3.2
VATRATUN	Rate	28	DCB	3.2
VATTYPEXT	VAT type	28	A	1
VATTYPSDH	VAT type	28	A	1
VATTYPUN	VAT type	28	A	1