View idempiere9.adempiere.rv_warehouseprice
Warehouse Price

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive text 2147483647  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
m_product_id numeric 10  √  null Product, Service, Item
m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
value varchar 40  √  null Search key for the record in the format required - must be unique
name varchar 255  √  null Alphanumeric identifier of the entity
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
c_uom_id numeric 10  √  null Unit of Measure
uomsymbol varchar 10  √  null Symbol for a Unit of Measure
pricelist numeric 0  √  null List Price
pricestd numeric 0  √  null Standard Price
margin numeric 0  √  null Margin for a product as a percentage
pricelimit numeric 0  √  null Lowest price for a product
warehousename varchar 60  √  null Warehouse Name
qtyavailable numeric 0  √  null Available Quantity (On Hand - Reserved)
qtyonhand numeric 0  √  null On Hand Quantity
qtyreserved numeric 0  √  null Reserved Quantity
qtyordered numeric 0  √  null Ordered Quantity
isinstanceattribute bpchar 2147483647  √  null The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date)

Analyzed at 2021-12-25 14:43 +0100