Table > Module Common Data > Table SII inquiry

Table CNSSII

Table	Abbreviation	Description	Module	Activity code
CNSSII	CSII	SII inquiry	Common Data	KSP

Key	Description	Duplicates	Activity code
CSII0	CPY+TYPENV+EJERCICIO+PERIODO+NUM+VCRNUM+VCRNUMLIN	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CCAJA	Cash VAT		M	4	1
CLAVEOPE	Key		A	1
CPY	Company		CPY			[CPY]CPY0=[CSII]CPY	Block
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[CSII]CREUSR	Other
CSV	CSV		A	16
EJERCICIO	Fiscal year		C	4
ESTADO	Status		A	20
ESTADOCON	Verification status		M	50	2120
FACMOD	Updated invoice		M	4	1
FECHAEXP	Shipping date		A	10
FECHAPRE	Submission date		A	19
FECHMOD	Last update date		A	19
IDENBIEN	Asset ID		A	40
IDENDESEMI	Recipient/issuer ID		A	40
IDENTIFCADOR	Identification		A	40
IMPORTE	Amount		DCB	12.2
NIFDESEMI	Recipient/issuer TIN		A	40
NIFDESTIN	Recipient TIN		A	40
NIFEMISOR	Issuer TIN		A	40
NUM	Number		L	8
PAIS	Country code		A	2
PAISDESEMI	Recipient/issuer country		A	2
PERIODO	Period		A	2
RAZONSOC	Company name		A	60
TYPDOC	Identification type		M	15	2004
TYPENV	Transmission method		M	50	2115
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[CSII]UPDUSR	Other
VCRNUM	Document		A	60
VCRNUMLIN	Line		C	2