From f25eefc1afca319be51e789212ac0aff4ec5fe04 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Fri, 10 Nov 2023 14:08:46 +0700 Subject: add date reserved --- import_stock_picking.ktr | 1045 +++++++++++++++++++++++----------------------- 1 file changed, 525 insertions(+), 520 deletions(-) diff --git a/import_stock_picking.ktr b/import_stock_picking.ktr index efdd6bc..14eadfa 100644 --- a/import_stock_picking.ktr +++ b/import_stock_picking.ktr @@ -430,7 +430,7 @@ 2023/10/20 09:58:08.186 - 2023/10/20 09:58:08.186 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -544,6 +544,304 @@ Y + + Insert / update + InsertUpdate + + Y + + 1 + + none + + + dw bi indoteknik (localhost) + 100 + N + + public + stock_picking
+ + id + id + = + + + + id + id + N + + + name + name + Y + + + origin + origin + Y + + + note + note + Y + + + backorder_id + backorder_id + Y + + + move_type + move_type + Y + + + state + state + Y + + + group_id + group_id + Y + + + priority + priority + Y + + + scheduled_date + scheduled_date + Y + + + date_deadline + date_deadline + Y + + + has_deadline_issue + has_deadline_issue + Y + + + date + date + Y + + + date_done + date_done + Y + + + location_id + location_id + Y + + + location_dest_id + location_dest_id + Y + + + picking_type_id + picking_type_id + Y + + + partner_id + partner_id + Y + + + company_id + company_id + Y + + + user_id + user_id + Y + + + owner_id + owner_id + Y + + + printed + printed + Y + + + is_locked + is_locked + Y + + + immediate_transfer + immediate_transfer + 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 + + + sale_id + sale_id + Y + + + website_id + website_id + Y + + + carrier_price + carrier_price + Y + + + carrier_id + carrier_id + Y + + + weight + weight + Y + + + carrier_tracking_ref + carrier_tracking_ref + Y + + + is_internal_use + is_internal_use + Y + + + account_id + account_id + Y + + + efaktur_id + efaktur_id + Y + + + is_efaktur_exported + is_efaktur_exported + Y + + + date_efaktur_exported + date_efaktur_exported + Y + + + driver_departure_date + driver_departure_date + Y + + + driver_arrival_date + driver_arrival_date + Y + + + delivery_tracking_no + delivery_tracking_no + Y + + + driver_id + driver_id + Y + + + picking_code + picking_code + Y + + + approval_status + approval_status + Y + + + real_shipping_id + real_shipping_id + Y + + + approval_return_status + approval_return_status + Y + + + date_doc_kirim + date_doc_kirim + Y + + + note_logistic + note_logistic + Y + + + approval_receipt_status + approval_receipt_status + Y + + + date_reserved + date_reserved + Y + + + + + + + + + + + + 360 + 64 + Y + + Table input TableInput @@ -1486,242 +1784,12 @@ Timestamp - normal - driver_departure_date - 6 - -1 - Table input - driver_departure_date - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - driver_arrival_date - 6 - -1 - Table input - driver_arrival_date - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - delivery_tracking_no - 2147483647 - -1 - Table input - delivery_tracking_no - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - driver_id - 9 - 0 - Table input - driver_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - picking_code - 2147483647 - -1 - Table input - picking_code - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - approval_status - 2147483647 - -1 - Table input - approval_status - - . - , - - none - N - Y - 0 - N - N - N - en_US - 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_US - Asia/Bangkok - N - - - String - normal - approval_return_status - 2147483647 - -1 - Table input - approval_return_status - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - date_doc_kirim - 6 - -1 - Table input - date_doc_kirim - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - note_logistic - 2147483647 - -1 - Table input - note_logistic - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - approval_receipt_status - 2147483647 + normal + driver_departure_date + 6 -1 Table input - approval_receipt_status + driver_departure_date . , @@ -1737,300 +1805,237 @@ Asia/Bangkok N - - - - - - - - - - - 160 - 64 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - stock_picking
- - id - id - = - - - - id - id - N - - - name - name - Y - - - origin - origin - Y - - - note - note - Y - - - backorder_id - backorder_id - Y - - - move_type - move_type - Y - - - state - state - Y - - - group_id - group_id - Y - - - priority - priority - Y - - - scheduled_date - scheduled_date - Y - - - date_deadline - date_deadline - Y - - - has_deadline_issue - has_deadline_issue - Y - - - date - date - Y - - - date_done - date_done - Y - - - location_id - location_id - Y - - - location_dest_id - location_dest_id - Y - - - picking_type_id - picking_type_id - Y - - - partner_id - partner_id - Y - - - company_id - company_id - Y - - - user_id - user_id - Y - - - owner_id - owner_id - Y - - - printed - printed - Y - - - is_locked - is_locked - Y - - - immediate_transfer - immediate_transfer - 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 - - - sale_id - sale_id - Y - - - website_id - website_id - Y - - - carrier_price - carrier_price - Y - - - carrier_id - carrier_id - Y - - - weight - weight - Y - - - carrier_tracking_ref - carrier_tracking_ref - Y - - - is_internal_use - is_internal_use - Y - - - account_id - account_id - Y - - - efaktur_id - efaktur_id - Y - - - is_efaktur_exported - is_efaktur_exported - Y - - - date_efaktur_exported - date_efaktur_exported - Y - - - driver_departure_date - driver_departure_date - Y - - + + Timestamp + normal driver_arrival_date - driver_arrival_date - Y - - + 6 + -1 + Table input + driver_arrival_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal delivery_tracking_no - delivery_tracking_no - Y - - + 2147483647 + -1 + Table input + delivery_tracking_no + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal driver_id - driver_id - Y - - + 9 + 0 + Table input + driver_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal picking_code - picking_code - Y - - + 2147483647 + -1 + Table input + picking_code + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal approval_status - approval_status - Y - - + 2147483647 + -1 + Table input + approval_status + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal real_shipping_id - real_shipping_id - Y - - + 9 + 0 + Table input + real_shipping_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal approval_return_status - approval_return_status - Y - - + 2147483647 + -1 + Table input + approval_return_status + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal date_doc_kirim - date_doc_kirim - Y - - + 6 + -1 + Table input + date_doc_kirim + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal note_logistic - note_logistic - Y - - + 2147483647 + -1 + Table input + note_logistic + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal approval_receipt_status - approval_receipt_status - Y - - + 2147483647 + -1 + Table input + approval_receipt_status + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -2040,7 +2045,7 @@ - 360 + 160 64 Y -- cgit v1.2.3