rv_storage_per_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
value varchar 510 √ null
name varchar 255 √ null
description varchar 255 √ null
upc varchar 30 √ null
sku varchar 30 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
m_product_category_id numeric 10 √ null
m_product_category.m_product_category_id Implied Constraint R
classification varchar 40 √ null
weight numeric 0 √ null
volume numeric 0 √ null
versionno varchar 20 √ null
guaranteedays numeric 10 √ null
guaranteedaysmin numeric 10 √ null
sumqtyonhand numeric 0 √ null
issold bpchar 1 √ null
lbr_productcategory_id numeric 10 √ null
lbr_productcategory.lbr_productcategory_id Implied Constraint R
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
cof_producttype_id numeric 10 √ null
cof_producttype.cof_producttype_id Implied Constraint R
cof_productclass_id numeric 10 √ null
cof_productclass.cof_productclass_id Implied Constraint R
cof_productgroup_id numeric 10 √ null
cof_productgroup.cof_productgroup_id Implied Constraint R
cof_grupofornecedor_id numeric 10 √ null
cof_grupofornecedor.cof_grupofornecedor_id Implied Constraint R
cof_qtyreservada numeric 0 √ null
cof_qtyrequisitada numeric 0 √ null
cof_provisaoestoque numeric 0 √ null
cof_tipoprovisaoestoque text 2147483647 √ null
producttype bpchar 1 √ null
cof_abc varchar 2 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views