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 |
|
|
|||||
created | timestamp | 29,6 | √ | null |
|
|
|||||
createdby | numeric | 10 | √ | null |
|
|
|||||
updated | timestamp | 29,6 | √ | null |
|
|
|||||
updatedby | numeric | 10 | √ | null |
|
|
|||||
ad_language | varchar | 6 | √ | null |
|
|
|||||
description | varchar | 255 | √ | null |
|
|
|||||
feature | varchar | 30 | √ | null |
|
|
|||||
m_product_id | numeric | 10 | √ | null |
|
|
|||||
backflushgroup | varchar | 30 | √ | null |
|
|
|||||
c_uom_id | numeric | 10 | √ | null |
|
|
|||||
componenttype | bpchar | 2 | √ | null |
|
|
|||||
datedelivered | timestamp | 29,6 | √ | null |
|
|
|||||
forecast | numeric | 0 | √ | null |
|
|
|||||
help | varchar | 2000 | √ | null |
|
|
|||||
iscritical | bpchar | 1 | √ | null |
|
|
|||||
issuemethod | bpchar | 1 | √ | null |
|
|
|||||
leadtimeoffset | numeric | 10 | √ | null |
|
|
|||||
line | numeric | 10 | √ | null |
|
|
|||||
m_attributesetinstance_id | numeric | 10 | √ | null |
|
|
|||||
m_changenotice_id | numeric | 10 | √ | null |
|
|
|||||
m_locator_id | numeric | 10 | √ | null |
|
|
|||||
m_warehouse_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_bom_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_bomline_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_id | numeric | 10 | √ | null |
|
|
|||||
qtydelivered | numeric | 0 | √ | null |
|
|
|||||
qtypost | numeric | 0 | √ | null |
|
|
|||||
qtyreject | numeric | 0 | √ | null |
|
|
|||||
qtyscrap | numeric | 0 | √ | null |
|
|
|||||
scrap | numeric | 0 | √ | null |
|
|
|||||
validfrom | timestamp | 29,6 | √ | null |
|
|
|||||
validto | timestamp | 29,6 | √ | null |
|
|
|||||
assay | numeric | 0 | √ | null |
|
|
|||||
ad_user_id | numeric | 10 | √ | null |
|
|
|||||
qtybatchs | numeric | 0 | √ | null |
|
|
|||||
qtyrequiered | numeric | 0 | √ | null |
|
|
|||||
qtyreserved | numeric | 0 | √ | null |
|
|
|||||
qtyavailable | numeric | 0 | √ | null |
|
|
|||||
qtyonhand | numeric | 0 | √ | null |
|
|
|||||
qtybom | numeric | 0 | √ | null |
|
|
|||||
isqtypercentage | bpchar | 1 | √ | null |
|
|
|||||
qtybatch | numeric | 0 | √ | null |
|
|
|||||
qtybatchsize | numeric | 0 | √ | null |
|
|