Table CONTACT
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| CONTACT | CNT | Contacts | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CNT0 | BPATYP+BPANUM+CCNCRM | No | |
| CNT1 | CCNCRM+BPATYP+BPANUM | No | |
| CNT2 | CCNCRM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPAADD | Address | ADR | ||||||
| BPANUM | Entity | BPA | ||||||
| BPATYP | Entity type | M | 15 | 943 | ||||
| CCNCRM | Code | AIN | [AIN]AIN0=[CNT]CCNCRM | Block | ||||
| CNTFNC | Function | M | 15 | 233 | ||||
| CNTMSS | Role | ADI | [ADI]CODE=906;CNTMSS | RTZ | ||||
| CNTSRV | Department | A | 30 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[CNT]CREUSR | Other | ||||
| EXPNUM | Export number | L | 8 | |||||
| FAX | Fax | TEL | ||||||
| MOB | Mobile phone | TEL | ||||||
| TEL | Telephone | TEL | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[CNT]UPDUSR | Other | ||||
| WEB | MAI |