Dictionary >  Module Supervisor >  Table Contact relationships  

Display all Hide all

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 Social 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