res_partner_bank

-1 rows


Description

Bank Accounts

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_partner_bank_id_seq'::regclass)
account_journal.bank_account_id account_journal_bank_account_id_fkey R
account_move.partner_bank_id account_move_partner_bank_id_fkey R
account_payment.partner_bank_id account_payment_partner_bank_id_fkey R
account_payment_register.partner_bank_id account_payment_register_partner_bank_id_fkey N
account_setup_bank_manual_config.res_partner_bank_id account_setup_bank_manual_config_res_partner_bank_id_fkey C
partner_id int4 10 null
res_partner.id res_partner_bank_partner_id_fkey C

Account Holder
bank_id int4 10 √ null
res_bank.id res_partner_bank_bank_id_fkey N

Bank
sequence int4 10 √ null

Sequence
currency_id int4 10 √ null
res_currency.id res_partner_bank_currency_id_fkey N

Currency
company_id int4 10 √ null
res_company.id res_partner_bank_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id res_partner_bank_create_uid_fkey N

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

Last Updated by
acc_number varchar 2147483647 null

Account Number
sanitized_acc_number varchar 2147483647 √ null

Sanitized Account Number
acc_holder_name varchar 2147483647 √ null

Account Holder Name
active bool 1 √ null

Active
allow_out_payment bool 1 √ null

Send Money
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
has_iban_warning bool 1 √ null

Has Iban Warning
has_money_transfer_warning bool 1 √ null

Has Money Transfer Warning

Indexes

Constraint Name Type Sort Column(s)
res_partner_bank_pkey Primary key Asc id
res_partner_bank__partner_id_index Performance Asc partner_id
res_partner_bank_unique_number Must be unique Asc/Asc sanitized_acc_number + partner_id

Relationships

Close relationships within degrees of separation