Table ITMMASTER @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
ITMMASTER	ITM	Products	Common Data

Key	Description	Duplicates	Activity code
ITM0	ITMREF	No
ITM1	ITMDES1	Yes
ITM2	SEAKEY+ITMREF	No
ITM3	CFGLIN+ITMREF	No
ITM4	CFGVCRNUM+ITMREF	No	CFG
ITM5	PLMITMREF+ITMREF	No	PLM

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACCCOD	Accounting code		CAC			[CAC]CAC0=1;ACCCOD;[V]GSUPCLE	Block
ALG	Allergens		A	20				FOA
ALGBOM	Allergen BOM code		C	2				FOA
ALGDAT	Allergen change date		D					FOA
ALTBOMHDK	Code		TBO			[TBO]TBO0=1;ALTBOMHDK	RTZ
AUUID	Single identifier		AUUID
BRDCOD	Cost group		M	15	325
BUY	Buyer		AUS			[AUS]CODUSR=[ITM]BUY	Block
CCE	Analytical dimension		CCE			[CCE]CCE0=DIE(indice);CCE(indice)	Block	ANA
CFGBPRNUM	BP		BPR			[BPR]BPR0=[ITM]CFGBPRNUM	RTZ	CFG
CFGBPRREF	BP reference		A	20				CFG
CFGDELDAT	Config purge date		D					CFG
CFGFLDALP1	Alpha field 1		A	20
CFGFLDALP2	Alpha field 2		A	20
CFGFLDALP3	Alpha field 3		A	20
CFGFLDALP4	Alpha field 4		A	20
CFGFLDALP5	Alpha field 5		A	20
CFGFLDALP6	Alpha field 6		A	20
CFGFLDNUM1	Numeric field 1		DCB	15
CFGFLDNUM2	Numeric field 2		DCB	15
CFGFLDNUM3	Numeric field 3		DCB	15
CFGFLDNUM4	Numeric field 4		DCB	15
CFGFLDNUM5	Numeric field 5		DCB	15
CFGFLDNUM6	Numeric field 6		DCB	15
CFGITMREF	Reference product		ITM			[ITM]ITM0=[ITM]CFGITMREF	Delete	CFG
CFGLIN	Product line		TLP			[TLP]TLP0=[ITM]CFGLIN	Block
CFGVCRNUM	Journal number config		VCR					CFG
CPRAMT	Fixed cost per unit		MD5
CPRCOE	Landed cost coef.		COE
CPY	Company		CPY			[CPY]CPY0=[ITM]CPY	Block
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREMAC	Creation of base		M	4	1
CREUSR	Creation user		A	5
CSTGRP	Cost group		A	10
CUSREF	Customs reference		INO			[INO]INO0=[ITM]CUSREF	Block	DEB
DACPCUCOE	Factor authorized		M	4	1			NUC
DACPUUCOE	Purchase factor entry		M	4	1
DACSAUCOE	Sales factor entry		M	4	1
DAYUOM	Unit for days		UOM			[TUN]TUN0=[ITM]DAYUOM	RTZ
DEFACT	Default title		DCB	5.4
DEFPOT	Default potency %		DCB	5.4
DES1AXX	Description 1		AX3
DES2AXX	Description 2		AX3
DES3AXX	Description 3		AX3
DIE	Dimension type code		DIE			[DIE]DIE0=[ITM]DIE	Block	ANA
DLU	UBD coefficient		COE
DLVFLG	Deliverable		M	4	1
DTY	Density		COE
EANCOD	UPC code		A	20
ECCBOMALT2	Code	2	TBO			[TBO]TBO0=2;ECCBOMALT2(indice)	Block	ECC
ECCBOMALT3	Code	2	TBO			[TBO]TBO0=3;ECCBOMALT3(indice)	Block	ECC
ECCFLG	Version management		M	4	1			ECC
ECCMAJ	Major sequence		ICV			[ICV]ICV0=[ITM]ECCMAJ	Block	ECC
ECCMIN	Minor sequence		ICV			[ICV]ICV0=[ITM]ECCMIN	Block	ECC
ECCROUALT	Routing code	2	TRO			[TRO]TRO0=[ITM]ECCROUALT	Block	RVM
ECCROUFLG	Routing version		M	4	1			RVM
ECCSTO	Stock version		M	20	2777			ECC
EECGES	Sub Intrastat		M	4	1			DEB
EEU	Intrastat additional unit		UOM			[TUN]TUN0=[ITM]EEU	Block
EEUSTUCOE	EU-STK conv.		COE
EXPNUM	Export number		L	8
EXYMGTCOD	Expiration management		M	15	211
EXYSTA	Expiration status		A	1
FIMHOR	Firm horizon		C	4
FIMHORUOM	Firm horizon time un		M	15	291
FLGFAS	Capitalizable		M	4	1			FAS
FLYCAT	Voucher category		ADI			[ADI]CODE=450;FLYCAT	RTZ
FRTHOR	Planning horizon		C	4
FRTHORUOM	Planning horizon time unit		M	15	291
GENFLG	Generic		M	4	1
GTIN	GTIN		A	14
HDKITMTYP	Product type		M	15	2984
HOUUOM	Unit for hour		UOM			[TUN]TUN0=[ITM]HOUUOM	RTZ
INTFLG	Intermediary		M	4	1
INVPRODTYP	Product type		M	25	2051			KPO
ITMDES1	Description 1		DES
ITMDES2	Description 2		DES
ITMDES3	Description 3		DES
ITMEXNFLG	Exemption flag		A	1
ITMREF	Product		ITM			[ITM]ITM0=[ITM]ITMREF	Delete
ITMSFTTYP	SAF-T product type		M	15	2273			SAFT
ITMSTA	Product status		M	15	246
ITMSTD	Standard		A	20
ITMVOU	STK volume		VOL
ITMWEI	Item weight		WEI
LBEFMT	Label format		ARP			[ARP]ARP0=[ITM]LBEFMT	Block	NUC
LIFENDDAT	Service life end		D
LIFSTRDAT	Service life start		D
LOAECCFLG	Version preload		M	4	1			ECC
LOTCOU	Lot sequence number		ANM			[ANM]ANM0=[ITM]LOTCOU	Block
LOTMGTCOD	Lot management		M	15	2711
MATTOL	Matching tolerance		MAT			[MAT]MAT0=[ITM]MATTOL	Block
MFGFLG	Manufactured		M	4	1
MFGTEX	Production text		TXC
MINRMNPRC	Delivery tolerance %		RAT
MNTUOM	Unit for minutes		UOM			[TUN]TUN0=[ITM]MNTUOM	RTZ
NEGSTO	Stock < 0 authorized		M	4	1
NEWLTISTA	Recontrol status		A	1
NPIPRO	Prototype		M	4	1			NPI
OFS	Reorder LT		C	4
PCCCOD	Cost type		PJCC			[PJCC]PCC0=[ITM]PCCCOD	Block	PJM
PCU	Packing unit		UOM			[TUN]TUN0=[ITM]PCU	Block	NUC
PCURUL	Issuing PAC		M	30	2706			NUC
PCUSTUCOE	PAC-STK conv.		COE					NUC
PHAFLG	Phantom		M	4	1
PITCDT	Tokens to be credited		L	8
PITCDTUOM	Credit unit		UOM			[TUN]TUN0=[ITM]PITCDTUOM	RTZ
PLAACS	User access		ACS			[ACS]ACS0=[ITM]PLAACS	Block
PLANNER	Planner		AUS			[AUS]CODUSR=[ITM]PLANNER	Block
PLMATTURL	Linked documents		A	250
PLMHISURL	PLM history		A	250
PLMITMREF	PLM product		PLM
PRQFLG	Mandatory PO request		M	4	1
PURBASPRI	Base price		MD5
PURFLG	Bought		M	4	1
PURTEX	Purchase text		TXC
PUU	Purchase unit		UOM			[TUN]TUN0=[ITM]PUU	Block
PUUSTUCOE	PUR-STK conv.		COE
RCPFLG	Receipt code		M	4	1
RPLITM	Alternate product		ITM			[ITM]ITM0=[ITM]RPLITM	Block
SALFLG	Sold		M	4	1
SAU	Sales unit		UOM			[TUN]TUN0=[ITM]SAU	Block
SAUSTUCOE	SAL-STK conv.		COE
SCPFLG	Subcontracted		M	4	1
SCSFLG	Subcontract		M	4	1
SEAKEY	Search key		A	20
SERCOU	Serial sequence		ANM			[ANM]ANM0=[ITM]SERCOU	Block
SERMGTCOD	Serial no. management		M	15	210
SHL	Shelf life		C	4
SHLLTI	Recontrol lead time		C	4
SHLLTIUOM	Rectrl time unit		M	15	2759
SHLUOM	Expir t unit		M	15	2759
SSTCOD	SST tax code		ADI			[ADI]CODE=203;SSTCOD	Block	LTA
SSU	Statistical unit		UOM			[TUN]TUN0=[ITM]SSU	Block
SSUSTUCOE	STA-STK conv.		COE
STAFED	Region/State		ADI			[ADI]CODE=80;STAFED	Block	DEBR
STATAXFLG	Tax flag		A	1
STCNUM	Cost structure		VCR
STDFLG	Management mode		M	15	297
STOCRD	Storage sheet		A	8
STOISSDEF	Stock issue		M	4	1
STOMGTCOD	Stock management		M	15	215
STU	Stock unit		UOM			[TUN]TUN0=[ITM]STU	Block
STULBEFMT	Label format		ARP			[ARP]ARP0=[ITM]STULBEFMT	Block
TCLCOD	Category		ITG			[ITG]ITG0="";TCLCOD	Block
TOOFLG	Tools		M	4	1
TPLCONGUA	Warranty contract		COT			[COT]COT0=[ITM]TPLCONGUA	RTZ
TPLCONLND	Loan contract		COT			[COT]COT0=[ITM]TPLCONLND	RTZ
TPLCONSRV	Service contract		COT			[COT]COT0=[ITM]TPLCONSRV	RTZ
TRKCOD	Traceability		M	15	754
TRKLEV	Traceability level		M	15	2778
TSICOD	Statistical group		ADI			[ADI]CODE=indice+20;TSICOD(indice)	Block	STI
UNNBR	UN number		UNNBR			[TUNNB]TUNNB0=[ITM]UNNBR	Block
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5
VACITM	Tax level	3	TVI			[TVI]TVI0=VACITM(indice);[V]GSUPCLE	Block
VOU	Volume unit		UOM			[TUN]TUN0=[ITM]VOU	Block
WEU	Weight unit		UOM			[TUN]TUN0=[ITM]WEU	Block