Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: account > Tables

bank_statement_line

Bank Statement Line

Catalog: Odoo

Schema: account

Documentation:

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

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table bank_statement_line are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

access_token

string

Security Token

☐

 

access_url

string

Portal Access URL

☐

Customer Portal URL

access_warning

string

Access warning

☐

 

account_number

string

Bank Account Number

☐

 

activity_calendar_event_id_label

string

 

☐

 

activity_calendar_event_id

string

 

☐

 

activity_date_deadline

datetime

Next Activity Deadline

☐

 

activity_exception_decoration

string

Activity Exception Decoration

☐

Type of the exception activity on record.

activity_exception_icon

string

Icon

☐

Icon to indicate an exception activity.

activity_ids

string

 

☐

 

activity_state

string

Activity State

☐

Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities.

activity_summary

string

Next Activity Summary

☐

 

activity_type_icon

string

Activity Type Icon

☐

Font awesome icon e.g. fa-tasks

activity_type_id_label

string

 

☐

 

activity_type_id

string

 

☐

 

activity_user_id_label

string

 

☐

 

activity_user_id

string

 

☐

 

always_tax_exigible

boolean

Always Tax Exigible

☐

 

amount_currency

decimal

Amount in Currency

☐

The amount expressed in an optional other currency if it is a multi-currency entry.

amount_paid

decimal

Amount paid

☐

 

amount_residual_signed

decimal

Amount Due Signed

☐

 

amount_residual

decimal

Residual Amount

☐

 

amount_tax_signed

decimal

Tax Signed

☐

 

amount_tax

decimal

Tax

☐

 

amount_total_in_currency_signed

decimal

Total in Currency Signed

☐

 

amount_total_signed

decimal

Total Signed

☐

 

amount_total

decimal

Total

☐

 

amount_untaxed_signed

decimal

Untaxed Amount Signed

☐

 

amount_untaxed

decimal

Untaxed Amount

☐

 

amount

decimal

Amount

☐

 

asset_asset_type

string

Asset Type

☐

 

asset_depreciated_value

decimal

Cumulative Depreciation

☐

 

asset_depreciation_beginning_date

datetime

Date of the beginning of the depreciation

☐

 

asset_id_display_name

string

Asset Id Display Name

☐

 

asset_id_label

string

 

☐

 

asset_id

string

 

☐

 

asset_ids

string

 

☐

 

asset_number_days

int32

Number of days

☐

 

asset_remaining_value

decimal

Depreciable Value

☐

 

asset_value_change

boolean

Asset Value Change

☐

 

attachment_ids

string

 

☐

 

authorized_transaction_ids

string

 

☐

 

auto_post_origin_id_label

string

 

☐

 

auto_post_origin_id

string

 

☐

 

auto_post_until

datetime

Auto-post until

☐

This recurring move will be posted up to and including this date.

auto_post

string

Auto-post

☑

Specify whether this entry is posted automatically on its accounting date, and any similar recurring invoices.

bank_partner_id_label

string

 

☐

Technical field to get the domain on the bank

bank_partner_id

string

 

☐

Technical field to get the domain on the bank

campaign_id_label

string

 

☐

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

campaign_id

string

 

☐

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

commercial_partner_id_label

string

 

☐

 

commercial_partner_id

string

 

☐

 

company_currency_id_label

string

 

☐

 

company_currency_id

string

 

☐

 

company_id_label

string

 

☐

 

company_id

string

 

☐

 

count_asset

int32

Count Asset

☐

 

count_deferred_expense

int32

Count Deferred Expense

☐

 

count_deferred_revenue

int32

Count Deferred Revenue

☐

 

country_code

string

Country Code

☐

The ISO country code in two chars. You can use this field for quick search.

create_date

datetime

Created on

☐

 

create_uid_label

string

 

☐

 

create_uid

string

 

☐

 

cron_last_check

datetime

Cron Last Check

☐

 

currency_id_label

string

 

☐

 

currency_id

string

 

☐

 

date

datetime

Date

☑

 

depreciation_value

decimal

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

string

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

string

 

☐

 

edi_blocking_level

string

Edi Blocking Level

☐

 

edi_document_ids

string

 

☐

 

edi_error_count

int32

Edi Error Count

☐

How many EDIs are in error for this move ?

edi_error_message

string

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

string

Electronic invoicing

☐

The aggregated state of all the EDIs with web-service of this move

edi_web_services_to_process

string

Edi Web Services To Process

☐

 

expense_sheet_id

string

 

