Table MARDEFVAL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MARDEFVAL | MDV | Criteria details | CRM activities |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MDV0 | MARSCTNUM+CRINUM | Yes | |
| MDV1 | MARSCTNUM+CRINUM+SCTVALNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[MDV]CREUSR | Other | ||||
| CRINUM | No. of criteria | L | 8 | |||||
| MARSCTNUM | Sector code | VCR | ||||||
| MARSCTVAL | Value | A | 35 | |||||
| MARVALDAT | Internal date value | D | ||||||
| SCTVALNUM | No. of value | C | 4 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[MDV]UPDUSR | Other |