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 |