stock_quant

71 rows


Description

Quants

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_quant_id_seq'::regclass)
stock_conflict_quant_rel.stock_quant_id stock_conflict_quant_rel_stock_quant_id_fkey C
stock_inventory_adjustment_name_stock_quant_rel.stock_quant_id stock_inventory_adjustment_name_stock_quant_stock_quant_id_fkey C
stock_inventory_conflict_stock_quant_rel.stock_quant_id stock_inventory_conflict_stock_quant_rel_stock_quant_id_fkey C
stock_inventory_warning_stock_quant_rel.stock_quant_id stock_inventory_warning_stock_quant_rel_stock_quant_id_fkey C
stock_quant_stock_quant_relocate_rel.stock_quant_id stock_quant_stock_quant_relocate_rel_stock_quant_id_fkey C
stock_quant_stock_request_count_rel.stock_quant_id stock_quant_stock_request_count_rel_stock_quant_id_fkey C
stock_quant_stock_track_confirmation_rel.stock_quant_id stock_quant_stock_track_confirmation_rel_stock_quant_id_fkey C
product_id int4 10 null
product_product.id stock_quant_product_id_fkey R

Product
company_id int4 10 √ null
res_company.id stock_quant_company_id_fkey N

Company
location_id int4 10 null
stock_location.id stock_quant_location_id_fkey R

Location
storage_category_id int4 10 √ null
stock_storage_category.id stock_quant_storage_category_id_fkey N

Storage Category
lot_id int4 10 √ null
stock_lot.id stock_quant_lot_id_fkey R

Lot/Serial Number
package_id int4 10 √ null
stock_quant_package.id stock_quant_package_id_fkey R

Package
owner_id int4 10 √ null
res_partner.id stock_quant_owner_id_fkey N

Owner
user_id int4 10 √ null
res_users.id stock_quant_user_id_fkey N

Assigned To
create_uid int4 10 √ null
res_users.id stock_quant_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id stock_quant_write_uid_fkey N

Last Updated by
inventory_date date 13 √ null

Scheduled Date
quantity numeric 0 √ null

Quantity
reserved_quantity numeric 0 null

Reserved Quantity
inventory_quantity numeric 0 √ null

Counted Quantity
inventory_diff_quantity numeric 0 √ null

Difference
inventory_quantity_set bool 1 √ null

Inventory Quantity Set
in_date timestamp 29,6 null

Incoming Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
accounting_date date 13 √ null

Accounting Date

Indexes

Constraint Name Type Sort Column(s)
stock_quant_pkey Primary key Asc id
stock_quant__location_id_index Performance Asc location_id
stock_quant__lot_id_index Performance Asc lot_id
stock_quant__owner_id_index Performance Asc owner_id
stock_quant__package_id_index Performance Asc package_id
stock_quant__product_id_index Performance Asc product_id

Relationships

Close relationships within degrees of separation