Advertisement
mugs

update AR_SYS_INFO_T for fiscal year maker

May 27th, 2015
310
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.51 KB | None | 0 0
  1. -- remove non-existent object codes
  2. UPDATE AR_SYS_INFO_T SET refund_fin_obj_cd=3103 WHERE refund_fin_obj_cd=3063;
  3. UPDATE AR_SYS_INFO_T SET univ_clr_object_cd=3103 WHERE univ_clr_object_cd=3063;
  4. UPDATE AR_SYS_INFO_T SET pmt_clr_fin_obj_cd=3103 WHERE pmt_clr_fin_obj_cd=3063;
  5.  
  6. -- remove non-existent org codes
  7. UPDATE AR_SYS_INFO_T SET PRCS_ORG_CD='9998' WHERE PRCS_ORG_CD='3310';
  8. UPDATE AR_SYS_INFO_T SET PRCS_ORG_CD='9983' WHERE PRCS_ORG_CD='8507';
  9. UPDATE AR_SYS_INFO_T SET PRCS_ORG_CD='9996' WHERE PRCS_ORG_CD='6201';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement