diff options
Diffstat (limited to 'import_match_payment_invoice.ktr')
| -rw-r--r-- | import_match_payment_invoice.ktr | 164 |
1 files changed, 157 insertions, 7 deletions
diff --git a/import_match_payment_invoice.ktr b/import_match_payment_invoice.ktr index 92c59c7..11e4155 100644 --- a/import_match_payment_invoice.ktr +++ b/import_match_payment_invoice.ktr @@ -427,15 +427,66 @@ <clusterschemas> </clusterschemas> <created_user>-</created_user> - <created_date>2024/03/06 15:36:02.956</created_date> + <created_date>2024/06/07 11:20:43.357</created_date> <modified_user>-</modified_user> - <modified_date>2024/03/06 15:36:02.956</modified_date> + <modified_date>2024/06/07 11:20:43.357</modified_date> <key_for_session_key/> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> + <servername/> + <data_tablespace/> + <index_tablespace/> + <attributes> + <attribute> + <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>IS_CLUSTERED</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>PORT_NUMBER</code> + <attribute>5432</attribute> + </attribute> + <attribute> + <code>PRESERVE_RESERVED_WORD_CASE</code> + <attribute>Y</attribute> + </attribute> + <attribute> + <code>QUOTE_ALL_FIELDS</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>SUPPORTS_BOOLEAN_DATA_TYPE</code> + <attribute>Y</attribute> + </attribute> + <attribute> + <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>USE_POOLING</code> + <attribute>N</attribute> + </attribute> + </attributes> + </connection> + <connection> <name>erp indoteknik production (localhost)</name> <server>10.148.0.3</server> <type>POSTGRESQL</type> @@ -487,6 +538,11 @@ </attributes> </connection> <order> + <hop> + <from>Table input</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>Table input</name> @@ -500,15 +556,109 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from v_match_payment_invoice -order by payment_id desc ---limit 100</sql> + <sql>select * from v_match_payment_invoice</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> <variables_active>N</variables_active> <lazy_conversion_active>N</lazy_conversion_active> <cached_row_meta_active>N</cached_row_meta_active> + <row-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>payment_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>payment_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> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>invoice_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>invoice_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> + </row-meta> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>288</xloc> + <yloc>128</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>v_match_payment_invoice</table> + <key> + <name>payment_id</name> + <field>payment_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>payment_id</name> + <rename>payment_id</rename> + <update>N</update> + </value> + <value> + <name>invoice_id</name> + <rename>invoice_id</rename> + <update>Y</update> + </value> + </lookup> <attributes/> <cluster_schema/> <remotesteps> @@ -518,8 +668,8 @@ order by payment_id desc </output> </remotesteps> <GUI> - <xloc>240</xloc> - <yloc>80</yloc> + <xloc>448</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> |