$$$$$$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	--

量变明声--	


/*	

dne        

nruter     	

)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            	

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

,ecirp_elas.a,ecirp_esab.a,ecirp.a,galf_pus_meti.a,tsucpus_niam.a,on_meti.a, on_hcnarb.b tceles		

)4ecirp_esab,3ecirp_esab,2ecirp_esab,1ecirp_esab,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	       	

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

nigeb        

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

*/	

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	

DNE		

ONdrac_sl@ = on_trectfig EREHW			

ONhcnarb_sl@ = hcnarb_yap ,emiTetaDyap_tdl@ = etad_yap ,rehsac_sl@ = repo_yap ,oNwolf_sl@ = on_wolf ,'2' = sutats TES			

 etacifitrec_tfig_mr_t ETADPU			

NIGEB		

'1' = )'qwgkcehc_sop' = di_rav_sys erehw metsys_sys_t morf )0,eulav_rav_sys(llunsi tceles( FI		

NIGEB	

'A' = yaWelas_sl@ dna 'PHS' = yaWyap_sl@ fi	

录记券礼，11-90-7102 dhnehc--	

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			

				

				

				

dne				

)tmAyap_nl@ ,'0','5',tmAyap_nl@,ONpiv_sl@,ONhcnarb_sg@,'L'(seulav						

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

		'PEL' = yaWyap_sl@ fi					

						

	)'0','4',tmAyap_nl@,ONpiv_sl@,ONhcnarb_sg@,'L'(seulav						

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

	'VEL' = epyt_snart@ fi					

	nigeb				

 )				

ONpiv_sl@  = di_drac.a dna					

'0' = galf_gnivas.b dna					

di_epyt.b = epyt_drac.a erehw					

b epyt_piv_mr_t ,a ofni_piv_mr_t morf *.b tceles		  			

 (stsixe fi	  			

71-5-8102	xzuohz	理处动变钱零--	  			

      	  			

      	  			

)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           

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

新更，在存已员银收 --        

esle     

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

)3mun,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     

40808102数次的式方款收录记3mun 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####@@@@