DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module UPR tables UPR00901
You are currently viewing the COMPANY database.
Change

COMPANY..UPR00901 Table Definition

(COMPANY..Payroll Employee Tips Summary)
Can view tips wage and receipt information, tax withheld on tips wages, and any uncollected tax amounts on tips wages. The data within this table is automatically updated when checks are posted.
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
Reported_Tips12_1 numeric(19,5)
0.00
Reported T...(more) Join Now
Reported_Tips12_2 numeric(19,5)
0.00

Reported_Tips12_3 numeric(19,5)
0.00

Reported_Tips12_4 numeric(19,5)
0.00

Reported_Tips12_5 numeric(19,5)
0.00

Reported_Tips12_6 numeric(19,5)
0.00

Reported_Tips12_7 numeric(19,5)
0.00

Reported_Tips12_8 numeric(19,5)
0.00

Reported_Tips12_9 numeric(19,5)
0.00

Reported_Tips12_10 numeric(19,5)
0.00

Reported_Tips12_11 numeric(19,5)
0.00

Reported_Tips12_12 numeric(19,5)
0.00

Charged_Tips12_1 numeric(19,5)
0.00
Charged Ti...(more) Join Now
Charged_Tips12_2 numeric(19,5)
0.00

Charged_Tips12_3 numeric(19,5)
0.00

Charged_Tips12_4 numeric(19,5)
0.00

Charged_Tips12_5 numeric(19,5)
0.00

Charged_Tips12_6 numeric(19,5)
0.00

Charged_Tips12_7 numeric(19,5)
0.00

Charged_Tips12_8 numeric(19,5)
0.00

Charged_Tips12_9 numeric(19,5)
0.00

Charged_Tips12_10 numeric(19,5)
0.00

Charged_Tips12_11 numeric(19,5)
0.00

Charged_Tips12_12 numeric(19,5)
0.00

Federal_Tax_On_Tips_1 numeric(19,5)
0.00
Federal Ta...(more) Join Now
Federal_Tax_On_Tips_2 numeric(19,5)
0.00

Federal_Tax_On_Tips_3 numeric(19,5)
0.00

Federal_Tax_On_Tips_4 numeric(19,5)
0.00

Federal_Tax_On_Tips_5 numeric(19,5)
0.00

Federal_Tax_On_Tips_6 numeric(19,5)
0.00

Federal_Tax_On_Tips_7 numeric(19,5)
0.00

Federal_Tax_On_Tips_8 numeric(19,5)
0.00

Federal_Tax_On_Tips_9 numeric(19,5)
0.00

Federal_Tax_On_Tips_10 numeric(19,5)
0.00

Federal_Tax_On_Tips_11 numeric(19,5)
0.00

Federal_Tax_On_Tips_12 numeric(19,5)
0.00

FICASS_Tips_1 numeric(19,5)
0.00
FICA/SS Ti...(more) Join Now
FICASS_Tips_2 numeric(19,5)
0.00

FICASS_Tips_3 numeric(19,5)
0.00

FICASS_Tips_4 numeric(19,5)
0.00

FICASS_Tips_5 numeric(19,5)
0.00

FICASS_Tips_6 numeric(19,5)
0.00

FICASS_Tips_7 numeric(19,5)
0.00

FICASS_Tips_8 numeric(19,5)
0.00

FICASS_Tips_9 numeric(19,5)
0.00

FICASS_Tips_10 numeric(19,5)
0.00

FICASS_Tips_11 numeric(19,5)
0.00

FICASS_Tips_12 numeric(19,5)
0.00

FICASS_Tax_On_Tips_1 numeric(19,5)
0.00
FICA/SS Ta...(more) Join Now
FICASS_Tax_On_Tips_2 numeric(19,5)
0.00

FICASS_Tax_On_Tips_3 numeric(19,5)
0.00

FICASS_Tax_On_Tips_4 numeric(19,5)
0.00

FICASS_Tax_On_Tips_5 numeric(19,5)
0.00

FICASS_Tax_On_Tips_6 numeric(19,5)
0.00

FICASS_Tax_On_Tips_7 numeric(19,5)
0.00

FICASS_Tax_On_Tips_8 numeric(19,5)
0.00

FICASS_Tax_On_Tips_9 numeric(19,5)
0.00

FICASS_Tax_On_Tips_10 numeric(19,5)
0.00

FICASS_Tax_On_Tips_11 numeric(19,5)
0.00

FICASS_Tax_On_Tips_12 numeric(19,5)
0.00

Uncollected_FICASS_Tax_1 numeric(19,5)
0.00
Uncollecte...(more) Join Now
Uncollected_FICASS_Tax_2 numeric(19,5)
0.00

Uncollected_FICASS_Tax_3 numeric(19,5)
0.00

Uncollected_FICASS_Tax_4 numeric(19,5)
0.00

Uncollected_FICASS_Tax_5 numeric(19,5)
0.00

Uncollected_FICASS_Tax_6 numeric(19,5)
0.00

