account_partial_reconcile

-1 rows


Description

Partial Reconcile

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_partial_reconcile_id_seq'::regclass)
account_move.tax_cash_basis_rec_id account_move_tax_cash_basis_rec_id_fkey N
debit_move_id int4 10 null
account_move_line.id account_partial_reconcile_debit_move_id_fkey R

Debit Move
credit_move_id int4 10 null
account_move_line.id account_partial_reconcile_credit_move_id_fkey R

Credit Move
full_reconcile_id int4 10 √ null
account_full_reconcile.id account_partial_reconcile_full_reconcile_id_fkey N

Full Reconcile
exchange_move_id int4 10 √ null
account_move.id account_partial_reconcile_exchange_move_id_fkey N

Exchange Move
debit_currency_id int4 10 √ null
res_currency.id account_partial_reconcile_debit_currency_id_fkey N

Currency of the debit journal item.
credit_currency_id int4 10 √ null
res_currency.id account_partial_reconcile_credit_currency_id_fkey N

Currency of the credit journal item.
company_id int4 10 √ null
res_company.id account_partial_reconcile_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id account_partial_reconcile_create_uid_fkey N

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

Last Updated by
max_date date 13 √ null

Max Date of Matched Lines
amount numeric 0 √ null

Amount
debit_amount_currency numeric 0 √ null

Debit Amount Currency
credit_amount_currency numeric 0 √ null

Credit Amount Currency
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
account_partial_reconcile_pkey Primary key Asc id
account_partial_reconcile__credit_move_id_index Performance Asc credit_move_id
account_partial_reconcile__debit_move_id_index Performance Asc debit_move_id
account_partial_reconcile__exchange_move_id_index Performance Asc exchange_move_id
account_partial_reconcile__full_reconcile_id_index Performance Asc full_reconcile_id

Relationships

Close relationships within degrees of separation