Table Abbreviation Description Module Activity code
TABMAT TMA ID numbers Common Data  

Key Description Duplicates Activity code
TMA0 EMPNUM No  
TMA1 USR Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACTDAT Active date   D          
AUUID Single identifier   AUUID          
CHGRAT Labor rate   DCB 12        
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DEFFCY Site   FCY     [FCY]FCY0=[TMA]DEFFCY Block  
DEFWCR Work center group   WCR     [TWC]TWC0=[TMA]DEFWCR Block  
DEFWST Work center   WST          
ELPFLG Elapsed labor   M 4 1      
EMPDES Description   DES          
EMPNUM Employee ID   EPN          
EMPSHO Short description   SHO          
EMPTYP Employee type   M 15 2425      
ENAFLG Active   M 4 1      
INACTDAT Inactive date   D          
SHIFT Shift code   SHFT     [SFTS]SHF0=[TMA]SHIFT Block  
SUMEMP Number of employees   L 8        
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USR User code   AUS     [AUS]CODUSR=[TMA]USR Delete