$$$$$$pr_msgetcode90(MS).sql^^^^dne

 TUPTUO edoc@ 18edoCteGSM_px.obd.retsam cexe	

nigeb

  SA

 )tuptuo )652(rahcrav edoc@( 09edoctegsm_rp erudecorp etaerc


og

09edoctegsm_rp erudecorp pord  

)'09edoctegsm_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_pos_trans_data(MS).sql^^^^

DNE


DNE 


 disop@ = disop.pmet_wolfyap_mr_t EREHW pmet_wolfyap_mr_t ETELED 	


 disop@ = disop.pmet_wolfelas_mr_t EREHW pmet_wolfelas_mr_t ETELED 	


 disop@ = disop.pmet EREHW 	

pmet SA pmet_wolfelas_mr_t MORF 	

on_teehs_ceps, '误错它其' ,dnar_onwolf.pmet ,disop.pmet ,nats_rhc.pmet 	

,nats_n.pmet ,ecirp_ni.pmet ,tma_ferp.pmet  ,galf_ceps.pmet  ,)'0',galf_moc.pmet(LLUNSI 	

,on_tfihs.pmet ,galf_etomer.pmet ,etad_repo.pmet ,on_retnuoc.pmet ,nam_elas.pmet 	

,di_repo.pmet ,yaw_lles.pmet ,yenom_elas.pmet ,ytnq_elas.pmet ,ecirp_elas.pmet 	

,ecirp_ecruos.pmet ,on_meti.pmet ,on_hcnarb.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

)on_teehs_ceps, ofni_rorre ,dnar_onwolf ,disop ,nats_rhc 	

,nats_n ,ecirp_ni ,tma_ferp ,galf_ceps ,galf_moc 	

,on_tfihs ,galf_etomer ,etad_repo ,on_retnuoc ,nam_elas 	

,di_repo ,yaw_lles ,yenom_elas ,ytnq_elas ,ecirp_elas 	

,ecirp_ecruos ,on_meti ,on_hcnarb ,on_wolf ,di_wolf (rorre_wolfelas_mr_t OTNI 	

 TRESNI 	

pmet_wolfelas理处-- 	

	

 disop@ = disop.pmet EREHW 	

 pmet SA pmet_wolfyap_mr_t MORF 	

'误错它其' ,dnar_onwolf.pmet ,disop.pmet ,)'0',galf_moc.pmet(LLUNSI 	

,on_tfihs.pmet ,galf_egnahcxe.pmet ,galf_etomer.pmet ,on_rehcuov.pmet ,omem.pmet 	

,nam_elas.pmet ,on_retnuoc.pmet ,di_repo.pmet ,etad_repo.pmet ,tnuoma_yap.pmet 	

,etar_nioc.pmet,)'BMR',on_nioc.pmet(LLUNSI ,on_piv.pmet ,on_drac.pmet ,yaw_lles.pmet 	

,yaw_yap.pmet ,on_hcnarb.pmet ,tnuoma_elas.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

) ofni_rorre ,dnar_onwolf ,disop ,galf_moc 	

,on_tfihs ,galf_egnahcxe ,galf_etomer ,on_rehcuov ,omem 	

,nam_elas ,on_retnuoc ,di_repo ,etad_repo ,tnuoma_yap 	

,etar_nioc ,on_nioc ,on_piv ,on_drac ,yaw_lles 	

