stock_valuation_layer

-1 rows


Description

Stock Valuation Layer

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_valuation_layer_id_seq'::regclass)
stock_valuation_layer.stock_valuation_layer_id stock_valuation_layer_stock_valuation_layer_id_fkey N
company_id int4 10 null
res_company.id stock_valuation_layer_company_id_fkey R

Company
product_id int4 10 null
product_product.id stock_valuation_layer_product_id_fkey R

Product
categ_id int4 10 √ null
product_category.id stock_valuation_layer_categ_id_fkey N

Product Category
stock_valuation_layer_id int4 10 √ null
stock_valuation_layer.id stock_valuation_layer_stock_valuation_layer_id_fkey N

Linked To
stock_move_id int4 10 √ null
stock_move.id stock_valuation_layer_stock_move_id_fkey N

Stock Move
account_move_id int4 10 √ null
account_move.id stock_valuation_layer_account_move_id_fkey N

Journal Entry
account_move_line_id int4 10 √ null
account_move_line.id stock_valuation_layer_account_move_line_id_fkey N

Invoice Line
create_uid int4 10 √ null
res_users.id stock_valuation_layer_create_uid_fkey N

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

Last Updated by
description varchar 2147483647 √ null

Description
quantity numeric 0 √ null

Quantity
unit_cost numeric 0 √ null

Unit Value
value numeric 0 √ null

Total Value
remaining_qty numeric 0 √ null

Remaining Qty
remaining_value numeric 0 √ null

Remaining Value
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
price_diff_value float8 17,17 √ null

Invoice value correction with invoice currency

Indexes

Constraint Name Type Sort Column(s)
stock_valuation_layer_pkey Primary key Asc id
stock_valuation_layer__account_move_id_index Performance Asc account_move_id
stock_valuation_layer__account_move_line_id_index Performance Asc account_move_line_id
stock_valuation_layer__stock_move_id_index Performance Asc stock_move_id
stock_valuation_layer__stock_valuation_layer_id_index Performance Asc stock_valuation_layer_id
stock_valuation_layer_index Performance Asc/Asc/Asc/Asc/Asc product_id + remaining_qty + stock_move_id + company_id + create_date

Relationships

Close relationships within degrees of separation