Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM in_summary_monthly_amount WHERE product_id = 20000227 AND date_year_month = '201710'
- SELECT * FROM in_summary_monthly_amount WHERE product_id = 20000261 AND date_year_month = '201710'
- SELECT * FROM in_summary_monthly_amount WHERE product_id = 20000403 AND date_year_month = '201710'
- SELECT * FROM in_summary_monthly_qty WHERE date_year_month = '201709'
- SELECT * FROM m_product WHERE product_code = 'KLSG81000'
- SELECT * FROM m_product WHERE product_code = 'SRL100100'
- SELECT * FROM m_product WHERE product_code = 'KCR311100'
- SELECT * FROM m_ctgr_product WHERE ctgr_product_id = 15100013
- SELECT * FROM m_ctgr_product WHERE ctgr_product_id = 15100008
- SELECT * FROM m_group_product WHERE group_product_id = 1000003
- BEGIN
- --Insert in_summary_monthly_amount Okt 2017
- INSERT INTO in_summary_monthly_amount(
- date_year_month, tenant_id,
- ou_bu_id, ou_branch_id, ou_sub_bu_id,
- doc_type_id, product_id, base_uom_id,
- qty, gl_curr_code, gl_amount, flg_amount, version, create_datetime,
- create_user_id, update_datetime, update_user_id, remark)
- --KLSG81000, qty 1, amount 43455
- VALUES ('201710', 11,
- 1000001, -99, -99,
- -99, 20000227, 15000001,
- 1, 'IDR', 43455, 'BGN_BALANCE', 0, '20180605000000',
- -1, '20180605000000', -1, 'FG'),
- --KCR311100, qty 1, amount 18000
- VALUES ('201710', 11,
- 1000001, -99, -99,
- -99, 20000403, 15000001,
- 1, 'IDR', 18000, 'BGN_BALANCE', 0, '20180605000000',
- -1, '20180605000000', -1, 'FG')
- --Update in_summary_monthly_amount Okt 2017
- --SRL100100, qty 58 + 2, amount 406000 + 14000
- UPDATE in_summary_monthly_amount SET qty = 60, gl_amount = 420000 WHERE summary_monthly_amount_id = 15005033
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement