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