View erp.COMPIERE.C_DUNNING_LINE_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
C_DUNNINGRUNLINE_ID number 10
C_DUNNINGRUNLINE C_DUNNINGRUNLINE_ID Implied Constraint
C_DUNNINGRUNENTRY_ID number 10
C_DUNNINGRUNENTRY C_DUNNINGRUNENTRY_ID Implied Constraint
AMT number 22
CONVERTEDAMT number 22
DAYSDUE number 10
TIMESDUNNED number 10
INTERESTAMT number 22
FEEAMT number 22
TOTALAMT number 22
C_INVOICE_ID number 10  √  null
C_INVOICE C_INVOICE_ID Implied Constraint
ISSOTRX char 1  √  null
DOCUMENTNO nvarchar2 60  √  null
DOCSTATUS char 2  √  null
DATETRX date 7  √  null
C_DOCTYPE_ID number 22  √  null
DOCUMENTTYPE nvarchar2 120  √  null
DESCRIPTION nvarchar2 510  √  null
C_CURRENCY_ID number 22  √  null
C_CAMPAIGN_ID number 22  √  null
C_PROJECT_ID number 22  √  null
C_ACTIVITY_ID number 22  √  null
USER1_ID number 22  √  null
USER2_ID number 22  √  null
DATEACCT date 7  √  null
C_CONVERSIONTYPE_ID number 22  √  null
AD_ORGTRX_ID number 22  √  null
POREFERENCE nvarchar2 40  √  null
DATEORDERED date 7  √  null
DATEINVOICED date 7  √  null
ISINDISPUTE char 1  √  null
PAYMENTTERM nvarchar2 120  √  null
C_CHARGE_ID number 10  √  null
C_CHARGE C_CHARGE_ID Implied Constraint
CHARGEAMT number 22  √  null
TOTALLINES number 22  √  null
GRANDTOTAL number 22  √  null
AMTINWORDS number 22  √  null
M_PRICELIST_ID number 10  √  null
M_PRICELIST M_PRICELIST_ID Implied Constraint
ISPAID char 1  √  null
ISALLOCATED char 1  √  null
TENDERTYPE char 1  √  null
DISCOUNTAMT number 22  √  null
View SQL:
SELECT drl.AD_Client_ID, drl.AD_Org_ID, drl.IsActive, drl.Created, drl.CreatedBy, drl.Updated, drl.UpdatedBy, 
COALESCE(dt.AD_Language,dtp.AD_Language) AS AD_Language,
    drl.C_DunningRunLine_ID, drl.C_DunningRunEntry_ID,
    drl.Amt, drl.ConvertedAmt, drl.DaysDue, drl.TimesDunned, 
    drl.InterestAmt, drl.FeeAmt, drl.TotalAmt,
drl.C_Invoice_ID, 
    COALESCE(i.IsSOTrx,p.IsReceipt) AS IsSOTrx,
    COALESCE(i.DocumentNo,p.DocumentNo) AS DocumentNo,
    COALESCE(i.DocStatus,p.DocStatus) AS DocStatus, 
COALESCE(i.DateInvoiced, p.DateTrx) AS DateTrx,
    COALESCE(i.C_DocType_ID,p.C_DocType_ID) AS C_DocType_ID,
    COALESCE(dt.PrintName,dtp.PrintName) AS DocumentType, 
    COALESCE(i.Description,p.Description) AS Description, 
COALESCE(i.C_Currency_ID,p.C_Currency_ID) AS C_Currency_ID, 
    COALESCE(i.C_Campaign_ID,p.C_Campaign_ID) AS C_Campaign_ID, 
    COALESCE(i.C_Project_ID,p.C_Project_ID) AS C_Project_ID,
    COALESCE(i.C_Activity_ID,p.C_Activity_ID) AS C_Activity_ID,
    COALESCE(i.User1_ID,p.User1_ID) AS User1_ID,
    COALESCE(i.User2_ID,p.User2_ID) AS User2_ID,
    COALESCE(i.DateAcct,p.DateAcct) AS DateAcct,
    COALESCE(i.C_ConversionType_ID,i.C_ConversionType_ID) AS C_ConversionType_ID,
    COALESCE(i.AD_OrgTrx_ID,p.AD_OrgTrx_ID) AS AD_OrgTrx_ID,
    i.POReference, i.DateOrdered,
i.DateInvoiced, i.IsInDispute,
pt.Name AS PaymentTerm,
    i.C_Charge_ID, i.ChargeAmt,
i.TotalLines, i.GrandTotal, i.GrandTotal AS AmtInWords,
i.M_PriceList_ID, i.IsPaid,
    p.IsAllocated, p.TenderType, p.DiscountAmt
FROM C_DunningRunLine drl
    LEFT OUTER JOIN C_Invoice i ON (drl.C_Invoice_ID=i.C_Invoice_ID)
LEFT OUTER JOIN C_DocType_Trl dt ON (i.C_DocType_ID=dt.C_DocType_ID)
LEFT OUTER JOIN C_PaymentTerm_Trl pt ON (i.C_PaymentTerm_ID=pt.C_PaymentTerm_ID
        AND pt.AD_Language=dt.AD_Language)
    LEFT OUTER JOIN C_Payment p ON (drl.C_Payment_ID=p.C_Payment_ID)
LEFT OUTER JOIN C_DocType_Trl dtp ON (p.C_DocType_ID=dtp.C_DocType_ID) 
WHERE COALESCE(dt.AD_Language,dtp.AD_Language)=COALESCE(dtp.AD_Language,dt.AD_Language)


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.