yang lama

NOTICE:  Start at : 2017-03-07 16:10:21.125588
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000246
NOTICE:  Done get month for : 00:00:00.000161
NOTICE:  Done get vDateFrom for : 00:00:00.000098
NOTICE:  Done get vDateTo for : 00:00:00.000084
NOTICE:  Done get vRoundingDigitUSD for : 00:00:00.000125
NOTICE:  Done get vRoundingDigitIDR for : 00:00:00.000101
NOTICE:  Done ambil valuta buku for : 00:00:00.000133
NOTICE:  Done get vMainCoaExtCommission for : 00:00:00.000116
NOTICE:  Done get vSubCoaExtCommission for : 00:00:00.000108
NOTICE:  Done get vCoaIdExtCommission for : 00:00:00.000155
NOTICE:  Done ambil 1 bulan setelah date to dan 1 bulan sebelum date from for : 00:00:00.000208
NOTICE:  Done delete fi_temp_summary_monthly_ar for : 00:00:00.001009
NOTICE:  Done insert dari fi_summary_monthly_ar  for : 00:00:00.016357
NOTICE:  Done ambil bulan terakhir tutup bulan  for : 00:00:00.001428
NOTICE:  Done tutup bulan sementara for : 00:00:00.107737
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (1) for : 00:00:00.217629
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (2) for : 00:00:00.086988
NOTICE:  Done update nilai original_price and original total_amount for : 00:00:00.001122
NOTICE:  Done update table temporary for numerator_rate, denominator_rate for : 00:00:00.063926
NOTICE:  Done insert tr_data_costs_sales_commission_for_igs (3) other cost for : 00:00:01.219105
NOTICE:  Done update table cost tr_data_so_sales_for_commission non ext commission for : 00:00:00.091358
NOTICE:  Done update table cost tr_data_so_sales_for_commission ext commission for : 00:00:00.092589
NOTICE:  Done update total_amount_usd for : 00:00:00.001354
NOTICE:  Done update total_amount_idr for : 00:00:00.001125
NOTICE:  Done update other_costs_usd for : 00:00:00.00112
NOTICE:  Done update line_of_business yang kosong menjadi DEFAULT for : 00:00:00.000338
NOTICE:  Done update bulan pelunasan for : 00:00:00.031744
NOTICE:  Done pRefHeader for : 00:00:00.000198
NOTICE:  Done pRefDetail for : 00:00:00.00067
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000532
NOTICE:  End at : 2017-03-07 16:10:23.06355+07

Total query runtime: 2009 ms.
2 rows retrieved.