Table Abbreviation Description Module Activity code
CONTACTCRM AIN Contact relationships Supervisor  

Key Description Duplicates Activity code
AIN0 CNTNUM No  
AIN1 CNTFULNAM Yes  
AIN2 CNTTYP+CNTNUM No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ADD Address 3 ADL          
AUUID Single identifier   AUUID          
CNTBIR Date of birth   D          
CNTCSP Category   ADI     [ADI]CODE=907;CNTCSP Block  
CNTEMA Email   MAI          
CNTETS Telephone   TEL          
CNTFAX Fax   TEL          
CNTFBDMAG Mailing prohibited   M 4 1      
CNTFNA First name   A 20        
CNTFULNAM Search key   A 60        
CNTLAN Language   LAN     [TLA]TLA0=[AIN]CNTLAN Block  
CNTLNA Last name   NAM          
CNTMOB Mobile phone   TEL          
CNTNUM Code   AIN     [AIN]AIN0=[AIN]CNTNUM Delete  
CNTTTL Title   M 20 941      
CNTTYP Type   M 15 7811      
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   AUS     [AUS]CODUSR=[AIN]CREUSR Other  
CRY Country   CRY     [TCY]TCY0=[AIN]CRY Block  
CRYNAM Country name   NCY          
CTY City   CTY          
EXPNUM Export number   L 8        
RDEPITNUM Residence permit   A 10       KMA
SAT County   SAT          
SSCNUM Soc. security fund   DCB 19.8       KMA
UIDCRDNUM ID card number   A 10       KMA
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   AUS     [AUS]CODUSR=[AIN]UPDUSR Other  
ZIP Postal code   POS