Table SALESREP
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SALESREP | REP | Sales rep | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
REP0 | REPNUM | No | |
REP1 | AUSNUM | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCCOD | Accounting code | CAC | [CAC]CAC0=4;ACCCOD;[V]GSUPCLE | Block | ||||
AUSNUM | User code | AUS | [AUS]CODUSR=[REP]AUSNUM | RTZ | ||||
AUUID | Single identifier | AUUID | ||||||
BPAADD | Default address | ADR | ||||||
CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
CFY | Company | CPY | [CPY]CPY0=[REP]CFY | Other | MUL | |||
CLLDEL | No. of late calls | L | 8 | |||||
COMBAS | Commission base | M | 15 | 405 | ||||
COMFOR1 | Commission formula 1 | FOR | [TFO]TFO0=3;COMFOR1 | Block | ||||
COMFOR2 | Commission formula 2 | FOR | [TFO]TFO0=3;COMFOR2 | Block | ||||
COMRAT1 | Commission rate 1 | RAT | COM | |||||
COMRAT2 | Commission rate 2 | RAT | COM | |||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CUR | Currency | CUR | [TCU]TCU0=[REP]CUR | Block | ||||
DIE | Dimension type code | DIE | [DIE]DIE0=[REP]DIE | Block | ANA | |||
EXPNUM | Export number | L | 8 | |||||
FCY | Sales site | FCY | [FCY]FCY0=[REP]FCY | Block | ||||
NSE | No. of reschedules | L | 8 | |||||
OBJCLL | Call objective | L | 8 | |||||
REPNAM | Last name | NAM | ||||||
REPNUM | Sales rep | BPR | [BPR]BPR0=[REP]REPNUM | Block | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |