GP Tables

BE020230 - HR_Benefit_SETP

Dynamics GP table BE020230 (HR_Benefit_SETP) contains 84 columns including BENEFIT, DSCRIPTN, BENEFITSTATUS_I....

SQL Query Builder

84 Columns

Column Description Type Length
BENEFIT Benefit String 8
DSCRIPTN Description String 32
BENEFITSTATUS_I Benefit Status Integer 2
COMPLETIONSTATUS_I Completion Status Integer 2
INACTIVE Inactive Boolean 2
Active Status values (2)
0 = Active1 = Inactive
BENEFITKIND_I Benefit Kind Integer 2
BNFBEGDT Benefit Beg Date Date 4
BNFENDDT Benefit End Date Date 4
VARBENFT Variable Benefit Boolean 2
BNFTFREQ Benefit Frequency Integer 2
CARRIER Carrier String 32
GROUPNUMBER_I Group Number String 32
PORTABLEBENEFIT_I Portable Benefit Boolean 2
PORABLEINDEX_I Portable Index Integer 2
MAXAGEEMP_I Max Age-Emp Integer 2
MAXAGEDEP_I Max Age-Dep Integer 2
MAXAGESP_I Max Age-Sp 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
GB_I GB Integer 2
COSTTOTAL_I Cost Total Currency 10
COSTCOBRA_I Cost COBRA Currency 10
BENAMOUNT_I Ben Amount 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
CHANGEBY_I Change By String 16
CHANGEDATE_I Change Date Date 4
NOTESINDEX_I Notes Index Currency 10
NEAREST_I Nearest Currency 10
NEARESTCHILD_I Nearest(Child) Currency 10
NEARESTSPOUSE_I Nearest(Spouse) Currency 10
NEARESTEMPLOYER_I Nearest(Employer) Currency 10
PREMMETHOD_I Prem Method Integer 2
PREMIUMEMPLOYEE_I Premium Employee Currency 10
PREMIUMSPOUSE_I Premium Spouse Currency 10
PREMIUMCHILD_I Premium Child Currency 10
PREMIUMEMPLOYER_I Premium Employer Currency 10
PREMIUMSMOKER_I Premium Smoker Currency 10
FACTOR_I Factor Integer 2
ROUNDUP_I Round Up Boolean 2
PDLIFE_I Pd Life Boolean 2
CONTEMPMATCH_I Contrib Employer Match Currency 10
CONTRIBEMPLOYERMAX_I Contrib Employer Max Currency 10
MINAGE_I Min Age Integer 2
BONUSELACTIVE_I Bonus Election Active Boolean 2
LOANSALLOWED_I Loans Allowed Boolean 2
HARDSHPWITHDRAW_I Hardship Withdrawals Boolean 2
TYPEOFCODE_I Type of Code Integer 2
CONTRIBDOLLAR_I Contrib Dollar Currency 10
CONTRIBPERCENT_I Contrib Percent Currency 10
MAJMEDCOVERAGE_I Major Medical Coverage Integer 2
MAXOUTOFPOCKET_I Max Out-Of-Pocket Currency 10
WAITINGPERIOD_I Waiting Period Integer 2
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
INACTBENEMPLOYEE Inactive Benefit Employee Boolean 2
INACTBENEMPLR Inactive Benefit Employer Boolean 2
GARNISHMENT Garnishment 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 BE020230. Click "Join" to add to your query.

DSCRIPTN

AHR2AP02 AHR2AP12 ASIEXP08 ASIEXP12 ASIEXP22 ASIEXP26 BE010130 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

BNFBEGDT

BE010130 BE011031 BE040100 BEA10130 BEA11031

BNFENDDT

BE010130 BE011031 BEA10130 BEA11031

COSTCOBRA_I

BE010130 BE040100 BEA10130

DEDNMTHD

BE010130 BEA10130 DD00200

BENEFIT

BE010130 BEA10130