View almasdd.COMPIERE.RV_TRANSACTION

 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
M_TRANSACTION_ID number 10
M_TRANSACTION M_TRANSACTION_ID Implied Constraint
AD_CLIENT_ID number 10
AD_CLIENTINFO AD_CLIENT_ID Implied Constraint
AD_ORG_ID number 10
AD_ORGINFO AD_ORG_ID Implied Constraint
MOVEMENTTYPE char 2
MOVEMENTDATE date 7
MOVEMENTQTY number 22
M_ATTRIBUTESETINSTANCE_ID number 10
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
M_PRODUCT_ID number 10
M_PRODUCT M_PRODUCT_ID Implied Constraint
VALUE nvarchar2 80
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
UPC varchar2 30  √  null
SKU varchar2 30  √  null
C_UOM_ID number 10
C_UOM C_UOM_ID Implied Constraint
M_PRODUCT_CATEGORY_ID number 10
M_PRODUCT_CATEGORY M_PRODUCT_CATEGORY_ID Implied Constraint
CLASSIFICATION char 1  √  null
WEIGHT number 22  √  null
VOLUME number 22  √  null
VERSIONNO nvarchar2 40  √  null
M_LOCATOR_ID number 10
M_LOCATOR M_LOCATOR_ID Implied Constraint
M_WAREHOUSE_ID number 10
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
X nvarchar2 120  √  null
Y nvarchar2 120  √  null
Z nvarchar2 120  √  null
M_INVENTORYLINE_ID number 10  √  null
M_INVENTORYLINE M_INVENTORYLINE_ID Implied Constraint
M_INVENTORY_ID number 10  √  null
M_INVENTORY M_INVENTORY_ID Implied Constraint
M_MOVEMENTLINE_ID number 10  √  null
M_MOVEMENTLINE M_MOVEMENTLINE_ID Implied Constraint
M_MOVEMENT_ID number 10  √  null
M_MOVEMENT M_MOVEMENT_ID Implied Constraint
M_INOUTLINE_ID number 10  √  null
M_INOUTLINE M_INOUTLINE_ID Implied Constraint
M_INOUT_ID number 10  √  null
M_INOUT M_INOUT_ID Implied Constraint
M_PRODUCTIONLINE_ID number 10  √  null
M_PRODUCTIONLINE M_PRODUCTIONLINE_ID Implied Constraint
M_PRODUCTIONPLAN_ID number 10  √  null
M_PRODUCTIONPLAN M_PRODUCTIONPLAN_ID Implied Constraint
M_PRODUCTION_ID number 10  √  null
M_PRODUCTION M_PRODUCTION_ID Implied Constraint
C_PROJECTISSUE_ID number 10  √  null
C_PROJECTISSUE C_PROJECTISSUE_ID Implied Constraint
C_PROJECT_ID number 10  √  null
C_PROJECT C_PROJECT_ID Implied Constraint
LINE number 22  √  null
View SQL:
SELECT t.M_Transaction_ID, t.AD_Client_ID,t.AD_Org_ID,
    t.MovementType,t.MovementDate,t.MovementQty,
    -- Instance
    t.M_AttributeSetInstance_ID, asi.M_AttributeSet_ID, asi.SerNo, asi.Lot, asi.M_Lot_ID,asi.GuaranteeDate,
    -- Product
    t.M_Product_ID,p.Value,p.Name,p.Description,p.UPC,p.SKU,
    p.C_UOM_ID,p.M_Product_Category_ID,p.Classification, p.Weight,p.Volume,p.VersionNo,
    -- Locator
    t.M_Locator_ID, l.M_Warehouse_ID, l.X, l.Y, l.Z,
    -- Inventory
    t.M_InventoryLine_ID,il.M_Inventory_ID,
    -- Movement
    t.M_MovementLine_ID,ml.M_Movement_ID,
    -- In/Out
    t.M_InOutLine_ID,iol.M_InOut_ID,
    -- Production
    t.M_ProductionLine_ID,prdl.M_ProductionPlan_ID,prdp.M_Production_ID,
    -- ProjectIssue
    t.C_ProjectIssue_ID,pjl.C_Project_ID,
    COALESCE(il.Line,ml.Line,iol.Line,prdl.Line,pjl.Line) AS Line
FROM M_Transaction t
  INNER JOIN M_Locator l ON (t.M_Locator_ID=l.M_Locator_ID)
  INNER JOIN M_Product p ON (t.M_Product_ID=p.M_Product_ID)
  LEFT OUTER JOIN M_AttributeSetInstance asi ON (t.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID)
  LEFT OUTER JOIN M_InventoryLine il ON (t.M_InventoryLine_ID=il.M_InventoryLine_ID)
  LEFT OUTER JOIN M_MovementLine ml ON (t.M_MovementLine_ID=ml.M_MovementLine_ID)
  LEFT OUTER JOIN M_InOutLine iol ON (t.M_InOutLine_ID=iol.M_InOutLine_ID)
  LEFT OUTER JOIN M_ProductionLine prdl ON (t.M_ProductionLine_ID=prdl.M_ProductionLine_ID)
    LEFT OUTER JOIN M_ProductionPlan prdp ON (prdl.M_ProductionPlan_ID=prdp.M_ProductionPlan_ID)
  LEFT OUTER JOIN C_ProjectIssue pjl ON (t.C_ProjectIssue_ID=pjl.C_ProjectIssue_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.