From af33dac188fe74e189246c0c9d1c0c9df93b3bc2 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 22 Oct 2025 09:33:17 +0700 Subject: update_cogs_fixco.ktr --- import_account_move_onetime.ktr | 561 ++++++++++++++++++++++++++++++++++++++-- 1 file changed, 545 insertions(+), 16 deletions(-) (limited to 'import_account_move_onetime.ktr') diff --git a/import_account_move_onetime.ktr b/import_account_move_onetime.ktr index fe12538..da576f8 100644 --- a/import_account_move_onetime.ktr +++ b/import_account_move_onetime.ktr @@ -437,14 +437,14 @@ - dw bi indoteknik (localhost) + dw bi indoteknik localhost POSTGRESQL Native dw_bi_indoteknik - 5432 - pdi - Encrypted 2be989bb20084ca95810197629d9ea18e + 5703 + metabase + Encrypted 2be98dfba28d7bf86853c9f58cfc4f889 @@ -463,7 +463,7 @@ PORT_NUMBER - 5432 + 5703 PRESERVE_RESERVED_WORD_CASE @@ -479,7 +479,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - N + Y USE_POOLING @@ -488,14 +488,14 @@ - erp indoteknik production (localhost) - 10.148.0.3 + erp indoteknik production + localhost POSTGRESQL Native erp_indoteknik - 5432 - pdi - Encrypted 2be989bb20084ca95810197629d9ea18e + 5901 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 @@ -514,7 +514,7 @@ PORT_NUMBER - 5432 + 5901 PRESERVE_RESERVED_WORD_CASE @@ -530,7 +530,7 @@ SUPPORTS_TIMESTAMP_DATA_TYPE - N + Y USE_POOLING @@ -556,7 +556,7 @@ none - dw bi indoteknik (localhost) + dw bi indoteknik 100 N @@ -1019,10 +1019,10 @@ none - erp indoteknik production (localhost) + erp indoteknik production select am.* from account_move am where 1=1 -and am.write_date between '2024-06-01' and '2024-06-30' +and am.write_date between '2025-01-01' and '2025-10-30' --and to_char(am.date, 'YYYY') = '2023' --and (am.move_type = 'out_invoice' or journal_id = 3) --and am.write_date >= (now() - '5 days'::interval) @@ -2942,6 +2942,535 @@ and am.write_date between '2024-06-01' and '2024-06-30' Asia/Bangkok N + + String + normal + no_faktur_pajak + 2147483647 + -1 + Table input + no_faktur_pajak + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal + date_completed + 6 + -1 + Table input + date_completed + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal + is_customer_commision + -1 + -1 + Table input + is_customer_commision + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + sale_id + 9 + 0 + Table input + sale_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + reklas_id + 9 + 0 + Table input + reklas_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal + date_efaktur_upload + 6 + -1 + Table input + date_efaktur_upload + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + real_invoice_id + 9 + 0 + Table input + real_invoice_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + bills_efaktur_exporter + 9 + 0 + Table input + bills_efaktur_exporter + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal + bills_date_efaktur + 6 + -1 + Table input + bills_date_efaktur + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + bills_invoice_exporter + 9 + 0 + Table input + bills_invoice_exporter + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal + bills_date_invoice + 6 + -1 + Table input + bills_date_invoice + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal + is_invoice_uploaded + -1 + -1 + Table input + is_invoice_uploaded + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal + is_efaktur_uploaded + -1 + -1 + Table input + is_efaktur_uploaded + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal + already_paid + -1 + -1 + Table input + already_paid + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + nomor_kwitansi + 2147483647 + -1 + Table input + nomor_kwitansi + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal + is_hr + -1 + -1 + Table input + is_hr + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + purchase_order_id + 9 + 0 + Table input + purchase_order_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + reklas_misc_id + 9 + 0 + Table input + reklas_misc_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + bill_id + 9 + 0 + Table input + bill_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal + down_payment + -1 + -1 + Table input + down_payment + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal + refund_id + 9 + 0 + Table input + refund_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal + reminder_sent_date + -1 + -1 + Table input + reminder_sent_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal + customer_promise_date + -1 + -1 + Table input + customer_promise_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + -- cgit v1.2.3