Table PITCOUNT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PITCOUNT | PCT | Point counter | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PCT0 | SRENUM+TPYFLG+FGVCAH+BPC+MAC+PBL+HDT+HDTSEQ | No | |
| PCT1 | CONNUM | Yes | |
| PCT2 | LOO | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPC | Customer | BPR | [BPR]BPR0=[PCT]BPC | RTZ | ||||
| CONNUM | Service contract | CON | [CON]CON0=[PCT]CONNUM | RTZ | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| FGVCAH | Cancel cache | C | 1 | |||||
| HDT | Consumptions | VCR | ||||||
| HDTSEQ | Consumptions | VCR | ||||||
| LOO | Loop | A | 100 | |||||
| MAC | Base | MAC | [MAC]MAC0=[PCT]MAC | RTZ | ||||
| PBL | Skill | PBL | [PBL]PBL0=[PCT]PBL | RTZ | ||||
| PIT | Points | L | 8 | |||||
| PITTYP | Point type | M | 15 | 3017 | ||||
| SAT | Point status | M | 15 | 3013 | ||||
| SRENUM | Service request | VCR | ||||||
| TPYFLG | Temp record | C | 1 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PCT]UPDUSR | Other |