View erp.COMPIERE.C_PROJECT_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_PROJECT_ID number 10
C_PROJECT C_PROJECT_ID Implied Constraint
VALUE nvarchar2 80
PROJECTNAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
NOTE nvarchar2 4000  √  null
ISSUMMARY char 1
PROJECTCATEGORY char 1  √  null
ORG_LOCATION_ID number 10  √  null
TAXID varchar2 20
C_PROJECTTYPE_ID number 10  √  null
C_PROJECTTYPE C_PROJECTTYPE_ID Implied Constraint
PROJECTTYPENAME nvarchar2 120  √  null
C_PHASE_ID number 10  √  null
C_PHASE C_PHASE_ID Implied Constraint
PROJECTPHASENAME nvarchar2 120  √  null
SALESREP_ID number 10  √  null
SALESREP_NAME nvarchar2 120  √  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
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
PAYMENTTERM nvarchar2 120  √  null
PAYMENTTERMNOTE nvarchar2 4000  √  null
POREFERENCE nvarchar2 40  √  null
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
M_PRICELIST_VERSION_ID number 10  √  null
M_PRICELIST_VERSION M_PRICELIST_VERSION_ID Implied Constraint
C_CAMPAIGN_ID number 10  √  null
C_CAMPAIGN C_CAMPAIGN_ID Implied Constraint
PLANNEDAMT number 22
PLANNEDQTY number 22
PLANNEDMARGINAMT number 22
INVOICEDAMT number 22
INVOICEDQTY number 22
PROJECTBALANCEAMT number 22
ISCOMMITMENT char 1
COMMITTEDAMT number 22
COMMITTEDQTY number 22
DATECONTRACT date 7  √  null
DATEFINISH date 7  √  null
ISCOMMITCEILING char 1
M_WAREHOUSE_ID number 10  √  null
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
View SQL:
SELECT p.AD_Client_ID, p.AD_Org_ID, p.IsActive, p.Created, p.CreatedBy, p.Updated, p.UpdatedBy, 
pt.AD_Language, p.C_Project_ID,
    p.Value, p.Name AS ProjectName, p.Description, p.Note, p.IsSummary, p.ProjectCategory,
    oi.C_Location_ID AS Org_Location_ID, oi.TaxID,
    p.C_ProjectType_ID, pjt.Name AS ProjectTypeName, p.C_Phase_ID, pjp.Name AS ProjectPhaseName,
p.SalesRep_ID, COALESCE(ubp.Name, u.Name) AS SalesRep_Name,
p.C_BPartner_ID, bp.Value AS BPValue, bp.TaxID AS BPTaxID, bp.NAICS, bp.DUNS,
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,
pt.Name AS PaymentTerm, pt.DocumentNote AS PaymentTermNote,
    p.POReference,
    p.C_Currency_ID, p.M_PriceList_Version_ID,
    p.C_Campaign_ID,
    p.PlannedAmt, p.PlannedQty, p.PlannedMarginAmt, p.InvoicedAmt, p.InvoicedQty, p.ProjectBalanceAmt,
    p.IsCommitment, p.CommittedAmt, p.CommittedQty, p.DateContract, p.DateFinish, p.IsCommitCeiling,
    p.M_Warehouse_ID
FROM C_Project p
LEFT OUTER JOIN C_BPartner bp ON (p.C_BPartner_ID=bp.C_BPartner_ID)
INNER JOIN AD_OrgInfo oi ON (p.AD_Org_ID=oi.AD_Org_ID)
LEFT OUTER JOIN C_PaymentTerm_Trl pt ON (p.C_PaymentTerm_ID=pt.C_PaymentTerm_ID)
    LEFT OUTER JOIN C_ProjectType pjt ON (p.C_ProjectType_ID=pjt.C_ProjectType_ID)
    LEFT OUTER JOIN C_Phase pjp ON (p.C_Phase_ID=pjp.C_Phase_ID)
LEFT OUTER JOIN AD_User u ON (p.SalesRep_ID=u.AD_User_ID)
LEFT OUTER JOIN C_BPartner ubp ON (u.C_BPartner_ID=ubp.C_BPartner_ID)
LEFT OUTER JOIN C_Greeting bpg on (bp.C_Greeting_ID=bpg.C_Greeting_ID)
LEFT OUTER JOIN AD_User bpc ON (p.AD_User_ID=bpc.AD_User_ID)
LEFT OUTER JOIN C_Greeting bpcg on (bpc.C_Greeting_ID=bpcg.C_Greeting_ID)
LEFT OUTER JOIN C_BPartner_Location bpl ON (p.C_BPartner_Location_ID=bpl.C_BPartner_Location_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.