payment_register |
Register Payment
Catalog: Odoo
Schema: account
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table payment_register are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amount |
decimal |
Amount |
☐ |
|
available_journal_ids |
string |
|
☐ |
|
available_partner_bank_ids |
string |
|
☐ |
|
available_payment_method_line_ids |
string |
|
☐ |
|
can_edit_wizard |
boolean |
Can Edit Wizard |
☐ |
|
can_group_payments |
boolean |
Can Group Payments |
☐ |
|
communication |
string |
Memo |
☐ |
|
company_currency_id_label |
string |
|
☐ |
|
company_currency_id |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
country_code |
string |
Country Code |
☐ |
The ISO country code in two chars. You can use this field for quick search. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
The payment's currency. |
currency_id |
string |
|
☐ |
The payment's currency. |
display_name |
string |
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_label |
string |
|
☐ |
|
journal_id |
string |
|
☐ |
|
line_ids |
string |
|
☐ |
|
partner_bank_id_label |
string |
|
☐ |
|
partner_bank_id |
string |
|
☐ |
|
partner_id_label |
string |
|
☐ |
|
partner_id |
string |
|
☐ |
|
partner_type |
string |
Partner Type |
☐ |
|
payment_date |
datetime |
Payment Date |
☑ |
|
payment_difference_handling |
string |
Payment Difference Handling |
☐ |
|
payment_difference |
decimal |
Payment Difference |
☐ |
|
payment_method_code |
string |
Code |
☐ |
|
payment_method_line_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_label |
string |
|
☐ |
Note that tokens from providers set to only authorize transactions (instead of capturing the amount) are not available. |
payment_token_id |
string |
|
☐ |
Note that tokens from providers set to only authorize transactions (instead of capturing the amount) are not available. |
payment_type |
string |
Payment Type |
☐ |
|
require_partner_bank_account |
boolean |
Require Partner Bank Account |
☐ |
|
show_partner_bank_account |
boolean |
Show Partner Bank Account |
☐ |
|
source_amount_currency |
decimal |
Amount to Pay (foreign currency) |
☐ |
|
source_amount |
decimal |
Amount to Pay (company currency) |
☐ |
|
source_currency_id_label |
string |
|
☐ |
|
source_currency_id |
string |
|
☐ |
|
suitable_payment_token_ids |
string |
|
☐ |
|
use_electronic_payment_method |
boolean |
Use Electronic Payment Method |
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
writeoff_account_id_label |
string |
|
☐ |
|
writeoff_account_id |
string |
|
☐ |
|
writeoff_label |
string |
Journal Item Label |
☐ |
Change label of the counterpart that will hold the payment difference |
01-03-2023 15:29 Version 22.1.135-BETA+3826