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