config |
Point of Sale Configuration
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 config are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
amount_authorized_diff |
decimal |
Amount Authorized Difference |
☐ |
This field depicts the maximum difference allowed between the ending balance and the theoretical cash when closing a session, for non-POS managers. If this maximum is reached, the user will have an error message at the closing of his session saying that he needs to contact his manager. |
auto_validate_terminal_payment |
boolean |
Auto Validate Terminal Payment |
☐ |
Automatically validates orders paid with a payment terminal. |
available_pricelist_ids |
string |
|
☐ |
Make several pricelists available in the Point of Sale. You can also apply a pricelist to specific customers from their contact form (in Sales tab). To be valid, this pricelist must be listed here as an available pricelist. Otherwise the default pricelist will apply. |
cash_control |
boolean |
Advanced Cash Control |
☐ |
Check the amount of the cashbox at opening and closing. |
cash_rounding |
boolean |
Cash Rounding |
☐ |
|
company_has_template |
boolean |
Company has chart of accounts |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
crm_team_id_label |
string |
|
☐ |
This Point of sale's sales will be related to this Sales Team. |
crm_team_id |
string |
|
☐ |
This Point of sale's sales will be related to this Sales Team. |
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
current_session_id_label |
string |
|
☐ |
|
current_session_id |
string |
|
☐ |
|
current_session_state |
string |
Current Session State |
☐ |
|
current_user_id_label |
string |
|
☐ |
|
current_user_id |
string |
|
☐ |
|
default_bill_ids |
string |
|
☐ |
|
default_fiscal_position_id_label |
string |
|
☐ |
|
default_fiscal_position_id |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
down_payment_product_id_label |
string |
|
☐ |
This product will be used as down payment on a sale order. |
down_payment_product_id |
string |
|
☐ |
This product will be used as down payment on a sale order. |
employee_ids |
string |
|
☐ |
If left empty, all employees can log in to the PoS session |
epson_printer_ip |
string |
Epson Printer IP |
☐ |
Local IP address of an Epson receipt printer. |
fiscal_position_ids |
string |
|
☐ |
This is useful for restaurants with onsite and take-away services that imply specific tax rates. |
group_pos_manager_id_label |
string |
|
☐ |
This field is there to pass the id of the pos manager group to the point of sale client. |
group_pos_manager_id |
string |
|
☐ |
This field is there to pass the id of the pos manager group to the point of sale client. |
group_pos_user_id_label |
string |
|
☐ |
This field is there to pass the id of the pos user group to the point of sale client. |
group_pos_user_id |
string |
|
☐ |
This field is there to pass the id of the pos user group to the point of sale client. |
has_active_session |
boolean |
Has Active Session |
☐ |
|
id |
int32 |
ID |
☐ |
|
iface_available_categ_ids |
string |
|
☐ |
The point of sale will only display products which are within one of the selected category trees. If no category is specified, all available products will be shown |
iface_big_scrollbars |
boolean |
Large Scrollbars |
☐ |
For imprecise industrial touchscreens. |
iface_cashdrawer |
boolean |
Cashdrawer |
☐ |
Automatically open the cashdrawer. |
iface_customer_facing_display_local |
boolean |
Local Customer Facing Display |
☐ |
Show checkout to customers. |
iface_customer_facing_display_via_proxy |
boolean |
Customer Facing Display |
☐ |
Show checkout to customers with a remotely-connected screen. |
iface_customer_facing_display |
boolean |
Iface Customer Facing Display |
☐ |
|
iface_display_id_label |
string |
|
☐ |
|
iface_display_id |
string |
|
☐ |
|
iface_electronic_scale |
boolean |
Electronic Scale |
☐ |
Enables Electronic Scale integration. |
iface_print_auto |
boolean |
Automatic Receipt Printing |
☐ |
The receipt will automatically be printed at the end of each order. |
iface_print_skip_screen |
boolean |
Skip Preview Screen |
☐ |
The receipt screen will be skipped if the receipt can be printed automatically. |
iface_print_via_proxy |
boolean |
Print via Proxy |
☐ |
Bypass browser printing and prints via the hardware proxy. |
iface_printer_id_label |
string |
|
☐ |
|
iface_printer_id |
string |
|
☐ |
|
iface_scale_id_label |
string |
|
☐ |
|
iface_scale_id |
string |
|
☐ |
|
iface_scan_via_proxy |
boolean |
Scan via Proxy |
☐ |
Enable barcode scanning with a remotely connected barcode scanner and card swiping with a Vantiv card reader. |
iface_scanner_ids |
string |
|
☐ |
Enable barcode scanning with a remotely connected barcode scanner and card swiping with a Vantiv card reader. |
iface_start_categ_id_label |
string |
|
☐ |
The point of sale will display this product category by default. If no category is specified, all available products will be shown. |
iface_start_categ_id |
string |
|
☐ |
The point of sale will display this product category by default. If no category is specified, all available products will be shown. |
iface_tax_included |
string |
Tax Display |
☑ |
|
iface_tipproduct |
boolean |
Product tips |
☐ |
|
invoice_journal_id_label |
string |
|
☐ |
Accounting journal used to create invoices. |
invoice_journal_id |
string |
|
☐ |
Accounting journal used to create invoices. |
iot_device_ids |
string |
|
☐ |
|
is_header_or_footer |
boolean |
Custom Header & Footer |
☐ |
|
is_installed_account_accountant |
boolean |
Is the Full Accounting Installed |
☐ |
|
is_margins_costs_accessible_to_every_user |
boolean |
Margins & Costs |
☐ |
When disabled, only PoS manager can view the margin and cost of product among the Product info. |
is_posbox |
boolean |
PosBox |
☐ |
|
journal_id_label |
string |
|
☐ |
Accounting journal used to post POS session journal entries and POS invoice payments. |
journal_id |
string |
|
☐ |
Accounting journal used to post POS session journal entries and POS invoice payments. |
last_session_closing_cash |
decimal |
Last Session Closing Cash |
☐ |
|
last_session_closing_date |
datetime |
Last Session Closing Date |
☐ |
|
limit_categories |
boolean |
Restrict Categories |
☐ |
|
limited_partners_amount |
int32 |
Limited Partners Amount |
☐ |
|
limited_partners_loading |
boolean |
Limited Partners Loading |
☐ |
By default, 100 partners are loaded.When the session is open, we keep on loading all remaining partners in the background.In the meantime, you can use the 'Load Customers' button to load partners from database. |
limited_products_amount |
int32 |
Limited Products Amount |
☐ |
|
limited_products_loading |
boolean |
Limited Product Loading |
☐ |
we load all starred products (favorite), all services, recent inventory movements of products, and the most recently updated products.When the session is open, we keep on loading all remaining products in the background.In the meantime, you can click on the 'database icon' in the searchbar to load products from database. |
manual_discount |
boolean |
Line Discounts |
☐ |
|
module_pos_discount |
boolean |
Global Discounts |
☐ |
|
module_pos_hr |
boolean |
Module Pos Hr |
☐ |
Show employee login screen |
module_pos_iot |
boolean |
IoT Box |
☐ |
|
module_pos_mercury |
boolean |
Integrated Card Payments |
☐ |
|
module_pos_restaurant |
boolean |
Is a Bar/Restaurant |
☐ |
|
name |
string |
Point of Sale |
☑ |
An internal identification of the point of sale. |
number_of_rescue_session |
int32 |
Number of Rescue Session |
☐ |
|
only_round_cash_method |
boolean |
Only apply rounding on cash |
☐ |
|
other_devices |
boolean |
Other Devices |
☐ |
Connect devices to your PoS without an IoT Box. |
partner_load_background |
boolean |
Partner Load Background |
☐ |
|
payment_method_ids |
string |
|
☐ |
|
payment_terminal_device_ids |
string |
|
☐ |
|
picking_policy |
string |
Shipping Policy |
☑ |
If you deliver all products at once, the delivery order will be scheduled based on the greatest product lead time. Otherwise, it will be based on the shortest. |
picking_type_id_label |
string |
|
☐ |
|
picking_type_id |
string |
|
☐ |
|
pos_session_duration |
string |
Pos Session Duration |
☐ |
|
pos_session_state |
string |
Pos Session State |
☐ |
|
pos_session_username |
string |
Pos Session Username |
☐ |
|
pricelist_id_label |
string |
|
☐ |
The pricelist used if no customer is selected or if the customer has no Sale Pricelist configured. |
pricelist_id |
string |
|
☐ |
The pricelist used if no customer is selected or if the customer has no Sale Pricelist configured. |
product_load_background |
boolean |
Product Load Background |
☐ |
|
proxy_ip |
string |
IP Address |
☐ |
The hostname or ip address of the hardware proxy, Will be autodetected if left empty. |
receipt_footer |
string |
Receipt Footer |
☐ |
A short text that will be inserted as a footer in the printed receipt. |
receipt_header |
string |
Receipt Header |
☐ |
A short text that will be inserted as a header in the printed receipt. |
restrict_price_control |
boolean |
Restrict Price Modifications to Managers |
☐ |
Only users with Manager access rights for PoS app can modify the product prices on orders. |
rounding_method_label |
string |
|
☐ |
|
rounding_method |
string |
|
☐ |
|
route_id_label |
string |
|
☐ |
|
route_id |
string |
|
☐ |
|
sequence_id_label |
string |
|
☐ |
This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders. |
sequence_id |
string |
|
☐ |
This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders. |
sequence_line_id_label |
string |
|
☐ |
This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders lines. |
sequence_line_id |
string |
|
☐ |
This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders lines. |
session_ids |
string |
|
☐ |
|
set_maximum_difference |
boolean |
Set Maximum Difference |
☐ |
Set a maximum difference allowed between the expected and counted money during the closing of the session. |
ship_later |
boolean |
Ship Later |
☐ |
|
start_category |
boolean |
Start Category |
☐ |
|
tax_regime_selection |
boolean |
Tax Regime Selection value |
☐ |
|
tip_product_id_label |
string |
|
☐ |
This product is used as reference on customer receipts. |
tip_product_id |
string |
|
☐ |
This product is used as reference on customer receipts. |
use_pricelist |
boolean |
Use a pricelist. |
☐ |
|
uuid |
string |
Uuid |
☐ |
A globally unique identifier for this pos configuration, used to prevent conflicts in client-generated data. |
warehouse_id_label |
string |
|
☐ |
|
warehouse_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826