Table DCLSII @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
DCLSII	DSII	SII monitor	Common Data	KSP

Key	Description	Duplicates
DSII0	CPY+TYPENV+GTE+VCRNUM+VCRLIN	No
DSII1	DKEY	No
DSII2	CPY+FCY+TYPENV+GTE+VCRNUM+VCRLIN	No

Column	Normal title	Type	Length	Menu	Link expression	Cancellation
AMTATI	Invoice total	DCB	13.2
AMTATIORI	Final payment	DCB	13.2
AUUID	Single identifier	AUUID
BPR	BP code	A	40
BPRNAM	Company name	A	120
BPRVCR	Source document	A	60
CLADECCON	Consignment key	A	1
CLAVDEC	Key	A	1
CLAVEOPE	Operation key	A	1
CODOPE	Operation code	A	3
CPY	Company	CPY			[CPY]CPY0=[DSII]CPY	Block
CREDATTIM	Date time	ADATIM
CREUSR	User	AUS			[AUS]CODUSR=[DSII]CREUSR	Other
CRY	Country	CRY			[TCY]TCY0=[DSII]CRY	Block
DATDVS	Date time	ADATIM
DATENV	Issue date	ADATIM
DATOPE	Operation date	D
DATOPEDEC	Declared operation date	D
DATVCRORI	Source date	ADATIM
DESBIENES	Asset description	A	40
DESCRY	Destination country	CRY			[TCY]TCY0=[DSII]DESCRY	Block
DIRECOPE	EU operator address	A	120
DKEY	Declared key	A	100
EJEREXPINI	Fiscal year	A	4
ESTMIEMBRO	EU member state	A	2
EXPDAT	Export date	D
FACDOC	Other documents	A	150
FCY	Site	FCY			[FCY]FCY0=[DSII]FCY	Other
FECHAINI	Use start date	D
FLGNIFREC	TIN not registered	M	4	1
FLGSEL	Send	M	4	1
GTE	Entry type	GTE			[GTE]GTE0=GTE(indice);[V]GSUPCLE	Block
IDENTBIEN	Asset ID	A	40
IDENTENT	Delivery number	A	40
IDEXPINI	Identifier	A	60
LOTNUM	Batch	A	16
NIFREPC	Representative TIN	A	40
NIP	Identification	A	40
OPEREF	Operation reference	A	250
ORICRY	Country of origin	CRY			[TCY]TCY0=[DSII]ORICRY	Other
PEREXPINI	Period	A	2
PLAZOOPE	Operation lead time	C	3
PRORRATA	Prorate	DCB	2.2
QTY	Quantity	QTY
RECDAT	Receipt date	D
REGDEDUCEFE	Deduction adjustment	DCB	12.2
REGUANUAL	Annual adjustment	DCB	12.2
STADOC	Document status	M	50	2119
TIMESTAMP	Last transmitted	A	19
TYPANUAL	Operation type	A	1
TYPCOM	Communication type	M	50	2116
TYPENV	Transmission method	M	50	2115
TYPOPE	Operation type	A	1
TYPOPECON	Consignment type	M	50	2125
TYPREC	Record type	A	1
UNIPRI	Unit price	DCB	12.2
UPDDATTIM	Date time	ADATIM
UPDUSR	User	AUS			[AUS]CODUSR=[DSII]UPDUSR	Other
VALBASIMP	Tax base value	DCB	12.2
VALBIEN	Stock value	DCB	12.2
VCRERRDES	Error description	A	250
VCRERRNUM	Error code	A	10
VCRLIN	Line	L	8
VCRNUM	Document	A	60
VCRSTA	Tax authority status	M	50	2118
VCRTYP	Document type	M	50	2109