Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
seqno | numeric | 10 | √ | null |
|
|
|||||
levelno | numeric | 10 | √ | null |
|
|
|||||
levels | varchar | 250 | √ | null |
|
|
|||||
ad_client_id | numeric | 10 | √ | null |
|
|
|||||
ad_org_id | numeric | 10 | √ | null |
|
|
|||||
createdby | numeric | 10 | √ | null |
|
|
|||||
updatedby | numeric | 10 | √ | null |
|
|
|||||
updated | timestamp | 29,6 | √ | null |
|
|
|||||
created | timestamp | 29,6 | √ | null |
|
|
|||||
ad_pinstance_id | numeric | 10 | √ | null |
|
|
|||||
implosion | bpchar | 1 | √ | null |
|
|
|||||
m_product_id | numeric | 10 | √ | null |
|
|
|||||
isactive | bpchar | 1 | √ | null |
|
|
|||||
pp_product_bom_id | numeric | 10 | √ | null |
|
|
|||||
pp_product_bomline_id | numeric | 10 | √ | null |
|
|
|||||
description | varchar | 255 | √ | null |
|
|
|||||
iscritical | bpchar | 1 | √ | null |
|
|
|||||
componenttype | bpchar | 2 | √ | null |
|
|
|||||
tm_product_id | numeric | 10 | √ | null |
|
|
|||||
c_uom_id | numeric | 10 | √ | null |
|
|
|||||
issuemethod | bpchar | 1 | √ | null |
|
|
|||||
line | numeric | 10 | √ | null |
|
|
|||||
m_attributesetinstance_id | numeric | 10 | √ | null |
|
|
|||||
scrap | numeric | 0 | √ | null |
|
|
|||||
validfrom | timestamp | 29,6 | √ | null |
|
|
|||||
validto | timestamp | 29,6 | √ | null |
|
|
|||||
qtybom | numeric | 0 | √ | null |
|
|
|||||
qtybatch | numeric | 0 | √ | null |
|
|
|||||
isqtypercentage | bpchar | 1 | √ | null |
|
|