View erp.COMPIERE.C_DUNNING_HEADER_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_DUNNINGRUN_ID number 10
C_DUNNINGRUN C_DUNNINGRUN_ID Implied Constraint
C_DUNNINGRUNENTRY_ID number 10  √  null
C_DUNNINGRUNENTRY C_DUNNINGRUNENTRY_ID Implied Constraint
DUNNINGDATE date 7
PRINTNAME nvarchar2 120  √  null
DOCUMENTNOTE nvarchar2 4000  √  null
C_BPARTNER_ID number 10  √  null
C_BPARTNER C_BPARTNER_ID Implied Constraint
BPVALUE nvarchar2 80  √  null
BPTAXID varchar2 20  √  null
NAICS char 6  √  null
DUNS char 11  √  null
ORG_LOCATION_ID number 10  √  null
TAXID varchar2 20
SALESREP_ID number 10  √  null
SALESREP_NAME nvarchar2 120  √  null
BPGREETING nvarchar2 120  √  null
NAME nvarchar2 120  √  null
NAME2 nvarchar2 120  √  null
BPCONTACTGREETING nvarchar2 120  √  null
TITLE nvarchar2 80  √  null
PHONE nvarchar2 80  √  null
CONTACTNAME nvarchar2 120  √  null
C_LOCATION_ID number 10  √  null
C_LOCATION C_LOCATION_ID Implied Constraint
REFERENCENO nvarchar2 80  √  null
AMT number 22  √  null
QTY number 22  √  null
NOTE nvarchar2 4000  √  null
View SQL:
SELECT dr.AD_Client_ID, dr.AD_Org_ID, dr.IsActive, dr.Created, dr.CreatedBy, dr.Updated, dr.UpdatedBy, 
dlt.AD_Language, dr.C_DunningRun_ID, C_DunningRunEntry_ID,
    dr.DunningDate, dlt.PrintName, dlt.Note AS DocumentNote,
    dre.C_BPartner_ID, bp.Value AS BPValue, bp.TaxID AS BPTaxID, bp.NAICS, bp.DUNS,
oi.C_Location_ID AS Org_Location_ID, oi.TaxID,
dre.SalesRep_ID, COALESCE(ubp.Name, u.Name) AS SalesRep_Name,
bpg.Greeting AS BPGreeting,
bp.Name, bp.Name2,
bpcg.Greeting AS BPContactGreeting,
bpc.Title, bpc.Phone,
NULLIF (bpc.Name, bp.Name) AS ContactName,
bpl.C_Location_ID, bp.ReferenceNo,
    dre.Amt, dre.Qty, dre.Note
FROM C_DunningRun dr
    INNER JOIN C_DunningLevel dl ON (dr.C_DunningLevel_ID=dl.C_DunningLevel_ID)
    INNER JOIN C_DunningLevel_Trl dlt ON (dl.C_DunningLevel_ID=dlt.C_DunningLevel_ID)
    INNER JOIN C_DunningRunEntry dre ON (dr.C_DunningRun_ID=dre.C_DunningRun_ID)
INNER JOIN C_BPartner bp ON (dre.C_BPartner_ID=bp.C_BPartner_ID)
LEFT OUTER JOIN C_Greeting_Trl bpg on (bp.C_Greeting_ID=bpg.C_Greeting_ID
        AND dlt.AD_Language=bpg.AD_Language)
INNER JOIN C_BPartner_Location bpl ON (dre.C_BPartner_Location_ID=bpl.C_BPartner_Location_ID)
LEFT OUTER JOIN AD_User bpc ON (dre.AD_User_ID=bpc.AD_User_ID)
LEFT OUTER JOIN C_Greeting_Trl bpcg on (bpc.C_Greeting_ID=bpcg.C_Greeting_ID
        AND dlt.AD_Language=bpcg.AD_Language)
INNER JOIN AD_OrgInfo oi ON (dr.AD_Org_ID=oi.AD_Org_ID)
LEFT OUTER JOIN AD_User u ON (dre.SalesRep_ID=u.AD_User_ID)
LEFT OUTER JOIN C_BPartner ubp ON (u.C_BPartner_ID=ubp.C_BPartner_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.