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

COMPANY..UPR10103 Table Definition

(COMPANY..Payroll Year End Pension)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RPTNGYR smallint
0

LASTNAME char(21)
''
Last Name:...(more) Join Now
FRSTNAME char(15)
''
First Name...(more) Join Now UPR00100.FRSTNAME
MIDLNAME char(15)
''

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
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
SOCSCNUM char(15)
''

DEPRTMNT char(7)
''
Department...(more) Join Now
join ... more text available
GROSDIST numeric(19,5)
0.00

TXBAMNDT tinyint
0

TAMD1099 numeric(19,5)
0.00

TOTDSTCB tinyint
0

CAPTLGAIN numeric(19,5)
0.00

FEDITXWH numeric(19,5)
0.00

EMPLECTR numeric(19,5)
0.00

NTREALAP numeric(19,5)
0.00

DSTCODE1 char(1)
''

DSTCODE2 char(1)
''

DSTCODE3 char(1)
''

IRASEPCB tinyint
0

OTAM1099 numeric(19,5)
0.00

OTPC1099 numeric(19,5)
0.00

TTLTDSTPC numeric(19,5)
0.00

STATWGS1 numeric(19,5)
0.00

STATWGS2 numeric(19,5)
0.00

STAINTX1 numeric(19,5)
0.00

STAINTX2 numeric(19,5)
0.00

STATECD1 char(3)
''

STATECD2 char(3)
''

ESTIDNR1 char(21)
''

ESTIDBR2 char(21)
''

LCLWGES1 numeric(19,5)
0.00

LCLWGS2 numeric(19,5)
0.00

LCLINTX1 numeric(19,5)
0.00

LCLINTX2 numeric(19,5)
0.00

LCLCODE1 char(7)
''

LCLCODE2 char(7)
''

Y1099RFC int
0

EMPLSUFF char(5)
''

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