View erp.COMPIERE.M_MOVEMENTLINEMA_V

 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  √  null
AD_CLIENTINFO AD_CLIENT_ID Implied Constraint
AD_ORG_ID number 10  √  null
AD_ORGINFO AD_ORG_ID Implied Constraint
ISACTIVE char 1  √  null
CREATED date 7  √  null
CREATEDBY number 10  √  null
UPDATED date 7  √  null
UPDATEDBY number 10  √  null
M_MOVEMENT_ID number 10  √  null
M_MOVEMENT M_MOVEMENT_ID Implied Constraint
M_MOVEMENTLINE_ID number 10  √  null
M_MOVEMENTLINE M_MOVEMENTLINE_ID Implied Constraint
LINE number 10  √  null
M_PRODUCT_ID number 10  √  null
M_PRODUCT M_PRODUCT_ID Implied Constraint
M_ATTRIBUTESETINSTANCE_ID number 10  √  null
M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID Implied Constraint
MOVEMENTQTY number 22  √  null
M_LOCATOR_ID number 10  √  null
M_LOCATOR M_LOCATOR_ID Implied Constraint
M_LOCATORTO_ID number 10  √  null
View SQL:
SELECT m.AD_Client_ID, m.AD_Org_ID, m.IsActive, m.Created, m.CreatedBy, m.Updated, m.UpdatedBy,
    l.M_Movement_ID, m.M_MovementLine_ID, l.Line, l.M_Product_ID, 
    m.M_AttributeSetInstance_ID, m.MovementQty, l.M_Locator_ID, l.M_LocatorTo_ID
FROM M_MovementLineMA m INNER JOIN M_MovementLine l ON (m.M_MovementLine_ID=l.M_MovementLine_ID)
UNION
SELECT AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy,
    M_Movement_ID, M_MovementLine_ID, Line, M_Product_ID, 
    M_AttributeSetInstance_ID, MovementQty, M_Locator_ID, M_LocatorTo_ID
FROM M_MovementLine
 


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.