Table CONTSERV @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
CONTSERV	CON	Service contract	Common Data

Key	Description	Duplicates
CON0	CONNUM	No
CON1	CONENDDAT	Yes
CON2	CONBPC	Yes
CON3	CONCCN	Yes
CON4	CONBPC+RSIFLG+FDDFLG	Yes
CON5	CONORI+CONORIVCR+CONORIVCRL	Yes

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACPDPTCOD	Litigation accepted	25	ADI			[ADI]CODE=315;ACPDPTCOD	Block
AMTPLY	Penalty amount		MD1
AMTPLYX	Penalty amount		MD1
AUUID	Single identifier		AUUID
BASEXXAMT	Expression database		M	15	976
BASEXXAMTX	Expression database		M	15	976
BASEXXITT	Expression database		M	15	976
BASEXXITTX	Expression database		M	15	976
BASEXXSOL	Expression database		M	15	976
BASEXXSOLX	Expression database		M	15	976
CCE	Analytical dimension		CCE			[CCE]CCE0=DIE(indice);CCE(indice)	Block	ANA
CONAMT	Amount		MD1
CONBASFOR	Revaluation formula		ADI			[ADI]CODE=427;CONBASFOR	Block
CONBASIDX	Indexing database		ADI			[ADI]CODE=410;CONBASIDX	Block
CONBPC	Sold-to		BPR			[BPR]BPR0=[CON]CONBPC	Block
CONBPCGRU	Group customer		BPR			[BPR]BPR0=[CON]CONBPCGRU	Block
CONBPCINV	Bill-to customer		BPR			[BPR]BPR0=[CON]CONBPCINV	Block
CONBPCPYR	Pay-by		BPR			[BPR]BPR0=[CON]CONBPCPYR	Block
CONCAT	Category		M	15	2976
CONCCN	Contact (relationship)		AIN			[AIN]AIN0=[CON]CONCCN	Block
CONCHGTYP	Rate type		M	15	202
CONCOT	Contract template		VCR
CONENDDAT	End date		D
CONNAM	Description		A	85
CONNUM	Code		VCR
CONORI	Source		M	15	2977
CONORIVCR	Original document no.		VCR
CONORIVCRL	Source document line		L	8
CONPJT	Project		PJT			[PIM]PIM0=[CON]CONPJT	Block
CONPRITYP	Price type		M	6	243
CONREW	Renewable		M	4	1
CONSTRDAT	Start date		D
CONTYP	Statistical group		ADI			[ADI]CODE=indice+440;CONTYP(indice)	Block	STO
CONTYPCLA	Category		DES
CONVACBPR	Tax rule		TVB			[TVB]TVB0=CONVACBPR;[V]GSUPCLE	Block
CPY	Company		CPY			[CPY]CPY0=[CON]CPY	Block
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
CRSCOVSAM	Coverage viewed		M	4	1
CUR	Currency		CUR			[TCU]TCU0=[CON]CUR	Block
DIE	Dimension type code		DIE			[DIE]DIE0=[CON]DIE	Block	ANA
DSYWND	Display left list		C	2
EVRMAC	All products		M	4	1
EVRPBL	All skills		M	4	1
FDDFLG	Archived		M	4	1
FDDUSR	Archived by		A	5
GUA	Warranty		M	4	1
INVDTA	Invoicing element		SFI			[SFI]SFI0=[CON]INVDTA	Block	SFI
INVDTAAMT	% or amt inv el		DCB	11.4				SFI
INVDTATYP	Value type		M	6	2227			SFI
INVFRY	Invoicing freq		C	4
INVFRYBAS	Basis		M	15	976
INVFRYCOE	Coefficient		DCB	3.2
INVLTI	Invoicing advance notice		C	4
INVLTIBAS	Basis		M	15	976
INVMET	Invoicing method		M	15	2978
ITMREF	Product code		ITM			[ITM]ITM0=[CON]ITMREF	Block
ITTDATEND	Intervention end		D
ITTDATENDX	Intervention end		D
ITTDUR	Duration		C	4
ITTDURBAS	Expression database		M	15	976
ITTDURBASX	Expression database		M	15	976
ITTDURX	B duration		C	4
ITTFCY	Intervention / site		M	4	1
ITTFCYX	Intervention / site		M	4	1
ITTLTIMAX	Max intrvn LT		C	4
ITTLTIMAXX	Max intrvn LT		C	4
LASIDXDAT	Last value date		D
LASINVDAT	Last invoice		D
LASVALIDX	Last index value		MD1
MANCONENDDAT	End date		D
MANCONREW	Renewable		M	4	1
MANCONSTRDAT	Start date		D
MANREWAMT	Renewal amount		MD1
MANREWFLG	To renew		M	4	1
MANREWFRY	Renew frequency		C	4
MANREWFRYBAS	Basis		M	15	976
NEXINVAMT	Next invoice amount		MD1
NEXINVDAT	Next invoice		D
NEXSHIINV	Next invoice sending		D
OCONAMT	Amount		MD1
OCONENDDAT	End date		D
OCONSTRDAT	Start date		D
ODSYWND	Old left list		C	2
OINV	Invoice		SIH			[SIV]SIV0=[CON]OINV	Other
OLASIDXDAT	Last value date		D
OLASINVDAT	Prev last invoice		D
OLASVALIDX	Last index value		MD1
ONEXINVAMT	Old amount		MD1
ONEXINVDAT	Former next invoice		D
ONEXSHIINV	Former next mailing		D
ORDLINNUM	Order line no.		L	8
ORDNUM	Order number		SOH			[SOH]SOH0=[CON]ORDNUM	Block
ORDUPDFLG	Order no. modification		M	4	1
OREWINV	Invoice		SIH			[SIV]SIV0=[CON]OREWINV	Other
ORVADAT	Revaluation date		D
ORVAINV	Invoice		SIH			[SIV]SIV0=[CON]ORVAINV	Other
OTHCNI	Other constraints		CLX
PITBLC	Remaining points		L	8
PITCDT	Points credit		L	8
PITCSM	Points consumed		L	8
PITRER	Points available		L	8
PITTOL	Points tolerance		C	3
PTE	Payment terms		PTE			[TPT]TPT0=PTE;[V]GCURLEG;1	Block
REWFRY	Renew frequency		C	4
REWFRYBAS	Basis		M	15	976
RSIDAT	Termination date		D
RSIFLG	Cancelled contract		M	4	1
RSILTI	Advance notice of cancellation		C	4
RSILTIBAS	Basis		M	15	976
RSIREN	Termination reason		ADI			[ADI]CODE=429;RSIREN	Block
RVADAT	Revaluation date		D
RVAFRY	Revaluation freq		C	4
RVAFRYBAS	Basis		M	15	976
RVAMET	Revaluation method		M	15	2979
RVASSP	Revaluation support		M	15	2974
SALFCY	Sales site		FCY			[FCY]FCY0=[CON]SALFCY	Block
SALREP	Sales rep		REP			[REP]REP0=[CON]SALREP	Block	REC
SFISSTCOD	SST tax code		ADI			[ADI]CODE=203;SFISSTCOD	Block	SFI
SIUDAT	Subscription date		D
SOLLTIMAX	Max rsltn LT		C	4
SOLLTIMAXX	Max rsltn LT		C	4
SSTENTCOD	Entity/Use		ADI			[ADI]CODE=202;SSTENTCOD	Block	LTA
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5