Table HDKTRS @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
HDKTRS	HTR	HDK entry transaction	Help Desk

Key	Description	Duplicates	Activity code
HTR0	HTRTYP+HTRNUM	No
HTR1	HTRNUM+HTRTYP	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACSCOD	Access code		ACS			[ACS]ACS0=[HTR]ACSCOD	Block
AMTINVCOD	Invoiceable amount		M	15	35
AUSTYPCOD	Provider type		M	15	35
AUUID	Single identifier		AUUID
BLOCINVI	Hidden block	15	A	15
BPCCURCOD	Purchase currency		M	15	35
BPCDATCOD	Purchase date		M	15	35
BPCGRUCOD	Group customer		M	15	35
BPCINVCOD	Bill-to customer		M	15	35
BPCPRICOD	Purchase price		M	15	35
BPCPYRCOD	Pay-by		M	15	35
BRACOD	Brand		M	15	35
CCECOD	Analytical dimensions		M	15	35
CHGTYPCOD	Rate type		M	15	35
CLELIS	Index	8	ANX
COLFIXNAM	Fixed column grid	10	A	25
COLFIXVAL	Fix.col. grid value	10	C	1
CONSPTCOD	Support contract		M	15	35
COULIS	Numbering active	8	M	4	1
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
CURCOD	Sales currency		M	15	35
DEPCOD	Settlement discount		M	15	35
DERLU	Last read		M	4	1
DESAXX	Description		AX3
DOCFLG	Auto print		M	4	1
DOCNAM	Document		ARP			[ARP]ARP0=[HTR]DOCNAM	Block
DONDATCOD	Date executed		M	15	35
DONHOUCOD	Carried out the		M	15	35
DOOCOD	Service caller		M	15	35
DTCKILCOD	Distance		M	15	35
ECCCOD	Major version		M	15	35			ECC
ECCCODMIN	Minor version		M	15	35			ECC
ENAFLG	Active		M	4	1
ENTCOD	Auto journal code		GAU			[GAU]GAU0=[HTR]ENTCOD	Block
EXPNUM	Export number		L	8
FCYITNFLG	Address tab		M	4	1
FIRLIS	In first position		M	4	1
FLTLIS	Filter	8	A	215
FLYWARFLG	Warranty requests		M	4	1
GFY	Group		AGF			[AGF]AGF0=[HTR]GFY	Block
GRALEVCOD	Severity		M	15	35
HDKITNCAT	Category		M	4	1
HDKITNDAT	Period		M	4	1
HDKITNDSY	Display	15	M	4	1
HDKITNPOS	Position	15	L	8
HDKITNSCO	Sub-contracted operations		M	4	1
HDKITNUSR	Employee		M	4	1
HDKSREDSY	Display	20	M	4	1
HDKSREGRA	Severity level		M	4	1
HDKSREPOS	Position	20	L	8
HDKSREQUE	Queue		M	4	1
HDKSRESAT	Status		M	4	1
HDKSREUSR	Employee		M	4	1
HDTAMTCOD	Amount consumed		M	15	35
HDTAUSCOD	Provider		M	15	35
HDTCPNCOD	Component		M	15	35
HDTINVCOD	Billable		M	15	35
HDTMACCOD	Base		M	15	35
HDTNUMCOD	Conso chrono		M	15	35
HDTPITCOD	Points debited		M	15	35
HDTTEXCOD	Text		M	15	35
HDTTIMCOD	Real duration		M	15	35
HDTTOTFLG	Totals		M	4	1
HDTTYPCOD	Consumption type		M	15	35
HSTOFCYCOD	Site stock (line)		M	15	35
HTRDES	Description		DES
HTRNUM	Transaction		TRS
HTRTYP	Transaction type		M	15	3020
HTRTYPCAR	Alpha no.		A	2
IFFADDCOD	Address indications		M	15	35
INVDTACOD	Invoice elements		M	15	35
ISSISSCOD	Quantity issued		M	15	35
ISSQTYCOD	Quantity to issue		M	15	35
ITNDATCOD	Installation date		M	15	35
ITNNUMCOD	Action Chrono		M	15	35
ITNTIMFLG	Time management		M	4	1
ITSDATCOD	In service date		M	15	35
MACCONFLG	Direct coverage		M	4	1
MAIFLG	Installations		M	4	1
NPRFLG	Auto print		M	4	1
NPRNAM	Document		ARP			[ARP]ARP0=[HTR]NPRNAM	Block
NUMBPCCOD	Customer request		M	15	35
OBJCOD	Additional info		M	15	35
OBJLIS	Object	8	AOB			[AOB]ABREV=[HTR]OBJLIS	Block
ONGINVISI	Hidden tab	10	A	15
ONGLETACT	Active tab		AMK			[AMK]CODMSK=[HTR]ONGLETACT	Block
ORDLIS	Sign	8	M	10	90
PJTCOD	Project		M	15	35
PLNDATCOD	Planned the		M	15	35
PRITYPCOD	Price type		M	15	35
PTECOD	Payment term		M	15	35
PURDATCOD	Sales date		M	15	35
REPCOD	Sales reps		M	15	35
RESDATCOD	Resolution date		M	15	35
RESHOUCOD	Resolution time		M	15	35
RESRENCOD	Reason		M	15	35
SALPRICOD	Sale price		M	15	35
SATCOD	Status		M	15	35
SBBTOTFLG	Subtotals		M	4	1
SCOAMTCOD	Subcontracted amount		M	15	35
SCOCOD	Subcontracted		M	15	35
SRETSDCOD	Stat groups		M	15	35
SSTENTCOD	Entity/Use		M	15	35			LTA
STOFCYCOD	Site stock (header)		M	15	35
STOISSCOD	Stock issue		M	15	35
TIMSPGCOD	Time spent		M	15	35
TITNADDFLG	Addresses		M	4	1
TITNHDTFLG	Consumptions		M	4	1
TITNRSEFLG	Resources		M	4	1
TRITIMCOD	Commute time		M	15	35
TRSCOD	Movement code		ADI			[ADI]CODE=14;TRSCOD	Block
TRSFAM	Transaction group		ADI			[ADI]CODE=9;TRSFAM	Block
TSRECOVFLG	Coverages		M	4	1
TSRECPNFLG	Components		M	4	1
TSREESCFLG	Escalations		M	4	1
TSREHDTFLG	Consumptions		M	4	1
TSREHORFLG	Timestamps		M	4	1
TSREINVFLG	Invoicing		M	4	1
TSREMACFLG	Base		M	4	1
TSREPBLFLG	Skills		M	4	1
TSREPITFLG	Points management		M	4	1
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5
VACBPRCOD	Tax rule		M	15	35