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

COMPANY..UPR00903 Table Definition

(COMPANY..Payroll Employee Tips Fiscal Summary)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
PERIODID smallint
0

YEAR1 smallint
0
Year: The ...(more) Join Now
Reported_Tips numeric(19,5)
0.00

Charged_Tips numeric(19,5)
0.00

FDTXTIPS numeric(19,5)
0.00

FICASS_Tips_Fiscal numeric(19,5)
0.00

FICSTPTX numeric(19,5)
0.00

Uncollected_FICASS_Tax_F numeric(19,5)
0.00

FICAMed_Tips_Fiscal numeric(19,5)
0.00

FICMTPTX numeric(19,5)
0.00

Uncollect_FICAMed_Tx_Fis numeric(19,5)
0.00

Reported_Receipts numeric(19,5)
0.00

Charged_Receipts numeric(19,5)
0.00

Allocated_Tips_Fiscal numeric(19,5)
0.00

Federal_Tips_Fiscal numeric(19,5)
0.00

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