,yaw_yap ,on_hcnarb ,tnuoma_elas ,on_wolf ,di_wolf (rorre_wolfyap_mr_t OTNI 	

 TRESNI 	

pmet_wolfyap理处-- 	




。表误错入转 ) 入收易交 DNA 常正不水流 ( DNA 新 将，3-- 	

。表误错入转 ) ) 入收易交 RO 常正水流 ( DNA 常正不水流 ( DNA 新 将，3-- 	

。表误错入转 ) ) 入收易交非 DNA 常正不水流 ( TON DNA 常正不水流 ( DNA 新 将，3-- 	

。表误错入转 ) ) ) 入收易交非 DNA 常正不水流 ( RO 常正水流 ( TON ( DNA 新 将，3-- 	

) etad_repo.wolf = etad_repo.pmet_wolfelas_mr_t DNA on_hcnarb.wolf = on_hcnarb.pmet_wolfelas_mr_t DNA 	

 di_wolf.wolf = di_wolf.pmet_wolfelas_mr_t DNA on_wolf.wolf = on_wolf.pmet_wolfelas_mr_t EREHW 	

wolf SA wolfelas_mr_t MORF 	

1 TCELES (STSIXE DNA 	

 disop@ = disop.pmet_wolfelas_mr_t EREHW 	

 pmet_wolfelas_mr_t ETELED 	

录记的旧中pmet_wolfelas除删-- 	


 )etad_repo.wolf = etad_repo.pmet_wolfyap_mr_t DNA on_hcnarb.wolf = on_hcnarb.pmet_wolfyap_mr_t DNA 	

di_wolf.wolf = di_wolf.pmet_wolfyap_mr_t DNA on_wolf.wolf = on_wolf.pmet_wolfyap_mr_t EREHW 	

wolf SA wolfyap_mr_t MORF 	

 1 TCELES (STSIXE DNA 	

 disop@ = disop.pmet_wolfyap_mr_t EREHW 	

 pmet_wolfyap_mr_t ETELED 	

录记的旧中pmet_wolfyap除删-- 	


分积员会理处 .3-- 	

dne 	

  pmetpiv_rucsiht ETACOLLAED		

pmetpiv_rucsiht ESOLC		

			dne		

on_hcnarb@ ,on_wolf@ OTNI pmetpiv_rucsiht HCTEF			

dne			

onhctab_pu@=onhctab_pu dna '0'=ccapiv_pu DNA						

on_hcnarb@=on_hcnarb dna on_wolf@=on_wolf   erehw				

'1'=ccapiv_pu tes wolfyap_mr_t etadpu				

nigeb			

 0 = RORRE@@ fi			

etad_ranul@, on_hcnarb@ ,on_wolf@ piv_mr_rp cexe			

nigeb		

 )0 = sutatS_hctef@@( ELIHW		

on_hcnarb@ ,on_wolf@ OTNI pmetpiv_rucsiht HCTEF		

 pmetpiv_rucsiht NEPO		

'' >< )'',on_drac(llunsi	DNA					

onhctab_pu@=onhctab_pu dna '0'=ccapiv_pu DNA					

 'VAS'= yaw_yap	EREHW			

 wolfyap_mr_t		MORF			

on_hcnarb,on_wolf tcnitsid TCELES			

				 noinu			

'' >< )'',on_piv.b(llunsi dna						

onhctab_pu@=onhctab_pu.b dna '0'=ccapiv_pu.b DNA						

'YOM' >< yaw_yap.b DNA						

 on_wolf.b = on_wolf.a		EREHW			

  b wolfyap_mr_t						

,a wolfelas_mr_t		MORF			

on_hcnarb.b,on_wolf.a tcnitsid TCELES			

ROF ROSRUC pmetpiv_rucsiht ERALCED		

据数的新更次本为作件条断判的面里piv_mr_rp--		

) )(ETADTEG (ranuLteG_nf.obd=etad_ranul@ tes		

)--		

on_hcnarb.c = on_hcnarb dna on_wolf.c = on_wolf dna			--		

'' >< )'',on_drac(llunsi	DNA			--		

onhctab_pu@=onhctab_pu dna '1'=ccapiv_pu DNA			--		

 'VAS'= yaw_yap	EREHW	--		

 wolfyap_mr_t		MORF	--		

1 TCELES	--		

				 noinu	--		

on_hcnarb.c = on_hcnarb.b dna on_wolf.c = on_wolf.a dna				--		

'' >< )'',on_piv.b(llunsi dna				--		

onhctab_pu@=onhctab_pu.b dna '1'=ccapiv_pu.b DNA				--		

'YOM' >< yaw_yap.b DNA				--		

 on_wolf.b = on_wolf.a		EREHW	--		

  b wolfyap_mr_t				--		

,a wolfelas_mr_t		MORF	--		

1 TCELES(--		

 stsixe ton dna--		

onhctab_pu@=onhctab_pu.c dna '1'=ccapiv_pu.c--		

 erehw--		

 c  wolfyap_mr_t morf--		

llun=ccapiv_pu.c tes  c etadpu--		

1为分积过算计，0位据数次本，llun为据数史历ccapiv_pu--		

nigeb 	

 1 = nyap@ fi 	

分积员会理处 .3-- 	


表wolf入转水流款付将以可，录记款付的入收易交非为且录记售销有没且的新 .2 DNE-- 	

 1 = nyap@ tes		

 0 > TNUOCWOR@@ fi  	

 )) yaw_yap.pmet = yaw_yap DNA ) 'YOM' = yaw_yap RO '1'=galf_yap ( EREHW 	

 ofni_tnemyap_db_t MORF 	

yaw_yap TCELES ( NI yaw_yap.pmet ( DNA 	

) ) pmet_wolfelas_mr_t MORF on_wolf TCELES ( NI TON on_wolf.pmet ( DNA 	

)etad_repo.wolf = etad_repo.pmet DNA on_hcnarb.wolf = on_hcnarb.pmet DNA 	

di_wolf.wolf = di_wolf.pmet DNA on_wolf.wolf = on_wolf.pmet EREHW 	

wolf SA wolfyap_mr_t MORF 	

 1 TCELES (STSIXE TON DNA disop@ = disop.pmet EREHW 	

pmet SA pmet_wolfyap_mr_t MORF 	

onhctab_pu@,'0',)(etadteg ,dnar_onwolf.pmet ,disop.pmet, )'0',galf_moc.pmet(LLUNSI 	

,on_tfihs.pmet ,galf_egnahcxe.pmet ,galf_etomer.pmet ,on_rehcuov.pmet ,omem.pmet 	

,nam_elas.pmet ,on_retnuoc.pmet ,di_repo.pmet ,etad_repo.pmet ,tnuoma_yap.pmet 	

,etar_nioc.pmet,)'BMR',on_nioc.pmet(LLUNSI ,on_piv.pmet ,on_drac.pmet ,yaw_lles.pmet 	

,yaw_yap.pmet ,on_hcnarb.pmet ,tnuoma_elas.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

)onhctab_pu,ccapiv_pu,emitpu ,dnar_onwolf ,disop ,galf_moc 	

,on_tfihs ,galf_egnahcxe ,galf_etomer ,on_rehcuov ,omem 	

,nam_elas ,on_retnuoc ,di_repo ,etad_repo ,tnuoma_yap 	

,etar_nioc ,on_nioc ,on_piv ,on_drac ,yaw_lles 	

,yaw_yap ,on_hcnarb ,tnuoma_elas ,on_wolf ,di_wolf (wolfyap_mr_t OTNI 	

 TRESNI 	

表wolf入转水流款付将以可，录记款付的入收易交非为且录记售销有没且的新 .2-- 	



中表wolf入转pmet_wolfyap和pmet_wolfelas将以可，单的录记有都中wolfyap和wolfelas在且录记新 .1 DNE-- 	

 1 = nyap@ tes		

 0 > TNUOCWOR@@ fi 	

))on_wolf.wolfelas_mr_t = on_wolf.pmet EREHW wolfelas_mr_t MORF on_wolf TCELES(STSIXE RO 		

) on_wolf.pmet_wolfelas_mr_t = on_wolf.pmet EREHW pmet_wolfelas_mr_t MORF on_wolf TCELES(STSIXE( DNA 		

)etad_repo.wolf = etad_repo.pmet DNA on_hcnarb.wolf = on_hcnarb.pmet DNA 			

di_wolf.wolf = di_wolf.pmet DNA on_wolf.wolf = on_wolf.pmet EREHW 			

wolf SA wolfyap_mr_t MORF 1 TCELES (STSIXE TON DNA disop@ = disop.pmet EREHW 	

pmet SA pmet_wolfyap_mr_t MORF 	

onhctab_pu@,'0',)(etadteg ,dnar_onwolf.pmet ,disop.pmet ,)'0',galf_moc.pmet(LLUNSI 		

,on_tfihs.pmet ,galf_egnahcxe.pmet ,galf_etomer.pmet ,on_rehcuov.pmet ,omem.pmet 		

,nam_elas.pmet ,on_retnuoc.pmet ,di_repo.pmet ,etad_repo.pmet ,tnuoma_yap.pmet 		

,etar_nioc.pmet,)'BMR',on_nioc.pmet(LLUNSI ,on_piv.pmet ,on_drac.pmet ,yaw_lles.pmet 		

,yaw_yap.pmet ,on_hcnarb.pmet ,tnuoma_elas.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

)onhctab_pu,ccapiv_pu,emitpu ,dnar_onwolf ,disop ,galf_moc 		

,on_tfihs ,galf_egnahcxe ,galf_etomer ,on_rehcuov ,omem 		

,nam_elas ,on_retnuoc ,di_repo ,etad_repo ,tnuoma_yap 		

,etar_nioc ,on_nioc ,on_piv ,on_drac ,yaw_lles 		

,yaw_yap ,on_hcnarb ,tnuoma_elas ,on_wolf ,di_wolf (wolfyap_mr_t OTNI TRESNI 	

pmet_wolfyap理处-- 	

0 = nyap@    tes 	

)))'','.',)'',':',)'',' ',)'','-',)121 ,)(etadteg,)32(rahc (trevnoc (ecalper (ecalper (ecalper (ecalper(mirtl(mirtr=onhctab_pu@ tceles 	

onhctab_pu,ccapiv_pu  dda  wolfyap_mr_t 次批理处次本-- 	


))on_wolf.pmet =on_wolf.wolfyap_mr_t EREHW wolfyap_mr_t MORF on_wolf TCELES(NI on_wolf RO 		

) on_wolf.pmet = on_wolf.pmetyap EREHW pmetyap sa pmet_wolfyap_mr_t MORF on_wolf TCELES(NI on_wolf( DNA 		

) etad_repo.wolf = etad_repo.pmet DNA 			

 on_meti.wolf = on_meti.pmet DNA on_hcnarb.wolf = on_hcnarb.pmet DNA 			

 di_wolf.wolf = di_wolf.pmet DNA on_wolf.wolf = on_wolf.pmet EREHW 			

wolf SA wolfelas_mr_t MORF 1 TCELES (STSIXE TON DNA disop@ = disop.pmet EREHW 	

 pmet SA pmet_wolfelas_mr_t MORF 	

on_teehs_ceps,)(etadteg ,dnar_onwolf.pmet ,disop.pmet ,nats_rhc.pmet 		

,nats_n.pmet ,ecirp_ni.pmet ,tma_ferp.pmet ,galf_ceps.pmet ,)'0',galf_moc.pmet(LLUNSI 		

,on_tfihs.pmet ,galf_etomer.pmet ,etad_repo.pmet ,on_retnuoc.pmet ,nam_elas.pmet 		

,di_repo.pmet ,yaw_lles.pmet ,yenom_elas.pmet ,ytnq_elas.pmet ,ecirp_elas.pmet 		

,ecirp_ecruos.pmet ,on_meti.pmet ,on_hcnarb.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

)on_teehs_ceps,emitpu ,dnar_onwolf ,disop , nats_rhc 		

,nats_n ,ecirp_ni ,tma_ferp ,galf_ceps ,galf_moc 		

,on_tfihs ,galf_etomer ,etad_repo ,on_retnuoc ,nam_elas 		

,di_repo ,yaw_lles ,yenom_elas ,ytnq_elas ,ecirp_elas 		

,ecirp_ecruos ,on_meti ,on_hcnarb ,on_wolf ,di_wolf (wolfelas_mr_t OTNI TRESNI 	

 pmet_wolfelas理处-- 	

中表wolf入转pmet_wolfyap和pmet_wolfelas将以可，单的录记有都中wolfyap和wolfelas在且录记新 .1-- 	

据数移转-- 	


)on_hcnarb.ROrre_wolfyap_mr_t  = on_hcnarb.pmet_wolfyap_mr_t     				

dna on_wolf.ROrre_wolfyap_mr_t = on_wolf.pmet_wolfyap_mr_t 					

 dna disop@ = disop EREHW   			

 ROrre_wolfyap_mr_t morf   			

 1 1 pot TCELES( STSIXE erehw pmet_wolfyap_mr_t ETELED 	

除删单整-- 	


)on_hcnarb.ROrre_wolfelas_mr_t  = on_hcnarb.pmet_wolfelas_mr_t     				

dna on_wolf.ROrre_wolfelas_mr_t = on_wolf.pmet_wolfelas_mr_t 					

 dna disop@ = disop EREHW   			

 ROrre_wolfelas_mr_t morf   			

 1 1 pot TCELES( STSIXE erehw pmet_wolfelas_mr_t ETELED 	

除删单整-- 	


on_hcnarb.vton = on_hcnarb.pmet DNA on_wolf.vton = on_wolf.pmet DNA disop@ = disop.pmet EREHW 	

vton sa )disop@ = disop.rorre_wolfelas_mr_t EREHW ROrre_wolfelas_mr_t MORF on_hcnarb.rorre_wolfelas_mr_t ,on_wolf.rorre_wolfelas_mr_t TCELES( 	

, pmet SA pmet_wolfyap_mr_t MORF 	

'构机或号货效无有含' ,disop.pmet ,)'0',galf_moc.pmet(LLUNSI 		

,on_tfihs.pmet ,galf_egnahcxe.pmet ,galf_etomer.pmet ,on_rehcuov.pmet ,omem.pmet 		

,nam_elas.pmet ,on_retnuoc.pmet ,di_repo.pmet ,etad_repo.pmet ,tnuoma_yap.pmet 		

,etar_nioc.pmet,)'BMR',on_nioc.pmet(LLUNSI ,on_piv.pmet ,on_drac.pmet ,yaw_lles.pmet 		

,yaw_yap.pmet ,on_hcnarb.pmet ,tnuoma_elas.pmet ,on_wolf.pmet ,di_wolf.pmet tcnitsid TCELES 	

)ofni_rorre ,disop ,galf_moc ,on_tfihs ,galf_egnahcxe ,galf_etomer ,on_rehcuov ,omem 		

,nam_elas ,on_retnuoc ,di_repo ,etad_repo ,tnuoma_yap ,etar_nioc ,on_nioc ,on_piv ,on_drac ,yaw_lles 		

,yaw_yap ,on_hcnarb ,tnuoma_elas ,on_wolf ,di_wolf (rorre_wolfyap_mr_t OTNI TRESNI 	

除移单整,单的构机效无有含包除移-- 	


on_hcnarb.vton = on_hcnarb.pmet DNA disop@ = disop.pmet EREHW 	

vton sa ) ) on_hcnarb.VtoN = on_hcnarb.ofni_hcnarb_db_t EREHW ofni_hcnarb_db_t MORF on_hcnarb TCELES (STSIXE TON RO		

 llun si on_hcnarb.vton EREHW VtoN sa PMET_wolfelas_mr_t MORF on_hcnarb.VtoN TCELES ( 	

,pmet sa pmet_wolfelas_mr_t MORF 	

on_teehs_ceps,'构机效无有含' ,disop.pmet ,nats_rhc.pmet 		

,nats_n.pmet ,ecirp_ni.pmet ,tma_ferp.pmet ,galf_ceps.pmet ,)'0',galf_moc.pmet(LLUNSI 		

,on_tfihs.pmet ,galf_etomer.pmet ,etad_repo.pmet ,on_retnuoc.pmet ,nam_elas.pmet 		

,di_repo.pmet ,yaw_lles.pmet ,yenom_elas.pmet ,ytnq_elas.pmet ,ecirp_elas.pmet 		

,ecirp_ecruos.pmet ,on_meti.pmet ,on_hcnarb.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

)on_teehs_ceps, ofni_rorre ,disop ,nats_rhc ,nats_n ,ecirp_ni ,tma_ferp ,galf_ceps ,galf_moc ,on_tfihs		

 ,galf_etomer ,etad_repo ,on_retnuoc ,nam_elas ,di_repo ,yaw_lles ,yenom_elas ,ytnq_elas		

 ,ecirp_elas ,ecirp_ecruos ,on_meti ,on_hcnarb ,on_wolf ,di_wolf (rorre_wolfelas_mr_t OTNI TRESNI 	

除移单整,单的构机效无有含包除移-- 	


on_wolf.vton = on_wolf.pmet DNA disop@ = disop.pmet EREHW 	

vton sa ) ) on_meti.VtoN = oN_meti.ofni_meti_db_t EREHW ofni_meti_db_t MORF oN_meti TCELES (STSIXE TON RO llun si on_meti.vton EREHW 		

VtoN sa pmet_wolfelas_mr_t MORF on_wolf.VtoN TCELES ( 		

, pmet SA pmet_wolfelas_mr_t MORF 	

on_teehs_ceps,'号货效无有含' ,disop.pmet ,nats_rhc.pmet 		

,nats_n.pmet ,ecirp_ni.pmet ,tma_ferp.pmet ,galf_ceps.pmet ,)'0',galf_moc.pmet(LLUNSI 		

,on_tfihs.pmet ,galf_etomer.pmet ,etad_repo.pmet ,on_retnuoc.pmet ,nam_elas.pmet 		

,di_repo.pmet ,yaw_lles.pmet ,yenom_elas.pmet ,ytnq_elas.pmet ,ecirp_elas.pmet 		

,ecirp_ecruos.pmet ,on_meti.pmet ,on_hcnarb.pmet ,on_wolf.pmet ,di_wolf.pmet TCELES 	

)on_teehs_ceps,ofni_rorre ,disop ,nats_rhc ,nats_n ,ecirp_ni ,tma_ferp ,galf_ceps ,galf_moc ,on_tfihs ,galf_etomer 		

 ,etad_repo ,on_retnuoc ,nam_elas ,di_repo ,yaw_lles ,yenom_elas ,ytnq_elas ,ecirp_elas 		

,ecirp_ecruos ,on_meti ,on_hcnarb ,on_wolf ,di_wolf (rorre_wolfelas_mr_t OTNI TRESNI 	

单的号货效无有含包除移-- 	



))csed on_wolf yb redro on_meti.pmet = onmeti_dlo erehw wolf_etadpu_meti_db_t morf on_wolf 1 pot tceles(      	

 > )csed on_wolf yb redro on_meti.pmet = onmeti_wen erehw wolf_etadpu_meti_db_t morf on_wolf 1 pot tceles(( ton 	

 dna onmeti_dlo.meti = on_meti.pmet EREHW 	

meti ) 0 > )onmeti_wen(NEL DNA 0 > )onmeti_dlo(NEL EREHW wolf_etadpu_meti_db_t MORF onmeti_wen ,onmeti_dlo TCELES(		

,pmet pmet_wolfelas_mr_t MORF 	

onmeti_wen.meti = on_meti TES 	

pmet ETADPU 	

码编品商的后改修号货新更-- 	


 ) etad_repo ,on_hcnarb ,on_wolf ,di_wolf YB PUORG 	

 pmet_wolfyap_mr_t MORF 	

 )on_moc(NIM TCELES(NI TON on_moc DNA disop@ = disop EREHW 	

 pmet_wolfyap_mr_t ETELED 	


 ) etad_repo ,on_meti ,on_hcnarb ,on_wolf ,di_wolf YB PUORG 	

 pmet_wolfelas_mr_t MORF 	

 )on_moc(NIM TCELES(NI TON on_moc DNA disop@ = disop EREHW 	

 pmet_wolfelas_mr_t ETELED 	

 据数复重除删-- 	

NIGEB 

 ) ) di_repo.wolf = di_repo.pmet DNA etad_repo.wolf = etad_repo.pmet DNA on_hcnarb.wolf = on_hcnarb.pmet DNA	

 di_wolf.wolf = di_wolf.pmet DNA on_wolf.wolf = on_wolf.pmet EREHW wolf sa wolfyap_mr_t MORF 1 TCELES (STSIXE TON DNA	

 disop@ = disop.pmet EREHW pmet sa pmet_wolfyap_mr_t MORF 1 TCELES (STSIXE FI 

水流款付新-- 


etad_repo.wolf = etad_repo.pmet DNA disop@ = disop.pmet DNA on_hcnarb.pmet = on_hcnarb.wolf DNA on_wolf.pmet = on_wolf.wolf EREHW 

wolf SA wolfyap_mr_t , pmet SA pmet_wolfyap_mr_t MORF 

pmet_wolfyap_mr_t ETELED 


etad_repo.wolf = etad_repo.pmet DNA disop@ = disop.pmet DNA on_hcnarb.pmet = on_hcnarb.wolf DNA on_wolf.pmet = on_wolf.wolf EREHW 

wolf SA wolfelas_mr_t ,pmet SA pmet_wolfelas_mr_t MORF 

pmet_wolfelas_mr_t ETELED 

息信水流旧除删-- 



 DNE 

)1>)*(TNUOC GNIVAH galf_moc ,)'',on_tfihs(LLUNSI ,galf_egnahcxe ,galf_etomer ,on_rehcuov ,omem ,nam_elas 		

,on_retnuoc ,di_repo ,etad_repo ,tnuoma_yap ,etar_nioc ,on_nioc ,on_piv ,on_drac ,yaw_lles ,yaw_yap 		

,on_hcnarb ,tnuoma_elas ,on_wolf ,di_wolf ,disop YB PUORG pmet_wolfyap_mr_t MORF )on_moc(XAM TCELES ( ni on_moc EREHW 	

 pmet_wolfyap_mr_t ETELED 	

 NIGEB 

)1>)*(TNUOC GNIVAH galf_moc ,)'',on_tfihs(LLUNSI ,galf_egnahcxe ,galf_etomer ,on_rehcuov ,omem ,nam_elas 	

,on_retnuoc ,di_repo ,etad_repo ,tnuoma_yap ,etar_nioc ,on_nioc ,on_piv ,on_drac ,yaw_lles ,yaw_yap 	

,on_hcnarb ,tnuoma_elas ,on_wolf ,di_wolf ,disop YB PUORG pmet_wolfyap_mr_t MORF )*(TNUOC TCELES (STSIXE ELIHW 


 DNE 

)1>)*(TNUOC GNIVAH galf_moc,)'',on_teehs_ceps(llunsi,)'',galf_ceps(LLUNSI ,)'',on_tfihs(LLUNSI 		

,galf_etomer ,etad_repo ,on_retnuoc ,nam_elas ,di_repo ,yaw_lles ,yenom_elas ,ytnq_elas ,ecirp_elas ,ecirp_ecruos 		

 ,on_meti ,on_hcnarb ,on_wolf ,di_wolf ,disop YB PUORG pmet_wolfelas_mr_t MORF )on_moc(XAM TCELES ( ni on_moc EREHW 	

 pmet_wolfelas_mr_t ETELED 	

 NIGEB 

)1>)*(TNUOC GNIVAH galf_moc ,)'',on_teehs_ceps(llunsi,)'',galf_ceps(LLUNSI ,)'',on_tfihs(LLUNSI 	

,galf_etomer ,etad_repo ,on_retnuoc ,nam_elas ,di_repo,yaw_lles ,yenom_elas ,ytnq_elas ,ecirp_elas ,ecirp_ecruos 	

 ,on_meti ,on_hcnarb ,on_wolf ,di_wolf ,disop YB PUORG pmet_wolfelas_mr_t MORF )*(TNUOC TCELES (STSIXE ELIHW 

。录记的同相全完除删 fyganhz-- 

)4(rahcrav on_hcnarb@  		

,)02(rahcrav on_wolf@  		

,)01(rahcrav etad_ranul@  		

,regetni       nyap@  		

,)81(rahcrav onhctab_pu@  eralced 

NIGEB

SA

)005(RAHCRAV disop@ 

 atad_snart_sop_rp ERUDECORP ETAERC



og

atad_snart_sop_rp erudecorp pord  

)'atad_snart_sop_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_rm_daysum(MS).sql^^^^

dne

nruter  

demuSyaDeBot_rucl etacollaed  

demuSyaDeBot_rucl esolc  

:rorreym


dne  

kaerb    

后最到已针指，败失取读 --    

    

esle    

dne    

dne      

rorreym otog 0 =! rorre@@ fi          

etaDrepo_sl@=etad_repo dna ONmeti_sl@=on_meti dna ONhcnarb_sl@=on_hcnarb --          

 di_wolf@=di_wolf erehw            

  '0' =   galf_moc            

 , '1' = 1rehto            

    ,tmAruc_nl@ + tmAerp_nl@ = tma_erp            

,ytQruc_nl@ + ytQerp_nl@ = ytq_erp tes    	

 musyad_mr_t etadpu          

72-20-3102 nhihs yb deifidom  致一不据数部分总致导，结日后传上先止防  '0' =   galf_moc --  	

42-50-5002 sjuw yb deifidom 理处结日做已录记 '1' = 1rehto --  	

额金计不送赠 --  	

额金、量数减冲次上的表结日售销品商台前新更 --          

          

dne          

rorreym otog 0 =! rorre@@ fi                

)'0',yaw_elas@,'售销台前',on_tsucpus@,'1001'                                     

,'-','TP',ONhcnarb_sl@,tmAruc_nl@,0,0,ONmeti_sl@,etaDrepo_tdl@( seulav                    

)galf_teehstsoc,yaw_elas,omem,on_tsucpus,di_repo                                     

,on_bd,on_snart,on_hcnarb,tma_teehs,ecirp,ytq_laer,on_meti,etad_repo(wolf_mi_t tresni                    

esle                

)'0','售销台前',etar_yl_pus@,yaw_elas@,on_tsucpus@,'1001'                                     

,'-','TP',ONhcnarb_sl@,tmAruc_nl@,0,0,ONmeti_sl@,etaDrepo_tdl@( seulav                    

)galf_teehstsoc,omem,etar_yl_pus,yaw_elas,on_tsucpus,di_repo                                     

,on_bd,on_snart,on_hcnarb,tma_teehs,ecirp,ytq_laer,on_meti,etad_repo(wolf_mi_t tresni                    

销代率扣和营联-- )'F' = yaw_elas@ ro 'C' = yaw_elas@( fi                

ONmeti_sl@ = on_meti erehw ofni_meti_db_t morf                	

galf_pus_meti=yaw_elas@,tsucpus_niam = on_tsucpus@ tceles                	

esle        	

ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw                    	

ecirp_hcnarb_cp_t morf yaw_elas=yaw_elas@,on_tsucpus = on_tsucpus@ tceles                	

)ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf 1 tceles(stsixe fi                

60-10-6002 sjuw yb deifidom--                

nigeb          

esle          

dne          

dne                

rorreym otog 0 =! rorre@@ fi                    

)'0',yaw_elas@,'售销台前',on_tsucpus@,'1001'                                         

,'-','TP',ONhcnarb_sl@,tmAruc_nl@,crPruc_nl@,ytQruc_nl@,ONmeti_sl@,etaDrepo_tdl@(  seulav                        

)galf_teehstsoc,yaw_elas,omem,on_tsucpus,di_repo                                         

,on_bd,on_snart,on_hcnarb,tma_teehs,ecirp,ytq_laer,on_meti,etad_repo(wolf_mi_t tresni                        

esle                    

)'0','售销台前',etar_yl_pus@,yaw_elas@,on_tsucpus@,'1001'								          

                             ,'-','TP',ONhcnarb_sl@,tmAruc_nl@,crPruc_nl@,ytQruc_nl@,ONmeti_sl@,etaDrepo_tdl@(  seulav                        

)galf_teehstsoc,omem,etar_yl_pus,yaw_elas,on_tsucpus,di_repo                                         

,on_bd,on_snart,on_hcnarb,tma_teehs,ecirp,ytq_laer,on_meti,etad_repo(wolf_mi_t tresni                        

销代率扣和营联-- )'F' = yaw_elas@ ro 'C' = yaw_elas@( fi                    

          

ONmeti_sl@ = on_meti erehw ofni_meti_db_t morf    		            

galf_pus_meti=yaw_elas@,tsucpus_niam = on_tsucpus@ tceles                    	

esle          	

ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw                    	

ecirp_hcnarb_cp_t morf yaw_elas=yaw_elas@,on_tsucpus = on_tsucpus@ tceles                    	

)ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf 1 tceles(stsixe fi                  

60-10-6002 sjuw yb deifidom--                  

nigeb                

esle                

dne                

rorreym otog 0 =! rorre@@ fi    	               

ONhcnarb_sl@,crPruc_nl@,ytQruc_nl@,ONmeti_sl@,etaDrepo_tdl@ wolf_metibmoc_rp cexe                    

nigeb                

))'1','7'( ni ats_enibmoc dna ONmeti_sl@=on_meti erehw ofni_meti_db_t morf 1 tceles(stsixe fi esle                

上同理处则品割分鲜生是品商分成如，水流写品商份成将则是，品商工加鲜生为否是断判 --                

水流写品商份成将则是，品商合组销促为否是断判 --                

dne                

                  

rorreym otog 0 =! rorre@@ fi  		

)ytQruc_nl@,crPtsoc_nl@,crPruc_nl@,gf_ONmeti_sl@,ytQruc_nl@,crPruc_nl@,onmeti_sl@,'6',ONhcnarb_sl@,etaDrepo_sl@( seulav    		

)ytq_sc,ecirp_tsoc_sc,ecirp_elas_sc,on_meti_sc,ytq,ecirp_elas,on_meti,epyt_snart,on_hcnarb,etad_repo(wolf_sc_mi_t tresni  		

crPpmt_nl@=crPtsoc_nl@ tceles 0>crPpmt_nl@ fi                  

onmeti_sl@=on_meti dna ONhcnarb_sl@=on_hcnarb erehw kcots_hcnarb_mi_t morf tsoc_gva=crPpmt_nl@ tceles                  

                  

   rorreym otog 0 =! rorre@@ fi                  

)'0',yaw_elas@,)31,1,ONmeti_sl@(gnirtsbus+'解分',on_tsucpus@,'1001'                                

,'-','TP',ONhcnarb_sl@,tmAruc_nl@,crPruc_nl@,ytQruc_nl@,gf_ONmeti_sl@,etaDrepo_tdl@( seulav                        

)galf_teehstsoc,yaw_elas,omem,on_tsucpus,di_repo                                         

,on_bd,on_snart,on_hcnarb,tma_teehs,ecirp,ytq_laer,on_meti,etad_repo(wolf_mi_t tresni                        

esle                    

)'0',)31,1,ONmeti_sl@(gnirtsbus+'解分',etar_yl_pus@,yaw_elas@,on_tsucpus@,'1001'                                         

,'-','TP',ONhcnarb_sl@,tmAruc_nl@,crPruc_nl@,ytQruc_nl@,gf_ONmeti_sl@,etaDrepo_tdl@( seulav                        

)galf_teehstsoc,omem,etar_yl_pus,yaw_elas,on_tsucpus,di_repo                                         

,on_bd,on_snart,on_hcnarb,tma_teehs,ecirp,ytq_laer,on_meti,etad_repo(wolf_mi_t tresni                        

销代率扣和营联-- )'F' = yaw_elas@ ro 'C' = yaw_elas@( fi                    

gf_ONmeti_sl@ = on_meti erehw ofni_meti_db_t morf    		            

galf_pus_meti=yaw_elas@,tsucpus_niam = on_tsucpus@ tceles                    	

esle            	

gf_ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw                    	

ecirp_hcnarb_cp_t morf yaw_elas=yaw_elas@,on_tsucpus = on_tsucpus@ tceles                    	

)gf_ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf 1 tceles(stsixe fi                    

60-10-6002 sjuw yb deifidom--                    

nigeb                

llun ton si gf_ONmeti_sl@ dna ''>< gf_ONmeti_sl@ fi                

'6'=ats_enibmoc.ofni_meti_db_t dna ONmeti_sl@= on_meti.tilpsbmoc_meti_db_t dna on_meti_bmoc.tilpsbmoc_meti_db_t=on_meti.ofni_meti_db_t erehw ofni_meti_db_t,tilpsbmoc_meti_db_t morf ecirp.ofni_meti_db_t=crPtsoc_nl@,)'',on_meti_bmoc(llunsi=gf_ONmeti_sl@ tceles                

''= gf_ONmeti_sl@ tceles                

)02(rahcrav gf_ONmeti_sl@ eralced                

水流写品商料原将则是，品商割分鲜生为否是断判 --                

                

ytQruc_nl@ / tmAruc_nl@ = crPruc_nl@ tceles                

量数减冲该应次本 / 额金减冲该应次本 = 价单减冲次本 --                

nigeb            

0 >< ytQruc_nl@ fi            

            

)901,)801,)(etadteg,)8(rahc(trevnoc+' '+)901,)121,etaDrepo_sl@,emitetad(trevnoc,)11(rahc(trevnoc,emitetad(trevnoc=etaDrepo_tdl@ tceles            

间时前当的结日+期日生发售销 , dd-mm-yyyy=121 :式格间时期日换转 --            

nigeb        

0 >< )4,tmAruc_nl@(dnuor RO 0 >< )4,ytQruc_nl@(dnuor fi        

        

额金计不送赠 --   tmAerp_nl@-)tmAter_nl@-tmAelas_nl@( = tmAruc_nl@ tceles        

ytQerp_nl@-)ytQvig_nl@+ytQter_nl@-ytQelas_nl@( = ytQruc_nl@ tceles        

减冲次上 - )送赠台前+货退台前-售销台前( = )额金/量数(减冲该应次本 --        

nigeb    

功成取读 --  0=sutatS_hctef@@ fi    

rorreym otog 0 =! rorre@@ fi    

etar_yl_pus@      

,tmAerp_nl@      

,ytQerp_nl@      

,crPelas_nl@      

,tmAvig_nl@      

,tmAter_nl@      

,tmAelas_nl@      

,ytQvig_nl@      

,ytQter_nl@      

,ytQelas_nl@      

,etaDrepo_sl@      

,ONmeti_sl@      

,ONhcnarb_sl@      

,di_wolf@      

otni demuSyaDeBot_rucl hctef    

取读 --    

nigeb  

1=1 elihw  

rorreym otog 0 =! rorre@@ fi  

demuSyaDeBot_rucl nepo  

开打 --

  

dne  

ylno daer rof        

)'0' = 1rehto ro llun si 1rehto( dna hcnarb_t@ ekil on_hcnarb erehw         

musyad_mr_t morf         

etar_yl_pus,tma_erp,ytq_erp,ecirp_elas,tma_vig,tma_ter,tma_elas             

,ytq_vig,ytq_ter,ytq_elas,etad_repo,on_meti,on_hcnarb,di_wolf tceles      

rof rosruc demuSyaDeBot_rucl eralced      

)tma_ter-tma_elas >< tma_erp RO ytq_vig+ytq_ter-ytq_elas >< ytq_erp( --      


)llun ton si etadnim_rhc@( htiW dnE -- dne      

galf_ceps,)021,etad_repo,)01(rahc(trevnoc,on_meti,on_hcnarb yb puorg           

)hcnarb_t@ ekil on_hcnarb(               

dna )'C' = yaw_lles ro )'' > )galf_ceps(mirtl dna llun ton si galf_ceps((       	

 dna ) )021 ,'00:00:00 ' + etadnim_rhc@,emitetad(trevnoc => etad_repo( erehw wolfelas_mr_t morf           

)dne tma_ferp esle )dne yenom_elas esle tma_ferp neht 0 = yenom_elas nehw esac( neht 'C' nehw tma_ferp- neht 'B' nehw yaw_lles esac(mus               

,)dne yenom_elas esle 0 neht 'C' nehw yenom_elas- neht 'B' nehw yaw_lles esac(mus               

,)dne ytnq_elas esle ytnq_elas- neht 'B' nehw yaw_lles esac(mus               

,galf_ceps sa )dne galf_ceps esle 'sz' neht 'C' = )yaw_lles(xam nehw esac(				

,)021,etad_repo,)01(rahc(trevnoc,on_meti,on_hcnarb tceles            

)tma_tcd,tma_elas,ytq_elas,epyt_tcd,etad_repo,on_meti,on_hcnarb( musyad_tnuocsid_ad_t otni tresni         

      

hcnarb_t@ ekil on_hcnarb dna etadnim_rhc@ => etad_repo erehw musyad_tnuocsid_ad_t  morf eteled         

nigeb      

理处才据数结日有 -- )llun ton si etadnim_rhc@( fi      


)tma_ter-tma_elas >< tma_erp RO ytq_vig+ytq_ter-ytq_elas >< ytq_erp( --        

)'0' = 1rehto ro llun si 1rehto( dna hcnarb_t@ ekil on_hcnarb erehw        

musyad_mr_t morf )etad_repo(nim = etadnim_rhc@ tceles      

      

'on_hcnarb_g'=di_rav_sys erehw metsys_sys_t morf '%'+eulav_rav_sys=hcnarb_t@ tceles      

nigeb  

esle  

dne  

ylno daer rof  )                   

)                             

))'4'=epyt_edart ro '0'=epyt_edart( dna '0' = ytreporp EREHW ofni_hcnarb_db_t MORF on_hcnarb tceles( ni )2,1,on_hcnarb(gnirtsbus                              

 dna '3' = ytreporp (                            

ro '2' = ytreporp EREHW	                     

  ofni_hcnarb_db_t MORF on_hcnarb TCELES(                   

 ni )on_hcnarb(mirtr                   

 dna )'0' = 1rehto ro llun si 1rehto( erehw            

musyad_mr_t morf            

etar_yl_pus,tma_erp,ytq_erp,ecirp_elas,tma_vig,tma_ter,tma_elas               

,ytq_vig,ytq_ter,ytq_elas,etad_repo,on_meti,on_hcnarb,di_wolf tceles        

 rof rosruc demuSyaDeBot_rucl eralced      

)tma_ter-tma_elas >< tma_erp RO ytq_vig+ytq_ter-ytq_elas >< ytq_erp( --      

        

束结----------------------------------------------总汇利让 SOP --      

)llun ton si etadnim_rhc@( htiW dnE -- dne      

galf_ceps,)021,etad_repo,)01(rahc(trevnoc,on_meti,on_hcnarb yb puorg               

) )  )                             

))'4'=epyt_edart ro '0'=epyt_edart( dna '0' = ytreporp EREHW ofni_hcnarb_db_t MORF on_hcnarb tceles( ni )2,1,on_hcnarb(gnirtsbus                              

 dna '3' = ytreporp (                            

ro '2' = ytreporp EREHW ofni_hcnarb_db_t MORF on_hcnarb TCELES                      

(   ni )on_hcnarb(mirtr(                  

dna )'C' = yaw_lles ro )'' > )galf_ceps(mirtl dna llun ton si galf_ceps((          	

 dna ))021 ,'00:00:00 ' + etadnim_rhc@,emitetad(trevnoc => etad_repo( erehw wolfelas_mr_t morf      	

)dne tma_ferp esle )dne yenom_elas esle tma_ferp neht 0 = yenom_elas nehw esac( neht 'C' nehw tma_ferp- neht 'B' nehw yaw_lles esac(mus                    

,)dne yenom_elas esle 0 neht 'C' nehw yenom_elas- neht 'B' nehw yaw_lles esac(mus                    

,)dne ytnq_elas esle ytnq_elas- neht 'B' nehw yaw_lles esac(mus                    

,galf_ceps sa )dne galf_ceps esle 'sz' neht 'C' = )yaw_lles(xam nehw esac(					

,)021,etad_repo,)01(rahc(trevnoc,on_meti,on_hcnarb tceles             

)tma_tcd,tma_elas,ytq_elas,epyt_tcd,etad_repo,on_meti,on_hcnarb( musyad_tnuocsid_ad_t otni tresni          

  利让SOP总汇新重 --          

      

)              

)))'4'=epyt_edart ro '0'=epyt_edart( dna '0' = ytreporp EREHW ofni_hcnarb_db_t MORF on_hcnarb tceles( ni )2,1,on_hcnarb(gnirtsbus dna '3' = ytreporp(                     

ro '2' = ytreporp erehw ofni_hcnarb_db_t morf on_hcnarb tceles(             

 ni )on_hcnarb(mirtr dna etadnim_rhc@ => etad_repo erehw musyad_tnuocsid_ad_t morf eteled         

据数有已除删 --         

nigeb      

理处才据数结日有 -- )llun ton si etadnim_rhc@( fi      

)                   

)       			

)                                 

))'4'=epyt_edart ro '0'=epyt_edart( dna '0' = ytreporp EREHW ofni_hcnarb_db_t MORF on_hcnarb tceles( ni )2,1,on_hcnarb(gnirtsbus                                 

 dna '3' = ytreporp.ofni_hcnarb_db_t (                                

ro '2' = ytreporp.ofni_hcnarb_db_t (				      			

dna ) on_hcnarb.musyad_mr_t = on_hcnarb.ofni_hcnarb_db_t ( EREHW	                     

  ofni_hcnarb_db_t MORF on_hcnarb TCELES(                   

stsixe                 

 dna )'0' = 1rehto ro llun si 1rehto( erehw          

musyad_mr_t morf )etad_repo(nim = etadnim_rhc@ tceles      

)tma_ter-tma_elas >< tma_erp RO ytq_vig+ytq_ter-ytq_elas >< ytq_erp( --      

22-20-5002 sjuw yb deifidoM 算计计统总汇利让品商 --      

始开----------------------------------------------总汇利让 SOP --      

nigeb  

 '1' = )'detubirtsid_si'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys tceles( fi  

部分SOP  01-10-5002  cgnauh yb deifidoM --  

库仓管托括包还部总在 --  

库仓的构机本于限只 --  

0 >< 量数减冲该应次本 :)rosruc(品商-库仓的结日做需 --  



)4,61(ciremun crPpmt_nl@    

,)4,61(ciremun crPtsoc_nl@    

,)61(ciremun     di_wolf@    

,)4,61(ciremun etar_yl_pus@    

,)8(rahcrav   yaw_elas@    

,)01(rahcrav  on_tsucpus@    

,)01(rahcrav etadnim_rhc@    

,)01(rahcrav   hcnarb_t@    

,)01(rahc etadrahc_t@    

,)4,61(ciremun ytqelttes_t@    

kcots tnerruc--   ,)4,61(ciremun pmet_nl@    

kcots tnerruc-- ,  )4,61(ciremun kcotsruc_nl@    

)型emiTetad(期日售销 --   ,  emitetad etaDrepo_tdl@    

价单减冲次本 --   ,)4,61(ciremun crPruc_nl@    

额金减冲该应次本 --   ,)4,61(ciremun tmAruc_nl@    

量数减冲该应次本 --   ,)4,61(ciremun ytQruc_nl@    

额金减冲次上 --   ,)4,61(ciremun tmAerp_nl@    

量数减冲次上 --   ,)4,61(ciremun ytQerp_nl@    

价单售销 --    ,)4,61(ciremun crPelas_nl@    

额金送赠 --   ,)4,61(ciremun tmAvig_nl@    

额金货退 --   ,)4,61(ciremun tmAter_nl@    

额金售销 --    ,)4,61(ciremun tmAelas_nl@    

量数送赠 --   ,)4,61(ciremun ytQvig_nl@    

量数货退 --   ,)4,61(ciremun ytQter_nl@    

量数售销 --    ,)4,61(ciremun ytQelas_nl@    

期日售销 --      ,)01(rahc etaDrepo_sl@    

码编品商 --        ,)02(rahc ONmeti_sl@    

码编库仓 --     ,)6(rahc ONhcnarb_sl@ eralced

nigeb

sa

musyad_mr_rp erudecorp etaerc


og

musyad_mr_rp erudecorp pord  

)'musyad_mr_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_rm_vip_addsav(MS).sql^^^^



dne

 nruter	

	'功成'=nruter@ tceles	

志日入插--	

	

		  ) yaw_yap@ , tma_tcaf@ ,'0',0, '值充程过储存' , 0 , dlo_tma_gnivas@, )(etadteg , '1001' , tma_dda@ , DI_drac@,on_hcnarb@ ( seulav	

 )yaw_yap,tnuoc_laer_sulp,galf_moc,tma_laudiser,1rehto,1mun,tnuoc_dlo,etad_repo,di_repo,tnuoc_sulp,di_drac,on_hcnarb ( drocer_sulp_gnivas_mr_t OTNI TRESNI	

水流值充入插--	


di_drac@=di_drac erehw  tma_laudiser@=tma_laudiser tes  ofni_piv_mr_t etadpu	

额余卡值储改修--	

			

)tma_laudiser@(tpyrcne_teg_f.obd=tma_laudiser@ tceles	

)00001*tma_gnivas@,)02(rahcrav(trevnoc=tma_laudiser@ tceles	

密加--	


tma_dda@ + dlo_tma_gnivas@=tma_gnivas@ tceles	

di_drac@=di_drac erehw )kcolon(htiw ofni_piv_mr_t morf )tma_laudiser(yrcsed_teg_f.obd=dlo_tma_gnivas@ tceles	

息信额余到得,息信值储员会询查--	

额余取--	

	

'00'=on_hcnarb@ tceles	

号编店分到得--	


	


dne		

nruter			

'在存不卡值储'=nruter@ tceles			

nigeb		

0=tnuoc_ll@ fi	

di_drac@=di_drac erehw )kcolon(htiw ofni_piv_mr_t morf )1(tnuoc=tnuoc_ll@ tceles	


dne		

nruter			

'0为以可不额金值充'=nruter@ tceles			

nigeb		

 0=tma_dda@ fi	


0=tnuoc_ll@ tceles	

化始初--	

型字数额余卡值储--  )2,61(ciremun		tma_gnivas_ssalc@			

,)02(rahcrav		pmet@			

号编店分--			,)6(rahcrav	on_hcnarb@			

号票小--		,)02(rahcrav	 on_wolf@			

,)02(rahcrav	epyt_drac@			

,)02(rahcrav	on_drac@			

, tni		tnuoc_ll@			

型字数额余卡值储--  ,)2,61(ciremun		dlo_tma_gnivas@			

型字数额余卡值储--  ,)2,61(ciremun	 		tma_gnivas@			

额余卡值储--	,)02(rahcrav		tma_laudiser@ eralced	

 nigeb

值充别类和值充通普有只值充卡值储--

sa

值回返--		)tuptuo )001(rahcrav nruter@	

	号编sop--	,)01(rahcrav			di_sop@	

人荐推--	,)01(rahcrav       nam_elas@	

式方款付--	,)21(rahcrav        yaw_yap@	

额金款付际实-- ,)2,61(ciremun		tma_tcaf@	

额金值充-- ,)2,61(ciremun		tma_dda@	

别类个一充能只次每死制限，值充通普是就空为，号编别类--	,)21(rahcrav onslc_meti@	

di卡--		,)02(rahcrav di_drac@	

(vasdda_piv_mr_rp erudecorp etaerc


og

vasdda_piv_mr_rp erudecorp pord  

)'vasdda_piv_mr_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_rpt_ciceroni_itemcls(MS).sql^^^^

dne

troper# morf * tceles   

   

)' '''' tluafed )02(rahcrav omem dda troper# elbat retla'( cexe--   

)')0,)di_inorecic.a = di_inorecic.troper# erehw a '        

+'ytq_elas# morf )yenom_elas.a(mus tceles((llunsi = lla_ytq tes troper# etadpu'(cexe   

)'seulav htiw 0 tluafed )4,61(ciremun lla_ytq dda troper# elbat retla'( cexe   


 

 slcmeti_ruc etacollaed   

 slcmeti_ruc esolc   

dne   

slc_ruc@ otni slcmeti_ruc hctef  	

)'di_inorecic.troper# = di_inorecic.ytq_elas# dna '''+ slc_ruc@ + '''=onslc_meti.ytq_elas# erehw '			

+ ' ytq_elas# morf  yenom_elas.ytq_elas#=' + slc_ruc@ +  '_slc tes troper# etadpu'( cexe  	

)'seulav htiw 0 tluafed )4,61(ciremun ' + slc_ruc@ +  '_slc dda troper# elbat retla'( cexe  	

nigeb   

0=sutats_hctef@@ elihw	


slc_ruc@ otni slcmeti_ruc hctef    

slcmeti_ruc nepo    

onslc_meti yb redro ytq_elas# morf onslc_meti tcnitsid tceles        

rof rosruc slcmeti_ruc  eralced    

)6(rahcrav slc_ruc@ eralced    


)ytq_elas# morf di_inorecic tcnitsid tceles(ni ton di_inorecic erehw troper# morf eteled	


onslc_meti.ofni_meti_db_t,di_inorecic.yrotsih_nc_t yb puorg	

onslc_meti@ ekil onslc_meti.ofni_meti_db_t dna onhcnarb@ ekil on_hcnarb.wolfelas_mr_t dna	

ot_etad@ dna morf_etad@ neewteb etad_repo.wolfelas_mr_t dna	

oninorecic@ ekil di_inorecic.yrotsih_nc_t dna  '' >< )'',on_teehs_cic.wolfelas_mr_t(llunsi erehw	

)on_meti.wolfelas_mr_t = on_meti.ofni_meti_db_t( no ofni_meti_db_t nioj renni	

)on_teehs.yrotsih_nc_t = on_teehs_cic.wolfelas_mr_t( no yrotsih_nc_t nioj renni	

 wolfelas_mr_t morf	

ytq_elas# otni     

 yenom_elas sa ))dne 0 esle   		

yenom_elas.wolfelas_mr_t*1- neht 'D' = yaw_lles.wolfelas_mr_t  ro 'B'= yaw_lles.wolfelas_mr_t nehw   		

 yenom_elas.wolfelas_mr_t neht 'A'= yaw_lles.wolfelas_mr_t nehw esac((mus 	

,onslc_meti sa onslc_meti.ofni_meti_db_t,di_inorecic sa di_inorecic.yrotsih_nc_t tceles	


ofni_inorecic_db_t morf	

troper# otni    

 eman_inorecic,di_inorecic tceles	

nigeb

sa

)

 )6(rahcrav    onslc_meti@   

,)6(rahcrav      onhcnarb@   

,)02(rahcrav    oninorecic@   

,emitetad       ot_etad@   

,emitetad     morf_etad@   

(

slcmeti_inorecic_tpr_rp erudecorp etaerc


og

slcmeti_inorecic_tpr_rp erudecorp pord  

)'slcmeti_inorecic_tpr_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_get_prod_fun(MS).sql^^^^

dne


'0' tceles 	

0认默-- 	

 	

dne 	

nruter		

'1' tceles		

nigeb 	

'dlihc_ger_mem'=yek_nuf@ fi 	

卡子为册注持支，72407102--	


 dne 	

nruter		

'1' tceles		

nigeb 	

'dnibnu_mem'=yek_nuf@ fi 	


 dne 	

nruter		

'1' tceles		

nigeb 	

'sutats_khc_redroxw_teg'=yek_nuf@ fi    

 	

 dne 	

nruter		

'1' tceles		

nigeb 	

'tnuocsidpivenilffo'=yek_nuf@ fi 	

 	

 dne 	

nruter		

'1' tceles		

nigeb 	

'kcotsenilffokcehc'=yek_nuf@ fi 	

  	

 dne 	

nruter		

'1' tceles		

nigeb 	

'rehcuovtnuocsidenilno'=yek_nuf@ fi 	


扣折员会下线取上线  tnuocsidpivenilffo--

存库下线测检上线 kcotsenilffokcehc--

用使下线券惠优上线  rehcuovtnuocsidenilno		--

61606102--		

	

 nigeb

sa

)

 	)002(rahcravn yek_nuf@	

(

nuf_dorp_teg_fsxw_rp corp etaerc


og

nuf_dorp_teg_fsxw_rp erudecorp pord  

)'nuf_dorp_teg_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_get_prod_ver(MS).sql^^^^

dne

rev_dorp sa rev_dorp@,eman_dorp sa '9天扬' tceles	

同相称名lmx.ppAgifnoC和手助和量尽 eman_dorp--	

	

 dne	

)'',' 8V',rev_dorp@(ECALPER=rev_dorp@ tceles		

'noisreV_esaBataD'=di_rav_sys erehw metsys_sys_t morf eulav_rav_sys=rev_dorp@ tceles		

nigeb	

)'noisreV_esaBataD'=di_rav_sys erehw metsys_sys_t morf 1 tceles (stsixe fi	

'10105102'=rev_dorp@ tceles	

 )06(rahcravn rev_dorp@ eralced	


nigeb

sa

rev_dorp_teg_fsxw_rp corp etaerc


og

rev_dorp_teg_fsxw_rp erudecorp pord  

)'rev_dorp_teg_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_get_push_msg(MS).sql^^^^

dne 

   

gsm_hsup# morf * tceles   

束结成生--    

 1rosruc etacollaed 	

标游闭关--                   1rosruc esolc 	

 	

dne 	

 	中eman@,di@量变的义定前之入放据数的取获，行1移下向标游将--  eman_piv@			

 ,xes@ ,di_drac@ ,tnetnoc_gsm@ ,di_nepo@ ,di_wolf@ otni 1rosruc morf txen hctef		

 		

)				

eman_piv@ ,xes@ ,di_drac@					

 ,'' ,ynapmoc@ ,tnetnoc_gsm@ ,di_nepo@ ,di_wolf@					

( seulav 		

)							

eman_piv ,xes ,di_drac								

 ,omem ,rednes_gsm ,tnetnoc_gsm ,di_nepo ,di_wolf								

( gsm_hsup# otni tresni		

表时临入写--		

额余--)tma_laudiser@,'evas#',tnetnoc_gsm@(ECALPER=tnetnoc_gsm@ tceles		--

)xes@,'xes#',tnetnoc_gsm@(ECALPER=tnetnoc_gsm@ tceles		--

名户客-- )eman_piv@,'tsuc#',tnetnoc_gsm@(ECALPER=tnetnoc_gsm@ tceles		--

额金款付卡值储用使--)tma_tsilevas@,'siht_evas#',tnetnoc_gsm@(ECALPER=tnetnoc_gsm@ tceles		--

额金值充--)tma_tsilevas@,'tma_evas#',tnetnoc_gsm@(ECALPER=tnetnoc_gsm@ tceles		--

量变换替--		--

 		--

yap_dracevas@=tnetnoc_gsm@ tceles			--

 		esle 		--

 		evas_drac@=tnetnoc_gsm@ tceles			--

 		'4'=epyt_repo@ fi		--

款付 5，值充是 4 epyt_repo--		--

'士女'=xes@ tceles			--

esle 		--

'生先'=xes@ tceles			--

'男'=xes@ fi 		--

nigeb 	

据数取获功成否是断判--           0=sutats_hctef@@ elihw 	


	中eman@,di@量变的义定前之入放据数的取获，行1移下向标游将--  eman_piv@		

 ,xes@ ,di_drac@ ,tnetnoc_gsm@ ,di_nepo@ ,di_wolf@ otni 1rosruc morf txen hctef	

标游开打--                       1rosruc nepo	


''=)'',on_tsuc.a(llunsi dna ''><)'',dinepo.a(llunsi dna '0'=noiger.a erehw	

a wolf_xw_t_ssem morf	

eman_piv sa ''		

 , xes_piv '' ,di_drac '' ,ssem.a ,dinepo.a ,di_wolf.a tceles	

 lla noinu	

''><)'',dinepo.b(llunsi dna '0'=noiger.a erehw	

 di_drac.b=on_tsuc.a no b ofni_piv_mr_t nioj renni a wolf_xw_t_ssem morf	

eman_piv sa )'',eman_piv.b(llunsi		

 ,xes_piv.b ,di_drac.b ,ssem.a ,dinepo.a ,di_wolf.a tceles	


''><)'',dinepo.b(llunsi dna )'5'=epyt_repo.a  ( dna '0'=galf_dnes.a erehw		--

 di_drac.b=di_drac.a no b ofni_piv_mr_t nioj renni a egassem_piv_t_ssem morf		--

  tma_tsilevas.a,tma_laudiser sa )tma_laudiser.b(yrcsed_teg_f.obd,eman_piv sa )'',eman_piv.b(llunsi, xes_piv.b ,di_drac.b,		--

epyt_repo.a,dinepo.b,di_wolf.a tceles  	--

1rosruc标游义定--         rof rosruc 1rosruc eralced	

	

)4,61(ciremun tma_tsilevas@ eralced	

额余--)001(rahcravn tma_laudiser@ eralced	

)0004(rahcravn tnetnoc_gsm@	eralced	

)001(rahcravn epyt_repo@ eralced	

)001(rahcravn eman_piv@ eralced	

)001(rahcravn xes@ eralced	

)001(rahcravn di_drac@ eralced	

)001(rahcravn di_nepo@ eralced	

)0,81(ciremun di_wolf@ eralced	

容内成生--   

   

)   

)001(rahcravn eman_piv    

,)001(rahcravn xes    

,)001(rahcravn di_drac    

,)004(rahcravn omem    

,)001(rahcravn rednes_gsm    

,)0004(rahcravn tnetnoc_gsm    

,)001(rahcravn di_nepo    

,)0,81(ciremun di_wolf	

(gsm_hsup# elbat etaerc   

   

定固名列--   

注备，人知通，容内知通, DI NEPO,di_wolf:容内回返--   

   

dne   --

)2-)lav_sys_pmt@(NEL,lav_sys_pmt@(THGIR=yap_dracevas@ tceles		--

'1'=)1,lav_sys_pmt@(tfel DNA 0>)lav_sys_pmt@(NEL fi 	--

'yap_dracevas'=)di_rav_sys(MIRTR erehw metsys_sys_t_ssem morf )eulav_rav_sys(MIRTR=lav_sys_pmt@ 1 pot tceles 	--

nigeb   --

)'yap_dracevas'=)di_rav_sys(MIRTR erehw metsys_sys_t_ssem morf 1 tceles( stsixe fi   --

   --

dne   --

)2-)lav_sys_pmt@(NEL,lav_sys_pmt@(THGIR=evas_drac@ tceles		--

'1'=)1,lav_sys_pmt@(tfel DNA 0>)lav_sys_pmt@(NEL fi 	--

'evas_drac'=)di_rav_sys(MIRTR erehw metsys_sys_t_ssem morf )eulav_rav_sys(MIRTR=lav_sys_pmt@ 1 pot tceles 	--

nigeb   --

)'evas_drac'=)di_rav_sys(MIRTR erehw metsys_sys_t_ssem morf 1 tceles( stsixe fi   --

   --

'.临光次下您迎欢,持支的店本对您谢谢,evas#为额余内卡的您,siht_evas#为额金款付卡值储用使次本您'=yap_dracevas@ tceles   --

'.持支的店本对您谢谢,evas#为额余内卡的前目您,tma_evas#为额金值充次本您:xes#tsuc#的敬尊'=evas_drac@ tceles   --

   

dne   

remotsuc_sys_t morf ]eman[=ynapmoc@ 1 pot tceles	

nigeb   

)remotsuc_sys_t morf 1 tceles( stsixe fi   

''=ynapmoc@ tceles   

   

eulav的里表数参-- )0004(rahcravn lav_sys_pmt@ eralced   

)0004(rahcravn yap_dracevas@ eralced   

)0004(rahcravn evas_drac@ eralced   

)001(rahcravn ynapmoc@ eralced   

   

.临光次下您迎欢,持支的店本对您谢谢,evas#为额余内卡的您,siht_evas#为额金款付卡值储用使次本您/1--   

yap_dracevas--   

.持支的店本对您谢谢,evas#为额余内卡的前目您,tma_evas#为额金值充次本您:xes#tsuc#的敬尊/1--   

evas_drac--   

发来上线由该应息消信微的功成值充,12.9.51,wuil-- 

nigeb 

sa 

 gsm_hsup_teg_fsxw_rp corp etaerc 


og

gsm_hsup_teg_fsxw_rp corp pord  

)'gsm_hsup_teg_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_item_brand(MS).sql^^^^dne

di_edoc yb redro	

'PP'=on_epyt erehw	

edoc_esab_db_t morf	

emantnerap sa ''		

,ontnerap sa ''		

,eman_dnarb sa eman_edoc		

,on_dnarb sa di_edoc tceles	

nigeb

sa

dnarb_meti_fsxw_rp corp etaerc


og

dnarb_meti_fsxw_rp erudecorp pord  

)'dnarb_meti_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_item_multi_unit(MS).sql^^^^

dne 

]tinu_itlum_meti_db_t[ MORF	

]omem[,      

]tinu_meti[,      

]on_meti[,      

]eman_tinu[,      

]di_tinu[ TCELES     

nigeb 

sa 

tinu_itlum_meti_fsxw_rp corp etaerc 


og

tinu_itlum_meti_fsxw_rp erudecorp pord  

)'tinu_itlum_meti_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_add_point(MS).sql^^^^

dne 

	

 TIMMOC	

di_drac@=]di_drac[ erehw 			

mun_cca@+)0,mun_cca(LLUNSI=mun_cca			

 tes ofni_piv_mr_t etadpu		

	

)mun_cca@ ,'0' ,0 ,onhcnarb_sl@ ,'分积0.2店商微' ,'',etad_repo@,tma_musnoc@ ,di_drac@ ,'1' ,)41,on_wolf@(thgir( seulav		--		

)cca_piv ,galf_moc ,tma_laudiser ,on_hcnarb ,2rehto ,1rehto ,emit_yap ,tnuoma ,di_drac ,epyt_drac ,on_wolf( tsilyap_drac_mr_t tresni--		

		

)on_wolf@+'/励奖分积0.2店商微' ,)(etadteg ,'1001' ,mun_cca@ ,0 ,'' ,'3' ,di_drac@ , )2,onhcnarb_sl@(tfel( SEULAV 		

  )omem ,etad_fgv ,repo_fgv ,mun_piv_fgv ,mun_meti_fgv ,on_meti_fgv ,galf_fgv ,on_piv_fgv ,on_hcnarb_fgv(wolf_doog_piv_mr_t OTNI TRESNI		

		

))(etadteg,)(etadteg,1,mun_cca@,mun_cca@,tma_musnoc@,tma_musnoc@,)2,onhcnarb_sl@(tfel ,di_drac@(seulav			

)etad_yfidom,etad_snoc,tnuoc_snoc,tnuoma_cca_ruc_piv,tnuoma_cca_piv,tnuoma_snoc_ruc_piv,tnuoma_snoc_piv,on_hcnarb,di_drac(emusnoc_piv_mr_t otni tresni			

esle		

dne		

)2,onhcnarb_sl@(tfel=on_hcnarb dna di_drac@ = di_drac erehw  			

1 + )0 ,tnuoc_snoc(llunsi = tnuoc_snoc  			

,)(etadteg=etad_yfidom,)(etadteg=etad_snoc,'0'=galf_moc  			

,mun_cca@ + )0,tnuoma_cca_ruc_piv(llunsi = tnuoma_cca_ruc_piv  			

,mun_cca@ + )0,tnuoma_cca_piv(llunsi = tnuoma_cca_piv  			

,tma_musnoc@ + )0,tnuoma_snoc_ruc_piv(llunsi = tnuoma_snoc_ruc_piv  			

,tma_musnoc@ + )0,tnuoma_snoc_piv(llunsi = tnuoma_snoc_piv  			

tes emusnoc_piv_mr_t etadpu			

nigeb		

))2,onhcnarb_sl@(tfel=on_hcnarb dna di_drac@=di_drac erehw emusnoc_piv_mr_t morf * tceles(stsixe fi		

	NOITCASNART NIGEB	

 no troba_tcax tes	

务事--	


'00' =onhcnarb_sl@ tes 	

di_drac@=]di_drac[ erehw ofni_piv_mr_t morf )'',di_drac(LLUNSI=on_drac@ tceles 	

 	

)6(rahcravn onhcnarb_sl@ eralced 	


 	dne 	

nruter		

'足不分积','0' tceles		

nigeb 	

0<mun_cca@+mun_cca_won@ fi 	

di_drac@=]di_drac[ erehw ofni_piv_mr_t morf )0,mun_ced(llunsi - )0,mun_cca(llunsi=mun_cca_won@ tceles 	

分积余剩---- 	


)4,61(ciremun mun_cca_won@ eralced	

)05(rahcravn on_drac@ eralced	


	nruter		

)'%'+on_wolf@ ekil omem erehw wolf_doog_piv_mr_t morf 1 tceles(stsixe fi	

	nruter		

)di_drac@=]di_drac[ erehw ofni_piv_mr_t morf 1 tceles(stsixe ton fi	

理处复重--	

 .容内息消：列二第；功成1，败失 0：列一第；列两,序顺定固:容内回返的过通不证验    .证验足不分积加新，动活等分积费消上线合配了为,WUIL，52-2-6102--	

.分积用已 mun_ced,分积计累 mun_cca,分积余剩 mun_cca_won--	

nigeb

sa

)

)0001(rahcravn sed_repo@	

分积加增次本-- ,)2,81(ciremun mun_cca@	

,)2,81(ciremun tma_musnoc@	

,)001(rahcravn on_wolf@	

,emitetad etad_repo@	

,)02(rahcravn di_drac@	

(tniop_dda_rebmem_fsxw_rp corp etaerc



og

tniop_dda_rebmem_fsxw_rp erudecorp pord  

)'tniop_dda_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_balance_query(MS).sql^^^^

dne 

di_drac@=]di_drac[ erehw ofni_piv_mr_t morf		

 ssap sa 2rehto,  ecnalab sa  ) tma_laudiser (yrcsed_teg_f.obd   TCELES    

nigeb 

sa 

))02(rahcrav di_drac@(yreuq_ecnalab_rebmem_fsxw_rp corp etaerc 


og

yreuq_ecnalab_rebmem_fsxw_rp erudecorp pord  

)'yreuq_ecnalab_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_bind_proc_mid(MS).sql^^^^

dne 

     

 di_drac_r@=di_drac erehw ofni_piv_mr_t morf		

   	

corp_si sa ''		

,epyt_repo sa ''		

,ebircsbus sa ''		

,cippiv sa ''		

,ofnielbaruovaf sa ''		

,liame sa ''		

,elibom		

,etad_dne_piv		

,etad_trats_piv		

,ssap_piv sa ''		

,mun_cca_won sa mun_ced  - mun_cca		

,mun_ced		

,mun_cca		

,sutats_drac		

,etad_repo		

,on_epyt sa ''		

,epyt_drac		

,xes_piv		

,yadhtrib		

,eman_piv		

,di_drac		

,on_hcnarb		

,dinepo		

,dipohs   sa ''		

 tceles 	

息信员会的后册注/定绑回返--  	

  	

dne 	

'0'=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf		

 dna di_drac_r@=di_drac erehw '1'=corp_si tes ofni_piv_fsxw etadpu		

理处已为新更--		

di_drac_r@=di_drac erehw		

)		

'0'=corp_si dna epyt_repo@=epyt_repo			

 dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw			

 morf yadhtrib 1 pot tceles			

( = yadhtrib tes		

 ofni_piv_mr_t etadpu		

  日生员会新更--		

nigeb 	

'2'=epyt_repo@ fi 	

下线到步同日生改修-- 	


dne  	

'0'=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw '1'=corp_si tes ofni_piv_fsxw etadpu		

理处已为新更--		

 '0'=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw morf etad_repo,dipohs,dinepo,di_drac tceles			

)etad_repo,dipohs,dinepo,di_drac( wolfdnib_piv_xw_t otni tresni		

表定绑写--		

'0'=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw morf yadhtrib,di_laicos,',',xes_piv,elibom,'0',9999999,etaDdnEpiv@,etad_trats_piv,dinepo,etad_repo,'1001',epyt_drac@,di_drac,di_drac,eman_piv tceles		

 )yadhtrib,di_laicos,tma_laudiser,xes_piv,elibom,sutats_drac,mun_esu,etad_dne_piv,etad_trats_piv,dinepo,etad_repo,di_repo,epyt_drac,onwolf_drac,di_drac,eman_piv( ofni_piv_mr_t otni tresni		

表员会9MZ到入插--  	

nigeb  	

'1'=epyt_repo@ fi  	

  	

dne  	

'0'=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw '1'=corp_si tes ofni_piv_fsxw etadpu		

理处已为新更--		

 di_drac_r@=di_drac erehw	)on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw morf )'',dinepo(llunsi 1 pot tceles(=dinepo tes ofni_piv_mr_t etadpu		

DINEPO的 OFNI PIV新更--		

 '0'=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw morf etad_repo,dipohs,dinepo,di_drac tceles			

)etad_repo,dipohs,dinepo,di_drac( wolfdnib_piv_xw_t otni tresni		

表定绑写--		

定绑员会理处--  	

nigeb  	

'0'=epyt_repo@ fi  	

册注/定绑员会理处留预-- 	

。册注理处 1，定绑理处 0 epyt_repo@-- 	

		

epyt_piv_mr_t morf di_epyt=epyt_drac@ 1 pot tceles			

)'xw'=di_epyt erehw epyt_piv_mr_t morf 1 tceles( stsixe ton fi		

'xw'=epyt_drac@ tceles		

			

			

))(ETADTEG,01,RAEY(DDAETAD=etaDdnEpiv@ tceles			

)(ETADTEG<etaDdnEpiv@ fi		

 epyt_repo@=epyt_repo dna on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw morf  etad_dne_piv=etaDdnEpiv@ tceles		

dne     	

di_drac@ = di_drac_r@ tceles                

''= ))di_drac_r@(mirtr(mirtl ro llun si di_drac_r@ fi             

di_drac@ = onwolf_drac ro di_drac@=di_drac erehw ofni_piv_mr_t morf di_drac =  di_drac_r@ 1 pot tceles 	        

'' = di_drac_r@ tceles             

nigeb         

esle         

	 di_drac@ =  di_drac_r@  tceles            

册注--	'1'=epyt_repo@ fi		

号卡面卡持支60308102 hsnat--		

)02(rahcrav di_drac_r@ eralced		

emitetad etaDdnEpiv@ eralced		

)2(rahc epyt_drac@ eralced		

 

nigeb 

sa 

) 

 )001(rahcravn epyt_repo@

 ,)001(rahcravn di_drac@

,)001(rahcravn on_wolf@

 	( 

dim_corp_dnib_rebmem_fsxw_rp corp etaerc 


og

dim_corp_dnib_rebmem_fsxw_rp erudecorp pord  

)'dim_corp_dnib_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_bind_write_mid(MS).sql^^^^

dne 

     

			

dne 	

)			

di_laicos@		

,drac_rehtaf@		

,corp_si@		

,epyt_repo@		

,ebircsbus@		

,cippiv@		

,ofnielbaruovaf@		

,liame@		

,elibom@		

,etad_dne_piv@		

,etad_trats_piv@		

,ssap_piv@		

,mun_cca_won@		

,mun_ced@		

,mun_cca@		

,sutats_drac@		

,etad_repo@		

,on_epyt@		

,epyt_drac@		

,xes_piv@		

,yadhtrib@		

,eman_piv@		

,di_drac_r@		

,on_hcnarb@		

,dinepo@		

,dipohs@		

		,on_wolf@		

(				

seulav				

 )  			

di_laicos		

,drac_rehtaf		

,corp_si		

,epyt_repo		

,ebircsbus		

,cippiv		

,ofnielbaruovaf		

,liame		

,elibom		

,etad_dne_piv		

,etad_trats_piv		

,ssap_piv		

,mun_cca_won		

,mun_ced		

,mun_cca		

,sutats_drac		

,etad_repo		

,on_epyt		

,epyt_drac		

,xes_piv		

,yadhtrib		

,eman_piv		

,di_drac		

,on_hcnarb		

,dinepo		

,dipohs		

,on_wolf		

( ofni_piv_fsxw otni tresni  	

nigeb 	

)on_wolf@=on_wolf dna di_drac_r@=di_drac erehw ofni_piv_fsxw morf 1 tceles( stsixe ton fi 	

        

di_drac@ = di_drac_r@ tceles        

''= ))di_drac_r@(mirtr(mirtl ro llun si di_drac_r@ fi     

di_drac@ = onwolf_drac ro di_drac@=di_drac erehw ofni_piv_mr_t morf di_drac = di_drac_r@ 1 pot tceles 	

  ''= di_drac_r@ tceles     

)02(rahcrav di_drac_r@ eralced 	

号卡面卡持支60308102 hsnat--	

nigeb 

sa 

) 

)05(rahcravn di_laicos@

,)05(rahcravn drac_rehtaf@

,)001(rahcravn corp_si@

,)001(rahcravn epyt_repo@

,)001(rahcravn ebircsbus@

,)001(rahcravn cippiv@

,)001(rahcravn ofnielbaruovaf@

,)001(rahcravn liame@

,)001(rahcravn elibom@

,emitetad etad_dne_piv@

,emitetad etad_trats_piv@

,)001(rahcravn ssap_piv@

,)2,81(ciremun mun_cca_won@

,)2,81(ciremun mun_ced@

,)2,81(ciremun mun_cca@

,)001(rahcravn sutats_drac@

,)001(rahcravn etad_repo@

,)001(rahcravn on_epyt@

,)001(rahcravn epyt_drac@

,)001(rahcravn xes_piv@

,)001(rahcravn yadhtrib@

,)001(rahcravn eman_piv@

,)001(rahcravn di_drac@

,)001(rahcravn on_hcnarb@

,)001(rahcravn dinepo@

,)001(rahcravn dipohs@

,)001(rahcravn on_wolf@

( 

dim_etirw_dnib_rebmem_fsxw_rp corp etaerc 



og

dim_etirw_dnib_rebmem_fsxw_rp erudecorp pord  

)'dim_etirw_dnib_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_change_pwd(MS).sql^^^^

dne 

dne    

;)llun,'功成置设码密'+di_drac@+'为号卡：码密设','店商微',llun,'1001',)(etadteg( SEULAV		

  )omem ,noitpircsed ,on_snart ,eman_retupmoc ,di_repo ,etad_repo(gol_rotarepo_sys_t OTNI TRESNI		

nigeb    

 0 = rorre@@ fi	

;di_drac@=di_drac erehw ssap@=2rehto tes ofni_piv_mr_t etadpu	

nigeb 

sa 

) 

)05(rahcravn ssap@ 	

,)05(rahcravn di_drac@ 	

( 

dwp_egnahc_rebmem_fsxw_rp corp etaerc 


og

dwp_egnahc_rebmem_fsxw_rp erudecorp pord  

)'dwp_egnahc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_charge_proc_mid(MS).sql^^^^

dne 

   	

  	

dne  	

 		

TIMMOC			

 		

			

'0'=corp_si dna epyt_repo@=epyt_repo dna di_drac@=di_drac dna on_wolf@=on_wolf erehw '1'=corp_si tes tsil_evas_rebmem_fsxw etadpu			

理处已为新更--			

)di_drac@,'','',on_wolf@,)(ETADTEG,'1001',tma@,1,'BMR',di_drac@,di_drac@,'A','BMR','000',tma@,disop@,1( seulav--			

)on_drac,on_tfihs,on_rehcuov,omem,etad_repo,di_repo,tnuoma_yap,etar_nioc,on_nioc,on_piv,di_drac,yaw_lles,yaw_yap,on_hcnarb,tnuoma_elas,on_wolf,di_wolf( wolfyap_mr_t otni tresni--			

写品产由容内的wolfyap_mr_t--			

			

)00.0,'0',tma_laudiser@,on_hcnarb_fed@,'费消卡值充上线',on_wolf_sl@,)(ETADTEG,tma@,di_drac@,'2',on_wolf_sl@( seulav			

)cca_piv,galf_moc,tma_laudiser,on_hcnarb,2rehto,1rehto,emit_yap,tnuoma,di_drac,epyt_drac,on_wolf(tsilyap_drac_mr_t otni tresni			

到用台前，段字  di_drac\2rehto\1rehto\on_wolf改修要不请--			

di_drac@ = di_drac erehw tma_laudiser_rts@ = tma_laudiser   tes ofni_piv_mr_t etadpu			

 		

 		NOITCASNART NIGEB			

 no troba_tcax tes			

		

tnuoc_sl@ = tma_laudiser_rts@ tes			

dne				

1+ i_ll@ =i_ll@ tes					

)2 * )2 - i_ll@ - nel_ll@(+))1 ,i_ll@ ,tma_laudiser_rts@(GNIRTSBUS(IICSA(rahc+ tnuoc_sl@=tnuoc_sl@ tes					

nigeb				

nel_ll@=<i_ll@ elihw			

'' = tnuoc_sl@ tes			

1 =     i_ll@ tes			

)tma_laudiser_rts@(nel =   nel_ll@ tes			


			)))2,00001 * tma_laudiser@(dnuor,)02(rahcrav(trevnoc(esrever =   tma_laudiser_rts@ tes		

密加额金--		

)tma_laudiser@(yrcsed_teg_f.obd=tma_laudiser_rts@ tceles--		

tma@ - tma_laudiser@=tma_laudiser@ tceles		

)41,on_wolf@(THGIR=on_wolf_sl@ TCELES    	

nigeb  	

'1'=epyt_repo@ fi  	

  	

dne  	

 		

 TIMMOC			

			

'0'=corp_si dna epyt_repo@=epyt_repo dna di_drac@=di_drac dna on_wolf@=on_wolf erehw '1'=corp_si tes tsil_evas_rebmem_fsxw etadpu			

理处已为新更--			

)di_drac@,'','',on_wolf@,)(ETADTEG,'1001',tma@,1,'BMR',di_drac@,di_drac@,'A','BMR','000',tma@,disop@,1( seulav--			

)on_drac,on_tfihs,on_rehcuov,omem,etad_repo,di_repo,tnuoma_yap,etar_nioc,on_nioc,on_piv,di_drac,yaw_lles,yaw_yap,on_hcnarb,tnuoma_elas,on_wolf,di_wolf( wolfyap_mr_t otni tresni--			

写品产由容内的wolfyap_mr_t--			

			

)'XWU',tma_tpiecer@,'0',00.0,on_wolf@,00.0,dlo_tma_laudiser@,)(ETADTEG,'1001',tma@,di_drac@,on_hcnarb_fed@( seulav			

)yaw_yap,tnuoc_laer_sulp,galf_moc,tma_laudiser,1rehto,1mun,tnuoc_dlo,etad_repo,di_repo,tnuoc_sulp,di_drac,on_hcnarb(drocer_sulp_gnivas_mr_t otni tresni			

			

di_drac@ = di_drac erehw tma_laudiser_rts@ = tma_laudiser  tes ofni_piv_mr_t etadpu			

				

dne				

nruter					

)1,61,'！在存已号单'(rorresiar					

nigeb				

)on_wolf@ = 1rehto erehw drocer_sulp_gnivas_mr_t morf 1 tceles( stsixe fi			

11908102 rjgnahz 常异义定自出抛，复重否是号单查检--			

			

 		NOITCASNART NIGEB			

 no troba_tcax tes			


tnuoc_sl@ = tma_laudiser_rts@ tes			

dne				

1+ i_ll@ =i_ll@ tes					

)2 * )2 - i_ll@ - nel_ll@(+))1 ,i_ll@ ,tma_laudiser_rts@(GNIRTSBUS(IICSA(rahc+ tnuoc_sl@=tnuoc_sl@ tes					

nigeb				

nel_ll@=<i_ll@ elihw			

'' = tnuoc_sl@ tes			

1 =     i_ll@ tes			

)tma_laudiser_rts@(nel =   nel_ll@ tes			


			)))2,00001 * tma_laudiser@(dnuor,)02(rahcrav(trevnoc(esrever =   tma_laudiser_rts@ tes		

密加额金--		

)tma_laudiser@(yrcsed_teg_f.obd=tma_laudiser_rts@ tceles--		

tma@+tma_laudiser@=tma_laudiser@ tceles		

tma_laudiser@ = dlo_tma_laudiser@ tceles		

理处--  	

nigeb  	

'0'=epyt_repo@ fi  	

理处留预-- 	

。款付 1，值充 0 epyt_repo@-- 	

	联关做on_wolf的上线和omem.wolfyap_mr_t,omem.tsilevas_piv_mr_t--		

			

'00'=on_hcnarb_fed@ tceles			

)on_hcnarb_fed@=on_hcnarb erehw ofni_hcnarb_db_t morf 1 tceles( stsixe ton fi		

			

'00'=on_hcnarb_fed@ tceles			

'1'=epyt_repo@ fi		

on_hcnarb查检--		

		

di_drac@=]di_drac[ erehw ofni_piv_mr_t morf			

 )'00',on_hcnarb(LLUNSI=on_hcnarb_fed@,epyt_drac=epyt_drac@, ) tma_laudiser (yrcsed_teg_f.obd=tma_laudiser@   TCELES		

on_wolf@=on_wolf erehw tsil_evas_rebmem_fsxw morf )'00',on_hcnarb(llunsi=on_hcnarb@,tma= tma@,tma_tpiecer = tma_tpiecer@ tceles		

TSILEVAS入存位02后-- )02,on_wolf@(THGIR=disop@ TCELES--		

'00'=on_hcnarb_fed@ tceles		

		

额金付实-- )4,61(ciremun tma_tpiecer@ eralced		

)41(rahcrav on_wolf_sl@ eralced		

)02(rahcrav tnuoc_sl@ eralced		

tni i_ll@ eralced		

tni nel_ll@ eralced		

)02(rahcravn on_hcnarb@ eralced		

)02(rahcravn on_hcnarb_fed@ eralced		

)4(rahcravn epyt_drac@ eralced		

ON WOLF做 di sop-- )02(rahcrav disop@ eralced--		

。致一型类库据数品产各和,额余符字--  )03(rahcrav tma_laudiser_rts@ eralced		

额余内卡前款付/值充--   )4,61(ciremun dlo_tma_laudiser@ eralced		

额余字数--   )4,61(ciremun tma_laudiser@ eralced		

额金的表间中-- )4,61(ciremun tma@ eralced		

		

nruter			

)'1'=corp_si dna on_wolf@=on_wolf erehw tsil_evas_rebmem_fsxw morf 1 tceles( stsixe fi		

识标表间中查检,理处复重止防--		

nruter			

)on_wolf@=on_wolf erehw tsil_evas_rebmem_fsxw morf 1 tceles( stsixe ton fi		

在存不号单--		

nigeb 

sa 

) 

 )001(rahcravn epyt_repo@ 

, )001(rahcravn di_drac@ 

, )001(rahcravn on_wolf@ 

 	( 

dim_corp_egrahc_rebmem_fsxw_rp corp etaerc 


og

dim_corp_egrahc_rebmem_fsxw_rp erudecorp pord  

)'dim_corp_egrahc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_charge_query(MS).sql^^^^

dne 

epyt_repo@=epyt_repo dna on_wolf@=on_wolf erehw tsil_evas_rebmem_fsxw  morf		

corp_si    TCELES		

esle	

corp_si@=corp_si dna epyt_repo@=epyt_repo dna on_wolf@=on_wolf erehw tsil_evas_rebmem_fsxw  morf		

corp_si    TCELES		

'0'=epyt_yreuq@ fi	

nigeb 

sa 

) 

)1(rahc corp_si@ 

,)1(rahc epyt_repo@ 

,)001(rahcravn on_wolf@ 

 on_wolf询查只，1，询查corp_si带,0--,)1(rahc epyt_yreuq@

  ( 

yreuq_egrahc_rebmem_fsxw_rp corp etaerc 


og

yreuq_egrahc_rebmem_fsxw_rp erudecorp pord  

)'yreuq_egrahc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_charge_write_mid(MS).sql^^^^

dne 

    

)tma_tpiecer@,corp_si@,on_hcnarb@,on_wolf_xw@,tma@,etad_repo@,epyt_repo@,di_drac@,on_wolf@(		

seulav		

 )tma_tpiecer,corp_si,on_hcnarb,on_wolf_xw,tma,etad_repo,epyt_repo,di_drac,on_wolf( tsil_evas_rebmem_fsxw otni tresni  	

	

dne	

nruter		

)1,61,'！在存已号单'(rorresiar		

nigeb	

)on_wolf@ = on_wolf erehw tsil_evas_rebmem_fsxw morf 1 tceles( stsixe fi	

  	

nigeb 

sa 

) 

)4,61(ciremun tma_tpiecer@

,)1(rahcrav corp_si@

,)05(rahcravn on_hcnarb@

,)001(rahcravn on_wolf_xw@

,)02(rahcrav tma@

,)02(rahcrav etad_repo@

,)1(rahcrav epyt_repo@

,)02(rahcrav di_drac@

,)001(rahcravn on_wolf@

( 

dim_etirw_egrahc_rebmem_fsxw_rp corp etaerc 



og

dim_etirw_egrahc_rebmem_fsxw_rp erudecorp pord  

)'dim_etirw_egrahc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_chk_ex(MS).sql^^^^

dne 

elibom@=elibom dna di_drac_r@=]di_drac[ erehw ofni_piv_mr_t morf		

]di_drac[   TCELES    

'2'=epyt_repo@ fi	

elibom@=elibom erehw ofni_piv_mr_t morf		

]di_drac[   TCELES    

'1'=epyt_repo@ fi	

di_drac_r@=]di_drac[ erehw ofni_piv_mr_t morf		

]di_drac[   TCELES    

'0'=epyt_repo@ fi	

。配匹否是号机手和号卡员会查检 2;在存已否是号机手查检 1，在存否是DI员会查检,0--	

dne		

 di_drac@ = di_drac_r@ tceles				

''=))di_drac_r@(MIRTR(MIRTL ro llun si di_drac_r@ fi			

 di_drac@= onwolf_drac erehw ofni_piv_mr_t morf di_drac = di_drac_r@ 1 pot tceles			

nigeb		

esle	

dne		

di_drac@ = di_drac_r@ tes			

nigeb		

) di_drac@=di_drac erehw ofni_piv_mr_t morf 1 tceles(stsixe fi	

)02(rahcrav di_drac_r@ eralced	

号卡面卡持支60308102 hsnat--	

nigeb 

sa 

) 

	)02(rahcravn elibom@ 

,)02(rahcravn di_drac@ 

,)2(rahcravn epyt_repo@ 

(xe_khc_rebmem_fsxw_rp corp etaerc 


og

xe_khc_rebmem_fsxw_rp erudecorp pord  

)'xe_khc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_chk_openid(MS).sql^^^^

dne 

dne		

'0' tceles				

esle			

'1' tceles				

)di_drac@=di_drac erehw ofni_piv_mr_t morf 1 tceles( stsixe fi			

nigeb		

esle	

dne	

'0' tceles			

esle		

'1' tceles			

)dinepo@=dinepo dna di_drac@=di_drac erehw ofni_piv_mr_t morf 1 tceles( stsixe fi		

nigeb    

0 > )dinepo@(NEL fi    

/*32018102 rjgnahz。息信员会配匹去di_drac据根仅，序程小是则dinepo无    

；息信员会配匹去 di_drac+DInepo据根当应，店商微是则dinepo有*/    

    

di_epyt@ = di_epyt erehw epyt_piv_mr_t morf )0,galf_gnivas(llunsi=galf_gnivas@ tceles    

过通:1,过通未示表:0回返 --    

di_drac@=di_drac erehw ofni_piv_mr_t morf epyt_drac=di_epyt@ tceles	

 )1(rahc galf_gnivas@ eralced	

 )2(rahc di_epyt@ eralced	

nigeb 

sa 

) 

)06(rahcravn dinepo@ 

,)02(rahcrav di_drac@ 

(dinepo_khc_rebmem_fsxw_rp corp etaerc 


og

dinepo_khc_rebmem_fsxw_rp erudecorp pord  

)'dinepo_khc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_chk_save(MS).sql^^^^

dne 

'0' tceles		

esle    

'1' tceles		

'1'=galf_gnivas@ fi    

di_epyt@ = di_epyt erehw epyt_piv_mr_t morf )0,galf_gnivas(llunsi=galf_gnivas@ tceles    

.用启:1,用启未示表:0回返 --    

di_drac@=di_drac erehw ofni_piv_mr_t morf epyt_drac=di_epyt@ tceles	

 )1(rahc galf_gnivas@ eralced	

 )2(rahc di_epyt@ eralced	

nigeb 

sa 

) 

 )02(rahcrav di_drac@ 

(evas_khc_rebmem_fsxw_rp corp etaerc 



og

evas_khc_rebmem_fsxw_rp erudecorp pord  

)'evas_khc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_chk_status(MS).sql^^^^

dne 

 		'1' tceles	

备准做epyt_repo@加新后以为，1为认默epyt_repo@的它其--	

 	

dne	

nruter		

'0' tceles			

esle		

'1' tceles			

'0'=galf_cca@ fi		

di_epyt@ = di_epyt erehw epyt_piv_mr_t morf )0,galf_cca(llunsi=galf_cca@ tceles		

di_drac_r@=di_drac erehw ofni_piv_mr_t morf epyt_drac=di_epyt@ tceles		

 )1(rahc galf_cca@ eralced		

 )2(rahc di_epyt@ eralced		

nigeb	

'2'=epyt_repo@ fi esle	

dne	

dne		

 nruter			

'0' tceles			

nigeb		

)etad_dne_piv dna etad_trats_piv neewteb )(ETADTEG dna '0'=sutats_drac dna di_drac_r@=di_drac erehw ofni_piv_mr_t morf 1 tceles (stsixe ton fi		

nigeb	

'1'=epyt_repo@ fi esle	

dne	

dne		

 nruter			

'0' tceles			

nigeb		

) '0'=sutats_drac dna di_drac_r@=di_drac erehw ofni_piv_mr_t morf 1 tceles (stsixe ton fi		

nigeb	

 '0'=epyt_repo@ fi	

.功成:1,败失示表:0回返 --	

	能功分积了动启否是卡员会 2,期效有值储和态状员会验校是1，态状员会验检是 0 epyt_repo@--	

dne		

 di_drac@ = di_drac_r@ tceles				

''=))di_drac_r@(MIRTR(MIRTL ro llun si di_drac_r@ fi			

 di_drac@= onwolf_drac erehw ofni_piv_mr_t morf di_drac = di_drac_r@ 1 pot tceles			

nigeb		

esle	

dne		

di_drac@ = di_drac_r@ tes			

nigeb		

) di_drac@=di_drac erehw ofni_piv_mr_t morf 1 tceles(stsixe fi	

)02(rahcrav di_drac_r@ eralced	

号卡面卡持支60308102 hsnat--	

nigeb 

sa 

) 

 )02(rahcrav di_drac@	

,)02(rahcravn epyt_repo@	

(sutats_khc_rebmem_fsxw_rp corp etaerc 


og

sutats_khc_rebmem_fsxw_rp erudecorp pord  

)'sutats_khc_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_get_info(MS).sql^^^^

dne 

 	

'0' tceles 	

它其 -- 	


dne 	

nruter 		

'0' = sutats_drac dna elibom@=elibom erehw ofni_piv_mr_t morf di_drac tceles 		

 		nigeb 	

 '2'=epyt_repo@ fi 	


	dne 	

 		 nruter 		

 on_meti.ofni_meti_db_t=on_gv.]doog_piv_mr_t[  no ofni_meti_db_t nioj renni				

 	]doog_piv_mr_t[  MORF				

   				eman_gv sa eman_meti.ofni_meti_db_t ,  				

]mun_timil_gv[ sa 0 ,  				

]on_hcnarb_gv[,  				

]etade_gv[  ,  				

]etadb_gv[  ,  				

]mun_piv_gv[,  				

]mun_gv[,  				

]on_gv[   TCELES				

  sa 用使请，上不对名列品产的你果如，名列回返--		

量数换限员会每，店门应对，止期效有，始期效有，分积，量数，码编品礼--		

nigeb 	

 '1'=epyt_repo@ fi 	

 	dne 	

 		

 nruter 		

 		)   di_drac@=di_drac erehw ofni_piv_mr_t morf epyt_drac  1 pot tceles  		

(=di_epyt erehw epyt_piv_mr_t morf eman_epyt,tnuocsid,yaw_elas tceles		

yaw_elas sa 用使请，上不对名列品产的你果如 eman_epyt,tnuocsid,yaw_elas，名列回返--		

间之 1 到 0 :扣折 tnuocsid  .扣折价员会 2; 价员会 1;扣折价售零 0：型类惠优员会 yaw_elas--		

nigeb 	

 '0'=epyt_repo@ fi 	

  

nigeb 

sa 

) 

)02(rahcravn elibom@	

,)06(rahcravn  dinepo@	

,)02(rahcravn di_drac@	

,)02(rahcravn epyt_repo@	

(ofni_teg_rebmem_fsxw_rp corp etaerc


og

ofni_teg_rebmem_fsxw_rp erudecorp pord  

)'ofni_teg_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_point_query(MS).sql^^^^

dne 

di_drac@=]di_drac[ erehw ofni_piv_mr_t morf		

  mun_ced,mun_cca,mun_cca_won sa ))0,mun_ced(llunsi - )0,mun_cca(llunsi(  TCELES    

nigeb 

sa 

))02(rahcrav di_drac@(yreuq_tniop_rebmem_fsxw_rp corp etaerc 


og

yreuq_tniop_rebmem_fsxw_rp erudecorp pord  

)'yreuq_tniop_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_save_detail(MS).sql^^^^

dne 

dne@ dna trats@ neewteb munwor erehw elbaTataDgnigaPpmt# morf * tceles	

elbaTataDgnigaPpmt# morf )1(TNUOC=tnuoc_latot@ tceles	

csed etad_epo  yb redro t ) 	

di_drac@=]di_drac[ erehw		

 drocer_sulp_gnivas_mr_t morf		

sed_repo sa '值充卡值储'			

,omem sa 1rehto			

,mun_cca sa 00.0			

,tma_musnoc sa tnuoc_sulp			

,on_wolf sa ''			

,etad_epo sa etad_repo			

,di_repo			

,on_hcnarb			

,on_drac sa di_drac			

,di_drac tceles		

		

noinu		

 '2'=]epyt_drac[ dna				

di_drac@=]di_drac[ erehw 		

 tsilyap_drac_mr_t morf 		

sed_repo sa '费消卡值储'			

,omem sa 1rehto			

,mun_cca sa 00.0			

,tma_musnoc sa tnuoma*1-			

,on_wolf			

,etad_epo sa emit_yap			

,di_repo sa '1001'			

,on_hcnarb			

,on_drac sa di_drac			

,di_drac tceles		

( 	

morf elbaTataDgnigaPpmt# otni *.t,munwor sa )1,1, tni(ytitnedi tceles	

	

ezisegap@* xedniegap@ =dne@ tceles	


ezisegap@*)1-xedniegap@(=trats@ tceles  	

 esle	

 1+)ezisegap@*)1-xedniegap@((=trats@ tceles		

 1>xedniegap@ fi	


 tni dne@ eralced	

tni trats@ eralced	

nigeb 

sa 

) 

tuptuo tni tnuoc_latot@ 

,tni ezisegap@ 

,tni xedniegap@ 

,)02(rahcravn di_drac@ 

(liated_evas_rebmem_fsxw_rp corp etaerc 


og

liated_evas_rebmem_fsxw_rp erudecorp pord  

)'liated_evas_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_member_unbind(MS).sql^^^^

dne 

 di_drac@=di_drac erehw llun=elibom,llun=dinepo tes ofni_piv_mr_t etadpu		

'1'=epyt_repo@ fi esle    

 di_drac@=di_drac erehw llun=dinepo tes ofni_piv_mr_t etadpu		

'0'=epyt_repo@  fi	

验校中手助在已 elibom,di nepo--	

elibom和dinepo除清 ’1‘= ，dinepo除清仅 '0'=epyt_repo--	

	 nigeb 

sa 

) 

 )05(rahcravn di_drac@ 

,)01(rahcravn epyt_repo@ 

(dnibnu_rebmem_fsxw_rp corp etaerc 


og

dnibnu_rebmem_fsxw_rp erudecorp pord  

)'dnibnu_rebmem_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_order_cancel(MS).sql^^^^

dne 

		

dne	

)41,))onredro@(mirtr(mirtl(thgir=on_wolf erehw '1' = galf_teehs tes wolfelas_pm_t etadpu		

)41,))onredro@(mirtr(mirtl(thgir=on_teehs erehw '2'=daolnwoDsI tes nixiew_llib_redro_t etadpu		

nigeb	

)'1'=)'0',daolnwoDsI(LLUNSI dna )41,))onredro@(mirtr(mirtl(thgir=on_teehs erehw nixiew_llib_redro_t morf 1 tceles( stsixe ton fi	 

销撤为新更-- 

nigeb 

sa 

) 

  )001(rahcravn onredro@ 

 

 	( 

lecnac_redro_fsxw_rp corp etaerc 


og

lecnac_redro_fsxw_rp erudecorp pord  

)'lecnac_redro_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_order_detail_write_mid(MS).sql^^^^

dne 

    

)		

 ecirpelas@

,munredro@

,eman_meti@

,onmeti@

,onredro@

,dinepo@

,dipohs@

(		

seulav		

 )  	

 ecirpelas

,munredro

,eman_meti

,onmeti

,onredro

,dinepo

,dipohs

( liated_redro_fsxw otni tresni  	

 	

nigeb 

  

sa 

) 

 )4,81(ciremun	ecirpelas@

 ,)4,81(ciremun	munredro@

 

,)05(rahcravn  eman_meti@

,)05(rahcravn	onmeti@

,)05(rahcravn	onredro@

,)05(rahcravn	dinepo@

,)05(rahcravn	dipohs@

( 

dim_etirw_liated_redro_fsxw_rp corp etaerc 



og

dim_etirw_liated_redro_fsxw_rp erudecorp pord  

)'dim_etirw_liated_redro_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_order_master_write_mid(MS).sql^^^^

dne 

    

)		

emitlaed@

,'1'

,omem@

,di_drac@

,sutatsyap@

,sutats@

,sserdda@

,etadrepo@

,epyt_laed@

,epyt_yap@


,latot@

,sserpxe_latot@

,vad_latot@

,tma_tot@


,letredro@

,)2,on_hcnarb@(tfel

,namredro@

,onredro@

,dinepo@

,dipohs@

(		

seulav		

 )  	

emitlaed

,corp_si

,omem

,di_drac

,sutatsyap

,sutats

,sserdda

,etadrepo

,epyt_laed

,epyt_yap


,latot

,sserpxe_latot

,vad_latot

,tma_tot


,letredro

,on_hcnarb

,namredro

,onredro

,dinepo

,dipohs

( retsam_redro_fsxw otni tresni  	

	

dne	

nruter		

)1,61,'！在存已号单'(rorresiar		

nigeb	

)onredro@ = onredro erehw retsam_redro_fsxw morf 1 tceles( stsixe fi	

		

nigeb 

sa 

) 

emitetad	emitlaed@

,)552(rahcravn	omem@

,)05(rahcravn	di_drac@

,)05(rahcravn	sutatsyap@


,)05(rahcravn	sutats@

,)05(rahcravn	sserdda@

,emitetad	etadrepo@

,)05(rahcravn	epyt_laed@

,)05(rahcravn	epyt_yap@


,)4,81(ciremun	latot@

,)4,81(ciremun	sserpxe_latot@

,)4,81(ciremun	vad_latot@

,)4,81(ciremun	tma_tot@


,)05(rahcravn	letredro@

,)05(rahcravn	on_hcnarb@

,)05(rahcravn	namredro@

,)05(rahcravn	onredro@

,)05(rahcravn	dinepo@

,)05(rahcravn	dipohs@

( 

dim_etirw_retsam_redro_fsxw_rp corp etaerc 


og

dim_etirw_retsam_redro_fsxw_rp erudecorp pord  

)'dim_etirw_retsam_redro_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_order_proc_mid(MS).sql^^^^

dne 

     

	

 			

			

 '0'=corp_si dna   onredro@=onredro erehw '1'=corp_si tes retsam_redro_fsxw etadpu--			

理处已为新更--			

 			

onredro@=onredro.a erehw onredro.b=onredro.a no b liated_redro_fsxw nioj renni a retsam_redro_fsxw morf 				

 emitlaed.a ,omem.a ,'2',sutatsyap,di_drac,epyt_laed,epyt_yap			

,sserdda.a,'' 				

,'0',dipohs.a,on_hcnarb.a,dinepo.a,munredro.b,etadrepo.a,ecirpelas.b,onmeti.b,letredro.a,namredro.a,)41,onredro.a(thgir,onredro.a tceles			

)emitlaed ,omem ,rev,sutatsyap,di_drac,epyt_laed,epyt_yap    

,]sserdda[,eman_meti,]daolnwoDsI[,]dipohs[,]on_hcnarb[,]dinepo[,]ytq_laer[,    

]etad_repo[,]ecirp[,]on_meti[,]letredro[,]namredro[,]on_teehs[,]on_redro[( nixiew_llib_redro_t otni tresni

 		空为的老，单订的店商微新是2为 rev--	

 		

LLA或000为]on_hcnarb[,理处--	

nruter			

)onredro@=onredro erehw retsam_redro_fsxw morf 1 tceles( stsixe ton fi		

在存不号单--  	

  	

nigeb 

sa 

) 

  )001(rahcravn onredro@ 

 	( 

dim_corp_redro_fsxw_rp corp etaerc 



og

dim_corp_redro_fsxw_rp erudecorp pord  

)'dim_corp_redro_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_order_query(MS).sql^^^^

dne 

		

 	

	 )41,))onredro@(mirtr(mirtl(thgir=on_teehs erehw  nixiew_llib_redro_t morf sutats_redro sa )'0',daolnwoDsI(LLUNSI  tceles			

 	 		

	销撤 2，用使品产被已 1，用使未 0，sutats_redro为定固列回返--		

  

nigeb 

sa 


) 

  )001(rahcravn onredro@ 

 

 	( 

yreuq_redro_fsxw_rp corp etaerc 


og

yreuq_redro_fsxw_rp erudecorp pord  

)'yreuq_redro_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_push_orderstatus_get(MS).sql^^^^

dne

 	

 		

'0' = )'0',galfpu_sutats(llunsi dna			

 )'2','1' (ni )'0',daolnwoDsI(llunsi  erehw		

 nixiew_llib_redro_t morf		

sutats_redro sa 		

	/*)dne 		

)dne '1' esle '2' neht '1' = galf_lecnac nehw esac(					

esle				

)dne '0' esle '1' neht '2' nehw '2' neht '1' nehw daolnwoDsI esac( neht					

 '2' nehw rev esac(*/ 		

断判开分以所，’1‘=galfpu_sutats即示显上页网在不都据数的前之0.2于由  hjey--- 		

)dne '0' esle '1' neht '2' nehw '2' neht '1' nehw daolnwoDsI esac( 		

 ,onredro sa )on_teehs,on_redro(llunsi,epyt_redro sa '0' 		

  		

 tcnitsid tceles		

.1为写回被会值个这，后站网给传回功成态状单订当， galfpu_sutats：列一了加增表单订微的9卖专 --	 

	

。销撤已 2， 成完已 1，理处未 0，态状单订微的9卖专表代  daolnwoDsI.nixiew_llib_redro_t中9卖专 --	

	态状单订站网应对.成完已 2，消取已 1 sutats_redro --	

留预 epyt_redro --	

sutats_redro sa '1',onredro sa 'aa',epyt_redro sa '0' tceles --

nigeb

sa

 teg_sutatsredro_hsup_fsxw_rp corp etaerc



og

teg_sutatsredro_hsup_fsxw_rp erudecorp pord  

)'teg_sutatsredro_hsup_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_push_orderstatus_writeback(MS).sql^^^^

dne

  	

 		

'0' = )'0',galfpu_sutats(llunsi dna )onredro@ = on_redro( erehw			

'1' = galfpu_sutats tes nixiew_llib_redro_t etadpu			

			

 	

nigeb

sa

)

)001(rahcravn onredro@	

,)1(rahcravn epyt_redro@	

(

 kcabetirw_sutatsredro_hsup_fsxw_rp corp etaerc



og

kcabetirw_sutatsredro_hsup_fsxw_rp erudecorp pord  

)'kcabetirw_sutatsredro_hsup_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_sys_param(MS).sql^^^^

dne 

		

di_rav_sys@=di_rav_sys erehw eman_rav_sys@=eman_rav_sys,eulav_rav_sys@=eulav_rav_sys tes metsys_sys_t etadpu 	

esle	

)eulav_rav_sys@,eman_rav_sys@,di_rav_sys@(			

seulav			

)eulav_rav_sys,eman_rav_sys,di_rav_sys(metsys_sys_t otni tresni		

)  di_rav_sys@=di_rav_sys erehw    metsys_sys_t morf 1 tceles( stsixe ton fi	 

留预.数参新更/加增， 0 epyt_repo@ --	

nigeb 

sa 

) 

  )552(rahcravn eulav_rav_sys@ 

,)04(rahcrav eman_rav_sys@ 

,)03(rahcrav di_rav_sys@ 

, 	)1(rahc epyt_repo@ 

( 

marap_sys_fsxw_rp corp etaerc


og

marap_sys_fsxw_rp erudecorp pord  

)'marap_sys_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_vip_mobile_update(MS).sql^^^^

dne 

galf_eradpu@ = galf_eradpu tceles    

	

dne	

		1 = galf_eradpu@ tes 0 = RORRE@@ fi		

di_drac@ = di_drac erehw elibom@ = elibom tes ofni_piv_mr_t etadpu		

nigeb	

		)di_drac@ = di_drac erehw ofni_piv_mr_t morf * tceles( stsixe fi	

在存否是卡员会断判--	

	

0 = galf_eradpu@ tes	

tni galf_eradpu@ eralced	

 

nigeb 

sa 

) )02(rahcrav elibom@ ,)02(rahcrav di_drac@(etadpu_elibom_piv_fsxw_rp corp etaerc 


og

etadpu_elibom_piv_fsxw_rp erudecorp pord  

)'etadpu_elibom_piv_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$pr_wxsf_write_push_msg_flag(MS).sql^^^^

dne 

   di_wolf@ = di_wolf erehw '1'=noiger tes wolf_xw_t_ssem etadpu    

nigeb 

sa 

) 

)001(rahcravn di_wolf@  

( 

 galf_gsm_hsup_etirw_fsxw_rp corp etaerc 


og

galf_gsm_hsup_etirw_fsxw_rp corp pord  

)'galf_gsm_hsup_etirw_fsxw_rp'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$t_rm_card_paylist_insert(MS).sql^^^^

dne



               

dne		

dne 		

			

dne				     

							

dne							

)tma_musnoc_nl@,on_wolf_sl@,'0','5',tma_musnoc_nl@,mun_cca_nl@,didrac_sl@,on_hcnarb_sl@,'4'( seulav							

 )tma_wolf,on_wolf,galf_dnes,epyt_repo,tma_tsilevas,mun_cca,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni							

nigeb							

esle						

'0' = galf_dnes  								

dna on_wolf_sl@ = on_wolf  								

dna '5' = epyt_repo  								

dna epyt_drac@ = epyt_drac  								

dna didrac_sl@ = di_drac  								

dna on_hcnarb_sl@ = on_hcnarb  								

 dna '4' = epyt_ssem erehw							

tma_musnoc_nl@ = tma_tsilevas,tma_musnoc_nl@ = tma_wolf,mun_cca_nl@ = mun_cca tes egassem_piv_t_ssem etadpu							

    																						

)'0' = galf_dnes    																						

dna on_wolf_sl@ = on_wolf    																						

dna '5' = epyt_repo    																						

dna epyt_drac@ = epyt_drac    																						

dna didrac_sl@ = di_drac    																						

dna on_hcnarb_sl@ = on_hcnarb    																						

 dna '4' = epyt_ssem erehw )kcolon(htiw egassem_piv_t_ssem morf 1 1 pot tceles(stsixe fi					     

nigeb				     

 '1' = )1,eulav_rav_sl@(tfel fi			     

)))'yap_dracevas'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES			

nigeb 		

 0 > wor_ll@ fi 		

				  nigeb		

款付卡值储--		

 )'5' = epyt_repo_sl@( fi	


 dne		

dne				

					

dne						

)on_wolf_sl@,'0','0',tma_musnoc_nl@,mun_cca_nl@,epyt_drac@,didrac_sl@,on_hcnarb_sl@,'5'( seulav								

 )on_wolf,galf_dnes,epyt_repo,tma_wolf,mun_cca,epyt_drac,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni								

esle							

'0' = galf_dnes  																						

dna on_wolf_sl@ = on_wolf  																						

dna '0' = epyt_repo  																						

dna epyt_drac@ = epyt_drac  																						

dna didrac_sl@ = di_drac  																						

dna on_hcnarb_sl@ = on_hcnarb  																						

 dna '5' = epyt_ssem erehw mun_cca_nl@ = mun_cca tes egassem_piv_t_ssem etadpu								

																								

)'0' = galf_dnes																								

dna on_wolf_sl@ = on_wolf																								

dna '0' = epyt_repo																								

dna epyt_drac@ = epyt_drac																								

dna didrac_sl@ = di_drac																								

dna on_hcnarb_sl@ = on_hcnarb																								

 dna '5' = epyt_ssem erehw )kcolon(htiw egassem_piv_t_ssem morf 1 1 pot tceles(stsixe fi							

nigeb						

 '1' = )1,eulav_rav_sl@(tfel fi    				

)))'otua_remusnoc'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES				

nigeb				

 0 > wor_ll@ fi			

				     1 = mun_elas_nl@ tceles 				    

esle			  

0 = mun_elas_nl@ tceles				     

0 = tma_musnoc_nl@ fi			  

on_wolf_sl@=on_wolf dna didrac_sl@=di_drac erehw tsilyap_drac_mr_t morf   )di_drac(tnuoc=tnuoc_l@ tceles--		  

nigeb		

费消员会--		

 )'0' = epyt_repo_sl@( fi	


'5' = epyt_repo_sl@ tceles  	

款付卡值储-- '2' = epyt_drac@ fi	

'0' = epyt_repo_sl@ tceles	

		

'metsys_sys_t_ssem' = eman erehw stcejbosys morf )*(tnuoc = wor_ll@ tceles	

	

表数参信短有否是断判，信短动自--	

	

'00' =on_hcnarb_sl@ tceles          

eslE        

on_hcnarb_sl@ =on_hcnarb_sl@ tceles           

 '2' => eulav_rav_sys@  fi        

'detubirtsid_si'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys = eulav_rav_sys@ tceles        


72-9-6102	xzuohz		错报值llun入插会则否，行执续继不时空为di_drac--	nruter '' = )'' ,didrac_sl@(llunsi fi		

	

detresni morf		

tma_laudiser = tma_laudiser_nl@		

,2rehto = 2rehto@		

,on_hcnarb=on_hcnarb_sl@		

,on_wolf=on_wolf_sl@                

,cca_piv=mun_cca_nl@		

,tnuoma=tma_musnoc_nl@		

,epyt_drac=epyt_drac@		

,di_drac=didrac_sl@	 tceles	

据数水流分积售销前当 --	

)2(rahcrav eulav_rav_sys@      

,)02(rahcrav 2rehto@      

,)01(rahcrav on_hcnarb_g@      

,)01(rahcrav on_hcnarb_sl@      

,)552(rahcrav eulav_rav_sl@      

,)0,2(ciremun wor_ll@      

额金费消计累别类卡的到级升要----- ,)4,61(ciremun ot_tma_etadpu_nl@      

额金费消计累的别类卡前当----,)4,61(ciremun won_tma_etadpu_nl@      

分积计累别类卡的到级升要----- ,)4,61(ciremun ot_cca_etadpu_nl@      

分积计累的别类卡前当----,)4,61(ciremun won_cca_etadpu_nl@      

,)02(rahc on_wolf_sl@      

,)0,2(ciremun tnuoc_l@      

别类卡新---- ,)2(rahc epyt_drac_ot@      

别类卡原--,)2(rahc  epyt_drac@      

额费消按 1 分积按 0 则规级升动自--,)1(rahc epytpu_piv@      

别类员会级升动自用启否是--,)1(rahc etadpu_piv@      

额金余剩费消值储--,)4,61(ciremun tma_laudiser_nl@      

数次费消--	,tni mun_elas_nl@      

值分积 --  ,)4,61(ciremun mun_cca_nl@      

额金费消 --    ,)4,61(ciremun tma_musnoc_nl@      

型类作操 --        ,)1(rahc epyt_repo_sl@      

号卡员会 --       ,)02(rahc didrac_sl@ eralced  


nigeb

sa

etadpu,tresni rof

tsilyap_drac_mr_t no tresni_tsilyap_drac_mr_t reggirt etaerc



og

tresni_tsilyap_drac_mr_t REGGIRT pord  

)'tresni_tsilyap_drac_mr_t'=eman erehw stcejbosys morf 1 tceles(stsixe fi

####$$$$$$t_rm_saving_plus_record_insert(MS).sql^^^^

dne

	

)'0',epyt_repo_sl@,tma_musnoc_nl@,didrac_sl@,on_hcnarb_sl@,'4'(seulav )galf_dnes,epyt_repo,tma_tsilevas,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni		

值充卡值储--  '1' = )1,eulav_rav_sl@(tfel fi	

)))'evas_drac'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES	


'0' = eulav_rav_sl@ tes	

'4' = epyt_repo_sl@ tceles	


nruter 		

 '值储转分积' = )1rehto_sl@(mirtr fi	


detresni morf        	

1rehto = 1rehto_sl@		

,on_hcnarb=on_hcnarb_sl@		

,tnuoc_sulp=tma_musnoc_nl@		

,di_drac=didrac_sl@	 tceles	

据数前当 --      

      

	)04(rahcrav 1rehto_sl@      

,)01(rahcrav on_hcnarb_g@      

,)01(rahcrav on_hcnarb_sl@      

,)552(rahc eulav_rav_sl@      

,)1(rahc epyt_repo_sl@      

额金值充 --  ,)4,61(ciremun tma_musnoc_nl@      

号卡员会 --       ,)02(rahc didrac_sl@ eralced  


nigeb

sa

tresni rof

drocer_sulp_gnivas_mr_t no tresni_drocer_sulp_gnivas_mr_t reggirt etaerc


og

tresni_drocer_sulp_gnivas_mr_t REGGIRT pord  

)'tresni_drocer_sulp_gnivas_mr_t'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$t_rm_vip_good_flow_insert(MS).sql^^^^

dne



dne		

dne			

)'5','0',tma_musnoc_nl@,didrac_sl@,didrac_sl@,on_hcnarb_sl@,'2'(seulav					

 )epyt_repo,galf_dnes,mun_cca_vig,drac_rehtaf,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni					

送赠分积-- 					

 '1' = )1,eulav_rav_sl@(tfel fi        				

)))'5vig_piv'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES				

nigeb			

 0 > wor_ll@ fi		

nigeb		

'3' = epyt_repo_sl@ fi    

dne		

dne			

)'3','0',tma_musnoc_nl@,didrac_sl@,didrac_sl@,on_hcnarb_sl@,'2'(seulav					

 )epyt_repo,galf_dnes,mun_cca_vig,drac_rehtaf,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni					

品商换兑分积-- 					

 '1' = )1,eulav_rav_sl@(tfel fi        				

)))'3vig_piv'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES				

nigeb			

 0 > wor_ll@ fi		

nigeb		

'2' = epyt_repo_sl@ fi	


		

dne		

dne			

)on_meti_fgv@,'6','0',tma_musnoc_nl@,didrac_sl@,didrac_sl@,on_hcnarb_sl@,'2'(seulav					

 )tma_egnahc,epyt_repo,galf_dnes,mun_cca_vig,drac_rehtaf,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni				

 '1' = )1,eulav_rav_sl@(tfel fi			

)))'6vig_piv'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES				

nigeb			

 0 > wor_ll@ fi		

nigeb		

 '4' = epyt_repo_sl@ fi	

值储转分积--	


'metsys_sys_t_ssem' = eman erehw stcejbosys morf )*(tnuoc = wor_ll@ tceles	

表数参信短有否是断判，信短动自--	

)2,on_hcnarb_sl@(tfel = on_hcnarb_sl@ tceles	

	

detresni morf		

galf_fgv = epyt_repo_sl@		

,on_hcnarb_fgv=on_hcnarb_sl@		

,on_meti_fgv=on_meti_fgv@		

,mun_piv_fgv=tma_musnoc_nl@		

,on_piv_fgv=didrac_sl@	 tceles	

据数水流分积售销前当 --	

)02(rahcrav on_meti_fgv@      

,)01(rahcrav on_hcnarb_g@      

,)01(rahcrav on_hcnarb_sl@      

,)552(rahcrav eulav_rav_sl@      

,)0,2(ciremun wor_ll@      

额金费消计累别类卡的到级升要----- ,)4,61(ciremun ot_tma_etadpu_nl@      

额金费消计累的别类卡前当----,)4,61(ciremun won_tma_etadpu_nl@      

分积计累别类卡的到级升要----- ,)4,61(ciremun ot_cca_etadpu_nl@      

分积计累的别类卡前当----,)4,61(ciremun won_cca_etadpu_nl@      

,)02(rahc on_wolf_sl@      

,)0,2(ciremun tnuoc_l@      

别类卡新---- ,)2(rahc epyt_drac_ot@      

别类卡原--,)2(rahc  epyt_drac@      

额费消按 1 分积按 0 则规级升动自--,)1(rahc epytpu_piv@      

别类员会级升动自用启否是--,)1(rahc etadpu_piv@      

数次费消--	,tni mun_elas_nl@      

值分积 --  ,)4,61(ciremun mun_cca_nl@      

额金费消 --    ,)4,61(ciremun tma_musnoc_nl@      

型类作操 --        ,)1(rahc epyt_repo_sl@      

号卡员会 --       ,)02(rahc didrac_sl@ eralced  


nigeb

sa

tresni rof

wolf_doog_piv_mr_t no tresni_wolf_doog_piv_mr_t reggirt etaerc



og

tresni_wolf_doog_piv_mr_t REGGIRT pord  

)'tresni_wolf_doog_piv_mr_t'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$tr_bd_i_item_info(MS).sql^^^^

dne


)on_meti.a = on_meti.c dna on_hcnarb.b = on_hcnarb.c erehw c ecirp_hcnarb_cp_t morf 1 tceles( stsixe ton   dna    	

)'1','0'( ni ytreporp.b erehw    	

 b ofni_hcnarb_db_t  ,a detresni morf            

sutats.a,4ecirp_esab.a,3ecirp_esab.a,2ecirp_esab.a,1ecirp_esab.a,kcots_meti.a,'1',ecirp_hcnarb.a,etar_yl_pus.a,ecirp_piv.a       	

,ecirp_elas.a,ecirp_esab.a,)dne ecirp.a esle ecirp_snart.a neht '2' nehw epyt_edart esac(,galf_pus_meti.a,tsucpus_niam.a,on_meti.a, on_hcnarb.b tceles	

)sutats,4ecirp_esab ,3ecirp_esab ,2ecirp_esab ,1ecirp_esab ,kcots_meti,elas_hcnarb,ecirp_hcnarb,etar_yl_pus ,ecirp_piv        	

,ecirp_elas,ecirp_esab ,ecirp,yaw_elas,on_tsucpus,on_meti,on_hcnarb( ecirp_hcnarb_cp_t tresni	

32-21-5002 sjuw yb deifidom 表息信品商构机写--        


) tsucpus_niam.a = on_tsucpus.c dna                                

 on_meti.a = on_meti.c dna                                

 on_hcnarb.b = on_hcnarb.c erehw                              

 c meti_tsucpus_db_t morf 1 tceles( stsixe ton dna           

) ))'3','1'( ni epyt_edart.b dna '0' = ytreporp.b( ro '1' = ytreporp.b( erehw         

b ofni_hcnarb_db_t ,a detresni morf           

)(etadteg,galf_pus_meti.a,tsucpus_niam.a ,on_meti.a, on_hcnarb.b tceles         

)etad_tcartnoc,yaw_elas,on_tsucpus,on_meti,on_hcnarb( meti_tsucpus_db_t tresni 	

32-21-5002 sjuw yb deifidom 表系关商应供品商写--         


ruc_meti_tresni etacollaed	

ruc_meti_tresni esolc	

dne	

kcots_tini@,ecirp@,yaw_selas@,tsucpus_niam@,on_meti@ otni ruc_meti_tresni hctef		


dne		

)'存库初期' , '1001' , 'A' , tsucpus_niam@ , dne '+' esle '-' neht 0 < kcots_tini@ nehw esac , 'DP' , '' , on_hcnarb@ , ) 0 , ecirp@ ( llunsi* ) 0 , ) kcots_tini@ ( sba ( llunsi , ) 0 , ecirp@ ( llunsi , ) 0 , ) kcots_tini@ ( sba ( llunsi , on_meti@ , )(etadteg , 'DP' (seulav			

 ) omem , di_repo , yaw_elas , on_tsucpus , on_bd , on_snart , on_hcnarb_d , on_hcnarb , tma_teehs , ecirp , ytq_laer , on_meti , etad_repo , on_rehcuov ( wolf_mi_t otni tresni			

nigeb		

0>kcots_tini@ fi		

存库初期成生 80308102 nahnol yb dda--		


)'dda',llun ,)(etadteg ,on_meti@ ,'I' ,'ofni_meti_db_t'( seulav			

)7yek,on_hcnarb ,etad_etadpu ,1yek ,epyt_egnahc ,elbat_moc( atad_mc_sys_t otni tresni		


)ecirp@,on_hcnarb@ ,on_meti@( seulav )tsoc_gva,on_hcnarb,on_meti( kcots_hcnarb_mi_t tresni			

)on_meti@ = on_meti dna on_hcnarb@ = on_hcnarb erehw kcots_hcnarb_mi_t morf on_meti tceles(stsixe ton fi		



nigeb	

0=sutats_hctef@@ elihw	

kcots_tini@,ecirp@,yaw_selas@,tsucpus_niam@,on_meti@ otni ruc_meti_tresni hctef	

ruc_meti_tresni nepo	

ylno daer rof		

detresni morf kcots_tini,ecirp,galf_pus_meti,tsucpus_niam,on_meti  tceles		

rof rosruc ruc_meti_tresni eralced	

入插--	

	

'10' + on_hcnarb@ = on_hcnarb@ tceles	

'on_hcnarb_g'=di_rav_sys erehw metsys_sys_t morf eulav_rav_sys=on_hcnarb@ tceles	

库仓的认默统系--	

	

存库初期-- )4,61(ciremun kcots_tini@ eralced	

)4,81(ciremun ecirp@,)01(rahcrav on_hcnarb@,)01(rahcrav yaw_selas@,)02(rahcrav tsucpus_niam@,)02(rahcrav on_meti@ eralced	

)03(rahcrav 1yek@ eralced	--

量变明声--	


nruter			

)'0' = )'detubirtsid_si'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys tceles( 		

ro '1' = )'detubirtsid_si'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys tceles(( ton fi	

90119002.guil 回返则是不果如，版机单或部总锁连是否是查检：为改修--   

回返则是不果如，版式部分是否是查检--	

nigeb

sa

tresni rof

ofni_meti_db_t no ofni_meti_i_db_rt reggirt etaerc


og

ofni_meti_i_db_rt reggirt pord  

)'ofni_meti_i_db_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$tr_rm_payflow(MS).sql^^^^

dne

rosruc_detresni ETACOLLAED

rosruc_detresni ESOLC

:ntr


dne

 

kramer@,epyt_snart@,on_inorecic_sl@ , di_inorecic_sl@ , omem_sl@        , on_retnuoc_sl@    	, on_tfihs_sl@    	

, ONdrac_sl@    	, ONpiv_sl@    	,yaWelas_sl@    	,emiTetaDyap_tdl@    	,etaRnioc_nl@    	,ONnioc_sl@    	

,yaWyap_sl@    	,tmAelas_nl@    ,tmAyap_nl@    	,ONhcnarb_sl@    	,rehsac_sl@    	,diwolf_nl@    	, oNwolf_sl@ otni

 rosruc_detresni HCTEF


dne	

 			

)  ONhcnarb_sl@ ,emiTetaDyap_tdl@ ,rehsac_sl@, oNwolf_sl@, ONhcnarb_sg@ , on_inorecic_sl@ , di_inorecic_sl@ (seulav   								

) di_hcnarB, etad_repO   , di_repO    ,on_wolf    ,on_hcnarB      ,on_inorecic     , di_inoreciC (wolf_on_inorecic_db_t otni tresni		

在存不-- ) oNwolf_sl@ = on_wolf dna ONhcnarb_sg@ = on_hcnarB			

DNA on_inorecic_sl@ = on_inorecic dna di_inorecic_sl@ = di_inoreciC erehw wolf_on_inorecic_db_t morf * tceles (stsixe ton fi		

nigeb	

) '' >< on_inorecic_sl@ ( DNA ) llUN ton si on_inorecic_sl@ ( DNA ) '' >< di_inorecic_sl@ ( DNA ) llUN ton si di_inorecic_sl@ ( fi  

能功游导--  


dne  

dne      

dne			

)kramer@,ONhcnarb_sg@,emiTetaDyap_tdl@ , tmAyap_nl@ ,ONpiv_sl@ ,'1' ,oNwolf_sl@(seulav      	  			

)2rehto,on_hcnarb,emit_yap ,tnuoma ,di_drac ,epyt_drac ,on_wolf(tsilyap_drac_mr_t otni tresni        			

esle				

'1'=epyt_drac dna ONpiv_sl@ = di_drac dna oNwolf_sl@ = on_wolf erehw						

tmAyap_nl@ + tnuoma = tnuoma tes tsilyap_drac_mr_t etadpu					

)'1'=epyt_drac dna ONpiv_sl@ = di_drac dna oNwolf_sl@ = on_wolf erehw tsilyap_drac_mr_t morf * tceles( stsixE fi				

nigeb			

)'4' = epyt_edart dna ONhcnarb_sg@ = on_hcnarb dna 0 = ytreporp erehw ofni_hcnarb_db_t morf on_hcnarb tceles( stsixE ro ONhcnarb_sg@ = on_hcnarb_g_sl@ fi			

31-11-4002 sjuw .传上独单细明款付员会,细明付员会成生再以可不时水流款付的传上部分 --    		

		

etaRnioc_nl@ * tmAyap_nl@ * 1- = tmAyap_nl@ tceles				

'D' = yaWelas_sl@ ro 'B' = yaWelas_sl@ fi			

13-01-6002 ghil yb deifidom 数负录记时货退 --			

nigeb      

)'GHC' >< yaWyap_sl@ dna ) )'D' = yaWelas_sl@( ro )'B' = yaWelas_sl@( ro )'A' = yaWelas_sl@((( fi      

录记时货退和售销常正录记只 --       

nigeb  

)'' >< ONpiv_sl@( DNA )lluN ton si ONpiv_sl@( fi 

 

额总费消卡员会新更,费消卡员会 --  


  

dne--  

dne	

dne.............................................)muSyad_tfihs_mr_t(表结日次班写 --  	

)ONnioc_sl@=on_nioc dna yaWelas_sl@=yaw_elas dna yaWyap_sl@=yaw_yap dna ONhcnarb_sg@=on_hcnarb dna rts_tfihs_sl@=on_tfihs dna rehsac_sl@=on_rehsac dna etad_tfihs_sl@=etad_repo( erehw			

)021,)(etadteg,)91(rahcrav(trevnoc=2rehto,'0'=galf_moc ,tmAyap_nl@+tma_laer=tma_laer tes musyad_tfihs_mr_t etadpu 		

新更，在存已次班 -- 		

esle  	

)llun,)021,)(etadteg,)91(rahcrav(trevnoc,)021,)(etadteg,)91(rahcrav(trevnoc,epyt_repo_sl@,ONnioc_sl@,yaWyap_sl@,yaWelas_sl@,tmAyap_nl@,0,ONhcnarb_sg@,rts_tfihs_sl@,rehsac_sl@,etad_tfihs_sl@     		

(seulav )3rehto,2rehto,1rehto,epyt_repo,on_nioc,yaw_yap,yaw_elas,tma_laer,tma_lles,on_hcnarb,on_tfihs,on_rehsac,etad_repo(musyad_tfihs_mr_t otni tresni 		

间时易交笔一末最次班本为 2rehto 间时易交笔一次班本第置 1rehto 10-90-5002 sjuw yb deifidom --         	

  加增，在存不次班 -- '0'=galFtsixEtfihs_sl@ fi  	

trats.............................................)musyad_tfihs_mr_t(表结日次班写 --  	

	

'1'=galFtsixEtfihs_sl@ tceles 		

在存已 --  esle  	

'0'=galFtsixEtfihs_sl@ tceles 		

在存不 -- ))ONnioc_sl@=on_nioc dna yaWelas_sl@=yaw_elas dna yaWyap_sl@=yaw_yap dna ONhcnarb_sg@=on_hcnarb dna rts_tfihs_sl@=on_tfihs dna rehsac_sl@=on_rehsac dna etad_tfihs_sl@=etad_repo( erehw 		

musyad_tfihs_mr_t morf *tceles(stsixe ton fi  	

	

)1,9,on_tfihs_sl@(gnirtsbus =  rts_tfihs_sl@ tceles  	

)2,7,on_tfihs_sl@(gnirtsbus+'-'+)2,5,on_tfihs_sl@(gnirtsbus+'-'+)4,1,on_tfihs_sl@(gnirtsbus = etad_tfihs_sl@ tceles  	

  		nigeb	

32-20-9002 guil理处不则空为次班-- 0 > ))'',on_tfihs_sl@(llunsi(nel fi	

在存已否是中)musyad_tfihs_mr_t(表结日次班在找查 --  	

 982822-717021-SQ 制控关开受不，据数次班写就，次班有要只 WHAM--  nigeb--  

理管次班否是 --    )))'4' = epyt_edart ro '0' = epyt_edart( dna ONhcnarb_sg@ = on_hcnarb dna 0 = ytreporp erehw ofni_hcnarb_db_t morf on_hcnarb tceles( stsixE dna '' >< )'',on_tfihs_sl@(llunsi( ro '1' = lrtc_tfihs_sg@ fi--  

  


dne  

dne.............................................)muSyad_rehsac_mr_t(表结日员银收写 --        

)ONnioc_sl@=on_nioc dna yaWelas_sl@=yaw_elas dna yaWyap_sl@=yaw_yap dna ONhcnarb_sg@=on_hcnarb dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw           

'0'=galf_moc ,tmAyap_nl@+tma_laer=tma_laer tes musyad_rehsac_mr_t etadpu        

新更，在存已员银收 --        

esle     

)llun,llun,llun,epyt_repo_sl@,ONnioc_sl@,yaWyap_sl@,yaWelas_sl@,tmAyap_nl@,0,ONhcnarb_sg@,rehsac_sl@,etaDrepo_sl@(seulav	

)3rehto,2rehto,1rehto,epyt_repo,on_nioc,yaw_yap,yaw_elas,tma_laer,tma_lles,on_hcnarb,on_rehsac,etad_repo(musyad_rehsac_mr_t otni tresni        

员银收为只省缺,'0'=epyt_repo：注 --  加增，在存不员银收 -- '0'=galFtsixErehsac_sl@ fi     

trats.............................................)muSyad_rehsac_mr_t(表结日员银收写 --      


'1'=galFtsixErehsac_sl@ tceles          

在存已 --  esle     

'0'=galFtsixErehsac_sl@ tceles          

在存不 -- ))ONnioc_sl@=on_nioc dna yaWelas_sl@=yaw_elas dna yaWyap_sl@=yaw_yap dna ONhcnarb_sg@=on_hcnarb dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw        

musyad_rehsac_mr_t morf * tceles(stsixe ton fi     

在存已否是中)muSyad_rehsac_mr_t(表结日员银收在找查 --     

nigeb  

))'4' = epyt_edart ro '0' = epyt_edart( dna ONhcnarb_sg@ = on_hcnarb dna 0 = ytreporp erehw ofni_hcnarb_db_t morf on_hcnarb tceles( stsixE     

 ro )ONhcnarb_sg@ = on_hcnarb_g_sl@( fi  

	部分SOP  01-10-5002  cgnauh yb deifidoM --  

部总到传上独单报日银收的部分理管立独,31-11-4002 sjuw  表结日员银收写可才水流SOP的传上部分的管托部总或构机前当 --  


)121,emiTetaDyap_tdl@,)01(rahc(trevnoc=etaDrepo_sl@ tceles  

dd-mm-yyyy=121：为式格，）天当（期日型符字换转 --  


'lrtc_tfihs'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys = lrtc_tfihs_sg@ tceles  

）中表统系在（理管次班行进否是统系到得 --  

 

 )2,ONhcnarb_sl@(tfel = ONhcnarb_sg@ tceles	

esle  

on_hcnarb_g_sl@ = ONhcnarb_sg@ tceles	

 '' = ONhcnarb_sl@ ro llun si ONhcnarb_sl@ fi  



'on_hcnarb_g'=)di_rav_sys(rewol erehw metsys_sys_t morf	

 eulav_rav_sys = on_hcnarb_g_sl@ tceles  

 


 dne     

'0' = epyt_repo_sl@ tceles	

nigeb     

esle  

dne     

'1' = epyt_repo_sl@ tceles	     

nigeb     

'VEL' = epyt_snart@ ro 'PPT' = epyt_snart@ fi  


oNwolf_sl@ = on_wolf erehw '1'= galf_yap tes dnes_tsucelas_mr_t etadpu	

  '款回送外'=omem_sl@ fi  


ntr otog  'YAP_DRO'=omem_sl@ dna 'A'=yaWelas_sl@ dna 'DRO'=yawyap_sl@ fi  

回返接直应时此，等表结日员银收次一了写经已就时金订付在为因，作操下以做再用不时算结款付来金订用调---- 

NIGEB

0 = SUTATS_HCTEF@@ ELIHW

kramer@,epyt_snart@ ,on_inorecic_sl@ , di_inorecic_sl@ ,  omem_sl@        , on_retnuoc_sl@    	, on_tfihs_sl@    	

, ONdrac_sl@    	, ONpiv_sl@    	,yaWelas_sl@    	,emiTetaDyap_tdl@    	,etaRnioc_nl@    	,ONnioc_sl@    	

,yaWyap_sl@    	,tmAelas_nl@    ,tmAyap_nl@    	,ONhcnarb_sl@    	,rehsac_sl@    	,diwolf_nl@    	, oNwolf_sl@ otni

 rosruc_detresni HCTEF


rosruc_detresni NEPO


传不心中送配且,理处不回返接直时传上店分立独-- NRUTER ) '1' = galf_etomer@ ( fi  --

表结日到据数细明输传否是 -- 


llun si galf_etomer ro '1' >< galf_etomer erehw	

 detresni morf  

kramer        

,epyt_snart,on_inorecic , di_inorecic , )omem(mirtr         ,on_retnuoc     	,on_tfihs     	,on_drac     	,on_piv    	,yaw_lles    	,etad_repo    	,etar_nioc    	,on_nioc    	

,yaw_yap    	,tnuoma_elas    	,tnuoma_yap    	,on_hcnarb    	,di_repo    	,di_wolf    	,on_wolf  tceles

 ROF ROSRUC rosruc_detresni ERALCED  


)552(rahcrav              kramer@          

,)1(rahc         epyt_repo_sl@  		

型类务业--         ,)3(rahc            epyt_snart@          

号牌--     ,)01(rahcrav        on_inorecic_sl@          

号编游导--    , )6(rahcrav        di_inorecic_sl@      	

明说付支金订--     ,)552(rahcrav              omem_sl@          

码代构机部总--    , )01(rahcrav       on_hcnarb_g_sl@      	

额售销卡行银--  ,)4,61(ciremun      tma_dracknab_nl@      	

  ,)4,61(ciremun           tma_ter_nl@      	

)币位本(额金售销--  ,)4,61(ciremun          tma_elas_nl@      	

号台柜--        ,)4(rahc        on_retnuoc_sl@      	

      ,)1(rahc    galFtsixEtfihs_sl@      	

,)1(rahc  galFtsixEretnuoc_sl@      	

)4,3,2,1(号次班--        ,)1(rahc         rts_tfihs_sl@      	

期日次班--       ,)01(rahc        etad_tfihs_sl@      	

号次班--        ,)9(rahc          on_tfihs_sl@      	

理管次班否是--        ,)1(rahc        lrtc_tfihs_sg@      	

理管柜专同合否是--        ,)1(rahc      lrtc_retnuoc_sg@      	

,)4,61(ciremun		 tmaevitan_nl@      	

,)2,01(lamiced			  elacs_nl@      	

在存已='1'；在存不='0'，志标在存已否是中)muSyad_rehsac_mr_t(表结日银收在员银收 --,)1(rahc	 galFtsixErehsac_sl@      	

号卡值储 --     ,)02(rahcrav			 ONdrac_sl@      	

号卡员会 --      ,)02(rahcrav			 ONpiv_sl@      	

ddmmyyyy：为式格，）天当（期日型符字 --      ,)01(rahc			 etaDrepo_sl@      	

式方售销 --        ,)1(rahc			 yaWelas_sl@      	

间时款付 --  ,emitetad		 emiTetaDyap_tdl@      	

率汇种币 --  ,)4,6(lamiced			 etaRnioc_nl@      	

种币 --         ,)3(rahc			 ONnioc_sl@      	

)3>--2(--式方款付 --         ,)3(rahc			 yaWyap_sl@      	

额金款付 --   ,)4,61(ciremun			 tmAyap_nl@      	

额金售销 --  ,)4,61(ciremun			 tmAelas_nl@      	

码编库仓 --       ,)6(rahc			 ONhcnarb_sl@      	

码编库仓 --       ,)6(rahc			 ONhcnarb_sg@      	

号序售销 --    ,)0,3(ciremun			 dIwolf_nl@      	

号售销 --        ,)41(rahc			 oNwolf_sl@      	

员银收 --     ,)4(rahc			 rehsac_sl@ eralced  

								

NRUTER '1' = )detresni morf galf_etomer tceles( fi  --

表结日到据数细明输传否是 --  

nigeb

sa

tresni rof

 wolfyap_mr_t no wolfyap_mr_rt reggirt etaerc



og

wolfyap_mr_rt REGGIRT pord  

)'wolfyap_mr_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$tr_rm_saleflow(MS).sql^^^^


DNE

rosruc_detresni ETACOLLAED

rosruc_detresni ESOLC

ofni_erom_nc_bat# elbat pord

:ntr

dne  

	

yenom_elas_cedl@,on_teehs_cic_sl@,on_teehs_ceps_sl@,galf_etomer@  		

,on_retnuoc_sl@  	,di_wolf@  		

,on_wolf@  	,tmAtcd_nl@  		

,galf_ceps_sl@  	,rehsac_sl@  		

,emiTetaDelas_tdl@  	,yaWelas_sl@  		

,crPelas_nl@  	,crPecruos_nl@  		

,ytQelas_nl@,ONmetI_sl@,ONhcnarb_sl@ OTNI	

 rosruc_detresni MORF TXEN HCTEF     

dne		

dne					

1 + di_bat_nim_ll@ = di_bat_nim_ll@ tes						

dne							

					) )dne '' esle di_etnc_sl@ neht '1' = galf_cic_erom_sl@ nehw esac(											

,)121,emiTetaDelas_tdl@,)01(rahcrav(trevnoc,etar_levart_cedl@,'2',) dne ytQelas_nl@  esle 0 neht 'c' nehw ytQelas_nl@ - neht 'B' nehw yaWelas_sl@ esac(,) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac(											

,etar_levart_cedl@ * ) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac(,onslc_meti_sl@,)2,ONhcnarb_sl@(tfel,on_teehs_cic_sl@( seulav									

)di_etnc,etad_repo,etar,epyt_mf,ytnq_elas,tma_elas,tma_laer,onslc_meti,on_hcnarb,on_teehs_cic( musyad_nc_mr_t otni tresni									

esle								

))'1' >< galf_cic_erom_sl@( ro )di_etnc_sl@ = di_etnc.musyad_nc_mr_t dna '1' = galf_cic_erom_sl@((  										

dna )121,emiTetaDelas_tdl@,)01(rahcrav(trevnoc = etad_repo  										

dna '2' = epyt_mf  										

dna onslc_meti_sl@ = onslc_meti  										

dna )2,ONhcnarb_sl@(tfel = on_hcnarb  										

 dna on_teehs_cic_sl@ = on_teehs_cic erehw									

) dne ytQelas_nl@  esle 0 neht 'c' nehw ytQelas_nl@ - neht 'B' nehw yaWelas_sl@ esac( + ytnq_elas = ytnq_elas  															

,) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac( + tma_elas = tma_elas  															

,etar * ) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac( + tma_laer = tma_laer tes musyad_nc_mr_t etadpu									

)   															

))'1' >< galf_cic_erom_sl@( ro )di_etnc_sl@ = di_etnc.musyad_nc_mr_t dna '1' = galf_cic_erom_sl@((   															

dna )121,emiTetaDelas_tdl@,)01(rahcrav(trevnoc = etad_repo   															

dna '2' = epyt_mf   															

dna onslc_meti_sl@ = onslc_meti   															

dna )2,ONhcnarb_sl@(tfel = on_hcnarb   									   						

 dna on_teehs_cic_sl@ = on_teehs_cic erehw 													    

 )kcolon(htiw musyad_nc_mr_t morf 1 1 pot tceles(stsixe fi								

								

dne									

0 = etar_levart_cedl@ tes											

1 >< tsixe_ll@ fi										

csed onslc_meti.slc_meti_db_t,csed )dne '2' esle '1' neht 0 =< etar_levart.slc_meti_db_t nehw esac( yb redro										

ONmetI_sl@ = on_meti.ofni_meti_db_t  											

dna )onslc_meti.ofni_meti_db_t(nel =< )onslc_meti.slc_meti_db_t(nel  											

 dna ))onslc_meti.slc_meti_db_t(nel,onslc_meti.ofni_meti_db_t(tfel = onslc_meti.slc_meti_db_t erehw										

)kcolon(htiw ofni_meti_db_t,)kcolon(htiw slc_meti_db_t morf										

onslc_meti.slc_meti_db_t = onslc_meti_sl@,1 = tsixe_ll@,etar_levart.slc_meti_db_t = etar_levart_cedl@ 1 pot tceles										

0 = tsixe_ll@ tes										

nigeb									

1 >< tsixe_ll@ fi								


csed onslc_meti.etar_slc_meti_nc_t yb redro								

))'1' >< galf_cic_erom_sl@( ro )di_etnc_sl@ = di_etnc.etar_slc_meti_nc_t dna '1' = galf_cic_erom_sl@((  									

dna on_teehs_cic_sl@ = on_teehs_cic.etar_slc_meti_nc_t  									

dna ONmetI_sl@ = on_meti.ofni_meti_db_t  									

dna )onslc_meti.ofni_meti_db_t(nel =< )onslc_meti.etar_slc_meti_nc_t(nel  									

 dna ))onslc_meti.etar_slc_meti_nc_t(nel,onslc_meti.ofni_meti_db_t(tfel = onslc_meti.etar_slc_meti_nc_t  									

dna '2' = epyt.etar_slc_meti_nc_t erehw								

)kcolon(htiw ofni_meti_db_t,)kcolon(htiw etar_slc_meti_nc_t morf								

onslc_meti.etar_slc_meti_nc_t = onslc_meti_sl@,1 = tsixe_ll@,etar.etar_slc_meti_nc_t = etar_levart_cedl@ 1 pot tceles								

 nigeb							

成提社行旅52-20-4102-pduoy---							

esle						

------							

dne							

										

) )dne '' esle di_etnc_sl@ neht '1' = galf_cic_erom_sl@ nehw esac( 											

,)121,emiTetaDelas_tdl@,)01(rahcrav(trevnoc,etar_inorecic_cedl@,'1',) dne ytQelas_nl@  esle 0 neht 'c' nehw ytQelas_nl@ - neht 'B' nehw yaWelas_sl@ esac(,) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac(											

,etar_inorecic_cedl@ * ) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac(,onslc_meti_sl@,)2,ONhcnarb_sl@(tfel,on_teehs_cic_sl@( seulav									

)di_etnc,etad_repo,etar,epyt_mf,ytnq_elas,tma_elas,tma_laer,onslc_meti,on_hcnarb,on_teehs_cic( musyad_nc_mr_t otni tresni									

esle								

))'1' >< galf_cic_erom_sl@( ro )di_etnc_sl@ = di_etnc.musyad_nc_mr_t dna '1' = galf_cic_erom_sl@((  										

dna )121,emiTetaDelas_tdl@,)01(rahcrav(trevnoc = etad_repo  										

dna '1' = epyt_mf  										

dna onslc_meti_sl@ = onslc_meti  										

dna )2,ONhcnarb_sl@(tfel = on_hcnarb  										

 dna on_teehs_cic_sl@ = on_teehs_cic erehw									

) dne ytQelas_nl@  esle 0 neht 'c' nehw ytQelas_nl@ - neht 'B' nehw yaWelas_sl@ esac( + ytnq_elas = ytnq_elas  															

,) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac( + tma_elas = tma_elas  															

,etar * ) dne yenom_elas_cedl@  esle 0 neht 'c' nehw yenom_elas_cedl@ - neht 'B' nehw yaWelas_sl@ esac( + tma_laer = tma_laer tes musyad_nc_mr_t etadpu									

)   															

))'1' >< galf_cic_erom_sl@( ro )di_etnc_sl@ = di_etnc.musyad_nc_mr_t dna '1' = galf_cic_erom_sl@((   															

 dna )121,emiTetaDelas_tdl@,)01(rahcrav(trevnoc = etad_repo   															

dna '1' = epyt_mf   															

dna onslc_meti_sl@ = onslc_meti   															

dna )2,ONhcnarb_sl@(tfel = on_hcnarb   								   							

 dna on_teehs_cic_sl@ = on_teehs_cic erehw 												    	

 )kcolon(htiw musyad_nc_mr_t morf 1 1 pot tceles(stsixe fi								

								

dne									

0 = etar_inorecic_cedl@ tes											

1 >< tsixe_ll@ fi										

csed onslc_meti.slc_meti_db_t,csed )dne '2' esle '1' neht 0 =< etar_inorecic.slc_meti_db_t nehw esac( yb redro										

ONmetI_sl@ = on_meti.ofni_meti_db_t  											

dna )onslc_meti.ofni_meti_db_t(nel =< )onslc_meti.slc_meti_db_t(nel  											

 dna ))onslc_meti.slc_meti_db_t(nel,onslc_meti.ofni_meti_db_t(tfel = onslc_meti.slc_meti_db_t erehw										

)kcolon(htiw ofni_meti_db_t,)kcolon(htiw slc_meti_db_t morf										

onslc_meti.slc_meti_db_t = onslc_meti_sl@,1 = tsixe_ll@,etar_inorecic.slc_meti_db_t = etar_inorecic_cedl@ 1 pot tceles										

0 = tsixe_ll@ tes										

nigeb									

1 >< tsixe_ll@ fi								


csed onslc_meti.etar_slc_meti_nc_t yb redro								

))'1' >< galf_cic_erom_sl@( ro )di_etnc_sl@ = di_etnc.etar_slc_meti_nc_t dna '1' = galf_cic_erom_sl@((  									

dna on_teehs_cic_sl@ = on_teehs_cic.etar_slc_meti_nc_t  									

 dna ONmetI_sl@ = on_meti.ofni_meti_db_t  									

dna )onslc_meti.ofni_meti_db_t(nel =< )onslc_meti.etar_slc_meti_nc_t(nel  									

 dna ))onslc_meti.etar_slc_meti_nc_t(nel,onslc_meti.ofni_meti_db_t(tfel = onslc_meti.etar_slc_meti_nc_t  									

dna '1' = epyt.etar_slc_meti_nc_t erehw								

)kcolon(htiw ofni_meti_db_t,)kcolon(htiw etar_slc_meti_nc_t morf								

onslc_meti.etar_slc_meti_nc_t = onslc_meti_sl@,1 = tsixe_ll@,etar.etar_slc_meti_nc_t = etar_inorecic_cedl@ 1 pot tceles								

nigeb							

成提游导52-20-4102-pduoy----------------							

 '1' = epyt_etnc_sl@ fi						

di_bat_nim_ll@ = di_bat erehw )kcolon(htiw ofni_erom_nc_bat# morf di_etnc = di_etnc_sl@,epyt_etnc = epyt_etnc_sl@ tceles						

					

				0 = etar_levart_cedl@ tes						

'' =    di_etnc_sl@ tes						

'' =  epyt_etnc_sl@ tes						

'' = onslc_meti_sl@ tes						

0 = etar_inorecic_cedl@ tes						

0 = tsixe_ll@ tes						

nigeb					

0 > di_bat_nim_ll@ dna 0 > di_bat_xam_ll@ dna 0 => di_bat_nim_ll@ - di_bat_xam_ll@ elihw				

				

)0,di_bat_nim_ll@(llunsi = di_bat_nim_ll@ tes				

)0,di_bat_xam_ll@(llunsi = di_bat_xam_ll@ tes				

ofni_erom_nc_bat# morf )di_bat(nim = di_bat_nim_ll@,)di_bat(xam = di_bat_xam_ll@ tceles				

0 = di_bat_nim_ll@ tes				

0 = di_bat_xam_ll@ tes				

				

				dne				

dne						

on_teehs_cic_sl@ = on_teehs.b_bat erehw							

)kcolon(htiw b_bat sa yrotsih_nc_t morf							

di_etnc sa di_levart.b_bat,epyt_etnc sa '2' tcnitsid tceles							

noinu							

on_teehs_cic_sl@ = on_teehs.b_bat erehw							

 )kcolon(htiw b_bat sa yrotsih_nc_t morf							

di_etnc sa di_inorecic.b_bat,epyt_etnc sa '1' tcnitsid tceles							

)di_etnc,epyt_etnc(ofni_erom_nc_bat# otni tresni							

nigeb						

esle					

dne						

on_teehs_cic_sl@ = on_teehs_cic.b_bat erehw							

)kcolon(htiw b_bat sa yrotsih_erom_nc_t morf							

di_etnc sa di_levart.b_bat,epyt_etnc sa '2' tcnitsid tceles							

noinu							

on_teehs_cic_sl@ = on_teehs_cic.b_bat erehw							

 )kcolon(htiw b_bat sa yrotsih_erom_nc_t morf							

di_etnc sa di_inorecic.b_bat,epyt_etnc sa '1' tcnitsid tceles							

)di_etnc,epyt_etnc(ofni_erom_nc_bat# otni tresni							

nigeb						

-------------游导多--- '1' = galf_cic_erom_sl@ fi					

					

ofni_erom_nc_bat# eteled					

					

)'0',galf_cic_erom_sl@(llunsi = galf_cic_erom_sl@ tes					

on_teehs_cic_sl@ = on_teehs.yrotsih_nc_t erehw )kcolon(htiw yrotsih_nc_t morf galf_cic_erom = galf_cic_erom_sl@ 1 pot tceles					

'0' = galf_cic_erom_sl@ tes					

			on_teehs_cic_sl@ = pmt_on_teehs_cic_sl@ tes					

nigeb				

pmt_on_teehs_cic_sl@ >< on_teehs_cic_sl@ fi			

52-20-4102--pduoy----			

'' = onslc_meti_sl@ tes			

0 = etar_inorecic_cedl@ tes			

0 = tsixe_ll@ tes			

nigeb		

'' >< ))on_teehs_cic_sl@(mirtr(mirtl fi	

)'',on_teehs_cic_sl@(llunsi = on_teehs_cic_sl@ tes	

表成提别类-费消游导写-42-40-3102-pduoy--------	

		

dne 				

dne   				

ONmetI_sl@ = on_meti dna )2,ONhcnarb_sl@(tfel = on_hcnarb dna on_teehs_ceps_sl@ = 3rehto erehW					

'0' = galf_moc, ytQelas_nl@ - ytq_dlos = ytq_dlos teS ecirp_ceps_mr_t ETADPU 					

nigeb					

'B' = yaWelas_sl@ fi  				

dne					

ONmetI_sl@ = on_meti dna )2,ONhcnarb_sl@(tfel = on_hcnarb dna on_teehs_ceps_sl@ = 3rehto erehW					

'0' = galf_moc,ytq_dlos + ytQelas_nl@ = ytq_dlos teS ecirp_ceps_mr_t ETADPU 					

nigeb					

'A' = yaWelas_sl@ fi  				

nigeb 				

ESLE 			

dne 				

dne   				

 )2,ONhcnarb_sl@(tfel = on_hcnarb dna on_teehs_ceps_sl@ = 3rehto erehW					

'0' = galf_moc, ytQelas_nl@ - ytq_dlos = ytq_dlos teS ecirp_ceps_mr_t ETADPU 					

nigeb					

'B' = yaWelas_sl@ fi  				

dne					

 )2,ONhcnarb_sl@(tfel = on_hcnarb dna on_teehs_ceps_sl@ = 3rehto erehW					

'0' = galf_moc,ytq_dlos + ytQelas_nl@ = ytq_dlos teS ecirp_ceps_mr_t ETADPU 					

nigeb					

'A' = yaWelas_sl@ fi  				

nigeb				

量变个这用 52213102 wdgnauh----------- 号货带不牌品别类-- 'up' = wen_galf_ceps_sl@ fi			

量变个这用 52213102 wdgnauh-----------   '' >< )'',wen_galf_ceps_sl@(llunsi fi		

量变个这用 52213102 wdgnauh----------- ))2,on_teehs_ceps_sl@(tfel(rewol = wen_galf_ceps_sl@ tceles		

    

)on_retnuoc_sl@ = on_retnuoc       		

 dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb dna etaDrepo_sl@=etad_repo( erehw                

'0'=galf_moc ,tma_ter_nl@+tma_ter=tma_ter ,tma_elas_nl@+tma_elas=tma_elas tes                 

 musyad_retnuoc_mr_t etadpu          

tma_dracknab_nl@+tma_dracknab=tma_dracknab         新更，在存已台柜 -- esle      

tma_dracknab_nl@ -- )llun,llun,0,tma_ter_nl@,tma_elas_nl@,on_retnuoc_sl@,)2,1,ONhcnarb_sl@(gnirtsbus,etaDrepo_sl@(seulav             

 )1rebmun,1rehto,tma_dracknab,tma_ter,tma_elas,on_retnuoc,on_hcnarb,etad_repo(                   

musyad_retnuoc_mr_t otni tresni          

加增，在存不台柜 --          

))on_retnuoc_sl@=on_retnuoc dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb dna etaDrepo_sl@=etad_repo( erehw             

musyad_retnuoc_mr_t morf *tceles(stsixe ton fi      


dne      

0 = tma_dracknab_nl@, -- 0 = tma_elas_nl@ ,tmAelas_nl@ = tma_ter_nl@ tceles          

nigeb      

货退 --  esle      

dne      

0 = tma_ter_nl@ ,tmAelas_nl@ = tma_elas_nl@ tceles				

esle			

0 = tma_ter_nl@ ,0 = tma_elas_nl@ tceles				

 'C' = yaWelas_sl@ fi			

送赠要需不---pduoy-50-50-2102 --			

nigeb      

送赠或售销 --   'C' = yaWelas_sl@ ro 'A' = yaWelas_sl@ fi      

trats.............................................)musyad_retnuoc_mr_t(表结日台柜写 --      


dne      

    	


dne				

)'BMR'=on_nioc dna yaWelas_sl@=yaw_elas										

 dna yawyap_sl@=yaw_yap dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb										

dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw										

'0'=galf_moc,tmAtnuocsid_nl@=1mun tes musyad_rehsac_mr_t etadpu					


tmAtcd_nl@ + tmAtnuocsid_nl@ = tmAtnuocsid_nl@ tceles					


)'BMR'=on_nioc dna yaWelas_sl@=yaw_elas   					

dna yawyap_sl@=yaw_yap dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb   					

 dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw						

   musyad_rehsac_mr_t morf )0,1mun(llunsi = tmAtnuocsid_nl@ tceles					

  nigeb				

     esle			

dne				

)'BMR'=on_nioc dna yaWelas_sl@=yaw_elas					

 dna yawyap_sl@=yaw_yap dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb					

dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw					

'0'=galf_moc,tmAtnuocsid_nl@=tma_laer tes musyad_rehsac_mr_t etadpu					


tmAtcd_nl@ + tmAtnuocsid_nl@ = tmAtnuocsid_nl@ tceles					


)'BMR'=on_nioc dna yaWelas_sl@=yaw_elas   				

dna yawyap_sl@=yaw_yap dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb   				

 dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw					

   musyad_rehsac_mr_t morf )0,tma_laer(llunsi = tmAtnuocsid_nl@ tceles					

nigeb				

  'FIG' = yawyap_sl@ dna 'C'= yaWelas_sl@ fi			


)0   ,0   ,0    ,''    ,''    ,''      ,'0'  ,'BMR'  ,yawyap_sl@,yaWelas_sl@       ,0       ,0,)2,1,ONhcnarb_sl@(gnirtsbus,rehsac_sl@,etaDrepo_sl@(seulav 		

)3mun,2mun,1mun,3rehto,2rehto,1rehto,epyt_repo,on_nioc,yaw_yap   ,yaw_elas,tma_laer,tma_lles                  ,on_hcnarb ,on_rehsac   ,etad_repo(       		

musyad_rehsac_mr_t otni tresni 		


'0'=galFtsixErehsac_sl@ fi    	

trats.............................................)muSyad_rehsac_mr_t(表结日员银收写 --   

 	

	

'1'=galFtsixErehsac_sl@ tceles      	

在存已 --  esle   	

'0'=galFtsixErehsac_sl@ tceles      	

在存不 -- ))'BMR'=on_nioc dna yaWelas_sl@=yaw_elas dna yawyap_sl@=yaw_yap dna )2,1,ONhcnarb_sl@(gnirtsbus=on_hcnarb dna rehsac_sl@=on_rehsac dna etaDrepo_sl@=etad_repo( erehw        	

musyad_rehsac_mr_t morf * tceles(stsixe ton fi   	

在存已否是中)muSyad_rehsac_mr_t(表结日员银收在找查 --   	

表结日员银收写可才水流SOP的传上部分的管托部总或构机本 --           

  

	nigeb      

0 >< tmAtcd_nl@ fi      

况情利让录记,)musyad_rehsac_mr_t(表结日员银收写 --      


       

      

di_wolf@ = di_wolf dna on_wolf@ = on_wolf erehw              

ytQelas_nl@ * ecirp_tsoc_ced@ =ecirp_ni tes wolfelas_mr_t etadpu      

价本成录记中水流--      

     

      

dne.............................................)muSyad_mr_t(表结日售销品商写 --      

dne        

etaDrepo_sl@=etad_repo dna ONmetI_sl@=on_meti dna ONhcnarb_sl@=on_hcnarb erehw--               

 di_wolf_nl@ = di_wolf erehw                

'0' = galf_moc      ,'0' =   1rehto                  

,ytQelas_nl@ * ecirp_tsoc_ced@ + ecirp_tsoc = ecirp_tsoc                  

,crPelas_nl@=ecirp_elas--          	

,)dne tmAelas_nl@ esle tmAtcd_nl@ neht 0 = tmAelas_nl@ nehw esac( + tma_vig = tma_vig  ,ytQelas_nl@ + ytq_vig =  ytq_vig          	

tes musyad_mr_t etadpu      	

送赠 -- 'C'=yaWelas_sl@ fi esle    	

etaDrepo_sl@=etad_repo dna ONmetI_sl@=on_meti dna ONhcnarb_sl@=on_hcnarb erehw--        	

 di_wolf_nl@ = di_wolf erehw                

'0'=   galf_moc        ,'0' =     1rehto  		

,ytQelas_nl@ * ecirp_tsoc_ced@ + ecirp_tsoc = ecirp_tsoc                  

,crPelas_nl@ = ecirp_elas-- ,tmAtcd_nl@ - tnuoma_tcd = tnuoma_tcd          	

,tmAelas_nl@ + tma_ter =    tma_ter  ,ytQelas_nl@ + ytq_ter =    ytq_ter          	

tes musyad_mr_t etadpu      	

货退 -- 'B'=yaWelas_sl@ fi esle    	

etaDrepo_sl@=etad_repo dna ONmetI_sl@=on_meti dna ONhcnarb_sl@=on_hcnarb erehw--                

 di_wolf_nl@ = di_wolf erehw                

'0' =   galf_moc         ,'0' =     1rehto                  

,ytQelas_nl@ * ecirp_tsoc_ced@ + ecirp_tsoc = ecirp_tsoc                  

,crPelas_nl@ = ecirp_elas--  ,tmAtcd_nl@ + tnuoma_tcd = tnuoma_tcd                  

,tmAelas_nl@ + tma_elas = tma_elas  ,ytQelas_nl@ + ytq_elas =   ytq_elas                  

tes musyad_mr_t etadpu               

售销 -- 'A'=yaWelas_sl@ fi            

42-50-5002 sjuw yb deifidom 理处否是录记行该志标 1rehto  '0' = 1rehto --            

nigeb        

新更，在存已细明 --  esle	

dne        

)on_tsucpus@,tmAtcd_nl@,llun,llun,'0',0                        

,ytQelas_nl@ * ecirp_tsoc_ced@ ,)dne tmAelas_nl@ esle tmAtcd_nl@ neht 0 = tmAelas_nl@ nehw esac( ,0 ,0 ,ytQelas_nl@ ,0 ,0        		

,etar_yl_nl@,0,0,etaDrepo_sl@,ONmetI_sl@,ONhcnarb_sl@(seulav         	

)on_tsucpus,tnuoma_tcd,3rehto,2rehto,1rehto,ytq_erp         			

,ecirp_tsoc,tma_vig,tma_ter,tma_elas,ytq_vig,ytq_ter,ytq_elas                         	

,etar_yl_pus,ecirp_ter,ecirp_elas,etad_repo,on_meti,on_hcnarb(musyad_mr_t tresni              

91-21-5002 sjuw yb deifidom--      	

送赠 -- 'C'=yaWelas_sl@ fi esle           

)on_tsucpus@,tmAtcd_nl@,llun,llun,'0',0			

,ytQelas_nl@ * ecirp_tsoc_ced@,0,tmAelas_nl@,0 ,0 ,ytQelas_nl@ ,0        		

,etar_yl_nl@ ,crPelas_nl@ ,crPelas_nl@,etaDrepo_sl@ ,ONmetI_sl@ ,ONhcnarb_sl@(seulav         	

)on_tsucpus,tnuoma_tcd,3rehto,2rehto,1rehto,ytq_erp         			

,ecirp_tsoc,tma_vig,tma_ter,tma_elas,ytq_vig,ytq_ter,ytq_elas                         	

,etar_yl_pus,ecirp_ter,ecirp_elas,etad_repo,on_meti,on_hcnarb(musyad_mr_t tresni              

91-21-5002 sjuw yb deifidom--      	

货退 -- 'B'=yaWelas_sl@ fi esle           

)on_tsucpus@,tmAtcd_nl@,llun,llun,'0',0			

,ytQelas_nl@ * ecirp_tsoc_ced@,0,0,tmAelas_nl@  ,0  ,0 ,ytQelas_nl@        		

,etar_yl_nl@,0,crPelas_nl@,etaDrepo_sl@,ONmetI_sl@,ONhcnarb_sl@(seulav         	

)on_tsucpus,tnuoma_tcd,3rehto,2rehto,1rehto,ytq_erp         			

,ecirp_tsoc,tma_vig,tma_ter,tma_elas,ytq_vig,ytq_ter,ytq_elas                         	

,etar_yl_pus,ecirp_ter,ecirp_elas,etad_repo,on_meti,on_hcnarb(musyad_mr_t tresni              

91-21-5002 sjuw yb deifidom--      	

售销 -- 'A'=yaWelas_sl@ fi           


0 = etar_yl_nl@ tceles      	

llun si etar_yl_nl@ fi   	

nigeb        

加增，在存不细明 -- '0'=galFtsixEmetI_sl@ fi	

trats.............................................)muSyad_mr_t(表结日售销品商写 --	

        

dne	

'1'=galFtsixEmetI_sl@ tceles      	

在存--  0 > di_wolf_nl@ fi           

 0 = ecirp_elas dna  		

on_tsucpus@ = on_tsucpus dna etaDrepo_sl@ = etad_repo dna  		

 ONmetI_sl@ =  on_meti dna ONhcnarb_sl@ = on_hcnarb erehw		

 musyad_mr_t morf di_wolf = di_wolf_nl@ 1 pot tceles   	

nigeb	

送赠-- 'C' = yaWelas_sl@  fi-- esle	

dne	

'1'=galFtsixEmetI_sl@ tceles       	

在存-- 0 > di_wolf_nl@ fi            

on_tsucpus@ = on_tsucpus dna etar_yl_nl@ = etar_yl_pus dna crPelas_nl@ = ecirp_elas dna crPelas_nl@ = ecirp_ter dna etaDrepo_sl@ = etad_repo dna          	

 ONmetI_sl@ =   on_meti dna ONhcnarb_sl@ = on_hcnarb erehw        	

 musyad_mr_t morf )di_wolf(xam = di_wolf_nl@  tceles    	

价货退、率扣、价售分区 91-21-5002 sjuw yb deifidom-- nigeb	

货退-- 'B' = yaWelas_sl@ fi esle	

dne	

'1'=galFtsixEmetI_sl@ tceles      	

在存-- 0 > di_wolf_nl@ fi    	

on_tsucpus@ = on_tsucpus dna etar_yl_nl@ = etar_yl_pus dna crPelas_nl@ = ecirp_elas dna etaDrepo_sl@ = etad_repo dna         	

ONmetI_sl@ =    on_meti dna ONhcnarb_sl@ = on_hcnarb erehw		   

    	musyad_mr_t morf di_wolf = di_wolf_nl@ 1 pot tceles    	

nigeb	

售销-- 'A' = yaWelas_sl@ fi	

0 = di_wolf_nl@,'0'=galFtsixEmetI_sl@ tceles	

在存已否是中表结日售销品商在找查 --	


  额金本成品商的时当录记且并 --	

。录记售销品商的价货退同不，率扣同不，价售同不内天一分区中　musyad_mr_t　在 --	

02-21-5002 sjuw yb diefidoM --	

        

ONmeti_sl@ = on_meti erehw ofni_meti_db_t morf tsucpus_niam = on_tsucpus@ tceles   	

esle 	

ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf on_tsucpus = on_tsucpus@ tceles   	

)ONmeti_sl@ = on_meti dna )2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf 1 tceles(stsixe fi         

        

束结率扣营联取-- dne        

         0 = etar_yl_nl@ tceles              

esle           

dne           

dne --             

dne  			

etar_pmt_nl@ = etar_yl_nl@ tceles--						

率扣价特取仍，况情的识标价特没，等相价特跟价原于属况情该，分部量超是不--  esle--					

		etar_yl_pmt_nl@	 =  etar_yl_nl@ tceles						

分部量超为，时量限单每或量限场全在存--  0 > ytq_detimil_nl@ + ytq_elas_nl@ fi					

quh.率扣案档品商取售销外量限,量限单整到虑考--					

)''=))galf_ceps_sl@(mirtl(mirtr ro llun si galf_ceps_sl@( dna ) 0 >< etar_pmt_nl@ dna llun ton si etar_pmt_nl@ dna 0 > onwolf_nl@( fi  			


)0,ytq_detimil_nl@(llunsi = ytq_detimil_nl@ tceles				

)0,ytq_elas_nl@(llunsi = ytq_elas_nl@ tceles				


etar_pmt_nl@ = etar_yl_nl@ tceles				

0 = etar_pmt_nl@ dna '0' = o_galf_sl@ fi esle   			

etar_pmt_nl@ = etar_yl_nl@ tceles	                    	

-率扣销促在存不则 )etar_pmt_nl@(llunsi 果如--  0 >< etar_pmt_nl@ dna llun ton si etar_pmt_nl@ fi                   	

                

ONmetI_sl@=on_meti dna onwolf_nl@=on_wolf erehw ecirp_ceps_mr_t morf ytq_detimil = ytq_detimil_nl@,ytq_elas = ytq_elas_nl@,tnuocsid = etar_pmt_nl@  tceles	                 	

                	


'1' =)1,))(etadteg,yadkeew(TRAPETAD ,keew(gnirtsbus dna                         	

)                              	

)                                  	

) emit_dne dna emit_nigeb neewteb                                      	

 )2,)))(etadteg,ss(trapetad,)2(rahcrav(trevnoc+'0'(thgir                                      	

+':'+)2,)))(etadteg,im(trapetad,)2(rahcrav(trevnoc+'0'(thgir                                      	

+':'+)2,)))(etadteg,hh(trapetad,)2(rahcrav(trevnoc+'0'(thgir(                     	             	

 dna )''>)emit_nigeb(mirtl dna llun ton si emit_nigeb(                                     	

 (                                 	

 ro )''=)emit_nigeb(mirtl ro llun si emit_nigeb(                                 	

( dna                         	

) )121,)'99.95:95:32 ' + )121,etad_dne,)01(rahc(trevnoc(,emitetad(trevnoc  dna etad_trats neewteb )(etadteg ( dna                         	

) )'2','5' ,'6','C'( ni ton epyt_laiceps ( dna                         	

) crPelas_nl@  = ecirp_eps ( dna  --                       	

) ONmetI_sl@ = on_meti ( dna                         	

))2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb ( erehw                       	

 ecirp_ceps_mr_t morf )on_wolf(xam= onwolf_nl@ tceles                 	

 nigeb			

   quh 理外另惠优类员会除-- esle		

dne			

etar_pmt_nl@ = etar_yl_nl@ tceles					

0 = etar_pmt_nl@ dna '0' = o_galf_sl@ fi esle				

etar_pmt_nl@ = etar_yl_nl@ tceles	                    		

quh量限笔单除排可--率扣销促在存不则 )etar_pmt_nl@(llunsi 果如--  0 >< etar_pmt_nl@ dna llun ton si etar_pmt_nl@ fi                		

etar_yl_nl@ = etar_pmt_nl@ tceles					

esle				

ONmetI_sl@=on_meti dna onwolf_nl@=on_wolf erehw ecirp_ceps_mr_t morf tnuocsid = etar_pmt_nl@  tceles					

0 > onwolf_nl@ fi				

)0 = ytq_detimil ro ytq_dlos > ytq_detimil( dna				

'1' =)1,))(etadteg,yadkeew(TRAPETAD ,keew(gnirtsbus dna     

                    	

)                              	

)                                  	

) emit_dne dna emit_nigeb neewteb                                      	

 )2,)))(etadteg,ss(trapetad,)2(rahcrav(trevnoc+'0'(thgir                                      	

+':'+)2,)))(etadteg,im(trapetad,)2(rahcrav(trevnoc+'0'(thgir                                      	

+':'+)2,)))(etadteg,hh(trapetad,)2(rahcrav(trevnoc+'0'(thgir(                     	             	

 dna )''>)emit_nigeb(mirtl dna llun ton si emit_nigeb(                                     	

 (                                 	

 ro )''=)emit_nigeb(mirtl ro llun si emit_nigeb(                                 	

( dna                         	

) )121,)'99.95:95:32 ' + )121,etad_dne,)01(rahc(trevnoc(,emitetad(trevnoc  dna etad_trats neewteb )(etadteg ( dna                         	

单价特量限员会---) '2' = epyt_laiceps ( dna                         	

) crPelas_nl@  = ecirp_eps ( dna  --                       	

) ONmetI_sl@ = on_meti ( dna                         	

))2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb ( erehw                       	

 ecirp_ceps_mr_t morf )on_wolf(xam= onwolf_nl@ tceles				

nigeb			

'VP' = galf_ceps_sl@  fi		

   quh惠优类员会理处先---		

扣折为tnuocsid时此,销促牌品和别类是6,5 --                 

nigeb--              

yfidom wham 率扣单价特取售销价特-- crPelas_nl@ >< crPecruos_nl@ fi--              

 率扣案档取售销价原--              

nigeb           

销代率扣和营联--  'F' = yaw_elas_pus_sl@ ro 'C' = yaw_elas_pus_sl@ fi           

          

	 etar_yl_nl@ = etar_yl_pmt_nl@ tceles		

     	

ONmetI_sl@ = on_meti erehw               	

ofni_meti_db_t morf               	

etar_yl_pus = etar_yl_nl@ ,galf_pus_meti = yaw_elas_pus_sl@ tceles           	

esle           

)2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb dna ONmetI_sl@ = on_meti erehw       	               

ecirp_hcnarb_cp_t morf               	

etar_yl_pus = etar_yl_nl@ ,yaw_elas = yaw_elas_pus_sl@ tceles           	

0 >< ))2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb dna ONmetI_sl@ = on_meti erehw ecirp_hcnarb_cp_t morf etar_yl_pus 1 pot tceles( dna ))2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb dna ONmetI_sl@ = on_meti erehw ecirp_hcnarb_cp_t morf 1 tceles( stsixe fi           

nigeb        

'B' = yaWelas_sl@ ro 'A' = yaWelas_sl@ fi        

 率扣取 货退和售销--        

        

crPelas_nl@ = ecirp_tsoc_ced@ tceles            

价售用使时零为 -- llun si ecirp_tsoc_ced@ ro 0 = ecirp_tsoc_ced@ fi        


dne        

ONmetI_sl@ = on_meti erehw ofni_meti_db_t morf )0,ecirp(llunsi = ecirp_tsoc_ced@ tceles	   	

esle   	

)2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb dna ONmetI_sl@ = on_meti erehw              	

ecirp_hcnarb_cp_t morf )0,ecirp(llunsi = ecirp_tsoc_ced@ tceles        	

))2,1,ONhcnarb_sl@(gnirtsbus = on_hcnarb dna ONmetI_sl@ = on_meti erehw ecirp_hcnarb_cp_t morf 1 tceles(stsixe fi           

nigeb        

价进构机取零为价本成 -- llun si ecirp_tsoc_ced@ ro 0 = ecirp_tsoc_ced@ fi        

ONhcnarb_sl@ = on_hcnarb dna ONmetI_sl@ = on_meti erehw             

 kcots_hcnarb_mi_t morf )0,tsoc_gva(llunsi = ecirp_tsoc_ced@ tceles        

rorresiar--

02-21-5002 sjuw yb deifidom 价本成取 --        

        

)121,emiTetaDelas_tdl@,)01(rahc(trevnoc=etaDrepo_sl@ tceles	

ddmmyyyy='211'：为式格，）天当（期日型符字换转 --	

	

tmAelas_nl@ - tmAecruos_nl@ = tmAtcd_nl@ tceles --	


'FIG' = yawyap_sl@ tes		

esle	

dne		

'BMR' = yawyap_sl@ tes			

0 = tmAtcd_nl@ tceles				

 )''=)galf_ceps_sl@(mirtl ro llun si galf_ceps_sl@( fi			

nigeb		

)0 = yenom_elas_cedl@ dna 'C' = yaWelas_sl@( ton fi	

	

额金利让取接直 --	

yenom_elas_cedl@ = tmAelas_nl@ tceles	

01215102 cbgnail 51I要主 差误现出时额金于等不 量数*价单免避，yenom_elas为额金售销化优--	

)2,crPelas_nl@ * ytQelas_nl@(dnuor = tmAelas_nl@ tceles--	

)2,crPecruos_nl@ * ytQelas_nl@(dnuor = tmAecruos_nl@ tceles	

数小位两取只额金 71-21-4002 sjuw yb deifidom  额金售销的际实和额金售销的定预来原算计 --	

        

传不心中送配且,理处不回返接直时传上店分立独-- NRUTER ) '1' = galf_etomer@ ( fi  --

表结日到据数细明输传否是 -- 

	0 = ytq_detimil_nl@ ,0 = ytq_elas_nl@ ,0 = etar_yl_pmt_nl@,llun = etar_pmt_nl@,llun = etar_yl_nl@ tceles	

''=on_tsucpus@ ,''=yaw_elas_pus_sl@ ,0=ecirp_tsoc_ced@ tceles        

量变化始初-- 


NIGEB

0 = SUTATS_HCTEF@@ ELIHW

yenom_elas_cedl@,on_teehs_cic_sl@,on_teehs_ceps_sl@,galf_etomer@  		

,on_retnuoc_sl@  	,di_wolf@  		

,on_wolf@  	,tmAtcd_nl@  		

,galf_ceps_sl@  	,rehsac_sl@  		

,emiTetaDelas_tdl@  	,yaWelas_sl@  		

,crPelas_nl@  	,crPecruos_nl@  		

,ytQelas_nl@,ONmetI_sl@,ONhcnarb_sl@ OTNI

 rosruc_detresni MORF TXEN HCTEF


rosruc_detresni NEPO


传不心中送配且,理处不回返接直时传上店分立独-- NRUTER ) '1' = galf_etomer@ ( fi  --

表结日到据数细明输传否是 -- 


'1' >< galf_etomer erehw	

 detresni morf      

yenom_elas,on_teehs_cic,on_teehs_ceps,galf_etomer  		

,on_retnuoc  	,di_wolf  		

,on_wolf  	,tma_ferp  		

,galf_ceps  	,di_repo  		

,etad_repo,yaw_lles,ecirp_elas,ecirp_ecruos,ytnq_elas,on_meti,on_hcnarb tceles

 ROF ROSRUC rosruc_detresni ERALCED


'1' = o_galf_sl@ tceles	

 '' = o_galf_sl@ ro llun si o_galf_sl@ fi

 'orez_tceffe_LKYL' = di_rav_sys erehw metsys_sys_t morf eulav_rav_sys = o_galf_sl@ tceles


-----------------------------------------------------------

'0' = galf_cic_erom_sl@ tes

'' = pmt_on_teehs_cic_sl@ tes

))01(rahcrav di_etnc,)1(rahcrav epyt_etnc,)1,1(ytitnedi )0,61(ciremun di_bat(ofni_erom_nc_bat# elbat etaerc

---------细明游导多储存来用表时临建创--52-20-4102--pduoy---



)01(rahcrav   		yawyap_sl@  		

,)01(rahcrav   		di_etnc_sl@  		

,)1(rahcrav   		epyt_etnc_sl@  		

,)0,61(ciremun   	di_bat_nim_ll@  		

,)0,61(ciremun   	di_bat_xam_ll@  		

,)1(rahcrav   	galf_cic_erom_sl@  		

,)41(rahcrav pmt_on_teehs_cic_sl@  		

,)4,61(ciremun    etar_levart_cedl@  		

,)4,61(ciremun  etar_inorecic_cedl@  		

,)4,61(ciremun     yenom_elas_cedl@  		

,tni            tsixe_ll@  		

,)21(rahcrav       onslc_meti_sl@  		

录记牌发市超游旅---  ,)41(rahcrav    on_teehs_cic_sl@  		

,)41(rahc	 on_teehs_ceps_sl@  		

量限场全--   ,)4,61(ciremun		ytq_detimil_nl@  		

量限单每--  ,)4,61(ciremun			 ytq_elas_nl@  		

,)4,61(ciremun		etar_yl_pmt_nl@      	

,)1(rahc    o_galf_sl@      	

,)0,61(ciremun                onwolf_nl@          

,)1(rahcrav		galf_etomer@  		

,)01(rahcrav			  on_tsucpus@      	

,)1(rahc		 yaw_elas_pus_sl@      	

,)61(ciremun			 di_wolf_nl@      	

率扣营联--  ,)4,61(ciremun			 etar_pmt_nl@      	

率扣营联--  ,)4,61(ciremun			 etar_yl_nl@      	

,)61(rahcrav		 on_retnuoc_sl@      	

,)4,61(ciremun			 tma_ter_nl@      	

,)4,61(ciremun			 tma_elas_nl@      	

,)4,61(ciremun		 ecirp_tsoc_ced@      	

,tni				 di_wolf@      	

,)02(rahcrav				 on_wolf@      	

的用利让算计是个这，用能不个这的galf_ceps_sl@来原，用售销经已新更 wdgnauh----- ,)01(rahcrav         wen_galf_ceps_sl@      	

,)01(rahcrav		 galf_ceps_sl@      	

,)4,61(ciremun		 tmAtnuocsid_nl@      	

,)4(rahc			  rehsac_sl@      	

在存已='1'；在存不='0'，志标在存已否是中)slc_muSyad_mr_t(表结日员银收在员银收 -- ,)1(rahc	 galFtsixErehsac_sl@      	

在存已='1'；在存不='0'，志标在存已否是中)muSyad_mr_t(表结日售销品商在品商细明 --   ,)1(rahc	 galFtsixEmetI_sl@      	

ddmmyyyy：为式格，）天当（期日型符字 --       ,)01(rahc			 etaDrepo_sl@      	

间时售销 --   ,emitetad	 emiTetaDelas_tdl@      	

式方售销 --        ,)1(rahc			 yaWelas_sl@      	

.额金扣折品商 --   ,)4,61(ciremun			 tmAtcd_nl@      	

额金售销品商 --    ,)4,61(ciremun			 tmAelas_nl@      	

额金售销的定预来原品商 --  ,)4,61(ciremun		 tmAecruos_nl@      	

价单售销品商 --,)4,61(ciremun			 crPelas_nl@      	

价单的定预来原品商 -- ,)4,61(ciremun		  crPecruos_nl@      	

量数售销品商 --,)4,61(ciremun			ytQelas_nl@      	

码编别类品商 --,)6(rahc			 ONssalC_sl@      	

码编品商 --,)02(rahc			 ONmetI_sl@      	

码编库仓 --,)6(rahc			 ONhcnarb_sl@ eralced


nigeb

sa

tresni rof

 wolfelas_mr_t no wolfelas_mr_rt reggirt etaerc




og

wolfelas_mr_rt REGGIRT pord  

)'wolfelas_mr_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$tr_rm_vip_info_insert(MS).sql^^^^

dne

    dne		

)'0',epyt_drac_sl@,didrac_sl@,on_hcnarb_sl@,'3'(seulav )galf_dnes,epyt_drac,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni				

0 = tnuoc_ll@ fi        			

didrac_sl@ = di_drac dna on_hcnarb_sl@ = on_hcnarb dna '3' = epyt_ssem erehw egassem_piv_t_ssem morf )1(tnuoc = tnuoc_ll@ tceles    			

 '1' = )1,eulav_rav_sl@(tfel fi        			

)))'wen_piv'(MIRTR(MIRTL(reppU = )))di_rav_sys(MIRTR(MIRTL(reppU EREHW metsys_sys_t_ssem MORF  )'',eulav_rav_sys(llunsi = eulav_rav_sl@ TCELES			

nigeb		

0 > wor_ll@ fi	

员会新--	


'on_hcnarb_g' = di_rav_sys erehw metsys_sys_t morf eulav_rav_sys = on_hcnarb_sl@ tceles	

值构机--        

detresni morf		

epyt_drac=epyt_drac_sl@		

,etad_repo=etad_repo@                

,di_repo=di_repo_sl@        	

,''=drac_rehtaf_sl@		

,di_drac=didrac_sl@	 tceles	

据数前当 --      

      

))(ETADTEG,2-,htnom(DDAETAD =< etad_repo erehw ngis_ofni_piv_mr_t morf eteled    

60108102 nimnait据数的前之月个两除删--	

	

 detresni morf  on_hcnarb_sl@,'tresni-器发触',0,mun_ced,mun_cca,)(etadteg,di_drac tceles	

)on_hcnarb,on_wolf,mun_cca_piv,mun_ced,mun_cca,etad_repo,di_drac(ngis_ofni_piv_mr_t otni tresni	

90107102 nimnait 志日录记分积新更--	

'on_hcnarb_g' = di_rav_sys erehw metsys_sys_t morf eulav_rav_sys = on_hcnarb_sl@ tceles	

值构机--	

	

'metsys_sys_t_ssem' = eman erehw stcejbosys morf )*(tnuoc = wor_ll@ tceles	

表数参信短有否是断判，信短动自--      


数行有已--      )0,1(ciremun tnuoc_ll@      

,)552(rahcrav eulav_rav_sl@      

,)0,2(ciremun wor_ll@      

,emitetad etad_repo@      

,)4(rahc di_repo_sl@      

,)02(rahcrav on_drac_sl@      

,)2(rahc epyt_drac_sl@      

,)6(rahc on_hcnarb_sl@      

分积送赠--   ,)4,61(ciremun mun_cca_vig_nl@      

卡父--    ,)02(rahc drac_rehtaf_sl@      

分积有现--,)4,61(ciremun mun_cca_won_nl@      

分积减冲--  ,)4,61(ciremun mun_ced_nl@      

值分积计累 --  ,)4,61(ciremun mun_cca_nl@      

号卡员会 --       ,)02(rahc didrac_sl@ eralced  


nigeb

sa

tresni rof

ofni_piv_mr_t no tresni_ofni_piv_mr_rt reggirt etAERC




og

tresni_ofni_piv_mr_rt REGGIRT pord  

)'tresni_ofni_piv_mr_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$tr_sys_u_operator(MS).sql^^^^

dne


dne    

ruc_repo_tresni etacollaed	

ruc_repo_tresni esolc	

dne	

		

on_hcnarb@,di_repo@ otni ruc_repo_tresni hctef		

)on_hcnarb@ ,)(etadteg ,di_repo@ ,'U' ,'rotarepo_sys_t'( seulav			

)on_hcnarb ,etad_etadpu ,1yek ,epyt_egnahc ,elbat_moc( atad_mc_sys_t otni tresni		

nigeb	

0=sutats_hctef@@ elihw	

on_hcnarb@,di_repo@ otni ruc_repo_tresni hctef	

ruc_repo_tresni nepo	

ylno daer rof detresni morf on_hcnarb,di_repo tceles  rof rosruc ruc_repo_tresni eralced	    

入插--	


nigeb    

)wp_mrifnoc(etadpu ro )tnarg_atad(etadpu ro )etar_tuptuo(etadpu ro )sutats_repo(etadpu ro )wp_repo(etadpu ro )eman_repo(etadpu fi    

    

    

dne    

ruc_repo_tresni etacollaed	

ruc_repo_tresni esolc	

dne	

		

on_hcnarb@,di_repo@ otni ruc_repo_tresni hctef		

)on_hcnarb@ ,)(etadteg ,di_repo@ ,'I' ,'rotarepo_sys_t'( seulav			

)on_hcnarb ,etad_etadpu ,1yek ,epyt_egnahc ,elbat_moc( atad_mc_sys_t otni tresni		

'00' >< on_hcnarb@ fi		

nigeb	

0=sutats_hctef@@ elihw	

on_hcnarb@,di_repo@ otni ruc_repo_tresni hctef	

ruc_repo_tresni nepo	

ylno daer rof detresni morf on_hcnarb,di_repo tceles  rof rosruc ruc_repo_tresni eralced	    

入插--	


ruc_repo_eteled etacollaed	

ruc_repo_eteled esolc	

dne	

on_hcnarb@,di_repo@ otni ruc_repo_eteled hctef        	

	

)on_hcnarb@ ,)(etadteg ,di_repo@ ,'D' ,'rotarepo_sys_t'( seulav		

)on_hcnarb ,etad_etadpu ,1yek ,epyt_egnahc ,elbat_moc( atad_mc_sys_t otni tresni		

'00' >< on_hcnarb@ fi		

nigeb	

0=sutats_hctef@@ elihw	

on_hcnarb@,di_repo@ otni ruc_repo_eteled hctef	


ruc_repo_eteled nepo	

ylno daer rof deteled morf on_hcnarb,di_repo tceles rof rosruc ruc_repo_eteled eralced	

    	除删--    	

nigeb    

)on_hcnarb(etadpu ro )di_repo(etadpu fi    

用使时码编新更于限仅 --    


nruter	

'00' = )'on_hcnarb_g'=di_rav_sys erehw metsys_sys_t morf eulav_rav_sys tceles( ton fi    


nruter	 

'1' = )'bzta_tes_repo_sys'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys tceles( ton fi    

回返则员作操护维部总是不果如--	


	nruter       

 '1' = )'detubirtsid_si'=)di_rav_sys(rewol erehw metsys_sys_t morf eulav_rav_sys tceles( ton fi    

回返则是不果如，部总版式部分是否是查检--	


)6(rahc on_hcnarb@		

,)4(rahc di_repo@	 eralced     

nigeb

sa

etadpu rof

 rotarepo_sys_t no rotarepo_u_sys_rt reggirt etaerc



og

rotarepo_u_sys_rt REGGIRT pord  

)'rotarepo_u_sys_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####$$$$$$tr_t_pc_price_flow_detail_del(MS).sql^^^^



dne


dne	

TIAWON HTIW )1 ,61 , '除删被许允不核审已据单'( RORRESIAR	 	


)'除删许允不核审已据单',on_teehs@,'理管销促','录记器发触','1001',)(etadteg(seulav		

)omem,noitpircsed,on_snart,eman_retupmoc,di_repo,etad_repo(gol_rotarepo_sys_t otni tresni		

nigeb	

)'1'=galf_evorppa dna on_teehs@=on_teehs erehw retsam_wolf_ecirp_cp_t morf * tceles(stsixe fi	

	

 deteled morf on_teehs=on_teehs@ 1 pot tceles	

)02(rahcrav on_teehs@ eralced	

nigeb

sa

eteled rof

 liated_wolf_ecirp_cp_t no led_liated_wolf_ecirp_cp_t_rt reggirt etaerc


og

led_liated_wolf_ecirp_cp_t_rt reggirt pord  

)'led_liated_wolf_ecirp_cp_t_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi

####$$$$$$tr_vm_market_master_approve(MS).sql^^^^

dne

nruter  	

kcabllor  	

txet_ruc_mv etacollaed      

txet_ruc_mv esolc  	

tekcit_ruc_mv etacollaed  	

tekcit_ruc_mv esolc  	

:rorreym  

nruter      

txet_ruc_mv etacollaed      

txet_ruc_mv esolc      

tekcit_ruc_mv etacollaed      

tekcit_ruc_mv esolc      

标游闭关--      

dne      

epyt_dnes@,etad_evorppa@,tsil_rep@,epyt_rep@,tsil_gat@,epyt_gat@,on_teehs@          

otni txet_ruc_mv hctef          

   

dne      	

				dne				

  				rorreym otog 0 =! rorre@@ fi    				

on_teehs@ = on_teehS erehw    				

)on_teehs@ = on_wolf erehw xw_egassem_piv_t_ssem morf )1(TNUOC tceles( = tma_txet tes retsam_tekram_mv_t etadpu					

量数文发新更--					

					rorreym otog 0 =! rorre@@ fi 					

)0 > )tsil_rep@,)on_meti.p(mirtr(XEDNIRAHC(  dna  						

epyt_rep@  = epyt_rep.p  dna  						

))0 > )tsil_gat@,)gat_sutats.t(mirtr(XEDNIRAHC dna '2' = epyt_gat@(								

ro )0 > )tsil_gat@,)gat_eulav.t(mirtr(XEDNIRAHC dna '1' = epyt_gat@((  dna  						

 on_piV.p = on_piV.t	 erehw					

p ecnereferp_piv_mv_t,t gat_piv_mv_t morf					

on_teehs@,'0',on_piV.t,'000','02' tcnitsid tceles					

 )on_wolf,galf_dnes,di_drac,on_hcnarb,epyt_ssem(xw_egassem_piv_t_ssem otni tresni    				

信微--    				

nigeb				

esle				

dne				

rorreym otog 0 =! rorre@@ fi    				

on_teehs@ = on_teehS erehw    				

)on_teehs@ = on_wolf erehw egassem_piv_t_ssem morf )1(TNUOC tceles( = tma_txet tes retsam_tekram_mv_t etadpu					

量数文发新更--        			

rorreym otog 0 =! rorre@@ fi        			

           			)0 > )tsil_rep@,)on_meti.p(mirtr(XEDNIRAHC(  dna           			

epyt_rep@  = epyt_rep.p  dna           			

))0 > )tsil_gat@,)gat_sutats.t(mirtr(XEDNIRAHC dna '2' = epyt_gat@(                			

ro )0 > )tsil_gat@,)gat_eulav.t(mirtr(XEDNIRAHC dna '1' = epyt_gat@((  dna           			

 on_piV.p = on_piV.t	 erehw        			

p ecnereferp_piv_mv_t,t gat_piv_mv_t morf					

on_teehs@,'0',on_piV.t,'000','02' tcnitsid tceles					

 )on_wolf,galf_dnes,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni					

nigeb				

信短-- '1' = epyt_dnes@ fi           	

  nigeb      	

  esle      	

销营起发义定自--      	

dne      	

						dne				

rorreym otog 0 =! rorre@@ fi    				

on_teehs@ = on_teehS erehw    				

)on_teehs@ = on_wolf erehw xw_egassem_piv_t_ssem morf )1(TNUOC tceles( = tma_txet tes retsam_tekram_mv_t etadpu					

量数文发新更--					

rorreym otog 0 =! rorre@@ fi					

	)0 > )tsil_gat@,)gat_sutats.t(mirtr(XEDNIRAHC dna '2' = epyt_gat@(						

ro )0 > )tsil_gat@,)gat_eulav.t(mirtr(XEDNIRAHC dna '1' = epyt_gat@(	 erehw					

t gat_piv_mv_t morf					

on_teehs@,'0',on_piV.t,'000','02' tcnitsid tceles					

 )on_wolf,galf_dnes,di_drac,on_hcnarb,epyt_ssem(xw_egassem_piv_t_ssem otni tresni    				

信微--    				

nigeb				

esle				

dne				

rorreym otog 0 =! rorre@@ fi    				

on_teehs@ = on_teehS erehw    				

)on_teehs@ = on_wolf erehw egassem_piv_t_ssem morf )1(TNUOC tceles( = tma_txet tes retsam_tekram_mv_t etadpu					

量数文发新更--					

rorreym otog 0 =! rorre@@ fi					

	)0 > )tsil_gat@,)gat_sutats.t(mirtr(XEDNIRAHC dna '2' = epyt_gat@(						

ro )0 > )tsil_gat@,)gat_eulav.t(mirtr(XEDNIRAHC dna '1' = epyt_gat@(	 erehw					

t gat_piv_mv_t morf					

on_teehs@,'0',on_piV.t,'000','02' tcnitsid tceles					

 )on_wolf,galf_dnes,di_drac,on_hcnarb,epyt_ssem(egassem_piv_t_ssem otni tresni					

nigeb				

信短-- '1' = epyt_dnes@ fi 			

nigeb      	

  '' = )tsil_rep@(mirtr fi      	

销营起发像画态状、像画值价员会择选--      	

nigeb  	

0=sutats_hctef@@ elihw      

   epyt_dnes@,etad_evorppa@,tsil_rep@,epyt_rep@,tsil_gat@,epyt_gat@,on_teehs@         

otni txet_ruc_mv hctef      

txet_ruc_mv nepo      

          

'1' = galf_evorppa.i erehw         

i detresni morf         

epyt_dnes.i,etad_krow.i,)'',tsil_rep.i(llunsi,)'',epyt_rep.i(llunsi,tsil_gat.i,epyt_gat.i,on_teehs.i tceles      

rof rosruc txet_ruc_mv eralced      

文发销营--      

on_teehs.i = on_teehs.retsam_tekram_mv_t erehw  	

i detresni morf  	

)on_tekram yb puorg on_teehS.i = on_tekram erehw tekcit_piv_mv_t morf )1(TNUOC tceles( = tma_tekciT tes retsam_tekram_mv_t etadpu  	

量数放发券新更--  	

	  dne  	

 etad_dne@,etad_trats@,on_tekcit@             

,eltit_dnes@,txet_dnes@,epyt_dnes@,etad_evorppa@,tsil_rep@,epyt_rep@,tsil_gat@,epyt_gat@ ,tsil_hcnarb@,epyt_hcnarb@,on_teehs@             

otni tekcit_ruc_mv hctef    	

    	

dne    	

rorreym otog 0 =! rorre@@ fi 			

)0 > )tsil_rep@,)on_meti.p(mirtr(XEDNIRAHC(  dna      			

epyt_rep@  = epyt_rep.p  dna      			

))0 > )tsil_gat@,)gat_sutats.t(mirtr(XEDNIRAHC dna '2' = epyt_gat@(            			

ro )0 > )tsil_gat@,)gat_eulav.t(mirtr(XEDNIRAHC dna '1' = epyt_gat@((  dna      			

 on_piV.p = on_piV.t	 erehw			

p ecnereferp_piv_mv_t,t gat_piv_mv_t morf			

tsil_hcnarb@,epyt_hcnarb@,etad_evorppa@        			

,etad_dne@,etad_trats@,on_teehs@,'1',on_tekcit@,on_piV.t tcnitsid tceles			

)tsil_hcnarB,epyt_hcnarB,etad_repO               	

,etad_dnE,etad_tratS,on_tekraM,sutats_tekciT,on_tekciT,on_piV(tekcit_piv_mv_t otni tresni        	

销营起发义定自--        	

nigeb    	

esle    	

dne    	

	

			rorreym otog 0 =! rorre@@ fi			

	)0 > )tsil_gat@,)gat_sutats.t(mirtr(XEDNIRAHC dna '2' = epyt_gat@(        			

ro )0 > )tsil_gat@,)gat_eulav.t(mirtr(XEDNIRAHC dna '1' = epyt_gat@(	 erehw			

t gat_piv_mv_t morf			

tsil_hcnarb@,epyt_hcnarb@,etad_evorppa@        			

,etad_dne@,etad_trats@,on_teehs@,'1',on_tekcit@,on_piV.t tcnitsid tceles			

)tsil_hcnarB,epyt_hcnarB,etad_repO               	

,etad_dnE,etad_tratS,on_tekraM,sutats_tekciT,on_tekciT,on_piV(tekcit_piv_mv_t otni tresni        	

销营起发像画态状、像画值价员会择选--        	

nigeb    	

  '' = )tsil_rep@(mirtr fi    	

nigeb  	

0=sutats_hctef@@ elihw  	

    

   etad_dne@,etad_trats@,on_tekcit@        

,eltit_dnes@,txet_dnes@,epyt_dnes@,etad_evorppa@,tsil_rep@,epyt_rep@,tsil_gat@,epyt_gat@ ,tsil_hcnarb@,epyt_hcnarb@,on_teehs@        

otni tekcit_ruc_mv hctef     

tekcit_ruc_mv nepo     

     

'1' = epyt_tekram.i dna '1' = galf_evorppa.i dna on_teehs.d = on_teehs.i  erehw     

d liated_tekram_mv_t,i detresni morf     

etad_dne.d,etad_trats.d,on_tekcit.d             

,eman_tekram,)'',txet_dnes.i(llunsi,epyt_dnes.i,etad_krow.i,)'',tsil_rep.i(llunsi,)'',epyt_rep.i(llunsi,tsil_gat.i,epyt_gat.i,tsil_hcnarb.i,epyt_hcnarb.i,on_teehs.i tceles     

rof rosruc tekcit_ruc_mv eralced     

券发销营--     

表列好偏员会--    )552(rahcrav        tsil_rep@    

, )1(rahcrav        epyt_rep@    

表列像画员会--  , )552(rahcrav        tsil_gat@    

, )1(rahcrav        epyt_gat@    

容内文发--   ,)552(rahcrav       txet_dnes@    

容内文发--   ,)001(rahcrav      eltit_dnes@    

信短2，信微1 式方送推--     ,)1(rahcrav       epyt_dnes@    

, emitetad    etad_evorppa@    

, emitetad     	  etad_dne@    

, emitetad 	  etad_trats@    

号券--, )02(rahcrav 	  on_tekcit@    

表列店门--, )552(rahcrav 	  tsil_hcnarb@    

, )1(rahcrav 	  epyt_hcnarb@    

号单--, )02(rahcrav     	  on_teehs@    

eralced  

nruter )galf_evorppa(etadpu ton fi  

nigeb

sa

 etadpu rof

 retsam_tekram_mv_t no evorppa_retsam_tekram_mv_rt reggirt etaerc



og

evorppa_retsam_tekram_mv_rt reggirt pord  

)'evorppa_retsam_tekram_mv_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####@@@@