Table ITEM

Table Abbreviation Description Module Activity code
ITEM ITM Products Geode GX  

Key Description Duplicates Activity code
ITM0 FCY+DEP+ITM No  
ITM1 FCY+SKCCLS+SKCNBR+LASSKCDAT+CREDAT+DEP+ITM No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ALCVOL Pure alcohol volume   QTY          
AMMNUM AMM no   A 7        
AST Alert stock   QTA          
AUUID Single identifier   AUUID          
CDKMGT Cross docking   M 4 1      
COD Other code   A 20        
CODE Classification code   A 5        
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CTLCODDAC Key in control code   M 4 1      
DAG Active matter   DAG     [DAG]DAG0=FCY;DAG(indice) Block DG0
DAGPCT %   DCB 6.2       DG0
DAGPRTLBL Printable description   M 4 1     DG0
DCTNUM Transport category   DCT     [DCT]DCT0=FCY;DCTNUM Block  
DEP Depositor   DEP     [DEP]DEP0=FCY;DEP Block  
DFTCTR Default container   ITC     [ITC]ITC0=FCY;DEP;ITM;DFTCTR RTZ  
DFTCTRLVL Def. cntr. level   M 15 311      
DGG Material   DGG     [DGG]DGG0=FCY;DEP;DGG Block  
DGGMGT Hazardous materials   M 4 1      
DGGREFTUN Tunnel restriction   A 6        
DIC ICPE class   DIC     [DIC]DIC0=FCY;DIC Block  
DMCNUM Haz mat class   DMC     [DMC]DMC0=FCY;DMCNUM Block  
ENAFLG Active   M 4 1      
ENDLIF Item end of life   D          
FAM Family   FAM     [FAM]FAM0=FCY;DEP;FAM Block  
FCY Site   FCY     [FCY]FCY0=FCY Block  
FIFDAT FIFO date nature   M 25 346      
FIFDEV FIFO tolerance   C 2        
FIFDEVUOM FIFO gap unit   M 10 347      
FIRINPDAT First arrival   D          
FRZPNT Freezing point   L 5        
FRZREV Freezing reversibility   M 15 421      
GENLEVINS General level of inspection   A 2        
GRP Packaging group   M 1 420      
GRU Group   GRU     [GRU]GRU0=FCY;DEP;GRU Block  
IDENT1 Identifier 1   ID1          
INPLOK Blocked in input   M 4 1      
INPLOK2 Blocked in input   M 4 1      
INPMOD Input mode   IMD     [IMD]IMD0=FCY;DEP;INPMOD Block  
ITM Product   ITM     [ITM]ITM0=FCY;DEP;ITM Delete  
ITMDESAXX Description   AX3          
ITMDESAXX2 Description   AX3          
ITMSHOAXX Short description   AX1          
LASINPDAT Last receipt   D          
LASOUTDAT Last output   D          
LASSKCDAT Last stock count   D          
LGTPNT Flash point   L 3        
LOTMGT Key in lot no.   M 4 1      
MAXSTK Maximum stock   QTA          
MINSTK Minimum stock   QTA          
NETVOL Net volume   QTY          
NETWEI Net weight   QTY          
NQA AQL   DCB 3.1        
ONU ONU codes   DON     [DON]DON0=FCY;ONU Block  
ORI Source   ITO     [ITO]ITO0=FCY;DEP;ORI Block  
OUTLOK Blocked in output   M 4 1      
OUTLOK2 Blocked in input   M 4 1      
OUTMOD Output mode   OMD     [OMD]OMD0=FCY;DEP;OUTMOD Block  
PRI Price   MD1          
QLYCRD Quality record   A 8        
QLYFLG QC management   M 4 1      
QLYSKN Stock Status   SKN     [SKN]SKN0=FCY;QLYSKN Block  
REFQTY Referred qty   DCB 7.3        
REFUNT Referred unit   UOM     [TUN]TUN0=[ITM]REFUNT Block  
RTDTER Detention length   C 2        
RTDUOM Detention unit   M 10 347      
SFA Sub-family   SFA     [SFA]SFA0=FCY;DEP;SFA Block  
SGR Subgroup   SGR     [SGR]SGR0=FCY;DEP;SGR Block  
SKCCLS Stock count class   SCC     [SCC]CCL0=FCY;SKCCLS Block  
SKCNBR No. stock counts   C 3        
SKCNUM Stock count   SKH     [SKH]SKH0=FCY;SKCNUM Other  
SLDTER SBD length   C 2        
SLDUOM SBD unit   M 10 347      
SMPTYP Sampling type   M 15 395      
SNDTER SbD length   C 2        
SNDUOM SbD unit   M 10 347      
SNGLOTCTL Single lot control   M 4 1      
SNGLOTMGT Single lot   M 4 1      
SOLCOD Solvent code   A 30        
SRNMGT Key in serial no   M 4 1      
STU Stock unit   UOM     [TUN]TUN0=[ITM]STU Block  
STUMGT Stock unit management   M 4 1      
TECFLD Technical field   A 30        
TRFMOD Auto transfer mode   M 15 365      
TRM Transmis   M 10 352      
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USDTER UBD length   C 2        
USDUOM UBD unit   M 10 347