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 TM tables PayCodes
You are currently viewing the COMPANY database.
Change

COMPANY..PayCodes Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
UPRTRXCD char
''

DSCRIPTN char
''

DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
JOBTITLE char
''

TB_Auto_ShiftOvertime tinyint
0

TB_Auto_ShiftOvertimeThr numeric
0.00

TB_Auto_Shift_Overtime_P char
''

TB_Auto_Unpaid_Break tinyint
0

TB_Auto_Unpaid_Break_Thr numeric
0.00

TB_Auto_Unpaid_Break_Dur numeric
0.00

TB_Monday_0 tinyint
0

TB_Monday_1 tinyint
0

TB_Monday_2 tinyint
0

TB_Monday_3 tinyint
0

TB_Monday_4 tinyint
0

TB_Monday_5 tinyint
0

TB_Monday_6 tinyint
0

TB_Monday_7 tinyint
0

TB_Monday_8 tinyint
0

TB_Monday_9 tinyint
0

TB_Monday_10 tinyint
0

TB_Monday_11 tinyint
0

TB_Monday_12 tinyint
0

TB_Monday_13 tinyint
0

TB_Monday_14 tinyint
0

TB_Monday_15 tinyint
0

TB_Monday_16 tinyint
0

TB_Monday_17 tinyint
0

TB_Monday_18 tinyint
0

TB_Monday_19 tinyint
0

TB_Monday_20 tinyint
0

TB_Monday_21 tinyint
0

TB_Monday_22 tinyint
0

TB_Monday_23 tinyint
0

TB_Tuesday_0 tinyint
0

TB_Tuesday_1 tinyint
0

TB_Tuesday_2 tinyint
0

TB_Tuesday_3 tinyint
0

TB_Tuesday_4 tinyint
0

TB_Tuesday_5 tinyint
0

TB_Tuesday_6 tinyint
0

TB_Tuesday_7 tinyint
0

TB_Tuesday_8 tinyint
0

TB_Tuesday_9 tinyint
0

TB_Tuesday_10 tinyint
0

TB_Tuesday_11 tinyint
0

TB_Tuesday_12 tinyint
0

TB_Tuesday_13 tinyint
0

TB_Tuesday_14 tinyint
0

TB_Tuesday_15 tinyint
0

TB_Tuesday_16 tinyint
0

TB_Tuesday_17 tinyint
0

TB_Tuesday_18 tinyint
0

TB_Tuesday_19 tinyint
0

TB_Tuesday_20 tinyint
0

TB_Tuesday_21 tinyint
0

TB_Tuesday_22 tinyint
0

TB_Tuesday_23 tinyint
0

TB_Wednesday_0 tinyint
0

TB_Wednesday_1 tinyint
0

TB_Wednesday_2 tinyint
0

TB_Wednesday_3 tinyint
0

TB_Wednesday_4 tinyint
0

TB_Wednesday_5 tinyint
0

TB_Wednesday_6 tinyint
0

TB_Wednesday_7 tinyint
0

TB_Wednesday_8 tinyint
0

TB_Wednesday_9 tinyint
0

TB_Wednesday_10 tinyint
0

TB_Wednesday_11 tinyint
0

TB_Wednesday_12 tinyint
0

TB_Wednesday_13 tinyint
0

TB_Wednesday_14 tinyint
0

TB_Wednesday_15 tinyint
0

TB_Wednesday_16 tinyint
0

TB_Wednesday_17 tinyint
0

TB_Wednesday_18 tinyint
0

TB_Wednesday_19 tinyint
0

TB_Wednesday_20 tinyint
0

TB_Wednesday_21 tinyint
0

TB_Wednesday_22 tinyint
0

TB_Wednesday_23 tinyint
0

TB_Thursday_0 tinyint
0

TB_Thursday_1 tinyint
0

TB_Thursday_2 tinyint
0

TB_Thursday_3 tinyint
0

TB_Thursday_4 tinyint
0

TB_Thursday_5 tinyint
0

TB_Thursday_6 tinyint
0

TB_Thursday_7 tinyint
0

