Module List >
Module UPR tables
UPR10103
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR10103 Table Definition
(COMPANY..Payroll Year End Pension)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|