1、在社保实际缴纳值导入T_HR_SSocPay中找到增加的字段FSocPersonal12、在核算临时表/取社保缴纳值导入数据，中增加红色字体的部分参数定义列表PERSONID,PERSONNAME,FID,FIDCARD,FSOCACCOUNT,FSOCBASE,FUNDACCOUNT,FUNDBASE,FRECEIVABLETOTAL,FPERSONALTOTAL,FUNITTOTAL,FPENSIONBASE,FPERSONALPENSION,FUNITPENSION,FMEDICALBASE,FPERSONALMEDICAL,FUNITMEDICAL,FINDUSTRIALINJURYBASE,FUNITINDUSTRIALINJURY,FUNEMPLOYMENTBASE,FPERSONALUNEMPLOYMENT,FUNITUNEMPLOYMENT,FBEARBASE,FUNITBEAR,FUNITFUND,FPERSONALFUND,FSocPersonal1参数名称列表：人员ID,人员编码,核算表ID,身份证号,社保账号,社保缴费基数,住房公积金账号,公积金缴费基数,应收合计,个人合计,单位合计,养老缴费基数,养老个人缴纳金,养老单位缴纳金,医疗缴费基数,医疗个人缴纳金,医疗单位缴纳金,工伤缴费基数,工伤单位缴纳金,失业缴费基数,失业个人缴纳金,失业单位缴纳金,生育缴费基数,生育单位缴纳金,公积金单位缴纳金,公积金个人缴纳金,测试（参数名称只能填写中文）参数类型列表：String,String,String,String,String,double,String,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double,double查询语句：selectperson.fidpersonId,person.fname_l2personName,T_HR_SCmpCalTable.fidfid,sin.fidcardfidcard,sin.fsocaccountfsocaccount,sin.fsocbasefsocbase,sin.fundaccountfundaccount,sin.fundbasefundbase,sin.freceivabletotalfreceivabletotal,sin.fpersonaltotalfpersonaltotal,sin.funittotalfunittotal,sin.fpensionbasefpensionbase,sin.fpersonalpensionfpersonalpension,sin.funitpensionfunitpension,sin.fmedicalbasefmedicalbase,sin.fpersonalmedicalfpersonalmedical,sin.funitmedicalfunitmedical,sin.findustrialinjurybasefindustrialinjurybase,sin.funitindustrialinjuryfunitindustrialinjury,sin.funemploymentbasefunemploymentbase,sin.fpersonalunemploymentfpersonalunemployment,sin.funitunemploymentfunitunemployment,sin.fbearbasefbearbase,sin.funitbearfunitbear,sin.funitfundfunitfund,sin.fpersonalfundfpersonalfund,sin.fsocpersonal1fsocpersonal1fromT_HR_SSocPaysininnerjoint_bd_personpersononsin.fpersonid=person.fidinnerjoinT_HR_SCmpCalTableonT_HR_SCmpCalTable.FPERSONID=sin.fpersonIdandT_HR_SCmpCalTable.FPeriodYear=sin.FPeriodYearandT_HR_SCmpCalTable.FPeriodMonth=sin.FPeriodMonth3、在公式的临时表“取社保缴纳值导入数据”中就可以选到字段“测试”
