Table CONTACTCRM
| 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 | 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 |