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

COMPANY..UPR10101 Table Definition

(COMPANY..Payroll Year End Wage)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RPTNGYR smallint
0

MCRQGEMP tinyint
0
Medicare Q...(more) Join Now
DEPRTMNT char(7)
''
Department...(more) Join Now
join ... more text available
LASTNAME char(21)
''
Last Name:...(more) Join Now
FRSTNAME char(15)
''
First Name...(more) Join Now UPR00100.FRSTNAME
MIDLNAME char(15)
''

SEQNUMBR int
0
Sequence N...(more) Join Now DTA10200.SEQNUMBR
ADDRESS1 char(61)
''

ADDRESS2 char(61)
''

ADDRESS3 char(61)
''

CITY char(35)
''
City: City...(more) Join Now
STATE char(29)
''

ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
Foreign_Address tinyint
0
Foreign Ad...(more) Join Now
Foreign_StateProvince char(23)
''
Foreign ...(more) Join Now
Foreign_Postal_Code char(15)
''
Foreign Po...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
W2CTRNBR char(7)
''

EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
SOCSCNUM char(15)
''

W2BFSTEM tinyint
0
W2 Box for...(more) Join Now
W2BFDCSD tinyint
0
W2 Box for...(more) Join Now
W2BFPPLN tinyint
0
W2 Box for...(more) Join Now
W2BFLREP tinyint
0
W2 Box for...(more) Join Now
W2BF942E tinyint
0
W2 Box for...(more) Join Now
W2BFSTTL char(1)
''

W2BFDCMP tinyint
0
W2 Box for...(more) Join Now
WGTPCOMP numeric(19,5)
0.00

FEDITXWH numeric(19,5)
0.00

SSECWAGS numeric(19,5)
0.00

SSTXWHLD numeric(19,5)
0.00

MCRWGTPS numeric(19,5)
0.00

MDCRTXWH numeric(19,5)
0.00

SSECTIPS numeric(19,5)
0.00

ALOCTIPS numeric(19,5)
0.00

ADEICPMT numeric(19,5)
0.00

DEPCRBFT numeric(19,5)
0.00

NQLFPLNS numeric(19,5)
0.00

BNINCWGS numeric(19,5)
0.00

W2FRMCTR int
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
STRINGARRAY_1 char(31)
''

STRINGARRAY_2 char(31)
''

STRINGARRAY_3 char(31)
''

STRINGARRAY_4 char(31)
''

STRINGARRAY_5 char(31)
''

LONGINTARRAY_1 int
0

LONGINTARRAY_2 int
0

LONGINTARRAY_3 int
0

LONGINTARRAY_4 int
0

LONGINTARRAY_5 int
0

EMPLSUFF char(5)
''

ESSW2PRINTED tinyint
0

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