payment_transaction

-1 rows


Description

Payment Transaction

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('payment_transaction_id_seq'::regclass)
account_invoice_transaction_rel.transaction_id account_invoice_transaction_rel_transaction_id_fkey C
account_payment.payment_transaction_id account_payment_payment_transaction_id_fkey N
payment_capture_wizard_payment_transaction_rel.payment_transaction_id payment_capture_wizard_payment_tran_payment_transaction_id_fkey C
payment_transaction.source_transaction_id payment_transaction_source_transaction_id_fkey N
sale_order_transaction_rel.transaction_id sale_order_transaction_rel_transaction_id_fkey C
provider_id int4 10 null
payment_provider.id payment_transaction_provider_id_fkey R

Provider
company_id int4 10 √ null
res_company.id payment_transaction_company_id_fkey N

Company
payment_method_id int4 10 null
payment_method.id payment_transaction_payment_method_id_fkey R

Payment Method
currency_id int4 10 null
res_currency.id payment_transaction_currency_id_fkey R

Currency
token_id int4 10 √ null
payment_token.id payment_transaction_token_id_fkey R

Payment Token
source_transaction_id int4 10 √ null
payment_transaction.id payment_transaction_source_transaction_id_fkey N

Source Transaction
callback_model_id int4 10 √ null
ir_model.id payment_transaction_callback_model_id_fkey N

Callback Document Model
callback_res_id int4 10 √ null

Callback Record ID
partner_id int4 10 null
res_partner.id payment_transaction_partner_id_fkey R

Customer
partner_state_id int4 10 √ null
res_country_state.id payment_transaction_partner_state_id_fkey N

State
partner_country_id int4 10 √ null
res_country.id payment_transaction_partner_country_id_fkey N

Country
create_uid int4 10 √ null
res_users.id payment_transaction_create_uid_fkey N

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

Last Updated by
reference varchar 2147483647 null

Reference
provider_reference varchar 2147483647 √ null

Provider Reference
state varchar 2147483647 null

Status
operation varchar 2147483647 √ null

Operation
landing_route varchar 2147483647 √ null

Landing Route
callback_method varchar 2147483647 √ null

Callback Method
callback_hash varchar 2147483647 √ null

Callback Hash
partner_name varchar 2147483647 √ null

Partner Name
partner_lang varchar 2147483647 √ null

Language
partner_email varchar 2147483647 √ null

Email
partner_address varchar 2147483647 √ null

Address
partner_zip varchar 2147483647 √ null

Zip
partner_city varchar 2147483647 √ null

City
partner_phone varchar 2147483647 √ null

Phone
state_message text 2147483647 √ null

Message
amount numeric 0 null

Amount
is_post_processed bool 1 √ null

Is Post-processed
tokenize bool 1 √ null

Create Token
callback_is_done bool 1 √ null

Callback Done
last_state_change timestamp 29,6 √ null

Last State Change Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
payment_id int4 10 √ null
account_payment.id payment_transaction_payment_id_fkey N

Payment

Indexes

Constraint Name Type Sort Column(s)
payment_transaction_pkey Primary key Asc id
payment_transaction__company_id_index Performance Asc company_id
payment_transaction__operation_index Performance Asc operation
payment_transaction__state_index Performance Asc state
payment_transaction_reference_uniq Must be unique Asc reference

Relationships

Close relationships within degrees of separation