Table SPAMOD3691 @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
SPAMOD3691	SPM3691	Spanish form 369	Financials	KSP

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

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation
ADEVOLIMPRES	To return	12	DCB	15.2
AINGSPAIMRES	Deposit in Spain	12	DCB	15.2
AUUID	Single identifier		AUUID
BASEIMP	Amount	28	DCB	15.2
BASEOTHER	Amount	28	DCB	15.2
BASESER	Amount	28	DCB	15.2
BIEIMPRES	Imports	12	DCB	15.2
CORIMPRES	Result	12	DCB	15.2
CORNEGIMPRES	Negative variances	12	DCB	15.2
CORPOSIMPRES	Positive variances	12	DCB	15.2
COUTAOTCOR	Corrected VAT	28	DCB	15.2
CPY	Company		CPY			[CPY]CPY0=[SPM3691]CPY	Block
CPYNAMIMP	Company name		A	125
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[SPM3691]CREUSR	Other
CRYEP	Country code	28	A	2
CRYIM	Country		A	2
CRYIMP	Country code/MS of consumption	28	A	2
CRYIMPCOR	Country code/MS of consumption	28	A	2
CRYIMPRES	Country	12	A	2
CRYOT	Country code	28	A	2
CRYOTHER	Country code/MS of consumption	28	A	2
CRYOTHERCOR	Country code/MS of consumption	28	A	2
CRYSER	Country code/MS of consumption	28	A	2
CUOTAIMP	Tax amount	28	DCB	15.2
CUOTAOTHER	Tax amount	28	DCB	15.2
CUOTASER	Tax amount	28	DCB	15.2
FIY	Fiscal year		A	4
FIYIMP	Fiscal year		A	4
FIYIMPCOR	Fiscal year	28	A	4
FIYOTHERCOR	Correction fiscal year	28	A	4
IMPENDDAT	End date		D
IMPINIDAT	Start date		D
MODEL	Form		A	3
NIOSSIMP	VAT number		A	15
NIOSSINT	Representative TIN		A	15
NIVAOTHER	VAT number	28	A	15
NIVASER	VAT number	28	A	15
NUMDECL	Declaration number		C	4
PER	Period		A	2
PERIMP	Period		A	2
PERIMPCOR	Period	28	A	2
PEROTHERCOR	Correction period	28	A	2
PERTYPIMP	Period type		A	1
PERTYPIMPCOR	Period type	28	A	1
TOTIMPRES	Total		DCB	15.2
TYPPEROTHCOR	Period type	28	A	1
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[SPM3691]UPDUSR	Other
USEINTERM	Representative		M	4	1
VATRATIMP	Rate	28	DCB	3.2
VATRATOTHER	Rate	28	DCB	3.2
VATRATSER	Rate	28	DCB	3.2
VATTTYSER	VAT type	28	A	1
VATTYPIMP	VAT type	28	A	1
VATTYPOTHER	VAT type	28	A	1