Table CONTREW
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
CONTREW | CRE | Contract renewals | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
CRE1 | CONNUM+REWRECNUMX | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
CONNUM | Contract code | CON | [CON]CON0=[CRE]CONNUM | RTZ | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[CRE]CREUSR | Other | ||||
INVNUM | Invoice no. | VCR | ||||||
PRONUMINV | Process number | L | 8 | |||||
REWEND | End | D | ||||||
REWMAN | Manual renew. | C | 2 | |||||
REWRECNUMX | Number | L | 8 | |||||
REWSTR | Start | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[CRE]UPDUSR | Other |