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