GP Tables

BE010130 - HR_Benefit_MSTR

Dynamics GP table BE010130 (HR_Benefit_MSTR) contains 84 columns including EMPID_I, BENEFIT, BENEFITTYPE_I....

SQL Query Builder

84 Columns

Column Description Type Length
EMPID_I Emp ID String 16
BENEFIT Benefit String 8
BENEFITTYPE_I Benefit Type String 8
IINDEX_I IIndex Integer 2
BENEFITKIND_I Benefit Kind Integer 2
COMPLETIONSTATUS_I Completion Status Integer 2
POLICYNUMBER_I Policy Number String 32
BENEFITSTATUS_I Benefit Status Integer 2
INACTIVE Inactive Boolean 2
Active Status values (2)
0 = Active1 = Inactive
OVERRIDE_I Override Boolean 2
CHECK1_I Check1 Boolean 2
CHECK2_I Check2 Boolean 2
CHECK3_I Check3 Boolean 2
CHECK4_I Check4 Boolean 2
CHECK5_I Check5 Boolean 2
DATEDUE_I Date Due Date 4
DSCRIPTN Description String 32
COMMENTSTR10_I CommentStr10 String 12
IBENEFITAMOUNT_I IBenefit Amount Currency 10
LIFEAMTEMPL_I Life Amt Empl Currency 10
LIFEAMTSPOUSE_I Life Amt Spouse Currency 10
LIFEAMTCHILDREN_I Life Amt Child(ren) Currency 10
BENELIGIBILEDATE_I Benefit Eligibility Date Date 4
BNFBEGDT Benefit Beg Date Date 4
BNFENDDT Benefit End Date Date 4
VARBENFT Variable Benefit Boolean 2
BNFTFREQ Benefit Frequency Integer 2
COSTEMPLOYEE_I Cost Employee Currency 10
COSTEMPLOYER_I Cost Employer Currency 10
COSTOTHER1_I Cost Other 1 Currency 10
COSTOTHER2_I Cost Other 2 Currency 10
I1_I i1 Integer 2
I2_I i2 Integer 2
I3_I i3 Integer 2
I4_I i4 Integer 2
NUMBEROFCHILDREN_I Number of children Integer 2
COSTTOTAL_I Cost Total Currency 10
COSTCOBRA_I Cost COBRA Currency 10
BENEFITDEDUCTIBLE_I Benefit Deductible Currency 10
BNPAYPMX Benefit Pay Period Max Currency 10
BNFYRMAX Benefit Year Max Currency 10
BNFLFMAX Benefit Lifetime Max Currency 10
BENEFICIARYINDEX_I Beneficiary Index Long Integer 4
CHANGEBY_I Change By String 16
CHANGEDATE_I Change Date Date 4
NOTESINDEX_I Notes Index Currency 10
CONTRIBPRETAX_I Contrib Pre Tax Currency 10
CONTPRETAXDLR_I Contrib Pre Tax Dollar Currency 10
CONTRIBAFTERTAX_I Contrib After Tax Currency 10
CONTAFTERTAXDLR_I Contrib After Tax Dollar Currency 10
CONTRIBBONUS_I Contrib Bonus Currency 10
CONTRIBBONUSDOLLAR_I Contrib Bonus Dollar Currency 10
HIGHLYCOMPENSATED_I Highly Compensated Boolean 2
LOANACTIVE_I Loan Active Boolean 2
TYPEOFCODE_I Type of Code Integer 2
TIERSUSED_I Tiers Used Boolean 2
MAJMEDCOVERAGE_I Major Medical Coverage Integer 2
MAXOUTOFPOCKET_I Max Out-Of-Pocket Currency 10
ELIGIBILITYDATE_I Eligibility Date Date 4
PRIMARYBENEFICIARY_I Primary Beneficiary String 32
SECBENEFICIARY_I Secondary Beneficiary String 32
BNFTMTHD Benefit Method Integer 2
BNFFRMLA Benefit Formula Integer 2
BNFPRCNT_1 Benefit Percent[1] Currency 10
BNFPRCNT_2 Benefit Percent[2] Currency 10
BNFPRCNT_3 Benefit Percent[3] Currency 10
BNFPRCNT_4 Benefit Percent[4] Currency 10
BNFPRCNT_5 Benefit Percent[5] Currency 10
DEDNMTHD Deduction Method Integer 2
DEDFRMLA Deduction Formula Integer 2
DEDNPRCT_1 Deduction Percent[1] Currency 10
DEDNPRCT_2 Deduction Percent[2] Currency 10
DEDNPRCT_3 Deduction Percent[3] Currency 10
DEDNPRCT_4 Deduction Percent[4] Currency 10
DEDNPRCT_5 Deduction Percent[5] Currency 10
DEPYPRMX Deduction Pay Period Max Currency 10
DEDYRMAX Deduction Year Max Currency 10
DEDLTMAX Deduction Lifetime Max Currency 10
DEDINITBAL Deduction Initial Balance Currency 10
INACTBENEMPLOYEE Inactive Benefit Employee Boolean 2
INACTBENEMPLR Inactive Benefit Employer Boolean 2
Benefit_Fiscal_Max Benefit Fiscal Max Currency 10
Deduction_Fiscal_Yr_Max Deduction Fiscal Year Max Currency 10
LIFEINSURTYPE Life Insurance Type Integer 2

Related Tables

Tables that share columns with BE010130. Click "Join" to add to your query.

DSCRIPTN

AHR2AP02 AHR2AP12 ASIEXP08 ASIEXP12 ASIEXP22 ASIEXP26 BE020230 BE021030

INACTIVE

AAG00400 AAG00401 ASIEXP02 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP10

CHANGEDATE_I

AAX10130 AEX10130 AHPSLH01 AHR2AP02 AHR2AP04 AHR2AP05 AHR2AP06 AHR2AP07

CHANGEBY_I

AAX10130 AEX10130 AHR2AP02 AHR2AP04 AHR2AP05 AHR2AP06 AHR2AP07 AHR2AP12

NOTESINDEX_I

AAU10130 AAX10130 AEU10130 AEX10130 AHR2AP02 AHR2AP04 AHR2AP05 AHR2AP06

EMPID_I

AE031000 AEMPNOTE AEU10130 AEX10130 BE011031 BE021030 BE040100 BE040200

BNFBEGDT

BE011031 BE020230 BE040100 BEA10130 BEA11031

CHECK1_I

BE011031 BE021030 BEA10130 BEA11031

IBENEFITAMOUNT_I

BE011031 BE021030 BEA10130 BEA11031

BNFENDDT

BE011031 BE020230 BEA10130 BEA11031