Module List > Module HRM tables APR10101
You are currently viewing the COMPANY database.
Change

COMPANY..APR10101 Table Definition

(COMPANY..APR Transaction Import Errors)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
COMPTRNM int
0

BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
COMPTRTP smallint
0

UPRTRXCD char(7)
''

TRXBEGDT datetime
'1/1/1900'

TRXENDDT datetime
'1/1/1900'

TRXHRUNT int
0

DAYSWRDK int
0

WKSWRKD int
0

INTERID char(5)
''

DEPRTMNT char(7)
''
Department...(more) Join Now TATX1030.DEPRTMNT
join ... more text available
JOBTITLE char(7)
''
Job Title:...(more) Join Now TATX1030.JOBTITLE
LOCATNID char(15)
''
Location I...(more) Join Now PA01101.LOCATNID
join ... more text available
SHFTCODE char(7)
''
Shift Code...(more) Join Now UPR00400.SHFTCODE
STATECD char(3)
''
State Code...(more) Join Now UPR00300.STATECD
SUTASTAT char(3)
''
Suta State...(more) Join Now UPR00400.SUTASTAT
PAYRTAMT numeric(19,5)
0
Pay Rate A...(more) Join Now UPR40600.PAYRTAMT
ERMSGTXT char(255)
''

MKTOPROC tinyint
0

APR_Import_Group char(15)
''

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