diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-10-09 14:36:54 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-10-09 14:36:54 +0700 |
| commit | 80fb1114ef4f21af51e7c245f5ebd34e630d8a15 (patch) | |
| tree | f668c4f53c19858b45d8c65874e146b9c8ecc20c /import_account_move.ktr | |
| parent | 4c611d9dca3e1b5aca4d5475885373839db6b14e (diff) | |
import account move
Diffstat (limited to 'import_account_move.ktr')
| -rw-r--r-- | import_account_move.ktr | 910 |
1 files changed, 455 insertions, 455 deletions
diff --git a/import_account_move.ktr b/import_account_move.ktr index 040990d..68db24c 100644 --- a/import_account_move.ktr +++ b/import_account_move.ktr @@ -430,7 +430,7 @@ <created_date>2023/09/25 16:36:39.046</created_date> <modified_user>-</modified_user> <modified_date>2023/09/25 16:36:39.046</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -545,6 +545,459 @@ </hop> </order> <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>account_move</table> + <key> + <name>id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>id</name> + <rename>id</rename> + <update>N</update> + </value> + <value> + <name>name</name> + <rename>name</rename> + <update>Y</update> + </value> + <value> + <name>date</name> + <rename>date</rename> + <update>Y</update> + </value> + <value> + <name>ref</name> + <rename>ref</rename> + <update>Y</update> + </value> + <value> + <name>narration</name> + <rename>narration</rename> + <update>Y</update> + </value> + <value> + <name>state</name> + <rename>state</rename> + <update>Y</update> + </value> + <value> + <name>posted_before</name> + <rename>posted_before</rename> + <update>Y</update> + </value> + <value> + <name>move_type</name> + <rename>move_type</rename> + <update>Y</update> + </value> + <value> + <name>to_check</name> + <rename>to_check</rename> + <update>Y</update> + </value> + <value> + <name>journal_id</name> + <rename>journal_id</rename> + <update>Y</update> + </value> + <value> + <name>company_id</name> + <rename>company_id</rename> + <update>Y</update> + </value> + <value> + <name>currency_id</name> + <rename>currency_id</rename> + <update>Y</update> + </value> + <value> + <name>partner_id</name> + <rename>partner_id</rename> + <update>Y</update> + </value> + <value> + <name>commercial_partner_id</name> + <rename>commercial_partner_id</rename> + <update>Y</update> + </value> + <value> + <name>is_move_sent</name> + <rename>is_move_sent</rename> + <update>Y</update> + </value> + <value> + <name>partner_bank_id</name> + <rename>partner_bank_id</rename> + <update>Y</update> + </value> + <value> + <name>payment_reference</name> + <rename>payment_reference</rename> + <update>Y</update> + </value> + <value> + <name>payment_id</name> + <rename>payment_id</rename> + <update>Y</update> + </value> + <value> + <name>statement_line_id</name> + <rename>statement_line_id</rename> + <update>Y</update> + </value> + <value> + <name>amount_untaxed</name> + <rename>amount_untaxed</rename> + <update>Y</update> + </value> + <value> + <name>amount_tax</name> + <rename>amount_tax</rename> + <update>Y</update> + </value> + <value> + <name>amount_total</name> + <rename>amount_total</rename> + <update>Y</update> + </value> + <value> + <name>amount_residual</name> + <rename>amount_residual</rename> + <update>Y</update> + </value> + <value> + <name>amount_untaxed_signed</name> + <rename>amount_untaxed_signed</rename> + <update>Y</update> + </value> + <value> + <name>amount_tax_signed</name> + <rename>amount_tax_signed</rename> + <update>Y</update> + </value> + <value> + <name>amount_total_signed</name> + <rename>amount_total_signed</rename> + <update>Y</update> + </value> + <value> + <name>amount_residual_signed</name> + <rename>amount_residual_signed</rename> + <update>Y</update> + </value> + <value> + <name>payment_state</name> + <rename>payment_state</rename> + <update>Y</update> + </value> + <value> + <name>tax_cash_basis_rec_id</name> + <rename>tax_cash_basis_rec_id</rename> + <update>Y</update> + </value> + <value> + <name>tax_cash_basis_move_id</name> + <rename>tax_cash_basis_move_id</rename> + <update>Y</update> + </value> + <value> + <name>auto_post</name> + <rename>auto_post</rename> + <update>Y</update> + </value> + <value> + <name>reversed_entry_id</name> + <rename>reversed_entry_id</rename> + <update>Y</update> + </value> + <value> + <name>fiscal_position_id</name> + <rename>fiscal_position_id</rename> + <update>Y</update> + </value> + <value> + <name>invoice_user_id</name> + <rename>invoice_user_id</rename> + <update>Y</update> + </value> + <value> + <name>invoice_date</name> + <rename>invoice_date</rename> + <update>Y</update> + </value> + <value> + <name>invoice_date_due</name> + <rename>invoice_date_due</rename> + <update>Y</update> + </value> + <value> + <name>invoice_origin</name> + <rename>invoice_origin</rename> + <update>Y</update> + </value> + <value> + <name>invoice_payment_term_id</name> + <rename>invoice_payment_term_id</rename> + <update>Y</update> + </value> + <value> + <name>invoice_incoterm_id</name> + <rename>invoice_incoterm_id</rename> + <update>Y</update> + </value> + <value> + <name>qr_code_method</name> + <rename>qr_code_method</rename> + <update>Y</update> + </value> + <value> + <name>invoice_source_email</name> + <rename>invoice_source_email</rename> + <update>Y</update> + </value> + <value> + <name>invoice_partner_display_name</name> + <rename>invoice_partner_display_name</rename> + <update>Y</update> + </value> + <value> + <name>invoice_cash_rounding_id</name> + <rename>invoice_cash_rounding_id</rename> + <update>Y</update> + </value> + <value> + <name>secure_sequence_number</name> + <rename>secure_sequence_number</rename> + <update>Y</update> + </value> + <value> + <name>inalterable_hash</name> + <rename>inalterable_hash</rename> + <update>Y</update> + </value> + <value> + <name>access_token</name> + <rename>access_token</rename> + <update>Y</update> + </value> + <value> + <name>message_main_attachment_id</name> + <rename>message_main_attachment_id</rename> + <update>Y</update> + </value> + <value> + <name>sequence_prefix</name> + <rename>sequence_prefix</rename> + <update>Y</update> + </value> + <value> + <name>sequence_number</name> + <rename>sequence_number</rename> + <update>Y</update> + </value> + <value> + <name>create_uid</name> + <rename>create_uid</rename> + <update>Y</update> + </value> + <value> + <name>create_date</name> + <rename>create_date</rename> + <update>Y</update> + </value> + <value> + <name>write_uid</name> + <rename>write_uid</rename> + <update>Y</update> + </value> + <value> + <name>write_date</name> + <rename>write_date</rename> + <update>Y</update> + </value> + <value> + <name>edi_state</name> + <rename>edi_state</rename> + <update>Y</update> + </value> + <value> + <name>stock_move_id</name> + <rename>stock_move_id</rename> + <update>Y</update> + </value> + <value> + <name>team_id</name> + <rename>team_id</rename> + <update>Y</update> + </value> + <value> + <name>partner_shipping_id</name> + <rename>partner_shipping_id</rename> + <update>Y</update> + </value> + <value> + <name>campaign_id</name> + <rename>campaign_id</rename> + <update>Y</update> + </value> + <value> + <name>source_id</name> + <rename>source_id</rename> + <update>Y</update> + </value> + <value> + <name>medium_id</name> + <rename>medium_id</rename> + <update>Y</update> + </value> + <value> + <name>preferred_payment_method_id</name> + <rename>preferred_payment_method_id</rename> + <update>Y</update> + </value> + <value> + <name>has_due</name> + <rename>has_due</rename> + <update>Y</update> + </value> + <value> + <name>is_warning</name> + <rename>is_warning</rename> + <update>Y</update> + </value> + <value> + <name>recurring_ref</name> + <rename>recurring_ref</rename> + <update>Y</update> + </value> + <value> + <name>website_id</name> + <rename>website_id</rename> + <update>Y</update> + </value> + <value> + <name>efaktur_id</name> + <rename>efaktur_id</rename> + <update>Y</update> + </value> + <value> + <name>is_efaktur_exported</name> + <rename>is_efaktur_exported</rename> + <update>Y</update> + </value> + <value> + <name>date_efaktur_exported</name> + <rename>date_efaktur_exported</rename> + <update>Y</update> + </value> + <value> + <name>masa_pajak</name> + <rename>masa_pajak</rename> + <update>Y</update> + </value> + <value> + <name>tahun_pajak</name> + <rename>tahun_pajak</rename> + <update>Y</update> + </value> + <value> + <name>efaktur_masukan</name> + <rename>efaktur_masukan</rename> + <update>Y</update> + </value> + <value> + <name>period_id</name> + <rename>period_id</rename> + <update>Y</update> + </value> + <value> + <name>date_send_fp</name> + <rename>date_send_fp</rename> + <update>Y</update> + </value> + <value> + <name>last_log_fp</name> + <rename>last_log_fp</rename> + <update>Y</update> + </value> + <value> + <name>date_kirim_tukar_faktur</name> + <rename>date_kirim_tukar_faktur</rename> + <update>Y</update> + </value> + <value> + <name>resi_tukar_faktur</name> + <rename>resi_tukar_faktur</rename> + <update>Y</update> + </value> + <value> + <name>date_terima_tukar_faktur</name> + <rename>date_terima_tukar_faktur</rename> + <update>Y</update> + </value> + <value> + <name>shipper_faktur_id</name> + <rename>shipper_faktur_id</rename> + <update>Y</update> + </value> + <value> + <name>due_extension</name> + <rename>due_extension</rename> + <update>Y</update> + </value> + <value> + <name>new_due_date</name> + <rename>new_due_date</rename> + <update>Y</update> + </value> + <value> + <name>counter</name> + <rename>counter</rename> + <update>Y</update> + </value> + <value> + <name>payment_schedule</name> + <rename>payment_schedule</rename> + <update>Y</update> + </value> + <value> + <name>cost_centre_id</name> + <rename>cost_centre_id</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>256</xloc> + <yloc>48</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -556,7 +1009,7 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from account_move where write_date >= (now() - '5 days'::interval)</sql> + <sql>select * from account_move --where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -2488,459 +2941,6 @@ <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>account_move</table> - <key> - <name>id</name> - <field>id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>id</name> - <rename>id</rename> - <update>N</update> - </value> - <value> - <name>name</name> - <rename>name</rename> - <update>Y</update> - </value> - <value> - <name>date</name> - <rename>date</rename> - <update>Y</update> - </value> - <value> - <name>ref</name> - <rename>ref</rename> - <update>Y</update> - </value> - <value> - <name>narration</name> - <rename>narration</rename> - <update>Y</update> - </value> - <value> - <name>state</name> - <rename>state</rename> - <update>Y</update> - </value> - <value> - <name>posted_before</name> - <rename>posted_before</rename> - <update>Y</update> - </value> - <value> - <name>move_type</name> - <rename>move_type</rename> - <update>Y</update> - </value> - <value> - <name>to_check</name> - <rename>to_check</rename> - <update>Y</update> - </value> - <value> - <name>journal_id</name> - <rename>journal_id</rename> - <update>Y</update> - </value> - <value> - <name>company_id</name> - <rename>company_id</rename> - <update>Y</update> - </value> - <value> - <name>currency_id</name> - <rename>currency_id</rename> - <update>Y</update> - </value> - <value> - <name>partner_id</name> - <rename>partner_id</rename> - <update>Y</update> - </value> - <value> - <name>commercial_partner_id</name> - <rename>commercial_partner_id</rename> - <update>Y</update> - </value> - <value> - <name>is_move_sent</name> - <rename>is_move_sent</rename> - <update>Y</update> - </value> - <value> - <name>partner_bank_id</name> - <rename>partner_bank_id</rename> - <update>Y</update> - </value> - <value> - <name>payment_reference</name> - <rename>payment_reference</rename> - <update>Y</update> - </value> - <value> - <name>payment_id</name> - <rename>payment_id</rename> - <update>Y</update> - </value> - <value> - <name>statement_line_id</name> - <rename>statement_line_id</rename> - <update>Y</update> - </value> - <value> - <name>amount_untaxed</name> - <rename>amount_untaxed</rename> - <update>Y</update> - </value> - <value> - <name>amount_tax</name> - <rename>amount_tax</rename> - <update>Y</update> - </value> - <value> - <name>amount_total</name> - <rename>amount_total</rename> - <update>Y</update> - </value> - <value> - <name>amount_residual</name> - <rename>amount_residual</rename> - <update>Y</update> - </value> - <value> - <name>amount_untaxed_signed</name> - <rename>amount_untaxed_signed</rename> - <update>Y</update> - </value> - <value> - <name>amount_tax_signed</name> - <rename>amount_tax_signed</rename> - <update>Y</update> - </value> - <value> - <name>amount_total_signed</name> - <rename>amount_total_signed</rename> - <update>Y</update> - </value> - <value> - <name>amount_residual_signed</name> - <rename>amount_residual_signed</rename> - <update>Y</update> - </value> - <value> - <name>payment_state</name> - <rename>payment_state</rename> - <update>Y</update> - </value> - <value> - <name>tax_cash_basis_rec_id</name> - <rename>tax_cash_basis_rec_id</rename> - <update>Y</update> - </value> - <value> - <name>tax_cash_basis_move_id</name> - <rename>tax_cash_basis_move_id</rename> - <update>Y</update> - </value> - <value> - <name>auto_post</name> - <rename>auto_post</rename> - <update>Y</update> - </value> - <value> - <name>reversed_entry_id</name> - <rename>reversed_entry_id</rename> - <update>Y</update> - </value> - <value> - <name>fiscal_position_id</name> - <rename>fiscal_position_id</rename> - <update>Y</update> - </value> - <value> - <name>invoice_user_id</name> - <rename>invoice_user_id</rename> - <update>Y</update> - </value> - <value> - <name>invoice_date</name> - <rename>invoice_date</rename> - <update>Y</update> - </value> - <value> - <name>invoice_date_due</name> - <rename>invoice_date_due</rename> - <update>Y</update> - </value> - <value> - <name>invoice_origin</name> - <rename>invoice_origin</rename> - <update>Y</update> - </value> - <value> - <name>invoice_payment_term_id</name> - <rename>invoice_payment_term_id</rename> - <update>Y</update> - </value> - <value> - <name>invoice_incoterm_id</name> - <rename>invoice_incoterm_id</rename> - <update>Y</update> - </value> - <value> - <name>qr_code_method</name> - <rename>qr_code_method</rename> - <update>Y</update> - </value> - <value> - <name>invoice_source_email</name> - <rename>invoice_source_email</rename> - <update>Y</update> - </value> - <value> - <name>invoice_partner_display_name</name> - <rename>invoice_partner_display_name</rename> - <update>Y</update> - </value> - <value> - <name>invoice_cash_rounding_id</name> - <rename>invoice_cash_rounding_id</rename> - <update>Y</update> - </value> - <value> - <name>secure_sequence_number</name> - <rename>secure_sequence_number</rename> - <update>Y</update> - </value> - <value> - <name>inalterable_hash</name> - <rename>inalterable_hash</rename> - <update>Y</update> - </value> - <value> - <name>access_token</name> - <rename>access_token</rename> - <update>Y</update> - </value> - <value> - <name>message_main_attachment_id</name> - <rename>message_main_attachment_id</rename> - <update>Y</update> - </value> - <value> - <name>sequence_prefix</name> - <rename>sequence_prefix</rename> - <update>Y</update> - </value> - <value> - <name>sequence_number</name> - <rename>sequence_number</rename> - <update>Y</update> - </value> - <value> - <name>create_uid</name> - <rename>create_uid</rename> - <update>Y</update> - </value> - <value> - <name>create_date</name> - <rename>create_date</rename> - <update>Y</update> - </value> - <value> - <name>write_uid</name> - <rename>write_uid</rename> - <update>Y</update> - </value> - <value> - <name>write_date</name> - <rename>write_date</rename> - <update>Y</update> - </value> - <value> - <name>edi_state</name> - <rename>edi_state</rename> - <update>Y</update> - </value> - <value> - <name>stock_move_id</name> - <rename>stock_move_id</rename> - <update>Y</update> - </value> - <value> - <name>team_id</name> - <rename>team_id</rename> - <update>Y</update> - </value> - <value> - <name>partner_shipping_id</name> - <rename>partner_shipping_id</rename> - <update>Y</update> - </value> - <value> - <name>campaign_id</name> - <rename>campaign_id</rename> - <update>Y</update> - </value> - <value> - <name>source_id</name> - <rename>source_id</rename> - <update>Y</update> - </value> - <value> - <name>medium_id</name> - <rename>medium_id</rename> - <update>Y</update> - </value> - <value> - <name>preferred_payment_method_id</name> - <rename>preferred_payment_method_id</rename> - <update>Y</update> - </value> - <value> - <name>has_due</name> - <rename>has_due</rename> - <update>Y</update> - </value> - <value> - <name>is_warning</name> - <rename>is_warning</rename> - <update>Y</update> - </value> - <value> - <name>recurring_ref</name> - <rename>recurring_ref</rename> - <update>Y</update> - </value> - <value> - <name>website_id</name> - <rename>website_id</rename> - <update>Y</update> - </value> - <value> - <name>efaktur_id</name> - <rename>efaktur_id</rename> - <update>Y</update> - </value> - <value> - <name>is_efaktur_exported</name> - <rename>is_efaktur_exported</rename> - <update>Y</update> - </value> - <value> - <name>date_efaktur_exported</name> - <rename>date_efaktur_exported</rename> - <update>Y</update> - </value> - <value> - <name>masa_pajak</name> - <rename>masa_pajak</rename> - <update>Y</update> - </value> - <value> - <name>tahun_pajak</name> - <rename>tahun_pajak</rename> - <update>Y</update> - </value> - <value> - <name>efaktur_masukan</name> - <rename>efaktur_masukan</rename> - <update>Y</update> - </value> - <value> - <name>period_id</name> - <rename>period_id</rename> - <update>Y</update> - </value> - <value> - <name>date_send_fp</name> - <rename>date_send_fp</rename> - <update>Y</update> - </value> - <value> - <name>last_log_fp</name> - <rename>last_log_fp</rename> - <update>Y</update> - </value> - <value> - <name>date_kirim_tukar_faktur</name> - <rename>date_kirim_tukar_faktur</rename> - <update>Y</update> - </value> - <value> - <name>resi_tukar_faktur</name> - <rename>resi_tukar_faktur</rename> - <update>Y</update> - </value> - <value> - <name>date_terima_tukar_faktur</name> - <rename>date_terima_tukar_faktur</rename> - <update>Y</update> - </value> - <value> - <name>shipper_faktur_id</name> - <rename>shipper_faktur_id</rename> - <update>Y</update> - </value> - <value> - <name>due_extension</name> - <rename>due_extension</rename> - <update>Y</update> - </value> - <value> - <name>new_due_date</name> - <rename>new_due_date</rename> - <update>Y</update> - </value> - <value> - <name>counter</name> - <rename>counter</rename> - <update>Y</update> - </value> - <value> - <name>payment_schedule</name> - <rename>payment_schedule</rename> - <update>Y</update> - </value> - <value> - <name>cost_centre_id</name> - <rename>cost_centre_id</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>256</xloc> - <yloc>48</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |
