View almasdd.COMPIERE.AD_ORG_V

 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
VALUE nvarchar2 80
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
ISSUMMARY char 1
C_LOCATION_ID number 10  √  null
C_LOCATION C_LOCATION_ID Implied Constraint
DUNS char 11
TAXID varchar2 20
SUPERVISOR_ID number 10  √  null
PARENT_ORG_ID number 10  √  null
AD_ORGTYPE_ID number 10  √  null
AD_ORGTYPE AD_ORGTYPE_ID Implied Constraint
M_WAREHOUSE_ID number 10  √  null
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
C_BPARTNER_ID number 10  √  null
C_BPARTNER C_BPARTNER_ID Implied Constraint
View SQL:
SELECT o.AD_Client_ID, o.AD_Org_ID, 
    o.IsActive, o.Created, o.CreatedBy, o.Updated, o.UpdatedBy,
    o.Value, o.Name, o.Description, o.IsSummary,
    i.C_Location_ID, i.DUNS, i.TaxID,
    i.Supervisor_ID, i.Parent_Org_ID, 
    i.AD_OrgType_ID, i.M_Warehouse_ID,
    bp.C_BPartner_ID
FROM AD_Org o
    INNER JOIN AD_OrgInfo i ON (o.AD_Org_ID=i.AD_Org_ID)
    LEFT OUTER JOIN C_BPartner bp ON (o.AD_Org_ID=bp.AD_OrgBP_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.