☐

 

extract_attachment_id_label

string

 

☐

 

extract_attachment_id

string

 

☐

 

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

string

Error message

☐

 

extract_partner_name

string

Extract Detected Partner Name

☐

 

extract_remote_id

int32

Id of the request to IAP-OCR

☐

 

extract_state_processed

boolean

Extract State Processed

☐

 

extract_state

string

Extract state

☑

 

extract_status_code

int32

Status code

☐

 

extract_word_ids

string

 

☐

 

fiscal_position_id_label

string

 

☐

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

string

 

☐

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_label

string

 

☐

The optional other currency if it is a multi-currency entry.

foreign_currency_id

string

 

☐

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

string

Highest Name

☐

 

id

int32

ID

☐

 

inalterable_hash

string

Inalterability Hash

☐

 

internal_index

string

Internal Reference

☐

 

invoice_cash_rounding_id_label

string

 

☐

Defines the smallest coinage of the currency that can be used to pay by cash.

invoice_cash_rounding_id

string

 

☐

Defines the smallest coinage of the currency that can be used to pay by cash.

invoice_date_due

datetime

Due Date

☐

 

invoice_date

datetime

Invoice/Bill Date

☐

 

invoice_filter_type_domain

string

Invoice Filter Type Domain

☐

 

invoice_has_outstanding

boolean

Invoice Has Outstanding

☐

 

invoice_incoterm_id_label

string

 

☐

International Commercial Terms are a series of predefined commercial terms used in international transactions.

invoice_incoterm_id

string

 

☐

International Commercial Terms are a series of predefined commercial terms used in international transactions.

invoice_line_ids

string

 

☐

 

invoice_origin

string

Origin

☐

The document(s) that generated the invoice.

invoice_outstanding_credits_debits_widget

byte[]

Invoice Outstanding Credits Debits Widget

☐

 

invoice_partner_display_name

string

Invoice Partner Display Name

☐

 

invoice_payment_term_id_label

string

 

☐

 

invoice_payment_term_id

string

 

☐

 

invoice_payments_widget

byte[]

Invoice Payments Widget

☐

 

invoice_source_email

string

Source Email

☐

 

invoice_user_id_label

string

 

☐

 

invoice_user_id

string

 

☐

 

invoice_vendor_bill_id_label

string

 

☐

Auto-complete from a past bill.

invoice_vendor_bill_id

string

 

☐

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_label

string

 

☐

 

journal_id

string

 

☐

 

line_ids

string

 

☐

 

made_sequence_hole

boolean

Made Sequence Hole

☐

 

medium_id_label

string

 

☐

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

medium_id

string

 

☐

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

message_attachment_count

int32

Attachment Count

☐

 

message_follower_ids

string

 

☐

 

message_has_error_counter

int32

Number of errors

☐

Number of messages with delivery error

message_has_error

boolean

Message Delivery error

☐

If checked, some messages have a delivery error.

message_has_sms_error

boolean

SMS Delivery error

☐

If checked, some messages have a delivery error.

message_ids

string

 

☐

 

message_is_follower

boolean

Is Follower

☐

 

message_main_attachment_id_label

string

 

☐

 

message_main_attachment_id

string

 

☐

 

message_needaction_counter

int32

Number of Actions

☐

Number of messages which requires an action

message_needaction

boolean

Action Needed

☐

If checked, new messages require your attention.

message_partner_ids

string

 

☐

 

move_id_label

string

 

☐

 

move_id

string

 

☐

 

move_type

string

Type

☑

 

my_activity_date_deadline

datetime

My Activity Deadline

☐

 

name

string

Number

☐

 

narration

string

Terms and Conditions

☐

 

needed_terms_dirty

boolean

Needed Terms Dirty

☐

 

needed_terms

byte[]

Needed Terms

☐

 

online_account_id_label

string

 

☐

 

online_account_id

string

 

☐

 

online_link_id_label

string

 

☐

 

online_link_id

string

 

☐

 

online_partner_information

string

Online Partner Information

☐

 

online_transaction_identifier

string

Online Transaction Identifier

☐

 

partner_bank_id_label

string

 

☐

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

string

 

☐

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

string

Partner Credit Warning

☐

 

partner_id_label

string

 

☐

 

partner_id

string

 

☐

 

partner_name

string

Partner Name

☐

 

partner_shipping_id_label

string

 

☐

The delivery address will be used in the computation of the fiscal position.

partner_shipping_id

string

 

☐

The delivery address will be used in the computation of the fiscal position.

