Advertisement
aadddrr

INDOCOM-668

Sep 14th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     UPDATE sl_do SET doc_date = '20170913' WHERE do_id = 13958
  2.  
  3.     UPDATE sl_so_balance_invoice SET ref_doc_date = '20170913' WHERE ref_doc_type_id = 311 AND ref_id = 13958 AND ref_doc_no = 'GDO/00775/201709'
  4.  
  5.     UPDATE in_log_product_balance_stock SET doc_date = '20170913' WHERE doc_type_id = 311 AND ref_id = 13958 AND doc_no = 'GDO/00775/201709'
  6.  
  7.     UPDATE in_balance_do_item SET doc_date = '20170913' WHERE do_id = 13958 AND doc_no = 'GDO/00775/201709'
  8.  
  9.     UPDATE sl_so_balance_warranty_invoice SET ref_doc_date = '20170913' WHERE ref_doc_type_id = 311 AND ref_id = 13958 AND ref_doc_no = 'GDO/00775/201709'
  10.  
  11.     SELECT * FROM gl_journal_trx WHERE doc_type_id = 311 AND doc_id = 13958 AND doc_no = 'GDO/00775/201709'
  12.  
  13.     85633
  14.  
  15.     UPDATE gl_journal_trx SET doc_date = '20170913' WHERE doc_type_id = 311 AND doc_id = 13958 AND doc_no = 'GDO/00775/201709'
  16.  
  17.     UPDATE gl_journal_trx_item SET journal_date = '20170913' WHERE journal_trx_id = 85633
  18.  
  19.     UPDATE gl_journal_trx_mapping SET journal_date = '20170913' WHERE journal_trx_id = 85633
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement