Table DEMCONGE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| DEMCONGE | DCG | Holiday requests | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DCG0 | REFNUM | Yes | |
| DCG1 | REFNUM+STA+TIM | Yes | |
| DCG2 | UID | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CHRONO | Sequence no. | VCR | ||||||
| CHRONO2 | Deletion chrono | VCR | ||||||
| CMT | Comment | CMT | ||||||
| CMT2 | Acknowledgement comment | CMT | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Contract | CTR | ||||||
| DEM | Request no. | L | 8 | |||||
| ENDDAT | End date | D | ||||||
| ENDDAY | Leave end | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| LNK | Link | L | 8 | |||||
| NBRDAY | Days | NDY | ||||||
| NBRHOU | Hours | NDY | ||||||
| REFNUM | Employee ID | MAT | [ID]ID0=REFNUM | Delete | ||||
| RPL | Substitute | MAT | [ID]ID0=RPL | RTZ | ||||
| STA | Tracking | M | 15 | 743 | ||||
| STRDAT | Start date | D | ||||||
| STRDAY | Leave start | M | 4 | 1 | ||||
| TIM | Nature of events | TPS | [TIM]TIM0=[DCG]TIM | Block | ||||
| TYPPGN | Leave type | M | 15 | 2408 | ||||
| UID | Identifier | L | 8 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDNUM | Fee | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| WEBSRV | Web service | M | 10 | 1 | ||||
| WRK | Workflow | A | 1 |