TB_Thursday_8 tinyint
0

TB_Thursday_9 tinyint
0

TB_Thursday_10 tinyint
0

TB_Thursday_11 tinyint
0

TB_Thursday_12 tinyint
0

TB_Thursday_13 tinyint
0

TB_Thursday_14 tinyint
0

TB_Thursday_15 tinyint
0

TB_Thursday_16 tinyint
0

TB_Thursday_17 tinyint
0

TB_Thursday_18 tinyint
0

TB_Thursday_19 tinyint
0

TB_Thursday_20 tinyint
0

TB_Thursday_21 tinyint
0

TB_Thursday_22 tinyint
0

TB_Thursday_23 tinyint
0

TB_Friday_0 tinyint
0

TB_Friday_1 tinyint
0

TB_Friday_2 tinyint
0

TB_Friday_3 tinyint
0

TB_Friday_4 tinyint
0

TB_Friday_5 tinyint
0

TB_Friday_6 tinyint
0

TB_Friday_7 tinyint
0

TB_Friday_8 tinyint
0

TB_Friday_9 tinyint
0

TB_Friday_10 tinyint
0

TB_Friday_11 tinyint
0

TB_Friday_12 tinyint
0

TB_Friday_13 tinyint
0

TB_Friday_14 tinyint
0

TB_Friday_15 tinyint
0

TB_Friday_16 tinyint
0

TB_Friday_17 tinyint
0

TB_Friday_18 tinyint
0

TB_Friday_19 tinyint
0

TB_Friday_20 tinyint
0

TB_Friday_21 tinyint
0

TB_Friday_22 tinyint
0

TB_Friday_23 tinyint
0

TB_Saturday_0 tinyint
0

TB_Saturday_1 tinyint
0

TB_Saturday_2 tinyint
0

TB_Saturday_3 tinyint
0

TB_Saturday_4 tinyint
0

TB_Saturday_5 tinyint
0

TB_Saturday_6 tinyint
0

TB_Saturday_7 tinyint
0

TB_Saturday_8 tinyint
0

TB_Saturday_9 tinyint
0

TB_Saturday_10 tinyint
0

TB_Saturday_11 tinyint
0

TB_Saturday_12 tinyint
0

TB_Saturday_13 tinyint
0

TB_Saturday_14 tinyint
0

TB_Saturday_15 tinyint
0

TB_Saturday_16 tinyint
0

TB_Saturday_17 tinyint
0

TB_Saturday_18 tinyint
0

TB_Saturday_19 tinyint
0

TB_Saturday_20 tinyint
0

TB_Saturday_21 tinyint
0

TB_Saturday_22 tinyint
0

TB_Saturday_23 tinyint
0

TB_Sunday_0 tinyint
0

TB_Sunday_1 tinyint
0

TB_Sunday_2 tinyint
0

TB_Sunday_3 tinyint
0

TB_Sunday_4 tinyint
0

TB_Sunday_5 tinyint
0

TB_Sunday_6 tinyint
0

TB_Sunday_7 tinyint
0

TB_Sunday_8 tinyint
0

TB_Sunday_9 tinyint
0

TB_Sunday_10 tinyint
0

TB_Sunday_11 tinyint
0

TB_Sunday_12 tinyint
0

TB_Sunday_13 tinyint
0

TB_Sunday_14 tinyint
0

TB_Sunday_15 tinyint
0

TB_Sunday_16 tinyint
0

TB_Sunday_17 tinyint
0

TB_Sunday_18 tinyint
0

TB_Sunday_19 tinyint
0

TB_Sunday_20 tinyint
0

TB_Sunday_21 tinyint
0

TB_Sunday_22 tinyint
0

TB_Sunday_23 tinyint
0

MDFUSRID char
''
User that ...(more) Join Now SY40500.MDFUSRID
join ... more text available
AA_Modify_Date datetime
'1/1/1900'

AA_Modify_Time datetime
'1/1/1900'

TB_Time_Clock_Pay_Max_CB tinyint
0

TB_Time_Clock_Pay_code_M numeric
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