Module List >
Module UPR tables
UPR00902
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR00902 Table Definition
(COMPANY..Payroll Employee Fiscal Summary)
Field Definitions:
What is the 'source' column?
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| YEAR1 |
smallint
0
|
Year: The ...(more) Join Now
|
|
|
|
| PERIODID |
smallint
0
|
|
|
|
|
| LPCHKNUM |
char(21)
''
|
Last Paych...(more) Join Now
|
|
|
|
| LSTPCKDT |
datetime
'1/1/1900'
|
Last Paych...(more) Join Now
|
|
|
|
| LPCHKAMT |
numeric(19,5)
0.00
|
Last Paych...(more) Join Now
|
|
|
|
| Gross_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Withholding_Fisc |
numeric(19,5)
0.00
|
|
|
|
|
| FICASS_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| FICAMED_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| FICASS_Withholding_Fisca |
numeric(19,5)
0.00
|
|
|
|
|
| FICAMED_Withholding_Fisc |
numeric(19,5)
0.00
|
|
|
|
|
| Suta_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| Futa_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| Net_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| Federal_Wages_Fiscal |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|