View almasdd.COMPIERE.C_RFQRESPONSELINE_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
C_RFQRESPONSE_ID number 10
C_RFQRESPONSE C_RFQRESPONSE_ID Implied Constraint
C_RFQRESPONSELINE_ID number 10
C_RFQRESPONSELINE C_RFQRESPONSELINE_ID Implied Constraint
C_RFQLINE_ID number 10
C_RFQLINE C_RFQLINE_ID Implied Constraint
C_RFQRESPONSELINEQTY_ID number 10
C_RFQRESPONSELINEQTY C_RFQRESPONSELINEQTY_ID Implied Constraint
C_RFQLINEQTY_ID number 10
C_RFQLINEQTY C_RFQLINEQTY_ID Implied Constraint
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
AD_LANGUAGE AD_LANGUAGE Implied Constraint
LINE number 10
M_PRODUCT_ID number 10  √  null
M_PRODUCT M_PRODUCT_ID Implied Constraint
M_ATTRIBUTESETINSTANCE_ID number 10  √  null
M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID Implied Constraint
NAME nvarchar2 4000  √  null
DESCRIPTION nvarchar2 510  √  null
DOCUMENTNOTE nvarchar2 4000  √  null
UPC varchar2 30  √  null
SKU varchar2 30  √  null
PRODUCTVALUE nvarchar2 80  √  null
HELP nvarchar2 4000  √  null
DATEWORKSTART date 7  √  null
DELIVERYDAYS number 10  √  null
C_UOM_ID number 10
C_UOM C_UOM_ID Implied Constraint
UOMSYMBOL nvarchar2 20  √  null
QTY number 22
PRICE number 22
DISCOUNT number 22  √  null
View SQL:
SELECT rrl.C_RfQResponse_ID, rrl.C_RfQResponseLine_ID, rrl.C_RfQLine_ID, 
    rq.C_RfQResponseLineQty_ID, rq.C_RfQLineQty_ID,
    rrl.AD_Client_ID, rrl.AD_Org_ID, rrl.IsActive, rrl.Created, rrl.CreatedBy, rrl.Updated, rrl.UpdatedBy,
l.AD_Language,
    rl.Line,
    rl.M_Product_ID, rl.M_AttributeSetInstance_ID,
COALESCE(p.Name||productAttribute(rl.M_AttributeSetInstance_ID), rl.Description) AS Name, -- main line
CASE WHEN p.Name IS NOT NULL THEN rl.Description END AS Description, -- second line
p.DocumentNote, -- third line
    p.UPC, p.SKU, p.Value AS ProductValue,
    rl.Help,
    rl.DateWorkStart, rl.DeliveryDays,
    q.C_UOM_ID, uom.UOMSymbol,
    q.Qty, rq.Price, rq.Discount
FROM C_RfQResponseLineQty rq
  INNER JOIN C_RfQLineQty q ON (rq.C_RfQLineQty_ID=q.C_RfQLineQty_ID)
  INNER JOIN C_UOM uom ON (q.C_UOM_ID=uom.C_UOM_ID)
  INNER JOIN C_RfQResponseLine rrl ON (rq.C_RfQResponseLine_ID=rrl.C_RfQResponseLine_ID)
  INNER JOIN C_RfQLine rl ON (rrl.C_RfQLine_ID=rl.C_RfQLine_ID)
  LEFT OUTER JOIN M_Product p ON (rl.M_Product_ID=p.M_Product_ID)
  INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
WHERE rq.IsActive='Y' AND q.IsActive='Y'
  AND rrl.IsActive='Y' AND rl.IsActive='Y'


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.