payment_id_label

string

 

☐

 

payment_id

string

 

☐

 

payment_ids

string

 

☐

 

payment_ref

string

Label

☐

 

payment_reference

string

Payment Reference

☐

The payment reference to set on journal items.

payment_state_before_switch

string

Payment State Before Switch

☐

 

payment_state

string

Payment Status

☐

 

payment_term_details

byte[]

Payment Term Details

☐

 

pos_order_ids

string

 

☐

 

pos_payment_ids

string

 

☐

 

pos_session_id_label

string

 

☐

 

pos_session_id

string

 

☐

 

posted_before

boolean

Posted Before

☐

 

purchase_id_label

string

 

☐

Auto-complete from a past purchase order.

purchase_id

string

 

☐

Auto-complete from a past purchase order.

purchase_order_count

int32

Purchase Order Count

☐

 

purchase_vendor_bill_id_label

string

 

☐

Auto-complete from a past bill / purchase order.

purchase_vendor_bill_id

string

 

☐

Auto-complete from a past bill / purchase order.

qr_code_method

string

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

decimal

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

byte[]

Quick Encoding Vals

☐

 

ref

string

Reference

☐

 

repair_ids

string

 

☐

 

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

string

 

☐

 

reversed_entry_id_label

string

 

☐

 

reversed_entry_id

string

 

☐

 

running_balance

decimal

Running Balance

☐

 

sale_order_count

int32

Sale Order Count

☐

 

secure_sequence_number

int32

Inalteralbility No Gap Sequence #

☐

 

sequence_number

int32

Sequence Number

☐

 

sequence_prefix

string

Sequence Prefix

☐

 

sequence

int32

Sequence

☐

 

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_label

string

 

☐

This is the source of the link, e.g. Search Engine, another domain, or name of email list

source_id

string

 

☐

This is the source of the link, e.g. Search Engine, another domain, or name of email list

state

string

Status

☑

 

statement_complete

boolean

Is Complete

☐

 

statement_id_label

string

 

☐

 

statement_id

string

 

☐

 

statement_line_id_label

string

 

☐

 

statement_line_id

string

 

☐

 

statement_line_ids

string

 

☐

 

statement_valid

boolean

Is Valid

☐

 

stock_move_id_label

string

 

☐

 

stock_move_id

string

 

☐

 

stock_valuation_layer_ids

string

 

☐

 

string_to_hash

string

String To Hash

☐

 

suitable_journal_ids

string

 

☐

 

suspense_statement_line_id_label

string

 

☐

 

suspense_statement_line_id

string

 

☐

 

tax_cash_basis_created_move_ids

string

 

☐

The cash basis entries created from the taxes on this entry, when reconciling its lines.

tax_cash_basis_origin_move_id_label

string

 

☐

The journal entry from which this tax cash basis journal entry has been created.

tax_cash_basis_origin_move_id

string

 

☐

The journal entry from which this tax cash basis journal entry has been created.

tax_cash_basis_rec_id_label

string

 

☐

 

tax_cash_basis_rec_id

string

 

☐

 

tax_closing_end_date

datetime

Tax Closing End Date

☐

 

tax_country_code

string

Tax Country Code

☐

 

tax_country_id_label

string

 

☐

 

tax_country_id

string

 

☐

 

tax_lock_date_message

string

Tax Lock Date Message

☐

 

tax_report_control_error

boolean

Tax Report Control Error

☐

 

tax_totals

byte[]

Invoice Totals

☐

Edit Tax amounts if you encounter rounding issues.

team_id_label

string

 

☐

 

team_id

string

 

☐

 

timesheet_count

int32

Number of timesheets

☐

 

timesheet_encode_uom_id_label

string

 

☐

 

timesheet_encode_uom_id

string

 

☐

 

timesheet_ids

string

 

☐

 

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

string

 

☐

 

transaction_type

string

Transaction Type

☐

 

transfer_model_id_label

string

 

☐

 

transfer_model_id

string

 

☐

 

type_name

string

Type Name

☐

 

unique_import_id

string

Import ID

☐

 

user_id_label

string

 

☐

 

user_id

string

 

☐

 

website_id_label

string

 

☐

Website through which this invoice was created for eCommerce orders.

website_id

string

 

☐

Website through which this invoice was created for eCommerce orders.

website_message_ids

string

 

☐

Website communication history

write_date

datetime

Last Updated on

☐

 

write_uid_label

string

 

☐

 

write_uid

string

 

☐

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer