| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| PYRNTYPE |
smallint
0
|
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| POSTED |
tinyint
0
|
Posted: S...(more) Join Now
|
RM10301.POSTED
|
|
|
| PYSTLTEX |
tinyint
0
|
|
|
|
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
Check Date...(more) Join Now
|
PM10000.CHEKDATE
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| PYADNMBR |
int
0
|
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| ADFDWHDG |
numeric(19,5)
0.00
|
|
|
|
|
| ESTFEDWH |
numeric(19,5)
0.00
|
Estimated ...(more) Join Now
|
|
|
|
| HWKVCACR |
numeric(19,5)
0.00
|
|
|
|
|
| HWKSKACR |
numeric(19,5)
0.00
|
|
|
|
|
| VACTMACC |
numeric(19,5)
0.00
|
|
|
|
|
| SKTMACCR |
numeric(19,5)
0.00
|
|
|
|
|
| VACTMLBL |
numeric(19,5)
0.00
|
|
|
|
|
| SKTMLBTY |
numeric(19,5)
0.00
|
|
|
|
|
| VACAVLBL |
int
0
|
Vacation A...(more) Join Now
|
UPR00100.VACAVLBL
|
|
|
| SIKTIMAV |
int
0
|
Sick Time ...(more) Join Now
|
UPR00100.SIKTIMAV
|
|
|
| GRWGPRN |
numeric(19,5)
0.00
|
|
|
|
|
| NTWPYRN |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_1 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_2 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_3 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_4 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_5 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_6 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_7 |
numeric(19,5)
0.00
|
|
|
|
|
| FEDWGARR_8 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_1 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_2 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_3 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_4 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_5 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_6 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_7 |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Tips_Array_8 |
numeric(19,5)
0.00
|
|
|
|
|
| FDWGPYRN |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_TipsPay_Run |
numeric(19,5)
0.00
|
|
|
|
|
| ANFDWHDG |
numeric(19,5)
0.00
|
|
|
|
|
| FDWDGPRN |
numeric(19,5)
0.00
|
Federal Wi...(more) Join Now
|
|
|
|
| FDTXTIPS |
numeric(19,5)
0.00
|
|
|
|
|
| FICASSWP |
numeric(19,5)
0.00
|
|
|
|
|
| FICASS_TipsPay_Run |
numeric(19,5)
0.00
|
|
|
|
|
| FCASWPR |
numeric(19,5)
0.00
|
|
|
|
|
| FICSTPTX |
numeric(19,5)
0.00
|
|
|
|
|
| Uncollected_FICASS_TaxP |
numeric(19,5)
0.00
|
|
|
|
|
| FICAMWGP |
numeric(19,5)
0.00
|
|
|
|
|
| FICAMed_TipsPay_Run |
numeric(19,5)
0.00
|
|
|
|
|
| FICAMWPR |
numeric(19,5)
0.00
|
|
|
|
|
| FICMTPTX |
numeric(19,5)
0.00
|
|
|
|
|
| Uncollected_FICAMed_TaxP |
numeric(19,5)
0.00
|
|
|
|
|
| EICWPYRN |
numeric(19,5)
0.00
|
|
|
|
|
| EPFICASS |
numeric(19,5)
0.00
|
|
|
|
|
| EFICAMCR |
numeric(19,5)
0.00
|
|
|
|
|
| Charged_Receipts |
numeric(19,5)
0.00
|
|
|
|
|
| Reported_Receipts |
numeric(19,5)
0.00
|
|
|
|
|
| Hours_Worked_For_Minimum |
numeric(19,5)
0.00
|
|
|
|
|
| Min_Wage_Bal_Applicable |
numeric(19,5)
0.00
|
|
|
|
|
| Reported_Tips |
numeric(19,5)
0.00
|
|
|
|
|
| Charged_Tips |
numeric(19,5)
0.00
|
|
|
|
|
| ALOCTIPS |
numeric(19,5)
0.00
|
|
|
|
|
| TipType |
smallint
0
|
Tip Type: ...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
RM10301.POSTEDDT
|
|
|
| GRWGFREIC |
numeric(19,5)
0.00
|
|
|
|
|
| CALCCHKERRS |
binary(4)
0
|
|
|
|
|
| EFICASSWH |
numeric
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| EFICASS_Tax_On_Tips |
numeric
0.00
|
|
|
|
|
| EFICAMWPR |
numeric
0.00
|
|
|
|
|
| EFICAMed_Tax_On_Tips |
numeric
0.00
|
|
|
|
|
| PayPeriodBeginDate |
datetime
'1/1/1900'
|
|
|
|
|
| PayPeriodEndDate |
datetime
'1/1/1900'
|
|
|
|
|
|