Advertisement
aadddrr

KPS-523

Sep 11th, 2017
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     --Combine Tax
  2.  
  3.     UPDATE fi_invoice_ar_tax
  4.     SET tax_no = '010.019-17.42901275',
  5.         --tax_date = '20170911',
  6.         update_datetime = '20170911140101', update_user_id = -2, version = version + 1
  7.     where invoice_ar_id = 32542
  8.  
  9.     UPDATE m_gen_tax_number
  10.       SET invoice_id = -99, invoice_doc_type_id = -99, invoice_doc_no = ' ', invoice_doc_date = ' ',
  11.         update_datetime = '20170911140101', update_user_id = -2, version = version + 1  
  12.     WHERE tax_no = '019-17.42901217'
  13.    
  14.     UPDATE m_gen_tax_number
  15.       SET invoice_id =32542, invoice_doc_type_id = 284,
  16.           invoice_doc_no = 'OTC/201708/001', invoice_doc_date = '20170831',
  17.           update_datetime = '20170911140101', version = version + 1,
  18.           update_user_id = -2
  19.     WHERE tax_no = '019-17.42901275'
  20.  
  21.  
  22.     --Sales Invoice
  23.  
  24.     UPDATE sl_invoice_tax SET tax_no = '010.019-17.42901217' WHERE invoice_tax_id = 14481
  25.  
  26.     UPDATE fi_invoice_tax_ar_balance SET tax_no = '010.019-17.42901217' WHERE invoice_ar_balance_id = 31338
  27.  
  28.     UPDATE m_gen_tax_number
  29.       SET invoice_id = -1, invoice_doc_type_id = -1, invoice_doc_no = ' ', invoice_doc_date = ' ',
  30.         update_datetime = '20170911140101', update_user_id = -2, version = version + 1  
  31.     WHERE tax_no = '019-17.42901160'
  32.    
  33.     UPDATE m_gen_tax_number
  34.       SET invoice_id =38479, invoice_doc_type_id = 321,
  35.           invoice_doc_no = 'SI/000028/KPS/201708', invoice_doc_date = '20170807',
  36.           update_datetime = '20170911140101', version = version + 1,
  37.           update_user_id = -2
  38.     WHERE tax_no = '019-17.42901217'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement