View almasdd.COMPIERE.RV_C_RFQRESPONSE

 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
C_RFQ_ID number 10
C_RFQ C_RFQ_ID Implied Constraint
C_RFQ_TOPIC_ID number 10
C_RFQ_TOPIC C_RFQ_TOPIC_ID Implied Constraint
C_BPARTNER_ID number 10
C_BPARTNER C_BPARTNER_ID Implied Constraint
C_BPARTNER_LOCATION_ID number 10
C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID Implied Constraint
AD_USER_ID number 10  √  null
AD_USER AD_USER_ID Implied Constraint
C_RFQRESPONSE_ID number 10
C_RFQRESPONSE C_RFQRESPONSE_ID Implied Constraint
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
DATERESPONSE date 7  √  null
DATEWORKSTART date 7  √  null
DELIVERYDAYS number 10  √  null
DATEWORKCOMPLETE date 7  √  null
PRICE number 22
RANKING number 10  √  null
ISSELFSERVICE char 1
DESCRIPTION nvarchar2 510  √  null
HELP nvarchar2 4000  √  null
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
LINE number 10
LINEDATEWORKSTART date 7  √  null
LINEDELIVERYDAYS number 10  √  null
LINEDATEWORKCOMPLETE date 7  √  null
LINEDESCRIPTION nvarchar2 510  √  null
LINEHELP nvarchar2 4000  √  null
C_UOM_ID number 10
C_UOM C_UOM_ID Implied Constraint
QTY number 22
BENCHMARKPRICE number 22
BENCHMARKDIFFERENCE number 22  √  null
QTYPRICE number 22
DISCOUNT number 22  √  null
QTYRANKING number 10  √  null
View SQL:
SELECT q.AD_Client_ID, q.AD_Org_ID, q.C_RfQ_ID, q.C_RfQ_Topic_ID,
    r.C_BPartner_ID, r.C_BPartner_Location_ID, r.AD_User_ID,
    r.C_RfQResponse_ID,
    r.C_Currency_ID, r.DateResponse, r.DateWorkStart, r.DeliveryDays, r.DateWorkComplete,
    r.Price, r.Ranking, r.IsSelfService,
    r.Description, r.Help,
    --  Line
    ql.M_Product_ID, ql.M_AttributeSetInstance_ID, 
    ql.Line, rl.DateWorkStart AS LineDateWorkStart, rl.DeliveryDays AS LineDeliveryDays, rl.DateWorkComplete AS LineDateworkComplete,
    rl.Description AS LineDescription, rl.Help AS LineHelp,
    --  Qty
    qlq.C_UOM_ID, qlq.Qty, qlq.BenchmarkPrice, rlq.Price-qlq.BenchmarkPrice AS BenchmarkDifference,
    rlq.Price AS QtyPrice, rlq.Discount, rlq.Ranking AS QtyRanking
FROM C_RfQ q
    INNER JOIN C_RfQLine ql ON (q.C_RfQ_ID = ql.C_RfQ_ID)
    INNER JOIN C_RfQLineQty qlq ON (ql.C_RfQLine_ID = qlq.C_RfQLine_ID)
    INNER JOIN C_RfQResponse r ON (q.C_RfQ_ID = r.C_RfQ_ID)
    INNER JOIN C_RfQResponseLine rl ON 
        (r.C_RfQResponse_ID = rl.C_RfQResponse_ID AND ql.C_RfQLine_ID = rl.C_RfQLine_ID)
    INNER JOIN C_RfQResponseLineQty rlq ON 
        (rl.C_RfQResponseLine_ID = rlq.C_RfQResponseLine_ID AND qlq.C_RfQLineQty_ID = rlq.C_RfQLineQty_ID)
WHERE r.IsComplete='Y'
    AND q.Processed='N'


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.