tabel temporary

NOTICE:  Start at : 2017-03-07 17:25:22.973769
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000516
NOTICE:  Done get month for : 00:00:00.000279
NOTICE:  Done get vDateFrom for : 00:00:00.000194
NOTICE:  Done get vDateTo for : 00:00:00.000185
NOTICE:  Done get vRoundingDigitUSD for : 00:00:00.000219
NOTICE:  Done get vRoundingDigitIDR for : 00:00:00.000129
NOTICE:  Done ambil valuta buku for : 00:00:00.00016
NOTICE:  Done get vMainCoaExtCommission for : 00:00:00.000126
NOTICE:  Done get vSubCoaExtCommission for : 00:00:00.000144
NOTICE:  Done get vCoaIdExtCommission for : 00:00:00.000197
NOTICE:  Done ambil 1 bulan setelah date to dan 1 bulan sebelum date from for : 00:00:00.000252
NOTICE:  Done delete fi_temp_summary_monthly_ar for : 00:00:00.001589
NOTICE:  Done insert dari fi_summary_monthly_ar  for : 00:00:00.017439
NOTICE:  Done ambil bulan terakhir tutup bulan  for : 00:00:00.002009
NOTICE:  Done tutup bulan sementara for : 00:00:00.123052
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (1) for : 00:00:00.214432
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (2) for : 00:00:00.081842
NOTICE:  Done update tr_data_so_sales_commission_for_igs warranty sell amount for : 00:00:00.008111
NOTICE:  Done update nilai original_price and original total_amount for : 00:00:00.001147
NOTICE:  Done update table temporary for numerator_rate, denominator_rate for : 00:00:00.066897
NOTICE:  Done insert tr_data_costs_sales_commission_for_igs (3) other cost for : 00:00:01.208382
NOTICE:  Done update table cost tr_data_so_sales_for_commission non ext commission for : 00:00:00.089351
NOTICE:  Done update table cost tr_data_so_sales_for_commission ext commission for : 00:00:00.090799
NOTICE:  Done update total_amount_usd for : 00:00:00.001301
NOTICE:  Done update total_amount_idr for : 00:00:00.001407
NOTICE:  Done update other_costs_usd for : 00:00:00.002263
NOTICE:  Done update line_of_business yang kosong menjadi DEFAULT for : 00:00:00.000832
NOTICE:  Done update bulan pelunasan for : 00:00:00.031357
NOTICE:  Done pRefHeader for : 00:00:00.000209
NOTICE:  Done pRefDetail for : 00:00:00.00088
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000491
NOTICE:  End at : 2017-03-07 17:25:24.920027+07
Total query runtime: 2014 ms.
2 rows retrieved.