Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: account > Tables

move_line

Journal Item

Catalog: Odoo

Schema: account

Documentation:

Override AccountInvoice_line to add the link to the purchase order line it is related to

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 move_line are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

account_id_label

string

 

☐

 

account_id

string

 

☐

 

account_internal_group

string

Internal Group

☐

 

account_root_id_label

string

 

☐

 

account_root_id

string

 

☐

 

account_type

string

Internal Type

☐

Account Type is used for information purpose, to generate country-specific legal reports, and set the rules to close a fiscal year and generate opening entries.

amount_currency

decimal

Amount in Currency

☐

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

amount_residual_currency

decimal

Residual Amount in Currency

☐

The residual amount on a journal item expressed in its currency (possibly not the company currency).

amount_residual

decimal

Residual Amount

☐

The residual amount on a journal item expressed in the company currency.

analytic_distribution

string

Analytic Distribution

☐

 

analytic_line_ids

string

 

☐

 

analytic_precision

int32

Analytic Precision

☐

 

asset_ids

string

 

☐

 

balance

decimal

Balance

☐

 

blocked

boolean

No Follow-up

☐

You can check this box to mark this journal item as a litigation with the associated partner

company_currency_id_label

string

 

☐

 

company_currency_id

string

 

☐

 

company_id_label

string

 

☐

 

company_id

string

 

☐

 

compute_all_tax_dirty

boolean

Compute All Tax Dirty

☐

 

compute_all_tax

byte[]

Compute All Tax

☐

 

consolidation_journal_line_ids

string

 

☐

 

create_date

datetime

Created on

☐

 

create_uid_label

string

 

☐

 

create_uid

string

 

☐

 

credit

decimal

Credit

☐

 

cumulated_balance

decimal

Cumulated Balance

☐

Cumulated balance depending on the domain and the order chosen in the view.

currency_id_label

string

 

☐

 

currency_id

string

 

☐

 

currency_rate

decimal

Currency Rate

☐

Currency rate from company currency to document currency.

date_maturity

datetime

Due Date

☐

This field is used for payable and receivable journal entries. You can put the limit date for the payment of this line.

date

datetime

Date

☐

 

debit

decimal

Debit

☐

 

discount_amount_currency

decimal

Discount amount in Currency

☐

 

discount_balance

decimal

Discount Balance

☐

 

discount_date

datetime

Discount Date

☐

Last date at which the discounted amount must be paid in order for the Early Payment Discount to be granted

discount_percentage

decimal

Discount Percentage

☐

 

discount

decimal

Discount (%)

☐

 

display_name

string

Display Name

☐

 

display_type

string

Display Type

☑

 

epd_dirty

boolean

Epd Dirty

☐

 

epd_key

byte[]

Epd Key

☐

 

epd_needed

byte[]

Epd Needed

☐

 

expected_pay_date

datetime

Expected Date

☐

Expected payment date as manually set through the customer statement(e.g: if you had the customer on the phone and want to remember the date he promised he would pay)

expense_id_label

string

 

☐

 

expense_id

string

 

☐

 

followup_line_id_label

string

 

☐

 

followup_line_id

string

 

☐

 

full_reconcile_id_label

string

 

☐

 

full_reconcile_id

string

 

☐

 

group_tax_id_label

string

 

☐

 

group_tax_id

string

 

☐

 

id

int32

ID

☐

 

invoice_date

datetime

Invoice/Bill Date

☐

 

invoice_origin

string

Origin

☐

The document(s) that generated the invoice.

is_account_reconcile

boolean

Account Reconcile

☐

Check this box if this account allows invoices & payments matching of journal items.

is_downpayment

boolean

Is Downpayment

☐

 

is_refund

boolean

Is Refund

☐

 

is_same_currency

boolean

Is Same Currency

☐

 

is_storno

boolean

Company Storno Accounting

☐

Utility field to express whether the journal item is subject to storno accounting

journal_id_label

string

 

☐

 

journal_id

string

 

☐

 

last_followup_date

datetime

Latest Follow-up

☐

 

