View almasdd.COMPIERE.RV_ASSET_SUMMONTH

 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
A_ASSET_ID number 10
A_ASSET A_ASSET_ID Implied Constraint
A_ASSET_GROUP_ID number 10
A_ASSET_GROUP A_ASSET_GROUP_ID Implied Constraint
M_PRODUCT_ID number 10  √  null
M_PRODUCT M_PRODUCT_ID Implied Constraint
VALUE nvarchar2 80
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
HELP nvarchar2 4000  √  null
GUARANTEEDATE date 7  √  null
ASSETSERVICEDATE date 7  √  null
C_BPARTNER_ID number 10  √  null
C_BPARTNER C_BPARTNER_ID Implied Constraint
AD_USER_ID number 10  √  null
AD_USER AD_USER_ID Implied Constraint
SERNO nvarchar2 510  √  null
LOT nvarchar2 510  √  null
VERSIONNO nvarchar2 40  √  null
MOVEMENTDATE date 7  √  null
DELIVERYCOUNT number 22  √  null
View SQL:
SELECT a.AD_Client_ID, a.AD_Org_ID, a.IsActive, a.Created, a.CreatedBy, a.Updated, a.UpdatedBy,
  a.A_Asset_ID, a.A_Asset_Group_ID, a.M_Product_ID, 
  a.Value, a.Name, a.Description, a.Help,
  a.GuaranteeDate, a.AssetServiceDate,
  a.C_BPartner_ID, a.AD_User_ID, a.SerNo, a.Lot, a.VersionNo,
  firstOf(ad.MovementDate, 'MM') AS MovementDate,
  COUNT(*) AS DeliveryCount
FROM A_Asset a
 INNER JOIN A_Asset_Delivery ad ON (a.A_Asset_ID=ad.A_Asset_ID)
GROUP BY a.AD_Client_ID, a.AD_Org_ID, a.IsActive, a.Created, a.CreatedBy, a.Updated, a.UpdatedBy,
  a.A_Asset_ID, a.A_Asset_Group_ID, a.M_Product_ID, 
  a.Value, a.Name, a.Description, a.Help,
  a.GuaranteeDate, a.AssetServiceDate,
  a.C_BPartner_ID, a.AD_User_ID, a.SerNo, a.Lot, a.VersionNo,
  firstOf(ad.MovementDate, 'MM')


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.