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 |