Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --To be run immediately before MST391, to zero out the RFD ARPPDH CRD-AMT values.
- update arppdh_m
- set arppdh_m.crd_amt = 0.000000
- from arppdh_m
- join mstprm_m prm on prm.ord_num = arppdh_m.dbt_nbr
- where prm.ctm_nbr in ('000097583085', '000097583086', '000097583807') and arppdh_m.src_dta = 'RFD'
- --To be run immediately after MST391, to restore the RFD ARPPDH CRD-AMT values.
- update arppdh_m
- set arppdh_m.crd_amt = arppdh_m.tot_pad
- from arppdh_m
- join mstprm_m prm on prm.ord_num = arppdh_m.dbt_nbr
- where prm.ctm_nbr in ('000097583085', '000097583086', '000097583807') and arppdh_m.src_dta = 'RFD'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement