invantive documentation
Invantive Support ForumsLog In / Sign Up

location: Odoo itgen_odoo_location

read only per partition

  • Catalog: Odoo
  • Schema: stock
  • Label: itgen_odoo_location

Inventory Locations

Can only retrieve data.

Table Columns

The columns of the table location 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 By unchecking the active field, you may hide a location without deleting it.
amazon_location boolean Amazon Location Whether this location represents the stock of a seller managed by Amazon under the Amazon Fulfillment program or not.
barcode varchar2 Barcode
child_ids varchar2
child_internal_location_ids varchar2 This location (if it's internal) and all its descendants filtered by type=Internal.
comment varchar2 Additional Information
company_id varchar2 Let this field empty if this location is shared between companies
company_id_label varchar2 Let this field empty if this location is shared between companies
complete_name varchar2 Full Location Name
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
cyclic_inventory_frequency int32 Inventory Frequency (Days) When different than 0, inventory count date for products stored at this location will be automatically set at the defined frequency.
display_name varchar2 Display Name
forecast_weight numeric Forecasted Weight
id int32 ID
incoming_move_line_ids varchar2
last_inventory_date datetime Last Effective Inventory Date of the last inventory at this location.
location_id varchar2 The parent location that includes this location. Example : The 'Dispatch Zone' is the 'Gate 1' parent location.
location_id_label varchar2 The parent location that includes this location. Example : The 'Dispatch Zone' is the 'Gate 1' parent location.
name varchar2 Location Name
net_weight numeric Net Weight
next_inventory_date datetime Next Expected Inventory Date for next planned inventory based on cyclic schedule.
outgoing_move_line_ids varchar2
parent_path varchar2 Parent Path
posx int32 Corridor (X) Optional localization details, for information purpose only
posy int32 Shelves (Y) Optional localization details, for information purpose only
posz int32 Height (Z) Optional localization details, for information purpose only
putaway_rule_ids varchar2
quant_ids varchar2
removal_strategy_id varchar2 Defines the default method used for suggesting the exact location (shelf) where to take the products from, which lot etc. for this location. This method can be enforced at the product category level, and a fallback is made on the parent locations if none is set here. FIFO: products/lots that were stocked first will be moved out first. LIFO: products/lots that were stocked last will be moved out first. Closet location: products/lots closest to the target location will be moved out first. FEFO: products/lots with the closest removal date will be moved out first (the availability of this method depends on the "Expiration Dates" setting).
removal_strategy_id_label varchar2 Defines the default method used for suggesting the exact location (shelf) where to take the products from, which lot etc. for this location. This method can be enforced at the product category level, and a fallback is made on the parent locations if none is set here. FIFO: products/lots that were stocked first will be moved out first. LIFO: products/lots that were stocked last will be moved out first. Closet location: products/lots closest to the target location will be moved out first. FEFO: products/lots with the closest removal date will be moved out first (the availability of this method depends on the "Expiration Dates" setting).
replenish_location boolean Replenish Location Activate this function to get all quantities to replenish at this particular location
return_location boolean Is a Return Location? Check this box to allow using this location as a return location.
scrap_location boolean Is a Scrap Location? Check this box to allow using this location to put scrapped/damaged goods.
storage_category_id varchar2
storage_category_id_label varchar2
usage varchar2 Location Type * Vendor Location: Virtual location representing the source location for products coming from your vendors * View: Virtual location used to create a hierarchical structures for your warehouse, aggregating its child locations ; can't directly contain products * Internal Location: Physical locations inside your own warehouses, * Customer Location: Virtual location representing the destination location for products sent to your customers * Inventory Loss: Virtual location serving as counterpart for inventory operations used to correct stock levels (Physical inventories) * Production: Virtual counterpart location for production operations: this location consumes the components and produces finished products * Transit Location: Counterpart location that should be used in inter-company or inter-warehouses operations
valuation_in_account_id varchar2 Used for real-time inventory valuation. When set on a virtual location (non internal type), this account will be used to hold the value of products being moved from an internal location into this location, instead of the generic Stock Output Account set on the product. This has no effect for internal locations.
valuation_in_account_id_label varchar2 Used for real-time inventory valuation. When set on a virtual location (non internal type), this account will be used to hold the value of products being moved from an internal location into this location, instead of the generic Stock Output Account set on the product. This has no effect for internal locations.
valuation_out_account_id varchar2 Used for real-time inventory valuation. When set on a virtual location (non internal type), this account will be used to hold the value of products being moved out of this location and into an internal location, instead of the generic Stock Output Account set on the product. This has no effect for internal locations.
valuation_out_account_id_label varchar2 Used for real-time inventory valuation. When set on a virtual location (non internal type), this account will be used to hold the value of products being moved out of this location and into an internal location, instead of the generic Stock Output Account set on the product. This has no effect for internal locations.
warehouse_id varchar2
warehouse_id_label varchar2
warehouse_view_ids 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: