From 18ee9a66fa2524c54ae2caa11f495188b29125d9 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 11 Jun 2024 12:04:12 +0700 Subject: import purchase order v2 --- import_purchase_order_v2.ktr | 3224 ++++++++++++++++++++++++++++++++++++++++++ run_single_ktr.sh | 2 +- 2 files changed, 3225 insertions(+), 1 deletion(-) create mode 100644 import_purchase_order_v2.ktr diff --git a/import_purchase_order_v2.ktr b/import_purchase_order_v2.ktr new file mode 100644 index 0000000..b8edaf5 --- /dev/null +++ b/import_purchase_order_v2.ktr @@ -0,0 +1,3224 @@ + + + + import_purchase_order_v2 + + + + Normal + / + + + + + + + + + + + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + TRANSNAME + Y + TRANSNAME + + + STATUS + Y + STATUS + + + LINES_READ + Y + LINES_READ + + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + + LINES_UPDATED + Y + LINES_UPDATED + + + + LINES_INPUT + Y + LINES_INPUT + + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + + LINES_REJECTED + Y + LINES_REJECTED + + + + ERRORS + Y + ERRORS + + + STARTDATE + Y + STARTDATE + + + ENDDATE + Y + ENDDATE + + + LOGDATE + Y + LOGDATE + + + DEPDATE + Y + DEPDATE + + + REPLAYDATE + Y + REPLAYDATE + + + LOG_FIELD + Y + LOG_FIELD + + + EXECUTING_SERVER + N + EXECUTING_SERVER + + + EXECUTING_USER + N + EXECUTING_USER + + + CLIENT + N + CLIENT + + + + + +
+ + + + ID_BATCH + Y + ID_BATCH + + + SEQ_NR + Y + SEQ_NR + + + LOGDATE + Y + LOGDATE + + + TRANSNAME + Y + TRANSNAME + + + STEPNAME + Y + STEPNAME + + + STEP_COPY + Y + STEP_COPY + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + INPUT_BUFFER_ROWS + Y + INPUT_BUFFER_ROWS + + + OUTPUT_BUFFER_ROWS + Y + OUTPUT_BUFFER_ROWS + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + LOGGING_OBJECT_TYPE + Y + LOGGING_OBJECT_TYPE + + + OBJECT_NAME + Y + OBJECT_NAME + + + OBJECT_COPY + Y + OBJECT_COPY + + + REPOSITORY_DIRECTORY + Y + REPOSITORY_DIRECTORY + + + FILENAME + Y + FILENAME + + + OBJECT_ID + Y + OBJECT_ID + + + OBJECT_REVISION + Y + OBJECT_REVISION + + + PARENT_CHANNEL_ID + Y + PARENT_CHANNEL_ID + + + ROOT_CHANNEL_ID + Y + ROOT_CHANNEL_ID + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + TRANSNAME + Y + TRANSNAME + + + STEPNAME + Y + STEPNAME + + + STEP_COPY + Y + STEP_COPY + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + LOG_FIELD + N + LOG_FIELD + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + METRICS_DATE + Y + METRICS_DATE + + + METRICS_CODE + Y + METRICS_CODE + + + METRICS_DESCRIPTION + Y + METRICS_DESCRIPTION + + + METRICS_SUBJECT + Y + METRICS_SUBJECT + + + METRICS_TYPE + Y + METRICS_TYPE + + + METRICS_VALUE + Y + METRICS_VALUE + + + + + +
+ + 0.0 + 0.0 + + 10000 + 50 + 50 + N + Y + 50000 + Y + + N + 1000 + 100 + + + + + + + + + - + 2024/06/11 11:58:56.696 + - + 2024/06/11 11:58:56.696 + + N + + + + + dw bi indoteknik (localhost) + localhost + POSTGRESQL + Native + dw_bi_indoteknik + 5432 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5432 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + + + + + erp indoteknik production (localhost) + 10.148.0.3 + POSTGRESQL + Native + erp_indoteknik + 5432 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5432 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + N + + + USE_POOLING + N + + + + + + Table input + Insert / update + Y + + + Table input 2 + Insert / update 2 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select * from purchase_order + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + Table input + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + access_token + 2147483647 + -1 + Table input + access_token + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + name + 2147483647 + -1 + Table input + name + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + priority + 2147483647 + -1 + Table input + priority + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + origin + 2147483647 + -1 + Table input + origin + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + partner_ref + 2147483647 + -1 + Table input + partner_ref + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + date_order + 6 + -1 + Table input + date_order + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + date_approve + 6 + -1 + Table input + date_approve + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + partner_id + 9 + 0 + Table input + partner_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + dest_address_id + 9 + 0 + Table input + dest_address_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + currency_id + 9 + 0 + Table input + currency_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + state + 2147483647 + -1 + Table input + state + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + notes + 2147483647 + -1 + Table input + notes + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + invoice_count + 9 + 0 + Table input + invoice_count + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + invoice_status + 2147483647 + -1 + Table input + invoice_status + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + date_planned + 6 + -1 + Table input + date_planned + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + date_calendar_start + 6 + -1 + Table input + date_calendar_start + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + amount_untaxed + -1 + -1 + Table input + amount_untaxed + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + amount_tax + -1 + -1 + Table input + amount_tax + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + amount_total + -1 + -1 + Table input + amount_total + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + fiscal_position_id + 9 + 0 + Table input + fiscal_position_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + payment_term_id + 9 + 0 + Table input + payment_term_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + incoterm_id + 9 + 0 + Table input + incoterm_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + user_id + 9 + 0 + Table input + user_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + company_id + 9 + 0 + Table input + company_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + currency_rate + -1 + -1 + Table input + currency_rate + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + mail_reminder_confirmed + -1 + -1 + Table input + mail_reminder_confirmed + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + mail_reception_confirmed + -1 + -1 + Table input + mail_reception_confirmed + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + message_main_attachment_id + 9 + 0 + Table input + message_main_attachment_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + create_uid + 9 + 0 + Table input + create_uid + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + create_date + 6 + -1 + Table input + create_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + write_uid + 9 + 0 + Table input + write_uid + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + write_date + 6 + -1 + Table input + write_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + picking_count + 9 + 0 + Table input + picking_count + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + picking_type_id + 9 + 0 + Table input + picking_type_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + group_id + 9 + 0 + Table input + group_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + effective_date + 6 + -1 + Table input + effective_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + sale_order_id + 9 + 0 + Table input + sale_order_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + approval_status + 2147483647 + -1 + Table input + approval_status + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + po_status + 2147483647 + -1 + Table input + po_status + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + note_description + 2147483647 + -1 + Table input + note_description + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + description + 2147483647 + -1 + Table input + description + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + status_paid_cbd + -1 + -1 + Table input + status_paid_cbd + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + revisi_po + -1 + -1 + Table input + revisi_po + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + from_apo + -1 + -1 + Table input + from_apo + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + approval_edit_line + -1 + -1 + Table input + approval_edit_line + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + sale_order + 2147483647 + -1 + Table input + sale_order + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 368 + 96 + Y + + + + Table input 2 + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select * from purchase_order_line + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + Table input 2 + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + name + 2147483647 + -1 + Table input 2 + name + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + sequence + 9 + 0 + Table input 2 + sequence + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + product_qty + -1 + -1 + Table input 2 + product_qty + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + product_uom_qty + -1 + -1 + Table input 2 + product_uom_qty + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + date_planned + 6 + -1 + Table input 2 + date_planned + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + product_uom + 9 + 0 + Table input 2 + product_uom + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + product_id + 9 + 0 + Table input 2 + product_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + price_unit + -1 + -1 + Table input 2 + price_unit + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + price_subtotal + -1 + -1 + Table input 2 + price_subtotal + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + price_total + -1 + -1 + Table input 2 + price_total + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + price_tax + -1 + -1 + Table input 2 + price_tax + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + order_id + 9 + 0 + Table input 2 + order_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + account_analytic_id + 9 + 0 + Table input 2 + account_analytic_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + company_id + 9 + 0 + Table input 2 + company_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + state + 2147483647 + -1 + Table input 2 + state + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + qty_invoiced + -1 + -1 + Table input 2 + qty_invoiced + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + qty_received_method + 2147483647 + -1 + Table input 2 + qty_received_method + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + qty_received + -1 + -1 + Table input 2 + qty_received + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + qty_received_manual + -1 + -1 + Table input 2 + qty_received_manual + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + qty_to_invoice + -1 + -1 + Table input 2 + qty_to_invoice + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + partner_id + 9 + 0 + Table input 2 + partner_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + currency_id + 9 + 0 + Table input 2 + currency_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + display_type + 2147483647 + -1 + Table input 2 + display_type + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + create_uid + 9 + 0 + Table input 2 + create_uid + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + create_date + 6 + -1 + Table input 2 + create_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + write_uid + 9 + 0 + Table input 2 + write_uid + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + write_date + 6 + -1 + Table input 2 + write_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + orderpoint_id + 9 + 0 + Table input 2 + orderpoint_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + product_description_variants + 2147483647 + -1 + Table input 2 + product_description_variants + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + propagate_cancel + -1 + -1 + Table input 2 + propagate_cancel + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + sale_order_id + 9 + 0 + Table input 2 + sale_order_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + sale_line_id + 9 + 0 + Table input 2 + sale_line_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + line_no + 9 + 0 + Table input 2 + line_no + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + qty_available_store + -1 + -1 + Table input 2 + qty_available_store + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + suggest + 2147483647 + -1 + Table input 2 + suggest + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + so_line_id + 9 + 0 + Table input 2 + so_line_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + indent + -1 + -1 + Table input 2 + indent + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + note + 2147483647 + -1 + Table input 2 + note + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_ltc + -1 + -1 + Table input 2 + is_ltc + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + delete_line + -1 + -1 + Table input 2 + delete_line + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + sale_automatic_id + 9 + 0 + Table input 2 + sale_automatic_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + so_id + 9 + 0 + Table input 2 + so_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 368 + 224 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public +
purchase_order
+ + id + id + = + + + + id + id + N + + + access_token + access_token + Y + + + name + name + Y + + + priority + priority + Y + + + origin + origin + Y + + + partner_ref + partner_ref + Y + + + date_order + date_order + Y + + + date_approve + date_approve + Y + + + partner_id + partner_id + Y + + + dest_address_id + dest_address_id + Y + + + currency_id + currency_id + Y + + + state + state + Y + + + notes + notes + Y + + + invoice_count + invoice_count + Y + + + invoice_status + invoice_status + Y + + + date_planned + date_planned + Y + + + date_calendar_start + date_calendar_start + Y + + + amount_untaxed + amount_untaxed + Y + + + amount_tax + amount_tax + Y + + + amount_total + amount_total + Y + + + fiscal_position_id + fiscal_position_id + Y + + + payment_term_id + payment_term_id + Y + + + incoterm_id + incoterm_id + Y + + + user_id + user_id + Y + + + company_id + company_id + Y + + + currency_rate + currency_rate + Y + + + mail_reminder_confirmed + mail_reminder_confirmed + Y + + + mail_reception_confirmed + mail_reception_confirmed + Y + + + message_main_attachment_id + message_main_attachment_id + Y + + + create_uid + create_uid + Y + + + create_date + create_date + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + picking_count + picking_count + Y + + + picking_type_id + picking_type_id + Y + + + group_id + group_id + Y + + + effective_date + effective_date + Y + + + sale_order_id + sale_order_id + Y + + + approval_status + approval_status + Y + + + po_status + po_status + Y + + + note_description + note_description + Y + + + description + description + Y + + + status_paid_cbd + status_paid_cbd + Y + + + revisi_po + revisi_po + Y + + + from_apo + from_apo + Y + + + approval_edit_line + approval_edit_line + Y + + + sale_order + sale_order + Y + + + + + + + + + + + + 560 + 96 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + purchase_order_line
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + sequence + sequence + Y + + + product_qty + product_qty + Y + + + product_uom_qty + product_uom_qty + Y + + + date_planned + date_planned + Y + + + product_uom + product_uom + Y + + + product_id + product_id + Y + + + price_unit + price_unit + Y + + + price_subtotal + price_subtotal + Y + + + price_total + price_total + Y + + + price_tax + price_tax + Y + + + order_id + order_id + Y + + + account_analytic_id + account_analytic_id + Y + + + company_id + company_id + Y + + + state + state + Y + + + qty_invoiced + qty_invoiced + Y + + + qty_received_method + qty_received_method + Y + + + qty_received + qty_received + Y + + + qty_received_manual + qty_received_manual + Y + + + qty_to_invoice + qty_to_invoice + Y + + + partner_id + partner_id + Y + + + currency_id + currency_id + Y + + + display_type + display_type + Y + + + create_uid + create_uid + Y + + + create_date + create_date + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + orderpoint_id + orderpoint_id + Y + + + product_description_variants + product_description_variants + Y + + + propagate_cancel + propagate_cancel + Y + + + sale_order_id + sale_order_id + Y + + + sale_line_id + sale_line_id + Y + + + line_no + line_no + Y + + + qty_available_store + qty_available_store + Y + + + suggest + suggest + Y + + + so_line_id + so_line_id + Y + + + indent + indent + Y + + + note + note + Y + + + is_ltc + is_ltc + Y + + + delete_line + delete_line + Y + + + sale_automatic_id + sale_automatic_id + Y + + + so_id + so_id + Y + + + + + + + + + + + + 560 + 224 + Y + + + + + + + N + + diff --git a/run_single_ktr.sh b/run_single_ktr.sh index 2321d19..9832952 100644 --- a/run_single_ktr.sh +++ b/run_single_ktr.sh @@ -1 +1 @@ -sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/import_link_po_to_inv.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" +sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/import_purchase_order_v2.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" -- cgit v1.2.3