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

COMPANY..UPR40500 Table Definition

(COMPANY..Payroll Accounts Setup)

This file contains payroll posting account information for a company. Default values are created during install and when data is cleared from the file. Defaults exist for:

Federal Tax Withholding:

EFIC/M Employee FICA Medicare Tax
EFIC/S Employee FICA Social Security Tax
FED Federal Tax Withholding
FICA/M FICA Medicare Tax Withholding
FICA/S FICA Social Security Tax Withholding

Employer’s Tax Expense:
FIC/ME FICA Medicare Tax Expense
FIC/SE FICA Social Security Tax Expense.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DEPRTMNT char(7)
''
Department...(more) Join Now
join ... more text available
JOBTITLE char(7)
''

PAYROLCD char(7)
''

UPRACTYP smallint
0

ACTINDX int
0
Account In...(more) Join Now
join ... more text available
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