invantive documentation
Invantive Support ForumsLog In / Sign Up

product: Odoo itgen_odoo_product

read only per partition

  • Catalog: Odoo
  • Schema: product
  • Label: itgen_odoo_product

Product Variant

Can only retrieve data.

Table Columns

The columns of the table product 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
accessory_product_ids varchar2 Accessories show up when the customer reviews the cart before payment (cross-sell strategy).
account_tag_ids varchar2 Tags to be set on the base and tax journal items created for this product.
active boolean Active If unchecked, it will allow you to hide the product without removing it.
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
additional_product_tag_ids varchar2
all_product_tag_ids varchar2
allow_out_of_stock_order boolean Continue selling when out-of-stock
allow_worksheets boolean Worksheets
alternative_product_ids varchar2 Suggest alternatives to your customer (upsell strategy). Those products show up on the product page.
attribute_line_ids varchar2
available_in_pos boolean Available in POS Check if you want this product to appear in the Point of Sale.
available_threshold numeric Show Threshold
avg_cost numeric Average Cost
barcode varchar2 Barcode International Article Number used for product identification.
base_unit_count numeric Base Unit Count Display base unit price on your eCommerce pages. Set to 0 to hide it for this product.
base_unit_id varchar2 Define a custom unit to display in the price per unit of measure field.
base_unit_id_label varchar2 Define a custom unit to display in the price per unit of measure field.
base_unit_name varchar2 Base Unit Name Displays the custom unit for the products if defined or the selected unit of measure otherwise.
base_unit_price numeric Price Per Unit
bom_count int32 # Bill of Material
bom_ids varchar2
bom_line_ids varchar2
can_be_expensed boolean Can be Expensed Specify whether the product can be selected in an expense.
can_image_1024_be_zoomed boolean Can Image 1024 be zoomed
can_image_variant_1024_be_zoomed boolean Can Variant Image 1024 be zoomed
can_publish boolean Can Publish
categ_id varchar2
categ_id_label varchar2
code varchar2 Reference
color int32 Color Index
combination_indices varchar2 Combination Indices
company_currency_id varchar2 Technical field to correctly show the currently selected company's currency that corresponds to the totaled value of the product's valuation layers
company_currency_id_label varchar2 Technical field to correctly show the currently selected company's currency that corresponds to the totaled value of the product's valuation layers
company_id varchar2
company_id_label varchar2
compare_list_price numeric Compare to Price The amount will be displayed strikethroughed on the eCommerce product page
cost_currency_id varchar2
cost_currency_id_label varchar2
cost_method varchar2 Costing Method Standard Price: The products are valued at their standard cost defined on the product. Average Cost (AVCO): The products are valued at weighted average cost. First In First Out (FIFO): The products are valued supposing those that enter the company first will also leave it first.
country_of_origin varchar2 Rules of origin determine where goods originate, i.e. not where they have been shipped from, but where they have been produced or manufactured. As such, the ‘origin’ is the 'economic nationality' of goods traded in commerce.
country_of_origin_label varchar2 Rules of origin determine where goods originate, i.e. not where they have been shipped from, but where they have been produced or manufactured. As such, the ‘origin’ is the 'economic nationality' of goods traded in commerce.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
days_to_prepare_mo numeric Days to prepare Manufacturing Order Create and confirm Manufacturing Orders these many days in advance, to have enough time to replenish components or manufacture semi-finished products. Note that this does not affect the MO scheduled date, which still respects the just-in-time mechanism.
default_code varchar2 Internal Reference
description varchar2 Description
description_picking varchar2 Description on Picking
description_pickingin varchar2 Description on Receptions
description_pickingout varchar2 Description on Delivery Orders
description_purchase varchar2 Purchase Description
description_sale varchar2 Sales Description A description of the Product that you want to communicate to your customers. This description will be copied to every Sales Order, Delivery Order and Customer Invoice/Credit Note
detailed_type varchar2 Product Type A storable product is a product for which you manage stock. The Inventory app has to be installed. A consumable product is a product for which stock is not managed. A service is a non-material product you provide.
display_name varchar2 Display Name
display_price varchar2 Leasing price First leasing pricing of the product
documents_allowed_company_id varchar2
documents_allowed_company_id_label varchar2
ebay_best_offer boolean Allow Best Offer
ebay_buy_it_now_price numeric Buy It Now Price
ebay_category_2_id varchar2 The use of a secondary category is not allowed on every eBay sites. Fees can be claimed by eBay for this feature
ebay_category_2_id_label varchar2 The use of a secondary category is not allowed on every eBay sites. Fees can be claimed by eBay for this feature
ebay_category_id varchar2
ebay_category_id_label varchar2
ebay_description varchar2 eBay Description
ebay_fixed_price numeric eBay Fixed Price
ebay_id varchar2 eBay ID
ebay_item_condition_id varchar2
ebay_item_condition_id_label varchar2
ebay_last_sync datetime Last update
ebay_listing_duration varchar2 Duration
ebay_listing_status varchar2 eBay Status
ebay_listing_type varchar2 Listing Type
ebay_price numeric Starting Price for Auction
ebay_private_listing boolean Private Listing
ebay_quantity int32 Quantity On eBay
ebay_quantity_sold int32 Quantity Sold
ebay_seller_payment_policy_id varchar2
ebay_seller_payment_policy_id_label varchar2
ebay_seller_return_policy_id varchar2
ebay_seller_return_policy_id_label varchar2
ebay_seller_shipping_policy_id varchar2
ebay_seller_shipping_policy_id_label varchar2
ebay_start_date datetime Start Date
ebay_store_category_2_id varchar2
ebay_store_category_2_id_label varchar2
ebay_store_category_id varchar2
ebay_store_category_id_label varchar2
ebay_subtitle varchar2 Subtitle The subtitle is restricted to 55 characters. Fees can be claimed by eBay for this feature
ebay_sync_stock boolean Use Stock Quantity
ebay_template_id varchar2
ebay_template_id_label varchar2
ebay_title varchar2 Title The title is restricted to 80 characters
ebay_url varchar2 eBay url
ebay_use boolean Publish On eBay
ebay_variant_url varchar2 eBay Variant URL
eco_count int32 # ECOs
eco_ids varchar2
event_ticket_ids varchar2
expense_policy varchar2 Re-Invoice Expenses Expenses and vendor bills can be re-invoiced to a customer.With this option, a validated expense can be re-invoice to a customer at its cost or sales price.
expense_policy_tooltip varchar2 Expense Policy Tooltip
extra_daily numeric Extra Day Fine by day overdue
extra_hourly numeric Extra Hour Fine by hour overdue
fiscal_country_codes varchar2 Fiscal Country Codes
free_qty numeric Free To Use Quantity Forecast quantity (computed as Quantity On Hand - reserved quantity) In a context with a single Stock Location, this includes goods stored in this location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.
fsm_partner_price numeric Partner Price
fsm_partner_price_currency_id varchar2
fsm_partner_price_currency_id_label varchar2
fsm_quantity numeric Material Quantity
has_available_route_ids boolean Routes can be selected on this product
has_configurable_attributes boolean Is a configurable product
has_message boolean Has Message
hs_code varchar2 HS Code Standardized code for international shipping and goods declaration. At the moment, only used for the FedEx shipping provider.
id int32 ID
image_1024 varbinary Image 1024
image_128 varbinary Image 128
image_1920 varbinary Image
image_256 varbinary Image 256
image_512 varbinary Image 512
image_variant_1024 varbinary Variant Image 1024
image_variant_128 varbinary Variant Image 128
image_variant_1920 varbinary Variant Image
image_variant_256 varbinary Variant Image 256
image_variant_512 varbinary Variant Image 512
incoming_qty numeric Incoming Quantity of planned incoming products. In a context with a single Stock Location, this includes goods arriving to this Location, or any of its children. In a context with a single Warehouse, this includes goods arriving to the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods arriving to any Stock Location with 'internal' type.
invoice_policy varchar2 Invoicing Policy Ordered Quantity: Invoice quantities ordered by the customer. Delivered Quantity: Invoice quantities delivered to the customer.
is_kits boolean Is Kits
is_product_variant boolean Is Product Variant
is_published boolean Is Published
is_seo_optimized boolean SEO optimized
is_temporal boolean Is Temporal
list_price numeric Sales Price Price at which the product is sold to customers.
location_id varchar2
location_id_label varchar2
lst_price numeric Sales Price The sale price is managed from the product template. Click on the 'Configure Variants' button to set the extra attribute prices.
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
mrp_product_qty numeric Manufactured
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Name
nbr_moves_in int32 Nbr Moves In Number of incoming stock moves in the past 12 months
nbr_moves_out int32 Nbr Moves Out Number of outgoing stock moves in the past 12 months
nbr_reordering_rules int32 Reordering Rules
offer_count int32 Offer Count
optional_product_ids varchar2 Optional Products are suggested whenever the customer hits Add to Cart (cross-sell strategy, e.g. for computers: warranty, software, etc.).
orderpoint_ids varchar2
out_of_stock_message varchar2 Out-of-Stock Message
outgoing_qty numeric Outgoing Quantity of planned outgoing products. In a context with a single Stock Location, this includes goods leaving this Location, or any of its children. In a context with a single Warehouse, this includes goods leaving the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods leaving any Stock Location with 'internal' type.
packaging_ids varchar2 Gives the different ways to package the same product.
partner_ref varchar2 Customer Ref
planning_enabled boolean Plan Services If enabled, a shift will automatically be generated for the selected role when confirming the Sales Order. Only employees with this role will automatically be assigned shifts for Sales Orders containing this service.
planning_role_id varchar2
planning_role_id_label varchar2
pos_categ_id varchar2 Category used in the Point of Sale.
pos_categ_id_label varchar2 Category used in the Point of Sale.
preparation_time numeric Security Time Temporarily make this product unavailable before pickup.
price_extra numeric Variant Price Extra This is the sum of the extra price of all attributes
pricelist_item_count int32 Number of price rules
priority varchar2 Favorite
produce_delay numeric Manufacturing Lead Time Average lead time in days to manufacture this product. In the case of multi-level BOM, the manufacturing lead times of the components will be added. In case the product is subcontracted, this can be used to determine the date at which components should be sent to the subcontractor.
product_pricing_ids varchar2
product_tag_ids varchar2
product_template_attribute_value_ids varchar2
product_template_image_ids varchar2
product_template_variant_value_ids varchar2
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_tooltip varchar2 Product Tooltip
product_variant_count int32 # Product Variants
product_variant_id varchar2
product_variant_id_label varchar2
product_variant_ids varchar2
product_variant_image_ids varchar2
project_id varchar2
project_id_label varchar2
project_template_id varchar2
project_template_id_label varchar2
property_account_creditor_price_difference varchar2 This account is used in automated inventory valuation to record the price difference between a purchase order and its related vendor bill when validating this vendor bill.
property_account_creditor_price_difference_label varchar2 This account is used in automated inventory valuation to record the price difference between a purchase order and its related vendor bill when validating this vendor bill.
property_account_expense_id varchar2 Keep this field empty to use the default value from the product category. If anglo-saxon accounting with automated valuation method is configured, the expense account on the product category will be used.
property_account_expense_id_label varchar2 Keep this field empty to use the default value from the product category. If anglo-saxon accounting with automated valuation method is configured, the expense account on the product category will be used.
property_account_income_id varchar2 Keep this field empty to use the default value from the product category.
property_account_income_id_label varchar2 Keep this field empty to use the default value from the product category.
property_stock_inventory varchar2 This stock location will be used, instead of the default one, as the source location for stock moves generated when you do an inventory.
property_stock_inventory_label varchar2 This stock location will be used, instead of the default one, as the source location for stock moves generated when you do an inventory.
property_stock_production varchar2 This stock location will be used, instead of the default one, as the source location for stock moves generated by manufacturing orders.
property_stock_production_label varchar2 This stock location will be used, instead of the default one, as the source location for stock moves generated by manufacturing orders.
public_categ_ids varchar2 The product will be available in each mentioned eCommerce category. Go to Shop > Edit Click on the page and enable 'Categories' to view all eCommerce categories.
purchase_line_warn varchar2 Purchase Order Line Warning Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
purchase_line_warn_msg varchar2 Message for Purchase Order Line
purchase_method varchar2 Control Policy On ordered quantities: Control bills based on ordered quantities. On received quantities: Control bills based on received quantities.
purchase_ok boolean Can be Purchased
purchase_order_line_ids varchar2
purchased_product_qty numeric Purchased
putaway_rule_ids varchar2
qty_available numeric Quantity On Hand Current quantity of products. In a context with a single Stock Location, this includes goods stored at this Location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. stored in the Stock Location of the Warehouse of this Shop, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.
qty_in_rent numeric Quantity currently in rent
quality_control_point_qty int32 Quality Control Point Qty
quality_fail_qty int32 Quality Fail Qty
quality_pass_qty int32 Quality Pass Qty
quantity_decreasable boolean Quantity Decreasable
quantity_svl numeric Quantity Svl
rating_avg numeric Average Rating
rating_avg_text varchar2 Rating Avg Text
rating_count int32 Rating count
rating_ids varchar2
rating_last_feedback varchar2 Rating Last Feedback
rating_last_image varbinary Rating Last Image
rating_last_text varchar2 Rating Text
rating_last_value numeric Rating Last Value
rating_percentage_satisfaction numeric Rating Satisfaction
recurring_invoice boolean Subscription Product If set, confirming a sale order with this product will create a subscription
rent_ok boolean Can be Rented Allow renting of this product.
reordering_max_qty numeric Reordering Max Qty
reordering_min_qty numeric Reordering Min Qty
responsible_id varchar2 This user will be responsible of the next activities related to logistic operations for this product.
responsible_id_label varchar2 This user will be responsible of the next activities related to logistic operations for this product.
route_from_categ_ids varchar2
route_ids varchar2 Depending on the modules installed, this will allow you to define the route of the product: whether it will be bought, manufactured, replenished on order, etc.
sale_delay numeric Customer Lead Time Delivery lead time, in days. It's the number of days, promised to the customer, between the confirmation of the sales order and the delivery.
sale_line_warn varchar2 Sales Order Line Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
sale_line_warn_msg varchar2 Message for Sales Order Line
sale_ok boolean Can be Sold
sales_count numeric Sold
seller_ids varchar2
seo_name varchar2 Seo name
sequence int32 Sequence Gives the sequence order when displaying a product list
serial_missing boolean Serial Missing
service_policy varchar2 Service Invoicing Policy
service_to_purchase boolean Subcontract Service If ticked, each time you sell this product through a SO, a RfQ is automatically created to buy the product. Tip: don't forget to set a vendor on the product.
service_tracking varchar2 Create on Order On Sales order confirmation, this product can generate a project and/or task. From those, you can track the service you are selling. 'In sale order's project': Will use the sale order's configured project if defined or fallback to creating a new project based on the selected template.
service_type varchar2 Track Service Manually set quantities on order: Invoice based on the manually entered quantity, without creating an analytic account. Timesheets on contract: Invoice based on the tracked hours on the related timesheet. Create a task and track hours: Create a task on the sales order validation and track the work hours.
service_upsell_threshold numeric Threshold Percentage of time delivered compared to the prepaid amount that must be reached for the upselling opportunity activity to be triggered.
service_upsell_threshold_ratio varchar2 Service Upsell Threshold Ratio
show_availability boolean Show availability Qty
show_forecasted_qty_status_button boolean Show Forecasted Qty Status Button
show_on_hand_qty_status_button boolean Show On Hand Qty Status Button
standard_price numeric Cost Value of the product (automatically computed in AVCO). Used to value the product when the purchase cost is not known (e.g. inventory adjustment). Used to compute margins on sale orders.
stock_move_ids varchar2
stock_notification_partner_ids varchar2
stock_quant_ids varchar2
stock_valuation_layer_ids varchar2
storage_category_capacity_ids varchar2
supplier_taxes_id varchar2 Default taxes used when buying the product.
tax_string varchar2 Tax String
taxes_id varchar2 Default taxes used when selling the product.
template_folder_id varchar2 On sales order confirmation, a workspace will be automatically generated for the project based on this template.
template_folder_id_label varchar2 On sales order confirmation, a workspace will be automatically generated for the project based on this template.
to_weight boolean To Weigh With Scale Check if the product should be weighted using the hardware scale integration.
total_value numeric Total Value
tracking varchar2 Tracking Ensure the traceability of a storable product in your warehouse.
type varchar2 Type
uom_id varchar2 Default unit of measure used for all stock operations.
uom_id_label varchar2 Default unit of measure used for all stock operations.
uom_name varchar2 Unit of Measure Name
uom_po_id varchar2 Default unit of measure used for purchase orders. It must be in the same category as the default unit of measure.
uom_po_id_label varchar2 Default unit of measure used for purchase orders. It must be in the same category as the default unit of measure.
used_in_bom_count int32 # BoM Where Used
valid_ean boolean Barcode is valid EAN
valid_product_template_attribute_line_ids varchar2
valuation varchar2 Inventory Valuation Manual: The accounting entries to value the inventory are not posted automatically. Automated: An accounting entry is automatically created to value the inventory when a product enters or leaves the company.
value_svl numeric Value Svl
variant_bom_ids varchar2
variant_seller_ids varchar2
version int32 Version The current version of the product.
virtual_available numeric Forecasted Quantity Forecast quantity (computed as Quantity On Hand - Outgoing + Incoming) In a context with a single Stock Location, this includes goods stored in this location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.
visible_expense_policy boolean Re-Invoice Policy visible
visible_qty_configurator boolean Quantity visible in configurator
volume numeric Volume
volume_uom_name varchar2 Volume unit of measure label
warehouse_id varchar2
warehouse_id_label varchar2
website_description varchar2 Description for the website
website_id varchar2 Restrict publishing to this website.
website_id_label varchar2 Restrict publishing to this website.
website_message_ids varchar2 Website communication history
website_meta_description varchar2 Website meta description
website_meta_keywords varchar2 Website meta keywords
website_meta_og_img varchar2 Website opengraph image
website_meta_title varchar2 Website meta title
website_published boolean Visible on current website
website_ribbon_id varchar2
website_ribbon_id_label varchar2
website_sequence int32 Website Sequence Determine the display order in the Website E-commerce
website_size_x int32 Size X
website_size_y int32 Size Y
website_url varchar2 Website URL The full URL to access the document through the website.
weight numeric Weight
weight_uom_name varchar2 Weight unit of measure label
worksheet_template_id varchar2
worksheet_template_id_label varchar2
write_date datetime Write Date
write_uid varchar2
write_uid_label varchar2

Release Notes

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