View erp.COMPIERE.RV_COMMISSIONRUNDETAIL

 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
C_COMMISSIONRUN_ID number 10
C_COMMISSIONRUN C_COMMISSIONRUN_ID Implied Constraint
DOCUMENTNO nvarchar2 60
DESCRIPTION nvarchar2 510  √  null
STARTDATE date 7
GRANDTOTAL number 22
PROCESSED char 1
C_COMMISSION_ID number 10
C_COMMISSION C_COMMISSION_ID Implied Constraint
COMMISSION_BPARTNER_ID number 10
C_COMMISSIONAMT_ID number 10
C_COMMISSIONAMT C_COMMISSIONAMT_ID Implied Constraint
COMMISSIONCONVERTEDAMT number 22
COMMISSIONQTY number 22
COMMISSIONAMT number 22
C_COMMISSIONDETAIL_ID number 10
C_COMMISSIONDETAIL C_COMMISSIONDETAIL_ID Implied Constraint
REFERENCE nvarchar2 120  √  null
C_ORDERLINE_ID number 10  √  null
C_ORDERLINE C_ORDERLINE_ID Implied Constraint
C_INVOICELINE_ID number 10  √  null
C_INVOICELINE C_INVOICELINE_ID Implied Constraint
INFO nvarchar2 120  √  null
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
ACTUALAMT number 22
CONVERTEDAMT number 22
ACTUALQTY number 22
INVOICEDOCUMENTNO nvarchar2 60  √  null
DATEDOC date 7  √  null
M_PRODUCT_ID number 22  √  null
C_BPARTNER_ID number 22  √  null
C_BPARTNER_LOCATION_ID number 22  √  null
AD_USER_ID number 22  √  null
C_DOCTYPE_ID number 22  √  null
View SQL:
SELECT cr.AD_Client_ID, cr.AD_Org_ID, cr.IsActive, cr.Created,cr.CreatedBy, cr.Updated,cr.UpdatedBy,
    -- Run
    cr.C_CommissionRun_ID, cr.DocumentNo, cr.Description, 
    cr.StartDate, cr.GrandTotal, cr.Processed,
    -- Commission
    c.C_Commission_ID, c.C_BPartner_ID AS Commission_BPartner_ID,
    --  Commission Amount
    ca.C_CommissionAmt_ID, 
    ca.ConvertedAmt AS CommissionConvertedAmt, ca.ActualQty AS CommissionQty, 
    ca.CommissionAmt,
    --  Commission Detail
    cd.C_CommissionDetail_ID,
    cd.Reference,
    cd.C_OrderLine_ID,
    cd.C_InvoiceLine_ID,
    cd.Info,
    cd.C_Currency_ID, cd.ActualAmt, cd.ConvertedAmt,
    cd.ActualQty,
    -- Invoice/Order
    i.DocumentNo AS InvoiceDocumentNo,
    COALESCE (i.DateInvoiced, o.DateOrdered) AS DateDoc,
    COALESCE (il.M_Product_ID,ol.M_Product_ID) AS M_Product_ID,
    COALESCE (i.C_BPartner_ID,o.C_BPartner_ID) AS C_BPartner_ID,
    COALESCE (i.C_BPartner_Location_ID,o.C_BPartner_Location_ID) AS C_BPartner_Location_ID,
    COALESCE (i.AD_User_ID,o.AD_User_ID) AS AD_User_ID,
    COALESCE (i.C_DocType_ID,o.C_DocType_ID) AS C_DocType_ID
FROM C_CommissionRun cr
    INNER JOIN C_Commission c ON (cr.C_Commission_ID=c.C_Commission_ID)
    INNER JOIN C_CommissionAmt ca ON (cr.C_CommissionRun_ID=ca.C_CommissionRun_ID)
    INNER JOIN C_CommissionDetail cd ON (ca.C_CommissionAmt_ID=cd.C_CommissionAmt_ID)
    LEFT OUTER JOIN C_OrderLine ol ON (cd.C_OrderLine_ID=ol.C_OrderLine_ID)
    LEFT OUTER JOIN C_InvoiceLine il ON (cd.C_InvoiceLine_ID=il.C_InvoiceLine_ID)
    LEFT OUTER JOIN C_Order o ON (ol.C_Order_ID=o.C_Order_ID)
    LEFT OUTER JOIN C_Invoice i ON (il.C_Invoice_ID=i.C_Invoice_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.