account_move

24 rows


Description

Journal Entry

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_move_id_seq'::regclass)
account_bank_statement_line.move_id account_bank_statement_line_move_id_fkey C
account_full_reconcile.exchange_move_id account_full_reconcile_exchange_move_id_fkey N
account_invoice_transaction_rel.invoice_id account_invoice_transaction_rel_invoice_id_fkey C
account_move.auto_post_origin_id account_move_auto_post_origin_id_fkey N
account_move.reversed_entry_id account_move_reversed_entry_id_fkey N
account_move.tax_cash_basis_origin_move_id account_move_tax_cash_basis_origin_move_id_fkey N
account_move_account_move_send_rel.account_move_id account_move_account_move_send_rel_account_move_id_fkey C
account_move_account_resequence_wizard_rel.account_move_id account_move_account_resequence_wizard_rel_account_move_id_fkey C
account_move_line.move_id account_move_line_move_id_fkey C
account_move_purchase_order_rel.account_move_id account_move_purchase_order_rel_account_move_id_fkey C
account_move_reversal_move.move_id account_move_reversal_move_move_id_fkey C
account_move_reversal_new_move.new_move_id account_move_reversal_new_move_new_move_id_fkey C
account_partial_reconcile.exchange_move_id account_partial_reconcile_exchange_move_id_fkey N
account_payment.move_id account_payment_move_id_fkey C
res_company.account_opening_move_id res_company_account_opening_move_id_fkey N
stock_valuation_layer.account_move_id stock_valuation_layer_account_move_id_fkey N
sequence_number int4 10 √ null

Sequence Number
message_main_attachment_id int4 10 √ null
ir_attachment.id account_move_message_main_attachment_id_fkey N

Main Attachment
journal_id int4 10 null
account_journal.id account_move_journal_id_fkey R

Journal
company_id int4 10 √ null
res_company.id account_move_company_id_fkey N

Company
payment_id int4 10 √ null
account_payment.id account_move_payment_id_fkey N

Payment
statement_line_id int4 10 √ null
account_bank_statement_line.id account_move_statement_line_id_fkey N

Statement Line
tax_cash_basis_rec_id int4 10 √ null
account_partial_reconcile.id account_move_tax_cash_basis_rec_id_fkey N

Tax Cash Basis Entry of
tax_cash_basis_origin_move_id int4 10 √ null
account_move.id account_move_tax_cash_basis_origin_move_id_fkey N

Cash Basis Origin
auto_post_origin_id int4 10 √ null
account_move.id account_move_auto_post_origin_id_fkey N

First recurring entry
secure_sequence_number int4 10 √ null

Inalteralbility No Gap Sequence #
invoice_payment_term_id int4 10 √ null
account_payment_term.id account_move_invoice_payment_term_id_fkey N

Payment Terms
partner_id int4 10 √ null
res_partner.id account_move_partner_id_fkey R

Partner
commercial_partner_id int4 10 √ null
res_partner.id account_move_commercial_partner_id_fkey R

Commercial Entity
partner_shipping_id int4 10 √ null
res_partner.id account_move_partner_shipping_id_fkey N

Delivery Address
partner_bank_id int4 10 √ null
res_partner_bank.id account_move_partner_bank_id_fkey R

Recipient Bank
fiscal_position_id int4 10 √ null
account_fiscal_position.id account_move_fiscal_position_id_fkey R

Fiscal Position
currency_id int4 10 null
res_currency.id account_move_currency_id_fkey R

Currency
reversed_entry_id int4 10 √ null
account_move.id account_move_reversed_entry_id_fkey N

Reversal of
invoice_user_id int4 10 √ null
res_users.id account_move_invoice_user_id_fkey N

Salesperson
invoice_incoterm_id int4 10 √ null
account_incoterms.id account_move_invoice_incoterm_id_fkey N

Incoterm
invoice_cash_rounding_id int4 10 √ null
account_cash_rounding.id account_move_invoice_cash_rounding_id_fkey N

Cash Rounding Method
create_uid int4 10 √ null
res_users.id account_move_create_uid_fkey N

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

Last Updated by
sequence_prefix varchar 2147483647 √ null

Sequence Prefix
access_token varchar 2147483647 √ null

Security Token
name varchar 2147483647 √ null

Number
ref varchar 2147483647 √ null

Reference
state varchar 2147483647 null

Status
move_type varchar 2147483647 null

Type
auto_post varchar 2147483647 null

Auto-post
inalterable_hash varchar 2147483647 √ null

Inalterability Hash
payment_reference varchar 2147483647 √ null

Payment Reference
qr_code_method varchar 2147483647 √ null

Payment QR-code
payment_state varchar 2147483647 √ null

Payment Status
invoice_source_email varchar 2147483647 √ null

Source Email
invoice_partner_display_name varchar 2147483647 √ null

Invoice Partner Display Name
invoice_origin varchar 2147483647 √ null

Origin
incoterm_location varchar 2147483647 √ null

Incoterm Location
date date 13 null

Date
auto_post_until date 13 √ null

Auto-post until
invoice_date date 13 √ null

Invoice/Bill Date
invoice_date_due date 13 √ null

Due Date
delivery_date date 13 √ null

Delivery Date
send_and_print_values jsonb 2147483647 √ null

Send And Print Values
narration text 2147483647 √ null

Terms and Conditions
amount_untaxed numeric 0 √ null

Untaxed Amount
amount_tax numeric 0 √ null

Tax
amount_total numeric 0 √ null

Total
amount_residual numeric 0 √ null

Amount Due
amount_untaxed_signed numeric 0 √ null

Untaxed Amount Signed
amount_tax_signed numeric 0 √ null

Tax Signed
amount_total_signed numeric 0 √ null

Total Signed
amount_total_in_currency_signed numeric 0 √ null

Total in Currency Signed
amount_residual_signed numeric 0 √ null

Amount Due Signed
quick_edit_total_amount numeric 0 √ null

Total (Tax inc.)
is_storno bool 1 √ null

Is Storno
always_tax_exigible bool 1 √ null

Always Tax Exigible
to_check bool 1 √ null

To Check
posted_before bool 1 √ null

Posted Before
is_move_sent bool 1 √ null

Is Move Sent
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
stock_move_id int4 10 √ null
stock_move.id account_move_stock_move_id_fkey N

Stock Move
campaign_id int4 10 √ null
utm_campaign.id account_move_campaign_id_fkey N

Campaign
source_id int4 10 √ null
utm_source.id account_move_source_id_fkey N

Source
medium_id int4 10 √ null
utm_medium.id account_move_medium_id_fkey N

Medium
team_id int4 10 √ null
crm_team.id account_move_team_id_fkey N

Sales Team
preferred_payment_method_id int4 10 √ null
account_payment_method.id account_move_preferred_payment_method_id_fkey N

Indexes

Constraint Name Type Sort Column(s)
account_move_pkey Primary key Asc id
account_move__auto_post_origin_id_index Performance Asc auto_post_origin_id
account_move__campaign_id_index Performance Asc campaign_id
account_move__company_id_index Performance Asc company_id
account_move__date_index Performance Asc date
account_move__invoice_date_due_index Performance Asc invoice_date_due
account_move__invoice_date_index Performance Asc invoice_date
account_move__medium_id_index Performance Asc medium_id
account_move__move_type_index Performance Asc move_type
account_move__partner_id_index Performance Asc partner_id
account_move__payment_id_index Performance Asc payment_id
account_move__reversed_entry_id_index Performance Asc reversed_entry_id
account_move__secure_sequence_number_index Performance Asc secure_sequence_number
account_move__source_id_index Performance Asc source_id
account_move__statement_line_id_index Performance Asc statement_line_id
account_move__stock_move_id_index Performance Asc stock_move_id
account_move__tax_cash_basis_origin_move_id_index Performance Asc tax_cash_basis_origin_move_id
account_move__tax_cash_basis_rec_id_index Performance Asc tax_cash_basis_rec_id
account_move_journal_id_company_id_idx Performance Asc/Asc/Asc journal_id + company_id + date
account_move_payment_idx Performance Asc/Asc/Asc/Asc/Asc journal_id + state + payment_state + move_type + date
account_move_sequence_index Performance Asc/Desc/Desc/Asc journal_id + sequence_prefix + sequence_number + name
account_move_sequence_index2 Performance Asc/Desc/Asc journal_id + id + sequence_prefix
account_move_sequence_index3 Performance Asc/Desc journal_id + sequence_prefix
account_move_to_check_idx Performance Asc journal_id
account_move_unique_name Must be unique Asc/Asc name + journal_id

Relationships

Close relationships within degrees of separation