matched_credit_ids

string

 

☐

Credit journal items that are matched with this journal item.

matched_debit_ids

string

 

☐

Debit journal items that are matched with this journal item.

matching_number

string

Matching #

☐

Matching number for this line, 'P' if it is only partially reconcile, or the name of the full reconcile if it exists.

move_attachment_ids

string

 

☐

 

move_id_label

string

 

☐

 

move_id

string

 

☐

 

move_name

string

Number

☐

 

move_type

string

Type

☐

 

name

string

Label

☐

 

need_vehicle

boolean

Need Vehicle

☐

 

next_action_date

datetime

Next Action Date

☐

Date where the next action should be taken for a receivable item. Usually, automatically set when sending reminders through the customer statement.

non_deductible_tax_value

decimal

Non Deductible Tax Value

☐

 

parent_state

string

Status

☐

 

partner_id_label

string

 

☐

 

partner_id

string

 

☐

 

payment_id_label

string

 

☐

The payment that created this entry

payment_id

string

 

☐

The payment that created this entry

price_subtotal

decimal

Subtotal

☐

 

price_total

decimal

Total

☐

 

price_unit

decimal

Unit Price

☐

 

product_id_label

string

 

☐

 

product_id

string

 

☐

 

product_uom_category_id_label

string

 

☐

Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios.

product_uom_category_id

string

 

☐

Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios.

product_uom_id_label

string

 

☐

 

product_uom_id

string

 

☐

 

purchase_line_id_label

string

 

☐

 

purchase_line_id

string

 

☐

 

purchase_order_id_label

string

 

☐

 

purchase_order_id

string

 

☐

 

quantity

decimal

Quantity

☐

The optional quantity expressed by this line, eg: number of product sold. The quantity is not a legal requirement but is very useful for some reports.

reconcile_model_id_label

string

 

☐

 

reconcile_model_id

string

 

☐

 

reconciled

boolean

Reconciled

☐

 

ref

string

Reference

☐

 

repair_fee_ids

string

 

☐

 

repair_line_ids

string

 

☐

 

sale_line_ids

string

 

☐

 

sequence

int32

Sequence

☐

 

statement_id_label

string

 

☐

The bank statement used for bank reconciliation

statement_id

string

 

☐

The bank statement used for bank reconciliation

statement_line_id_label

string

 

☐

The statement line that created this entry

statement_line_id

string

 

☐

The statement line that created this entry

stock_valuation_layer_ids

string

 

☐

 

subscription_end_date

datetime

Subscription Revenue End Date

☐

 

subscription_id_label

string

 

☐

 

subscription_id

string

 

☐

 

subscription_mrr

decimal

Monthly Recurring Revenue

☐

The MRR is computed by dividing the signed amount (in company currency) by the amount of time between the start and end dates converted in months.This allows comparison of invoice lines created by subscriptions with different temporalities.The computation assumes that 1 month is comprised of exactly 30 days, regardless of the actual length of the month.

subscription_start_date

datetime

Subscription Revenue Start Date

☐

 

tax_audit

string

Tax Audit String

☐

Computed field, listing the tax grids impacted by this line, and the amount it applies to each of them.

tax_base_amount

decimal

Base Amount

☐

 

tax_group_id_label

string

 

☐

 

tax_group_id

string

 

☐

 

tax_ids

string

 

☐

 

tax_key

byte[]

Tax Key

☐

 

tax_line_id_label

string

 

☐

Indicates that this journal item is a tax line

tax_line_id

string

 

☐

Indicates that this journal item is a tax line

tax_repartition_line_id_label

string

 

☐

Tax distribution line that caused the creation of this move line, if any

tax_repartition_line_id

string

 

☐

Tax distribution line that caused the creation of this move line, if any

tax_tag_ids

string

 

☐

Tags assigned to this line by the tax creating it, if any. It determines its impact on financial reports.

tax_tag_invert

boolean

Invert Tags

☐

 

term_key

byte[]

Term Key

☐

 

vehicle_id_label

string

 

☐

 

vehicle_id

string

 

☐

 

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