View idempiere9.adempiere.rv_costsummary
Product Cost Summary

 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 bpchar 1  √  null The record is active in the system
createdby int4 10  √  null User who created this records
created timestamptz 35,6  √  null Date this record was created
updatedby int4 10  √  null User who updated this records
updated timestamptz 35,6  √  null Date this record was updated
m_product_id numeric 10  √  null Product, Service, Item
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)
isbom bpchar 1  √  null Bill of Materials
producttype bpchar 1  √  null Type of product
m_product_category_id numeric 10  √  null Category of a Product
m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
c_acctschema_id numeric 10  √  null Rules for accounting
c_currency_id numeric 10  √  null The Currency for this record
currentcostprice numeric 0  √  null The currently used cost price
futurecostprice numeric 0  √  null Future Cost Price

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