account_move_line

57 rows


Description

Journal Item

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_move_line_id_seq'::regclass)
account_account_tag_account_move_line_rel.account_move_line_id account_account_tag_account_move_line_account_move_line_id_fkey C
account_analytic_line.move_line_id account_analytic_line_move_line_id_fkey C
account_automatic_entry_wizard_account_move_line_rel.account_move_line_id account_automatic_entry_wizard_accoun_account_move_line_id_fkey C
account_move_line.cogs_origin_id account_move_line_cogs_origin_id_fkey N
account_move_line_account_tax_rel.account_move_line_id account_move_line_account_tax_rel_account_move_line_id_fkey C
account_partial_reconcile.credit_move_id account_partial_reconcile_credit_move_id_fkey R
account_partial_reconcile.debit_move_id account_partial_reconcile_debit_move_id_fkey R
account_payment_register_move_line_rel.line_id account_payment_register_move_line_rel_line_id_fkey C
sale_order_line_invoice_rel.invoice_line_id sale_order_line_invoice_rel_invoice_line_id_fkey C
stock_valuation_layer.account_move_line_id stock_valuation_layer_account_move_line_id_fkey N
move_id int4 10 null
account_move.id account_move_line_move_id_fkey C

Journal Entry
journal_id int4 10 √ null
account_journal.id account_move_line_journal_id_fkey N

Journal
company_id int4 10 √ null
res_company.id account_move_line_company_id_fkey N

Company
company_currency_id int4 10 √ null
res_currency.id account_move_line_company_currency_id_fkey N

Company Currency
sequence int4 10 √ null

Sequence
account_id int4 10 √ null
account_account.id account_move_line_account_id_fkey C

Account
currency_id int4 10 null
res_currency.id account_move_line_currency_id_fkey R

Currency
partner_id int4 10 √ null
res_partner.id account_move_line_partner_id_fkey R

Partner
reconcile_model_id int4 10 √ null
account_reconcile_model.id account_move_line_reconcile_model_id_fkey N

Reconciliation Model
payment_id int4 10 √ null
account_payment.id account_move_line_payment_id_fkey N

Originator Payment
statement_line_id int4 10 √ null
account_bank_statement_line.id account_move_line_statement_line_id_fkey N

Originator Statement Line
statement_id int4 10 √ null
account_bank_statement.id account_move_line_statement_id_fkey N

Statement
group_tax_id int4 10 √ null
account_tax.id account_move_line_group_tax_id_fkey N

Originator Group of Taxes
tax_line_id int4 10 √ null
account_tax.id account_move_line_tax_line_id_fkey R

Originator Tax
tax_group_id int4 10 √ null
account_tax_group.id account_move_line_tax_group_id_fkey N

Originator tax group
tax_repartition_line_id int4 10 √ null
account_tax_repartition_line.id account_move_line_tax_repartition_line_id_fkey R

Originator Tax Distribution Line
full_reconcile_id int4 10 √ null
account_full_reconcile.id account_move_line_full_reconcile_id_fkey N

Matching
account_root_id int4 10 √ null

Account Root
product_id int4 10 √ null
product_product.id account_move_line_product_id_fkey R

Product
product_uom_id int4 10 √ null
uom_uom.id account_move_line_product_uom_id_fkey R

Unit of Measure
create_uid int4 10 √ null
res_users.id account_move_line_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id account_move_line_write_uid_fkey N

Last Updated by
move_name varchar 2147483647 √ null

Number
parent_state varchar 2147483647 √ null

Status
ref varchar 2147483647 √ null

Reference
name varchar 2147483647 √ null

Label
matching_number varchar 2147483647 √ null

Matching #
display_type varchar 2147483647 null

Display Type
date date 13 √ null

Date
invoice_date date 13 √ null

Invoice/Bill Date
date_maturity date 13 √ null

Due Date
discount_date date 13 √ null

Discount Date
analytic_distribution jsonb 2147483647 √ null

Analytic Distribution
debit numeric 0 √ null

Debit
credit numeric 0 √ null

Credit
balance numeric 0 √ null

Balance
amount_currency numeric 0 √ null

Amount in Currency
tax_base_amount numeric 0 √ null

Base Amount
amount_residual numeric 0 √ null

Residual Amount
amount_residual_currency numeric 0 √ null

Residual Amount in Currency
quantity numeric 0 √ null

Quantity
price_unit numeric 0 √ null

Unit Price
price_subtotal numeric 0 √ null

Subtotal
price_total numeric 0 √ null

Total
discount numeric 0 √ null

Discount (%)
discount_amount_currency numeric 0 √ null

Discount amount in Currency
discount_balance numeric 0 √ null

Discount Balance
tax_tag_invert bool 1 √ null

Invert Tags
reconciled bool 1 √ null

Reconciled
blocked bool 1 √ null

No Follow-up
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
purchase_line_id int4 10 √ null
purchase_order_line.id account_move_line_purchase_line_id_fkey N

Purchase Order Line
cogs_origin_id int4 10 √ null
account_move_line.id account_move_line_cogs_origin_id_fkey N

Cogs Origin
is_downpayment bool 1 √ null

Is Downpayment

Indexes

Constraint Name Type Sort Column(s)
account_move_line_pkey Primary key Asc id
account_move_line__cogs_origin_id_index Performance Asc cogs_origin_id
account_move_line__company_id_index Performance Asc company_id
account_move_line__date_maturity_index Performance Asc date_maturity
account_move_line__full_reconcile_id_index Performance Asc full_reconcile_id
account_move_line__group_tax_id_index Performance Asc group_tax_id
account_move_line__journal_id_index Performance Asc journal_id
account_move_line__matching_number_index Performance Asc matching_number
account_move_line__move_id_index Performance Asc move_id
account_move_line__move_name_index Performance Asc move_name
account_move_line__payment_id_index Performance Asc payment_id
account_move_line__purchase_line_id_index Performance Asc purchase_line_id
account_move_line__statement_id_index Performance Asc statement_id
account_move_line__statement_line_id_index Performance Asc statement_line_id
account_move_line__unreconciled_index Performance Asc/Asc account_id + partner_id
account_move_line_account_id_date_idx Performance Asc/Asc account_id + date
account_move_line_analytic_distribution_accounts_gin_index Performance
account_move_line_date_name_id_idx Performance Desc/Desc/Asc date + move_name + id
account_move_line_journal_id_neg_amnt_residual_idx Performance Asc journal_id
account_move_line_partner_id_ref_idx Performance Asc/Asc partner_id + ref

Check Constraints

Constraint Name Constraint
account_move_line_check_accountable_required_fields ((((display_type)::text = ANY ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR (account_id IS NOT NULL)))
account_move_line_check_amount_currency_balance_sign ((((display_type)::text = ANY ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR (((balance <= (0)::numeric) AND (amount_currency <= (0)::numeric)) OR ((balance >= (0)::numeric) AND (amount_currency >= (0)::numeric)))))
account_move_line_check_credit_debit ((((display_type)::text = ANY ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR ((credit * debit) = (0)::numeric)))
account_move_line_check_non_accountable_fields_null ((((display_type)::text <> ALL ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR ((amount_currency = (0)::numeric) AND (debit = (0)::numeric) AND (credit = (0)::numeric) AND (account_id IS NULL))))

Relationships

Close relationships within degrees of separation