Table PHONECALL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PHONECALL | CLL | Call | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CLL0 | CLLNUM | No | |
| CLL1 | CLLDATX | Yes | |
| CLL2 | CLLCMP | Yes | |
| CLL3 | CLLCCN | Yes | |
| CLL4 | CLLREP+CLLDATX | Yes | |
| CLL5 | CLLCMGNUM | Yes | |
| CLL6 | CLLOPGTYP+CLLOPGNUM | Yes | |
| CLL7 | CLLORIADI+CLLORIVCR+CLLORIVCRL | Yes | |
| CLL8 | CLLDAT+CLLHOU+CLLNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CLLCAT | Category | ADI | [ADI]CODE=432;CLLCAT | Block | ||||
| CLLCCN | Contact (relationship) | AIN | [AIN]AIN0=[CLL]CLLCCN | Block | ||||
| CLLCCNCRY | Contact country | CRY | [TCY]TCY0=[CLL]CLLCCNCRY | Block | ||||
| CLLCMGFLG | Call campaign flag | C | 2 | |||||
| CLLCMGNUM | Campaign code | CMG | [CMG]CMG0=[CLL]CLLCMGNUM | Block | ||||
| CLLCMP | BP | BPR | [BPR]BPR0=[CLL]CLLCMP | Block | ||||
| CLLCOR | Outlook contact | COR | [COR]COR0=[CLL]CLLCOR | Block | ||||
| CLLDAT | Date | D | ||||||
| CLLDATX | Week conversion | D | ||||||
| CLLDON | Completed | M | 4 | 1 | ||||
| CLLDUR | Duration | C | 4 | |||||
| CLLEML | MAI | |||||||
| CLLETS | Direct line | TEL | ||||||
| CLLHOU | Time | HM | ||||||
| CLLMOB | Mobile phone | TEL | ||||||
| CLLNUM | Call time | VCR | ||||||
| CLLOBJ | Subject summary | CLX | ||||||
| CLLOPGNUM | Operation code | VCR | ||||||
| CLLOPGTYP | Operation type | AOB | [AOB]ABREV=[CLL]CLLOPGTYP | Block | ||||
| CLLOPP | Project | PJT | [PIM]PIM0=[CLL]CLLOPP | Block | ||||
| CLLORI | Source | M | 15 | 2993 | ||||
| CLLORIADI | Source | ADI | [ADI]CODE=439;CLLORIADI | Block | ||||
| CLLORIAOB | Object code | AOB | [AOB]ABREV=[CLL]CLLORIAOB | Block | ||||
| CLLORITYP | Source type | M | 15 | 3037 | ||||
| CLLORIVCR | Original document no. | VCR | ||||||
| CLLORIVCRL | Original line no. | L | 8 | |||||
| CLLPIOLEV | Priority level | ADI | [ADI]CODE=405;CLLPIOLEV | Block | ||||
| CLLREP | Sales rep | REP | [REP]REP0=[CLL]CLLREP | Block | ||||
| CLLRPO | Report | CLX | ||||||
| CLLSAO | Satisfaction | ADI | [ADI]CODE=436;CLLSAO | Block | ||||
| CLLSCP | Call script | SCP | [SCP]SCP0=[CLL]CLLSCP | Block | ||||
| CLLTNTPRE | Prev attempts | C | 4 | |||||
| CLLTYP | Type | M | 956 | |||||
| CLLWEE | Week | C | 4 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREHOU | Creation time | HM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| NUMFULOBJ | Chrono txt file | CLC | ||||||
| NUMFULRPO | Chrono txt file | CLC | ||||||
| OBJFLG | Flag text file | C | 2 | |||||
| RPOFLG | Flag text file | C | 2 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[CLL]SALFCY | Block | ||||
| TYPFULOBJ | Type text file | CLT | ||||||
| TYPFULRPO | Type text file | CLT | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |