SHARE
TWEET

Untitled

a guest Jul 17th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --To be run immediately before MST391, to zero out the RFD ARPPDH CRD-AMT values.
  2. update arppdh_m
  3. set arppdh_m.crd_amt = 0.000000
  4. from arppdh_m
  5. join mstprm_m prm on prm.ord_num = arppdh_m.dbt_nbr
  6. where prm.ctm_nbr in ('000097583085', '000097583086', '000097583807') and arppdh_m.src_dta = 'RFD'
  7.  
  8. --To be run immediately after MST391, to restore the RFD ARPPDH CRD-AMT values.
  9. update arppdh_m
  10. set arppdh_m.crd_amt = arppdh_m.tot_pad
  11. from arppdh_m
  12. join mstprm_m prm on prm.ord_num = arppdh_m.dbt_nbr
  13. where prm.ctm_nbr in ('000097583085', '000097583086', '000097583807') and arppdh_m.src_dta = 'RFD'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top