Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  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'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement