invantive documentation
Forum di supporto InvantiveAccedi / Registrati

move_line: Odoo itgen_odoo_move_line

read only per partition

  • Catalogo: Odoo
  • Schema: account
  • Etichetta: itgen_odoo_move_line

Journal Item

È possibile solo recuperare i dati.

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

Colonne della tabella

Di seguito sono riportate le colonne della tabella move_line. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
account_id varchar2
account_id_label varchar2
account_internal_group varchar2 Internal Group
account_root_id varchar2
account_root_id_label varchar2
account_type varchar2 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 numeric Importo in Valuta The amount expressed in an optional other currency if it is a multi-currency entry.
amount_residual numeric Importo residuo The residual amount on a journal item expressed in the company currency.
amount_residual_currency numeric Residual Amount in Currency The residual amount on a journal item expressed in its currency (possibly not the company currency).
analytic_distribution varchar2 Analytic Distribution
analytic_line_ids varchar2
analytic_precision int32 Analytic Precision
asset_ids varchar2
balance numeric 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 varchar2
company_currency_id_label varchar2
company_id varchar2
company_id_label varchar2
compute_all_tax varbinary Compute All Tax
compute_all_tax_dirty boolean Compute All Tax Dirty
consolidation_journal_line_ids varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
credit numeric Credit
cumulated_balance numeric Cumulated Balance Cumulated balance depending on the domain and the order chosen in the view.
currency_id varchar2
currency_id_label varchar2
currency_rate numeric Tasso di cambio della valuta Currency rate from company currency to document currency.
date datetime Date
date_maturity datetime Scadenza This field is used for payable and receivable journal entries.You can put the limit date for the payment of this line.
debit numeric Debit
discount numeric Sconto (%)
discount_amount_currency numeric Discount amount in Currency
discount_balance numeric 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 numeric Percentuale di sconto
display_name varchar2 Nome visualizzato
display_type varchar2 Tipo di display
epd_dirty boolean Epd Dirty
epd_key varbinary Epd Key
epd_needed varbinary 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 varchar2
expense_id_label varchar2
followup_line_id varchar2
followup_line_id_label varchar2
full_reconcile_id varchar2
full_reconcile_id_label varchar2
group_tax_id varchar2
group_tax_id_label varchar2
id int32 ID
invoice_date datetime Invoice/Bill Date
invoice_origin varchar2 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 varchar2
journal_id_label varchar2
last_followup_date datetime Latest Follow-up
matched_credit_ids varchar2 Credit journal items that are matched with this journal item.
matched_debit_ids varchar2 Debit journal items that are matched with this journal item.
matching_number varchar2 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 varchar2
move_id varchar2
move_id_label varchar2
move_name varchar2 Number
move_type varchar2 Type
name varchar2 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 numeric Non Deductible Tax Value
parent_state varchar2 Status
partner_id varchar2
partner_id_label varchar2
payment_id varchar2 The payment that created this entry
payment_id_label varchar2 The payment that created this entry
price_subtotal numeric Subtotal
price_total numeric Total
price_unit numeric Prezzo unitario
product_id varchar2
product_id_label varchar2
product_uom_category_id varchar2 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_label varchar2 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 varchar2
product_uom_id_label varchar2
purchase_line_id varchar2
purchase_line_id_label varchar2
purchase_order_id varchar2
purchase_order_id_label varchar2
quantity numeric 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 varchar2
reconcile_model_id_label varchar2
reconciled boolean Reconciled
ref varchar2 Reference
repair_fee_ids varchar2
repair_line_ids varchar2
sale_line_ids varchar2
sequence int32 Sequence
statement_id varchar2 The bank statement used for bank reconciliation
statement_id_label varchar2 The bank statement used for bank reconciliation
statement_line_id varchar2 The statement line that created this entry
statement_line_id_label varchar2 The statement line that created this entry
stock_valuation_layer_ids varchar2
subscription_end_date datetime Subscription Revenue End Date
subscription_id varchar2
subscription_id_label varchar2
subscription_mrr numeric 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 varchar2 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 numeric Importo base
tax_group_id varchar2
tax_group_id_label varchar2
tax_ids varchar2
tax_key varbinary Tax Key
tax_line_id varchar2 Indicates that this journal item is a tax line
tax_line_id_label varchar2 Indicates that this journal item is a tax line
tax_repartition_line_id varchar2 Tax distribution line that caused the creation of this move line, if any
tax_repartition_line_id_label varchar2 Tax distribution line that caused the creation of this move line, if any
tax_tag_ids varchar2 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 varbinary Term Key
vehicle_id varchar2
vehicle_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: