Table TIMEMP
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TIMEMP | TIP | Tracked times | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TIP0 | LIG | No | |
| TIP1 | REFNUM+STRDAT+LIG | No | |
| TIP2 | REFNUM+DATPYR+STRDAT+LIG | No | |
| TIP3 | REFNUM+DATPYR+STRDAT+STRTIM+LIG | No | TPS |
| TIP4 | REFNUM+STRDAT+STRTIM+LIG | No | TPS |
| TIP5 | REFNUM+CTRNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ANAFLG | Ana flag | C | 1 | TPS | ||||
| AUTFLG | Automatic | M | 4 | 1 | TPS | |||
| AUUID | Single identifier | AUUID | ||||||
| BPCNUM | Customer | BPR | SRV | |||||
| BRKTIM | Rest break | DCB | 2.2 | TPS | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Other | ANA | |||
| CMT | Comment | CMT | ||||||
| CPY | Company | CPY | [CPY]CPY0=[TIP]CPY | Delete | SRV | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTRDAT | Date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| DATBUL | Pay date | D | ||||||
| DATPYR | Pay date | D | ||||||
| DAYNGT | Day/night | M | 15 | 402 | TPS | |||
| DCGUID | Line identifier | L | 8 | |||||
| DIE | Dim type code | DIE | [DIE]DIE0=[TIP]DIE | Block | ANA | |||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Block | TPS | |||
| ENDDAT | End date | D | ||||||
| ENDDAY | Half-day | M | 4 | 1 | ||||
| ENDTIM | End time | HM | TPS | |||||
| EXPNUM | Export number | L | 8 | |||||
| FCY | Site | FCY | [FCY]FCY0=[TIP]FCY | Block | ||||
| FLD1 | Alpha field 1 | A | 15 | TPS | ||||
| FLD2 | Alpha field 2 | A | 15 | TPS | ||||
| FLGBUL | To take | M | 4 | 1 | ||||
| INVFLG | Invoiceable | M | 4 | 1 | SRV | |||
| LIG | Line | L | 8 | |||||
| NATCOD | Nature of activity | NAT | [NAT]NAT0=[TIP]NATCOD | Block | TPS | |||
| NBRDAY | Days | NDY | ||||||
| NBRHOU | Hours | NDY | ||||||
| QTY1 | First quantity | DCB | 9.2 | TPS | ||||
| QTY2 | Second quantity | DCB | 9.2 | TPS | ||||
| REFNUM | Employee ID | MAT | [ID]ID0=[TIP]REFNUM | Block | ||||
| SOHLIG | Line | L | 6 | SRV | ||||
| SOHNUM | Order | VCR | SRV | |||||
| SRV | Department | SRV | [SRV]SRV0=[TIP]SRV | Block | TPS | |||
| STA | Status | C | 2 | TPS | ||||
| STAFLG | Signature | AUS | [AUS]CODUSR=[TIP]STAFLG | Other | TPS | |||
| STRDAT | Start date | D | ||||||
| STRDAY | Half-day | M | 4 | 1 | ||||
| STRTIM | Start time | HM | TPS | |||||
| TIM | Nature of events | TPS | [TIM]TIM0=[TIP]TIM | Block | ||||
| TYPDAY | Day type | M | 15 | 413 | TPS | |||
| TYPPGN | Leave type | M | 4 | 2408 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |