diff options
Diffstat (limited to 'import_odoo_14_to_data_warehouse_manual.ktr')
| -rw-r--r-- | import_odoo_14_to_data_warehouse_manual.ktr | 83 |
1 files changed, 41 insertions, 42 deletions
diff --git a/import_odoo_14_to_data_warehouse_manual.ktr b/import_odoo_14_to_data_warehouse_manual.ktr index 4800250..debbe66 100644 --- a/import_odoo_14_to_data_warehouse_manual.ktr +++ b/import_odoo_14_to_data_warehouse_manual.ktr @@ -750,31 +750,7 @@ LEFT JOIN brand mf ON mf.id = p.brand_id LEFT JOIN res_partner_industry i ON i.id = rp.industry_id WHERE m.move_type::text = 'out_invoice'::text AND m.state::text = 'posted'::text - --AND ml.write_date >= (now() - '15 days'::interval) - and m.name in( - 'INV/2023/10/0343', -'INV/2023/10/0358', -'INV/2023/12/0166', -'INV/2023/10/0348', -'INV/2023/10/0344', -'INV/2023/03/0177', -'INV/2023/08/0347', -'INV/2023/10/0328', -'INV/2023/08/0591', -'INV/2023/05/0083', -'INV/2023/10/0346', -'INV/2023/10/0071', -'INV/2023/10/0347', -'INV/2023/12/0425', -'INV/2023/08/0059', -'INV/2023/10/0360', -'INV/2023/10/0329', -'INV/2023/03/0178', -'INV/2023/10/0359', -'INV/2023/10/0276', -'INV/2023/10/0345', -'INV/2023/12/0299' - )</sql> + --AND ml.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -801,7 +777,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -824,7 +800,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -847,7 +823,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -870,7 +846,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -893,7 +869,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -916,7 +892,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -939,7 +915,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -962,7 +938,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -985,7 +961,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1008,7 +984,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1031,7 +1007,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1054,7 +1030,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1077,7 +1053,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1100,7 +1076,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1123,7 +1099,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1146,7 +1122,7 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> @@ -1169,7 +1145,30 @@ <sort_descending>N</sort_descending> <output_padding>N</output_padding> <date_format_lenient>N</date_format_lenient> - <date_format_locale>en_US</date_format_locale> + <date_format_locale>en_ID</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>account_move_line_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>account_move_line_id</comments> + <conversion_Mask>####0;-####0</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_ID</date_format_locale> <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> |