m_inout_lineconfirm_v

0 rows


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 2147483647 √ null
m_inoutlineconfirm_id numeric 10 √ null
m_inoutlineconfirm.m_inoutlineconfirm_id Implied Constraint R
m_inoutconfirm_id numeric 10 √ null
m_inoutconfirm.m_inoutconfirm_id Implied Constraint R
targetqty numeric 0 √ null
confirmedqty numeric 0 √ null
differenceqty numeric 0 √ null
scrappedqty numeric 0 √ null
description varchar 255 √ null
processed bpchar 1 √ null
m_inout_id numeric 10 √ null
m_inout.m_inout_id Implied Constraint R
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id Implied Constraint R
line numeric 10 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
movementqty numeric 0 √ null
uomsymbol varchar 10 √ null
qtybackordered numeric 0 √ null
name varchar 255 √ null
shipdescription varchar 2147483647 √ null
documentnote varchar 2000 √ null
upc varchar 30 √ null
sku varchar 30 √ null
productvalue varchar 510 √ null
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
x varchar 60 √ null
y varchar 60 √ null
z varchar 60 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
m_attributeset_id numeric 10 √ null
m_attributeset.m_attributeset_id Implied Constraint R
serno varchar 40 √ null
lot varchar 40 √ null
m_lot_id numeric 10 √ null
m_lot.m_lot_id Implied Constraint R
guaranteedate timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views