account_payment

-1 rows


Description

Payments

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_payment_id_seq'::regclass)
account_move.payment_id account_move_payment_id_fkey N
account_move_line.payment_id account_move_line_payment_id_fkey N
account_payment.paired_internal_transfer_payment_id account_payment_paired_internal_transfer_payment_id_fkey N
account_payment.source_payment_id account_payment_source_payment_id_fkey N
account_payment_account_bank_statement_line_rel.account_payment_id account_payment_account_bank_statement__account_payment_id_fkey C
payment_refund_wizard.payment_id payment_refund_wizard_payment_id_fkey N
payment_transaction.payment_id payment_transaction_payment_id_fkey N
message_main_attachment_id int4 10 √ null
ir_attachment.id account_payment_message_main_attachment_id_fkey N

Main Attachment
move_id int4 10 null
account_move.id account_payment_move_id_fkey C

Journal Entry
partner_bank_id int4 10 √ null
res_partner_bank.id account_payment_partner_bank_id_fkey R

Recipient Bank Account
paired_internal_transfer_payment_id int4 10 √ null
account_payment.id account_payment_paired_internal_transfer_payment_id_fkey N

Paired Internal Transfer Payment
payment_method_line_id int4 10 √ null
account_payment_method_line.id account_payment_payment_method_line_id_fkey N

Payment Method
payment_method_id int4 10 √ null
account_payment_method.id account_payment_payment_method_id_fkey N

Method
currency_id int4 10 √ null
res_currency.id account_payment_currency_id_fkey N

Currency
partner_id int4 10 √ null
res_partner.id account_payment_partner_id_fkey R

Customer/Vendor
outstanding_account_id int4 10 √ null
account_account.id account_payment_outstanding_account_id_fkey N

Outstanding Account
destination_account_id int4 10 √ null
account_account.id account_payment_destination_account_id_fkey N

Destination Account
destination_journal_id int4 10 √ null
account_journal.id account_payment_destination_journal_id_fkey N

Destination Journal
create_uid int4 10 √ null
res_users.id account_payment_create_uid_fkey N

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

Last Updated by
payment_type varchar 2147483647 null

Payment Type
partner_type varchar 2147483647 null

Partner Type
payment_reference varchar 2147483647 √ null

Payment Reference
amount numeric 0 √ null

Amount
amount_company_currency_signed numeric 0 √ null

Amount Company Currency Signed
is_reconciled bool 1 √ null

Is Reconciled
is_matched bool 1 √ null

Is Matched With a Bank Statement
is_internal_transfer bool 1 √ null

Internal Transfer
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
payment_transaction_id int4 10 √ null
payment_transaction.id account_payment_payment_transaction_id_fkey N

Payment Transaction
payment_token_id int4 10 √ null
payment_token.id account_payment_payment_token_id_fkey N

Saved Payment Token
source_payment_id int4 10 √ null
account_payment.id account_payment_source_payment_id_fkey N

Source Payment
check_number varchar 2147483647 √ null
check_amount_in_words varchar 2147483647 √ null

Amount in Words

Indexes

Constraint Name Type Sort Column(s)
account_payment_pkey Primary key Asc id
account_payment__move_id_index Performance Asc move_id
account_payment__outstanding_account_id_index Performance Asc outstanding_account_id
account_payment__paired_internal_transfer_payment_id_index Performance Asc paired_internal_transfer_payment_id
account_payment__payment_method_line_id_index Performance Asc payment_method_line_id
account_payment__source_payment_id_index Performance Asc source_payment_id

Check Constraints

Constraint Name Constraint
account_payment_check_amount_not_negative ((amount >= 0.0))

Relationships

Close relationships within degrees of separation