View erp.COMPIERE.M_INOUT_LINECONFIRM_VT

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
AD_CLIENT_ID number 10
AD_CLIENTINFO AD_CLIENT_ID Implied Constraint
AD_ORG_ID number 10
AD_ORGINFO AD_ORG_ID Implied Constraint
ISACTIVE char 1
CREATED date 7
CREATEDBY number 10
UPDATED date 7
UPDATEDBY number 10
AD_LANGUAGE varchar2 6  √  null
AD_LANGUAGE AD_LANGUAGE Implied Constraint
M_INOUTLINECONFIRM_ID number 10
M_INOUTLINECONFIRM M_INOUTLINECONFIRM_ID Implied Constraint
M_INOUTCONFIRM_ID number 10
M_INOUTCONFIRM M_INOUTCONFIRM_ID Implied Constraint
TARGETQTY number 22
CONFIRMEDQTY number 22
DIFFERENCEQTY number 22  √  null
SCRAPPEDQTY number 22  √  null
DESCRIPTION nvarchar2 510  √  null
PROCESSED char 1
M_INOUT_ID number 10  √  null
M_INOUT M_INOUT_ID Implied Constraint
M_INOUTLINE_ID number 10  √  null
M_INOUTLINE M_INOUTLINE_ID Implied Constraint
LINE number 10  √  null
MOVEMENTQTY number 22  √  null
UOMSYMBOL nvarchar2 20  √  null
QTYBACKORDERED number 22  √  null
NAME nvarchar2 510  √  null
SHIPDESCRIPTION nvarchar2 510  √  null
DOCUMENTNOTE nvarchar2 4000  √  null
UPC varchar2 30  √  null
SKU varchar2 30  √  null
PRODUCTVALUE nvarchar2 80  √  null
M_LOCATOR_ID number 10  √  null
M_LOCATOR M_LOCATOR_ID Implied Constraint
M_WAREHOUSE_ID number 10  √  null
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
X nvarchar2 120  √  null
Y nvarchar2 120  √  null
Z nvarchar2 120  √  null
M_ATTRIBUTESETINSTANCE_ID number 10  √  null
M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID Implied Constraint
M_ATTRIBUTESET_ID number 10  √  null
M_ATTRIBUTESET M_ATTRIBUTESET_ID Implied Constraint
SERNO nvarchar2 80  √  null
LOT nvarchar2 80  √  null
M_LOT_ID number 10  √  null
M_LOT M_LOT_ID Implied Constraint
GUARANTEEDATE date 7  √  null
View SQL:
SELECT iolc.AD_Client_ID, iolc.AD_Org_ID, iolc.IsActive, iolc.Created, iolc.CreatedBy, iolc.Updated, iolc.UpdatedBy,
uom.AD_Language,
    iolc.M_InOutLineConfirm_ID, iolc.M_InOutConfirm_ID,
    iolc.TargetQty, iolc.ConfirmedQty, iolc.DifferenceQty, iolc.ScrappedQty,
    iolc.Description, iolc.Processed,
iol.M_InOut_ID, iol.M_InOutLine_ID, 
iol.Line, 
iol.MovementQty, uom.UOMSymbol, ol.QtyOrdered-ol.QtyDelivered AS QtyBackOrdered,
COALESCE(COALESCE(pt.Name,p.Name), iol.Description) AS Name, -- main line
CASE WHEN COALESCE(pt.Name,p.Name) IS NOT NULL THEN iol.Description END AS ShipDescription, -- second line
COALESCE(pt.DocumentNote, p.DocumentNote) AS DocumentNote, -- third line
    p.UPC, p.SKU, p.Value AS ProductValue,
iol.M_Locator_ID, l.M_Warehouse_ID, l.X, l.Y, l.Z,
    iol.M_AttributeSetInstance_ID, asi.M_AttributeSet_ID, asi.SerNo, asi.Lot, asi.M_Lot_ID,asi.GuaranteeDate
FROM M_InOutLineConfirm iolc
    INNER JOIN M_InOutLine iol ON (iolc.M_InOutLine_ID=iol.M_InOutLine_ID)
INNER JOIN C_UOM_Trl uom ON (iol.C_UOM_ID=uom.C_UOM_ID)
LEFT OUTER JOIN M_Product p ON (iol.M_Product_ID=p.M_Product_ID)
LEFT OUTER JOIN M_Product_Trl pt ON (iol.M_Product_ID=pt.M_Product_ID AND uom.AD_Language=pt.AD_Language)
    LEFT OUTER JOIN M_AttributeSetInstance asi ON (iol.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID)
    LEFT OUTER JOIN M_Locator l ON (iol.M_Locator_ID=l.M_Locator_ID)
    LEFT OUTER JOIN C_OrderLine ol ON (iol.C_OrderLine_ID=ol.C_OrderLine_ID)


SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.