Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
ad_client_id | numeric | 10 | √ | null |
|
|
|||||
ad_org_id | numeric | 10 | √ | null |
|
|
|||||
m_forecast_id | numeric | 10 | √ | null |
|
|
|||||
name | varchar | 60 | √ | null |
|
|
|||||
c_calendar_id | numeric | 10 | √ | null |
|
|
|||||
c_year_id | numeric | 10 | √ | null |
|
|
|||||
c_period_id | numeric | 10 | √ | null |
|
|
|||||
datepromised | timestamp | 29,6 | √ | null |
|
|
|||||
m_product_id | numeric | 10 | √ | null |
|
|
|||||
salesrep_id | numeric | 10 | √ | null |
|
|
|||||
c_uom_id | numeric | 10 | √ | null |
|
|
|||||
qty | numeric | 0 | √ | null |
|
|
|||||
qtycalculated | numeric | 0 | √ | null |
|
|
|||||
pricelist | numeric | 0 | √ | null |
|
|
|||||
pricestd | numeric | 0 | √ | null |
|
|
|||||
pricelimit | numeric | 0 | √ | null |
|
|
|||||
totalamt | numeric | 0 | √ | null |
|
|
|||||
m_product_category_id | numeric | 10 | √ | null |
|
|
|||||
classification | varchar | 40 | √ | null |
|
|
|||||
group1 | varchar | 255 | √ | null |
|
|
|||||
group2 | varchar | 255 | √ | null |
|
|