Table
|
Abbreviation
|
Description
|
Module
|
Activity code
|
TABMAT
|
TMA
|
ID numbers
|
Common Data
|
|
Key
|
Description
|
Duplicates
|
Activity code
|
TMA0
|
EMPNUM
|
No
|
|
TMA1
|
USR
|
Yes
|
|
Column
|
Normal title
|
Dim.
|
Type
|
Length
|
Menu
|
Link expression
|
Cancellation
|
Act
|
ACTDAT
|
Active date
|
|
D
|
|
|
|
|
|
AUUID
|
Single identifier
|
|
AUUID
|
|
|
|
|
|
CHGRAT
|
Labor rate
|
|
DCB
|
12
|
|
|
|
|
CREDAT
|
Date created
|
|
D
|
|
|
|
|
|
CREDATTIM
|
Date time
|
|
ADATIM
|
|
|
|
|
|
CREUSR
|
Creation user
|
|
A
|
5
|
|
|
|
|
DEFFCY
|
Site
|
|
FCY
|
|
|
[FCY]FCY0=[TMA]DEFFCY
|
Block
|
|
DEFWCR
|
Work center group
|
|
WCR
|
|
|
[TWC]TWC0=[TMA]DEFWCR
|
Block
|
|
DEFWST
|
Work center
|
|
WST
|
|
|
|
|
|
ELPFLG
|
Elapsed labor
|
|
M
|
4
|
1
|
|
|
|
EMPDES
|
Description
|
|
DES
|
|
|
|
|
|
EMPNUM
|
Employee ID
|
|
EPN
|
|
|
|
|
|
EMPSHO
|
Short description
|
|
SHO
|
|
|
|
|
|
EMPTYP
|
Employee type
|
|
M
|
15
|
2425
|
|
|
|
ENAFLG
|
Active
|
|
M
|
4
|
1
|
|
|
|
INACTDAT
|
Inactive date
|
|
D
|
|
|
|
|
|
SHIFT
|
Shift code
|
|
SHFT
|
|
|
[SFTS]SHF0=[TMA]SHIFT
|
Block
|
|
SUMEMP
|
Number of employees
|
|
L
|
8
|
|
|
|
|
UPDDAT
|
Change date
|
|
D
|
|
|
|
|
|
UPDDATTIM
|
Date time
|
|
ADATIM
|
|
|
|
|
|
UPDUSR
|
Change user
|
|
A
|
5
|
|
|
|
|
USR
|
User code
|
|
AUS
|
|
|
[AUS]CODUSR=[TMA]USR
|
Delete
|
|