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

COMPANY..UPR10213 Table Definition

(COMPANY..Payroll Check Descriptions)

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
PYCDDSAR_1 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_2 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_3 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_4 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_5 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_6 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_7 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_8 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_9 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_10 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_11 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_12 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_13 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_14 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_15 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_16 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_17 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_18 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_19 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_20 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_21 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_22 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_23 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_24 char(31)
''
DD Pay Des...(more) Join Now
PYCDDSAR_25 char(31)
''
DD Pay Des...(more) Join Now
deddesar_1 char(31)
''
DD Deducti...(more) Join Now
deddesar_2 char(31)
''
DD Deducti...(more) Join Now
deddesar_3 char(31)
''
DD Deducti...(more) Join Now
deddesar_4 char(31)
''
DD Deducti...(more) Join Now
deddesar_5 char(31)
''
DD Deducti...(more) Join Now
deddesar_6 char(31)
''
DD Deducti...(more) Join Now
deddesar_7 char(31)
''
DD Deducti...(more) Join Now
deddesar_8 char(31)
''
DD Deducti...(more) Join Now
deddesar_9 char(31)
''
DD Deducti...(more) Join Now
deddesar_10 char(31)
''
DD Deducti...(more) Join Now
deddesar_11 char(31)
''
DD Deducti...(more) Join Now
deddesar_12 char(31)
''
DD Deducti...(more) Join Now
deddesar_13 char(31)
''
DD Deducti...(more) Join Now
deddesar_14 char(31)
''
DD Deducti...(more) Join Now
deddesar_15 char(31)
''
DD Deducti...(more) Join Now
deddesar_16 char(31)
''
DD Deducti...(more) Join Now
deddesar_17 char(31)
''
DD Deducti...(more) Join Now
deddesar_18 char(31)
''
DD Deducti...(more) Join Now
deddesar_19 char(31)
''
DD Deducti...(more) Join Now
deddesar_20 char(31)
''
DD Deducti...(more) Join Now
deddesar_21 char(31)
''
DD Deducti...(more) Join Now
deddesar_22 char(31)
''
DD Deducti...(more) Join Now
deddesar_23 char(31)
''
DD Deducti...(more) Join Now
deddesar_24 char(31)
''
DD Deducti...(more) Join Now
deddesar_25 char(31)
''

BENDESAR_1 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_2 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_3 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_4 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_5 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_6 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_7 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_8 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_9 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_10 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_11 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_12 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_13 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_14 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_15 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_16 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_17 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_18 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_19 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_20 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_21 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_22 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_23 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_24 char(31)
''
DD Benefit...(more) Join Now
BENDESAR_25 char(31)
''
DD Benefit...(more) Join Now
TIMECODEDESCARRAY_1 char(31)
''

TIMECODEDESCARRAY_2 char(31)
''

TIMECODEDESCARRAY_3 char(31)
''

TIMECODEDESCARRAY_4 char(31)
''

TIMECODEDESCARRAY_5 char(31)
''

TIMECODEDESCARRAY_6 char(31)
''

TIMECODEDESCARRAY_7 char(31)
''

TIMECODEDESCARRAY_8 char(31)
''

TIMECODEDESCARRAY_9 char(31)
''

TIMECODEDESCARRAY_10 char(31)
''

TIMECODEDESCARRAY_11 char(31)
''

TIMECODEDESCARRAY_12 char(31)
''

TIMECODEDESCARRAY_13 char(31)
''

TIMECODEDESCARRAY_14 char(31)
''

TIMECODEDESCARRAY_15 char(31)
''

TIMECODEDESCARRAY_16 char(31)
''

TIMECODEDESCARRAY_17 char(31)
''

TIMECODEDESCARRAY_18 char(31)
''

TIMECODEDESCARRAY_19 char(31)
''

TIMECODEDESCARRAY_20 char(31)
''

TIMECODEDESCARRAY_21 char(31)
''

TIMECODEDESCARRAY_22 char(31)
''

TIMECODEDESCARRAY_23 char(31)
''

TIMECODEDESCARRAY_24 char(31)
''

TIMECODEDESCARRAY_25 char(31)
''

PAYARRCD_1 char(7)
''

PAYARRCD_2 char(7)
''

PAYARRCD_3 char(7)
''

PAYARRCD_4 char(7)
''

PAYARRCD_5 char(7)
''

PAYARRCD_6 char(7)
''

PAYARRCD_7 char(7)
''

PAYARRCD_8 char(7)
''

PAYARRCD_9 char(7)
''

PAYARRCD_10 char(7)
''

PAYARRCD_11 char(7)
''

PAYARRCD_12 char(7)
''

PAYARRCD_13 char(7)
''

PAYARRCD_14 char(7)
''

PAYARRCD_15 char(7)
''

PAYARRCD_16 char(7)
''

PAYARRCD_17 char(7)
''

PAYARRCD_18 char(7)
''

PAYARRCD_19 char(7)
''

PAYARRCD_20 char(7)
''

PAYARRCD_21 char(7)
''

PAYARRCD_22 char(7)
''

PAYARRCD_23 char(7)
''

PAYARRCD_24 char(7)
''

PAYARRCD_25 char(7)
''

DEDCDARR_1 char(7)
''

DEDCDARR_2 char(7)
''

DEDCDARR_3 char(7)
''

DEDCDARR_4 char(7)
''

DEDCDARR_5 char(7)
''

DEDCDARR_6 char(7)
''

DEDCDARR_7 char(7)
''

DEDCDARR_8 char(7)
''

DEDCDARR_9 char(7)
''

DEDCDARR_10 char(7)
''

DEDCDARR_11 char(7)
''

DEDCDARR_12 char(7)
''

DEDCDARR_13 char(7)
''

DEDCDARR_14 char(7)
''

DEDCDARR_15 char(7)
''

DEDCDARR_16 char(7)
''

DEDCDARR_17 char(7)
''

DEDCDARR_18 char(7)
''

DEDCDARR_19 char(7)
''

DEDCDARR_20 char(7)
''

DEDCDARR_21 char(7)
''

DEDCDARR_22 char(7)
''

DEDCDARR_23 char(7)
''

DEDCDARR_24 char(7)
''

DEDCDARR_25 char(7)
''

BNFCDARR_1 char(7)
''

BNFCDARR_2 char(7)
''

BNFCDARR_3 char(7)
''

BNFCDARR_4 char(7)
''

BNFCDARR_5 char(7)
''

BNFCDARR_6 char(7)
''

BNFCDARR_7 char(7)
''

BNFCDARR_8 char(7)
''

BNFCDARR_9 char(7)
''

BNFCDARR_10 char(7)
''

BNFCDARR_11 char(7)
''

BNFCDARR_12 char(7)
''

BNFCDARR_13 char(7)
''

BNFCDARR_14 char(7)
''

BNFCDARR_15 char(7)
''

BNFCDARR_16 char(7)
''

BNFCDARR_17 char(7)
''

BNFCDARR_18 char(7)
''

BNFCDARR_19 char(7)
''

BNFCDARR_20 char(7)
''

BNFCDARR_21 char(7)
''

BNFCDARR_22 char(7)
''

BNFCDARR_23 char(7)
''

BNFCDARR_24 char(7)
''

BNFCDARR_25 char(7)
''

TIMECODEARRAY_1 char(7)
''

TIMECODEARRAY_2 char(7)
''

TIMECODEARRAY_3 char(7)
''

TIMECODEARRAY_4 char(7)
''

TIMECODEARRAY_5 char(7)
''

TIMECODEARRAY_6 char(7)
''

TIMECODEARRAY_7 char(7)
''

TIMECODEARRAY_8 char(7)
''

TIMECODEARRAY_9 char(7)
''

TIMECODEARRAY_10 char(7)
''

TIMECODEARRAY_11 char(7)
''

TIMECODEARRAY_12 char(7)
''

TIMECODEARRAY_13 char(7)
''

TIMECODEARRAY_14 char(7)
''

TIMECODEARRAY_15 char(7)
''

TIMECODEARRAY_16 char(7)
''

TIMECODEARRAY_17 char(7)
''

TIMECODEARRAY_18 char(7)
''

TIMECODEARRAY_19 char(7)
''

TIMECODEARRAY_20 char(7)
''

TIMECODEARRAY_21 char(7)
''

TIMECODEARRAY_22 char(7)
''

TIMECODEARRAY_23 char(7)
''

TIMECODEARRAY_24 char(7)
''

TIMECODEARRAY_25 char(7)
''

STATXARR_1 char(3)
''

STATXARR_2 char(3)
''

STATXARR_3 char(3)
''

STATXARR_4 char(3)
''

STATXARR_5 char(3)
''

STATXARR_6 char(3)
''

STATXARR_7 char(3)
''

STATXARR_8 char(3)
''

STATXARR_9 char(3)
''

STATXARR_10 char(3)
''

STATXARR_11 char(3)
''

STATXARR_12 char(3)
''

STATXARR_13 char(3)
''

STATXARR_14 char(3)
''

STATXARR_15 char(3)
''

STATXARR_16 char(3)
''

STATXARR_17 char(3)
''

STATXARR_18 char(3)
''

STATXARR_19 char(3)
''

STATXARR_20 char(3)
''

STATXARR_21 char(3)
''

STATXARR_22 char(3)
''

STATXARR_23 char(3)
''

STATXARR_24 char(3)
''

STATXARR_25 char(3)
''

LCLTXARR_1 char(7)
''

LCLTXARR_2 char(7)
''

LCLTXARR_3 char(7)
''

LCLTXARR_4 char(7)
''

LCLTXARR_5 char(7)
''

LCLTXARR_6 char(7)
''

LCLTXARR_7 char(7)
''

LCLTXARR_8 char(7)
''

LCLTXARR_9 char(7)
''

LCLTXARR_10 char(7)
''

LCLTXARR_11 char(7)
''

LCLTXARR_12 char(7)
''

LCLTXARR_13 char(7)
''

LCLTXARR_14 char(7)
''

LCLTXARR_15 char(7)
''

LCLTXARR_16 char(7)
''

LCLTXARR_17 char(7)
''

LCLTXARR_18 char(7)
''

LCLTXARR_19 char(7)
''

LCLTXARR_20 char(7)
''

LCLTXARR_21 char(7)
''

LCLTXARR_22 char(7)
''

LCLTXARR_23 char(7)
''

LCLTXARR_24 char(7)
''

LCLTXARR_25 char(7)
''

USERID char(15)
''
The user t...(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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3