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:已
收代理  	返回手續費	返回管理費      補貼		上繳