$$$$$$LoginOperID(MS).sql^^^^DNE

1 NRUTER	


) emiTgoL@ ,DIrepO@ ,dips@@( seulav ) emitgol,direpo,dips(dips_sys_t otni tresnI		

ESLE	

dips@@ = dips erehw emiTgoL@ = emitgol ,DIrepO@ = direpo tes dips_sys_t etadpu		

) dips@@ = dips erehw dips_sys_t morf 1 tceles (stsixE FI	


dips@@ = dips erehw sessecorpsys..retsam morf emiT_nigoL = emiTgoL@ tceles	


) emit_nigol.p = emitgol.dips_sys_t dna dips.p = dips.dips_sys_t erehw p sessecorpsys..retsam morf 1 tceles ( stsixe ton erehw dips_sys_t morF eteleD	

	

emiTetaD emiTgoL@		eralceD	

NIGEB

SA

))02(rahcrav DIrepO@ (]DIrepOnigoL[.]obd[ CORP   etaerc


og

DIrepOnigoL erudecorp pord  

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

sserdda_ten@ tceles	


'1-'=sserdda_ten@ tceles		

0=)sserdda_ten@(nel fi	

	

emanrevres@=emantsoh erehw	

   sessecorpsys..retsam morf	

sserdda_ten=sserdda_ten@ tceles	

	

))'emaNenihcaM'(YTREPORPREVRES ,)001(rahcrav(trevnoc =emanrevres@ tceles	

)001(rahcrav emanrevres@ eralced	

nigeb

sa

) )001(rahcrav sserdda_ten@,)03(rahcrav eman_bd@(sserdda_ten_revres_teg_rp erudecorp etaerc


og

sserdda_ten_revres_teg_rp erudecorp pord  

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

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

dne

	on_wolf_cedl@  	

,ntr_on_teehs_ceps_sl@  	

,ntr_galfceps_sl@      

,bmoc_sl@      

,tmatfig_sl@      

 ,ytqtfig_sl@      

,metitfig_sl@      

,ytQelas_nl@      

,ecirPdrac_nl@      

,ecirPceps_nl@      

,ecirPelas_nl@      

,ONssalC_sl@      

,emaNbuS_sl@ tceles    

值回返 --    

)0,ytQelas_nl@(llunsi = ytQelas_nl@ tceles	

)0,on_wolf_cedl@(llunsi = on_wolf_cedl@ tceles	

)'',rddapus_sl@(llunsi = rddapus_sl@ tceles    

)'',letpus_sl@(llunsi = letpus_sl@ tceles    

)'',tmatfig_sl@(llunsi = tmatfig_sl@ tceles    

)'',ytqtfig_sl@(llunsi = ytqtfig_sl@ tceles    

)'',metitfig_sl@(llunsi = metitfig_sl@ tceles    


))121,etaddne_tfig ,)01(rahc(trevnoc                                             	

 dna )121,etadtrats_tfig ,)01(rahc(trevnoc neewteb )121 ,)(etadteG ,)01(rahc(trevnoc(          

 dna ) 0> ytq_elas dna '3' = epyt_laiceps dna ONmetI_sa@ = on_meti            

 dna ))2,1,ONhcnarb_sa@(gnirtsbus = on_hcnarb ro 'LLA' = on_hcnarb(( erehw    

 ecirp_ceps_mr_t morf    

 on_wolf = on_wolf_cedl@,ytq_elas = ytQelas_nl@ ,tma_tfig=tmatfig_sl@           

,ytq_tfig=ytqtfig_sl@ ,meti_tfig=metitfig_sl@ 1 pot tceles    

0 = on_wolf_cedl@ tes    

品赠销促理处 --    


ecirPpiv_nl@ = ecirPdrac_nl@ tceles		

0 = ecirPdrac_nl@ ro llun si ecirPdrac_nl@ fi  --		

价员会=价卡员会，价卡员会有没 --		

ecirPelas_nl@ = ecirPceps_nl@ tceles		

0 = ecirPceps_nl@ ro llun si ecirPceps_nl@ fi    

价售零=价特，价特有没 --    


ecirPceps_rucl etacollaed    

ecirPceps_rucl esolc    

闭关 --    


DNE    

kaerb            

esle        

dne        

dne			

--------------------------------------------------------------------------------------------------               

'' = ntr_on_teehs_ceps_sl@ tes   				

'' = ntr_galfceps_sl@ tes   				

----------------空回返也号据单销促以所-价特员会取有没ecirPdrac_nl@后最在于由--31-90-3102-pduoy---                

               

效有价卡员会次本--  ecirPpmt_nl@ = ecirPdrac_nl@ tceles                   

))211,etaDdne_tdl@,)8(rahc(trevnoc=<)211,)(etadteg,)8(rahc(trevnoc           	

 dna )211,etaDtrats_tdl@,)8(rahc(trevnoc=>)211,)(etadteg,)8(rahc(trevnoc( fi               

理处来gnirts为换转式格期日将 ,ddmmyyyy=211：式格期日 --     

          

效有否是价卡员会次本断判 --               

nigeb			

价特员会 --  '2'=epyTceps_sl@ fi esle			

/* '0'=epyTceps_sl@ fi" htiW dnE*/     dne			

价特义定先预能可有 :etoN ;效无价特次本 ----          

)价员会有能可，价特售零有没 ,daerb能不( kaerb--	eunitnoc					

esle				

dne				

dne					

dne						

------------------------------------------									

dne							

'' = ntr_on_teehs_ceps_sl@ tes								

'' = ntr_galfceps_sl@ tes								

ecirPelas_nl@ = ecirPceps_nl@ tes								

nigeb							

)ntr_galfceps_sl@ >< galfceps_sl@ dna )0,ecirPceps_nl@(LLUNSI < ecirPpmt_nl@( ro ntr_galfceps_sl@ = galfceps_sl@ ro '' = ntr_galfceps_sl@ fi							

----------------71-21-3102--pduoy--------  								

ecirPelas_nl@ = ecirPceps_nl@ tceles--  								

nigeb						

esle						

dne						

---------------------------------------------------------------------------------									

dne							

ecirPpmt_nl@ = ecirPceps_nl@ tes								

on_teehs_ceps_sl@ = ntr_on_teehs_ceps_sl@ tes								

galfceps_sl@ = ntr_galfceps_sl@ tes								

nigeb							

)ntr_galfceps_sl@ >< galfceps_sl@ dna )0,ecirPceps_nl@(LLUNSI < ecirPpmt_nl@( ro ntr_galfceps_sl@ = galfceps_sl@ ro '' = ntr_galfceps_sl@ fi							

-------------------------------------------------------71-21-3102--pduoy--------   								

wolf_nl@=on_wolf erehw     --   								

nart timmoc     --   								

ecirPceps_rucl FO TNERRUC EREHW     --   								

ytQelas_na@+ytQdlos_nl@=ytq_dlos tes ecirp_ceps_mr_t etadpu    --   								

nart nigeb --   								

ecirPpmt_nl@ = ecirPceps_nl@ tceles --  								

'-----' tnirp--   							

wolf_nl@ tnirp--   							

ytQelas_na@ tnirp--   							

'-----' tnirp--   							

nigeb						

出超未--  ytQdlos_nl@>ytq_detimil@ fi						

出超否是量限场卖断判--					

nigeb					

esle					

dne					

ecirPpmt_nl@ = ecirPceps_nl@ tceles--  								

---------------------------------------------------------------------------------									

dne						

ecirPpmt_nl@ = ecirPceps_nl@ tes							

on_teehs_ceps_sl@ = ntr_on_teehs_ceps_sl@ tes							

galfceps_sl@ = ntr_galfceps_sl@ tes							

nigeb						

)ntr_galfceps_sl@ >< galfceps_sl@ dna )0,ecirPceps_nl@(LLUNSI < ecirPpmt_nl@( ro ntr_galfceps_sl@ = galfceps_sl@ ro '' = ntr_galfceps_sl@ fi						

-------------------------------------------------------71-21-3102--pduoy--------   							

nigeb					

量限场卖作否是-- 99999>ytq_detimil@ ro llun si ytq_detimil@ ro 0=ytq_detimil@ fi					

效有价特次本 --     nigeb				

))211,etaDdne_tdl@,)8(rahc(trevnoc=<)211,)(etadteg,)8(rahc(trevnoc dna )211,etaDtrats_tdl@,)8(rahc(trevnoc=>)211,)(etadteg,)8(rahc(trevnoc(fi esle				

理处来gnirts为换转式格期日将 ,ddmmyyyy=211：式格期日 --              

效有否是价特售销次本断判 --              

dne				

)价员会有能可，价特售零有没 ,kaerb能不( kaerb--    eunitnoc						

esle					

dne					

--低价特段时比价特通普的面后能可,kaerb能不 71-21-3102--pduoy kaerb -- 					

dne						

dne							

------------------------------------------									

dne								

'' = ntr_on_teehs_ceps_sl@ tes									

'' = ntr_galfceps_sl@ tes									

ecirPelas_nl@ = ecirPceps_nl@ tes									

								

nigeb								

)ntr_galfceps_sl@ >< galfceps_sl@ dna )0,ecirPceps_nl@(LLUNSI < ecirPpmt_nl@( ro ntr_galfceps_sl@ = galfceps_sl@ ro '' = ntr_galfceps_sl@ fi								

----------------71-21-3102--pduoy--------									

nigeb							

esle							

dne							

------------------------------------------									

dne								

									

ecirPpmt_nl@ = ecirPceps_nl@ tes									

on_teehs_ceps_sl@ = ntr_on_teehs_ceps_sl@ tes									

galfceps_sl@ = ntr_galfceps_sl@ tes									

									

nigeb								

)ntr_galfceps_sl@ >< galfceps_sl@ dna )0,ecirPceps_nl@(LLUNSI < ecirPpmt_nl@( ro ntr_galfceps_sl@ = galfceps_sl@ ro '' = ntr_galfceps_sl@ fi								

----------------71-21-3102--pduoy--------  								

ecirPpmt_nl@ = ecirPceps_nl@ tceles ---  								

nigeb							

出超未--  ytQdlos_nl@>ytq_detimil@ fi							

出超否是量限场卖断判--						

nigeb						

esle						

dne						

---------------------------------------------------------------------------------							

dne							

ecirPpmt_nl@ = ecirPceps_nl@ tes								

on_teehs_ceps_sl@ = ntr_on_teehs_ceps_sl@ tes								

galfceps_sl@ = ntr_galfceps_sl@ tes								

nigeb							

)ntr_galfceps_sl@ >< galfceps_sl@ dna )0,ecirPceps_nl@(LLUNSI < ecirPpmt_nl@( ro ntr_galfceps_sl@ = galfceps_sl@ ro '' = ntr_galfceps_sl@ fi							

-------------------------------------------------------71-21-3102--pduoy--------							

ecirPpmt_nl@ = ecirPceps_nl@ tceles----							

nigeb						

量限场卖作否是-- 99999>ytq_detimil@ ro llun si ytq_detimil@ ro 0=ytq_detimil@ fi						

ecirPpmt_nl@ = ecirPceps_nl@ tceles--  							

nigeb					

emitdne_tdl@=<won_tdl@ dna emittrats_tdl@ => won_tdl@ dna					

)121 ,etaDdne_tdl@ ,)01(rahc(trevnoc=<)121 ,won_tdl@ ,)01(rahc(trevnoc dna					

)121 ,etaDtrats_tdl@ ,)01(rahc(trevnoc=>)121 ,won_tdl@ ,)01(rahc(trevnoc fi					

内围范定指在间时、期日--					

)121,emitdne_sl@ + ' ' + )121 ,won_tdl@ ,)01(rahc(trevnoc ,emitetad(trevnoc =emitdne_tdl@ 						

,)121,emittrats_sl@ + ' ' + )121 ,won_tdl@ ,)01(rahc(trevnoc ,emitetad(trevnoc =emittrats_tdl@ tceles					

)(etadteg=won_tdl@ tceles					

nigeb				

)'' >< )'',emiTdnE_sl@(llunsi dna '' >< )'',emittrats_sl@(llunsi( fi				

)'00:00:21'=emit_dne dna '00:8' = emit_nigeb dna '1'&'0'=epyt_ceps(价特售销的间时定固是否是断判先--				

nigeb			

价特 --   '0'=epyTceps_sl@ fi			

'1'=epyTceps_sl@扣拆消取--			


nigeb        

0 = sutats_hctef@@ fi        

on_teehs_ceps_sl@,galfceps_sl@,wolf_nl@,ytq_detimil@,emiTdnE_sl@ ,emittrats_sl@ ,etaDdne_tdl@,etaDtrats_tdl@,ytQdlos_nl@,ytQelas_nl@              

,tnuocsid_nl@,ecirPpmt_nl@,epyTceps_sl@ OTNI ecirPceps_rucl HCTEF        

NIGEB    

1=1 ELIHW    

ecirPceps_rucl nepo    

开打 --    

 on_wolf yb redro			

) ) )))'VP'><)2,3rehto(tfel dna emit_dne dna emit_nigeb neewteb )801,)(etadteg,)8(rahc(trevnoc(( dna ))121,etad_dne,)01(rahc(trevnoc dna )121,etad_trats,)01(rahc(trevnoc			

neewteb )121,)(etadteg,)01(rahc(trevnoc( dna ONmetI_sa@=on_meti dna )2,1,ONhcnarb_sa@(gnirtsbus=on_hcnarb erehw ecirp_ceps_mr_t morf )3rehto(xam tceles(=3rehto		

dna )'EP'=)2,3rehto(tfel( dna ))emit_dne dna emit_nigeb neewteb )801,)(etadteg,)8(rahc(trevnoc( dna ))121,etad_dne,)01(rahc(trevnoc dna )121,etad_trats,)01(rahc(trevnoc neewteb )121,)(etadteg,)01(rahc(trevnoc(((		

 ro ''=)emit_nigeb(mirtl ro llun si emit_nigeb( dna		

)'1' = )1 ,))(etadteg ,wd(TRAPETAD ,keew(gnirtsbus( dna		

 )'FP'><)2,3rehto(tfel( dna		

 )'HP'><)2,3rehto(tfel( dna		

)ONmetI_sa@=on_meti( dna		

))2,1,ONhcnarb_sa@(gnirtsbus=on_hcnarb( erehw    

/*效生录记价调条多品商一同 ”单价特间时定固“ */

    

ecirp_ceps_mr_t morf    

3rehto,)2,3rehto(tfel,on_wolf,ytq_detimil,emit_dne ,emit_nigeb,etad_dne,etad_trats,ytq_dlos,ytq_elas		

,tnuocsid,ecirp_eps,epyt_laiceps tceles		

 rof rosruc ecirPceps_rucl eralced    

)化转要需故，库仓为中售销SOP而，构机为中义定价特(义定 --    


ecirPelas_nl@ = ecirPpiv_nl@ tceles       

0 = ecirPpiv_nl@ ro llun si ecirPpiv_nl@ fi    

40-60-4002 sjuw yb deifidoM--    

    

-----------------------------------------    

'' = ntr_on_teehs_ceps_sl@ tes	

	'' =  	ntr_galfceps_sl@ tes    

---------化始初-价特的回返-71-21-3102--pduoy--     

    

0 = ecirPdrac_nl@ tceles    

0 = ecirPceps_nl@ tceles    

....理处价卡员会,价特 --    

    


/**************************************************************    

*    

"价特量超" 受享再不，后价特述上受享已     *    

*    

价售零，价员会  ,价特员会  ：时费消员会     *    

价售零 ，价特销促 , 价特段时定固 :时费消员会非     *    

序顺价取品商一同 *    

*    

**************************************************************    

*    

价特员会              2   *    

价特量超              4   *    

价特段时定固 和，价特销促              0   *    

epyt_laiceps  *    

*    

*************************************************************/    


    

   

dne    

dne	

	ONmetI_sa@=on_meti dna )2,1,ONhcnarb_sa@(gnirtsbus=on_hcnarb erehw 			

ecirp_hcnarb_cp_t morf  			

ecirp_piv = ecirPpiv_nl@ ,ecirp_elas = ecirPelas_nl@ tceles			

nigeb	

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

nigeb    

'4' = epyt_edart_sl@ fi    

   表格价构机取部分型SOP----    

    

ONmetI_sa@=on_meti erehw ofni_meti_db_t morf        

ecirp_piv=ecirPpiv_nl@   ,ecirp_elas=ecirPelas_nl@	    

, ats_enibmoc= bmoc_sl@ ,2rehto = onpus_sl@        

,onslc_meti=ONssalC_sl@	,emanbus_meti=emaNbuS_sl@ tceles    

ecirp_piv=ecirPpiv_nl@   ,ecirp_elas=ecirPelas_nl@ --    

息信本基的品商台前取获中)ofni_meti_db_t(从 --    


)2,1,ONhcnarb_sa@(gnirtsbus = on_hcnarb erehw        

ofni_hcnarb_db_t morf       

epyt_edart = epyt_edart_sl@ tceles    

01-10-5002  cgnauh yb deifidoM --    

0 = on_wolf_cedl@ tes	

'' = on_teehs_ceps_sl@ tceles	

''=galfceps_sl@ tceles    


---------号据单价特的回返-71-21-3102--pduoy--  )41(rahc ntr_on_teehs_ceps_sl@	

---------志标价特的回返-71-21-3102--pduoy-- 	,)3(rahc  ntr_galfceps_sl@	

键主销促品赠-- ,)0,61(ciremun on_wolf_cedl@	

据单价特--        , )41(rahc on_teehs_ceps_sl@	

EP\SP别区以，志标价特加增-- 	,)3(rahc  galfceps_sl@    

型类部分 -- 	,)1(rahc epyt_edart_sl@    

号水流 --     ,)0,61(ciremun wolf_nl@    

   ）...生、拆、组（型类品商 -- 	,	)1(rahc	bmoc_sl@    

,    emitetad won_tdl@    

期日束结价特 --          ,emitetad emitdne_tdl@    

期日始开价特 --        ,emitetad emittrats_tdl@    

emit束结价特 --         ,   )8(rahc emiTdne_sl@    

emit始开价特 --          ,)8(rahc emiTtrats_sl@    

期日束结价特 --          ,emitetad etaDdne_tdl@    

期日始开价特 --        ,emitetad etaDtrats_tdl@    

码编修维 --          ,)03(rahcrav onpus_sl@    

址地修维 --       ,)001(rahcrav rddapus_sl@    

话电修维 --         ,)03(rahcrav letpus_sl@    

04.001/0.03/05.21 :tamrof，列额金品商送赠 --        ,)004(rahcrav tmatfig_sl@    

4/2/01 :tamrof，列量数品商送赠 --        ,)004(rahcrav ytqtfig_sl@    

300/200/100 :tamrof，列码编品商送赠 --       ,)0001(rahcrav metitfig_sl@    

量数售销价特的售销经已前当 --      ,)4,61(ciremun ytQdlos_nl@    

量数购限场卖 --     ,)4,61(ciremun ytq_detimil@    

量数购限单客 --      ,)4,61(ciremun ytQelas_nl@    

率扣折 --      ,)2,6(ciremun tnuocsid_nl@    

价卡员会 --     ,)4,61(ciremun ecirPpiv_nl@    

价卡员会 --    ,)4,61(ciremun ecirPdrac_nl@    

价特台前 --    ,)4,61(ciremun ecirPceps_nl@    

,)4,61(ciremun ecirPpmt_nl@    

型类价特 --         ,)1(rahc epyTceps_sl@    

价售零 --      ,)4,61(ciremun ecirPelas_nl@    

码编别类 --            ,)6(rahc ONssalC_sl@    

称简 --    ,)02(rahcrav emaNbuS_sl@ eralced  


1= ytQelas_na@ ,'20001'= ONmetI_sa@ ,'00'= ONhcnarb_sa@ ofni_meti_teg_mr_rp cexe---

nruter )ONmetI_sa@=on_meti erehw ofni_meti_db_t morf 1 tceles(stsixe ton fi  

断判性效有的码编 --

nigeb

sa

))4,21(ciremun ytQelas_na@ ,)02(rahc ONmetI_sa@ ,)6(rahc ONhcnarb_sa@(ofni_meti_teg_mr_rp erudecorp etAERC


og

ofni_meti_teg_mr_rp erudecorp pord  

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

dne


ruc_is_eteled etacollaed	

ruc_is_eteled esolc	

dne	

on_noc@ otni ruc_is_eteled hctef		


on_noc@ = on_noc erehw egrahc_tcartnoc_db_t morf eteled		

on_noc@ = on_noc erehw krow_tcartnoc_db_t morf eteled		

on_noc@ = on_noc erehw tcuded_tcartnoc_db_t morf eteled		

on_noc@ = on_noc erehw liated_tcartnoc_db_t morf eteled		

nigeb	

0=sutats_hctef@@ elihw	

on_noc@ otni ruc_is_eteled hctef	

ruc_is_eteled nepo	

ylno daer rof deteled morf on_noc tceles rof rosruc ruc_is_eteled eralced	


)02(rahc on_noc@ eralced	

	

nigeb

sa

eteled rof

 retsam_tcartnoc_db_t no retsam_tcartnoc_db_rt reggirt ETAERC


og

retsam_tcartnoc_db_rt REGGIRT pord  

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

dne


ruc_meti_eteled etacollaed	

ruc_meti_eteled esolc	

dne	  

on_meti@ otni ruc_meti_eteled hctef		

    

on_meti@ = on_meti erehw kcots_hcnarb_mi_t morf eteled    

42-80-6002 sjuw--    

    

dne.72-20-6002 ztud yb dda--    

on_meti@ = on_meti erehw ecirp_hcnarb_cp_t morf eteled    

72-20-6002 ztud yb dda--    

                

on_meti@ = on_meti erehw meti_tsucpus_db_t morf eteled		


)llun ,)(etadteg ,on_meti@ ,'D' ,'ofni_meti_db_t'( seulav			

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

nigeb    

0=sutats_hctef@@ elihw    

on_meti@ otni ruc_meti_eteled hctef    

ruc_meti_eteled nepo    

ylno daer rof deteled morf on_meti tceles		

rof rosruc ruc_meti_eteled eralced    

	


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

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


dips@@ = dips erehw sessecorpsys.obd.retsam morf	

'品商除删录记器发触-'+)eman_margorp(mirtr,on_meti@,emantsoh,)4,1,)emanigol(mirtr(gnirtsbus,)(etadteg tceles	

)omem,noitpircsed,eman_retupmoc ,di_repo ,etad_repo( gol_rotarepo_sys_t tresni	

志日如写--	


)02(rahcrav on_meti@ eralced	

nigeb

sa

eteled rof

 ofni_meti_db_t no ofni_meti_d_db_rt reggirt etaerc


og

ofni_meti_d_db_rt reggirt pord   

)'ofni_meti_d_db_rt' = 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	--

量变明声--	


/*	

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_wm_sheet_master(MS).sql^^^^

dne

nruter        

kcabllor        

1_ruc_ms etacollaed        

1_ruc_ms esolc        

:rorreym    

    

nruter    


dne    

        

rorreym otog 0 =! rorre@@ fi        

        

) )2,1,on_hcnarb@(gnirtsbus,etad_yap@,'A',on_tsuc@,'0',etad_krow@,yaw_elas@              

,0,0,tma_latot@ ,on_snart@ ,on_teehs@ ,1(seulav            

)on_hcnarb,etad_cca,yaw_yap,on_tsucpus          	

,galf_elttes,etad_repo,yaw_elas,tma_xat,2tma_dluohs,tma_dluohs              

,on_snart,on_rehcuov,epyt_yap(wolf_yapcer_mf_t otni tresni           

esle        

) )2,1,on_hcnarb@(gnirtsbus,etad_yap@,'A',on_tsuc@,'0',etad_krow@,yaw_elas@              

,0,0,tma_latot@ ,on_snart@ ,on_teehs@ ,1(seulav            

)on_hcnarb,etad_cca,yaw_yap,on_tsucpus          	

,galf_elttes,etad_repo,yaw_elas,tma_xat,2tma_dluohs,tma_dluohs              

,on_snart,on_rehcuov,epyt_yap(wolf_yapcer_mf_t otni tresni           

'OS'=on_snart@ fi        

        

/*        

esle        

) )2,1,on_hcnarb@(gnirtsbus,etad_yap@,'A',on_tsuc@,'0',etad_repo@,yaw_elas@              

,0,tma_latot@,0,tma_latot@ ,on_snart@ ,on_teehs@ ,1(seulav            

)on_hcnarb,etad_cca,yaw_yap,on_tsucpus             

,galf_elttes,etad_repo,yaw_elas,tma_xat,2tma_dluohs,tma_dluohs,tma_teehs             

,on_snart,on_rehcuov,epyt_yap(wolf_yapcer_mf_t otni tresni            

额金收应生产销代户客 -- 'B'=yaw_elas@ fi        

60-10-6002 sjuw yb detnemmoc */        

        

)(etadteg=etad_yap@ tceles            

llun si etad_yap@ fi        

nigeb    

'IR'=on_snart@ ro 'OS'=on_snart@ fi    

账收应 --    


nruter       

)on_hcnarb_qh_sl@ = hcnarb_elttes@( ton dna ) hcnarb_elttes@ = eulav_rav_sys dna 'on_hcnarb_g' = di_rav_sys erehw metsys_sys_t morf * tceles( stsixe ton fi    

部总到传上接直再款账的生产户客的算结店本 ,生产再后店总到传上,款账生产不户客的算结店门地本非--    


'on_hcnarb_qh_sys'=di_rav_sys erehw metsys_sys_t morf eulav_rav_sys = on_hcnarb_qh_sl@ tceles    


on_tsuc@=on_tsucpus dna 'C'=galf_tsucpus erehw ofni_tsucpus_db_t morf hcnarb_elttes = hcnarb_elttes@ tceles    

算结户客许允也店分的管托部总--    



1_ruc_ms etacollaed    

1_ruc_ms esolc    


dne    

1rehto@,ecirp_tsoc@,xat@,tma_bus@            

,ecirp_dilav@			,ecirp_igRO@			,3mun@			,ytq_laer@			,ytq_redro@										

,on_meti@				,galf_tcca@	,galf_snart@	,teehs_esrever@		,galf_esrever@										

,yaw_elas@				,etad_yap@	,etad_dilav@			,etad_krow@			,etad_repo@										

,di_tped@			,nam_mrifnoc@		,nam_redRO@			,di_repo@		,galf_evorppa@										

,sutats_redro@				,on_nioc@		,tnuocsid@			,yaw_yap@			,on_tsuc@										

,on_hcnarb@			,on_rehcuov@			,on_bd@			,on_snart@			,on_teehs@	OTNI 1_ruc_ms HCTEF			

            

dne        

tmAtcd_nl@ - tmAtnuocsid_nl@ = tmAtnuocsid_nl@ tceles--            

tma_bus@ - tma_latot@ = tma_latot@ tceles            

            

0=tmAtcd_nl@ tceles    --            

llun si tmAtcd_nl@ ro 0<tmAtcd_nl@ fi--            

on_meti@=on_meti erehw ofni_meti_db_t morf ytq_laer@ *)ecirp_dilav@ - ecirp_elas(=tmAtcd_nl@ tceles--            

0=tmAtcd_nl@ tceles--            

额利让 --            

            

dne            

dne				

dne					

 	dne        				

rorreym otog 0 =! rorre@@ fi            				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'																		

,etad_yap@			,di_repo@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@		,on_meti@			,etad_krow@			,on_teehs@	( 		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc																		

,etad_cca				,di_repo		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb            			

0=3mun@ ton fi            			

品赠--						


)xat_elas@,xat_esahcrup@,1rehto@ ,'0'																

,etad_yap@			,di_repo@		,yaw_elas@		,on_tsucpus@					,'-'																

,on_snart@					,llun		,on_hcnarb@			,ecirp_dilav@*ytq_laer@					,llun																

,ecirp_dilav@			,ytq_laer@		,on_meti@			,etad_krow@			,on_teehs@	( 		 SEULAV											

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc																

,etad_cca				,di_repo		,yaw_elas			,on_tsucpus				,on_bd																

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI											

 TRESNI											

nigeb					

esle                	

dne					

dne        				

rorreym otog 0 =! rorre@@ fi            				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'			,etad_yap@																		

,di_repo@		,etar_yl_pus@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@		,on_meti@			,etad_krow@			,on_teehs@	( 		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc			,etad_cca																		

,di_repo		,etar_yl_pus		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb            			

水流写量数送赠--  0=3mun@ ton fi						


)xat_elas@,xat_esahcrup@,1rehto@ ,'0'			,etad_yap@																

,di_repo@		,etar_yl_pus@		,yaw_elas@		,on_tsucpus@					,'-'																

,on_snart@					,llun		,on_hcnarb@			,ecirp_dilav@*ytq_laer@					,llun																

,ecirp_dilav@			,ytq_laer@		,on_meti@			,etad_krow@			,on_teehs@	( 		 SEULAV											

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc			,etad_cca																

,di_repo		,etar_yl_pus		,yaw_elas			,on_tsucpus				,on_bd																

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI											

 TRESNI											

nigeb					

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

                    		售销发批台后与售销SOP分区 60-10-6002 sjuw　　水流写 --                	

nigeb				

esle				

dne                

rorreym otog 0 =! rorre@@ fi    	               

on_hcnarb@,ecirp_dilav@,3mun@,ytq_laer@,on_meti@,etad_krow@,on_snart@,on_tsucpus@,on_teehs@ wolf_metibmoc_mw_rp cexe                   

nigeb                

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

水流写 --				

dne                

                  

rorreym otog 0 =! rorre@@ fi                       

)ytq_laer@,crPtsoc_nl@,ecirp_dilav@,gf_ONmeti_sl@,ytq_laer@,ecirp_dilav@,on_meti@,'6',on_hcnarb@,)121,etad_krow@,)01(rahc(trevnoc( 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                    

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


dne	                  

 	dne        				

rorreym otog 0 =! rorre@@ fi            				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'																		

,etad_yap@			,di_repo@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	( 		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc																		

,etad_cca				,di_repo		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb            			

0=3mun@ ton fi            			

品赠--						

dne                    	

 rorreym otog 0 =! rorre@@ fi	                    	

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'	,yaw_elas@	,)31,1,ON_meti@(GNIRTSBUS+'解分'					,''																		

,'1001'					,'-'		,on_snart@			,on_hcnarb@			,ecirp_dilav@*ytq_laer@																		

,ecirp_dilav@			,ytq_laer@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	( 		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc		,yaw_elas					,omem			,on_tsucpus																		

,di_repo				,on_bd		,on_snart			,on_hcnarb			,tma_teehs																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb						

)0 =! ytq_laer@( FI						

nigeb					

esle                    

dne					

dne        				

rorreym otog 0 =! rorre@@ fi            				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'			,etad_yap@																		

,di_repo@		,etar_yl_pus@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@		,on_meti@			,etad_krow@			,on_teehs@	( 		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc			,etad_cca																		

,di_repo		,etar_yl_pus		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb            			

水流写量数送赠--  0=3mun@ ton fi						


dne					

rorreym otog 0 =! rorre@@ fi				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'	,)31,1,ON_meti@(GNIRTSBUS+'解分'	,etar_yl_pus@			,yaw_elas@		,on_tsucpus@																		

,'1001'					,'-'		,on_snart@			,on_hcnarb@			,ecirp_dilav@*ytq_laer@																		

,ecirp_dilav@			,ytq_laer@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	( 		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,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			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb						

)0 =! ytq_laer@( FI						

nigeb					

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

nigeb                

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

			

'6'=ats_enibmoc.ofni_meti_db_t dna on_meti@= 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       			

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

on_meti@ = on_meti erehw ofni_meti_db_t morf                    	

etar_yl_pus=etar_yl_pus@,galf_pus_meti=yaw_elas@,tsucpus_niam=on_tsucpus@ tceles                	

esle	        	

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

ecirp_hcnarb_cp_t morf                    	

etar_yl_pus=etar_yl_pus@,yaw_elas=yaw_elas@,on_tsucpus = on_tsucpus@ tceles                	

0 >< ))2,1,on_hcnarb@(gnirtsbus = on_hcnarb dna on_meti@ = on_meti erehw ecirp_hcnarb_cp_t morf etar_yl_pus tceles( dna )on_meti@ = on_meti dna )2,1,on_hcnarb@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf 1 tceles( stsixe fi	

率扣，式方营经，商应供--				

nigeb            

))2,1,on_hcnarb@(gnirtsbus = on_hcnarb dna )'4','0'( ni epyt_edart erehw ofni_hcnarb_db_t morf 1 tceles( stsixe ro            

))2,1,on_hcnarb@(gnirtsbus = eulav_rav_sys dna 'on_hcnarb_g' = di_rav_sys erehw metsys_sys_t morf 1 tceles( stsixe fi            

店总到传上接直会水流的店分为因 水流写才店分管托和店门地本--            

            

3mun@- = 3mun@ tceles            

ytq_laer@- = ytq_laer@ tceles            

数负改货退品赠,数负为改量数库入出 --            

nigeb        

'-'=on_bd --  'IR'=on_snart@ fi esle        

dne        

tmAtcd_nl@ + tmAtnuocsid_nl@ = tmAtnuocsid_nl@ tceles--            

tma_bus@ + tma_latot@ = tma_latot@ tceles            

            

0=tmAtcd_nl@ tceles    --            

llun si tmAtcd_nl@ ro 0 < tmAtcd_nl@ fi--            

on_meti@=on_meti erehw ofni_meti_db_t morf ytq_laer@*)ecirp_dilav@ - ecirp_elas(=tmAtcd_nl@ tceles--            

0=tmAtcd_nl@ tceles--            

额利让 --            

            

dne            

dne		

	                       dne			

 	dne			

rorreym otog 0 =! rorre@@ fi			

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'																		

,etad_yap@			,di_repo@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@		,on_meti@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc																		

,etad_cca				,di_repo		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

TRESNI													

nigeb 			

0=3mun@ ton fi 			

品赠--                    

									

dne                     

rorreym otog 0 =! rorre@@ fi   							

)xat_elas@,xat_esahcrup@,1rehto@  ,'0'																		

,etad_yap@			,di_repo@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@			,tma_bus@					,llun																		

,ecirp_dilav@			,ytq_laer@		,on_meti@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc																		

,etad_cca				,di_repo		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

TRESNI													

nigeb                     

)0 =! ytq_laer@( FI                     

nigeb 		

esle                 

dne 		

dne	                

rorreym otog 0 =! rorre@@ fi 			

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'			,etad_yap@																		

,di_repo@		,etar_yl_pus@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@		,on_meti@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc			,etad_cca																		

,di_repo		,etar_yl_pus		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb        		

水流写量数送赠--  0=3mun@ ton fi			

dne                     

rorreym otog 0 =! rorre@@ fi   							

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'			,etad_yap@																		

,di_repo@		,etar_yl_pus@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@			,tma_bus@					,llun																		

,ecirp_dilav@			,ytq_laer@		,on_meti@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto  ,galf_teehstsoc			,etad_cca																		

,di_repo		,etar_yl_pus		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

TRESNI													

nigeb                     

42-70-6002 sjuw yb dedda-- )0 =! ytq_laer@( FI                     

nigeb		

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

        	nigeb             	

 esle  	        	

dne              

rorreym otog 0 =! rorre@@ fi	               

on_hcnarb@,ecirp_dilav@,3mun@,ytq_laer@,on_meti@,etad_krow@,on_snart@,on_tsucpus@,on_teehs@ wolf_metibmoc_mw_rp cexe                  

nigeb              

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

售销发批台后与售销SOP分区 60-10-6002 sjuw　　水流写 --              

)llun ton si gf_ONmeti_sl@ dna ''>< gf_ONmeti_sl@ fi( htiw dne-- DNE              

rorreym otog 0 =! rorre@@ fi   		    		

)3mun@+ytq_laer@,crPtsoc_nl@,ecirp_dilav@,gf_ONmeti_sl@                                    

,3mun@+ytq_laer@,ecirp_dilav@,on_meti@,'6',on_hcnarb@,)121,etad_krow@,)01(rahc(trevnoc( 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                 

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

              

dne                  

 	dne        				

rorreym otog 0 =! rorre@@ fi            				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'																		

,etad_yap@			,di_repo@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc																		

,etad_cca				,di_repo		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb            			

0=3mun@ ton fi            			

品赠--   						

dne                    

   rorreym otog 0 =! rorre@@ fi   	                    

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'	,yaw_elas@	,)31,1,ON_meti@(GNIRTSBUS+'解分'					,''																		

,'1001'					,'-'		,on_snart@	,on_hcnarb@,tma_bus@																		

,ecirp_dilav@			,ytq_laer@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc		,yaw_elas					,omem			,on_tsucpus																		

,di_repo				,on_bd		,on_snart			,on_hcnarb			,tma_teehs																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb                    

42-70-6002 sjuw yb dedda-- )0 =! ytq_laer@( FI                    

nigeb		

esle                  

dne 		

dne      				

rorreym otog 0 =! rorre@@ fi            				

)xat_elas@,xat_esahcrup@,1rehto@ ,'0'			,etad_yap@																		

,di_repo@		,etar_yl_pus@		,yaw_elas@		,on_tsucpus@					,'-'																		

,on_snart@					,llun		,on_hcnarb@						,0					,llun																		

,0				,3mun@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,galf_teehstsoc			,etad_cca																		

,di_repo		,etar_yl_pus		,yaw_elas			,on_tsucpus				,on_bd																		

,on_snart		,on_hcnarb_d		,on_hcnarb			,tma_teehs			,ecirp_tsoc																		

,ecirp			,ytq_laer			,on_meti			,etad_repo			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb           	

水流写量数送赠--  0=3mun@ ton fi		

                      

dne                     

rorreym otog 0 =! rorre@@ fi                          

   )xat_elas@,xat_esahcrup@,1rehto@ ,'0' ,)31,1,ON_meti@(GNIRTSBUS+'解分'	,etar_yl_pus@			,yaw_elas@		,on_tsucpus@																		

,'1001'					,'-'		,on_snart@		,on_hcnarb@,				tma_bus@																		

,ecirp_dilav@			,ytq_laer@	,gf_onmeti_sl@			,etad_krow@			,on_teehs@	(		 SEULAV													

)xat_elas,xat_esahcrup,1rehto ,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			,on_rehcuov(wolf_mi_t OTNI													

 TRESNI													

nigeb                     

42-70-6002 sjuw yb dedda-- )0 =! ytq_laer@( FI                     

nigeb                  

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

nigeb               

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

			

'6'=ats_enibmoc.ofni_meti_db_t dna on_meti@= 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       	

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

               

on_meti@ = on_meti erehw ofni_meti_db_t morf	                    

etar_yl_pus=etar_yl_pus@,galf_pus_meti=yaw_elas@,tsucpus_niam=on_tsucpus@ tceles	                

esle	        	

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

ecirp_hcnarb_cp_t morf	                    

etar_yl_pus=etar_yl_pus@,yaw_elas=yaw_elas@,on_tsucpus = on_tsucpus@ tceles	                

0 >< ))2,1,on_hcnarb@(gnirtsbus = on_hcnarb dna on_meti@ = on_meti erehw ecirp_hcnarb_cp_t morf etar_yl_pus tceles( dna )on_meti@ = on_meti dna )2,1,on_hcnarb@(gnirtsbus = on_hcnarb erehw ecirp_hcnarb_cp_t morf 1 tceles( stsixe fi		

率扣，式方营经，商应供--   				

nigeb            

))2,1,on_hcnarb@(gnirtsbus = on_hcnarb dna )'4','0'( ni epyt_edart erehw ofni_hcnarb_db_t morf 1 tceles( stsixe ro            

))2,1,on_hcnarb@(gnirtsbus = eulav_rav_sys dna 'on_hcnarb_g' = di_rav_sys erehw metsys_sys_t morf 1 tceles( stsixe fi            

店总到传上接直会水流的店分为因 水流写才店分管托和店门地本--            

/*            

dne            

rorreym otog 0 =! rorre@@ fi                

ecirp_dilav@ >< ecirp_esab dna on_meti@=on_meti erehw ecirp_dilav@=ecirp_esab tes ofni_meti_db_t etadpu                

nigeb            

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

价发批品商新更价售销按--            

*/            

           rorreym otog 0 =! rorre@@ fi            

)etad_dilav@,yaw_elas@,ecirp_dilav@,ecirp_dilav@,ecirp_dilav@,on_meti@,on_tsuc@,)2,1,on_hcnarb@(gnirtsbus(seulav                

)etad_tcartnoc,yaw_elas,ecirp_tsal,ecirp_mottob,ecirp_pot,on_meti,on_tsucpus,on_hcnarb(meti_tsucpus_db_t otni tresni                

esle            

)2,1,on_hcnarb@(gnirtsbus=on_hcnarb dna on_meti@=on_meti dna on_tsuc@=on_tsucpus erehw                

etad_dilav@=etad_tcartnoc,yaw_elas@=yaw_elas,ecirp_dilav@=ecirp_tsal                      

,)dne ecirp_mottob esle ecirp_dilav@                      

 neht llun si ecirp_mottob ro 0=ecirp_mottob ro )ecirp_dilav@>ecirp_mottob( nehw esac(=ecirp_mottob                      

换代格价务业前当用应，况情的LLUN或0为价低最有现 --                      

,)dne ecirp_pot esle ecirp_dilav@ neht ecirp_dilav@<ecirp_pot nehw esac(=ecirp_pot                       

tes meti_tsucpus_db_t etadpu                

)on_meti@=on_meti                        

 dna on_tsuc@=on_tsucpus dna )2,1,on_hcnarb@(gnirtsbus=on_hcnarb erehw meti_tsucpus_db_t morf 1 tceles(stsixe fi            

系关品商与户客护维 --            

            

dne            

rorreym otog 0 =! rorre@@ fi                

on_rehcuov@ = on_teehs erehw '1' = sutats_redro TES  retsam_teehs_mw_t ETADPU                    

esle                

on_rehcuov@ = on_teehs erehw '2' = sutats_redro TES  retsam_teehs_mw_t ETADPU                    

)on_teehs yb puorg )0,1mun(llunsi + ytq_redro> )0,3mun(llunsi + ytq_laer dna on_rehcuov@ = on_teehs erehw                    

liated_teehs_mw_t morf on_teehs tceles(stsixe ton FI                

                

rorreym otog 0 =! rorre@@ fi                

on_meti@ = on_meti dna on_rehcuov@ = on_teehs  erehw                    

3mun@+)0,1mun(llunsi=1mun,ytq_laer@ + )0,ytq_redro(llunsi = ytq_redro TES liated_teehs_mw_t ETADPU                

态状、ytq_redro量数货到单定售销改修 --                

nigeb            

'' >< on_rehcuov@ fi            

nigeb        

库出售销-- 'OS'=on_snart@ fi        

on_meti@ = on_meti erehw		

ofni_meti_db_t morf		

xat_elas = xat_elas@ ,xat_esahcrup = xat_esahcrup@ tceles		

税项销和税项进的案档品商取，91-90-7102 dhnehc--		

nigeb    

0=sutats_hctef@@ elihw    

1rehto@,ecirp_tsoc@,xat@,tma_bus@        

,ecirp_dilav@,ecirp_igro@,3mun@,ytq_laer@,ytq_redro@,on_meti@        

,galf_tcca@,galf_snart@,teehs_esrever@,galf_esrever@,yaw_elas@        

,etad_yap@,etad_dilav@,etad_krow@,etad_repo@        

,di_tped@,nam_mrifnoc@,nam_redro@,di_repo@        

,galf_evorppa@,sutats_redro@        

,on_nioc@,tnuocsid@ ,yaw_yap@,on_tsuc@        

,on_hcnarb@,on_rehcuov@,on_bd@,on_snart@,on_teehs@        

otni 1_ruc_ms hctef    

1_ruc_ms nepo    

0= tmAtnuocsid_nl@ tceles--    

0=tma_latot@ tceles    

)0 =! 3mun ro ( 42-70-6002 sjuw yb dedda--                                       

 零为得不量数据单-- )0 =! 3mun ro 0=!ytq_laer.b(  dna )'1' = galf_evorppa.a( dna      

) on_teehs.b = on_teehs.a ( erehw    

b liated_teehs_mw_t ,a detresni morf    

1rehto.b,)0,ecirp_tsoc(llunsi,)0,xat.b(llunsi,)0,tma_bus.b(llunsi        

,)0,ecirp_dilav.b(llunsi,)0,ecirp_igro.b(llunsi,)0,3mun.b(llunsi,ytq_laer.b,ytq_redro.b,on_meti.b        

,galf_tcca.a,galf_snart.a,teehs_esrever.a,galf_esrever.a,yaw_elas.a        

,etad_yap.a,etad_dilav.a,etad_krow.a,etad_repo.a        

,di_tped.a,nam_mrifnoc.a,nam_redro.a,di_repo.a        

,galf_evorppa.a,sutats_redro.a        

,)'BMR',on_nioc.a(llunsi,tnuocsid.a,)'A',yaw_yap.a(llunsi,)'',on_tsucpus.a(llunsi        

,on_hcnarb.a,)'',on_rehcuov.a(llunsi,on_bd.a,on_snart.a,on_teehs.a tceles        

rof rosruc 1_ruc_ms eralced    


)6(rahc on_hcnarb_qh_sl@--    

,)4,61(ciremun crPpmt_nl@--	

, )4,61(ciremun crPtsoc_nl@--	

品商割分鲜生--   ,)02(rahcrav gf_ONmeti_sl@--    


)店门算结(构机属所户客--    ,)4(rahcrav  hcnarb_elttes@ --   

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

,)4,61(ciremun    etar_yl_pus@--    

,)4,61(ciremun tmAtnuocsid_nl@--    

)01(rahc    etaDrepo_sl@    

,)4,61(ciremun      tmAtcd_nl@--    

锐项销--  ,)2,4(CIREMUN			xat_elas@	

税项进--   ,)2,4(CIREMUN			xat_esahcrup@	

,)4,61(CIREMUN			crPpmt_nl@	

,)4,61(CIREMUN			crPtsoc_nl@	

,)4,61(CIREMUN		etar_yl_pus@	

,)4,5(CIREMUN			tnuocsid@	

额金--   ,)4,61(ciremun      tma_latot@    

,)4,5(ciremun            xat@    

,)4,61(ciremun        tma_bus@    

价单售零--,   )4,61(ciremun     ecirp_tsoc@    

价单售零--,   )4,61(ciremun    ecirp_dilav@    

价单货进--,   )4,61(ciremun     ecirp_igro@    

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

量数--,   )4,61(ciremun       ytq_laer@    

量数--,   )4,61(ciremun      ytq_redro@    

期日款付--		,EMITETAD			etad_yap@	

期效有单订--		,EMITETAD			etad_dilav@	

期日核审--		,EMITETAD			etad_krow@	

期日作操--		,EMITETAD			etad_repo@	

品商割分鲜生--	,)02(RAHCRAV		gf_onmeti_sl@	

)店门算结(构机属所户客--		,)4(RAHCRAV		hcnarb_elttes@	

,)6(RAHC	on_hcnarb_qh_sl@	

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

,)01(RAHC		etaDrepo_sl@--	

号证凭始原--		, )41(RAHC		on_rehcuov_os@	

,)2(RAHC			snart_dlo@	

码代品货--,        )02(rahc        on_meti@    

,)1(rahc      galf_tcca@    

,)1(rahc     galf_snart@    

,)41(rahc  teehs_esrever@    

,)1(rahc   galf_esrever@    

,)1(rahc       yaw_elas@    

期日款付--,   emitetad       etad_yap@ --   

期效有单订--,   emitetad     etad_dilav@--    

期日核审--,   emitetad      etad_krow@ --   

,)552(rahcrav         1rehto@    

,)4(rahc        di_tped@    

,)4(rahc    nam_mrifnoc@    

,)4(rahc      nam_redro@    

,)4(rahc        di_repo@    

核审-1，核审未-0--  志标批审--,      )1(rahc   galf_evorppa@    

,)1(rahc   sutats_redro@    

种币--,         )3(rahc        on_nioc@    

,   )4,5(ciremun       tnuocsid@ --   

式方款付--,         )2(rahc        yaw_yap@    

码代户客商应供--,        )8(rahc     on_tsucpus@    

码代户客--,        )8(rahc        on_tsuc@    

码代店本--,        )6(rahc      on_hcnarb@    

号证凭始原--,         )41(rahc     on_rehcuov@    

式方库入出--,      )1(rahc          on_bd@    

式方作操存库--,         )2(rahc       on_snart@    

号单作工--, )41(rahc       on_teehs@    

eralced  


nruter )galf_evorppa(etadpu ton fi  

nigeb

sa

 etadpu rof

retsam_teehs_mw_t no retsam_teehs_mw_rt reggirt etAERC


og

retsam_teehs_mw_rt reggirt pord  

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

dne

nruter        

kcabllor        

2_ruc_ms etacollaed        

2_ruc_ms esolc        

:rorreym    

    

nruter    

2_ruc_ms etacollaed    

2_ruc_ms esolc	


dne    

ecirp_dilav_cedl@,on_meti_sl@        

,yaw_elas_sl@        

,etad_dilav_tdl@,on_tsuc_sl@        

,on_hcnarb_sl@,on_snart_sl@		

otni 2_ruc_ms hctef		

dne        

rorreym otog 0 =! rorre@@ fi            

)etad_dilav_tdl@,yaw_elas_sl@,ecirp_dilav_cedl@,ecirp_dilav_cedl@,ecirp_dilav_cedl@,on_meti_sl@,on_tsuc_sl@,)2,1,on_hcnarb_sl@(gnirtsbus(seulav                

)etad_tcartnoc,yaw_elas,ecirp_tsal,ecirp_mottob,ecirp_pot,on_meti,on_tsucpus,on_hcnarb(meti_tsucpus_db_t otni tresni                

esle            

)2,1,on_hcnarb_sl@(gnirtsbus=on_hcnarb dna on_meti_sl@=on_meti dna on_tsuc_sl@=on_tsucpus erehw                

etad_dilav_tdl@=etad_tcartnoc,yaw_elas_sl@=yaw_elas,ecirp_dilav_cedl@=ecirp_tsal                      

,)dne ecirp_mottob esle ecirp_dilav_cedl@                      

 neht llun si ecirp_mottob ro 0=ecirp_mottob ro )ecirp_dilav_cedl@>ecirp_mottob( nehw esac(=ecirp_mottob                      

换代格价务业前当用应，况情的LLUN或0为价低最有现 --                      

,)dne ecirp_pot esle ecirp_dilav_cedl@ neht ecirp_dilav_cedl@ < ecirp_pot nehw esac( = ecirp_pot                       

tes meti_tsucpus_db_t etadpu                

)on_meti_sl@=on_meti                        

 dna on_tsuc_sl@=on_tsucpus dna )2,1,on_hcnarb_sl@(gnirtsbus = on_hcnarb erehw meti_tsucpus_db_t morf 1 1 pot tceles(stsixe fi            

系关品商与户客护维 --            

)'',ytreporp_sl@(llunsi = ytreporp_sl@ tceles			

)2,on_hcnarb_sl@(tfel = on_hcnarb erehw )kcolon(htiw ofni_hcnarb_db_t morf ytreporp = ytreporp_sl@ tceles			

'' = ytreporp_sl@ tes			

nigeb        

库出售销-- '1' = detubirtsid_si_sl@ dna 'OS'=on_snart_sl@ fi        

nigeb    

0=sutats_hctef@@ elihw    

ecirp_dilav_cedl@,on_meti_sl@        

,yaw_elas_sl@        

,etad_dilav_tdl@,on_tsuc_sl@        

,on_hcnarb_sl@,on_snart_sl@		

otni 2_ruc_ms hctef    

2_ruc_ms nepo    

                                   

)'2',detubirtsid_si_sl@(llunsi = detubirtsid_si_sl@ tceles	

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

'2' = detubirtsid_si_sl@ tes	


 零为得不量数据单-- )0 =! 3mun ro 0=!ytq_laer.b(  		

dna 'OS' = on_snart.a  		

 dna '1' = galf_evorppa.a  		

dna on_teehs.b = on_teehs.a erehw    

b liated_teehs_mw_t ,a detresni morf    

ecirp_dilav.b,on_meti.b			

,yaw_elas.a			

,etad_dilav.a			

,)'',on_tsucpus.a(llunsi			

,on_hcnarb.a,on_snart.a  tceles    

rof rosruc 2_ruc_ms eralced    

    

价单售零--   )4,61(ciremun  ecirp_dilav_cedl@    

期效有单订--		,EMITETAD   	etad_dilav_tdl@	

,)1(rahc detubirtsid_si_sl@	

,)1(rahc      ytreporp_sl@	

码代品货--        ,)02(rahc        on_meti_sl@    

,)1(rahc       yaw_elas_sl@    

码代户客商应供--        ,)8(rahc     on_tsucpus_sl@    

码代户客--        ,)8(rahc        on_tsuc_sl@    

码代店本--        ,)6(rahc      on_hcnarb_sl@    

式方作操存库--         ,)2(rahc       on_snart_sl@    

eralced	

------------系关品商户客部分此护维部总-部总到单OS传上部分---51-80-2102---pduoy---------------------

nigeb

sa

 tresni rof

retsam_teehs_mw_t no ecirp_rof_retsam_teehs_mw_rt reggirt etAERC




og

ecirp_rof_retsam_teehs_mw_rt reggirt pord  

)'ecirp_rof_retsam_teehs_mw_rt'=eman erehw stcejbosys morf 1 tceles(stsixe fi####@@@@