Please enable JavaScript to view this site.

Odoo Forums

Navigation: Schema: pos > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer