View erp.COMPIERE.RV_C_RFQ_UNANSWERED

 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
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
HELP nvarchar2 4000  √  null
SALESREP_ID number 10
C_RFQ_TOPIC_ID number 10
C_RFQ_TOPIC C_RFQ_TOPIC_ID Implied Constraint
QUOTETYPE char 1
ISQUOTETOTALAMT char 1
ISQUOTEALLQTY char 1
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
DATERESPONSE date 7
ISRFQRESPONSEACCEPTED char 1
DATEWORKSTART date 7  √  null
DELIVERYDAYS number 10  √  null
DATEWORKCOMPLETE date 7  √  null
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
View SQL:
SELECT q.AD_Client_ID, q.AD_Org_ID, q.C_RfQ_ID, q.Name, q.Description, q.Help, q.SalesRep_ID,
    q.C_RfQ_Topic_ID, q.QuoteType, q.IsQuoteTotalAmt, q.IsQuoteAllQty, q.C_Currency_ID,
    q.DateResponse, q.IsRfQResponseAccepted, q.DateWorkStart, q.DeliveryDays, q.DateWorkComplete,
    r.C_BPartner_ID, r.C_BPartner_Location_ID, r.AD_User_ID
FROM C_RfQ q
    INNER JOIN C_RfQResponse r ON (q.C_RfQ_ID=r.C_RfQ_ID)
WHERE r.IsComplete='N'
    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.