Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
|
|
|||||
isactive | bpchar | 1 | √ | null |
|
|
|||||
pp_order_bom_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_bomline_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_id | numeric | 10 | √ | null |
|
|
|||||
iscritical | bpchar | 1 | √ | null |
|
|
|||||
componenttype | bpchar | 2 | √ | null |
|
|
|||||
m_product_id | numeric | 10 | √ | null |
|
|
|||||
c_uom_id | numeric | 10 | √ | null |
|
|
|||||
qtyrequiered | numeric | 0 | √ | null |
|
|
|||||
qtyreserved | numeric | 0 | √ | null |
|
|
|||||
qtyavailable | numeric | 0 | √ | null |
|
|
|||||
qtyonhand | numeric | 0 | √ | null |
|
|
|||||
m_warehouse_id | numeric | 10 | √ | null |
|
|
|||||
qtybom | numeric | 0 | √ | null |
|
|
|||||
isqtypercentage | bpchar | 1 | √ | null |
|
|
|||||
qtybatch | numeric | 0 | √ | null |
|
|
|||||
qtybatchsize | numeric | 0 | √ | null |
|
|