payment |
Point of Sale Payments
Catalog: Odoo
Schema: pos
Documentation:
Used to register payments made in a pos.order.
See `payment_ids` field of pos.order model.
The main characteristics of pos.payment can be read from
`payment_method_id`.
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 are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_move_id_label |
string |
|
☐ |
|
account_move_id |
string |
|
☐ |
|
amount |
decimal |
Amount |
☑ |
Total amount of the payment. |
card_type |
string |
Type of card used |
☐ |
|
cardholder_name |
string |
Cardholder Name |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
currency_rate |
decimal |
Conversion Rate |
☐ |
Conversion rate from company currency to order currency. |
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
is_change |
boolean |
Is this payment change? |
☐ |
|
name |
string |
Label |
☐ |
|
partner_id_label |
string |
|
☐ |
|
partner_id |
string |
|
☐ |
|
payment_date |
datetime |
Date |
☑ |
|
payment_method_id_label |
string |
|
☐ |
|
payment_method_id |
string |
|
☐ |
|
payment_status |
string |
Payment Status |
☐ |
|
pos_order_id_label |
string |
|
☐ |
|
pos_order_id |
string |
|
☐ |
|
session_id_label |
string |
|
☐ |
|
session_id |
string |
|
☐ |
|
ticket |
string |
Payment Receipt Info |
☐ |
|
transaction_id |
string |
Payment Transaction ID |
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826