Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
ad_client_id | numeric | 10 | √ | null |
|
|
|||||
ad_org_id | numeric | 10 | √ | null |
|
|
|||||
isactive | bpchar | 1 | √ | null |
|
|
|||||
createdby | int4 | 10 | √ | null |
|
|
|||||
created | timestamptz | 35,6 | √ | null |
|
|
|||||
updatedby | int4 | 10 | √ | null |
|
|
|||||
updated | timestamptz | 35,6 | √ | null |
|
|
|||||
m_product_id | numeric | 10 | √ | null |
|
|
|||||
value | varchar | 510 | √ | null |
|
|
|||||
name | varchar | 255 | √ | null |
|
|
|||||
upc | varchar | 30 | √ | null |
|
|
|||||
isbom | bpchar | 1 | √ | null |
|
|
|||||
producttype | bpchar | 1 | √ | null |
|
|
|||||
m_product_category_id | numeric | 10 | √ | null |
|
|
|||||
m_costtype_id | numeric | 10 | √ | null |
|
|
|||||
c_acctschema_id | numeric | 10 | √ | null |
|
|
|||||
c_currency_id | numeric | 10 | √ | null |
|
|
|||||
currentcostprice | numeric | 0 | √ | null |
|
|
|||||
futurecostprice | numeric | 0 | √ | null |
|
|
|||||
currentqty | numeric | 0 | √ | null |
|
|
|||||
cumulatedamt | numeric | 0 | √ | null |
|
|
|||||
cumulatedqty | numeric | 0 | √ | null |
|
|
|||||
m_costelement_id | numeric | 10 | √ | null |
|
|