Table MATERIAL

Table Abbreviation Description Module Activity code
MATERIAL MAT Materials Geode GX  

Key Description Duplicates Activity code
MAT0 FCY+MAT No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
FCY Site   FCY     [FCY]FCY0=[MAT]FCY Block  
MAT Material   MAT     [MAT]MAT0=FCY;MAT Delete  
MATDESAXX Description   AX3          
MATSHOAXX Short description   AX1          
MATTYP Material type   MTT     [MTT]MTT0=FCY;MATTYP Block  
MAXCUQ Max CU   L 8        
MAXVOL Max volume   QTY          
MAXWEI Max.wght   QTY          
TRFADD Transfer address   SLO     [SLO]SLO0=FCY;TRFSTO;TRFADD Block  
TRFSTO Transfer store   STO     [STO]STO0=FCY;TRFSTO Block  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5