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 pdi Encrypted 2be989bb20084ca95810197629d9ea18e 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 pdi Encrypted 2be989bb20084ca95810197629d9ea18e 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 where write_date >= (now() - '3 days'::interval) 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 where write_date >= (now() - '3 days'::interval) 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