account_bank_statement

-1 rows


Description

Bank Statement

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_bank_statement_id_seq'::regclass)
account_bank_statement_ir_attachment_rel.account_bank_statement_id account_bank_statement_ir_attach_account_bank_statement_id_fkey C
account_bank_statement_line.statement_id account_bank_statement_line_statement_id_fkey N
account_move_line.statement_id account_move_line_statement_id_fkey N
company_id int4 10 √ null
res_company.id account_bank_statement_company_id_fkey N

Company
journal_id int4 10 √ null
account_journal.id account_bank_statement_journal_id_fkey N

Journal
create_uid int4 10 √ null
res_users.id account_bank_statement_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 √ null

Reference
reference varchar 2147483647 √ null

External Reference
first_line_index varchar 2147483647 √ null

First Line Index
date date 13 √ null

Date
balance_start numeric 0 √ null

Starting Balance
balance_end numeric 0 √ null

Computed Balance
balance_end_real numeric 0 √ null

Ending Balance
is_complete bool 1 √ null

Is Complete
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_bank_statement_pkey Primary key Asc id
account_bank_statement__date_index Performance Asc date
account_bank_statement__first_line_index_index Performance Asc first_line_index
account_bank_statement_journal_id_date_desc_id_desc_idx Performance Asc/Desc/Desc journal_id + date + id

Relationships

Close relationships within degrees of separation