Uncollected_FICASS_Tax_7 numeric(19,5)
0.00

Uncollected_FICASS_Tax_8 numeric(19,5)
0.00

Uncollected_FICASS_Tax_9 numeric(19,5)
0.00

Uncollected_FICASS_Tax_10 numeric(19,5)
0.00

Uncollected_FICASS_Tax_11 numeric(19,5)
0.00

Uncollected_FICASS_Tax_12 numeric(19,5)
0.00

FICAMed_Tips_1 numeric(19,5)
0.00
FICA/Med T...(more) Join Now
FICAMed_Tips_2 numeric(19,5)
0.00

FICAMed_Tips_3 numeric(19,5)
0.00

FICAMed_Tips_4 numeric(19,5)
0.00

FICAMed_Tips_5 numeric(19,5)
0.00

FICAMed_Tips_6 numeric(19,5)
0.00

FICAMed_Tips_7 numeric(19,5)
0.00

FICAMed_Tips_8 numeric(19,5)
0.00

FICAMed_Tips_9 numeric(19,5)
0.00

FICAMed_Tips_10 numeric(19,5)
0.00

FICAMed_Tips_11 numeric(19,5)
0.00

FICAMed_Tips_12 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_1 numeric(19,5)
0.00
FICA/Med T...(more) Join Now
FICAMed_Tax_On_Tips_2 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_3 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_4 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_5 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_6 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_7 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_8 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_9 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_10 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_11 numeric(19,5)
0.00

FICAMed_Tax_On_Tips_12 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_1 numeric(19,5)
0.00
Uncollecte...(more) Join Now
Uncollected_FICAMed_Tax_2 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_3 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_4 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_5 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_6 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_7 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_8 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_9 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_10 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_11 numeric(19,5)
0.00

Uncollected_FICAMed_Tax_12 numeric(19,5)
0.00

Reported_Receipts12_1 numeric(19,5)
0.00
Reported R...(more) Join Now
Reported_Receipts12_2 numeric(19,5)
0.00

Reported_Receipts12_3 numeric(19,5)
0.00

Reported_Receipts12_4 numeric(19,5)
0.00

Reported_Receipts12_5 numeric(19,5)
0.00

Reported_Receipts12_6 numeric(19,5)
0.00

Reported_Receipts12_7 numeric(19,5)
0.00

Reported_Receipts12_8 numeric(19,5)
0.00

Reported_Receipts12_9 numeric(19,5)
0.00

Reported_Receipts12_10 numeric(19,5)
0.00

Reported_Receipts12_11 numeric(19,5)
0.00

Reported_Receipts12_12 numeric(19,5)
0.00

Charged_Receipts12_1 numeric(19,5)
0.00
Charged Re...(more) Join Now
Charged_Receipts12_2 numeric(19,5)
0.00

Charged_Receipts12_3 numeric(19,5)
0.00

Charged_Receipts12_4 numeric(19,5)
0.00

Charged_Receipts12_5 numeric(19,5)
0.00

Charged_Receipts12_6 numeric(19,5)
0.00

Charged_Receipts12_7 numeric(19,5)
0.00

Charged_Receipts12_8 numeric(19,5)
0.00

Charged_Receipts12_9 numeric(19,5)
0.00

Charged_Receipts12_10 numeric(19,5)
0.00

Charged_Receipts12_11 numeric(19,5)
0.00

Charged_Receipts12_12 numeric(19,5)
0.00

Allocated_Tips_Array_1 numeric(19,5)
0.00
Allocated...(more) Join Now
Allocated_Tips_Array_2 numeric(19,5)
0.00

Allocated_Tips_Array_3 numeric(19,5)
0.00

Allocated_Tips_Array_4 numeric(19,5)
0.00

Allocated_Tips_Array_5 numeric(19,5)
0.00

Allocated_Tips_Array_6 numeric(19,5)
0.00

Allocated_Tips_Array_7 numeric(19,5)
0.00

Allocated_Tips_Array_8 numeric(19,5)
0.00

Allocated_Tips_Array_9 numeric(19,5)
0.00

Allocated_Tips_Array_10 numeric(19,5)
0.00

Allocated_Tips_Array_11 numeric(19,5)
0.00

Allocated_Tips_Array_12 numeric(19,5)
0.00

YEAR1 smallint
0
Year: The ...(more) Join Now
Federal_Tips_1 numeric(19,5)
0.00
Federal Ti...(more) Join Now
Federal_Tips_2 numeric(19,5)
0.00

Federal_Tips_3 numeric(19,5)
0.00

Federal_Tips_4 numeric(19,5)
0.00

Federal_Tips_5 numeric(19,5)
0.00

Federal_Tips_6 numeric(19,5)
0.00

Federal_Tips_7 numeric(19,5)
0.00

Federal_Tips_8 numeric(19,5)
0.00

Federal_Tips_9 numeric(19,5)
0.00

Federal_Tips_10 numeric(19,5)
0.00

Federal_Tips_11 numeric(19,5)
0.00

Federal_Tips_12 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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3