From 80fb1114ef4f21af51e7c245f5ebd34e630d8a15 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 9 Oct 2023 14:36:54 +0700 Subject: import account move --- import_account_move.ktr | 3268 +++++++++++++++++++++++------------------------ 1 file changed, 1634 insertions(+), 1634 deletions(-) (limited to 'import_account_move.ktr') 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 @@ 2023/09/25 16:36:39.046 - 2023/09/25 16:36:39.046 - + H4sIAAAAAAAAAAMAAAAAAAAAAAA= N @@ -545,8 +545,8 @@ - Table input - TableInput + Insert / update + InsertUpdate Y @@ -555,1081 +555,476 @@ none - erp indoteknik production (localhost) - select * from account_move where write_date >= (now() - '5 days'::interval) - 0 - - N - N - N - N - - - Integer - normal + dw bi indoteknik (localhost) + 100 + N + + public + account_move
+ id - 9 - 0 - Table input - id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + id + = + + + + id + id + N + + name - 2147483647 - -1 - Table input - name - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Date - normal + name + Y + + date - -1 - -1 - Table input - date - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + date + Y + + ref - 2147483647 - -1 - Table input - ref - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + ref + Y + + narration - 2147483647 - -1 - Table input - narration - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + narration + Y + + state - 2147483647 - -1 - Table input - state - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Boolean - normal + state + Y + + posted_before - -1 - -1 - Table input - posted_before - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + posted_before + Y + + move_type - 2147483647 - -1 - Table input - move_type - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Boolean - normal + move_type + Y + + to_check - -1 - -1 - Table input - to_check - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + to_check + Y + + journal_id - 9 - 0 - Table input - journal_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + journal_id + Y + + company_id - 9 - 0 - Table input - company_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + company_id + Y + + currency_id - 9 - 0 - Table input - currency_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + currency_id + Y + + partner_id - 9 - 0 - Table input - partner_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + partner_id + Y + + commercial_partner_id - 9 - 0 - Table input - commercial_partner_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Boolean - normal + commercial_partner_id + Y + + is_move_sent - -1 - -1 - Table input - is_move_sent - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + is_move_sent + Y + + partner_bank_id - 9 - 0 - Table input - partner_bank_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + partner_bank_id + Y + + payment_reference - 2147483647 - -1 - Table input - payment_reference - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + payment_reference + Y + + payment_id - 9 - 0 - Table input - payment_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + payment_id + Y + + statement_line_id - 9 - 0 - Table input - statement_line_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + statement_line_id + Y + + amount_untaxed - -1 - -1 - Table input - amount_untaxed - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_untaxed + Y + + amount_tax - -1 - -1 - Table input - amount_tax - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_tax + Y + + amount_total - -1 - -1 - Table input - amount_total - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_total + Y + + amount_residual - -1 - -1 - Table input - amount_residual - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_residual + Y + + amount_untaxed_signed - -1 - -1 - Table input - amount_untaxed_signed - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_untaxed_signed + Y + + amount_tax_signed - -1 - -1 - Table input - amount_tax_signed - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_tax_signed + Y + + amount_total_signed - -1 - -1 - Table input - amount_total_signed - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - BigNumber - normal + amount_total_signed + Y + + amount_residual_signed - -1 - -1 - Table input - amount_residual_signed - ######0.0###################;-######0.0################### - . - - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + amount_residual_signed + Y + + payment_state - 2147483647 - -1 - Table input - payment_state - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + payment_state + Y + + tax_cash_basis_rec_id - 9 - 0 - Table input - tax_cash_basis_rec_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + tax_cash_basis_rec_id + Y + + tax_cash_basis_move_id - 9 - 0 - Table input - tax_cash_basis_move_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Boolean - normal + tax_cash_basis_move_id + Y + + auto_post - -1 - -1 - Table input - auto_post - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + auto_post + Y + + reversed_entry_id - 9 - 0 - Table input - reversed_entry_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + reversed_entry_id + Y + + fiscal_position_id - 9 - 0 - Table input - fiscal_position_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + fiscal_position_id + Y + + invoice_user_id - 9 - 0 - Table input - invoice_user_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Date - normal + invoice_user_id + Y + + invoice_date - -1 - -1 - Table input - invoice_date - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Date - normal + invoice_date + Y + + invoice_date_due - -1 - -1 - Table input - invoice_date_due - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + invoice_date_due + Y + + invoice_origin - 2147483647 - -1 - Table input - invoice_origin - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + invoice_origin + Y + + invoice_payment_term_id - 9 - 0 - Table input - invoice_payment_term_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + invoice_payment_term_id + Y + + invoice_incoterm_id - 9 - 0 - Table input - invoice_incoterm_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + invoice_incoterm_id + Y + + qr_code_method - 2147483647 - -1 - Table input - qr_code_method - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + qr_code_method + Y + + invoice_source_email - 2147483647 - -1 - Table input - invoice_source_email - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + invoice_source_email + Y + + invoice_partner_display_name - 2147483647 - -1 - Table input - invoice_partner_display_name - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + invoice_partner_display_name + Y + + invoice_cash_rounding_id - 9 - 0 - Table input - invoice_cash_rounding_id - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal + invoice_cash_rounding_id + Y + + secure_sequence_number - 9 - 0 - Table input - secure_sequence_number - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal + secure_sequence_number + Y + + inalterable_hash - 2147483647 - -1 - Table input - inalterable_hash - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - String - normal - access_token - 2147483647 - -1 - Table input - access_token - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - + inalterable_hash + Y + + + access_token + access_token + Y + + + message_main_attachment_id + message_main_attachment_id + Y + + + sequence_prefix + sequence_prefix + Y + + + sequence_number + sequence_number + Y + + + create_uid + create_uid + Y + + + create_date + create_date + Y + + + write_uid + write_uid + Y + + + write_date + write_date + Y + + + edi_state + edi_state + Y + + + stock_move_id + stock_move_id + Y + + + team_id + team_id + Y + + + partner_shipping_id + partner_shipping_id + Y + + + campaign_id + campaign_id + Y + + + source_id + source_id + Y + + + medium_id + medium_id + Y + + + preferred_payment_method_id + preferred_payment_method_id + Y + + + has_due + has_due + Y + + + is_warning + is_warning + Y + + + recurring_ref + recurring_ref + Y + + + website_id + website_id + Y + + + efaktur_id + efaktur_id + Y + + + is_efaktur_exported + is_efaktur_exported + Y + + + date_efaktur_exported + date_efaktur_exported + Y + + + masa_pajak + masa_pajak + Y + + + tahun_pajak + tahun_pajak + Y + + + efaktur_masukan + efaktur_masukan + Y + + + period_id + period_id + Y + + + date_send_fp + date_send_fp + Y + + + last_log_fp + last_log_fp + Y + + + date_kirim_tukar_faktur + date_kirim_tukar_faktur + Y + + + resi_tukar_faktur + resi_tukar_faktur + Y + + + date_terima_tukar_faktur + date_terima_tukar_faktur + Y + + + shipper_faktur_id + shipper_faktur_id + Y + + + due_extension + due_extension + Y + + + new_due_date + new_due_date + Y + + + counter + counter + Y + + + payment_schedule + payment_schedule + Y + + + cost_centre_id + cost_centre_id + Y + + + + + + + + + + + + 256 + 48 + Y + + + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik production (localhost) + select * from account_move --where write_date >= (now() - '5 days'::interval) + 0 + + N + N + N + N + Integer normal - message_main_attachment_id + id 9 0 Table input - message_main_attachment_id + id ####0;-####0 . , @@ -1648,11 +1043,11 @@ String normal - sequence_prefix + name 2147483647 -1 Table input - sequence_prefix + name . , @@ -1669,37 +1064,14 @@ N - Integer - normal - sequence_number - 9 - 0 - Table input - sequence_number - ####0;-####0 - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer + Date normal - create_uid - 9 - 0 + date + -1 + -1 Table input - create_uid - ####0;-####0 + date + . , @@ -1715,13 +1087,13 @@ N - Timestamp + String normal - create_date - 6 + ref + 2147483647 -1 Table input - create_date + ref . , @@ -1738,14 +1110,14 @@ N - Integer + String normal - write_uid - 9 - 0 + narration + 2147483647 + -1 Table input - write_uid - ####0;-####0 + narration + . , @@ -1761,13 +1133,13 @@ N - Timestamp + String normal - write_date - 6 + state + 2147483647 -1 Table input - write_date + state . , @@ -1784,13 +1156,13 @@ N - String + Boolean normal - edi_state - 2147483647 + posted_before + -1 -1 Table input - edi_state + posted_before . , @@ -1807,14 +1179,14 @@ N - Integer + String normal - stock_move_id - 9 - 0 + move_type + 2147483647 + -1 Table input - stock_move_id - ####0;-####0 + move_type + . , @@ -1830,14 +1202,14 @@ N - Integer + Boolean normal - team_id - 9 - 0 + to_check + -1 + -1 Table input - team_id - ####0;-####0 + to_check + . , @@ -1855,11 +1227,11 @@ Integer normal - partner_shipping_id + journal_id 9 0 Table input - partner_shipping_id + journal_id ####0;-####0 . , @@ -1878,11 +1250,11 @@ Integer normal - campaign_id + company_id 9 0 Table input - campaign_id + company_id ####0;-####0 . , @@ -1901,11 +1273,11 @@ Integer normal - source_id + currency_id 9 0 Table input - source_id + currency_id ####0;-####0 . , @@ -1924,11 +1296,11 @@ Integer normal - medium_id + partner_id 9 0 Table input - medium_id + partner_id ####0;-####0 . , @@ -1947,11 +1319,11 @@ Integer normal - preferred_payment_method_id + commercial_partner_id 9 0 Table input - preferred_payment_method_id + commercial_partner_id ####0;-####0 . , @@ -1970,11 +1342,11 @@ Boolean normal - has_due + is_move_sent -1 -1 Table input - has_due + is_move_sent . , @@ -1991,14 +1363,14 @@ N - Boolean + Integer normal - is_warning - -1 - -1 + partner_bank_id + 9 + 0 Table input - is_warning - + partner_bank_id + ####0;-####0 . , @@ -2016,11 +1388,11 @@ String normal - recurring_ref + payment_reference 2147483647 -1 Table input - recurring_ref + payment_reference . , @@ -2039,11 +1411,11 @@ Integer normal - website_id + payment_id 9 0 Table input - website_id + payment_id ####0;-####0 . , @@ -2062,11 +1434,11 @@ Integer normal - efaktur_id + statement_line_id 9 0 Table input - efaktur_id + statement_line_id ####0;-####0 . , @@ -2083,39 +1455,16 @@ N - Boolean + BigNumber normal - is_efaktur_exported + amount_untaxed -1 -1 Table input - is_efaktur_exported - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Timestamp - normal - date_efaktur_exported - 6 - -1 - Table input - date_efaktur_exported - + amount_untaxed + ######0.0###################;-######0.0################### . - , + none N @@ -2129,16 +1478,16 @@ N - String + BigNumber normal - masa_pajak - 2147483647 + amount_tax + -1 -1 Table input - masa_pajak - + amount_tax + ######0.0###################;-######0.0################### . - , + none N @@ -2152,16 +1501,16 @@ N - String + BigNumber normal - tahun_pajak - 2147483647 + amount_total + -1 -1 Table input - tahun_pajak - + amount_total + ######0.0###################;-######0.0################### . - , + none N @@ -2175,39 +1524,16 @@ N - String + BigNumber normal - efaktur_masukan - 2147483647 + amount_residual + -1 -1 Table input - efaktur_masukan - - . - , - - none - N - Y - 0 - N - N - N - en_US - Asia/Bangkok - N - - - Integer - normal - period_id - 9 - 0 - Table input - period_id - ####0;-####0 + amount_residual + ######0.0###################;-######0.0################### . - , + none N @@ -2221,16 +1547,16 @@ N - Timestamp + BigNumber normal - date_send_fp - 6 + amount_untaxed_signed + -1 -1 Table input - date_send_fp - + amount_untaxed_signed + ######0.0###################;-######0.0################### . - , + none N @@ -2244,16 +1570,16 @@ N - String + BigNumber normal - last_log_fp - 2147483647 + amount_tax_signed + -1 -1 Table input - last_log_fp - + amount_tax_signed + ######0.0###################;-######0.0################### . - , + none N @@ -2267,16 +1593,16 @@ N - Date + BigNumber normal - date_kirim_tukar_faktur + amount_total_signed -1 -1 Table input - date_kirim_tukar_faktur - + amount_total_signed + ######0.0###################;-######0.0################### . - , + none N @@ -2290,16 +1616,16 @@ N - String + BigNumber normal - resi_tukar_faktur - 2147483647 + amount_residual_signed + -1 -1 Table input - resi_tukar_faktur - + amount_residual_signed + ######0.0###################;-######0.0################### . - , + none N @@ -2313,13 +1639,13 @@ N - Date + String normal - date_terima_tukar_faktur - -1 + payment_state + 2147483647 -1 Table input - date_terima_tukar_faktur + payment_state . , @@ -2338,11 +1664,11 @@ Integer normal - shipper_faktur_id + tax_cash_basis_rec_id 9 0 Table input - shipper_faktur_id + tax_cash_basis_rec_id ####0;-####0 . , @@ -2361,11 +1687,11 @@ Integer normal - due_extension + tax_cash_basis_move_id 9 0 Table input - due_extension + tax_cash_basis_move_id ####0;-####0 . , @@ -2382,13 +1708,13 @@ N - Date + Boolean normal - new_due_date + auto_post -1 -1 Table input - new_due_date + auto_post . , @@ -2407,11 +1733,11 @@ Integer normal - counter + reversed_entry_id 9 0 Table input - counter + reversed_entry_id ####0;-####0 . , @@ -2428,14 +1754,14 @@ N - Date + Integer normal - payment_schedule - -1 - -1 + fiscal_position_id + 9 + 0 Table input - payment_schedule - + fiscal_position_id + ####0;-####0 . , @@ -2453,11 +1779,11 @@ Integer normal - cost_centre_id + invoice_user_id 9 0 Table input - cost_centre_id + invoice_user_id ####0;-####0 . , @@ -2470,463 +1796,1137 @@ N N en_US - Asia/Bangkok - N - - - - - - - - - - - - 112 - 48 - Y - - - - Insert / update - InsertUpdate - - Y - - 1 - - none - - - dw bi indoteknik (localhost) - 100 - N - - public - account_move
- - id - id - = - - - - id - id - N - - - name - name - Y - - - date - date - Y - - - ref - ref - Y - - - narration - narration - Y - - - state - state - Y - - - posted_before - posted_before - Y - - - move_type - move_type - Y - - - to_check - to_check - Y - - - journal_id - journal_id - Y - - - company_id - company_id - Y - - - currency_id - currency_id - Y - - - partner_id - partner_id - Y - - - commercial_partner_id - commercial_partner_id - Y - - - is_move_sent - is_move_sent - Y - - - partner_bank_id - partner_bank_id - Y - - - payment_reference - payment_reference - Y - - - payment_id - payment_id - Y - - - statement_line_id - statement_line_id - Y - - - amount_untaxed - amount_untaxed - Y - - - amount_tax - amount_tax - Y - - - amount_total - amount_total - Y - - - amount_residual - amount_residual - Y - - - amount_untaxed_signed - amount_untaxed_signed - Y - - - amount_tax_signed - amount_tax_signed - Y - - - amount_total_signed - amount_total_signed - Y - - - amount_residual_signed - amount_residual_signed - Y - - - payment_state - payment_state - Y - - - tax_cash_basis_rec_id - tax_cash_basis_rec_id - Y - - - tax_cash_basis_move_id - tax_cash_basis_move_id - Y - - - auto_post - auto_post - Y - - - reversed_entry_id - reversed_entry_id - Y - - - fiscal_position_id - fiscal_position_id - Y - - - invoice_user_id - invoice_user_id - Y - - + Asia/Bangkok + N + + + Date + normal invoice_date - invoice_date - Y - - + -1 + -1 + Table input + invoice_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal invoice_date_due - invoice_date_due - Y - - + -1 + -1 + Table input + invoice_date_due + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal invoice_origin - invoice_origin - Y - - + 2147483647 + -1 + Table input + invoice_origin + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal invoice_payment_term_id - invoice_payment_term_id - Y - - + 9 + 0 + Table input + invoice_payment_term_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal invoice_incoterm_id - invoice_incoterm_id - Y - - + 9 + 0 + Table input + invoice_incoterm_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal qr_code_method - qr_code_method - Y - - + 2147483647 + -1 + Table input + qr_code_method + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal invoice_source_email - invoice_source_email - Y - - + 2147483647 + -1 + Table input + invoice_source_email + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal invoice_partner_display_name - invoice_partner_display_name - Y - - + 2147483647 + -1 + Table input + invoice_partner_display_name + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal invoice_cash_rounding_id - invoice_cash_rounding_id - Y - - + 9 + 0 + Table input + invoice_cash_rounding_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal secure_sequence_number - secure_sequence_number - Y - - + 9 + 0 + Table input + secure_sequence_number + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal inalterable_hash - inalterable_hash - Y - - + 2147483647 + -1 + Table input + inalterable_hash + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal access_token - access_token - Y - - + 2147483647 + -1 + Table input + access_token + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal message_main_attachment_id - message_main_attachment_id - Y - - + 9 + 0 + Table input + message_main_attachment_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal sequence_prefix - sequence_prefix - Y - - + 2147483647 + -1 + Table input + sequence_prefix + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal sequence_number - sequence_number - Y - - + 9 + 0 + Table input + sequence_number + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal create_uid - create_uid - Y - - + 9 + 0 + Table input + create_uid + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal create_date - create_date - Y - - + 6 + -1 + Table input + create_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal write_uid - write_uid - Y - - + 9 + 0 + Table input + write_uid + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal write_date - write_date - Y - - + 6 + -1 + Table input + write_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal edi_state - edi_state - Y - - + 2147483647 + -1 + Table input + edi_state + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal stock_move_id - stock_move_id - Y - - + 9 + 0 + Table input + stock_move_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal team_id - team_id - Y - - + 9 + 0 + Table input + team_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal partner_shipping_id - partner_shipping_id - Y - - + 9 + 0 + Table input + partner_shipping_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal campaign_id - campaign_id - Y - - + 9 + 0 + Table input + campaign_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal source_id - source_id - Y - - + 9 + 0 + Table input + source_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal medium_id - medium_id - Y - - + 9 + 0 + Table input + medium_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal preferred_payment_method_id - preferred_payment_method_id - Y - - + 9 + 0 + Table input + preferred_payment_method_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal has_due - has_due - Y - - + -1 + -1 + Table input + has_due + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal is_warning - is_warning - Y - - + -1 + -1 + Table input + is_warning + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal recurring_ref - recurring_ref - Y - - + 2147483647 + -1 + Table input + recurring_ref + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal website_id - website_id - Y - - + 9 + 0 + Table input + website_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal efaktur_id - efaktur_id - Y - - + 9 + 0 + Table input + efaktur_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Boolean + normal is_efaktur_exported - is_efaktur_exported - Y - - + -1 + -1 + Table input + is_efaktur_exported + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal date_efaktur_exported - date_efaktur_exported - Y - - + 6 + -1 + Table input + date_efaktur_exported + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal masa_pajak - masa_pajak - Y - - + 2147483647 + -1 + Table input + masa_pajak + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal tahun_pajak - tahun_pajak - Y - - + 2147483647 + -1 + Table input + tahun_pajak + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal efaktur_masukan - efaktur_masukan - Y - - + 2147483647 + -1 + Table input + efaktur_masukan + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal period_id - period_id - Y - - + 9 + 0 + Table input + period_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Timestamp + normal date_send_fp - date_send_fp - Y - - + 6 + -1 + Table input + date_send_fp + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal last_log_fp - last_log_fp - Y - - + 2147483647 + -1 + Table input + last_log_fp + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal date_kirim_tukar_faktur - date_kirim_tukar_faktur - Y - - + -1 + -1 + Table input + date_kirim_tukar_faktur + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal resi_tukar_faktur - resi_tukar_faktur - Y - - + 2147483647 + -1 + Table input + resi_tukar_faktur + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal date_terima_tukar_faktur - date_terima_tukar_faktur - Y - - + -1 + -1 + Table input + date_terima_tukar_faktur + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal shipper_faktur_id - shipper_faktur_id - Y - - + 9 + 0 + Table input + shipper_faktur_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal due_extension - due_extension - Y - - + 9 + 0 + Table input + due_extension + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal new_due_date - new_due_date - Y - - + -1 + -1 + Table input + new_due_date + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal counter - counter - Y - - + 9 + 0 + Table input + counter + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Date + normal payment_schedule - payment_schedule - Y - - + -1 + -1 + Table input + payment_schedule + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + Integer + normal cost_centre_id - cost_centre_id - Y - - + 9 + 0 + Table input + cost_centre_id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + @@ -2936,7 +2936,7 @@ - 256 + 112 48 Y -- cgit v1.2.3