payment_method |
Point of Sale Payment Methods
Catalog: Odoo
Schema: pos
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_method are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
config_ids |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
hide_use_payment_terminal |
boolean |
Hide Use Payment Terminal |
☐ |
|
id |
int32 |
ID |
☐ |
|
image |
byte[] |
Image |
☐ |
|
iot_device_id_label |
string |
|
☐ |
|
iot_device_id |
string |
|
☐ |
|
is_cash_count |
boolean |
Cash |
☐ |
|
journal_id_label |
string |
|
☐ |
Leave empty to use the receivable account of customer.Defines the journal where to book the accumulated payments (or individual payment if Identify Customer is true) after closing the session.For cash journal, we directly write to the default account in the journal via statement lines.For bank journal, we write to the outstanding account specified in this payment method.Only cash and bank journals are allowed. |
journal_id |
string |
|
☐ |
Leave empty to use the receivable account of customer.Defines the journal where to book the accumulated payments (or individual payment if Identify Customer is true) after closing the session.For cash journal, we directly write to the default account in the journal via statement lines.For bank journal, we write to the outstanding account specified in this payment method.Only cash and bank journals are allowed. |
name |
string |
Method |
☑ |
Defines the name of the payment method that will be displayed in the Point of Sale when the payments are selected. |
open_session_ids |
string |
|
☐ |
Open PoS sessions that are using this payment method. |
outstanding_account_id_label |
string |
|
☐ |
Leave empty to use the default account from the company setting.Account used as outstanding account when creating accounting payment records for bank payments. |
outstanding_account_id |
string |
|
☐ |
Leave empty to use the default account from the company setting.Account used as outstanding account when creating accounting payment records for bank payments. |
payment_terminal_ids |
string |
|
☐ |
|
receivable_account_id_label |
string |
|
☐ |
Leave empty to use the default account from the company setting.Overrides the company's receivable account (for Point of Sale) used in the journal entries. |
receivable_account_id |
string |
|
☐ |
Leave empty to use the default account from the company setting.Overrides the company's receivable account (for Point of Sale) used in the journal entries. |
split_transactions |
boolean |
Identify Customer |
☐ |
Forces to set a customer when using this payment method and splits the journal entries for each customer. It could slow down the closing process. |
type |
string |
Type |
☐ |
|
use_payment_terminal |
string |
Use a Payment Terminal |
☐ |
Record payments with a terminal on this journal. |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826