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 |