Module List > Module HR tables AEU10130
You are currently viewing the COMPANY database.
Change

COMPANY..AEU10130 Table Definition

(COMPANY..Archive_HR_User_Defined)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MSEQUENCE_I smallint
0

EMPID_I char(15)
''
Employee I...(more) Join Now TATX1030.EMPID_I
MSTRING_I_1 char(31)
''

MSTRING_I_2 char(31)
''

MSTRING_I_3 char(31)
''

MSTRING_I_4 char(31)
''

MSTRING_I_5 char(31)
''

MLINT_I_1 int
0

MLINT_I_2 int
0

MLINT_I_3 int
0

MLINT_I_4 int
0

MLINT_I_5 int
0

MDLR_I_1 numeric(19,5)
0.00

MDLR_I_2 numeric(19,5)
0.00

MDLR_I_3 numeric(19,5)
0.00

MDLR_I_4 numeric(19,5)
0.00

MDLR_I_5 numeric(19,5)
0.00

MCHECK_I_1 tinyint
0

MCHECK_I_2 tinyint
0

MCHECK_I_3 tinyint
0

MCHECK_I_4 tinyint
0

MCHECK_I_5 tinyint
0

MCHECK_I_6 tinyint
0

MCHECK_I_7 tinyint
0

MCHECK_I_8 tinyint
0

MCHECK_I_9 tinyint
0

MCHECK_I_10 tinyint
0

MDATE1_I datetime
'1/1/1900'

MDATE2_I datetime
'1/1/1900'

MDATE3_I datetime
'1/1/1900'

MDATE4_I datetime
'1/1/1900'

MDATE5_I datetime
'1/1/1900'

MTIME_I_1 char(5)
''

MTIME_I_2 char(5)
''

MTIME_I_3 char(5)
''

MTIME_I_4 char(5)
''

MTIME_I_5 char(5)
''

NOTESINDEX_I numeric(19,5)
0.00

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3