Module List > Module UPR tables UPR30501
You are currently viewing the COMPANY database.
Change

COMPANY..UPR30501 Table Definition

(COMPANY..uprTmcdDtlHIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
Pay_Schedule char
''

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
PERIODID smallint
0

TRXNUMBER int
0

TRXDATE datetime
'1/1/1900'

PayCode char
''

UNTSTOPY numeric
0.00
Units to p...(more) Join Now
DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
JOBTITLE char
''

STATECD char
''
State Code...(more) Join Now PA11801.STATECD
LOCALTAX char
''

SHFTCODE char
''
Shift Code...(more) Join Now
DAYSWRDK int
0

WKSWRKD int
0

SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
CMMTTEXT text


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