account_payment_register

-1 rows


Description

Register Payment

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_payment_register_id_seq'::regclass)
account_payment_register_move_line_rel.wizard_id account_payment_register_move_line_rel_wizard_id_fkey C
currency_id int4 10 √ null
res_currency.id account_payment_register_currency_id_fkey N

Currency
journal_id int4 10 √ null
account_journal.id account_payment_register_journal_id_fkey N

Journal
partner_bank_id int4 10 √ null
res_partner_bank.id account_payment_register_partner_bank_id_fkey N

Recipient Bank Account
source_currency_id int4 10 √ null
res_currency.id account_payment_register_source_currency_id_fkey N

Source Currency
company_id int4 10 √ null
res_company.id account_payment_register_company_id_fkey N

Company
partner_id int4 10 √ null
res_partner.id account_payment_register_partner_id_fkey R

Customer/Vendor
payment_method_line_id int4 10 √ null
account_payment_method_line.id account_payment_register_payment_method_line_id_fkey N

Payment Method
writeoff_account_id int4 10 √ null
account_account.id account_payment_register_writeoff_account_id_fkey N

Difference Account
create_uid int4 10 √ null
res_users.id account_payment_register_create_uid_fkey N

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

Last Updated by
communication varchar 2147483647 √ null

Memo
payment_type varchar 2147483647 √ null

Payment Type
partner_type varchar 2147483647 √ null

Partner Type
payment_difference_handling varchar 2147483647 √ null

Payment Difference Handling
writeoff_label varchar 2147483647 √ null

Journal Item Label
payment_date date 13 null

Payment Date
amount numeric 0 √ null

Amount
source_amount numeric 0 √ null

Amount to Pay (company currency)
source_amount_currency numeric 0 √ null

Amount to Pay (foreign currency)
group_payment bool 1 √ null

Group Payments
can_edit_wizard bool 1 √ null

Can Edit Wizard
can_group_payments bool 1 √ null

Can Group Payments
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
payment_token_id int4 10 √ null
payment_token.id account_payment_register_payment_token_id_fkey N

Saved payment token

Indexes

Constraint Name Type Sort Column(s)
account_payment_register_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation