invantive documentation
Invantive Support ForumsLog In / Sign Up

payment_register: Odoo itgen_odoo_payment_register

read only per partition

  • Catalog: Odoo
  • Schema: account
  • Label: itgen_odoo_payment_register

Register Payment

Can only retrieve data.

Table Columns

The columns of the table payment_register are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
amount numeric Amount
available_journal_ids varchar2
available_partner_bank_ids varchar2
available_payment_method_line_ids varchar2
can_edit_wizard boolean Can Edit Wizard
can_group_payments boolean Can Group Payments
communication varchar2 Memo
company_currency_id varchar2
company_currency_id_label varchar2
company_id varchar2
company_id_label varchar2
country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2 The payment's currency.
currency_id_label varchar2 The payment's currency.
display_name varchar2 Display Name
early_payment_discount_mode boolean Early Payment Discount Mode
group_payment boolean Group Payments Only one payment will be created by partner (bank), instead of one per billy.
hide_writeoff_section boolean Hide Writeoff Section
id int32 ID
journal_id varchar2
journal_id_label varchar2
line_ids varchar2
partner_bank_id varchar2
partner_bank_id_label varchar2
partner_id varchar2
partner_id_label varchar2
partner_type varchar2 Partner Type
payment_date datetime Payment Date
payment_difference numeric Payment Difference
payment_difference_handling varchar2 Payment Difference Handling
payment_method_code varchar2 Code
payment_method_line_id varchar2 Manual: Pay or Get paid by any method outside of Odoo. Payment Providers: Each payment provider has its own Payment Method. Request a transaction on/to a card thanks to a payment token saved by the partner when buying or subscribing online. Check: Pay bills by check and print it from Odoo. Batch Deposit: Collect several customer checks at once generating and submitting a batch deposit to your bank. Module account_batch_payment is necessary. SEPA Credit Transfer: Pay in the SEPA zone by submitting a SEPA Credit Transfer file to your bank. Module account_sepa is necessary. SEPA Direct Debit: Get paid in the SEPA zone thanks to a mandate your partner will have granted to you. Module account_sepa is necessary.
payment_method_line_id_label varchar2 Manual: Pay or Get paid by any method outside of Odoo. Payment Providers: Each payment provider has its own Payment Method. Request a transaction on/to a card thanks to a payment token saved by the partner when buying or subscribing online. Check: Pay bills by check and print it from Odoo. Batch Deposit: Collect several customer checks at once generating and submitting a batch deposit to your bank. Module account_batch_payment is necessary. SEPA Credit Transfer: Pay in the SEPA zone by submitting a SEPA Credit Transfer file to your bank. Module account_sepa is necessary. SEPA Direct Debit: Get paid in the SEPA zone thanks to a mandate your partner will have granted to you. Module account_sepa is necessary.
payment_token_id varchar2 Note that tokens from providers set to only authorize transactions (instead of capturing the amount) are not available.
payment_token_id_label varchar2 Note that tokens from providers set to only authorize transactions (instead of capturing the amount) are not available.
payment_type varchar2 Payment Type
require_partner_bank_account boolean Require Partner Bank Account
show_partner_bank_account boolean Show Partner Bank Account
source_amount numeric Amount to Pay (company currency)
source_amount_currency numeric Amount to Pay (foreign currency)
source_currency_id varchar2
source_currency_id_label varchar2
suitable_payment_token_ids varchar2
use_electronic_payment_method boolean Use Electronic Payment Method
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
writeoff_account_id varchar2
writeoff_account_id_label varchar2
writeoff_label varchar2 Journal Item Label Change label of the counterpart that will hold the payment difference

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: