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 |