Table MARASSREP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MARASSREP | MAR | Representative portfolio | CRM activities |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MAR0 | RECORDNUM+RECORDADD+RECORDTYP | Yes | |
| MAR1 | RECORDNUM+RECORDTYP | Yes | |
| MAR2 | RECORDNUM+RECORDADD+RECORDTYP+REPTYP | Yes | |
| MAR3 | RECORDNUM+RECORDTYP+REPTYP | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[MAR]CREUSR | Other | ||||
| MANASS | Manually allocated | C | 4 | |||||
| RECORDADD | Address code | ADR | ||||||
| RECORDNUM | Record key | VCR | ||||||
| RECORDTYP | Record type | ABR | ||||||
| REPITM | Product group | ADI | [ADI]CODE=1+GFAMCIA;REPITM | Block | ||||
| REPMSS | Role | ADI | [ADI]CODE=414;REPMSS | Block | ||||
| REPNUM | Sales rep | REP | [REP]REP0=[MAR]REPNUM | Block | ||||
| REPTYP | Representative type | C | 4 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[MAR]UPDUSR | Other |