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

COMPANY..UPR10109 Table Definition

(COMPANY..Payroll Year End Dependent ACA)
uprYearEndDependentACA
 

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
Effective_Date datetime
'1/1/1900'

FRSTNAME char
''

OfferOfCoverageCode smallint
0

SafeHarborCode smallint
0

MIDDLEINITIAL char
''

DOLRAMNT numeric
0.00

LASTNAME char
''
Last Name:...(more) Join Now WC010300.LASTNAME
CHANGEBY_I char
''
*Change By...(more) Join Now
DEPENDENTSSN char
''

BRTHDATE datetime
'1/1/1900'

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
CoveredForYear tinyint
0

CoveredMonth_1 tinyint
0

CoveredMonth_2 tinyint
0

CoveredMonth_3 tinyint
0

CoveredMonth_4 tinyint
0

CoveredMonth_5 tinyint
0

CoveredMonth_6 tinyint
0

CoveredMonth_7 tinyint
0

CoveredMonth_8 tinyint
0

CoveredMonth_9 tinyint
0

CoveredMonth_10 tinyint
0

CoveredMonth_11 tinyint
0

CoveredMonth_12 tinyint
0

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