Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('res_config_settings_id_seq'::regclass) |
|
|
|||||
| create_uid | int4 | 10 | √ | null |
|
|
Created by |
||||
| write_uid | int4 | 10 | √ | null |
|
|
Last Updated by |
||||
| create_date | timestamp | 29,6 | √ | null |
|
|
Created on |
||||
| write_date | timestamp | 29,6 | √ | null |
|
|
Last Updated on |
||||
| web_app_name | varchar | 2147483647 | √ | null |
|
|
Web App Name |
||||
| company_id | int4 | 10 | null |
|
|
Company |
|||||
| user_default_rights | bool | 1 | √ | null |
|
|
Default Access Rights |
||||
| module_base_import | bool | 1 | √ | null |
|
|
Allow users to import data from CSV/XLS/XLSX/ODS files |
||||
| module_google_calendar | bool | 1 | √ | null |
|
|
Allow the users to synchronize their calendar with Google Calendar |
||||
| module_microsoft_calendar | bool | 1 | √ | null |
|
|
Allow the users to synchronize their calendar with Outlook Calendar |
||||
| module_mail_plugin | bool | 1 | √ | null |
|
|
Allow integration with the mail plugins |
||||
| module_auth_oauth | bool | 1 | √ | null |
|
|
Use external authentication providers (OAuth) |
||||
| module_auth_ldap | bool | 1 | √ | null |
|
|
LDAP Authentication |
||||
| module_account_inter_company_rules | bool | 1 | √ | null |
|
|
Manage Inter Company |
||||
| module_voip | bool | 1 | √ | null |
|
|
Asterisk (VoIP) |
||||
| module_web_unsplash | bool | 1 | √ | null |
|
|
Unsplash Image Library |
||||
| module_partner_autocomplete | bool | 1 | √ | null |
|
|
Partner Autocomplete |
||||
| module_base_geolocalize | bool | 1 | √ | null |
|
|
GeoLocalize |
||||
| module_google_recaptcha | bool | 1 | √ | null |
|
|
reCAPTCHA |
||||
| module_website_cf_turnstile | bool | 1 | √ | null |
|
|
Cloudflare Turnstile |
||||
| group_multi_currency | bool | 1 | √ | null |
|
|
Multi-Currencies |
||||
| show_effect | bool | 1 | √ | null |
|
|
Show Effect |
||||
| module_product_images | bool | 1 | √ | null |
|
|
Get product pictures using barcode |
||||
| profiling_enabled_until | timestamp | 29,6 | √ | null |
|
|
Profiling enabled until |
||||
| tenor_gif_limit | int4 | 10 | √ | null |
|
|
Tenor Gif Limit |
||||
| twilio_account_sid | varchar | 2147483647 | √ | null |
|
|
Twilio Account SID |
||||
| twilio_account_token | varchar | 2147483647 | √ | null |
|
|
Twilio Account Auth Token |
||||
| sfu_server_url | varchar | 2147483647 | √ | null |
|
|
SFU Server URL |
||||
| sfu_server_key | varchar | 2147483647 | √ | null |
|
|
SFU Server key |
||||
| tenor_api_key | varchar | 2147483647 | √ | null |
|
|
Tenor API key |
||||
| tenor_content_filter | varchar | 2147483647 | √ | null |
|
|
Tenor content filter |
||||
| google_translate_api_key | varchar | 2147483647 | √ | null |
|
|
Message Translation API Key |
||||
| external_email_server_default | bool | 1 | √ | null |
|
|
Use Custom Email Servers |
||||
| module_google_gmail | bool | 1 | √ | null |
|
|
Support Gmail Authentication |
||||
| module_microsoft_outlook | bool | 1 | √ | null |
|
|
Support Outlook Authentication |
||||
| restrict_template_rendering | bool | 1 | √ | null |
|
|
Restrict Template Rendering |
||||
| use_twilio_rtc_servers | bool | 1 | √ | null |
|
|
Use Twilio ICE servers |
||||
| group_analytic_accounting | bool | 1 | √ | null |
|
|
Analytic Accounting |
||||
| auth_signup_template_user_id | int4 | 10 | √ | null |
|
|
Template user for new users created through signup |
||||
| auth_signup_uninvited | varchar | 2147483647 | √ | null |
|
|
Customer Account |
||||
| auth_signup_reset_password | bool | 1 | √ | null |
|
|
Enable password reset from Login page |
||||
| google_gmail_client_identifier | varchar | 2147483647 | √ | null |
|
|
Gmail Client Id |
||||
| google_gmail_client_secret | varchar | 2147483647 | √ | null |
|
|
Gmail Client Secret |
||||
| product_pricelist_setting | varchar | 2147483647 | √ | null |
|
|
Pricelists Method |
||||
| product_weight_in_lbs | varchar | 2147483647 | √ | null |
|
|
Weight unit of measure |
||||
| product_volume_volume_in_cubic_feet | varchar | 2147483647 | √ | null |
|
|
Volume unit of measure |
||||
| group_discount_per_so_line | bool | 1 | √ | null |
|
|
Discounts |
||||
| group_uom | bool | 1 | √ | null |
|
|
Units of Measure |
||||
| group_product_variant | bool | 1 | √ | null |
|
|
Variants |
||||
| module_sale_product_matrix | bool | 1 | √ | null |
|
|
Sales Grid Entry |
||||
| module_loyalty | bool | 1 | √ | null |
|
|
Promotions, Coupons, Gift Card & Loyalty Program |
||||
| group_stock_packaging | bool | 1 | √ | null |
|
|
Product Packagings |
||||
| group_product_pricelist | bool | 1 | √ | null |
|
|
Pricelists |
||||
| group_sale_pricelist | bool | 1 | √ | null |
|
|
Advanced Pricelists |
||||
| unsplash_access_key | varchar | 2147483647 | √ | null |
|
|
Access Key |
||||
| unsplash_app_id | varchar | 2147483647 | √ | null |
|
|
Application ID |
||||
| digest_id | int4 | 10 | √ | null |
|
|
Digest Email |
||||
| digest_emails | bool | 1 | √ | null |
|
|
Digest Emails |
||||
| chart_template | varchar | 2147483647 | √ | null |
|
|
Chart Template |
||||
| module_account_accountant | bool | 1 | √ | null |
|
|
Accounting |
||||
| group_warning_account | bool | 1 | √ | null |
|
|
Warnings in Invoices |
||||
| group_cash_rounding | bool | 1 | √ | null |
|
|
Cash Rounding |
||||
| group_show_sale_receipts | bool | 1 | √ | null |
|
|
Sale Receipt |
||||
| group_show_purchase_receipts | bool | 1 | √ | null |
|
|
Purchase Receipt |
||||
| module_account_budget | bool | 1 | √ | null |
|
|
Budget Management |
||||
| module_account_payment | bool | 1 | √ | null |
|
|
Invoice Online Payment |
||||
| module_account_reports | bool | 1 | √ | null |
|
|
Dynamic Reports |
||||
| module_account_check_printing | bool | 1 | √ | null |
|
|
Allow check printing and deposits |
||||
| module_account_batch_payment | bool | 1 | √ | null |
|
|
Use batch payments |
||||
| module_account_sepa | bool | 1 | √ | null |
|
|
SEPA Credit Transfer (SCT) |
||||
| module_account_sepa_direct_debit | bool | 1 | √ | null |
|
|
Use SEPA Direct Debit |
||||
| module_account_bank_statement_import_qif | bool | 1 | √ | null |
|
|
Import .qif files |
||||
| module_account_bank_statement_import_ofx | bool | 1 | √ | null |
|
|
Import in .ofx format |
||||
| module_account_bank_statement_import_csv | bool | 1 | √ | null |
|
|
Import in .csv, .xls, and .xlsx format |
||||
| module_account_bank_statement_import_camt | bool | 1 | √ | null |
|
|
Import in CAMT.053 format |
||||
| module_currency_rate_live | bool | 1 | √ | null |
|
|
Automatic Currency Rates |
||||
| module_account_intrastat | bool | 1 | √ | null |
|
|
Intrastat |
||||
| module_product_margin | bool | 1 | √ | null |
|
|
Allow Product Margin |
||||
| module_l10n_eu_oss | bool | 1 | √ | null |
|
|
EU Intra-community Distance Selling |
||||
| module_account_taxcloud | bool | 1 | √ | null |
|
|
Account TaxCloud |
||||
| module_account_avatax | bool | 1 | √ | null |
|
|
Account Avatax |
||||
| module_account_invoice_extract | bool | 1 | √ | null |
|
|
Document Digitization |
||||
| module_snailmail_account | bool | 1 | √ | null |
|
|
Snailmail |
||||
| module_account_peppol | bool | 1 | √ | null |
|
|
PEPPOL Invoicing |
||||
| use_invoice_terms | bool | 1 | √ | null |
|
|
Default Terms & Conditions |
||||
| group_sale_delivery_address | bool | 1 | √ | null |
|
|
Customer Addresses |
||||
| module_product_expiry | bool | 1 | √ | null |
|
|
Expiration Dates |
||||
| group_stock_production_lot | bool | 1 | √ | null |
|
|
Lots & Serial Numbers |
||||
| group_stock_lot_print_gs1 | bool | 1 | √ | null |
|
|
Print GS1 Barcodes for Lots & Serial Numbers |
||||
| group_lot_on_delivery_slip | bool | 1 | √ | null |
|
|
Display Lots & Serial Numbers on Delivery Slips |
||||
| group_stock_tracking_lot | bool | 1 | √ | null |
|
|
Packages |
||||
| group_stock_tracking_owner | bool | 1 | √ | null |
|
|
Consignment |
||||
| group_stock_adv_location | bool | 1 | √ | null |
|
|
Multi-Step Routes |
||||
| group_warning_stock | bool | 1 | √ | null |
|
|
Warnings for Stock |
||||
| group_stock_sign_delivery | bool | 1 | √ | null |
|
|
Signature |
||||
| module_stock_picking_batch | bool | 1 | √ | null |
|
|
Batch Transfers |
||||
| group_stock_picking_wave | bool | 1 | √ | null |
|
|
Wave Transfers |
||||
| module_stock_barcode | bool | 1 | √ | null |
|
|
Barcode Scanner |
||||
| module_stock_sms | bool | 1 | √ | null |
|
|
SMS Confirmation |
||||
| module_delivery | bool | 1 | √ | null |
|
|
Delivery Methods |
||||
| module_delivery_dhl | bool | 1 | √ | null |
|
|
DHL Express Connector |
||||
| module_delivery_fedex | bool | 1 | √ | null |
|
|
FedEx Connector |
||||
| module_delivery_ups | bool | 1 | √ | null |
|
|
UPS Connector |
||||
| module_delivery_usps | bool | 1 | √ | null |
|
|
USPS Connector |
||||
| module_delivery_bpost | bool | 1 | √ | null |
|
|
bpost Connector |
||||
| module_delivery_easypost | bool | 1 | √ | null |
|
|
Easypost Connector |
||||
| module_delivery_sendcloud | bool | 1 | √ | null |
|
|
Sendcloud Connector |
||||
| module_delivery_shiprocket | bool | 1 | √ | null |
|
|
Shiprocket Connector |
||||
| module_quality_control | bool | 1 | √ | null |
|
|
Quality |
||||
| module_quality_control_worksheet | bool | 1 | √ | null |
|
|
Quality Worksheet |
||||
| group_stock_multi_locations | bool | 1 | √ | null |
|
|
Storage Locations |
||||
| group_stock_storage_categories | bool | 1 | √ | null |
|
|
Storage Categories |
||||
| group_stock_reception_report | bool | 1 | √ | null |
|
|
Reception Report |
||||
| module_stock_dropshipping | bool | 1 | √ | null |
|
|
Dropshipping |
||||
| pay_invoices_online | bool | 1 | √ | null |
|
|
Pay Invoices Online |
||||
| use_manufacturing_lead | bool | 1 | √ | null |
|
|
Default Manufacturing Lead Time |
||||
| group_mrp_byproducts | bool | 1 | √ | null |
|
|
By-Products |
||||
| module_mrp_mps | bool | 1 | √ | null |
|
|
Master Production Schedule |
||||
| module_mrp_plm | bool | 1 | √ | null |
|
|
Product Lifecycle Management (PLM) |
||||
| module_mrp_subcontracting | bool | 1 | √ | null |
|
|
Subcontracting |
||||
| group_mrp_routings | bool | 1 | √ | null |
|
|
MRP Work Orders |
||||
| group_unlocked_by_default | bool | 1 | √ | null |
|
|
Unlock Manufacturing Orders |
||||
| group_mrp_reception_report | bool | 1 | √ | null |
|
|
Allocation Report for Manufacturing Orders |
||||
| group_mrp_workorder_dependencies | bool | 1 | √ | null |
|
|
Work Order Dependencies |
||||
| default_purchase_method | varchar | 2147483647 | √ | null |
|
|
Bill Control |
||||
| lock_confirmed_po | bool | 1 | √ | null |
|
|
Lock Confirmed Orders |
||||
| po_order_approval | bool | 1 | √ | null |
|
|
Purchase Order Approval |
||||
| group_warning_purchase | bool | 1 | √ | null |
|
|
Purchase Warnings |
||||
| module_account_3way_match | bool | 1 | √ | null |
|
|
3-way matching: purchases, receptions and bills |
||||
| module_purchase_requisition | bool | 1 | √ | null |
|
|
Purchase Agreements |
||||
| module_purchase_product_matrix | bool | 1 | √ | null |
|
|
Purchase Grid Entry |
||||
| use_po_lead | bool | 1 | √ | null |
|
|
Security Lead Time for Purchase |
||||
| group_send_reminder | bool | 1 | √ | null |
|
|
Receipt Reminder |
||||
| module_stock_landed_costs | bool | 1 | √ | null |
|
|
Landed Costs |
||||
| group_lot_on_invoice | bool | 1 | √ | null |
|
|
Display Lots & Serial Numbers on Invoices |
||||
| group_stock_accounting_automatic | bool | 1 | √ | null |
|
|
Automatic Stock Accounting |
||||
| is_installed_sale | bool | 1 | √ | null |
|
|
Is the Sale Module Installed |
||||
| invoice_mail_template_id | int4 | 10 | √ | null |
|
|
Invoice Email Template |
||||
| default_invoice_policy | varchar | 2147483647 | √ | null |
|
|
Invoicing Policy |
||||
| group_auto_done_setting | bool | 1 | √ | null |
|
|
Lock Confirmed Sales |
||||
| group_proforma_sales | bool | 1 | √ | null |
|
|
Pro-Forma Invoice |
||||
| group_warning_sale | bool | 1 | √ | null |
|
|
Sale Order Warnings |
||||
| automatic_invoice | bool | 1 | √ | null |
|
|
Automatic Invoice |
||||
| module_product_email_template | bool | 1 | √ | null |
|
|
Specific Email |
||||
| module_sale_amazon | bool | 1 | √ | null |
|
|
Amazon Sync |
||||
| module_sale_loyalty | bool | 1 | √ | null |
|
|
Coupons & Loyalty |
||||
| module_sale_margin | bool | 1 | √ | null |
|
|
Margins |
||||
| module_sale_pdf_quote_builder | bool | 1 | √ | null |
|
|
PDF Quote builder |
||||
| group_sale_order_template | bool | 1 | √ | null |
|
|
Quotation Templates |
||||
| default_picking_policy | varchar | 2147483647 | null |
|
|
Picking Policy |
|||||
| use_security_lead | bool | 1 | √ | null |
|
|
Security Lead Time for Sales |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| res_config_settings_pkey | Primary key | Asc | id |
Relationships
Close relationships within degrees of separation
