account_bank_statement_line

-1 rows


Description

Bank Statement Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_bank_statement_line_id_seq'::regclass)
account_move.statement_line_id account_move_statement_line_id_fkey N
account_move_line.statement_line_id account_move_line_statement_line_id_fkey N
account_payment_account_bank_statement_line_rel.account_bank_statement_line_id account_payment_account_bank__account_bank_statement_line__fkey C
move_id int4 10 null
account_move.id account_bank_statement_line_move_id_fkey C

Journal Entry
statement_id int4 10 √ null
account_bank_statement.id account_bank_statement_line_statement_id_fkey N

Statement
sequence int4 10 √ null

Sequence
partner_id int4 10 √ null
res_partner.id account_bank_statement_line_partner_id_fkey R

Partner
currency_id int4 10 √ null
res_currency.id account_bank_statement_line_currency_id_fkey N

Journal Currency
foreign_currency_id int4 10 √ null
res_currency.id account_bank_statement_line_foreign_currency_id_fkey N

Foreign Currency
create_uid int4 10 √ null
res_users.id account_bank_statement_line_create_uid_fkey N

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

Last Updated by
account_number varchar 2147483647 √ null

Bank Account Number
partner_name varchar 2147483647 √ null

Partner Name
transaction_type varchar 2147483647 √ null

Transaction Type
payment_ref varchar 2147483647 √ null

Label
internal_index varchar 2147483647 √ null

Internal Reference
transaction_details jsonb 2147483647 √ null

Transaction Details
amount numeric 0 √ null

Amount
amount_currency numeric 0 √ null

Amount in Currency
is_reconciled bool 1 √ null

Is Reconciled
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
amount_residual float8 17,17 √ null

Residual Amount

Indexes

Constraint Name Type Sort Column(s)
account_bank_statement_line_pkey Primary key Asc id
account_bank_statement_line__internal_index_index Performance Asc internal_index
account_bank_statement_line__move_id_index Performance Asc move_id
account_bank_statement_line_internal_index_move_id_amount_idx Performance Asc/Asc/Asc internal_index + move_id + amount

Relationships

Close relationships within degrees of separation