Table SPLIBREG @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
SPLIBREG	SPLREG	Bookkeeping	Financials	KSP

Key	Description	Duplicates	Activity code
SPLREG0	CPY+RECTYP+REGTYP+INVNUM+VAT	No
SPLREG1	CPY+RECTYP+REGTYP+FIY+PER	Yes

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation
ACTIAE	IAE activity		A	6
ACTSUBTYP	Activity subtype		A	2
ACTTYP	Activity type		A	1
AMTTAX	Tax amount		DCB	12.2
AMTTOT	Invoice total		DCB	12.2
AUUID	Single identifier		AUUID
BPNAME	BP name		A	40
BUILOC	Location		A	1
CDRREF	Cadastre		A	20
CPY	Company		CPY			[CPY]CPY0=[SPLREG]CPY	Block
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[SPLREG]CREUSR	Other
CRN	BP identification		CRN
CRY	Country		CRY			[TCY]TCY0=[SPLREG]CRY	Block
CSHAMT	Cash VAT amount		DCB	12.2
CSHMET	Cash VAT method		A	2
CSHMETID	Cash VAT method ID		A	32
CSHVATDAT	Cash VAT date		D
DEDAMT	Deductible amount		MD1
DEDFIY	Deduction fiscal year		C	4
DEDLATPER	Deductible in later period		A	1
DEDPER	Deduction period		A	2
DEDRAT	Deductible %		DCB	3.6
DOCTYP	Document type		M	15	2004
EECNUM	EU identification		EEC
ENDDAT	End date		D
EXTREF	External reference		A	40
FCY	Site		FCY			[FCY]FCY0=[SPLREG]FCY	Delete
FIY	Fiscal year		C	2
INIDAT	Start date		D
INVGOOD	Investment goods		A	1
INVNUM	Invoice number		VCR
INVNUMEND	Final invoice number		A	20
INVTYP	Invoice type		M	4	645
INVTYPSPA	Invoice type		A	2
MACTSUBTYP	Main activity subtype		A	2
MAINACTIAE	Main activity		A	6
MAINACTTYP	Main activity type		A	1
MAINREGAGR	Main billing agreement		A	14
NATTYP	Operation nature		A	2
OPEAMT	Amount		DCB	12.2
OPECONCEPT	Operation subject		A	3
OPEDAT	Operation date		D
OPEEXE	Exempted operation		A	2
OPEKEY	Operation key		A	2
PER	Period		C	2
PTHDAT	Receipt date		D
PTHNUM	Receipt number		VCR
PTHNUMEND	Final receipt number		VCR
RECTYP	Record type		A	1
REGAGR	Registration agreement		A	15
REGTYP	Tax rule type		C	2
REVCHG	Reverse charge		A	1
SDHDAT	Issue date		D
SERIE	Series		A	20
STA	Status		M	4	1
SUBTAX	Subject to tax		DCB	12.2
SURRAT	Surcharge type		DCB	4.2
SURTAXAMT	Equivalence surcharge tax		DCB	12.2
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[SPLREG]UPDUSR	Other
VAT	Tax		VAT			[TVT]TVT0=[SPLREG]VAT	BSRA
VATRAT	Rate		DCB	3.2
VCRLIN	Entry line no.		L	8
WTHAMT	Withholding amount	10	DCB	12.2
WTHRAT	Withholding type	10	DCB	4.2