View idempiere9.adempiere.rv_m_forecast
Forecast Report

 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
m_forecast_id numeric 10  √  null Material Forecast
name varchar 60  √  null Alphanumeric identifier of the entity
c_calendar_id numeric 10  √  null Accounting Calendar Name
c_year_id numeric 10  √  null Calendar Year
c_period_id numeric 10  √  null Period of the Calendar
datepromised timestamp 29,6  √  null Date Order was promised
m_product_id numeric 10  √  null Product, Service, Item
salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_uom_id numeric 10  √  null Unit of Measure
qty numeric 0  √  null Quantity
qtycalculated numeric 0  √  null Calculated Quantity
pricelist numeric 0  √  null List Price
pricestd numeric 0  √  null Standard Price
pricelimit numeric 0  √  null Lowest price for a product
totalamt numeric 0  √  null Total Amount
m_product_category_id numeric 10  √  null Category of a Product
classification varchar 12  √  null Classification for grouping
group1 varchar 255  √  null Group1
group2 varchar 255  √  null Group2

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