From 433ed2628501e15ecf01a7df0971ffacb9cea957 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Fri, 12 Jul 2024 09:50:32 +0700 Subject: add import sale order v2 --- import_sale_order_v2.ktr | 4876 ++++++++++++++++++++++++++++++++++++++++++++++ import_utm_source.ktr | 655 +++++++ 2 files changed, 5531 insertions(+) create mode 100644 import_sale_order_v2.ktr create mode 100644 import_utm_source.ktr diff --git a/import_sale_order_v2.ktr b/import_sale_order_v2.ktr new file mode 100644 index 0000000..1a58ca1 --- /dev/null +++ b/import_sale_order_v2.ktr @@ -0,0 +1,4876 @@ + + + + import_sale_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/07/12 09:41:32.846 + - + 2024/07/12 09:41:32.846 + + 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 sale_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 + name + 2147483647 + -1 + Table input + name + + . + , + + 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 + client_order_ref + 2147483647 + -1 + Table input + client_order_ref + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + reference + 2147483647 + -1 + Table input + reference + + . + , + + 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 + + + Timestamp + normal + date_order + 6 + -1 + Table input + date_order + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Date + normal + validity_date + -1 + -1 + Table input + validity_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + require_signature + -1 + -1 + Table input + require_signature + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + require_payment + -1 + -1 + Table input + require_payment + + . + , + + 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 + user_id + 9 + 0 + Table input + user_id + ####0;-####0 + . + , + + 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 + partner_invoice_id + 9 + 0 + Table input + partner_invoice_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + partner_shipping_id + 9 + 0 + Table input + partner_shipping_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + pricelist_id + 9 + 0 + Table input + pricelist_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 + + + Integer + normal + analytic_account_id + 9 + 0 + Table input + analytic_account_id + ####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 + + + String + normal + note + 2147483647 + -1 + Table input + note + + . + , + + 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 + + + BigNumber + 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 + + + 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 + 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 + company_id + 9 + 0 + Table input + company_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + team_id + 9 + 0 + Table input + team_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + signed_by + 2147483647 + -1 + Table input + signed_by + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + signed_on + 6 + -1 + Table input + signed_on + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + commitment_date + 6 + -1 + Table input + commitment_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + show_update_pricelist + -1 + -1 + Table input + show_update_pricelist + + . + , + + 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 + + + Integer + normal + campaign_id + 9 + 0 + Table input + campaign_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + source_id + 9 + 0 + Table input + source_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + medium_id + 9 + 0 + Table input + medium_id + ####0;-####0 + . + , + + 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 + + + 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 + sale_order_template_id + 9 + 0 + Table input + sale_order_template_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + incoterm + 9 + 0 + Table input + incoterm + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + picking_policy + 2147483647 + -1 + Table input + picking_policy + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + warehouse_id + 9 + 0 + Table input + warehouse_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + procurement_group_id + 9 + 0 + Table input + procurement_group_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Date + normal + effective_date + -1 + -1 + Table input + effective_date + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + has_due + -1 + -1 + Table input + has_due + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_warning + -1 + -1 + Table input + is_warning + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + cart_recovery_email_sent + -1 + -1 + Table input + cart_recovery_email_sent + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + website_id + 9 + 0 + Table input + website_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + warning_stock + 2147483647 + -1 + Table input + warning_stock + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + opportunity_id + 9 + 0 + Table input + opportunity_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + code_promo_program_id + 9 + 0 + Table input + code_promo_program_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + project_id + 9 + 0 + Table input + project_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + carrier_id + 9 + 0 + Table input + carrier_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + delivery_message + 2147483647 + -1 + Table input + delivery_message + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + delivery_rating_success + -1 + -1 + Table input + delivery_rating_success + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + recompute_delivery_price + -1 + -1 + Table input + recompute_delivery_price + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + amount_delivery + -1 + -1 + Table input + amount_delivery + ######0.0###################;-######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 + + + Number + normal + delivery_amt + -1 + -1 + Table input + delivery_amt + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + shipping_cost_covered + 2147483647 + -1 + Table input + shipping_cost_covered + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + shipping_paid_by + 2147483647 + -1 + Table input + shipping_paid_by + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + sales_tax_id + 9 + 0 + Table input + sales_tax_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + real_shipping_id + 9 + 0 + Table input + real_shipping_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + fee_third_party + -1 + -1 + Table input + fee_third_party + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + so_status + 2147483647 + -1 + Table input + so_status + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + partner_purchase_order_name + 2147483647 + -1 + Table input + partner_purchase_order_name + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + partner_purchase_order_description + 2147483647 + -1 + Table input + partner_purchase_order_description + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + payment_status + 2147483647 + -1 + Table input + payment_status + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Timestamp + normal + date_doc_kirim + 6 + -1 + Table input + date_doc_kirim + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + payment_type + 2147483647 + -1 + Table input + payment_type + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + gross_amount + -1 + -1 + Table input + gross_amount + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + notification + 2147483647 + -1 + Table input + notification + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + delivery_service_type + 2147483647 + -1 + Table input + delivery_service_type + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + payment_link_midtrans + 2147483647 + -1 + Table input + payment_link_midtrans + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + due_id + 9 + 0 + Table input + due_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + customer_type + 2147483647 + -1 + Table input + customer_type + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + sppkp + 2147483647 + -1 + Table input + sppkp + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + npwp + 2147483647 + -1 + Table input + npwp + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + voucher_id + 9 + 0 + Table input + voucher_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + amount_voucher_disc + -1 + -1 + Table input + amount_voucher_disc + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + estimated_arrival_days + 9 + 0 + Table input + estimated_arrival_days + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + applied_voucher_id + 9 + 0 + Table input + applied_voucher_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + email + 2147483647 + -1 + Table input + email + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + picking_iu_id + 9 + 0 + Table input + picking_iu_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + helper_by_id + 9 + 0 + Table input + helper_by_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + print_image + -1 + -1 + Table input + print_image + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + image_sizes + 2147483647 + -1 + Table input + image_sizes + + . + , + + none + N + Y + 0 + N + N + N + en_ID + 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_ID + Asia/Bangkok + N + + + String + normal + web_approval + 2147483647 + -1 + Table input + web_approval + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + note_ekspedisi + 2147483647 + -1 + Table input + note_ekspedisi + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + flash_sale + -1 + -1 + Table input + flash_sale + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + note_website + 2147483647 + -1 + Table input + note_website + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 176 + 112 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public +
t_sale_order
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + origin + origin + Y + + + client_order_ref + client_order_ref + Y + + + reference + reference + Y + + + state + state + Y + + + date_order + date_order + Y + + + validity_date + validity_date + Y + + + require_signature + require_signature + Y + + + require_payment + require_payment + Y + + + create_date + create_date + Y + + + user_id + user_id + Y + + + partner_id + partner_id + Y + + + partner_invoice_id + partner_invoice_id + Y + + + partner_shipping_id + partner_shipping_id + Y + + + pricelist_id + pricelist_id + Y + + + currency_id + currency_id + Y + + + analytic_account_id + analytic_account_id + Y + + + invoice_status + invoice_status + Y + + + note + note + Y + + + amount_untaxed + amount_untaxed + Y + + + amount_tax + amount_tax + Y + + + amount_total + amount_total + Y + + + currency_rate + currency_rate + Y + + + payment_term_id + payment_term_id + Y + + + fiscal_position_id + fiscal_position_id + Y + + + company_id + company_id + Y + + + team_id + team_id + Y + + + signed_by + signed_by + Y + + + signed_on + signed_on + Y + + + commitment_date + commitment_date + Y + + + show_update_pricelist + show_update_pricelist + Y + + + access_token + access_token + Y + + + campaign_id + campaign_id + Y + + + source_id + source_id + Y + + + medium_id + medium_id + Y + + + message_main_attachment_id + message_main_attachment_id + Y + + + create_uid + create_uid + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + sale_order_template_id + sale_order_template_id + Y + + + incoterm + incoterm + Y + + + picking_policy + picking_policy + Y + + + warehouse_id + warehouse_id + Y + + + procurement_group_id + procurement_group_id + Y + + + effective_date + effective_date + Y + + + has_due + has_due + Y + + + is_warning + is_warning + Y + + + cart_recovery_email_sent + cart_recovery_email_sent + Y + + + website_id + website_id + Y + + + warning_stock + warning_stock + Y + + + opportunity_id + opportunity_id + Y + + + code_promo_program_id + code_promo_program_id + Y + + + project_id + project_id + Y + + + carrier_id + carrier_id + Y + + + delivery_message + delivery_message + Y + + + delivery_rating_success + delivery_rating_success + Y + + + recompute_delivery_price + recompute_delivery_price + Y + + + amount_delivery + amount_delivery + Y + + + approval_status + approval_status + Y + + + delivery_amt + delivery_amt + Y + + + shipping_cost_covered + shipping_cost_covered + Y + + + shipping_paid_by + shipping_paid_by + Y + + + sales_tax_id + sales_tax_id + Y + + + real_shipping_id + real_shipping_id + Y + + + fee_third_party + fee_third_party + Y + + + so_status + so_status + Y + + + partner_purchase_order_name + partner_purchase_order_name + Y + + + partner_purchase_order_description + partner_purchase_order_description + Y + + + payment_status + payment_status + Y + + + date_doc_kirim + date_doc_kirim + Y + + + payment_type + payment_type + Y + + + gross_amount + gross_amount + Y + + + notification + notification + Y + + + delivery_service_type + delivery_service_type + Y + + + payment_link_midtrans + payment_link_midtrans + Y + + + due_id + due_id + Y + + + customer_type + customer_type + Y + + + sppkp + sppkp + Y + + + npwp + npwp + Y + + + voucher_id + voucher_id + Y + + + amount_voucher_disc + amount_voucher_disc + Y + + + estimated_arrival_days + estimated_arrival_days + Y + + + applied_voucher_id + applied_voucher_id + Y + + + email + email + Y + + + picking_iu_id + picking_iu_id + Y + + + helper_by_id + helper_by_id + Y + + + print_image + print_image + Y + + + image_sizes + image_sizes + Y + + + real_invoice_id + real_invoice_id + Y + + + web_approval + web_approval + Y + + + note_ekspedisi + note_ekspedisi + Y + + + flash_sale + flash_sale + Y + + + note_website + note_website + Y + + + + + + + + + + + + 400 + 112 + Y + + + + Table input 2 + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select * from sale_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 + + + 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 + + + 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 + + + String + normal + invoice_status + 2147483647 + -1 + Table input 2 + invoice_status + + . + , + + 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 + + + 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 + + + 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 + + + BigNumber + normal + price_reduce + -1 + -1 + Table input 2 + price_reduce + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + price_reduce_taxinc + -1 + -1 + Table input 2 + price_reduce_taxinc + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + price_reduce_taxexcl + -1 + -1 + Table input 2 + price_reduce_taxexcl + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + discount + -1 + -1 + Table input 2 + discount + ######0.0###################;-######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 + 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 + + + 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 + + + String + normal + qty_delivered_method + 2147483647 + -1 + Table input 2 + qty_delivered_method + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + qty_delivered + -1 + -1 + Table input 2 + qty_delivered + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + qty_delivered_manual + -1 + -1 + Table input 2 + qty_delivered_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 + + + 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 + + + BigNumber + normal + untaxed_amount_invoiced + -1 + -1 + Table input 2 + untaxed_amount_invoiced + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + untaxed_amount_to_invoice + -1 + -1 + Table input 2 + untaxed_amount_to_invoice + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + salesman_id + 9 + 0 + Table input 2 + salesman_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 + + + 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 + + + Integer + normal + order_partner_id + 9 + 0 + Table input 2 + order_partner_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_expense + -1 + -1 + Table input 2 + is_expense + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_downpayment + -1 + -1 + Table input 2 + is_downpayment + + . + , + + 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 + + + Number + normal + customer_lead + -1 + -1 + Table input 2 + customer_lead + ####0.0#########;-####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 + product_packaging + 9 + 0 + Table input 2 + product_packaging + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + route_id + 9 + 0 + Table input 2 + route_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + linked_line_id + 9 + 0 + Table input 2 + linked_line_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + String + normal + warning_stock + 2147483647 + -1 + Table input 2 + warning_stock + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_reward_line + -1 + -1 + Table input 2 + is_reward_line + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_service + -1 + -1 + Table input 2 + is_service + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + project_id + 9 + 0 + Table input 2 + project_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + task_id + 9 + 0 + Table input 2 + task_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Boolean + normal + is_delivery + -1 + -1 + Table input 2 + is_delivery + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + vendor_id + 9 + 0 + Table input 2 + vendor_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + BigNumber + normal + purchase_price + -1 + -1 + Table input 2 + purchase_price + ######0.0###################;-######0.0################### + . + + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + purchase_tax_id + 9 + 0 + Table input 2 + purchase_tax_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 + + + String + normal + note_procurement + 2147483647 + -1 + Table input 2 + note_procurement + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + amount_voucher_disc + -1 + -1 + Table input 2 + amount_voucher_disc + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Number + normal + initial_discount + -1 + -1 + Table input 2 + initial_discount + ####0.0#########;-####0.0######### + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + Integer + normal + order_promotion_id + 9 + 0 + Table input 2 + order_promotion_id + ####0;-####0 + . + , + + 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 + + + String + normal + reserved_from + 2147483647 + -1 + Table input 2 + reserved_from + + . + , + + none + N + Y + 0 + N + N + N + en_ID + Asia/Bangkok + N + + + + + + + + + + + + 176 + 240 + Y + + + + Insert / update 2 + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + t_sale_order_line
+ + id + id + = + + + + id + id + N + + + order_id + order_id + Y + + + name + name + Y + + + sequence + sequence + Y + + + invoice_status + invoice_status + Y + + + price_unit + price_unit + Y + + + price_subtotal + price_subtotal + Y + + + price_tax + price_tax + Y + + + price_total + price_total + Y + + + price_reduce + price_reduce + Y + + + price_reduce_taxinc + price_reduce_taxinc + Y + + + price_reduce_taxexcl + price_reduce_taxexcl + Y + + + discount + discount + Y + + + product_id + product_id + Y + + + product_uom_qty + product_uom_qty + Y + + + product_uom + product_uom + Y + + + qty_delivered_method + qty_delivered_method + Y + + + qty_delivered + qty_delivered + Y + + + qty_delivered_manual + qty_delivered_manual + Y + + + qty_to_invoice + qty_to_invoice + Y + + + qty_invoiced + qty_invoiced + Y + + + untaxed_amount_invoiced + untaxed_amount_invoiced + Y + + + untaxed_amount_to_invoice + untaxed_amount_to_invoice + Y + + + salesman_id + salesman_id + Y + + + currency_id + currency_id + Y + + + company_id + company_id + Y + + + order_partner_id + order_partner_id + Y + + + is_expense + is_expense + Y + + + is_downpayment + is_downpayment + Y + + + state + state + Y + + + customer_lead + customer_lead + 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 + + + product_packaging + product_packaging + Y + + + route_id + route_id + Y + + + linked_line_id + linked_line_id + Y + + + warning_stock + warning_stock + Y + + + is_reward_line + is_reward_line + Y + + + is_service + is_service + Y + + + project_id + project_id + Y + + + task_id + task_id + Y + + + is_delivery + is_delivery + Y + + + vendor_id + vendor_id + Y + + + purchase_price + purchase_price + Y + + + purchase_tax_id + purchase_tax_id + Y + + + line_no + line_no + Y + + + note_procurement + note_procurement + Y + + + amount_voucher_disc + amount_voucher_disc + Y + + + initial_discount + initial_discount + Y + + + order_promotion_id + order_promotion_id + Y + + + note + note + Y + + + reserved_from + reserved_from + Y + + + + + + + + + + + + 400 + 240 + Y + + + + + + + N + + diff --git a/import_utm_source.ktr b/import_utm_source.ktr new file mode 100644 index 0000000..54d950c --- /dev/null +++ b/import_utm_source.ktr @@ -0,0 +1,655 @@ + + + + import_utm_source + + + + 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/07/12 09:38:15.870 + - + 2024/07/12 09:38:15.870 + + N + + + + + dw bi indoteknik + localhost + POSTGRESQL + Native + dw_bi_indoteknik + 5703 + metabase + Encrypted 2be98dfba28d7bf86853c9f58cfc4f889 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5703 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + Y + + + USE_POOLING + N + + + + + erp indoteknik production + localhost + POSTGRESQL + Native + erp_indoteknik + 5901 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5901 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + Y + + + USE_POOLING + N + + + + + + Table input + Insert / update + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik production + select * from utm_source + 0 + + N + N + N + N + + + + + + + + + + + 208 + 112 + Y + + + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik + 100 + N + + public +
utm_source
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + create_uid + create_uid + Y + + + create_date + create_date + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + + + + + + + + + + 368 + 112 + Y + + + + + + + N + + -- cgit v1.2.3