开发档案.txt

太平洋保险保单统计系统

Temp_NP
NP_ID N(6), NP_Name C(20), Safe_ID N(6), Safe_Name C(20), NPYear N(4), NPMonth N(2), Dan_T n(5), Dan_F n(5), Money N(11,2),  
网点ID      网店名称       险种ID        险种名称         年份         月份          有效单      作废单      营业额        

InRate1 N(5,2), InSub1 N(11,2), InRate2 N(5,2), InSub2 N(11,2), InSub3 N(11,2), SumIn N(11,2), OutRate1 N(5,2), OutSub1 N(11,2),
代理率          代理金额        管理率          管理金额        交强补贴        收入合计       上缴率           上缴金额


OutRate2 N(5,2), OutSub2 N(11,2), OutSub3 N(11,2), SumOut N(11,2)
返点率           返点金额         0.5%部门金额     支出合计


NP_ID,NP_Name,Safe_ID,Safe_Name,NPYear,NPMonth,Dan_T,Dan_F,Money,InRate1,InSub1,InRate2,InSub2,InSub3,SumIn,OutRate1,OutSub1,OutRate2,OutSub2,OutSub3,SumOut



MoneyIn
PID	dat	Pyear	Pmonth	NetPoint	kind	num	remark


TEXT TO TSQL NOSHOW
SELECT NetPoint.coname, safetykind.safetyname, NetPtRate.PID, NetPtRate.NP_Pid, NetPtRate.SK_Pid,NetPtRate.money,
      NetPtRate.inrate1, inrate1sum, NetPtRate.inrate2,
      NetPtRate.inrate2sum, NetPtRate.inrate3sum, NetPtRate.summation1,
      NetPtRate.outrate1, NetPtRate.outrate1sum, NetPtRate.condition,
      NetPtRate.retuPoint, NetPtRate.retuPointsum, NetPtRate.DeptSum,
      NetPtRate.summation2, NetPtRate.remark
FROM NetPtRate INNER JOIN
      NetPoint ON NetPtRate.NP_Pid = NetPoint.PID INNER JOIN
      safetykind ON NetPtRate.SK_Pid = safetykind.PID
order by NetPtRate.NP_Pid,NetPtRate.SK_Pid
ENDTEXT



estate1,	estate2,	estate3,	estate4,	estate5	  1:未  2:已
收代理  	返回手续费	返回管理费      补贴		上缴