invantive documentation
Invantive Support ForumsLog In / Sign Up

config: Odoo itgen_odoo_config

read only per partition

  • Catalog: Odoo
  • Schema: pos
  • Label: itgen_odoo_config

Point of Sale Configuration

Can only retrieve data.

Table Columns

The columns of the table config are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
active boolean Active
amount_authorized_diff numeric 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 varchar2 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 varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
crm_team_id varchar2 This Point of sale's sales will be related to this Sales Team.
crm_team_id_label varchar2 This Point of sale's sales will be related to this Sales Team.
currency_id varchar2
currency_id_label varchar2
current_session_id varchar2
current_session_id_label varchar2
current_session_state varchar2 Current Session State
current_user_id varchar2
current_user_id_label varchar2
default_bill_ids varchar2
default_fiscal_position_id varchar2
default_fiscal_position_id_label varchar2
display_name varchar2 Display Name
down_payment_product_id varchar2 This product will be used as down payment on a sale order.
down_payment_product_id_label varchar2 This product will be used as down payment on a sale order.
employee_ids varchar2 If left empty, all employees can log in to the PoS session
epson_printer_ip varchar2 Epson Printer IP Local IP address of an Epson receipt printer.
fiscal_position_ids varchar2 This is useful for restaurants with onsite and take-away services that imply specific tax rates.
group_pos_manager_id varchar2 This field is there to pass the id of the pos manager group to the point of sale client.
group_pos_manager_id_label varchar2 This field is there to pass the id of the pos manager group to the point of sale client.
group_pos_user_id varchar2 This field is there to pass the id of the pos user group to the point of sale client.
group_pos_user_id_label varchar2 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 varchar2 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 boolean Iface Customer Facing Display
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_display_id varchar2
iface_display_id_label varchar2
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 varchar2
iface_printer_id_label varchar2
iface_scale_id varchar2
iface_scale_id_label varchar2
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 varchar2 Enable barcode scanning with a remotely connected barcode scanner and card swiping with a Vantiv card reader.
iface_start_categ_id varchar2 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_label varchar2 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 varchar2 Tax Display
iface_tipproduct boolean Product tips
invoice_journal_id varchar2 Accounting journal used to create invoices.
invoice_journal_id_label varchar2 Accounting journal used to create invoices.
iot_device_ids varchar2
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 varchar2 Accounting journal used to post POS session journal entries and POS invoice payments.
journal_id_label varchar2 Accounting journal used to post POS session journal entries and POS invoice payments.
last_session_closing_cash numeric 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 varchar2 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 varchar2
payment_terminal_device_ids varchar2
picking_policy varchar2 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 varchar2
picking_type_id_label varchar2
pos_session_duration varchar2 Pos Session Duration
pos_session_state varchar2 Pos Session State
pos_session_username varchar2 Pos Session Username
pricelist_id varchar2 The pricelist used if no customer is selected or if the customer has no Sale Pricelist configured.
pricelist_id_label varchar2 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 varchar2 IP Address The hostname or ip address of the hardware proxy, Will be autodetected if left empty.
receipt_footer varchar2 Receipt Footer A short text that will be inserted as a footer in the printed receipt.
receipt_header varchar2 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 varchar2
rounding_method_label varchar2
route_id varchar2
route_id_label varchar2
sequence_id varchar2 This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders.
sequence_id_label varchar2 This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders.
sequence_line_id varchar2 This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders lines.
sequence_line_id_label varchar2 This sequence is automatically created by Odoo but you can change it to customize the reference numbers of your orders lines.
session_ids varchar2
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 varchar2 This product is used as reference on customer receipts.
tip_product_id_label varchar2 This product is used as reference on customer receipts.
use_pricelist boolean Use a pricelist.
uuid varchar2 Uuid A globally unique identifier for this pos configuration, used to prevent conflicts in client-generated data.
warehouse_id varchar2
warehouse_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: