invantive documentation
Invantive Support ForumsLog In / Sign Up

bank_statement_line: Odoo itgen_odoo_bank_statement_line

read only per partition

  • Catalog: Odoo
  • Schema: account
  • Label: itgen_odoo_bank_statement_line

Bank Statement Line

Can only retrieve data.

Summary

Populate factory part for account.bank.statements.line.

Table Columns

The columns of the table bank_statement_line are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
access_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
account_number varchar2 Bank Account Number
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
always_tax_exigible boolean Always Tax Exigible
amount numeric Amount
amount_currency numeric Amount in Currency The amount expressed in an optional other currency if it is a multi-currency entry.
amount_paid numeric Amount paid
amount_residual numeric Residual Amount
amount_residual_signed numeric Amount Due Signed
amount_tax numeric Tax
amount_tax_signed numeric Tax Signed
amount_total numeric Total
amount_total_in_currency_signed numeric Total in Currency Signed
amount_total_signed numeric Total Signed
amount_untaxed numeric Untaxed Amount
amount_untaxed_signed numeric Untaxed Amount Signed
asset_asset_type varchar2 Asset Type
asset_depreciated_value numeric Cumulative Depreciation
asset_depreciation_beginning_date datetime Date of the beginning of the depreciation
asset_id varchar2
asset_id_display_name varchar2 Asset Id Display Name
asset_id_label varchar2
asset_ids varchar2
asset_number_days int32 Number of days
asset_remaining_value numeric Depreciable Value
asset_value_change boolean Asset Value Change
attachment_ids varchar2
authorized_transaction_ids varchar2
auto_post varchar2 Auto-post Specify whether this entry is posted automatically on its accounting date, and any similar recurring invoices.
auto_post_origin_id varchar2
auto_post_origin_id_label varchar2
auto_post_until datetime Auto-post until This recurring move will be posted up to and including this date.
bank_partner_id varchar2 Technical field to get the domain on the bank
bank_partner_id_label varchar2 Technical field to get the domain on the bank
campaign_id varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
campaign_id_label varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_currency_id varchar2
company_currency_id_label varchar2
company_id varchar2
company_id_label varchar2
count_asset int32 Count Asset
count_deferred_expense int32 Count Deferred Expense
count_deferred_revenue int32 Count Deferred Revenue
country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
cron_last_check datetime Cron Last Check
currency_id varchar2
currency_id_label varchar2
date datetime Date
depreciation_value numeric Depreciation
direction_sign int32 Direction Sign Multiplicator depending on the document type, to convert a price into a balance
display_inactive_currency_warning boolean Display Inactive Currency Warning
display_name varchar2 Display Name
display_qr_code boolean Display QR-code
draft_asset_exists boolean Draft Asset Exists
draft_deferred_expense_exists boolean Draft Deferred Expense Exists
draft_deferred_revenue_exists boolean Draft Deferred Revenue Exists
duplicated_ref_ids varchar2
edi_blocking_level varchar2 Edi Blocking Level
edi_document_ids varchar2
edi_error_count int32 Edi Error Count How many EDIs are in error for this move ?
edi_error_message varchar2 Edi Error Message
edi_show_abandon_cancel_button boolean Edi Show Abandon Cancel Button
edi_show_cancel_button boolean Edi Show Cancel Button
edi_state varchar2 Electronic invoicing The aggregated state of all the EDIs with web-service of this move
edi_web_services_to_process varchar2 Edi Web Services To Process
expense_sheet_id varchar2
extract_attachment_id varchar2
extract_attachment_id_label varchar2
extract_can_show_banners boolean Can show the ocr banners
extract_can_show_send_button boolean Can show the ocr send button
extract_detected_layout int32 Extract Detected Layout Id
extract_error_message varchar2 Error message
extract_partner_name varchar2 Extract Detected Partner Name
extract_remote_id int32 Id of the request to IAP-OCR
extract_state varchar2 Extract state
extract_state_processed boolean Extract State Processed
extract_status_code int32 Status code
extract_word_ids varchar2
fiscal_position_id varchar2 Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices. The default value comes from the customer.
fiscal_position_id_label varchar2 Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices. The default value comes from the customer.
foreign_currency_id varchar2 The optional other currency if it is a multi-currency entry.
foreign_currency_id_label varchar2 The optional other currency if it is a multi-currency entry.
has_message boolean Has Message
has_reconciled_entries boolean Has Reconciled Entries
hide_post_button boolean Hide Post Button
highest_name varchar2 Highest Name
id int32 ID
inalterable_hash varchar2 Inalterability Hash
internal_index varchar2 Internal Reference
invoice_cash_rounding_id varchar2 Defines the smallest coinage of the currency that can be used to pay by cash.
invoice_cash_rounding_id_label varchar2 Defines the smallest coinage of the currency that can be used to pay by cash.
invoice_date datetime Invoice/Bill Date
invoice_date_due datetime Due Date
invoice_filter_type_domain varchar2 Invoice Filter Type Domain
invoice_has_outstanding boolean Invoice Has Outstanding
invoice_incoterm_id varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
invoice_incoterm_id_label varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
invoice_line_ids varchar2
invoice_origin varchar2 Origin The document(s) that generated the invoice.
invoice_outstanding_credits_debits_widget varbinary Invoice Outstanding Credits Debits Widget
invoice_partner_display_name varchar2 Invoice Partner Display Name
invoice_payment_term_id varchar2
invoice_payment_term_id_label varchar2
invoice_payments_widget varbinary Invoice Payments Widget
invoice_source_email varchar2 Source Email
invoice_user_id varchar2
invoice_user_id_label varchar2
invoice_vendor_bill_id varchar2 Auto-complete from a past bill.
invoice_vendor_bill_id_label varchar2 Auto-complete from a past bill.
is_in_extractable_state boolean Is In Extractable State
is_move_sent boolean Is Move Sent It indicates that the invoice/payment has been sent.
is_reconciled boolean Is Reconciled
is_storno boolean Is Storno
journal_id varchar2
journal_id_label varchar2
line_ids varchar2
made_sequence_hole boolean Made Sequence Hole
medium_id varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
medium_id_label varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
move_id varchar2
move_id_label varchar2
move_type varchar2 Type
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Number
narration varchar2 Terms and Conditions
needed_terms varbinary Needed Terms
needed_terms_dirty boolean Needed Terms Dirty
online_account_id varchar2
online_account_id_label varchar2
online_link_id varchar2
online_link_id_label varchar2
online_partner_information varchar2 Online Partner Information
online_transaction_identifier varchar2 Online Transaction Identifier
partner_bank_id varchar2 Bank Account Number to which the invoice will be paid. A Company bank account if this is a Customer Invoice or Vendor Credit Note, otherwise a Partner bank account number.
partner_bank_id_label varchar2 Bank Account Number to which the invoice will be paid. A Company bank account if this is a Customer Invoice or Vendor Credit Note, otherwise a Partner bank account number.
partner_credit_warning varchar2 Partner Credit Warning
partner_id varchar2
partner_id_label varchar2
partner_name varchar2 Partner Name
partner_shipping_id varchar2 The delivery address will be used in the computation of the fiscal position.
partner_shipping_id_label varchar2 The delivery address will be used in the computation of the fiscal position.
payment_id varchar2
payment_id_label varchar2
payment_ids varchar2
payment_ref varchar2 Label
payment_reference varchar2 Payment Reference The payment reference to set on journal items.
payment_state varchar2 Payment Status
payment_state_before_switch varchar2 Payment State Before Switch
payment_term_details varbinary Payment Term Details
pos_order_ids varchar2
pos_payment_ids varchar2
pos_session_id varchar2
pos_session_id_label varchar2
posted_before boolean Posted Before
purchase_id varchar2 Auto-complete from a past purchase order.
purchase_id_label varchar2 Auto-complete from a past purchase order.
purchase_order_count int32 Purchase Order Count
purchase_vendor_bill_id varchar2 Auto-complete from a past bill / purchase order.
purchase_vendor_bill_id_label varchar2 Auto-complete from a past bill / purchase order.
qr_code_method varchar2 Payment QR-code Type of QR-code to be generated for the payment of this invoice, when printing it. If left blank, the first available and usable method will be used.
quick_edit_mode boolean Quick Edit Mode
quick_edit_total_amount numeric Total (Tax inc.) Use this field to encode the total amount of the invoice. Odoo will automatically create one invoice line with default values to match it.
quick_encoding_vals varbinary Quick Encoding Vals
ref varchar2 Reference
repair_ids varchar2
restrict_mode_hash_table boolean Lock Posted Entries with Hash If ticked, the accounting entry or invoice receives a hash as soon as it is posted and cannot be modified anymore.
reversal_move_id varchar2
reversed_entry_id varchar2
reversed_entry_id_label varchar2
running_balance numeric Running Balance
sale_order_count int32 Sale Order Count
secure_sequence_number int32 Inalteralbility No Gap Sequence #
sequence int32 Sequence
sequence_number int32 Sequence Number
sequence_prefix varchar2 Sequence Prefix
show_discount_details boolean Show Discount Details
show_name_warning boolean Show Name Warning
show_payment_term_details boolean Show Payment Term Details
show_reset_to_draft_button boolean Show Reset To Draft Button
source_id varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
source_id_label varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
state varchar2 Status
statement_complete boolean Is Complete
statement_id varchar2
statement_id_label varchar2
statement_line_id varchar2
statement_line_id_label varchar2
statement_line_ids varchar2
statement_valid boolean Is Valid
stock_move_id varchar2
stock_move_id_label varchar2
stock_valuation_layer_ids varchar2
string_to_hash varchar2 String To Hash
suitable_journal_ids varchar2
suspense_statement_line_id varchar2
suspense_statement_line_id_label varchar2
tax_cash_basis_created_move_ids varchar2 The cash basis entries created from the taxes on this entry, when reconciling its lines.
tax_cash_basis_origin_move_id varchar2 The journal entry from which this tax cash basis journal entry has been created.
tax_cash_basis_origin_move_id_label varchar2 The journal entry from which this tax cash basis journal entry has been created.
tax_cash_basis_rec_id varchar2
tax_cash_basis_rec_id_label varchar2
tax_closing_end_date datetime Tax Closing End Date
tax_country_code varchar2 Tax Country Code
tax_country_id varchar2
tax_country_id_label varchar2
tax_lock_date_message varchar2 Tax Lock Date Message
tax_report_control_error boolean Tax Report Control Error
tax_totals varbinary Invoice Totals Edit Tax amounts if you encounter rounding issues.
team_id varchar2
team_id_label varchar2
timesheet_count int32 Number of timesheets
timesheet_encode_uom_id varchar2
timesheet_encode_uom_id_label varchar2
timesheet_ids varchar2
timesheet_total_duration int32 Timesheet Total Duration Total recorded duration, expressed in the encoding UoM, and rounded to the unit
to_check boolean To Check If this checkbox is ticked, it means that the user was not sure of all the related information at the time of the creation of the move and that the move needs to be checked again.
transaction_ids varchar2
transaction_type varchar2 Transaction Type
transfer_model_id varchar2
transfer_model_id_label varchar2
type_name varchar2 Type Name
unique_import_id varchar2 Import ID
user_id varchar2
user_id_label varchar2
website_id varchar2 Website through which this invoice was created for eCommerce orders.
website_id_label varchar2 Website through which this invoice was created for eCommerce orders.
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: