Table TASK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TASK | TSK | Task | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TSK0 | TSKNUM | No | |
| TSK1 | TSKDAT+TSKNUM | No | |
| TSK2 | TSKCMP | Yes | |
| TSK3 | TSKCCN | Yes | |
| TSK4 | TSKREP+TSKDAT+TSKNUM | No | |
| TSK5 | CREUSR | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREHOU | Creation time | HM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| HOUTIMSPG | Time spent (hours) | L | 8 | |||||
| MNTTIMSPG | Time passed (minute) | C | 2 | |||||
| NUMFULOBJ | Chrono txt file | CLC | ||||||
| NUMFULRPO | Chrono txt file | CLC | ||||||
| OBJFLG | Flag text file | C | 2 | |||||
| RPOFLG | Flag text file | C | 2 | |||||
| SALFCY | Site | FCY | [FCY]FCY0=[TSK]SALFCY | Block | ||||
| TSKCCN | Contact (relationship) | AIN | [AIN]AIN0=[TSK]TSKCCN | Block | ||||
| TSKCMGNUM | Marketing campaign | CMG | [CMG]CMG0=[TSK]TSKCMGNUM | Block | ||||
| TSKCMP | BP | BPR | [BPR]BPR0=[TSK]TSKCMP | Block | ||||
| TSKCOR | Outlook contact | COR | [COR]COR0=[TSK]TSKCOR | Block | ||||
| TSKDAT | Due date | D | ||||||
| TSKDEL | Late | C | 4 | |||||
| TSKDES | Description | CLX | ||||||
| TSKDON | Completed | M | 4 | 1 | ||||
| TSKNUM | Task chrono | VCR | ||||||
| TSKOPGNUM | Marketing operation | VCR | ||||||
| TSKOPGTYP | Operation type | AOB | [AOB]ABREV=[TSK]TSKOPGTYP | Block | ||||
| TSKORI | Source | M | 15 | 2992 | ||||
| TSKORIADI | Source | ADI | [ADI]CODE=439;TSKORIADI | Block | ||||
| TSKORIAOB | Object code | AOB | [AOB]ABREV=[TSK]TSKORIAOB | Block | ||||
| TSKORITYP | Source type | M | 15 | 3037 | ||||
| TSKORIVCR | Original document no. | VCR | ||||||
| TSKORIVCRL | Original line no. | L | 8 | |||||
| TSKPIOLEV | Priority level | ADI | [ADI]CODE=405;TSKPIOLEV | Block | ||||
| TSKPJT | Project | PJT | [PIM]PIM0=[TSK]TSKPJT | Block | ||||
| TSKREP | Sales rep | REP | [REP]REP0=[TSK]TSKREP | Block | ||||
| TSKRPO | Report | CLX | ||||||
| TSKSAO | Satisfaction | ADI | [ADI]CODE=435;TSKSAO | Block | ||||
| TSKSTR | Start date | D | ||||||
| TSKTYP | Category | ADI | [ADI]CODE=431;TSKTYP | Block | ||||
| TYPFULOBJ | Type text file | CLT | ||||||
| TYPFULRPO | Type text file | CLT | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |