Table SERREQUEST
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SERREQUEST | SRE | Service requests | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
SRE0 | SRENUM | No | |
SRE1 | CREDAT | Yes | |
SRE2 | CREDAT+SRENUM | No | |
SRE3 | SREBPC | Yes | |
SRE4 | SRECCN | Yes | |
SRE5 | SREBPC+SRENUMBPC | Yes | |
SRE6 | SOLNUM | Yes | |
SRE7 | SREORI+SREORIVCR+SREORIVCRL | Yes | |
SRE8 | SRERESDAT+SRERESHOU+SREASS+SRENUM | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
CONSPT | Support contract | CON | [CON]CON0=[SRE]CONSPT | Block | ||||
CONSPTFLG | Support contract flg | C | 1 | |||||
CONSPTTYP | Contract type | AOB | [AOB]ABREV=[SRE]CONSPTTYP | Block | ||||
COVAUSCLA | Covered by | A | 30 | |||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREHOU | Creation time | HM | ||||||
CREUSR | Creation user | A | 5 | |||||
CTIMSPGDAY | Cumul (days) | L | 8 | |||||
CTIMSPGHOU | Cumul (hours) | L | 8 | |||||
CTIMSPGMNT | Cumul (minutes) | L | 8 | |||||
DIE | Dimension type code | DIE | [DIE]DIE0=[SRE]DIE | Block | ANA | |||
ENTCOD | Stock auto journal | GAU | [GAU]GAU0=[SRE]ENTCOD | Block | ||||
INVDTA | Invoicing element | SFI | [SFI]SFI0=[SRE]INVDTA | Other | SFI | |||
INVDTAAMT | % or amt inv el | DCB | 11.4 | SFI | ||||
INVDTATYP | Value type | M | 6 | 2227 | SFI | |||
MACFLT | Base filter | MAC | [MAC]MAC0=[SRE]MACFLT | Block | ||||
MACFLTINT | Customer filter | M | 4 | 1 | ||||
MANUPD | Modify resolution | M | 4 | 1 | ||||
NBRMANUPD | No. manual modifs | L | 8 | |||||
NUMFULDES | Description chrono | CLC | ||||||
OVRCOV | Global coverage | M | 15 | 3003 | ||||
OVRCOVREN | Non-coverage reason | C | 4 | |||||
OVRCOVTYP | Contract type | AOB | [AOB]ABREV=[SRE]OVRCOVTYP | Block | ||||
REP | Sales rep | A | 5 | |||||
SALFCY | Site | FCY | [FCY]FCY0=[SRE]SALFCY | Block | ||||
SFISSTCOD | SST tax code | ADI | [ADI]CODE=203;SFISSTCOD | Block | SFI | |||
SOLNUM | Solution code | SOL | [SOL]SOL0=[SRE]SOLNUM | Block | ||||
SREASS | Assignment | M | 15 | 975 | ||||
SREBPAADD | Address | ADR | ||||||
SREBPC | Customer | BPR | [BPR]BPR0=[SRE]SREBPC | Block | ||||
SREBPCGRU | Group customer | BPR | [BPR]BPR0=[SRE]SREBPCGRU | Block | ||||
SREBPCINV | Bill-to customer | BPR | [BPR]BPR0=[SRE]SREBPCINV | Block | ||||
SREBPCPYR | Pay-by | BPR | [BPR]BPR0=[SRE]SREBPCPYR | Block | ||||
SRECCN | Contact (relationship) | AIN | [AIN]AIN0=[SRE]SRECCN | Block | ||||
SRECHGTYP | Rate type | M | 15 | 202 | ||||
SRECOV | Covered | M | 4 | 1 | ||||
SRECOVAUS | Covered by | A | 5 | |||||
SRECOVAUT | Auto cover | C | 4 | |||||
SRECOVCTL | To control by | A | 5 | |||||
SRECOVNUM | Coverage reference | VCR | ||||||
SRECUR | Currency | CUR | [TCU]TCU0=[SRE]SRECUR | Block | ||||
SREDATASS | Assignment date | D | ||||||
SREDEP | Settlement discount | TDA | [TDA]TDA0=SREDEP;[V]GSUPCLE | Block | ||||
SREDES | Overview | CLX | ||||||
SREDESFLG | Overview written | C | 2 | |||||
SREDET | Assignment detail | VCR | ||||||
SREDOO | Service caller | BPR | [BPR]BPR0=[SRE]SREDOO | Block | ||||
SREESC | No. of escalations | C | 4 | |||||
SREESC2 | Historized escalation | C | 4 | |||||
SREESC3 | Incremental escaln | C | 4 | |||||
SREGRALEV | Severity level | ADI | [ADI]CODE=428;SREGRALEV | Block | ||||
SREHOUASS | Time | HM | ||||||
SREINUMBPC | Customer no. chrono | L | 8 | |||||
SREINVFLG | Invoicing flag | M | 15 | 3004 | ||||
SRELOK | Blocking gravity | M | 4 | 1 | ||||
SREMAC | Base by default | MAC | [MAC]MAC0=[SRE]SREMAC | Block | ||||
SREMACPBL | Skills base/default | PBL | [PBL]PBL0=[SRE]SREMACPBL | Block | ||||
SRENUM | Sequence no. | VCR | ||||||
SRENUMBPC | Customer request | VCR | ||||||
SREORI | Source | M | 20 | 2982 | ||||
SREORIVCR | Original document no. | VCR | ||||||
SREORIVCRL | Source document line | L | 8 | |||||
SREPBLGRP | Skill | PBL | [PBL]PBL0=[SRE]SREPBLGRP | Block | ||||
SREPIOLEV | Level of urgency | ADI | [ADI]CODE=405;SREPIOLEV | Block | ||||
SREPJT | Project | PJT | [PIM]PIM0=[SRE]SREPJT | Block | ||||
SREPRITYP | Price type | M | 6 | 243 | ||||
SREPTE | Payment terms | PTE | [TPT]TPT0=SREPTE;[V]GCURLEG;1 | Block | ||||
SREREP | Sales rep | REP | [REP]REP0=[SRE]SREREP | Block | REC | |||
SRERESDAT | Desired resolution | D | ||||||
SRERESHOU | Desired resolution | HM | ||||||
SRERESREN | Reason | A | 80 | |||||
SRESAT | Request status | ADI | [ADI]CODE=422;SRESAT | Block | ||||
SRETIMSPG | Total time spent | C | 4 | |||||
SRETPL | Request model | VCR | ||||||
SRETTR | Title | A | 80 | |||||
SRETYPCOV | Coverage type | M | 25 | 974 | ||||
SREVACBPR | Tax rule | TVB | [TVB]TVB0=SREVACBPR;[V]GSUPCLE | RTZ | ||||
SSTENTCOD | Entity/Use | ADI | [ADI]CODE=202;SSTENTCOD | Block | LTA | |||
STOFCY | Storage site | FCY | [FCY]FCY0=[SRE]STOFCY | Block | ||||
TIMSPGDAY | Time passed (days) | L | 8 | |||||
TIMSPGHOU | Time spent (hours) | L | 8 | |||||
TIMSPGMNT | Time passed (minute) | L | 8 | |||||
TRSCOD | Movement code | ADI | [ADI]CODE=14;TRSCOD | Block | ||||
TRSFAM | Transaction group | ADI | [ADI]CODE=9;TRSFAM | Block | ||||
TSDCOD | Statistical group | ADI | [ADI]CODE=indice+445;TSDCOD(indice) | Block | STR | |||
TSKREPCRE | Sales rep task created | M | 4 | 1 | ||||
TYPFULDES | Description type | CLT | ||||||
TYPMAC | Base type | M | 15 | 2983 | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |