Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Combine Tax
- UPDATE fi_invoice_ar_tax
- SET tax_no = '010.019-17.42901275',
- --tax_date = '20170911',
- update_datetime = '20170911140101', update_user_id = -2, version = version + 1
- where invoice_ar_id = 32542
- UPDATE m_gen_tax_number
- SET invoice_id = -99, invoice_doc_type_id = -99, invoice_doc_no = ' ', invoice_doc_date = ' ',
- update_datetime = '20170911140101', update_user_id = -2, version = version + 1
- WHERE tax_no = '019-17.42901217'
- UPDATE m_gen_tax_number
- SET invoice_id =32542, invoice_doc_type_id = 284,
- invoice_doc_no = 'OTC/201708/001', invoice_doc_date = '20170831',
- update_datetime = '20170911140101', version = version + 1,
- update_user_id = -2
- WHERE tax_no = '019-17.42901275'
- --Sales Invoice
- UPDATE sl_invoice_tax SET tax_no = '010.019-17.42901217' WHERE invoice_tax_id = 14481
- UPDATE fi_invoice_tax_ar_balance SET tax_no = '010.019-17.42901217' WHERE invoice_ar_balance_id = 31338
- UPDATE m_gen_tax_number
- SET invoice_id = -1, invoice_doc_type_id = -1, invoice_doc_no = ' ', invoice_doc_date = ' ',
- update_datetime = '20170911140101', update_user_id = -2, version = version + 1
- WHERE tax_no = '019-17.42901160'
- UPDATE m_gen_tax_number
- SET invoice_id =38479, invoice_doc_type_id = 321,
- invoice_doc_no = 'SI/000028/KPS/201708', invoice_doc_date = '20170807',
- update_datetime = '20170911140101', version = version + 1,
- update_user_id = -2
- WHERE tax_no = '019-17.42901217'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement