diff options
Diffstat (limited to 'import_adempiere_to_data_warehouse.ktr')
| -rw-r--r-- | import_adempiere_to_data_warehouse.ktr | 76 |
1 files changed, 75 insertions, 1 deletions
diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr index 624192f..46f7ec7 100644 --- a/import_adempiere_to_data_warehouse.ktr +++ b/import_adempiere_to_data_warehouse.ktr @@ -1160,36 +1160,51 @@ <fields> <field> <name>customer</name> + <rename/> </field> <field> <name>invoice_date</name> + <rename/> </field> <field> <name>price_subtotal</name> + <rename/> </field> <field> <name>invoice</name> + <rename/> </field> <field> <name>quantity</name> + <rename/> </field> <field> <name>product</name> + <rename/> </field> <field> <name>brand</name> + <rename/> </field> <field> <name>salesperson</name> + <rename/> </field> <field> <name>name</name> + <rename/> </field> <field> <name>value</name> + <rename/> </field> <field> <name>odoo_partner_name</name> + <rename/> + </field> + <field> + <name>industry</name> + <rename/> </field> <select_unspecified>N</select_unspecified> <meta> @@ -1379,6 +1394,23 @@ <currency_symbol/> <storage_type/> </meta> + <meta> + <name>industry</name> + <rename>industry</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> </fields> <attributes/> <cluster_schema/> @@ -1406,7 +1438,9 @@ <schema_name/> </partitioning> <connection>erp indoteknik production</connection> - <sql>select id, name, reference_number from res_partner where reference_number is not null</sql> + <sql>select rp.id, rp.name, reference_number, rpi.name as industry from res_partner rp +left join res_partner_industry rpi on rpi.id = rp.industry_id +where reference_number is not null</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1483,6 +1517,29 @@ <date_format_timezone>Asia/Bangkok</date_format_timezone> <lenient_string_to_number>N</lenient_string_to_number> </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>industry</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>industry</comments> + <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_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> </row-meta> <attributes/> <cluster_schema/> @@ -1844,6 +1901,11 @@ <rename>odoo_partner_name</rename> <update>Y</update> </value> + <value> + <name>industry</name> + <rename>industry</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -1871,6 +1933,18 @@ <schema_name/> </partitioning> <fields> + <field> + <name>name</name> + <rename/> + </field> + <field> + <name>reference_number</name> + <rename/> + </field> + <field> + <name>industry</name> + <rename/> + </field> <select_unspecified>N</select_unspecified> <meta> <name>name</name> |