Join di pRefDetail

NOTICE:  Start at : 2017-03-07 17:04:29.579556
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000268
NOTICE:  Done get month for : 00:00:00.000167
NOTICE:  Done get vDateFrom for : 00:00:00.0001
NOTICE:  Done get vDateTo for : 00:00:00.000082
NOTICE:  Done get vRoundingDigitUSD for : 00:00:00.000126
NOTICE:  Done get vRoundingDigitIDR for : 00:00:00.000099
NOTICE:  Done ambil valuta buku for : 00:00:00.000233
NOTICE:  Done get vMainCoaExtCommission for : 00:00:00.000223
NOTICE:  Done get vSubCoaExtCommission for : 00:00:00.000165
NOTICE:  Done get vCoaIdExtCommission for : 00:00:00.000182
NOTICE:  Done ambil 1 bulan setelah date to dan 1 bulan sebelum date from for : 00:00:00.000275
NOTICE:  Done delete fi_temp_summary_monthly_ar for : 00:00:00.001038
NOTICE:  Done insert dari fi_summary_monthly_ar  for : 00:00:00.016244
NOTICE:  Done ambil bulan terakhir tutup bulan  for : 00:00:00.00151
NOTICE:  Done tutup bulan sementara for : 00:00:00.105171
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (1) for : 00:00:00.205839
NOTICE:  Done insert tr_data_so_sales_commission_for_igs (2) for : 00:00:00.076539
NOTICE:  Done update tr_data_so_sales_commission_for_igs warranty sell amount for : 00:00:00.00011
NOTICE:  Done update nilai original_price and original total_amount for : 00:00:00.001044
NOTICE:  Done update table temporary for numerator_rate, denominator_rate for : 00:00:00.063829
NOTICE:  Done insert tr_data_costs_sales_commission_for_igs (3) other cost for : 00:00:01.202229
NOTICE:  Done update table cost tr_data_so_sales_for_commission non ext commission for : 00:00:00.092302
NOTICE:  Done update table cost tr_data_so_sales_for_commission ext commission for : 00:00:00.09069
NOTICE:  Done update total_amount_usd for : 00:00:00.001305
NOTICE:  Done update total_amount_idr for : 00:00:00.001106
NOTICE:  Done update other_costs_usd for : 00:00:00.001116
NOTICE:  Done update line_of_business yang kosong menjadi DEFAULT for : 00:00:00.00034
NOTICE:  Done update bulan pelunasan for : 00:00:00.031057
NOTICE:  Done pRefHeader for : 00:00:00.000194
NOTICE:  Done pRefDetail for : 00:00:00.002533
NOTICE:  Done delete tr_data_so_sales_commission_for_igs for : 00:00:00.000433
NOTICE:  End at : 2017-03-07 17:04:31.47617+07

Total query runtime: 1966 ms.
2 rows retrieved.