Table CONTACTXT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CONTACTXT | CNTXT | Contacts | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CNT0 | UIDSES+BPATYP+BPANUM+CCNCRM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | 3 | ADL | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPAADD | Address | ADR | ||||||
| BPANUM | Entity | BPA | ||||||
| BPATYP | Entity type | M | 15 | 943 | ||||
| CCNCRM | Code | AIN | [AIN]AIN0=[CNTXT]CCNCRM | Block | ||||
| 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 | |||||
| CNTFNC | Function | M | 15 | 233 | ||||
| CNTFULNAM | Search key | A | 60 | |||||
| CNTLAN | Language | LAN | [TLA]TLA0=[CNTXT]CNTLAN | Block | ||||
| CNTLNA | Last name | NAM | ||||||
| CNTMOB | Mobile phone | TEL | ||||||
| CNTMSS | Role | ADI | [ADI]CODE=906;CNTMSS | RTZ | ||||
| CNTSRV | Department | A | 30 | |||||
| CNTTTL | Title | M | 20 | 941 | ||||
| CNTTYP | Type | M | 15 | 7811 | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[CNTXT]CREUSR | Other | ||||
| CRUD | Create/Read/Update/Delete | A | 1 | |||||
| CRY | Country | CRY | [TCY]TCY0=[CNTXT]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTY | City | CTY | ||||||
| DPO | Data protection | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FAX | Fax | TEL | ||||||
| IDXTREM | Technical field | DCO | ||||||
| IMPSEQ | Sequence | L | 8 | |||||
| MOB | Mobile phone | TEL | ||||||
| RDEPITNUM | Residence permit | A | 10 | KMA | ||||
| SAT | County | SAT | ||||||
| SSCNUM | Soc. security fund | DCB | 19.8 | KMA | ||||
| TEL | Telephone | TEL | ||||||
| UIDCRDNUM | ID card number | A | 10 | KMA | ||||
| UIDSES | Session | L | 8 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[CNTXT]UPDUSR | Other | ||||
| WEB | MAI | |||||||
| ZIP | Postal code | POS |