Table CORRESPOND
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CORRESPOND | COR | Outlook contact | CRM activities |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| COR0 | CORNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BIR | Date of birth | D | ||||||
| BPRLIB | Company description | CLX | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[COR]BPRNUM | Other | ||||
| CNTNUM | Code | AIN | [AIN]AIN0=[COR]CNTNUM | Delete | ||||
| CORNUM | Sequence no. | VCR | ||||||
| CORTYP | Type | AOB | [AOB]ABREV=[COR]CORTYP | Block | ||||
| CPYADD | Address | 3 | ADL | |||||
| CPYBPADES | Description | DES | ||||||
| CPYBPANUM | Code | ADR | ||||||
| CPYBPATYP | Entity type | M | 15 | 943 | ||||
| CPYCRY | Country | CRY | [TCY]TCY0=[COR]CPYCRY | Block | ||||
| CPYCRYNAM | Country name | NCY | ||||||
| CPYCTY | City | CTY | ||||||
| CPYEML | MAI | |||||||
| CPYFAX | Fax | TEL | ||||||
| CPYMOB | Mobile phone | TEL | ||||||
| CPYSAT | County | SAT | ||||||
| CPYTEL | Telephone | TEL | ||||||
| CPYZIP | Postal code | POS | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CSP | Category | ADI | [ADI]CODE=907;CSP | Block | ||||
| FNA | First name | FNA | ||||||
| FNC | Function | M | 15 | 233 | ||||
| FNCLIB | Function description | A | 50 | |||||
| HOMADD | Address | 3 | ADL | |||||
| HOMCRY | Country | CRY | [TCY]TCY0=[COR]HOMCRY | Block | ||||
| HOMCRYNAM | Country name | NCY | ||||||
| HOMCTY | City | CTY | ||||||
| HOMEML | MAI | |||||||
| HOMFAX | Fax | TEL | ||||||
| HOMMOB | Mobile phone | TEL | ||||||
| HOMSAT | County | SAT | ||||||
| HOMTEL | Telephone | TEL | ||||||
| HOMZIP | Postal code | POS | ||||||
| LAN | Language | LAN | [TLA]TLA0=[COR]LAN | Block | ||||
| LNA | Last name | NAM | ||||||
| MSS | Role | ADI | [ADI]CODE=414;MSS | Block | ||||
| SRV | Department | DES | ||||||
| TTL | Title | M | 15 | 941 | ||||
| TTR | Title | DES | ||||||
| UPDBPRNUM | Change BP code | C | 1 | |||||
| UPDCNTNUM | Change inter code | C | 1 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |