dengan update

NOTICE:  Start at : 2017-03-07 16:08:43.973932
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000375
NOTICE:  Done get month for : 00:00:00.000342
NOTICE:  Done get vDateFrom for : 00:00:00.000214
NOTICE:  Done get vDateTo for : 00:00:00.000181
NOTICE:  Done get vRoundingDigitUSD for : 00:00:00.000263
NOTICE:  Done get vRoundingDigitIDR for : 00:00:00.000218
NOTICE:  Done ambil valuta buku for : 00:00:00.000299
NOTICE:  Done get vMainCoaExtCommission for : 00:00:00.000229
NOTICE:  Done get vSubCoaExtCommission for : 00:00:00.000215
NOTICE:  Done get vCoaIdExtCommission for : 00:00:00.000307
NOTICE:  Done ambil 1 bulan setelah date to dan 1 bulan sebelum date from for : 00:00:00.000417
NOTICE:  Done delete fi_temp_summary_monthly_ar for : 00:00:00.002013
NOTICE:  Done insert dari fi_summary_monthly_ar  for : 00:00:00.019462
NOTICE:  Done ambil bulan terakhir tutup bulan  for : 00:00:00.001131
NOTICE:  Done tutup bulan sementara for : 00:00:00.124519
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (1) for : 00:00:00.212309
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (2) for : 00:00:00.084149
NOTICE:  Done update warranty sell amount for : 00:00:00.012458
NOTICE:  Done update nilai original_price and original total_amount for : 00:00:00.001109
NOTICE:  Done update table temporary for numerator_rate, denominator_rate for : 00:00:00.067721
NOTICE:  Done insert tr_data_costs_sales_commission_for_igs (3) other cost for : 00:00:01.246182
NOTICE:  Done update table cost tr_data_so_sales_for_commission non ext commission for : 00:00:00.093492
NOTICE:  Done update table cost tr_data_so_sales_for_commission ext commission for : 00:00:00.090762
NOTICE:  Done update total_amount_usd for : 00:00:00.001328
NOTICE:  Done update total_amount_idr for : 00:00:00.001082
NOTICE:  Done update other_costs_usd for : 00:00:00.001386
NOTICE:  Done update line_of_business yang kosong menjadi DEFAULT for : 00:00:00.00062
NOTICE:  Done update bulan pelunasan for : 00:00:00.030874
NOTICE:  Done pRefHeader for : 00:00:00.000201
NOTICE:  Done pRefDetail for : 00:00:00.000698
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000402
NOTICE:  End at : 2017-03-07 16:08:45.968953+07

Total query runtime: 2074 ms.
2 rows retrieved.