Table > Module Financials > Table Italian VAT detail declaration

Table DCLVATITA

Table	Abbreviation	Description	Module	Activity code
DCLVATITA	DVI	Italian VAT detail declaration	Financials	KIT

Key	Description	Duplicates	Activity code
DVI0	CPY+FCY+VATTYP+ACCDAT+NUM+VATRAT+VAT+DEDRAT	No
DVI1	FIY+PER+VAT+VATRAT+DEDRAT	Yes

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACC	General accounts		GAC			[GAC]GAC0="";ACC	Other
ACCDAT	Accounting date		D
AMTCUR	Amount in currency		MD1
AMTDUT	Postable amount		MD1
AMTDUTCUR	Postable currency amt		MD1
AMTDUTEUR	Postable euro amount		MD1
AMTEUR	EURO VAT amount		MD1
AMTVAT	Tax amount		MD1
AUUID	Single identifier		AUUID
BPRNAM	Company name	2	NAM
BPRNUM	BP		BPR			[BPR]BPR0=[DVI]BPRNUM	Block
BPRTYP	BP type		M	15	644
CALMONTH	Calendar month		C	2
CALYEAR	Civil year		C	4
CPY	Company		CPY			[CPY]CPY0=[DVI]CPY	Block
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[DVI]CREUSR	Other
CUR	Currency		CUR			[TCU]TCU0=[DVI]CUR	Block
DEDDUT	Deductible base		MD1
DEDRAT	Deductible %		DCB	3.6
DEDVAT	Input VAT		MD1
DESVCR	Description		DES
EECNUM	EU identification		A	20
EURCUR	EURO currency code		CUR			[TCU]TCU0=[DVI]EURCUR	Block
FCY	Site		FCY			[FCY]FCY0=[DVI]FCY	Block
FCYNUM	Site document code		FCY			[FCY]FCY0=[DVI]FCYNUM	Block
FIY	Fiscal year		C	2
INVDAT	Invoice date		D
INVNUM	Invoice number		VCR
JOU	Journal		JOU			[JOU]JOU0=JOU;[V]GSUPCLE	Block
NUM	Document no.		VCR
PER	Period		C	2
REGTYP	Registry type		A	1
SIM	Simulation		M	4	1
SNS	Sign		C	2
TYP	Entry type		GTE			[GTE]GTE0=TYP;[V]GSUPCLE	Block
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[DVI]UPDUSR	Other
VAT	Tax		VAT			[TVT]TVT0=VAT;[V]GSUPCLE	Block
VATNUM	IVA partita		A	15
VATPAY	Tax/collection flag		M	15	204
VATRAT	Rate		DCB	3.6
VATREG	VAT registry		ANM			[ANM]ANM0=[DVI]VATREG	Block
VATTYP	VAT type		A	4