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

COMPANY..UPR30301 Table Definition

(COMPANY..Payroll Transaction History Header)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
YEAR1 smallint
0
Year: The ...(more) Join Now
PYRLRTYP smallint
0
1 = Regula...(more) Join Now
PAYROLCD char(7)
''

MTDWAGES_1 numeric(19,5)
0.00

MTDWAGES_2 numeric(19,5)
0.00

MTDWAGES_3 numeric(19,5)
0.00

MTDWAGES_4 numeric(19,5)
0.00

MTDWAGES_5 numeric(19,5)
0.00

MTDWAGES_6 numeric(19,5)
0.00

MTDWAGES_7 numeric(19,5)
0.00

MTDWAGES_8 numeric(19,5)
0.00

MTDWAGES_9 numeric(19,5)
0.00

MTDWAGES_10 numeric(19,5)
0.00

MTDWAGES_11 numeric(19,5)
0.00

MTDWAGES_12 numeric(19,5)
0.00

MTDHOURS_1 int
0

MTDHOURS_2 int
0

MTDHOURS_3 int
0

MTDHOURS_4 int
0

MTDHOURS_5 int
0

MTDHOURS_6 int
0

MTDHOURS_7 int
0

MTDHOURS_8 int
0

MTDHOURS_9 int
0

MTDHOURS_10 int
0

MTDHOURS_11 int
0

MTDHOURS_12 int
0

STXBLWGS_1 numeric(19,5)
0.00

STXBLWGS_2 numeric(19,5)
0.00

STXBLWGS_3 numeric(19,5)
0.00

STXBLWGS_4 numeric(19,5)
0.00

STXBLWGS_5 numeric(19,5)
0.00

STXBLWGS_6 numeric(19,5)
0.00

STXBLWGS_7 numeric(19,5)
0.00

STXBLWGS_8 numeric(19,5)
0.00

STXBLWGS_9 numeric(19,5)
0.00

STXBLWGS_10 numeric(19,5)
0.00

STXBLWGS_11 numeric(19,5)
0.00

STXBLWGS_12 numeric(19,5)
0.00

LCTXBLWG_1 numeric(19,5)
0.00

LCTXBLWG_2 numeric(19,5)
0.00

LCTXBLWG_3 numeric(19,5)
0.00

LCTXBLWG_4 numeric(19,5)
0.00

LCTXBLWG_5 numeric(19,5)
0.00

LCTXBLWG_6 numeric(19,5)
0.00

LCTXBLWG_7 numeric(19,5)
0.00

LCTXBLWG_8 numeric(19,5)
0.00

LCTXBLWG_9 numeric(19,5)
0.00

LCTXBLWG_10 numeric(19,5)
0.00

LCTXBLWG_11 numeric(19,5)
0.00

LCTXBLWG_12 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